逻辑DG 日志应用后不删除的处理：LOG_AUTO_DELETE

最新推荐文章于 2024-08-27 09:51:39 发布

weixin_34151004

最新推荐文章于 2024-08-27 09:51:39 发布

阅读量195

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

本文链接：https://blog.youkuaiyun.com/weixin_34151004/article/details/85083022

本文记录了一次Oracle数据库逻辑DG环境下日志自动删除功能失效的问题，故障表现为日志应用正常但不自动删除，并触发了内部错误ORA-00600。通过重启未能解决问题，最终通过设置参数LOG_AUTO_DELETE为TRUE得以解决。

故障现象：

逻辑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');