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 = SCOPE=BOTH; ALTER SYSTEM SET db_recovery_file_dest = '' SCOPE=BOTH; 3 check the status of the recovery area again by running the command in step 1.