适用范围

oracle 物理adg数据同步11gr2及以后

问题概述

oracle物理备库告警日志中间接性出现ORA-00322、ORA-00312报错信息

2022-08-02T05:02:49.089020+08:00
 rfs (PID:87479): Standby controlfile consistent with primary
2022-08-02T05:02:49.116911+08:00
 rfs (PID:87479): Selected LNO:14 for T-1.S-130382 dbid 2844717988 branch 1075655142
2022-08-02T05:02:49.175988+08:00
Errors in file /oracle/app/oracle/diag/rdbms/rzzwdba/rzzwdba1/trace/rzzwdba1_rfs_128650.trc:
ORA-00322: log 14 of thread 1 is not current copy
ORA-00312: online log 14 thread 1: '+RZARCHDG/RZZWDBA/ONLINELOG/group_14.898.1086028549'
2022-08-02T05:02:49.625168+08:00
PR00 (PID:109937): Media Recovery Waiting for T-1.S-130382 (in transit)
2022-08-02T05:02:49.638258+08:00
Recovery of Online Redo Log: Thread 1 Group 14 Seq 130382 Reading mem 0
  Mem# 0: +RZARCHDG/RZZWDBA/ONLINELOG/group_14.898.1086028549

问题原因

adg日志应用检查

SQL> select process,pid,status,group#,resetlog_id,thread#,sequence# from v$managed_standby;

PROCESS   PID                      STATUS       GROUP#                                   RESETLOG_ID    THREAD#  SEQUENCE#
--------- ------------------------ ------------ ---------------------------------------- ----------- ---------- ----------
ARCH      15484                    CLOSING      13                                        1075655142          1     130529
DGRD      15500                    ALLOCATED    N/A                                                0          0          0