平台: Oracle10.2.0.4

dataguard主库redo大小发生变更后, 如果此时备库的standby redo大小未跟着更改, 则会发生ORA-16086错误.

Thu Jul 9 15:18:43 2009
Errors in file /u01/app/oracle/admin/YITIAN/bdump/yitian_lgwr_3550.trc:
ORA-16086: standby database does not contain available standby log files
Thu Jul 9 15:18:43 2009
LGWR: Failed to archive log 7 thread 1 sequence 4206 (16086)
Thu Jul 9 15:18:47 2009
Thread 1 advanced to log sequence 4206 (LGWR switch)
Current log# 7 seq# 4206 mem# 0: /u03/oradata/YITIAN/redo71.log
Current log# 7 seq# 4206 mem# 1: /u04/oradata/YITIAN/redo72.log
LNSc started with pid=68, OS id=1361
Thu Jul 9 15:24:45 2009
Errors in file /u01/app/oracle/admin/YITIAN/bdump/yitian_lgwr_3550.trc:
ORA-16086: standby database does not contain available standby log files
Thu Jul 9 15:24:45 2009
LGWR: Failed to archive log 8 thread 1 sequence 4207 (16086)
Thu Jul 9 15:24:49 2009
Thread 1 advanced to log sequence 4207 (LGWR switch)
Current log# 8 seq# 4207 mem# 0: /u04/oradata/YITIAN/redo81.log
Current log# 8 seq# 4207 mem# 1: /u01/oradata/YITIAN/redo82.log
LNSc started with pid=35, OS id=1870
Thu Jul 9 15:30:46 2009
Errors in file /u01/app/oracle/admin/YITIAN/bdump/yitian_lgwr_3550.trc:
ORA-16086: standby database does not contain available standby log files
Thu Jul 9 15:30:46 2009
LGWR: Failed to archive log 5 thread 1 sequence 4208 (16086)
Thu Jul 9 15:30:50 2009
Thread 1 advanced to log sequence 4208 (LGWR switch)
Current log# 5 seq# 4208 mem# 0: /u01/oradata/YITIAN/redo51.log
Current log# 5 seq# 4208 mem# 1: /u02/oradata/YITIAN/redo52.log
LNSc started with pid=54, OS id=2317

而且是每6分钟发生一次错误, 日志切换也是每6分钟一次. 后来把备库standby redolog调整成和主库redolog一样大小后, 就没这个问题了.

--End--