ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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.