backup命令中的keepforever关键字会屏蔽rman的retentionpolicy(十)

2015-07-24 10:51:33 · 作者: · 浏览: 23
te的备份。 Report of obsolete backups and copies Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Backup Set 59 20-NOV-14 Backup Piece 77 20-NOV-14 /u01/app/oracle/product/10.2.0/db_1/dbs/01po49gn_1_1 Backup Set 60 20-NOV-14 Backup Piece 78 20-NOV-14 /home/oracle/back/db_PROD_20141120 Backup Set 61 20-NOV-14 Backup Piece 79 20-NOV-14 /u01/app/oracle/product/10.2.0/db_1/dbs/03po49ji_1_1 Backup Set 62 20-NOV-14 Backup Piece 80 20-NOV-14 /home/oracle/back/c-275920358-20141120-00 Backup Set 63 20-NOV-14 Backup Piece 81 20-NOV-14 /home/oracle/back/arch_PROD_864169010 Backup Set 64 20-NOV-14 Backup Piece 82 20-NOV-14 /home/oracle/back/db_PROD_864169015 Backup Set 65 20-NOV-14 Backup Piece 83 20-NOV-14 /home/oracle/back/arch_PROD_864169124 Backup Set 66 20-NOV-14 Backup Piece 84 20-NOV-14 /home/oracle/back/c-275920358-20141120-01 Backup Set 67 20-NOV-14 Backup Piece 85 20-NOV-14 /home/oracle/back/arch_PROD_864171704 Backup Set 68 20-NOV-14 Backup Piece 86 20-NOV-14 /home/oracle/back/db_PROD_864171708 Backup Set 69 20-NOV-14 Backup Piece 87 20-NOV-14 /home/oracle/back/arch_PROD_864171816 Backup Set 70 20-NOV-14 Backup Piece 88 20-NOV-14 /home/oracle/back/c-275920358-20141120-02 Backup Set 71 20-NOV-14 Backup Piece 89 20-NOV-14 /home/oracle/back/arch_PROD_20141120 Backup Set 72 20-NOV-14 Backup Piece 90 20-NOV-14 /home/oracle/back/arch_0hpo4dvs_1_1 Backup Set 73 20-NOV-14 Backup Piece 91 20-NOV-14 /home/oracle/back/db_0ipo4dvu_1_1 Backup Set 74 20-NOV-14 Backup Piece 92 20-NOV-14 /home/oracle/back/arch_0jpo4e39_1_1 Backup Set 75 20-NOV-14 Backup Piece 93 20-NOV-14 /home/oracle/back/c-275920358-20141120-03 Backup Set 76 23-NOV-14 Backup Piece 94 23-NOV-14 /home/oracle/back/c-275920358-20141123-00 Backup Set 195 26-NOV-14 Backup Piece 200 26-NOV-14 /home/oracle/backup/0mpojm4e_1_1 Backup Set 196 26-NOV-14 Backup Piece 201 26-NOV-14 /home/oracle/backup/0npojm4j_1_1 Backup Set 197 26-NOV-14 Backup Piece 202 26-NOV-14 /home/oracle/backup/0opojm6u_1_1 Backup Set 222 26-NOV-14 Backup Piece 224 26-NOV-14 /home/oracle/backup/0ppojm71_1_1 Backup Set 232 26-NOV-14 Backup Piece 234 26-NOV-14 /home/oracle/backup/control/c-275920358-20141126-00 Backup Set 269 26-NOV-14 Backup Piece 272 26-NOV-14 /home/oracle/backup/control/c-275920358-20141126-01 Backup Set 298 15-DEC-14 Backup Piece 308 15-DEC-14 /home/oracle/backup/control/c-275920358-20141215-00 Backup Set 377 15-DEC-14 Backup Piece 391 15-DEC-14 /home/oracle/backup/control/c-275920358-20141215-01 Backup Set 411 16-DEC-14 Backup Piece 414 16-DEC-14 /home/oracle/full_after_keep_10pq96j9_1_1 ---------->
多了此行,此行就是“备份的开始时间是:20141216T014409”的这个备份,而该备份是在那个keep备份之后的备份。既然keep备份之后的备份都报 obsolete了,而keep的备份却没有报obsolete,这说明keep forever 屏蔽了rman的retention policy。 Backup Set 434 16-DEC-14 Backup Piece 444 16-DEC-14 /home/oracle/backup/control/c-275920358-20141216-00 RMAN> ------------------下面说明将此keep forever的备份 变为obsolete的方法:-------------------------------------------------------- RMAN> change backupset 280 nokeep; allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=290 devtype=DISK keep attributes for the backup are deleted backup set key=280 recid=25 stamp=866410166 RMAN> list backupset 280; ------>