ORA-38786: Recovery area is not enabled. ORACLE 报错 故障修复 远程处理

文档解释

ORA-38786: Recovery area is not enabled.

Cause: An attempt was made to perform a command that requires Flash recovery area to be enabled.

Action: Set DB_RECOVERY_FILE_DEST to an appropriate location and retry.

。

ORA-38786: Recovery area is not enabled的意思是恢复区域尚未启用。

官方解释

常见案例

一般处理方法及步骤

1.打开一个SQL提示符，连接到您的数据库。

2.设置恢复区路径： ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=‘/u01/ora_backup’ SCOPE = BOTH;

3.指定可用空间： ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 100G SCOPE=BOTH;

4.让恢复区域可用： ALTER SYSTEM SET LOG_ARCHIVE_CONFIG = ‘DB_RECOVERY_FILE_DEST_SIZE = 100G’ SCOPE=BOTH;

5.确认设置：SELECT NAME, VALUE FROM V$DATABASE_PROPERTY;

6. 提交更改： COMMIT;