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

1. You are restoring datafiles and controlfiles only [not online redo logs] ? Correct ?
2. Your *existing* online redo logs are still on disk -- so they are "ahead" of the files that you are restoring ? Correct ?
3. If your backup was a Hot Backup, when you issue the RECOVER DATABASE, are you issuing RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL ? --> If you are restoring older controlfiles, you must use the "USING BACKUP CONTROLFILE" syntax. --> If you are NOT restoring controlfiles but are still using the on-disk controlfiles which are the same "ahead" of datafiles as the online redo logs, then a simple RECOVER DATABASE should work.

Hemant
At 05:44 PM Monday, you wrote:
>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
>

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

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