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
-- //www.freelists.org/webpage/oracle-l
Hemant K Chitale http://web.singnet.com.sg/~hkchital
-- //www.freelists.org/webpage/oracle-l