On 5/4/07, John Dunn <JDunn_at_sefas.com> wrote:
>
> OK, I have recreated the control file but when I run RECOVER DATABASE
> USING BACKUP CONTROLFILE I get the following errors.
>
> I am not and never have been using archivelogs so why is it asking for
> this file?
>
> SQL> RECOVER DATABASE USING BACKUP CONTROLFILE;
>
> ORA-00279: change 406102834 generated at 05/02/2007 03:19:46 needed for
> thread1
>
> ORA-00289: suggestion :
> /u03/app/oracle/product/9.2.0.1.0/dbs/arch1_1633.dbf
>
> ORA-00280: change 406102834 for thread 1 is in sequence #1633
>
>
>
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
>
Unless this is a test (i.e. throwaway) database, I'd highly recommend that
you contact Oracle Support before going any further. I don't mean any
offense, but you seem to be in over your head... database recovery really
isn't conducive to learning on-the-fly, as there are many possible
scenarios.
--
"I'm too sexy for my code." - Awk Sed Fred.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 04 2007 - 07:41:38 CDT
