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