Restoring a database to new host question
658523Oct 5 2010 — edited Oct 5 2010Hello,
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