back
Oracle® Database 11g / 12c / 18c error codes ORA-01145: offline immediate disallowed unless media recovery enabled
ORA-01145: offline immediate disallowed unless media recovery enabled
Oracle Error Code: ORA-01145
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.