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

[Paula_Stankus]

Title: Message

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