故障环境

exdata X3 11.2.3.3.1

database： 11.2.0.3.28 备库，主库当前版本为11.2.0.3.22

系统：Linux 5.10

故障现象：

备库数据库alert日志报上面600错误（mrp进程中断），数据库处于mount状态，然后节点频繁重启，最后实例无法startup。
数据库报600错误：

Errors in file /u01/app/oracle/diag/rdbms/fossstd/fossdb2/trace/fossdb2_dbw0_22984.trc (incident=880173):

ORA-00600: internal error code, arguments: [H_MK_WRITING_CR_BG], [], [], [], [], [], [], [], [], [], [], []

Incident details in: /u01/app/oracle/diag/rdbms/fossstd/fossdb2/incident/incdir_880173/fossdb2_dbw0_22984_i880173.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Errors in file /u01/app/oracle/diag/rdbms/fossstd/fossdb2/trace/fossdb2_dbw0_22984.trc:

ORA-00600: internal error code, arguments: [H_MK_WRITING_CR_BG], [], [], [], [], [], [], [], [], [], [], []

DBW0 (ospid: 22984): terminating the instance due to error 471

处理方法：

1、停止所有实例

2、将其中一个节点启动mount状态

3、开启日志实时应用

alter database recover managed standby database using current logfile disconnect from session;

4、查看实时应用情况

!ps -ef|grep mrp

set line 300

select name,value from v$dataguard_stats;

5、待追平后停止实时应用，启动该实例，再开启实时应用

alter database recover managed standby database cancel;

alter database open;

alter database recover managed standby database using current logfile disconnect from session;

6、查看数据库状态（确定为READ ONLY WITH APPLY模式）

select open_mode,database_role from v$database;

7、启动其他实例，查看实例情况

crsctl stat res -t

参考MOS文档：
DBWR Hits ORA-600 [H_MK_WRITING_CR_BG] (文档 ID 1946758.1)
Behavior of Active Dataguard(ADG) When Apply Node Aborts/Crash (文档 ID 1613719.1)

ITPub博客

记一次ADG standby异常诊断、恢复

最新文章