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

故障环境

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博客 ” ，链接：http://blog.itpub.net/29953799/viewspace-1873979/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29953799/viewspace-1873979/