Re: SOS : error when recover datafile : ORA-00279

From: eugenep <eugene_at_mail.gsfc.state.ga.us>
Date: 26 Sep 2002 12:38:28 -0700
Message-ID: <f57221ec.0209261138.400d654f@posting.google.com>

> I tried to shutdown db and restore 23-SEP online backup of itgx01.dbf
> and startup mount for recover :
>
> # sqlplus internal
> SQL> startup mount
> SQL> alter database recover datafile '/u03/proddata/itgx01.dbf';
> alter database recover datafile '/u03/proddata/itgx01.dbf'
> *
> ERROR at line 1:
> ORA-00279: change 5965070658351 generated at 09/23/2002 01:54:48 needed for
> thread 1
> ORA-00289: suggestion : /u03/prodarch/prod6977.arc
> ORA-00280: change 5965070658351 for thread 1 is in sequence #6977
>
>
> SQL>
>
> BUT WHY? I had all archived logfiles in /u03/prodarch
>

In the future, all you need to do is add the word AUTOMATIC after the word RECOVER to avoid this error. If you omit the AUTOMATIC option, then you MUST specify the names of redo log files using the LOGFILE parameter in your RECOVER clause.

Regards,

Eugene Pokopac (Oracle DBA - Tucker, GA) Received on Thu Sep 26 2002 - 14:38:28 CDT