Oracle Solution for Error ora-01196

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

What triggered the Error:

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.

What should we do to fix it:

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