Oracle11GDataGuardORA-16086問題修復詳細過程
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：
