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.

--没有再报错了