ORA-38709: Recovery Area is not enabled.
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
ORA-15173: entry 'string' does not exist in directory 'string'
ORA-17622: failed to deregister the memory with Oracle Disk Manager library
EXP-00102: Resumable parameters ignored -- current session not resumable
TNS-01400: Instance "string" has number handlers.
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.
DRG-11826: Proxy Authentication Required
ORA-24086: cannot create a 8.0 compatible string queue
ORA-25280: complete sender information not provided to non-repudiate sender
LSX-00155: invalid use of attribute "ref"
TNS-01064: Listener configuration changes will not be persistent
QSM-02120: compatibility mode must be 9.0 or higher
ORA-16112: log mining and apply stopping