一：问题描述

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.

--没有再报错了