How to fix the Oracle error ORA-01145: offline immediate disallowed unless media recovery enabled?

In this post, you’ll learn more about the Oracle ErrorORA-01145: offline immediate disallowed unless media recovery enabled with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01145: offline immediate disallowed unless media recovery enabled

Reason for the Error ORA-01145: offline immediate disallowed unless media recovery enabled

ALTER TABLESPACE … OFFLINE IMMEDIATE or ALTER DATABASE DATAFILE … OFFLINE is only allowed if database is in ARCHIVELOG mode.

How to fix the Error ORA-01145: offline immediate disallowed unless media recovery enabled ?

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

Take tablespace offline normally or shutdown abort. Reconsider your backup strategy. You could do this if you were archiving your logs.