ORA-19815 Recovery File Size

Problem:

ORA-19815: WARNING: db_recovery_file_dest_size of 5218762752 bytes is 99.46% used, and has 28102144 remaining bytes available.

Solution (if you have available disk space):

alter system set db_recovery_file_dest_size=<size>; 

Query to show the size of the recovery area and how full.

set lines 100
col name format a60
select	name
,	floor(space_limit / 1024 / 1024) "Size MB"
,	ceil(space_used  / 1024 / 1024) "Used MB"
from	v$recovery_file_dest
order by name