RE: URGENT: Trying to duplicate database from cold backup - auxi

[Paula_Stankus]

Title: Message

Thanks for the confirmation - I really believe that was it as well!!  - please see my earlier e-mail. 

-----Original Message-----
From: Jack van Zanen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 5:24 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT: Trying to duplicate database from cold backup - auxi

Hi Paula

 

Another issue you may encounter is that duplicate in 8.1.7 may not work w/o a "set until" clause see bug 2329702

 

 

Jack

 

 -----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 11:09 PM
To: Multiple recipients of list ORACLE-L
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-----
From: Stankus, Paula G
Sent: Monday, August 04, 2003 4:12 PM
To: '[EMAIL PROTECTED]'
Subject: RE: URGENT: Trying to duplicate database from cold backup - auxiliary 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