Alert.log Show On Logical Standby Database Shows ORA-19815 yet V$flash_recovery_area_usage Shows 0% Usage (Doc ID 1512471.1)

Last updated on SEPTEMBER 12, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Goal

At standby site, in a logical standby environment, the alert.log shows repeatedly the following message:

  ORA-19815: WARNING: db_recovery_file_dest_size of 34359738368 bytes is 100.00% used, and has 0 remaining bytes available. 

 Yet query of v$flash_recovery_area_usage shows:

FILE_TYPE            PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE                          0                         0               0
REDO LOG                              0                         0               0
ARCHIVED LOG                          0                         0               0
BACKUP PIECE                          0                         0               0
IMAGE COPY                            0                         0               0
FLASHBACK LOG                         0                         0               0
FOREIGN ARCHIVED LOG                  0                         0               0

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms