MAN-06025: no backup of archived log for thread 1 with sequence 33505 and starting SCN of 11195696346 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 33504 and starting SCN of 11195690731 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 33503 and starting SCN of 11195685937 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 33502 and starting SCN of 11195681129 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 33501 and starting SCN of 11195666579 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 33500 and starting SCN of 11195658641 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 33499 and starting SCN of 11195658616 found to restore RMAN>
去找下缺失的dbf文件是否存在，原来文件一直存在
[root@localhost ~]# find / -name *33499*.dbf /oracle/app/oracle/flash_recovery_area/archivelog/1_33499_821708334.dbf [root@localhost ~]# find / -name *33512*.dbf /oracle/app/oracle/flash_recovery_area/archivelog/1_33512_821708334.dbf [root@localhost ~]#
将这些将归档日志copy到从库
[root@localhost archivelog]# scp 335.dbf root@192.118.180.108:/oracle/app/oracle/flash_recovery_area/archivelog/
[root@localhost archivelog]# chown -R oracle.dba /oracle/app/oracle/flash_recovery_area/archivelog/*
4，上一步中，如果为MOUNTED，则可以开始启动备库的REDO应用，去从库执行：
先去主库执行：
ALTER system SET log_archive_dest_state_2 = ‘defer’;
alter database recover managed standby database disconnect from session;
备库执行：
SQL> alter database recover managed standby database disconnect from session; Database altered. SQL> SQL> alter database recover managed standby database cancel; Database altered. SQL>
发现归档日志无法传输过来，而且缺失33499到33512的归档日志。想了想以前可以基于scn做过增量恢复standby的，可以试试。
5，利用SCN增量备份来恢复standby库
先备份：
backup device type disk incremental from scn 11195658616 database format ‘/home/oracle/db_incre%U.bbk’;
ALTER system SETlog_archive_dest_state_2 = ‘defer’
然后创建恢复的控制文件：
ALTER DATABASE CREATE standby controlfile AS ‘/home/oracle/standby1.ctl’;
/pddata2/oracle/backup/data
细节再使用基于scn增量备份的恢复程序：
参考文章地址：http://blog.csdn.net/mchdba/article/details/45826893