Site icon IT Tutorial

ORA-38709: Recovery Area is not enabled.

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:
ORA38706: Cannot turn on FLASHBACK DATABASE logging.
ORA38709: 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/

Exit mobile version