报错信息：
RMAN-06025: no backup of archived log for thread 1 with sequence *** and starting SCN of ********* found to restore
报错背景：
朋友在进行测试环境测试库恢复的过程中遇到此问题，怀疑是找不到归档文件导致的，由于其已经执行过增量备份，所以大家都推测很可能是有归档没备份进去导致的。
测试过程：
归档文件在的时候执行数据库恢复（恢复成功）：
RMAN> restore database;
Starting restore at 19-MAR-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
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 /oracle/app/oradata/ORCL/datafile/o1_mf_system_8xm4839m_.dbf
channel ORA_DISK_1: restoring datafile 00003 to /oracle/app/oradata/ORCL/datafile/o1_mf_undotbs1_8xm483gd_.dbf
channel ORA_DISK_1: restoring datafile 00007 to /oracle/app/oradata/ORCL/datafile/gaoqiang.dbf
channel ORA_DISK_1: restoring datafile 00008 to /oracle/app/oradata/ORCL/datafile/gao.dbf
channel ORA_DISK_1: restoring datafile 00009 to /oracle/app/oradata/ORCL/datafile/lee.dbf
channel ORA_DISK_1: restoring datafile 00014 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLDRSYS01.DBF
channel ORA_DISK_1: restoring datafile 00015 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLINDX01.DBF
channel ORA_DISK_1: restoring datafile 00017 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLTOOLS01.DBF
channel ORA_DISK_1: restoring datafile 00018 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLXDB01.DBF
channel ORA_DISK_1: restoring datafile 00019 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASECA_PARTDATA.DBF
channel ORA_DISK_1: restoring datafile 00020 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASECA_INDEX.DBF
channel ORA_DISK_1: restoring datafile 00023 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEOCSP_DATA.DBF
channel ORA_DISK_1: restoring datafile 00024 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEOCSP_INDEX.DBF
channel ORA_DISK_1: restoring datafile 00027 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEBSTRSPACE.DBF
channel ORA_DISK_1: reading from backup piece /backup/orcl_full_ORCL_20150319_3eq27jsk_1_1_L0
channel ORA_DISK_1: piece handle=/backup/orcl_full_ORCL_20150319_3eq27jsk_1_1_L0 tag=VALIDATE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
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 00002 to /oracle/app/oradata/ORCL/datafile/o1_mf_sysaux_8xm483f7_.dbf
channel ORA_DISK_1: restoring datafile 00004 to /oracle/app/oradata/ORCL/datafile/o1_mf_users_8xm483jk_.dbf
channel ORA_DISK_1: restoring datafile 00005 to /oracle/app/oradata/ORCL/datafile/o1_mf_example_8xm4gzck_.dbf
channel ORA_DISK_1: restoring datafile 00006 to /oracle/app/oradata/catalog_rman/rmantbs01.dbf
channel ORA_DISK_1: restoring datafile 00010 to /oracle/app/oradata/ORCL/datafile/jon.dbf
channel ORA_DISK_1: restoring datafile 00011 to /oracle/app/oradata/ORCL/datafile/CA_DATA.dbf
channel ORA_DISK_1: restoring datafile 00012 to /oracle/app/oradata/ORCL/datafile/CA_TEMP.dbf
channel ORA_DISK_1: restoring datafile 00013 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLCWMLITE01.DBF
channel ORA_DISK_1: restoring datafile 00016 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLODM01.DBF
channel ORA_DISK_1: restoring datafile 00021 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEKMC_DATA.DBF
channel ORA_DISK_1: restoring datafile 00022 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEKMC_INDEX.DBF
channel ORA_DISK_1: restoring datafile 00025 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASETSADB_DATA.DBF
channel ORA_DISK_1: restoring datafile 00026 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASETSADB_INDEX.DBF
channel ORA_DISK_1: restoring datafile 00028 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASERA_DATA_01.DBF
channel ORA_DISK_1: reading from backup piece /backup/orcl_full_ORCL_20150319_3fq27jsl_1_1_L0
channel ORA_DISK_1: piece handle=/backup/orcl_full_ORCL_20150319_3fq27jsl_1_1_L0 tag=VALIDATE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 19-MAR-15
RMAN> recover database
2> ;
Starting recover at 19-MAR-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /oracle/app/oradata/ORCL/datafile/o1_mf_system_8xm4839m_.dbf
destination for restore of datafile 00007: /oracle/app/oradata/ORCL/datafile/gaoqiang.dbf
destination for restore of datafile 00008: /oracle/app/oradata/ORCL/datafile/gao.dbf
destination for restore of datafile 00010: /oracle/app/oradata/ORCL/datafile/jon.dbf
destination for restore of datafile 00014: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLDRSYS01.DBF
destination for restore of datafile 00016: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLODM01.DBF
destination for restore of datafile 00017: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLTOOLS01.DBF
channel ORA_DISK_1: reading from backup piece /backup/orcl_Inc_ORCL_20150319_3nq27k0e_1_1_L1
channel ORA_DISK_1: piece handle=/backup/orcl_Inc_ORCL_20150319_3nq27k0e_1_1_L1 tag=VALIDATE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: /oracle/app/oradata/ORCL/datafile/o1_mf_sysaux_8xm483f7_.dbf
destination for restore of datafile 00009: /oracle/app/oradata/ORCL/datafile/lee.dbf
destination for restore of datafile 00013: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLCWMLITE01.DBF
destination for restore of datafile 00015: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLINDX01.DBF
destination for restore of datafile 00018: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLXDB01.DBF
destination for restore of datafile 00020: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASECA_INDEX.DBF
destination for restore of datafile 00026: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASETSADB_INDEX.DBF
channel ORA_DISK_1: reading from backup piece /backup/orcl_Inc_ORCL_20150319_3oq27k0f_1_1_L1
channel ORA_DISK_1: piece handle=/backup/orcl_Inc_ORCL_20150319_3oq27k0f_1_1_L1 tag=VALIDATE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: /oracle/app/oradata/ORCL/datafile/o1_mf_undotbs1_8xm483gd_.dbf
destination for restore of datafile 00004: /oracle/app/oradata/ORCL/datafile/o1_mf_users_8xm483jk_.dbf
destination for restore of datafile 00005: /oracle/app/oradata/ORCL/datafile/o1_mf_example_8xm4gzck_.dbf
destination for restore of datafile 00019: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASECA_PARTDATA.DBF
destination for restore of datafile 00023: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEOCSP_DATA.DBF
destination for restore of datafile 00024: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEOCSP_INDEX.DBF
destination for restore of datafile 00027: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEBSTRSPACE.DBF
channel ORA_DISK_1: reading from backup piece /backup/orcl_Inc_ORCL_20150319_3pq27k0f_1_1_L1
channel ORA_DISK_1: piece handle=/backup/orcl_Inc_ORCL_20150319_3pq27k0f_1_1_L1 tag=VALIDATE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /oracle/app/oradata/catalog_rman/rmantbs01.dbf
destination for restore of datafile 00011: /oracle/app/oradata/ORCL/datafile/CA_DATA.dbf
destination for restore of datafile 00012: /oracle/app/oradata/ORCL/datafile/CA_TEMP.dbf
destination for restore of datafile 00021: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEKMC_DATA.DBF
destination for restore of datafile 00022: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEKMC_INDEX.DBF
destination for restore of datafile 00025: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASETSADB_DATA.DBF
destination for restore of datafile 00028: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASERA_DATA_01.DBF
channel ORA_DISK_1: reading from backup piece /backup/orcl_Inc_ORCL_20150319_3qq27k0f_1_1_L1
channel ORA_DISK_1: piece handle=/backup/orcl_Inc_ORCL_20150319_3qq27k0f_1_1_L1 tag=VALIDATE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
starting media recovery
archived log for thread 1 with sequence 164 is already on disk as file /archlog/orcl/1_164_820195525.dbf
archived log for thread 1 with sequence 165 is already on disk as file /archlog/orcl/1_165_820195525.dbf
archived log for thread 1 with sequence 166 is already on disk as file /archlog/orcl/1_166_820195525.dbf
archived log for thread 1 with sequence 167 is already on disk as file /archlog/orcl/1_167_820195525.dbf
archived log file name=/archlog/orcl/1_164_820195525.dbf thread=1 sequence=164
archived log file name=/archlog/orcl/1_165_820195525.dbf thread=1 sequence=165
media recovery complete, elapsed time: 00:00:00
Finished recover at 19-MAR-15
OK，恢复成功，没有任何问题！~~~
接着执行alter system switch logfile生成3个新的归档日志，新的3个日志是不在最新的增量备份中的。
挪走归档日志，其中包括新生成的3个日志：
[root@dbserver backup]# mkdir archbackup
[root@dbserver backup]# cd /archlog/orcl/
[root@dbserver orcl]# ls
1_100_820195525.dbf 1_111_820195525.dbf 1_122_820195525.dbf 1_133_820195525.dbf 1_144_820195525.dbf 1_155_820195525.dbf 1_166_820195525.dbf
1_101_820195525.dbf 1_112_820195525.dbf 1_123_820195525.dbf 1_134_820195525.dbf 1_145_820195525.dbf 1_156_820195525.dbf 1_167_820195525.dbf
1_102_820195525.dbf 1_113_820195525.dbf 1_124_820195525.dbf 1_135_820195525.dbf 1_146_820195525.dbf 1_157_820195525.dbf 1_92_820195525.dbf
1_103_820195525.dbf 1_114_820195525.dbf 1_125_820195525.dbf 1_136_820195525.dbf 1_147_820195525.dbf 1_158_820195525.dbf 1_93_820195525.dbf
1_104_820195525.dbf 1_115_820195525.dbf 1_126_820195525.dbf 1_137_820195525.dbf 1_148_820195525.dbf 1_159_820195525.dbf 1_94_820195525.dbf
1_105_820195525.dbf 1_116_820195525.dbf 1_127_820195525.dbf 1_138_820195525.dbf 1_149_820195525.dbf 1_160_820195525.dbf 1_95_820195525.dbf
1_106_820195525.dbf 1_117_820195525.dbf 1_128_820195525.dbf 1_139_820195525.dbf 1_150_820195525.dbf 1_161_820195525.dbf 1_96_820195525.dbf
1_107_820195525.dbf 1_118_820195525.dbf 1_129_820195525.dbf 1_140_820195525.dbf 1_151_820195525.dbf 1_162_820195525.dbf 1_97_820195525.dbf
1_108_820195525.dbf 1_119_820195525.dbf 1_130_820195525.dbf 1_141_820195525.dbf 1_152_820195525.dbf 1_163_820195525.dbf 1_98_820195525.dbf
1_109_820195525.dbf 1_120_820195525.dbf 1_131_820195525.dbf 1_142_820195525.dbf 1_153_820195525.dbf 1_164_820195525.dbf 1_99_820195525.dbf
1_110_820195525.dbf 1_121_820195525.dbf 1_132_820195525.dbf 1_143_820195525.dbf 1_154_820195525.dbf 1_165_820195525.dbf
[root@dbserver orcl]# mv ./* /backup/archbackup/
[root@dbserver orcl]# ls -lt
总计 0 ---OK，归档路径下没有任何归档日志文件
[root@dbserver orcl]# pwd
/archlog/orcl
再进行数据库恢复：
重启数据库到mount状态
RMAN> shutdown immediate;
database dismounted
Oracle instance shut down
RMAN> startup mount;
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 417546240 bytes
Fixed Size 2213936 bytes
Variable Size 364906448 bytes
Database Buffers 41943040 bytes
Redo Buffers 8482816 bytes
RMAN> restore database;
Starting restore at 19-MAR-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK
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 /oracle/app/oradata/ORCL/datafile/o1_mf_system_8xm4839m_.dbf
channel ORA_DISK_1: restoring datafile 00003 to /oracle/app/oradata/ORCL/datafile/o1_mf_undotbs1_8xm483gd_.dbf
channel ORA_DISK_1: restoring datafile 00007 to /oracle/app/oradata/ORCL/datafile/gaoqiang.dbf
channel ORA_DISK_1: restoring datafile 00008 to /oracle/app/oradata/ORCL/datafile/gao.dbf
channel ORA_DISK_1: restoring datafile 00009 to /oracle/app/oradata/ORCL/datafile/lee.dbf
channel ORA_DISK_1: restoring datafile 00014 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLDRSYS01.DBF
channel ORA_DISK_1: restoring datafile 00015 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLINDX01.DBF
channel ORA_DISK_1: restoring datafile 00017 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLTOOLS01.DBF
channel ORA_DISK_1: restoring datafile 00018 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLXDB01.DBF
channel ORA_DISK_1: restoring datafile 00019 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASECA_PARTDATA.DBF
channel ORA_DISK_1: restoring datafile 00020 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASECA_INDEX.DBF
channel ORA_DISK_1: restoring datafile 00023 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEOCSP_DATA.DBF
channel ORA_DISK_1: restoring datafile 00024 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEOCSP_INDEX.DBF
channel ORA_DISK_1: restoring datafile 00027 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEBSTRSPACE.DBF
channel ORA_DISK_1: reading from backup piece /backup/orcl_full_ORCL_20150319_3eq27jsk_1_1_L0
channel ORA_DISK_1: piece handle=/backup/orcl_full_ORCL_20150319_3eq27jsk_1_1_L0 tag=VALIDATE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
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 00002 to /oracle/app/oradata/ORCL/datafile/o1_mf_sysaux_8xm483f7_.dbf
channel ORA_DISK_1: restoring datafile 00004 to /oracle/app/oradata/ORCL/datafile/o1_mf_users_8xm483jk_.dbf
channel ORA_DISK_1: restoring datafile 00005 to /oracle/app/oradata/ORCL/datafile/o1_mf_example_8xm4gzck_.dbf
channel ORA_DISK_1: restoring datafile 00006 to /oracle/app/oradata/catalog_rman/rmantbs01.dbf
channel ORA_DISK_1: restoring datafile 00010 to /oracle/app/oradata/ORCL/datafile/jon.dbf
channel ORA_DISK_1: restoring datafile 00011 to /oracle/app/oradata/ORCL/datafile/CA_DATA.dbf
channel ORA_DISK_1: restoring datafile 00012 to /oracle/app/oradata/ORCL/datafile/CA_TEMP.dbf
channel ORA_DISK_1: restoring datafile 00013 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLCWMLITE01.DBF
channel ORA_DISK_1: restoring datafile 00016 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLODM01.DBF
channel ORA_DISK_1: restoring datafile 00021 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEKMC_DATA.DBF
channel ORA_DISK_1: restoring datafile 00022 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEKMC_INDEX.DBF
channel ORA_DISK_1: restoring datafile 00025 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASETSADB_DATA.DBF
channel ORA_DISK_1: restoring datafile 00026 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASETSADB_INDEX.DBF
channel ORA_DISK_1: restoring datafile 00028 to /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASERA_DATA_01.DBF
channel ORA_DISK_1: reading from backup piece /backup/orcl_full_ORCL_20150319_3fq27jsl_1_1_L0
channel ORA_DISK_1: piece handle=/backup/orcl_full_ORCL_20150319_3fq27jsl_1_1_L0 tag=VALIDATE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 19-MAR-15
RMAN> recover database;
Starting recover at 19-MAR-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /oracle/app/oradata/ORCL/datafile/o1_mf_system_8xm4839m_.dbf
destination for restore of datafile 00007: /oracle/app/oradata/ORCL/datafile/gaoqiang.dbf
destination for restore of datafile 00008: /oracle/app/oradata/ORCL/datafile/gao.dbf
destination for restore of datafile 00010: /oracle/app/oradata/ORCL/datafile/jon.dbf
destination for restore of datafile 00014: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLDRSYS01.DBF
destination for restore of datafile 00016: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLODM01.DBF
destination for restore of datafile 00017: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLTOOLS01.DBF
channel ORA_DISK_1: reading from backup piece /backup/orcl_Inc_ORCL_20150319_3nq27k0e_1_1_L1
channel ORA_DISK_1: piece handle=/backup/orcl_Inc_ORCL_20150319_3nq27k0e_1_1_L1 tag=VALIDATE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: /oracle/app/oradata/ORCL/datafile/o1_mf_sysaux_8xm483f7_.dbf
destination for restore of datafile 00009: /oracle/app/oradata/ORCL/datafile/lee.dbf
destination for restore of datafile 00013: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLCWMLITE01.DBF
destination for restore of datafile 00015: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLINDX01.DBF
destination for restore of datafile 00018: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORADATAORCLXDB01.DBF
destination for restore of datafile 00020: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASECA_INDEX.DBF
destination for restore of datafile 00026: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASETSADB_INDEX.DBF
channel ORA_DISK_1: reading from backup piece /backup/orcl_Inc_ORCL_20150319_3oq27k0f_1_1_L1
channel ORA_DISK_1: piece handle=/backup/orcl_Inc_ORCL_20150319_3oq27k0f_1_1_L1 tag=VALIDATE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: /oracle/app/oradata/ORCL/datafile/o1_mf_undotbs1_8xm483gd_.dbf
destination for restore of datafile 00004: /oracle/app/oradata/ORCL/datafile/o1_mf_users_8xm483jk_.dbf
destination for restore of datafile 00005: /oracle/app/oradata/ORCL/datafile/o1_mf_example_8xm4gzck_.dbf
destination for restore of datafile 00019: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASECA_PARTDATA.DBF
destination for restore of datafile 00023: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEOCSP_DATA.DBF
destination for restore of datafile 00024: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEOCSP_INDEX.DBF
destination for restore of datafile 00027: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEBSTRSPACE.DBF
channel ORA_DISK_1: reading from backup piece /backup/orcl_Inc_ORCL_20150319_3pq27k0f_1_1_L1
channel ORA_DISK_1: piece handle=/backup/orcl_Inc_ORCL_20150319_3pq27k0f_1_1_L1 tag=VALIDATE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /oracle/app/oradata/catalog_rman/rmantbs01.dbf
destination for restore of datafile 00011: /oracle/app/oradata/ORCL/datafile/CA_DATA.dbf
destination for restore of datafile 00012: /oracle/app/oradata/ORCL/datafile/CA_TEMP.dbf
destination for restore of datafile 00021: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEKMC_DATA.DBF
destination for restore of datafile 00022: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASEKMC_INDEX.DBF
destination for restore of datafile 00025: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASETSADB_DATA.DBF
destination for restore of datafile 00028: /oracle/app/oracle/product/11.2.0/db_1/dbs/ORACLEORA92DATABASERA_DATA_01.DBF
channel ORA_DISK_1: reading from backup piece /backup/orcl_Inc_ORCL_20150319_3qq27k0f_1_1_L1
channel ORA_DISK_1: piece handle=/backup/orcl_Inc_ORCL_20150319_3qq27k0f_1_1_L1 tag=VALIDATE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
starting media recovery
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/19/2015 13:43:56
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 167 and starting SCN of 379521673 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 166 and starting SCN of 379521652 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 165 and starting SCN of 379520892 found to restore
确实是由于归档的问题导致了RMAN-06025报错。
解决方法一般有2个：
1.把最新的归档日志复制到归档路径下，再次执行数据库恢复操作；
2.进行不完全恢复。
不完全恢复方法：
基于时间点：
startup mount;
restore database until time "to_date('2015-04-20 08:13:50','yyyy-mm-dd hh24:mi:ss')";
recover database until time "to_date('2015-04-20 08:13:50','yyyy-mm-dd hh24:mi:ss')";
alter database open resetlogs;
基于scn号：
startup mount;
restore database until scn 888；
recover database until scn 888；
alter database open resetlogs;
基于归档日志序列号:
startup mount;
restore database until sequence 123 thread 1；
recover database until sequence 123 thread 1；
alter database open resetlogs;
阅读(21271) | 评论(0) | 转发(0) |
