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 Bryansk viewed 'How to Shrink a Table in Oracle Database - With Ex' 2 mins ago

A visitor from Hessen viewed 'Oracle NO_INDEX hint: Syntax, Purpose and Example' 13 mins ago

A visitor from Singapore viewed 'Oracle SQL Script to Check Index Fragmentation and' 26 mins ago

A visitor from Mumbai viewed 'SQL Loader bad file vs Discard File: Difference an' 36 mins ago

A visitor from California viewed 'GoldenGate Start Extract Pump Failing / Abending w' 1 hr 48 mins ago

Real-time | Get Script | More Info