My Oracle Support Banner

ORA-00338 - Stuck Recovery on Physical standby after recreate controlfile from primary (Doc ID 2776188.1)

Last updated on MAY 20, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Managed recovery is not progressing on standby with below errors in the standby alert log

ORA-00338: log 9 of thread 1 is more recent than control file
ORA-00312: online log 9 thread 1: '+FRA/<DBUniqueName>/ONLINELOG/group_9.258.1022593711'
ORA-00338: log 9 of thread 1 is more recent than control file
ORA-00312: online log 9 thread 1: '+DATA/<DBUniqueName>/ONLINELOG/group_9.464.1022593701'


ORA-00338: log 14 of thread 2 is more recent than control file
ORA-00312: online log 14 thread 2: '+FRA/<DBUniqueName>/ONLINELOG/group_14.271.1022593439'
ORA-00338: log 14 of thread 2 is more recent than control file
ORA-00312: online log 14 thread 2: '+DATA/<DBUniqueName>/ONLINELOG/group_14.477.1022593429'

And


ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 15 thread 2: '+DATA/<DBUniqueName>/ONLINELOG/group_15.476.1022593445'

ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 16 thread 2: '+DATA/<DBUniqueName>/ONLINELOG/group_16.475.1022593465'

V$standby_log shows that Groups 9 and 14 are in ACTIVE status:

THREAD# GROUP# SEQUENCE# BYTES ARC STATUS BLOCKSIZE MEMBER
1 9 697199 4294967296 YES ACTIVE 512 +DATA/<DBUniqueName>/ONLINELOG/group_9.464.1022593701
1 9 697199 4294967296 YES ACTIVE 512 +FRA/<DBUniqueName>/ONLINELOG/group_9.258.1022593711
2 14 534022 4294967296 YES ACTIVE 512 +FRA/<DBUniqueName>/ONLINELOG/group_14.271.1022593439
2 14 534022 4294967296 YES ACTIVE 512 +DATA/<DBUniqueName>/ONLINELOG/group_14.477.1022593429
2 15 0 4294967296 NO UNASSIGNED 512 +FRA/<DBUniqueName>/ONLINELOG/group_15.270.1022593455
2 15 0 4294967296 NO UNASSIGNED 512 +DATA/<DBUniqueName>/ONLINELOG/group_15.476.1022593445
2 16 0 4294967296 NO UNASSIGNED 512 +DATA/<DBUniqueName>/ONLINELOG/group_16.475.1022593465
2 16 0 4294967296 NO UNASSIGNED 512 +FRA/<DBUniqueName>/ONLINELOG/group_16.269.1022593483

 

Changes

 Recovered standby database and recreated standby controlfile from primary. While starting Managed recovery on standby, recovery is not progressing

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.