ORA – 19809 & ORA – 19804

DESCRIPTION:

In this article, we are going to see how to resolve ORA – 19809 & ORA – 19804.

CAUSE:

By default RMAN backup goes to Flash Recovery Area if it is set. In case its not able to make more space and required space exceeds the limit of flash recovery area then its fails with those error message.Its because of the FRA’s space limit.we can check and to determine the disk quota and current disk usage in the flash recovery area, query the view

V$RECOVERY_FILE_DEST.

SOLUTION:

We need to increase the size of FRA (Flash Recovery Area) even if the space is not available on the disk:

ALTER SYSTEM SET db_recovery_file_dest_size=200G SCOPE=BOTH ;