IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
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.Cause: An ALTER DATABASE FLASHBACK ON command failed because the Recovery Area was not enabled.
Action: Set DB_RECOVERY_FILE_DEST to a location and retry.
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.
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.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/
