My Oracle Support Banner

Recovery failing with ORA-00328, ORA-00334 (Doc ID 1327154.1)

Last updated on OCTOBER 21, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 11.2]
Information in this document applies to any platform.


Recovery is failing with errors like these:

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 3761213609795 generated at 05/16/2011 06:54:19 needed for thread 1
ORA-00289: suggestion : /usr/oracle/p003/archive/arch/_677042908_1_237409.log
ORA-00280: change 3761213609795 for thread 1 is in sequence #237409

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00328: archived log ends at change 3760559938982, need later change 3761213609795
ORA-00334: archived log: '/usr/oracle/p003/archive/arch/_677042908_1_237409.log'


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

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