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:
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!
Shutdown database NORMAL without waiting forever