My Oracle Support Banner

* Recovery Thread Mismatch ora-279 ora-280 (Doc ID 757994.1)

Last updated on APRIL 03, 2020

Applies to:

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

Symptoms

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:

SQL> recover standby database;
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?

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
Cause
Solution
 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
References

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