Oracle 9i clone
Hi
I'm trying to clone my production db ona Sun box, NOT using RMAN.
No problems with creating controlfile and dbf copies etc.
I edit the controlfile create script and try to bring up the 'new' database and have a load of errors trying to recover the logfiles, even though startup without recovery.
Would I be right in thinking that the UNDO tablespace is meesing me up, so if I were to :
- create a rollback segment in the production database prior to shutdown and dbf copy
- edit controfile script to show UNDO_MANAGEMENT=MANUAL and ROLLBACK_SEGMENTS='rbs1'
- copy files
- bring up 'new' db with RESETLOGS
it may work?
Thanks.
Software/Hardware used:
Software/Hardware used:
ASKED:
November 17, 2005 10:48 AM
UPDATED:
November 20, 2005 4:36 PM
Answer Wiki:
We shut down the database, copy dbf, ctl and log files (i.e. a complete cold backup), and generate a backup control file from the database (alter database command), and copy all the archived logs generated since the cold backup was taken. We use the "recover database using the backup control file" command and then open with a resetlogs. The procedure only fails if we bring up the database before initiating a recovery, permitting UNDO to be generated. Regards.
To see all answers submitted to the Answer Wiki: View Answer History.
Need some more answers before we can answer properly.
1/. Are you trying to clone from one box to another?
2/. What type of copies do you have – online/offline? simply copying with the database unaware won’t do.
3/. Can we have a sample error, as logfile and UNDO/REDO are not the same thing.
Basically, if your starting with offline/cold backups you should be able to restart the db on a new box – so your not backing up or restoring everything. If your starting with online/hot backups then you will need to recover, which will bring all the datafiles to a consistent point, and then a resetlogs to rollback any open transactions.