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

ORA-15173: entry 'string' does not exist in directory 'string'

1 Answers  


ORA-17622: failed to deregister the memory with Oracle Disk Manager library

1 Answers  


EXP-00102: Resumable parameters ignored -- current session not resumable

1 Answers  


TNS-01400: Instance "string" has number handlers.

1 Answers  


ORA-33082: (XSAGDNGL41) In AGGMAP workspace object, the non-dimensioned valueset workspace object must have a parent QDR in its VALUESET statement over the VALUESET's base dimension.

1 Answers  






DRG-11826: Proxy Authentication Required

1 Answers  


ORA-24086: cannot create a 8.0 compatible string queue

1 Answers  


ORA-25280: complete sender information not provided to non-repudiate sender

1 Answers  


LSX-00155: invalid use of attribute "ref"

1 Answers  


TNS-01064: Listener configuration changes will not be persistent

1 Answers  


QSM-02120: compatibility mode must be 9.0 or higher

1 Answers  


ORA-16112: log mining and apply stopping

1 Answers  


Categories