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-02722: osnpui: cannot send break message to orapop

1 Answers  

---

SQL*Loader-00131: Invalid multithreading option

1 Answers  

---

PLS-01473: Use <> instead of != or ~=

1 Answers  

---

ORA-29955: error occurred in the execution of ODCIINDEXEXCHANGEPARTITION routine

1 Answers  

---

AMD-00136: Generation of SQL script "string" failed

1 Answers  

---

RMAN-06902: AS COMPRESSED BACKUPSET option cannot be used when backing up backupsets

1 Answers  

---

ORA-30738: object "string" does not exist in schema "string"

1 Answers  

---

ORA-28047: database is not a member of any enterprise domain in OID

1 Answers  

---

NNL-00901: CONTENT ERROR responses sent: number

1 Answers  

---

ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables

1 Answers  

---

NNL-01001: NAME EXISTS responses received: number

1 Answers  

---

ORA-29886: feature not supported for domain indexes

1 Answers  

---