open clone database but rollbacks are wrong

[nlefel]

Hello Ora-Gurus !

On a semi regualr basis I copy PROD to TEST for our databases. The work involved ranges from 2 hours to read the tapes to 15 hours for some of the biggies.

Using the "standard" method outlined elswhere in this forum
I create controlfile to trace on PROD and then create a
new controlfile on the TEST.

So far so good.

It has happened in the past (and I'm sure, sadly, it will happen again) that the initTEST.ora has a different number of rollback segments defined as the PROD database. Normally this is noticed before the ALTER DATABASE OPEN RESETLOGS
gets its way.

Now my question: IF the number of rollbacks in initTEST.ora is not compatible with the datafiles the OPEN RESET fails. At present I make a complete restore should this happen.

Is there a way out of this "dead end" ?

Points for me:
My checklist should be more thorough - for instance
1) "before OPEN RESETLOGS... remove rollback parameter from initTEST.ora.
2) ensure TEST rollbacks come up offline - see 1) !!

I have heard of a way to edit the traced controlfile script,
deleting the rollback file entries and setting initTEST.ora parameters to set any (false) rollbacks offline. Then try to drop them. Tried without success -

Do you know better ??

Thanx in advance

[marist89]

Use public rollback segments instead. That way, you don't have to have a rollback_segments= parameter in your init.ora.