os : Redhat5.5
db:Oracle 11.2.0.1
问题:备份策略,把当天备份的备份集删除了!有遇到过这问题的吗?
贴下rman脚本,以及日志
--保留策略为7天
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name HNCCS_PR are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
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 MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/product/11.2.0/db_1/dbs/snapcf_hnccs.f'; # default
--备份脚本
[oracle@ccsdb1 run]$ cat rman_bak.sh
#!/bin/bash
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=hnccs
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
WEEK_DAILY=`date +%a`
BAK_LEVEL=0
# echo $week_day
case "$WEEK_DAILY" in
"Mon")
BAK_LEVEL=2
;;
"Tue")
BAK_LEVEL=2
;;
"Wed")
BAK_LEVEL=2
;;
"Thu")
BAK_LEVEL=1
;;
"Fri")
BAK_LEVEL=2
;;
"Sat")
BAK_LEVEL=2
;;
"Sun")
BAK_LEVEL=0
;;
"*")
BAK_LEVEL=error
esac
rman target /log=/syjkccs/log/rman_log/log_`date +%Y%m%d%H%M`.log<
run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup as compressed backupset incremental level $BAK_LEVEL filesperset 5 database format '/backup/
bak_lev"$BAK_LEVEL"_%U_%T';
sql 'alter system archive log current';
backupfilesperset 20 archivelog alltag='arc_bak' format '/backup/arch_lev"$BAK_LEVEL"_%U_%T';
backup current controlfile tag='ctl_bak' format '/backup/ctl_lev"$BAK_LEVEL"_%U_%T';
backup spfile tag='spfile' format '/backup/spfile_lev"$BAK_LEVEL"_%U_%T';
release channel c1;
release channel c2;
release channel c3;
}
delete noprompt obsolete;
crosscheck archivelog all;
delete noprompt archivelog until time 'sysdate-5';
EOF
exit
--日志中删除当日备份的记录(日志太长了,只贴出了删除过期备份的一部分)
RMAN>
RMAN>
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=819 device type=DISK
Deleting the following obsolete backups and copies:
TypeKey Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 61 10-JUL-13
Backup Piece 61 10-JUL-13 /backup/ctl_lev"2"_22oebs6b_1_1_0710
Backup Set 64 11-JUL-13
Backup Piece 64 11-JUL-13 /backup/bak_lev"1"_27oeega1_1_1_0711
Backup Set 142 18-JUL-13
Backup Piece 142 18-JUL-13 /backup/bak_lev"1"_4lof0utp_1_1_0718
Backup Set 150 18-JUL-13
Backup Piece 150 18-JUL-13 /backup/spfile_lev"1"_4rof0v8p_1_1_0718
deleted backup piece
backup piece handle=/backup/ctl_lev"2"_22oebs6b_1_1_0710 RECID=61 STAMP=820375756
deleted backup piece
backup piece handle=/backup/bak_lev"1"_27oeega1_1_1_0711 RECID=64 STAMP=820461890
deleted backup piece
backup piece handle=/backup/bak_lev"1"_4lof0utp_1_1_0718 RECID=142 STAMP=821066681
deleted backup piece
backup piece handle=/backup/spfile_lev"1"_4rof0v8p_1_1_0718 RECID=150 STAMP=821067033
Deleted 4 objects
----这里可以看出来,删除了日期为0718的备份,在系统上也查看了不存在这几个备份集