RAC recovery with backup controlfile fails with Ora-00266

(Doc ID 362368.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.4 and later   [Release: 10.1 and later ]
Oracle Server - 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 : /app/oracle/admin/crmdev/arch/2_18401_569175784.dbf
ORA-00280: change 1115203292 for thread 2 is in sequence #18401
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/app/oracle/admin/crmdev/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 : /d1/RAC/dbs/arch1_2481.dbf
ORA-00280: change 8174399184052 for thread 1 is in sequence #2481


Specify log: {=suggested | filename | AUTO | CANCEL}
/d4/cprac/cpracdata/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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms