My Oracle Support Banner

No Alert From Enterprise Manager When Fast Recovery Area Filled Up (Doc ID 2607051.1)

Last updated on NOVEMBER 21, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 13.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

No incident triggered by Enterprise Manager when the metric fast recovery area filled up.

The error in the alert log.

2019-10-21T17:26:44.675874-05:00
Errors in file <ORACLE_DB_HOME>/diag/rdbms/<DB_NAME>/trace/<DB_NAME>_arc0_nn.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 4972498386944 bytes is 100.00% used, and has 0 remaining bytes available.
2019-10-21T17:26:44.675968-05:00
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
  then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
  BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
  reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
  system command was used to delete files, then use RMAN CROSSCHECK and
  DELETE EXPIRED commands.
************************************************************************

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.