Tag Archives: ORA-01145

ORA-01145: offline immediate disallowed unless media recovery enabled

oracle

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/