* Recovery Thread Mismatch ora-279 ora-280
(Doc ID 757994.1)
Last updated on APRIL 03, 2020
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
The following Error Messages are seen on a Physical Standby Database when Manual Recovery is attempted and even when you cancel and try to restart Managed Recovery:
ORA-00279: change 193486616 generated at 11/12/2008 21:10:35 needed for thread 37513
ORA-00289: suggestion : /opt/oracle/oradata/PATH/archives/FILE_NAME.ARC
ORA-00280: change 193486616 for thread 37513 is in sequence #31360
When verified the thread number is 1 usually but wondering where this 37513 thread has come and
how to fix this. Where does this erroneous thread come from?
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
|This is really unusual to see such out of order thread number. The issue is with the standby control file corruption giving out an erroneous value for the thread. So recreate the standby control file to fix this error. You can follow|