Whenever there is a long running job that generates more archived logs than usual, the Fast Recovery Area gets full.
select space_limit/1024/1024/1024 ||
‘GB space allocated; ‘ ||
‘GB space used; ‘||
round((space_limit – space_used)/1024/1024/1024) ||
‘GB space left; ‘ ||
round(space_used/space_limit * 100) ||
‘ pct used’
200GB space allocated; 180GB space used; 20GB space left; 90 pct used
In order to clear space in the Fast Recovery Area, back up the archived logs and then delete them:
rman>backup archivelog all;
rman>DELETE archivelog until time “sysdate-1/24” backed up 1 times to device type disk;
This command deletes all the archived logs that have been backed up up until an hour ago. Alternatively, you can just say until time “sysdate” and it will delete all of the logs that have been backed up to now.