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 Hamburg viewed 'DBMS_SCHEDULER. Create_job Fails with ORA-06512 OR' 36 secs ago

A visitor from Encamp viewed 'Fix RMAN-03009 ORA-00245 RMAN-08132 control file b' 15 mins ago

A visitor from Bengaluru viewed 'Export and Create Excel File from Oracle SQL Query' 54 mins ago

A visitor from India viewed 'Error in invoking target ‘mkldflags ntcontab.o nnf' 1 hr 5 mins ago

A visitor from Kerala viewed 'Oracle SQL Script to Check Index Fragmentation and' 1 hr 57 mins ago

Real-time | Get Script | More Info