ORA-38706: Cannot turn on FLASHBACK DATABASE logging.ORA-38709: Recovery Area is not enabled.

一：問題描述

SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38709: Recovery Area is not enabled. 二：出錯原因

沒有設定閃回恢複區路徑

如圖：

三：解決辦法

設定閃回恢複區路徑

SQL> alter system set db_recovery_file_dest='/home/oracle/db_recovery_file_dest';--這裡可以自訂路徑

System altered.

SQL> show parameter db_recovery;

NAME         TYPE  VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest       string  /home/oracle/db_recovery_file_
       dest
db_recovery_file_dest_size      big integer 2G
SQL> alter database flashback on;

Database altered.

--沒有再報錯了