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-16526: unable to allocate task element

1 Answers  


ORA-13151: failed to remove exception record

1 Answers  


ORA-37081: Requested advice produced no precomputes

1 Answers  


ORA-06020: NETASY: initialisation failure

1 Answers  


LFI-01516: read() failed (OSD return value = string) in string.

1 Answers  






NNL-01053: Request processing enabled: string

1 Answers  


ORA-10640: Operation not permitted during SYSTEM tablespace migration

1 Answers  


ORA-01645: previous attempt to make read write is half complete

1 Answers  


QSM-02173: the unique constraints does not exist on the join columns of the inner table

1 Answers  


ORA-19678: RMAN configuration value exceeds maximum length of string

1 Answers  


NNL-00913: Server-generated requests sent: number

1 Answers  


this is the exception raised when i am working with oracle 11g java.lang.ClassNotFoundException: oracle.jdbc.Driver.Ora cleDriver.. but i set the class path for both oracle and java..

1 Answers  


Categories