Rman Backups When The Directory Structures Are Different

guocun09發表於2012-04-19

10) Now restore the datafiles to new locations and recover. Since we are recovering the database here till the archivelog sequence 50 the sequence number in the SET UNTIL SEQUENCE clause should be  50 (+1)

RMAN> run
 {
 set until sequence 51;
 set newname for datafile 1 to '/node2/database/prod/sys01.dbf';
 set newname for datafile 2 to '/node2/database/prod/undotbs01.dbf';
 set newname for datafile 3 to '/node2/database/prod/sysaux01.dbf';
 set newname for datafile 4 to '/node2/database/prod/users01.dbf';
 set newname for datafile 5 to '/node2/database/prod/1.dbf';
 set newname for datafile 6 to '/node2/database/prod/sysaux02.dbf';
 set newname for datafile 7 to '/node2/database/prod/undotbs02.dbf';
 restore database;
 switch datafile all;
 recover database;
 alter database open resetlogs;
 }

 

If we are restoring the Rman backups  from tapes,then we should ensure the same media manager variables that were used during backups are maintained during restore too.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25583515/viewspace-721708/,如需轉載,請註明出處,否則將追究法律責任。

相關文章