2023/05/08 4:03

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.

Solution

1 Execute the following SQL statement to check the status of the recovery area.

SELECT name, space_limit, space_used
FROM v$recovery_file_dest;

2 If the recovery area is not enabled, execute the following SQL statement to enable the recovery area status.

ALTER SYSTEM SET db_recovery_file_dest_size = <size_in_bytes> SCOPE=BOTH;
ALTER SYSTEM SET db_recovery_file_dest = ‘<recovery_area_location>’ SCOPE=BOTH;

3 check the status of the recovery area again by running the command in step 1.