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.

ORA-38492: invalid ALTER INDEX parameters clause "string"

1 Answers  

---

RMAN-06564: must use the TO clause when the instance is started with SPFILE

1 Answers  

---

ORA-01218: logfile member is not from the same point-in-time

1 Answers  

---

ORA-26516: no push transaction acknowledgement

1 Answers  

---

ORA-36644: (XSDUNION07) Concat dimension workspace object contains a previously detected leaf dimension.

1 Answers  

---

ORA-02485: Invalid _trace_options parameter specification (string)

1 Answers  

---

ORA-36968: (XSRELTBL11) workspace object must be a relation.

1 Answers  

---

NNL-00917: Artificial request processing delay: string

1 Answers  

---

PCC-02104: Unable to connect to Oracle

1 Answers  

---

RMAN-08508: archive log destination=string

1 Answers  

---

DRG-52110: error in writing extended knowledge base

1 Answers  

---

NNC-00413: general failure

1 Answers  

---