#!/bin/bash
echo -e "\033[32mTime:$(date +%F" "%T)\033[0m"
source ~/.bash_profile
LOG_DIR=$ORACLE_BASE/flash_recovery_area/ORCL/archivelog/
DELETE_DATE=`date '+%Y_%m_%d'`
LOG_NAME=${LOG_DIR}${DELETE_DATE}".log"
echo -e "\033[32mArchive logs begin to clean up.\033[0m"
rman log=$LOG_NAME target / <<EOF
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete noprompt archivelog all completed before 'sysdate-7';
EOF
echo -e "\n"
echo -e "\033[32mArchive logs clean is complete.\033[0m"
echo -e "\033[32mTime:$(date +%F" "%T)\033[0m"