故障现象:
逻辑DG数据库日志能够应用,但是确不会将应用后的日志删除,查看日志发现已经自动设置了TURNING OFF LOG AUTO DELETE
Completed: alter database register logfile '/archivelog/archive_2_25797_614088933.arc'
Tue Apr 24 11:06:10 2012
LOGMINER: Begin mining logfile for session 1 thread 2 sequence 25797, /archivelog/archive_2_25797_614088933.arc
Tue Apr 24 11:06:18 2012
Thread 1 advanced to log sequence 528 (LGWR switch)
  Current log# 5 seq# 528 mem# 0: /oradata/rlog13_disk
Tue Apr 24 11:06:29 2012
Errors in file /home/oracle/admin/lstandby/bdump/lstandby_p000_278768.trc:
ORA-00600: internal error code, arguments: [krvxradfd: file header mismatch], [2566595041], [2566595041], [614088933], [614088933], [2], [2], [25796]
Tue Apr 24 11:06:31 2012
LOGMINER: Log Auto Delete - Unexpected error, turning OFF Log Auto Delete
Tue Apr 24 11:06:31 2012
krvxerpt: Errors detected in process 25, role reader.
Tue Apr 24 11:06:31 2012
krvxmrs: Leaving by exception: 600
Tue Apr 24 11:06:31 2012
Errors in file /home/oracle/admin/lstandby/bdump/lstandby_p000_278768.trc:
ORA-00600: internal error code, arguments: [krvxradfd: file header mismatch], [2566595041], [2566595041], [614088933], [614088933], [2], [2], [25796]
LOGSTDBY status: ORA-00600: internal error code, arguments: [krvxradfd: file header mismatch], [2566595041], [2566595041], [614088933], [614088933], [2], [2], [25796]
Tue Apr 24 11:06:32 2012
Errors in file /home/oracle/admin/lstandby/bdump/lstandby_lsp0_311792.trc:
ORA-12801: error signaled in parallel query server P000
ORA-00600: internal error code, arguments: [krvxradfd: file header mismatch], [2566595041], [2566595041], [614088933], [614088933], [2], [2], [257
Tue Apr 24 11:06:32 2012
LogMiner process death detected
logminer process death detected, exiting logical standby
LOGSTDBY Analyzer process P003 pid=30 OS id=360854 stopped
LOGSTDBY Apply process P007 pid=39 OS id=197114 stopped
LOGSTDBY Apply process P005 pid=32 OS id=209370 stopped
LOGSTDBY Apply process P006 pid=38 OS id=201018 stopped
 
故障处理1:尝试重启,未解决问题
Attempt to start background Logical Standby process
LOGSTDBY Parameter:                LOG_AUTO_DELETE = FALSE 
LOGSTDBY Parameter:                DISABLE_APPLY_DELAY =  
LOGSTDBY Parameter:                      REAL_TIME =  
 
故障处理2:直接设置参数解决该问题
EXECUTE DBMS_LOGSTDBY.APPLY_SET('LOG_AUTO_DELETE', 'TRUE');