# 切換至oracle用戶
su – oracle

# 使用RMAN工具，刪除失效的歸檔日志
rman

# 使用target命令連接本地數據庫
RMAN> connect target /

RMAN> crosscheck archivelog all;

# 刪除狀態為expired（失效/不可用）的歸檔日志
RMAN> delete expired archivelog all;

# 刪除 3 天前的歸檔日志：
RMAN> delete archivelog all completed before 'sysdate-3';
# 刪除 1 天前
RMAN> delete archivelog until time 'sysdate-1'

# 退出RMAN
RMAN> exit

#!/bin/bash
BACK_DIR=/home/oracle/clear_archlog/data
export DATE=`date +%F`
mkdir -p $BACK_DIR/$DATE
touch $BACK_DIR/$DATE/rman_backup.log
echo "--------------------------------`date`-------------------------------"
source ~/.bash_profile 
# 記錄日志rman_backup.log 可以后期檢查是否執行成功
rman target / >> $BACK_DIR/$DATE/rman_backup.log <<EOF             
# 把無效的expired的archivelog標出來
crosscheck archivelog all;
# 直接全部刪除過期的歸檔日志
#delete noprompt expired archivelog all;
# 直接刪除7天前所有的歸檔日志
delete noprompt archivelog all completed before 'sysdate-7';
exit
EOF
echo -e "\n"
echo "------------------------------ FINISHED ----------------------------"

#授予執行權限
chmod +x archivelog_clear.sh

./archivelog_clear.sh

30 3 15 * *   /home/oracle/archivelog_clear.sh

crontab -l