Home » Server Options » Data Guard » ORA-00279:
ORA-00279: [message #323718] Thu, 29 May 2008 05:47 Go to next message
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}
auto
ORA-00328: archived log ends at change 257666, need later change 257667
ORA-00334: archived log:
'/u02/app/oracle/admin/ESTLG_LS/arch/arch_ESTLG_LS_30.log'


if i give redo log then also want 30 sequence
Re: ORA-00279: [message #323729 is a reply to message #323718] Thu, 29 May 2008 05:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Give it what is asked you or cancel the session.

Regards
Michel
Re: ORA-00279: [message #323733 is a reply to message #323729] Thu, 29 May 2008 06:07 Go to previous messageGo to next message
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 #323738 is a reply to message #323733] Thu, 29 May 2008 06:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Apply online redo logs when it asks for the sequence 30.

Regards
Michel
Re: ORA-00279: [message #323753 is a reply to message #323738] Thu, 29 May 2008 06:31 Go to previous messageGo to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

SQL> recover database using backup controlfile;
ORA-00279: change 257668 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 257668 for thread 1 is in sequence #30


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/newdata/app/oracle/oradata/EASTLEG/redo03.log
ORA-00310: archived log contains sequence 39; sequence 30 required
ORA-00334: archived log: '/newdata/app/oracle/oradata/EASTLEG/redo03.log'


SQL> recover database using backup controlfile;
ORA-00279: change 257668 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 257668 for thread 1 is in sequence #30


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/newdata/app/oracle/oradata/EASTLEG/redo02.log
ORA-00310: archived log contains sequence 41; sequence 30 required
ORA-00334: archived log: '/newdata/app/oracle/oradata/EASTLEG/redo02.log'


apply all online redo but display above error.
Re: ORA-00279: [message #323761 is a reply to message #323753] Thu, 29 May 2008 06:44 Go to previous message
Michel Cadot
Messages: 68625
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
Previous Topic: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
Next Topic: Dataguard implementation steps
Goto Forum:
  


Current Time: Thu Mar 28 23:52:17 CDT 2024