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.

LSX-00171: missing required sub-element "~S"

1 Answers  

---

ORA-07432: unable to perform nested sleep

1 Answers  

---

LPX-00223: external entity "~s" found in an attribute value

1 Answers  

---

RMAN-03009: failure of string command on string channel at string

1 Answers  

---

ORA-02837: Unable to unlink temporary file

1 Answers  

---

ORA-33050: (XSAGDNGL24) AGGMAP workspace object cannot be used to aggregate workspace object, because it is defined in a different analytic workspace.

1 Answers  

---

ORA-13615: The task or object string is greater than the maximum allowable length of 30 characters.

1 Answers  

---

LSX-00238: invalid Nmtoken "~S"

1 Answers  

---

ORA-29280: invalid directory path

1 Answers  

---

RMAN-06113: changed archive log available

1 Answers  

---

DRG-11503: insert statement overflows maximum statement size

1 Answers  

---

ORA-14055: keyword REBUILD in ALTER INDEX REBUILD must immediately follow <index name>

1 Answers  

---