Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: URGENT: Trying to duplicate database from cold backup - auxi
No doubt about it, the old way is much easier.
I've had to do it often enough that I wrote some PL/SQL, SQL and Perl to more or less automate the generation of the scripts needed to mount and unmount shares, copy files, generate the controlfile script and open up the database.
Doing this with RMAN is prohibitively difficult.
My reason for doing so was to get the experience needed to restore an entire database to a new server should the old one fail, as it is the same process.
Jared
Freeman Robert - IL <FREEMANR_at_tusc.com>
Sent by: ml-errors_at_fatcity.com
08/05/2003 02:44 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: Subject: RE: URGENT: Trying to duplicate database from cold backup - auxi
>> BTW, I just waited till afterhours brought the database down, copied
>> the file and cloned the easy way.
I love RMAN, but truth be told, I still find the old manual method of cloning a database to be easier somehow. Must be an old fogie.
RF
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: FREEMANR_at_tusc.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Jared.Still_at_radisys.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Aug 05 2003 - 17:14:23 CDT
![]() |
![]() |