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.
No comments:
Post a Comment
Thanks for your comment.