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"
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
B.ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=/HOME/FRA
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
|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|
DRG-11813: Moved Temporarily
IMG-00805: SIGNATURE data has been corrupted or is invalid
ORA-07217: sltln: environment variable cannot be evaluated.
ORA-16779: The destination parameter of some database has wrong syntax.
ORA-01666: controlfile is for a standby database
NPL-00100: cannot initialize ASN.1 context
LRM-00114: error when processing from command line
ORA-14005: missing RANGE keyword
DRG-50855: logoff fail
ORA-25302: Operation not possible for non-buffered queue string
ORA-31157: Invalid Content-Type charset
PLS-00118: Duplicate group-by clause in table expression