backup命令中的keepforever关键字会屏蔽rman的retentionpolicy(五)
data/PROD/disk1/sysaux01.dbf
4 Full 234104 20-NOV-14 /u01/app/oracle/oradata/PROD/disk1/example_1.dbf
5 Full 234104 20-NOV-14 /u01/app/oracle/oradata/PROD/disk1/indx_1.dbf
6 Full 234104 20-NOV-14 /u01/app/oracle/oradata/PROD/disk1/tools_1.dbf
7 Full 234104 20-NOV-14 /u01/app/oracle/oradata/PROD/disk1/users_1.dbf
8 Full 234104 20-NOV-14 /u01/app/oracle/oradata/PROD/disk1/oltp_1.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
65 2.50K DISK 00:00:01 20-NOV-14
BP Key: 83 Status: AVAILABLE Compressed: NO Tag: TAG20141120T225844
Piece Name: /home/oracle/back/arch_PROD_864169124
List of Archived Logs in backup set 65
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 11 234100 20-NOV-14 234133 20-NOV-14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
66 Full 6.58M DISK 00:00:03 20-NOV-14
BP Key: 84 Status: AVAILABLE Compressed: NO Tag: TAG20141120T225846
Piece Name: /home/oracle/back/c-275920358-20141120-01
Control File Included: Ckp SCN: 234139 Ckp time: 20-NOV-14
SPFILE Included: Modification time: 20-NOV-14
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
67 25.15M DISK 00:00:03 20-NOV-14
BP Key: 85 Status: AVAILABLE Compressed: NO Tag: TAG20141120T234144
Piece Name: /home/oracle/back/arch_PROD_864171704
List of Archived Logs in backup set 67
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6 224560 20-NOV-14 233442 20-NOV-14
1 7 233442 20-NOV
-14 233473 20-NOV-14
1 8 233473 20-NOV-14 233536 20-NOV-14
1 9 233536 20-NOV-14 233559 20-NOV-14
1 10 233559 20-NOV-14 234100 20-NOV-14
1 11 234100 20-NOV-14 234133 20-NOV-14
1 12 234133 20-NOV-14 236454 20-NOV-14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
68 Full 345.13M DISK 00:01:38 20-NOV-14
BP Key: 86 Status: AVAILABLE Compressed: NO Tag: TAG20141120T234148
Piece Name: /home/oracle/back/db_PROD_864171708
List of Datafiles in backup set 68
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 236458 20-NOV-14 /u01/app/oracle/oradata/PROD/disk1/system01.dbf
2 Full 236458 20-NOV-14 /u01/app/oracle/oradata/PROD/disk1/undotbs01.dbf
3 Full 236458 20-NOV-14 /u01/app/oracle/oradata/PROD/disk1/sysaux01.dbf
4 Full 236458 20-NOV-14 /u01/app/oracle/oradata/PROD/disk1/example_1.dbf
5 Full 236458 20-NOV-14 /u01/app/oracle/oradata/PROD/disk1/indx_1.dbf
6 Full 236458 20-NOV-14 /u01/app/oracle/oradata/PROD/disk1/tools_1.dbf
7 Full 236458 20-NOV-14 /u01/app/oracle/oradata/PROD/disk1/users_1.dbf
8 Full 236458 20-NOV-14 /u01/app/oracle/oradata/PROD/disk1/oltp_1.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
69 2.50K DISK 00:00:01 20-NOV-14
BP Key: 87 Status: AVAILABLE Compressed: NO Tag: TAG20141120T234336
Piece Name: /home/oracle/back/arch_PROD_864171816
List of Archived Logs in backup set 69
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 13 236454 20-NOV-14 236487 20-NOV-14
BS Key Type LV Size Devic