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

2015-07-24 10:51:33 · 作者: · 浏览: 25
kup/control/c-275920358-20141126-00 Control File Included: Ckp SCN: 284520 Ckp time: 26-NOV-14 SPFILE Included: Modification time: 26-NOV-14 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 269 Full 6.58M DISK 00:00:02 26-NOV-14 BP Key: 272 Status: AVAILABLE Compressed: NO Tag: TAG20141126T184247 Piece Name: /home/oracle/backup/control/c-275920358-20141126-01 Control File Included: Ckp SCN: 284938 Ckp time: 26-NOV-14 SPFILE Included: Modification time: 26-NOV-14 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 Keep: LOGS Until: FOREVER -------------------------------------------------------------->注意此行!!! 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 BS Key Type LV Size Device Type Elapsed Time Completi
on Time ------- ---- -- ---------- ----------- ------------ --------------- 298 Full 6.58M DISK 00:00:01 15-DEC-14 BP Key: 308 Status: AVAILABLE Compressed: NO Tag: TAG20141215T212929 Piece Name: /home/oracle/backup/control/c-275920358-20141215-00 Control File Included: Ckp SCN: 356856 Ckp time: 15-DEC-14 SPFILE Included: Modification time: 15-DEC-14 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 355 11.60M DISK 00:00:02 15-DEC-14 BP Key: 358 Status: AVAILABLE Compressed: NO Tag: TAG20141215T213153 Piece Name: /home/oracle/arc_back_after_keep_0upq8nq9_1_1 List of Archived Logs in backup set 355 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 21 284502 26-NOV-14 305116 01-DEC-14 1 22 305116 01-DEC-14 356141 15-DEC-14 1 23 356141 15-DEC-14 356890 15-DEC-14 1 24 356890 15-DEC-14 356892 15-DEC-14 1 25 356892 15-DEC-14 356894 15-DEC-14 1 26 356894 15-DEC-14 356897 15-DEC-14 1 27 356897 15-DEC-14 356899 15-DEC-14 1 28 356899 15-DEC-14 356901 15-DEC-14 1 29 356901 15-DEC-14 356903 15-DEC-14 1 30 356903 15-DEC-14 356905 15-DEC-14 1 31 356905 15-DEC-14 356907 15-DEC-14 1 32 356907 15-DEC-14 356909 15-DEC-14 1 33 356909 15-DEC-14 356957 15-DEC-14 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 377 Full 6.58M DISK 00:00:00 15-DEC-14 BP Key: 391 Status: AVAILABLE Compressed: NO Tag: TAG20141215T213157 Piece Name: /home/oracle/backup/control/c-275920358-20141215-01 Control File Incl