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

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 17 Jan 2006 13:04:48 -0500
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410505EA58EB@usahm236.amer.corp.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-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Prabhu, K Sent: Monday, January 16, 2006 4:44 AM
To: oracle-l_at_freelists.org
Subject: ORA-00338: log 1 of thread 1 is more recent than controlfile.

All,

We're testing User-Managed Backups of the Whole Database. Oracle recomends to make backups of all datafiles as well as all control files but not online redo log files.

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.

Is there anything we missed out or do we need to take online redologs as well in our consistent whole backup ?

Thanks

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 17 2006 - 12:08:06 CST