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-16526: unable to allocate task element
ORA-13151: failed to remove exception record
ORA-37081: Requested advice produced no precomputes
ORA-06020: NETASY: initialisation failure
LFI-01516: read() failed (OSD return value = string) in string.
NNL-01053: Request processing enabled: string
ORA-10640: Operation not permitted during SYSTEM tablespace migration
ORA-01645: previous attempt to make read write is half complete
QSM-02173: the unique constraints does not exist on the join columns of the inner table
ORA-19678: RMAN configuration value exceeds maximum length of string
NNL-00913: Server-generated requests sent: number
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..