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.