Oracle DB Error ORA-01143 cannot disable media recovery - file string needs media recovery

The following is the cause of this error:

An attempt to disable media recovery found a file that needs media recovery, thus media recovery cannot be disabled.

Action you can take to resolve this issue: Recover the offending file or drop the tablespace it belongs to and retry this command.

Tags: Database, Education, Software

Related