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 Moscow viewed 'How to Recover the Oracle 10g 11g Database from RM' 16 mins ago

A visitor from Alabama viewed 'Golden Gate ggsci start manager: ERROR: Parameter ' 16 mins ago

A visitor from Kerala viewed 'ORA-00059: maximum number of DB_FILES exceeded - F' 1 hr 19 mins ago

A visitor from Phnom penh viewed 'FIX RMAN-11001 ORA-01547 "warning: RECOVER succeed' 2 hrs 22 mins ago

A visitor from Nagpur viewed 'RMAN-08591: WARNING: invalid archived log deletion' 3 hrs 57 mins ago

Real-time | Get Script | More Info