ORA-01145: offline immediate disallowed unless media recovery enabled

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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-01145：脱机立即禁止，除非启用介质恢复,
.原因： ALTER TABLESPACE ... OFFLINE IMMEDIATE或ALTER DATABASE DATAFILE ...仅当数据库处于ARCHIVELOG模式时，才允许离线。,
.操作：使表空间正常脱机或关闭中止。重新考虑您的备份策略。你可以这样做，如果你归档你的日志。,
.

aiaiDBA

13718043309

010-86462881

ORA-01145: offline immediate disallowed unless media recovery enabled

1 个回答

相似问题