ORA-00314: Restore need online log from a cold backup
                                                 Last update (2009-04-10 22:47:42)
                                                                                                                   Date added (2008-04-04 20:37:33)

Summary
Performing a restore of the database from an cold offline backup while starting the database you receive the following error:

ORA-00314: log %s of thread %s, expected sequence# %s doesn't match %s"
Cause: The online log is corrupted or is an old version.

When you do a cold database backup you shutdown the database and copy the:
1. datafiles
2. redolog files
3. control files
4. parameter files
You would think all online transactions have been written to datafiles so the online redo logs are no longer needed.

But this is not true! Redolog files are needed!

Other links
Shutdown database NORMAL without waiting forever
Reviews
Filters
Search