How to disable flash recovery area of existing open Oracle (10g, 11g) database?

advertisements

_____________________________________________________________________________________________________________________

Flash recovery area can be disabled by setting DB_RECOVERY_FILE_DEST initialization parameter to a null value.

Connect to SQL*Plus as sys as sysdba and issue following command to disable the flash recover area.

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='' SCOPE=BOTH SID="*";

Once you disable the flash recovery area, the database will not provide any space management features of the flash recovery area for the files stored in the DB_RECOVER_FILE_DEST location. The existing files still can be accessible for the RMAN for backup and recovery purpose.

How to add Flash Recovery Area to an Existing Database?
How to check flash recovery area USAGE?

_____________________________________________________________________________________________________________________

Live Traffic Feed

A visitor from Newtownabbey viewed 'SQL Query to Find Out Oracle Session Details for a' 31 mins ago

A visitor from Kukes viewed 'Oracle Sequence Cycle vs Nocycle Difference and Co' 34 mins ago

A visitor from Singapore viewed 'Data Pump EXPDP IMPDP EXCLUDE and INCLUDE Options ' 1 hr 27 mins ago

A visitor from Singapore viewed 'Data Pump EXPDP IMPDP EXCLUDE and INCLUDE Options ' 1 hr 37 mins ago

A visitor from San francisco viewed 'RMAN Restore Failed RMAN-06100: no channel to rest' 2 hrs 4 mins ago

Real-time | Get Script | More Info