How to Disable the Flash Recovery Area?

Document ID : KB000050849
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When the flash recovery area is enabled in Oracle, it generates a numerous benign error messages in the alert_<SID>.log file that make it difficult to read through and could trigger false alarms for customers. This solution describes how to disable the flash recovery area.

Solution:

To disable the flash recovery area, use this SQL*Plus statement to change the settings on a running database:

ALTER DATABASE FLASHBACK OFF;  

The database will no longer provide the space management features of the flash recovery area for the files stored in the old DB_RECOVERY_FILE_DEST location.