Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Restoring a database to new host question

658523Oct 5 2010 — edited Oct 5 2010
Hello,

I want to Perform recovery of target database to a new host with standard procedure as decribed in docs. I have a doubt
so please guide me clear.

Its fine that backup are accessible, spfile and control files are restored, but for the given script

RUN
{
SET NEWNAME FOR DATAFILE 1 TO 'u02/oradata/test/system01.dbf';
SET NEWNAME FOR DATAFILE 2 TO 'u02/oradata/test/undotbs01.dbf';
SET NEWNAME FOR DATAFILE 3 TO 'u02/oradata/test/sysaux.dbf';
SET NEWNAME FOR DATAFILE 4 TO 'u02/oradata/test/users01.dbf';
SET NEWNAME FOR DATAFILE 5 TO 'u02/oradata/test/example01.dbf';
SQL "ALTER DATABASE RENAME FILE ''/u01/app/oracle/oradata/orcl/redo01.log''
TO ''u02/oradata/test/redo01.log'' ";
SQL "ALTER DATABASE RENAME FILE ''/u01/app/oracle/oradata/orcl/redo02.log''
TO ''u02/oradata/test/redo02.log'' ";
SQL "ALTER DATABASE RENAME FILE ''/u01/app/oracle/oradata/orcl/redo03.log''
TO ''u02/oradata/test/redo03.log'' ";
SET UNTIL SCN 4545727;
RESTORE DATABASE;
SWITCH DATAFILE ALL;
RECOVER DATABASE;
}

data files are taken from backup, but where does the redolog files come from. Would RMAN automatically create them( as in
DUPLICATE database command) so we have to manually create them.

Looking for reply.

Regards,

Abbasi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2010
Added on Oct 5 2010
4 comments
294 views