Monitoring Server Flash Recovery Area
Monitoring server flash recovery area is advisable to ensure you have enough space for backups.
By default, Oracle Audit Vault Server has the following initialization parameter settings:
-
The
DB_RECOVERY_FILE_DEST_SIZEinitialization parameter is set to 2 GB. -
The
DB_RECOVERY_FILE_DESTinitialization parameter is set to the default flash recovery area, typically the ORACLE_HOME/flash_recovery_area directory.
Ensure that the size of your flash recovery area is large enough to hold a copy of all data files, all incremental backups, online redo logs, archived redo logs not yet backed up on tape, control files, and control file auto backups. This space can fill quickly, depending on the number of audit trails configured, the scope of the audit record collection being administered, and the backup and archive plans that you have in place.
You can use Oracle Enterprise Manager Database Control to monitor the available space in the flash recovery area. Monitor the percent space that is usable in the Usable Flash Recovery Area field under the High Availability section on the Home page. Check the alert log in the Database Console for messages. When the used space in the flash recovery area reaches 85 percent, a warning message is sent to the alert log. When the used space in the flash recovery area reaches 97 percent, a critical warning message is sent to the alert log.
You can manage space in the flash recovery area by increasing the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter to accommodate these files and to set the DB_RECOVERY_FILE_DEST initialization parameter to a value where more disk space is available.