How to fix the Oracle error ORA-01124: cannot recover data file string – file is in use or recovery?

In this post, you’ll learn more about the Oracle ErrorORA-01124: cannot recover data file string – file is in use or recovery with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01124: cannot recover data file string – file is in use or recovery

Reason for the Error ORA-01124: cannot recover data file string – file is in use or recovery

An attempt to do media recovery found that the file was not available for recovery. Either it is online and the database is open in some instance, or another process is curently doing media recovery on the file.

How to fix the Error ORA-01124: cannot recover data file string – file is in use or recovery ?

You can fix this error in Oracle by following the below steps

Do not do media recovery.