1、删除主库归档日志

1.1、backup_oracle.bat

rman target / cmdfile=D:/backup/rman/backup_db.rman
log=d:/backup/rman/logfile/rmanlog%date:~0,4%%date:~5,2%%date:~8,2%.log

1.2、 backup_db.rman

CONFIGURE RETENTION POLICY TO REDUNDANCY=2;
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
backup filesperset = 5 as compressed backupset database format 'd:/backup/rman/full_%U.rman';
sql 'alter system archive log current';
backup filesperset = 50 as compressed backupset archivelog all format 'd:/backup/rman/arch_%U.rman' delete input;
DELETE noprompt OBSOLETE;
crosscheck backup;
delete noprompt expired backup;
backup format 'd:/backup/rman/ctl_%U.rman' current controlfile;
backup spfile format 'd:/backup/rman/spfile_%U.rman';
exit;
backup_oracle.bat

2、删除备库归档日志

2.1、delete_dg_archivelog.bat

cd D:\scripts
d:
echo delete archivelog staring>delete_archivelog.bak
sqlplus / as sysdba @delete_archive.sql
echo rman target / cmdfile=rman_checkcross.rman>>delete_archivelog.bat
delete_archivelog.bat>>delete_dg_archivelog_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%".log
exit

2.2、delete_archive.sql

set line 150
col name for a150
set pagesize 0 feedback off verify off heading off echo off
spool delete_archivelog.bat
select 'del '||name from v$archived_log where APPLIED='YES' AND NAME IS NOT NULL AND DEST_ID=1;
spool off
exit;

2.3、rman_checkcross.rman

crosscheck archivelog all;
delete noprompt expired archivelog all;
exit
delete_dg_archivelog.bat