Last updated on OCTOBER 28, 2016
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.4Oracle 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