|
|
Re: ORA-00279: [message #323733 is a reply to message #323729] |
Thu, 29 May 2008 06:07 |
malvika
Messages: 55 Registered: May 2008 Location: india
|
Member |
|
|
SQL> recover database using backup controlfile;
ORA-00279: change 257667 generated at 05/29/2008 13:42:06 needed for thread 1
ORA-00289: suggestion :
/u02/app/oracle/admin/ESTLG_LS/arch/arch_ESTLG_LS_30.log
ORA-00280: change 257667 for thread 1 is in sequence #30
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/newdata/app/oracle/oradata/ESTLG_LS/redo02.log
ORA-00310: archived log contains sequence 29; sequence 30 required
ORA-00334: archived log: '/newdata/app/oracle/oradata/ESTLG_LS/redo02.log'
SQL> recover database using backup controlfile;
ORA-00279: change 257667 generated at 05/29/2008 13:42:06 needed for thread 1
ORA-00289: suggestion :
/u02/app/oracle/admin/ESTLG_LS/arch/arch_ESTLG_LS_30.log
ORA-00280: change 257667 for thread 1 is in sequence #30
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/newdata/app/oracle/oradata/ESTLG_LS/redo03.log
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01248: file 6 was created in the future of incomplete recovery
ORA-01110: data file 6: '/newdata/app/oracle/oradata/ESTLG_LS/logstdby_01.dbf'
[Updated on: Thu, 29 May 2008 06:19] Report message to a moderator
|
|
|
|
|
Re: ORA-00279: [message #323761 is a reply to message #323753] |
Thu, 29 May 2008 06:44 |
|
Michel Cadot
Messages: 68651 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Then you miss one archived log and have to recover before (using "until" clause).
Regards
Michel
|
|
|