Oracle 9i clone

Tags:
Oracle
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.
ASKED: November 17, 2005  10:48 AM
UPDATED: November 20, 2005  4:36 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Richardburak
    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.
    0 pointsBadges:
    report
  • Latemorningperson
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/oracle-9i-clone/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following