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

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

Answer / ajit tripathi

Everything will be same as above only path for fra will be inverted comas.

DRG-11718: multiple Preferred Terms for term string

1 Answers  

---

ORA-29288: invalid file name

1 Answers  

---

ORA-07473: snclrd: read error when trying to read sgadef.dbf file.

1 Answers  

---

NNO-00322: statistic counter dump interval changed to number seconds

1 Answers  

---

TNS-12631: Username retrieval failed

1 Answers  

---

LSX-00282: duplicate notation name "~S"

1 Answers  

---

ORA-16070: parameter string contains an invalid REGISTER attribute value

1 Answers  

---

ORA-23608: invalid resolution column "string"

1 Answers  

---

ORA-25426: remote instance does not support shared dblinks

1 Answers  

---

NNL-00239: Resetting of statistic counters is now disabled

1 Answers  

---

SQL*Loader-00654: Variable length field exceeds maximum length.

1 Answers  

---

RMAN-20221: ambiguous controlfile copy name

1 Answers  

---