Re: ORA-00338: log 1 of thread 1 is more recent than controlfile.

This error comes when opening database.
If you start database after incomplte recovery than you need to do "alter database open resetlogs". If you had offline backup and didn't copy your redo logs - than you need to do

SQL> startup mount
SQL> recover until cancel
SQL> alter database open resetlogs;

How was recovery tried (one that didn't help)? How did you try to open the DB? Statements would be helpful.

If it's offline backup than you can also backup redo logs to avoid opening resetlogs.

Alex

2006/1/17, Powell, Mark D <mark.powell_at_eds.com>:
> If I am reading the post correctly I believe that you need to tell
> Oracle to perform a recovery using a backup control file.
>
> HTH -- Mark D Powell --
>
>
> -----Original Message-----
> During our testing we backed up all the datafiles and control files and
> restored those files after couple of startup/shutdowns. While starting
> up the database with backup files oracle signals error 'ora-00338'.
> ORA-00338: log 1 of thread 1 is more recent than controlfile.
> Even recover database doesn't help us.

--
http://www.freelists.org/webpage/oracle-l