Database will not start after rollback

Products

• Data Loss Prevention Enforce
• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

When attempting to open the database, it 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 environment 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.