Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ORA-00338: log 1 of thread 1 is more recent than controlfile.

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

From: Prabhu, K <prabhu_adam_at_hotmail.com>
Date: Mon, 16 Jan 2006 09:44:08 +0000
Message-ID: <BAY114-F27ABEEEFF1421B731E15C1851B0@phx.gbl>


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
Received on Mon Jan 16 2006 - 03:44:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US