ORA-19815: WARNING: db_recovery_file_dest_size 

ORA-19815

Errors in file /oracle12.2/diag/rdbms/KARDB/KARDB/trace/KARDB_m000_25197.trc:

ORA-19815: WARNING: db_recovery_file_dest_size of 3221225472000 bytes is 92.44% used, and has 243602825216 remaining bytes available.

PURPOSE: All documents are provided on this Blog just for educational purposes only.  Please make sure that you run it in your test environment before to move on to production environment. 

col NAME format a30

select substr(name, 1, 30) name, round(space_limit/1024/1024/1024, 1) quota_gb, round(space_used/1024/1024/1024, 1) used_gb, round(space_reclaimable/1024/1024/1024, 1) reclaimable_gb, number_of_files files from v$recovery_file_dest; 

NAME                             QUOTA_GB    USED_GB RECLAIMABLE_GB      FILES
------------------------------ ---------- ---------- -------------- ----------

/fast_recovery_area                  3000       2068              0       1338

SELECT FILE_TYPE "Type", PERCENT_SPACE_USED "% Used", PERCENT_SPACE_RECLAIMABLE "% Reclaim", NUMBER_OF_FILES "# Files" FROM V$FLASH_RECOVERY_AREA_USAGE;

Solution;

rman target /
RMAN> crosscheck archivelog all;

RMAN> delete expired archivelog all;

or via script:

more delete_archivelog_KARDB.sh

#!/bin/bash
date '+%Y-%m-%d  %H:%M:%S'

. setdb_home KARDB
export NLS_DATE_FORMAT='yyyy/mm/dd hh24:mi:ss'
rman target / <<EOF
crosscheck archivelog all;
delete force noprompt archivelog all completed before 'sysdate - 5';
#delete force noprompt expired archivelog all;
EOF
date '+%Y-%m-%d  %H:%M:%S'
cd /fast_recovery_area/KARDB/archivelog

find /fast_recovery_area/KARDB/archivelog/* -type d -empty -print -exec rm -r {} \;

As cronJob:

35 * * * * /script/delete_archivelog_KARDB.ksh > /script/log/delete_archivelog_KARDB.log.$(date +\%Y-\%m-\%d--\%H-\%M) 2>&1