Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-38709: Recovery Area is not enabled.

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



More Oracle Errors Interview Questions

DRG-11813: Moved Temporarily

1 Answers  


IMG-00805: SIGNATURE data has been corrupted or is invalid

1 Answers  


ORA-07217: sltln: environment variable cannot be evaluated.

1 Answers  


ORA-16779: The destination parameter of some database has wrong syntax.

1 Answers  


ORA-01666: controlfile is for a standby database

1 Answers  






NPL-00100: cannot initialize ASN.1 context

1 Answers  


LRM-00114: error when processing from command line

1 Answers  


ORA-14005: missing RANGE keyword

1 Answers  


DRG-50855: logoff fail

1 Answers  


ORA-25302: Operation not possible for non-buffered queue string

1 Answers  


ORA-31157: Invalid Content-Type charset

1 Answers  


PLS-00118: Duplicate group-by clause in table expression

1 Answers  






Categories