My Oracle Support Banner

RAC recovery with backup controlfile fails with Ora-00266 (Doc ID 362368.1)

Last updated on OCTOBER 31, 2019

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.
***Checked for relevance on 01-Mar-2011***


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

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