设置的归档目录不在闪回恢复的地方，查闪回目录使用情况没有用。另外需要设置删除归档的定时任务。

1、编辑删除归档日志的脚本----/home/oracle/clearlog.sh

#! /bin/bash
source ~/profile_orcl
#记录归档删除的日志
exec >> /home/rman_log/log/del_arch`date +%F-%H`.log
$ORACLE_HOME/bin/rman target / <<EOF
#检查归档
crosscheck archivelog all;
#列出无效的归档日志
list expired archivelog all;
#删除无效归档
delete noprompt expired archivelog all;
#删除七天前的归档
delete noprompt archivelog until time 'sysdate-7';
#删除所有的归档
#delete noprompt archivelog all;
exit;
EOF

2、修改clearlog.sh脚本的权限及所有者所属组
chown oracle:oinstall clearlog.sh
chmod 775 clearlog.sh

3、以oracle用户设置定时任务
$crontab -e
* * * * * /home/oracle/clearlog.sh

这个方法我也用过，只是物理文件不删除如何能够在执行脚本后自动删除归档日志的操作系统文件？

1、目前配置了定期清理日志的脚本，内容如下：

#!/bin/bash
echo “----------------------------------------`date`---------------------------------------”
source ~/.bash_profile
rman target /<<EOF
CROSSCHECK ARCHIVELOG ALL;
delete noprompt archivelog until time ‘(sysdate-1)’;
DELETE NOPROMPT force archivelog until time ‘(SYSDATE-10)’;
sql ‘BEGIN dbms_backup_restore.resetCfileSection(11); END;’;
exit;
EOF
2、每天定时任务清理后的日志中都有这个信息

正常按照配置应该是昨天的数据应该显示被清理，但是看日志是没有被处理掉的。
3、归档日志的备份频率是周，执行的脚本如下：
#!/bin/bash
echo “----------------------------------------date---------------------------------------”
source ~/.bash_profile
export FILE=“mabak_configandlog”$(date +%Y%m%d%H)
rman target / log /db_bak/configandlog/${FILE}.log<<EOF
run{
CONFIGURE BACKUP OPTIMIZATION ON;
#backup database keep until time ‘sysdate + 7’;
allocate channel c1 type disk;
backup as compressed backupset archivelog all format ‘/db_bak/configandlog/madbArchLog_%d_%T_%s_%p.bak’;
backup spfile format ‘/db_bak/configandlog/madb_SPFILE_%d_%T_%s_%p.bak’;
backup as compressed backupset current controlfile format ‘/db_bak/configandlog/madbconfig_%d_%T_%s_%p_control.bak’;
crosscheck backupset;
delete noprompt expired backupset;
#delete noprompt expired archivelog all;
delete noprompt obsolete;
release channel c1;
}
exit;
EOF
最新的执行日期是20220222，但是日志中还是存在
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madbArchLog_MAEASDB_20220122_22_1.bak RECID=20 STAMP=1094605204
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madbArchLog_MAEASDB_20220122_23_1.bak RECID=21 STAMP=1094605330
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madbArchLog_MAEASDB_20220122_24_1.bak RECID=22 STAMP=1094605465
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madbArchLog_MAEASDB_20220124_27_1.bak RECID=25 STAMP=1094846312
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madbArchLog_MAEASDB_20220129_30_1.bak RECID=28 STAMP=1095210003
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madbArchLog_MAEASDB_20220201_33_1.bak RECID=31 STAMP=1095469204
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madbArchLog_MAEASDB_20220208_36_1.bak RECID=34 STAMP=1096074004
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madbArchLog_MAEASDB_20220208_37_1.bak RECID=35 STAMP=1096074119
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madbArchLog_MAEASDB_20220208_38_1.bak RECID=36 STAMP=1096074245
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madbArchLog_MAEASDB_20220215_41_1.bak RECID=39 STAMP=1096678803
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madb_SPFILE_MAEASDB_20220215_42_1.bak RECID=40 STAMP=1096678909
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madbconfig_MAEASDB_20220215_43_1_control.bak RECID=41 STAMP=1096678911
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madbArchLog_MAEASDB_20220222_44_1.bak RECID=42 STAMP=1097283604
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madbArchLog_MAEASDB_20220222_45_1.bak RECID=43 STAMP=1097283739
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madb_SPFILE_MAEASDB_20220222_46_1.bak RECID=44 STAMP=1097283875
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/db_bak/configandlog/madbconfig_MAEASDB_20220222_47_1_control.bak RECID=45 STAMP=1097283877
Crosschecked 16 objects

specification does not match any backup in the repository
4、rman的设置如下