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@(protected)>: > 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 (See ora-00338.ora-code.com)'. > ORA-00338 (See ORA-00338.ora-code.com): log 1 of thread 1 is more recent than controlfile. > Even recover database doesn't help us. -- http://www.freelists.org/webpage/oracle-l
