|
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; ------> |