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.
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.
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.