1，问题描述，standby从库没有应用redo日志
Tue Jul 22 09:05:07 2014
2，在从库查看redo日志信息
SQL> show parameter log_file_name_convert;
3，重建redo log
再查看下看一下现在的redo log状态
4，检查归档文件是否完整
从库redo log损坏了的话，只要从库的归档日志在，还是可以修复的，不用重新做Standy。
5，确定归档日志有没有写到从库：
所以用的lgwr进程，用lgwr进程进行传输日志，而其他模式用arch传输日志是等到日志写到归档的过程中传输过去，最近你没有改过从库的保护模式吧。
6，检查alert信息
因为主库1点有oracle归档日志，所以去主库从库看下alert日志信息：
7，在从库上操作，还原昨天的logfile组：
先停止redo应用
8，尝试下关闭再重启从库
SHUTDOWN IMMEDIATE;
- Tue Jul 22 11:04:42 2014
MRP0: Background Media Recovery cancelled with status 16037
Errors in file /oracle/app/oracle/diag/rdbms/pddgunq/powerdes/trace/powerdes_pr00_13338.trc:
ORA-16037: user requested cancel of managed recovery operation
Recovery
Errors in file /oracle/app/oracle/diag/rdbms/pddgunq/powerdes/trace/powerdes_pr00_13338.trc:
ORA-16037: user requested cancel of managed recovery operation
Waiting for MRP0 pid 13335 to terminate
Tue Jul 22 11:04:44 2014
MRP0: Background Media Recovery process shutdown (powerdes)
License high water mark = 40
ALTER DATABASE CLOSE NORMAL
Tue Jul 22 11:04:45 2014
SMON: disabling cache recovery
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Tue Jul 22 11:04:46 2014
ARCH shutting down
Tue Jul 22 11:04:46 2014
ARCH shutting down
Tue Jul 22 11:04:46 2014
ARCj: Archival stoppedTue Jul 22 11:04:46 2014
ARCH shutting downTue Jul 22 11:04:46 2014
ARCH shutting down
ARCH shutting down
Tue Jul 22 11:04:46 2014
ARCH shutting downARCi: Archival stopped
Tue Jul 22 11:04:46 2014
ARCH shutting down
Tue Jul 22 11:04:46 2014
ARCH shutting down
ARCf: Archival stopped
ARCg: Archival stoppedARCh: Archival stopped
Tue Jul 22 11:04:46 2014
ARCH shutting downARCe: Archival stopped
Tue Jul 22 11:04:46 2014
ARCH shutting downTue Jul 22 11:04:46 2014
ARCd: Archival stopped
ARCH shutting downTue Jul 22 11:04:46 2014
ARCc: Archival stoppedTue Jul 22 11:04:46 2014
ARCH shutting downARCH shutting down
Tue Jul 22 11:04:46 2014
Tue Jul 22 11:04:46 2014
Tue Jul 22 11:04:46 2014
ARCH shutting downTue Jul 22 11:04:46 2014
ARCH shutting down
ARCH shutting downARCa: Archival stopped
ARC9: Archival stopped
ARCH shutting down
ARC7: Archival stopped
ARCb: Archival stopped
ARC6: Archival stoppedARC5: Archival stoppedTue Jul 22 11:04:46 2014
ARCH shutting downARC8: Archival stopped
ARC4: Archival stopped
ARC2: Archival stopped
ARC3: Archival stopped
Tue Jul 22 11:04:46 2014
ARCH shutting down
ARC1: Archival stoppedTue Jul 22 11:04:46 2014
ARCH shutting down
ARC0: Archival stopped
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Jul 22 11:04:48 2014
Stopping background process VKTM:
Tue Jul 22 11:04:50 2014
Instance shutdown complete再启动从库
9，从库上面执行恢复归档日志，这个过程比较慢，耗时比较长
recover automatic standby database ;
10，总结2个操作：
一是重建了redo log，添加了3组standby log：
|