DG同步报错：ORA-600和ORA-313 ORA-312

DG同步报错：ORA-600和ORA-313 ORA-312

1 ADG数据库告警日志:

Errors in file /oracle/app/oracle/diag/rdbms/ORCLdg/ORCL3/trace/ORCL3_rfs_41580.trc:
ORA-00313: open failed for members of log group 17 of thread 1
Errors in file /oracle/app/oracle/diag/rdbms/ORCLdg/ORCL3/trace/ORCL3_rfs_41580.trc:
ORA-00313: open failed for members of log group 17 of thread 1
Errors in file /oracle/app/oracle/diag/rdbms/ORCLdg/ORCL3/trace/ORCL3_rfs_41580.trc  (incident=1080248):
ORA-00600: internal error code, arguments: [2130], [0], [4674], [5], [], [], [], [], [], [], [], []
Errors in file /oracle/app/oracle/diag/rdbms/ORCLdg/ORCL3/trace/ORCL3_rfs_258901.trc:
ORA-00313: open failed for members of log group 17 of thread 1

2 在主库检查DG状态时，ERROR显示ORA-0600

ORA-16099: 备用数据库中出现内部错误 ORA-00600

3 查看备库的日志文件 有一个STANBY日志组的文件是STALE状态

col MEMBER for a70
select * from v$logfile;
 GROUP# STATUS       TYPE            MEMBER                                                                 IS_
------- ------------ --------------- ---------------------------------------------------------------------- ---
      1              ONLINE          +ORCL_DATA/ORCLdg/onlinelog/group_1.626.1077702797                   NO
     16              ONLINE          +ORCL_ARCH/ORCLdg/onlinelog/group_16.271.1077702869                  YES
     17 STALE        STANDBY         +ORCL_DATA/ORCLdg/onlinelog/group_17.643.1077703691                  NO
     17              STANDBY         +ORCL_ARCH/ORCLdg/onlinelog/group_17.274.1077703695                  YES
     18              STANDBY         +ORCL_DATA/ORCLdg/onlinelog/group_18.652.1077704561                  NO

4 关闭日志应用，重启ADG到MOUNT状态，重建STATE状态的日志组

shutdown immediate
startup mount
alter database clear logfile group 17;
-- 如果是非归档模式，使用下面的命令重建
alter database clear unarchived logfile group 1;

5 重建之后再次重启ADG

shutdown immediate
startup

6 重启ADG之后告警日志无报错ORA-600和ORA-313

7 在主库检查DG状态

重启DG之后，主库同步报错：
ORA-12528: TNS:listener:all appropriate instances are blocking new connections
解决方法：连接报错，主库之后会重试，过一会儿就好了

参考：https://blog.csdn.net/weixin_33958366/article/details/92996175
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG’