大家好,最近遇到一个比较棘手的问题,不知那位高人能给予指点
oracle 10.2.0.4在solairs下及redhat下都遇到了RMAN无法根据策略自动清理过期备份问题
RMAN的配置
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/oracle/oradata/backup/rman/%d_%F.bak';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/oracle/oradata/backup/rman/%d_data_%T_%U.bak';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/product/10.2.0/db_server/dbs/snapcf_mpaper.f'; # default
备份脚本如下
[oracle@mpaper-db1 ~]$cat /u01/oracle/oradata/backup/rman_backup.sh
#!/bin/sh
. /opt/oracle/.bash_profile
ORACLE_SID=mpaper
export ORACLE_SID
rq=`date +%Y%m%d`
$ORACLE_HOME/bin/rman target / log=/u01/oracle/oradata/backup/rman/MPAPER_bak_$rq.log<
crosscheck archivelog all;
delete noprompt expired archivelog all;
backup database
plus archivelog
format '/u01/oracle/oradata/backup/rman/%d_arc_%