I posted a document a couple weeks ago that may be of help. It includes netbackup stuff, but you can ignore that.
Jared www.tinyurl.com/hu4r or http://www.cybcon.com/~jkstill/Alternate%20Client%20Restore%20With%20Veritas%20NetBackup%20and%20Oracle%20RMAN.doc [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/04/2003 02:09 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: URGENT: Trying to duplicate database from cold backup - auxi This is the type of script I am using: rman <<EOF connect target rman/[EMAIL PROTECTED] connect catalog rman/[EMAIL PROTECTED] connect auxiliary sys/[EMAIL PROTECTED] run { resync catalog; allocate auxiliary channel d1 type disk; allocate auxiliary channel d2 type disk; set newname for datafile '/data/oracle8/TEST2/systemTEST2.dbf' TO '/data/oracle8/TEST3/systemTEST3.dbf'; set newname for datafile '/data/oracle8/TEST2/rbsTEST2.dbf' TO '/data/oracle8/TEST3/rbsTEST3.dbf'; set newname for datafile '/data/oracle8/TEST2/tempTEST2.dbf' TO '/data/oracle8/TEST3/tempTEST3.dbf'; set newname for datafile '/data/oracle8/TEST2/dataTEST2.dbf' TO '/data/oracle8/TEST3/dataTEST3.dbf'; sql 'alter system switch logfile'; duplicate target database to test3 LOGFILE '/data/oracle8/TEST3/redoTEST301.log' size 1M, '/data/oracle8/TEST3/redoTEST302.log' size 1M, '/data/oracle8/TEST3/redoTEST303.log' size 1M; } EOF -----Original Message----- Sent: Monday, August 04, 2003 4:12 PM To: '[EMAIL PROTECTED]' database not mounted error!!! Guys, When trying to duplicate database with this script I have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to create new logfiles. Get error: RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounte d -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
