Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-01145 – offline immediate disallowed unless media recovery enabled

Oracle Database Error Code ORA-1145 Description :

offline immediate disallowed unless media recovery enabled

Error Cause:

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

How to Solve :

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