Physical standby_ORA-00322,ORA-00312

RAC+单机DG,其中DG库alter日志 Physical standby_ORA-00322,ORA-00312

Thu Sep 09 11:58:25 2021
Errors in file /u01/app/oracle/diag/rdbms/hzdg/hzdg/trace/hzdg_arc1_50876.trc:
ORA-00322: log 17 of thread 2 is not current copy
ORA-00312: online log 17 thread 2: '+DATA/hzdg/onlinelog/redo17b.log'
ORA-00322: log 17 of thread 2 is not current copy
ORA-00312: online log 17 thread 2: '+DATA/hzdg/onlinelog/redo17a.log'
Recovery of Online Redo Log: Thread 1 Group 11 Seq 85960 Reading mem 0

 

****trc文件
[oracle@hzdg trace]$ vi /u01/app/oracle/diag/rdbms/hzdg/hzdg/trace/hzdg_arc1_50876.trc
Trace file /u01/app/oracle/diag/rdbms/hzdg/hzdg/trace/newmhzdg_arc1_50876.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name: Linux
Node name: hzdg
Release: 4.1.12-61.1.18.el7uek.x86_64
Version: #2 SMP Fri Nov 4 15:48:30 PDT 2016
Machine: x86_64
Instance name: hzdg
Redo thread mounted by this instance: 1
Oracle process number: 39
Unix process pid: 50876, image: oracle@hzdg (ARC1)

*** 2021-09-09 11:58:25.676
*** SESSION ID:(2302.1) 2021-09-09 11:58:25.676
*** CLIENT ID:() 2021-09-09 11:58:25.676
*** SERVICE NAME:(SYS$BACKGROUND) 2021-09-09 11:58:25.676
*** MODULE NAME:() 2021-09-09 11:58:25.676
*** ACTION NAME:() 2021-09-09 11:58:25.676

*** TRACE FILE RECREATED AFTER BEING REMOVED ***

DDE rules only execution for: ORA 312
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
Successfully dispatched
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
DDE: Problem Key 'ORA 312' was flood controlled (0x1) (no incident)
ORA-00312: online log 17 thread 2: '+DATA/hzdg/onlinelog/redo17b.log'
ORA-00322: log 17 of thread 2 is not current copy
ORA-00312: online log 17 thread 2: '+DATA/hzdg/onlinelog/redo17a.log'
ORA-00322: log 17 of thread 2 is not current copy
ORA-00312: online log 17 thread 2: '+DATA/hzdg/onlinelog/redo17b.log'
ORA-00322: log 17 of thread 2 is not current copy
ORA-00312: online log 17 thread 2: '+DATA/hzdg/onlinelog/redo17a.log'
[oracle@hzdg trace]$

***MOS官方
Physical standby - alert*log shows ORA-322, ORA-312 intermittently (Doc ID 1592057.1)

APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
SYMPTOMS
environment:

11gR2, physical standby database

 

alert<SID>.log shows intermittently ORA-322 and ORA-312 for SRLs (standby redo logs), eg:

 

...
Sat Oct 12 01:38:25 2013
Errors in file /<path>/<db_name>_arc2_29431.trc:
ORA-00322: log 6 of thread 1 is not current copy
ORA-00312: online log 6 thread 1: '/<path>/stby3b.rdo'
ORA-00322: log 6 of thread 1 is not current copy
ORA-00312: online log 6 thread 1: '<path>/stby3a.rdo'
Sat Oct 12 01:38:25 2013
...

CHANGES
none

CAUSE
This errors are written due to a very small timing window, when the SRL header
is being updated to reflect new contents from the primary and in the same way
the ARCH process is doing his activity and seeing a CF flog entry that reflects an earlier
state.

SOLUTION
check the alert<SID>.log for any further issues. As long as ORA-322, ORA-312 is not combined with other issues, you can ignore this error.

 

eg:

...
Sat Oct 12 01:38:01 2013
Media Recovery Waiting for thread 1 sequence 1616 (in transit)
Recovery of Online Redo Log: Thread 1 Group 6 Seq 1616 Reading mem 0
Mem# 0: /<path>/stby3a.rdo
Mem# 1: /<path>/stby3b.rdo

-> SRLs are fine and in use

RFS[7]: Selected log 6 for thread 1 sequence 1618 dbid 1156134024 branch 828112011
Sat Oct 12 01:38:25 2013
Errors in file /<path>/<db_name>_arc2_29431.trc:
ORA-00322: log 6 of thread 1 is not current copy
ORA-00312: online log 6 thread 1: '/<path>/stby3b.rdo'
ORA-00322: log 6 of thread 1 is not current copy
ORA-00312: online log 6 thread 1: '/<path>/stby3a.rdo'

-> ORA-322, ORA-312 for SRLs

Sat Oct 12 01:38:25 2013
Media Recovery Waiting for thread 1 sequence 1618 (in transit)
Recovery of Online Redo Log: Thread 1 Group 6 Seq 1618 Reading mem 0
Mem# 0: /<path>/stby3a.rdo
Mem# 1: /<path>/stby3b.rdo

-> no further errors, SRLs are in use again

****SOLUTION 即:如果这个错误如果没有和他问题结合，您就可以忽略此错误；