SAP Note 13789 - Recovery on error ORA-1113

Symptom:

Oracle rturns ORA1113 although a complete off-line backup of all file systems was restored and it should be consistent with all objects.

Cause and prerequisites

Unknown.
The following tables will help you to examine the recovery situation in more detail:
V$RECOVER_FILE: Display of the files, which require a recovery.
V$RECOVERY_LOG: All OFFLINE Redologs that are required to do this.
The select commands can be performed in the MOUNT status of the database. If no logs appear in V$RECOVERY_LOG, a recovery with the online redologs is sufficient.

Solution
If V$RECOVERY_LOG does not return any file, you can perform:
sqldba> recover database
and if this was successful;
sqldba> alter database open;
irectly in the MOUNT status.

Otherwise, we always recommend the program SAPDBA, which however is based on correct information of Oracle in the V$ tables. Therefore the workflow is also incorrect if the information in V$ tables in SAPDBA is incorrect.

Key word: RECOVERY