Rman Backups When The Directory Structures Are Different
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Restore Rman Backups On A Different Node When The Directory Are Diff_419137.1REST
- RMAN Fast Incremental BackupsASTREM
- Monitoring RMAN Backups
- Under the same directory(folder) copy or rename with the different extension name
- Making Whole Database Backups with RMANDatabase
- Ext2fs Undeletion of Directory Structures mini-HOWTOStruct
- HowTo Restore RMAN Disk backups of RACREST
- Using RMAN Incremental Backups to Refresh a Standby DatabaseREMDatabase
- Using RMAN Incremental Backups to Roll Forward a Physical Standby DatabaseREMForwardDatabase
- Using RMAN REPORT NEED BACKUP with Different Retention Policies
- zt:Different type of RMAN backup compression in 11G
- NBU report error 6 when RMAN backupError
- HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another NoRESTDatabase
- RMAN跨平臺傳輸表空間(different Endian)
- Can you create a second voting disk in a different ASM diskgroup when using External Redundancy in 1ASM
- ORA-1113, ORA-1110 When recovering a copy of the database on a different serverDatabaseServer
- Migrate to different Endian Platform Using TTS With RMAN-371556.1PlatformTTS
- Physical Storage StructuresStruct
- 3.5 Different
- HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another Node [ID 415579.1]RESTDatabase
- RMAN之環境配置(二)---Backups to a Media Manager備份到介質管理器
- set up different data screen(masterial master) for different userAST
- Oracle Database Memory StructuresOracleDatabaseStruct
- B. Suffix StructuresStruct
- Using mysqldump for backupsMySql
- sentence structures經典句型Struct
- operating-system structuresStruct
- E. Data Structures FanStruct
- CRICOS Data Structures and AlgorithmsHash TablesStructGo
- Oracle ASM User Directory and Group DirectoryOracleASM
- different random numbers generatorrandom
- Introduction to Oracle Memory Structures (69)OracleStruct
- 2.3.3.3.2 Applications at Different VersionsAPP
- Hide RMAN Passwords when Connecting to a Target Database (Doc ID 183377.1)IDEDatabase
- MySQL 建表DATA DIRECTORY 、INDEX DIRECTORY 簡介MySqlIndex
- Simple Automated Backups for MongoDB Replica SetsMongoDB
- How to move progress database to different OSDatabase
- Export And Import Between Different Oracle VersionsExportImportOracle