ORA-38706: Cannot turn on FLASHBACK DATABASE logging.ORA-38709: Recovery Area... - 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

5650969129c7031003.png (23.98 KB, 下载次数: 112)

2025-11-11 10:16 上传

解决办法
设置闪回恢复区路径

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.

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)