Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-38709: Recovery Area is not enabled.
- 3 Answers
- 23624 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
QSM-02001: clustered mv container table
CLSR-00504: Error number encountered when posting an EVM event
ORA-33454: (ESDREAD07) Discarding compiled code for workspace object because number is now string workspace object, whereas it was string workspace object when the code was compiled.
ORA-33050: (XSAGDNGL24) AGGMAP workspace object cannot be used to aggregate workspace object, because it is defined in a different analytic workspace.
QSM-01077: materialized view, string, is grouping at a higher level than query
TNS-00112: Failed to find configuration file name
ORA-13858: Invalid action name
ORA-23490: extension request "string" with status "string" not allowed in this operation
KUP-11003: bad data encountered while reading from file string
IMG-00902: VIR signature free failed
ORA-00344: unable to re-create online log 'string'
ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.
Oracle Errors 
