oracle数据库rman备份计划及恢复(5)

this file type File Name: /u01/ora_bak/ora_bak/onlinelog_f/o1_mf_3_c5fr9kfo_.log RMAN-07529: Reason: catalog is not supported for this file type File Name: /u01/ora_bak/ora_bak/onlinelog_f/o1_mf_1_c5fr9ds4_.log RMAN-07529: Reason: catalog is not supported for this file type File Name: /u01/ora_bak/ora_bak/onlinelog/o1_mf_3_c5fr9k9d_.log RMAN-07529: Reason: catalog is not supported for this file type File Name: /u01/ora_bak/ora_bak/onlinelog/o1_mf_2_c5fr9gy5_.log RMAN-07529: Reason: catalog is not supported for this file type File Name: /u01/ora_bak/ora_bak/onlinelog/o1_mf_1_c5fr9dmk_.log RMAN-07529: Reason: catalog is not supported for this file type File Name: /u01/ora_bak/O1_MF_S_895896118_C4KS5S1R_.BKP RMAN-07518: Reason: Foreign database file DBID: 966107096 Database Name: RFDB

 

 

i.开始restore数据文件：

 

 

RMAN> restore database;

 

Starting restore at 14-DEC-15

using channel ORA_DISK_1

 

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/ATEST/datafile/o1_mf_system_c5fr6s3v_.dbf

channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/ATEST/datafile/o1_mf_sysaux_c5fr6s6d_.dbf

channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/ATEST/datafile/o1_mf_undotbs1_c5fr6s7n_.dbf

channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/ATEST/datafile/o1_mf_users_c5fr6s88_.dbf

channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/ATEST/backupset/2015_12_09/o1_mf_nnndf_TAG20151209T161546_c6hrslnq_.bkp

channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ATEST/backupset/2015_12_09/o1_mf_nnndf_TAG20151209T161546_c6hrslnq_.bkp tag=TAG20151209T161546

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:45

Finished restore at 14-DEC-15

 

 

j.开始recover数据（在此之前，需要先拷贝redolog到控制文件默认的路径下）： redolog默认路径：

 

 

SQL> select member from v$logfile;

 

MEMBER

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/ATEST/onlinelog/o1_mf_3_c5fr9k9d_.log

/u01/app/oracle/fast_recovery_area/ATEST/onlinelog/o1_mf_3_c5fr9kfo_.log

/u01/app/oracle/oradata/ATEST/onlinelog/o1_mf_2_c5fr9gy5_.log