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.

NNL-00210: Cache checkpointing is currently disabled

1 Answers  

---

ORA-26098: direct path context is not prepared

1 Answers   IBM,

---

RMAN-06109: changed archive log unavailable

1 Answers  

---

ORA-12534: TNS:operation not supported

1 Answers  

---

ORA-01688: unable to extend table string.string partition string by string in tablespace string

1 Answers  

---

NID-00603: No datafiles found in database

1 Answers  

---

SQL*Loader-00945: record size number too large for direct path

1 Answers  

---

ORA-04016: sequence string no longer exists

1 Answers  

---

ORA-06039: NETDNT: connect failed

1 Answers  

---

QSM-01007: query has NOREWRITE hint

1 Answers  

---

ORA-08206: ora_addr: cannot translate address file name

1 Answers  

---

QSM-02084: DISTINCT clause on a duplicate sensitive aggregate function

1 Answers  

---