ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
How to Disable the Flash Recovery Area?
Article ID: 50849
Updated On:
Products
CA eHealth
Issue/Introduction
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.
Environment
Release:
Component: EHORA
Component: EHORA
Feedback
Yes
No
Powered by
