|
此时list backupset 280 就看不到Keep: LOGS Until: FOREVER 的痕迹了。
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
280 Full 349.29M DISK 00:01:54 15-DEC-14
BP Key: 283 Status: AVAILABLE Compressed: NO Tag: TAG20141215T212732
Piece Name: /home/oracle/keep_test_0spq8ni4_1_1
List of Datafiles in backup set 280
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 356820 15-DEC-14 /u01/app/oracle/oradata/PROD/disk1/system01.dbf
2 Full 356820 15-DEC-14 /u01/app/oracle/oradata/PROD/disk1/undotbs01.dbf
3 Full 356820 15-DEC-14 /u01/app/oracle/oradata/PROD/disk1/sysaux01.dbf
4 Full 356820 15-DEC-14 /u01/app/oracle/oradata/PROD/disk1/example_1.dbf
5 Full 356820 15-DEC-14 /u01/app/oracle/oradata/PROD/disk1/indx_1.dbf
6 Full 356820 15-DEC-14 /u01/app/oracle/oradata/PROD/disk1/tools_1.dbf
7 Full 356820 15-DEC-14 /u01/app/oracle/oradata/PROD/disk1/users_1.dbf
8 Full 356820 15-DEC-14 /u01/app/oracle/oradata/PROD/disk1/oltp_1.dbf
9 Full 356820 15-DEC-14 /u01/app/oracle/oradata/PROD/disk1/r_1.dbf
-----------------------下面再来report obsolete redundancy 1; ------------------------------------------
RMAN> report obsolete redundancy 1;
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
Bac |