Re: ORA-00338: log 1 of thread 1 is more recent than controlfile.
- From: Alex Gorbachev <gorbyx@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 18 Jan 2006 00:01:19 +0100
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@xxxxxxx>:
> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
