RAC recovery with backup controlfile fails with Ora-00266
(Doc ID 362368.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.1 [Release 9.2 to 10.2]Information in this document applies to any platform.
Symptoms
RAC database performing Duplicate database using RMAN backup failed
Controlfile recreated , and the recovery fails with
ORA-00289: suggestion : /<path>/arch/2_18401_569175784.dbf
ORA-00280: change 1115203292 for thread 2 is in sequence #18401
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/<path>/arch/2_18401_569175784.dbf
ORA-00279: change 1115203292 generated at needed for thread 1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00266: name of archived log file needed
If you have recreated the controlfile then
SQL> recover database using backup controlfile ;
ORA-00279: change 8174399184052 generated at 03/23/2006 00:08:56 needed for
thread 1
ORA-00289: suggestion : /<path>/arch1_2481.dbf
ORA-00280: change 8174399184052 for thread 1 is in sequence #2481
Specify log: {=suggested | filename | AUTO | CANCEL}
/<path>/log2.dbf
ORA-00279: change 8174399184052 generated at 03/23/2006 00:08:56 needed for
thread 2
Changes
You can recreate the controlfile from the production server by using
alter database controlfile to '<filename>';
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 |