Oracle Solution for Error ora-01145

ORA-01145: offline immediate disallowed unless media recovery enabled

What triggered the Error:

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

What should we do to fix it:

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