Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-38709: Recovery Area is not enabled.

Answers were Sorted based on User's Feedback



ORA-38709: Recovery Area is not enabled...

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

Is This Answer Correct ?    6 Yes 2 No

ORA-38709: Recovery Area is not enabled...

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

Is This Answer Correct ?    2 Yes 2 No

ORA-38709: Recovery Area is not enabled...

Answer / ajit tripathi

Everything will be same as above only path for fra will be inverted comas.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07601: spguno: $GETJPIW failure

1 Answers  


RMAN-06102: no channel to restore a backup or copy of log thread number seq number lowscn string

1 Answers  


ORA-15036: disk 'string' is truncated

1 Answers  


AUD-00704: invalid input format

1 Answers  


NNO-00266: cannot find document "string" in configuration database

1 Answers  


ORA-12842: Cursor invalidated during parallel execution

2 Answers   ACC,


DRG-12013: This method has already been performed - repeat operation?

1 Answers  


ORA-12495: cannot disable an enabled level, category, or release category

1 Answers  


SQL*Loader-00566: partial record found at end of datafile

1 Answers  


ORA-16701: generic resource guard request failed

1 Answers  


PROC-00007: Cannot perform cluster registry operation because key handle is invalid.

1 Answers  


ORA-39111: Dependent object type string skipped, base object type string already exists

1 Answers  


Categories