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-01106: database must be closed before dismounting

1 Answers  

---

ORA-09367: Windows 3.1 Two-Task driver unable to deallocate shared memory

1 Answers  

---

UDI-00015: invalid context or job state for parameter, 'string'.

1 Answers  

---

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

1 Answers  

---

ORA-25352: no current transaction

1 Answers  

---

ORA-22997: VARRAY | OPAQUE stored as LOB is not specified at the table level

1 Answers  

---

ORA-31414: error(s) occurred during change table advance

1 Answers  

---

ORA-14075: partition maintenance operations may only be performed on partitioned indices

1 Answers  

---

ORA-07637: smsdbp: buffer protect option not specified when sga created

1 Answers  

---

NNO-00253: administrative region parameter string length string exceeds maximum of string

1 Answers  

---

RMAN-06507: trying alternate file for archivelog thread number, sequence number

1 Answers  

---

ORA-19001: Invalid storage option specified

1 Answers  

---