ORA-38709: Recovery Area is not enabled.

Question Posted / guest

3 Answers
22690 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

ORA-38709: Recovery Area is not enabled...

Answer / bhuvneshwar singh

ORA-38706 "Cannot turn on flashback database logging"
ORA-38709 "Recovery area is not enabled"

Solution :

1. do the proper shutdown of database (shut normal,immediate).
2. start up database in mount phase ( startup mount).
3. set this parameter one by one
a.ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=2G
SCOPE=BOTH;

B.ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=/HOME/FRA
SCOPE=BOTH;

4. ALTER DATABASE OPEN;

5. NOW USE THIS COMMAND AND CHECK IT OUT WHETHER FLASHBACK
AREA IS ENABLED ?

SELECT NAME, FLASHBACK_ON FROM V$DATABASE;

I am sure this information will help you a lot

Regards
Bhvuneshwar singh

Is This Answer Correct ?

6 Yes

2 No

ORA-38709: Recovery Area is not enabled...

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?

2 Yes

2 No

ORA-38709: Recovery Area is not enabled...

Answer / ajit tripathi

Everything will be same as above only path for fra will be inverted comas.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer