Recovery Area Free Space (%)

Description

This is a database-level metric. For cluster databases, this metric is monitored at the cluster database target level and not by member instances.

This metric is evaluated by the server periodically every 15 minutes or during a file creation, whichever occurs first. It is also printed in the alert log. The Critical Threshold is set for <3% and the Warning Threshold is set for <15%. It is not user-customizable. The user is alerted the first time the alert occurs, and the alert is not cleared until the available space rises above 15%.

Data Source

Not available

User Action

To free up space from the Flash Recovery Area, follow these steps:

  1. Consider changing your RMAN retention policy. If you are using dataguard, then consider changing your RMAN archivelog deletion policy.

  2. Back up files to a tertiary device, such as tape using the RMAN command BACKUP RECOVERY AREA.

  3. Add disk space and increase the db_recovery_file_dest_size parameter to reflect the new space.

  4. Delete unncessary files using the RMAN DELETE command. If an OS command was used to delete files, then use RMAN CROSSCHECK and DELETE EXPIRED commands.

Related Topics

About Alerts

About the Metric Detail Page

Editing Thresholds

Understanding Line Charts