Database will not start after rollback

book

Article ID: 184492

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

attempting to open the database fails with an error
ORA-00314: expected sequence doesn't match
ORA-00312: online log 1 thread 1: in redo02.log.

When looking at the files, the redo02.log is not in the same date range as the rest of the db files in the oradata/protect/ folder.

Cause

The redo logs are moveable and were located elsewhere. The cold backup was not complete since the redo logs were not copied correctly.

This is not a supported enviroment by Symantec or Oracle and without a proper backup, there us no way to recover the DB.

Resolution

If there is correct and full copy of the database with the redo logs that were in another folder, it will need to be restored. Otherwise there is no method to recover an incomplete backup.