环境:oralce10g x64 ,suse10 x64
发现在日常备份中,rman无法将过期的归档日志备份删除,查相关资料,
delete noprompt backup completed before 'sysdate-2'; 可通过该语句将所有备份记录删除,包括归档日志备份。
整理的脚本如下:
10 20 * * * su - oracle -c "/oracle/script/fullbackup.sh"
10 12 * * * su - oracle -c "/oracle/script/arcbk.sh"
先设置rman备份保留可恢复数据库到前两天的时间;
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 days;
oracle@ciqdb:~/script> cat fullbackup.sh
echo '=======start backup====================================='>>/rmanfs/rmandb.log
date >>/rmanfs/rmandb.log
$ORACLE_HOME/bin/rman target / log /rmanfs/rmandb.log append <<EOF
run {
crosscheck backup;
delete noprompt expired backup device type disk;
allocate channel DISK_2 type disk format '/rmanfs/fulldb_%T_%u';
##backup database include current controlfile ;
backup as compressed backupset
( database include current controlfile );
}
allocate channel for maintenance device type disk;
delete noprompt archivelog until time 'sysdate - 8';
delete noprompt obsolete device type disk;
delete noprompt backup completed before 'sysdate-2';
EOF
date >>/rmanfs/rmandb.log
echo '======stop backup====================================-='>>/rmanfs/rmandb.log
oracle@ciqdb:~/script> cat arcbk.sh
echo '=======start backup====================================='>>/rmanfs/rmanarc.log
date >>/rmanfs/rmanarc.log
$ORACLE_HOME/bin/rman target / log /rmanfs/rmanarc.log append <<EOF
run {
allocate channel DISK_2 type disk format '/rmanfs/arc_%T_%u';
##backup archivelog all not backed up 1 times;
backup as compressed backupset ( archivelog all);
}
allocate channel for maintenance device type disk;
delete noprompt obsolete device type disk;
EOF
date >>/rmanfs/rmanarc.log
echo '======stop backup====================================-='>>/rmanfs/rmanarc.log
oracle@ciqdb:~/script>
发现在日常备份中,rman无法将过期的归档日志备份删除,查相关资料,
delete noprompt backup completed before 'sysdate-2'; 可通过该语句将所有备份记录删除,包括归档日志备份。
整理的脚本如下:
10 20 * * * su - oracle -c "/oracle/script/fullbackup.sh"
10 12 * * * su - oracle -c "/oracle/script/arcbk.sh"
先设置rman备份保留可恢复数据库到前两天的时间;
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 days;
oracle@ciqdb:~/script> cat fullbackup.sh
echo '=======start backup====================================='>>/rmanfs/rmandb.log
date >>/rmanfs/rmandb.log
$ORACLE_HOME/bin/rman target / log /rmanfs/rmandb.log append <<EOF
run {
crosscheck backup;
delete noprompt expired backup device type disk;
allocate channel DISK_2 type disk format '/rmanfs/fulldb_%T_%u';
##backup database include current controlfile ;
backup as compressed backupset
( database include current controlfile );
}
allocate channel for maintenance device type disk;
delete noprompt archivelog until time 'sysdate - 8';
delete noprompt obsolete device type disk;
delete noprompt backup completed before 'sysdate-2';
EOF
date >>/rmanfs/rmandb.log
echo '======stop backup====================================-='>>/rmanfs/rmandb.log
oracle@ciqdb:~/script> cat arcbk.sh
echo '=======start backup====================================='>>/rmanfs/rmanarc.log
date >>/rmanfs/rmanarc.log
$ORACLE_HOME/bin/rman target / log /rmanfs/rmanarc.log append <<EOF
run {
allocate channel DISK_2 type disk format '/rmanfs/arc_%T_%u';
##backup archivelog all not backed up 1 times;
backup as compressed backupset ( archivelog all);
}
allocate channel for maintenance device type disk;
delete noprompt obsolete device type disk;
EOF
date >>/rmanfs/rmanarc.log
echo '======stop backup====================================-='>>/rmanfs/rmanarc.log
oracle@ciqdb:~/script>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29519108/viewspace-1796243/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29519108/viewspace-1796243/