已索引

$ mkdir /home/oracle/tool
$ touch /home/oracle/tool/rman_delete_arch.sh
$ chmod +x /home/oracle/tool/rman_delete_arch.sh

$ crontab -e oracle
0 * * * * /home/oracle/tool/rman_delete_arch.sh >/dev/null 2>&1 &

$ vi /home/oracle/tool/rman_delete_arch.sh
#!/bin/bash

####################################################################
# if with backup and dataguard, primary site should config rman with:
#     CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE' APPLIED ON ALL STANDBY;
#     DELETE NOPROMPT ARCHIVELOG ALL;
# else in standby site
#     CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
#     DELETE NOPROMPT ARCHIVELOG ALL;
# else
#     DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
####################################################################

source /home/oracle/.bash_profile
LOG_DIR=/home/oracle/tool
RMAN_LOG_FILE=$LOG_DIR/delete_arch.log
export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

rman target / >> $RMAN_LOG_FILE << EOF
DELETE NOPROMPT ARCHIVELOG ALL;
exit
EOF