ORA-01196: file … is inconsistent due to a failed media recovery session

Message:
ORA-01196: file string is inconsistent due to a failed media recovery session

Cause:
The file was being recovered but the recovery did not terminate normally. This left the file in an inconsistent state. No more recovery was successfully completed on this file.

Action:
Either apply more logs until the file is consistent or restore the backup again and repeat recovery.

Posted in Uncategorized

Contribute further information: