Recovery failing with ORA-00328, ORA-00334

(Doc ID 1327154.1)

Last updated on DECEMBER 05, 2017

Applies to:

Oracle Server - 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'


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