问题是这样的。我们有一套数据库,大概4t的数据库量。rman备份到本地文件系统,因为挂载的存储空间有限,每周六晚做一次全备后,上一次的全备就应该删除。
配置了rman的脚本为:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
之前一直运行正常,但这周一(即8月10日)早上检查,发现8.8及8.1的备份都在,文件系统使用率95%。
rman target /
RMAN> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/dbbackup/arch/arch_bak_0jqdi08m_1_1_20150802 RECID=1091 STAMP=886636824
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/dbbackup/arch/arch_bak_0lqdieb9_1_1_20150802 RECID=1093 STAMP=886651245
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/dbbackup/db/db_GDORDB_0hqdhr04_1_1_20150801_886631428_1.bk RECID=1095 STAMP=886631443
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/dbbackup/db/db_GDORDB_0hqdhr04_2_1_20150801_886631428_2.bk RECID=1096 STAMP=886636045
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/dbbackup/db/db_GDORDB_0hqdhr04_3_1_20150802_886631428_3.bk RECID=1097 STAMP=886639956
crosschecked backup piece: found to be 'AVAILABLE'
...........................
20150801、20150802这些数据库都是AVAILABLE
然后:RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found
既然是AVAILABLE,删除不了也就不奇怪了。
在文件系统里面查询
oracle@rcs_subsdb1:/backup/dbbackup/db> ls -l
total 6940373907
-rw-r--r-- 1 oracle oinstall 33 May 20 09:56 abc.sh
-rw-r----- 1 oracle asmadmin 46399488 Aug 10 08:01 controlfile_c-4132661331-20150810-02
-rw-r----- 1 oracle asmadmin 314572800000 Aug 1 23:47 db_GDORDB_0hqdhr04_1_1_20150801_886631428_1.bk
-rw-r----- 1 oracle asmadmin 314572800000 Aug 2 00:52 db_GDORDB_0hqdhr04_2_1_20150801_886631428_2.bk
-rw-r----- 1 oracle asmadmin 314572800000 Aug 2 02:12 db_GDORDB_0hqdhr04_3_1_20150802_886631428_3.bk
-rw-r----- 1 oracle asmadmin 314572800000 Aug 2 03:14 db_GDORDB_0hqdhr04_4_1_20150802_886631428_4.bk
...........................
20150801晚上备份的数据都有。
为什么我配置rman REDUNDANCY为1,它还要给我保存多余一份全备呢?
求大神协助解决。