ORA-01145: offline immediate disallowed unless media recovery enabled

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

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

Error Type: ORA

• Additional information for ORA-01145: offline immediate disallowed unless media recovery enabled01145
Discussions and solutions for Oracle Database Error ORA-01145: offline immediate disallowed unless media recovery enabled Developer anwers for Oracle Database Error ORA-01145: offline immediate disallowed unless media recovery enabled FAQs for ORA-01145: offline immediate disallowed unless media recovery enabled search others tips for ORA-01145: offline immediate disallowed unless media recovery enabled