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 (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. > >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
