Sometimes You can get “ORA-38709: Recovery Area is not enabled. ” error.
Details of error are as follows.
ORA-38709: Recovery Area is not enabled.
To solve this error , you need to firstly set the db_recovery_file_dest_size parameter, then set db_recovery_file_dest parameter.
SQL> alter system set db_recovery_file_dest_size=50G scope=both sid='*'; System altered. SQL> alter system set db_recovery_file_dest='+DATA' scope=both sid='*'; System altered.
Now try to enable flashback as follows.
SQL> alter database flashback on; Database altered. SQL> select flashback_on from v$database; FLASHBACK_ON ------------------ YES
Do you want to learn Oracle Database for Beginners, then read the following articles.
278 views last month, 9 views today