逻辑DG 日志应用后不删除的处理:LOG_AUTO_DELETE
原创文章标签 ORACLE DG LOG_AUTO_D 文章分类 Oracle 数据库
©著作权归作者所有:来自51CTO博客作者zylhsy的原创作品,请联系作者获取转载授权,否则将追究法律责任
故障现象:
逻辑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');
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
DG_broker工具管理切换DG主备
DG_broker工具管理切换DG主备
oracle TCP hive -
ORACLE DG 逻辑standby
有好工作欢迎推荐 限深圳地区,个人QQ:252190189
物理standby oracle DG