Bo's Oracle Station

查看: 1096|回复: 0

第7次活动:2017-08-16(星期三晚上7:00-10:00)

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-8-16 20:37:26 | 显示全部楼层 |阅读模式
备份归档日志一段范围:
  1. RMAN> backup tag 'my_archivelog_29-30'   archivelog   from sequence   29   until   sequence 30  delete all input   ;
复制代码
对备份集再备份,由于打开了“备份优化”,要加上“force":
  1. RMAN> backup backupset 50  force delete input  ;
复制代码
关于备份策略指导三种情况的研究:
  1. [root@station90 SECOUG]# su - oracle
  2. [oracle@station90 ~]$ rman target /

  3. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Aug 16 20:06:51 2017

  4. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  5. connected to target database: ORCL (DBID=1343950367)

  6. RMAN> list backup;

  7. using target database control file instead of recovery catalog

  8. List of Backup Sets
  9. ===================


  10. BS Key  Type LV Size
  11. ------- ---- -- ----------
  12. 38      Full    9.36M
  13.   SPFILE Included: Modification time: 14-AUG-17
  14.   SPFILE db_unique_name: ORCL
  15.   Control File Included: Ckp SCN: 1105523      Ckp time: 14-AUG-17

  16.   Backup Set Copy #1 of backup set 38
  17.   Device Type Elapsed Time Completion Time Compressed Tag
  18.   ----------- ------------ --------------- ---------- ---
  19.   DISK        00:00:00     14-AUG-17       NO         TAG20170814T213045

  20.     List of Backup Pieces for backup set 38 Copy #1
  21.     BP Key  Pc# Status      Piece Name
  22.     ------- --- ----------- ----------
  23.     38      1   AVAILABLE   +FRA/orcl/autobackup/2017_08_14/s_952032645.261.952032645

  24.   Backup Set Copy #2 of backup set 38
  25.   Device Type Elapsed Time Completion Time Compressed Tag
  26.   ----------- ------------ --------------- ---------- ---
  27.   SBT_TAPE    00:00:00     15-AUG-17       NO         TAG20170814T213045

  28.     List of Backup Pieces for backup set 38 Copy #2
  29.     BP Key  Pc# Status      Media                   Piece Name
  30.     ------- --- ----------- ----------------------- ----------
  31.     46      1   AVAILABLE   station90-000004        c-1343950367-20170814-00

  32. BS Key  Size       Device Type Elapsed Time Completion Time
  33. ------- ---------- ----------- ------------ ---------------
  34. 39      4.00M      SBT_TAPE    00:00:16     14-AUG-17      
  35.         BP Key: 39   Status: AVAILABLE  Compressed: NO  Tag: TAG20170814T213058
  36.         Handle: 1csbtnci_1_1   Media: station90-000003

  37.   List of Archived Logs in backup set 39
  38.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  39.   ---- ------- ---------- --------- ---------- ---------
  40.   1    27      1103423    14-AUG-17 1105603    14-AUG-17

  41. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  42. ------- ---- -- ---------- ----------- ------------ ---------------
  43. 40      Full    9.50M      SBT_TAPE    00:00:15     14-AUG-17      
  44.         BP Key: 40   Status: AVAILABLE  Compressed: NO  Tag: TAG20170814T213124
  45.         Handle: c-1343950367-20170814-01   Media: station90-000003
  46.   SPFILE Included: Modification time: 14-AUG-17
  47.   SPFILE db_unique_name: ORCL
  48.   Control File Included: Ckp SCN: 1105658      Ckp time: 14-AUG-17

  49. BS Key  Type LV Size
  50. ------- ---- -- ----------
  51. 41      Incr 1  14.58M
  52.   List of Datafiles in backup set 41
  53.   File LV Type Ckp SCN    Ckp Time  Name
  54.   ---- -- ---- ---------- --------- ----
  55.   1    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/system.256.816169553
  56.   2    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
  57.   3    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
  58.   4    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/users.259.816169553
  59.   5    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/example.265.816169651

  60.   Backup Set Copy #1 of backup set 41
  61.   Device Type Elapsed Time Completion Time Compressed Tag
  62.   ----------- ------------ --------------- ---------- ---
  63.   DISK        00:00:01     15-AUG-17       NO         ORA_OEM_LEVEL_0

  64.     List of Backup Pieces for backup set 41 Copy #1
  65.     BP Key  Pc# Status      Piece Name
  66.     ------- --- ----------- ----------
  67.     41      1   AVAILABLE   +FRA/orcl/backupset/2017_08_15/nnndn1_ora_oem_level_0_0.268.952119027

  68.   Backup Set Copy #2 of backup set 41
  69.   Device Type Elapsed Time Completion Time Compressed Tag
  70.   ----------- ------------ --------------- ---------- ---
  71.   SBT_TAPE    00:00:01     15-AUG-17       NO         ORA_OEM_LEVEL_0

  72.     List of Backup Pieces for backup set 41 Copy #2
  73.     BP Key  Pc# Status      Media                   Piece Name
  74.     ------- --- ----------- ----------------------- ----------
  75.     45      1   AVAILABLE   station90-000003        1esc0bni_1_2

  76. BS Key  Type LV Size
  77. ------- ---- -- ----------
  78. 42      Full    9.36M
  79.   SPFILE Included: Modification time: 15-AUG-17
  80.   SPFILE db_unique_name: ORCL
  81.   Control File Included: Ckp SCN: 1108098      Ckp time: 15-AUG-17

  82.   Backup Set Copy #1 of backup set 42
  83.   Device Type Elapsed Time Completion Time Compressed Tag
  84.   ----------- ------------ --------------- ---------- ---
  85.   DISK        00:00:00     15-AUG-17       NO         TAG20170815T213029

  86.     List of Backup Pieces for backup set 42 Copy #1
  87.     BP Key  Pc# Status      Piece Name
  88.     ------- --- ----------- ----------
  89.     42      1   AVAILABLE   +FRA/orcl/autobackup/2017_08_15/s_952119029.269.952119029

  90.   Backup Set Copy #2 of backup set 42
  91.   Device Type Elapsed Time Completion Time Compressed Tag
  92.   ----------- ------------ --------------- ---------- ---
  93.   SBT_TAPE    00:00:00     15-AUG-17       NO         TAG20170815T213029

  94.     List of Backup Pieces for backup set 42 Copy #2
  95.     BP Key  Pc# Status      Media                   Piece Name
  96.     ------- --- ----------- ----------------------- ----------
  97.     47      1   AVAILABLE   station90-000003        c-1343950367-20170815-00

  98. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  99. ------- ---- -- ---------- ----------- ------------ ---------------
  100. 43      Full    425.25M    SBT_TAPE    00:00:26     15-AUG-17      
  101.         BP Key: 43   Status: AVAILABLE  Compressed: NO  Tag: TAG20170815T213042
  102.         Handle: 1hsc0bo2_1_1   Media: station90-000003
  103.   List of Datafiles in backup set 43
  104.   File LV Type Ckp SCN    Ckp Time  Name
  105.   ---- -- ---- ---------- --------- ----
  106.   2       Full 1105463    14-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
  107.   3       Full 1105481    14-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
  108.   4       Full 1105510    14-AUG-17 +DATA/orcl/datafile/users.259.816169553

  109. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  110. ------- ---- -- ---------- ----------- ------------ ---------------
  111. 44      Full    657.75M    SBT_TAPE    00:00:29     15-AUG-17      
  112.         BP Key: 44   Status: AVAILABLE  Compressed: NO  Tag: TAG20170815T213042
  113.         Handle: 1gsc0bo2_1_1   Media: station90-000004
  114.   List of Datafiles in backup set 44
  115.   File LV Type Ckp SCN    Ckp Time  Name
  116.   ---- -- ---- ---------- --------- ----
  117.   1       Full 1105450    14-AUG-17 +DATA/orcl/datafile/system.256.816169553
  118.   5       Full 1105495    14-AUG-17 +DATA/orcl/datafile/example.265.816169651

  119. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  120. ------- ---- -- ---------- ----------- ------------ ---------------
  121. 45      Full    9.50M      SBT_TAPE    00:00:16     15-AUG-17      
  122.         BP Key: 48   Status: AVAILABLE  Compressed: NO  Tag: TAG20170815T213209
  123.         Handle: c-1343950367-20170815-01   Media: station90-000003
  124.   SPFILE Included: Modification time: 15-AUG-17
  125.   SPFILE db_unique_name: ORCL
  126.   Control File Included: Ckp SCN: 1108330      Ckp time: 15-AUG-17

  127. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  128. ------- ---- -- ---------- ----------- ------------ ---------------
  129. 46      Incr 1  15.79M     DISK        00:00:02     16-AUG-17      
  130.         BP Key: 49   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  131.         Piece Name: +FRA/orcl/backupset/2017_08_16/nnndn1_ora_oem_level_0_0.270.952205439
  132.   List of Datafiles in backup set 46
  133.   File LV Type Ckp SCN    Ckp Time  Name
  134.   ---- -- ---- ---------- --------- ----
  135.   1    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/system.256.816169553
  136.   2    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
  137.   3    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
  138.   4    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/users.259.816169553
  139.   5    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/example.265.816169651

  140. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  141. ------- ---- -- ---------- ----------- ------------ ---------------
  142. 47      Full    9.36M      DISK        00:00:01     16-AUG-17      
  143.         BP Key: 50   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T213039
  144.         Piece Name: +FRA/orcl/autobackup/2017_08_16/s_952205439.271.952205441
  145.   SPFILE Included: Modification time: 16-AUG-17
  146.   SPFILE db_unique_name: ORCL
  147.   Control File Included: Ckp SCN: 1111909      Ckp time: 16-AUG-17

  148. BS Key  Size       Device Type Elapsed Time Completion Time
  149. ------- ---------- ----------- ------------ ---------------
  150. 48      22.00M     SBT_TAPE    00:00:16     16-AUG-17      
  151.         BP Key: 51   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T213053
  152.         Handle: 1lsc304d_1_1   Media: station90-000003

  153.   List of Archived Logs in backup set 48
  154.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  155.   ---- ------- ---------- --------- ---------- ---------
  156.   1    28      1105603    14-AUG-17 1112021    16-AUG-17

  157. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  158. ------- ---- -- ---------- ----------- ------------ ---------------
  159. 49      Full    9.50M      SBT_TAPE    00:00:15     16-AUG-17      
  160.         BP Key: 52   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T213118
  161.         Handle: c-1343950367-20170816-01   Media: station90-000003
  162.   SPFILE Included: Modification time: 16-AUG-17
  163.   SPFILE db_unique_name: ORCL
  164.   Control File Included: Ckp SCN: 1112070      Ckp time: 16-AUG-17

  165. RMAN>

  166. RMAN> list backupset 48;


  167. List of Backup Sets
  168. ===================


  169. BS Key  Size       Device Type Elapsed Time Completion Time
  170. ------- ---------- ----------- ------------ ---------------
  171. 48      22.00M     SBT_TAPE    00:00:16     16-AUG-17      
  172.         BP Key: 51   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T213053
  173.         Handle: 1lsc304d_1_1   Media: station90-000003

  174.   List of Archived Logs in backup set 48
  175.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  176.   ---- ------- ---------- --------- ---------- ---------
  177.   1    28      1105603    14-AUG-17 1112021    16-AUG-17

  178. RMAN> list backupset 48,49;


  179. List of Backup Sets
  180. ===================


  181. BS Key  Size       Device Type Elapsed Time Completion Time
  182. ------- ---------- ----------- ------------ ---------------
  183. 48      22.00M     SBT_TAPE    00:00:16     16-AUG-17      
  184.         BP Key: 51   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T213053
  185.         Handle: 1lsc304d_1_1   Media: station90-000003

  186.   List of Archived Logs in backup set 48
  187.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  188.   ---- ------- ---------- --------- ---------- ---------
  189.   1    28      1105603    14-AUG-17 1112021    16-AUG-17

  190. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  191. ------- ---- -- ---------- ----------- ------------ ---------------
  192. 49      Full    9.50M      SBT_TAPE    00:00:15     16-AUG-17      
  193.         BP Key: 52   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T213118
  194.         Handle: c-1343950367-20170816-01   Media: station90-000003
  195.   Control File Included: Ckp SCN: 1112070      Ckp time: 16-AUG-17
  196.   SPFILE Included: Modification time: 16-AUG-17
  197.   SPFILE db_unique_name: ORCL

  198. RMAN> list backup;


  199. List of Backup Sets
  200. ===================


  201. BS Key  Type LV Size
  202. ------- ---- -- ----------
  203. 38      Full    9.36M
  204.   SPFILE Included: Modification time: 14-AUG-17
  205.   SPFILE db_unique_name: ORCL
  206.   Control File Included: Ckp SCN: 1105523      Ckp time: 14-AUG-17

  207.   Backup Set Copy #1 of backup set 38
  208.   Device Type Elapsed Time Completion Time Compressed Tag
  209.   ----------- ------------ --------------- ---------- ---
  210.   DISK        00:00:00     14-AUG-17       NO         TAG20170814T213045

  211.     List of Backup Pieces for backup set 38 Copy #1
  212.     BP Key  Pc# Status      Piece Name
  213.     ------- --- ----------- ----------
  214.     38      1   AVAILABLE   +FRA/orcl/autobackup/2017_08_14/s_952032645.261.952032645

  215.   Backup Set Copy #2 of backup set 38
  216.   Device Type Elapsed Time Completion Time Compressed Tag
  217.   ----------- ------------ --------------- ---------- ---
  218.   SBT_TAPE    00:00:00     15-AUG-17       NO         TAG20170814T213045

  219.     List of Backup Pieces for backup set 38 Copy #2
  220.     BP Key  Pc# Status      Media                   Piece Name
  221.     ------- --- ----------- ----------------------- ----------
  222.     46      1   AVAILABLE   station90-000004        c-1343950367-20170814-00

  223. BS Key  Size       Device Type Elapsed Time Completion Time
  224. ------- ---------- ----------- ------------ ---------------
  225. 39      4.00M      SBT_TAPE    00:00:16     14-AUG-17      
  226.         BP Key: 39   Status: AVAILABLE  Compressed: NO  Tag: TAG20170814T213058
  227.         Handle: 1csbtnci_1_1   Media: station90-000003

  228.   List of Archived Logs in backup set 39
  229.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  230.   ---- ------- ---------- --------- ---------- ---------
  231.   1    27      1103423    14-AUG-17 1105603    14-AUG-17

  232. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  233. ------- ---- -- ---------- ----------- ------------ ---------------
  234. 40      Full    9.50M      SBT_TAPE    00:00:15     14-AUG-17      
  235.         BP Key: 40   Status: AVAILABLE  Compressed: NO  Tag: TAG20170814T213124
  236.         Handle: c-1343950367-20170814-01   Media: station90-000003
  237.   SPFILE Included: Modification time: 14-AUG-17
  238.   SPFILE db_unique_name: ORCL
  239.   Control File Included: Ckp SCN: 1105658      Ckp time: 14-AUG-17

  240. BS Key  Type LV Size
  241. ------- ---- -- ----------
  242. 41      Incr 1  14.58M
  243.   List of Datafiles in backup set 41
  244.   File LV Type Ckp SCN    Ckp Time  Name
  245.   ---- -- ---- ---------- --------- ----
  246.   1    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/system.256.816169553
  247.   2    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
  248.   3    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
  249.   4    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/users.259.816169553
  250.   5    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/example.265.816169651

  251.   Backup Set Copy #1 of backup set 41
  252.   Device Type Elapsed Time Completion Time Compressed Tag
  253.   ----------- ------------ --------------- ---------- ---
  254.   DISK        00:00:01     15-AUG-17       NO         ORA_OEM_LEVEL_0

  255.     List of Backup Pieces for backup set 41 Copy #1
  256.     BP Key  Pc# Status      Piece Name
  257.     ------- --- ----------- ----------
  258.     41      1   AVAILABLE   +FRA/orcl/backupset/2017_08_15/nnndn1_ora_oem_level_0_0.268.952119027

  259.   Backup Set Copy #2 of backup set 41
  260.   Device Type Elapsed Time Completion Time Compressed Tag
  261.   ----------- ------------ --------------- ---------- ---
  262.   SBT_TAPE    00:00:01     15-AUG-17       NO         ORA_OEM_LEVEL_0

  263.     List of Backup Pieces for backup set 41 Copy #2
  264.     BP Key  Pc# Status      Media                   Piece Name
  265.     ------- --- ----------- ----------------------- ----------
  266.     45      1   AVAILABLE   station90-000003        1esc0bni_1_2

  267. BS Key  Type LV Size
  268. ------- ---- -- ----------
  269. 42      Full    9.36M
  270.   SPFILE Included: Modification time: 15-AUG-17
  271.   SPFILE db_unique_name: ORCL
  272.   Control File Included: Ckp SCN: 1108098      Ckp time: 15-AUG-17

  273.   Backup Set Copy #1 of backup set 42
  274.   Device Type Elapsed Time Completion Time Compressed Tag
  275.   ----------- ------------ --------------- ---------- ---
  276.   DISK        00:00:00     15-AUG-17       NO         TAG20170815T213029

  277.     List of Backup Pieces for backup set 42 Copy #1
  278.     BP Key  Pc# Status      Piece Name
  279.     ------- --- ----------- ----------
  280.     42      1   AVAILABLE   +FRA/orcl/autobackup/2017_08_15/s_952119029.269.952119029

  281.   Backup Set Copy #2 of backup set 42
  282.   Device Type Elapsed Time Completion Time Compressed Tag
  283.   ----------- ------------ --------------- ---------- ---
  284.   SBT_TAPE    00:00:00     15-AUG-17       NO         TAG20170815T213029

  285.     List of Backup Pieces for backup set 42 Copy #2
  286.     BP Key  Pc# Status      Media                   Piece Name
  287.     ------- --- ----------- ----------------------- ----------
  288.     47      1   AVAILABLE   station90-000003        c-1343950367-20170815-00

  289. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  290. ------- ---- -- ---------- ----------- ------------ ---------------
  291. 43      Full    425.25M    SBT_TAPE    00:00:26     15-AUG-17      
  292.         BP Key: 43   Status: AVAILABLE  Compressed: NO  Tag: TAG20170815T213042
  293.         Handle: 1hsc0bo2_1_1   Media: station90-000003
  294.   List of Datafiles in backup set 43
  295.   File LV Type Ckp SCN    Ckp Time  Name
  296.   ---- -- ---- ---------- --------- ----
  297.   2       Full 1105463    14-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
  298.   3       Full 1105481    14-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
  299.   4       Full 1105510    14-AUG-17 +DATA/orcl/datafile/users.259.816169553

  300. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  301. ------- ---- -- ---------- ----------- ------------ ---------------
  302. 44      Full    657.75M    SBT_TAPE    00:00:29     15-AUG-17      
  303.         BP Key: 44   Status: AVAILABLE  Compressed: NO  Tag: TAG20170815T213042
  304.         Handle: 1gsc0bo2_1_1   Media: station90-000004
  305.   List of Datafiles in backup set 44
  306.   File LV Type Ckp SCN    Ckp Time  Name
  307.   ---- -- ---- ---------- --------- ----
  308.   1       Full 1105450    14-AUG-17 +DATA/orcl/datafile/system.256.816169553
  309.   5       Full 1105495    14-AUG-17 +DATA/orcl/datafile/example.265.816169651

  310. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  311. ------- ---- -- ---------- ----------- ------------ ---------------
  312. 45      Full    9.50M      SBT_TAPE    00:00:16     15-AUG-17      
  313.         BP Key: 48   Status: AVAILABLE  Compressed: NO  Tag: TAG20170815T213209
  314.         Handle: c-1343950367-20170815-01   Media: station90-000003
  315.   SPFILE Included: Modification time: 15-AUG-17
  316.   SPFILE db_unique_name: ORCL
  317.   Control File Included: Ckp SCN: 1108330      Ckp time: 15-AUG-17

  318. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  319. ------- ---- -- ---------- ----------- ------------ ---------------
  320. 46      Incr 1  15.79M     DISK        00:00:02     16-AUG-17      
  321.         BP Key: 49   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  322.         Piece Name: +FRA/orcl/backupset/2017_08_16/nnndn1_ora_oem_level_0_0.270.952205439
  323.   List of Datafiles in backup set 46
  324.   File LV Type Ckp SCN    Ckp Time  Name
  325.   ---- -- ---- ---------- --------- ----
  326.   1    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/system.256.816169553
  327.   2    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
  328.   3    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
  329.   4    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/users.259.816169553
  330.   5    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/example.265.816169651

  331. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  332. ------- ---- -- ---------- ----------- ------------ ---------------
  333. 47      Full    9.36M      DISK        00:00:01     16-AUG-17      
  334.         BP Key: 50   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T213039
  335.         Piece Name: +FRA/orcl/autobackup/2017_08_16/s_952205439.271.952205441
  336.   SPFILE Included: Modification time: 16-AUG-17
  337.   SPFILE db_unique_name: ORCL
  338.   Control File Included: Ckp SCN: 1111909      Ckp time: 16-AUG-17

  339. BS Key  Size       Device Type Elapsed Time Completion Time
  340. ------- ---------- ----------- ------------ ---------------
  341. 48      22.00M     SBT_TAPE    00:00:16     16-AUG-17      
  342.         BP Key: 51   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T213053
  343.         Handle: 1lsc304d_1_1   Media: station90-000003

  344.   List of Archived Logs in backup set 48
  345.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  346.   ---- ------- ---------- --------- ---------- ---------
  347.   1    28      1105603    14-AUG-17 1112021    16-AUG-17

  348. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  349. ------- ---- -- ---------- ----------- ------------ ---------------
  350. 49      Full    9.50M      SBT_TAPE    00:00:15     16-AUG-17      
  351.         BP Key: 52   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T213118
  352.         Handle: c-1343950367-20170816-01   Media: station90-000003
  353.   SPFILE Included: Modification time: 16-AUG-17
  354.   SPFILE db_unique_name: ORCL
  355.   Control File Included: Ckp SCN: 1112070      Ckp time: 16-AUG-17

  356. RMAN> show all;

  357. RMAN configuration parameters for database with db_unique_name ORCL are:
  358. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  359. CONFIGURE BACKUP OPTIMIZATION ON;
  360. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  361. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  362. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  363. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  364. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  365. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  366. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  367. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  368. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  369. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  370. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  371. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  372. CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  373. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  374. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  375. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  376. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  377. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  378. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  379. RMAN> report obsolete;

  380. RMAN retention policy will be applied to the command
  381. RMAN retention policy is set to recovery window of 1 days
  382. Report of obsolete backups and copies
  383. Type                 Key    Completion Time    Filename/Handle
  384. -------------------- ------ ------------------ --------------------
  385. Backup Set           38     15-AUG-17         
  386.   Backup Piece       46     15-AUG-17          c-1343950367-20170814-00
  387. Backup Set           38     14-AUG-17         
  388.   Backup Piece       38     14-AUG-17          +FRA/orcl/autobackup/2017_08_14/s_952032645.261.952032645

  389. RMAN> delete obsolete;

  390. RMAN retention policy will be applied to the command
  391. RMAN retention policy is set to recovery window of 1 days
  392. allocated channel: ORA_DISK_1
  393. channel ORA_DISK_1: SID=136 device type=DISK
  394. allocated channel: ORA_DISK_2
  395. channel ORA_DISK_2: SID=195 device type=DISK
  396. allocated channel: ORA_DISK_3
  397. channel ORA_DISK_3: SID=12 device type=DISK
  398. allocated channel: ORA_DISK_4
  399. channel ORA_DISK_4: SID=72 device type=DISK
  400. allocated channel: ORA_DISK_5
  401. channel ORA_DISK_5: SID=137 device type=DISK
  402. allocated channel: ORA_DISK_6
  403. channel ORA_DISK_6: SID=196 device type=DISK
  404. allocated channel: ORA_DISK_7
  405. channel ORA_DISK_7: SID=11 device type=DISK
  406. allocated channel: ORA_DISK_8
  407. channel ORA_DISK_8: SID=73 device type=DISK
  408. allocated channel: ORA_SBT_TAPE_1
  409. channel ORA_SBT_TAPE_1: SID=139 device type=SBT_TAPE
  410. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  411. allocated channel: ORA_SBT_TAPE_2
  412. channel ORA_SBT_TAPE_2: SID=9 device type=SBT_TAPE
  413. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  414. Deleting the following obsolete backups and copies:
  415. Type                 Key    Completion Time    Filename/Handle
  416. -------------------- ------ ------------------ --------------------
  417. Backup Set           38     15-AUG-17         
  418.   Backup Piece       46     15-AUG-17          c-1343950367-20170814-00
  419. Backup Set           38     14-AUG-17         
  420.   Backup Piece       38     14-AUG-17          +FRA/orcl/autobackup/2017_08_14/s_952032645.261.952032645

  421. Do you really want to delete the above objects (enter YES or NO)? YES
  422. deleted backup piece
  423. backup piece handle=+FRA/orcl/autobackup/2017_08_14/s_952032645.261.952032645 RECID=38 STAMP=952032645
  424. Deleted 1 objects

  425. deleted backup piece
  426. backup piece handle=c-1343950367-20170814-00 RECID=46 STAMP=952119079
  427. Deleted 1 objects


  428. RMAN> show all;

  429. RMAN configuration parameters for database with db_unique_name ORCL are:
  430. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  431. CONFIGURE BACKUP OPTIMIZATION ON;
  432. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  433. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  434. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  435. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  436. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  437. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  438. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  439. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  440. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  441. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  442. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  443. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  444. CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  445. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  446. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  447. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  448. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  449. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  450. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  451. RMAN> run {
  452. 2> allocate channel c1 device type disk format '/home/oracle/mybackup/%d_%U';
  453. 3> backup as copy tablespace users;
  454. 4> release channel c1;
  455. 5> }

  456. released channel: ORA_DISK_1
  457. released channel: ORA_DISK_2
  458. released channel: ORA_DISK_3
  459. released channel: ORA_DISK_4
  460. released channel: ORA_DISK_5
  461. released channel: ORA_DISK_6
  462. released channel: ORA_DISK_7
  463. released channel: ORA_DISK_8
  464. released channel: ORA_SBT_TAPE_1
  465. released channel: ORA_SBT_TAPE_2
  466. allocated channel: c1
  467. channel c1: SID=136 device type=DISK

  468. Starting backup at 16-AUG-17
  469. channel c1: starting datafile copy
  470. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  471. output file name=/home/oracle/mybackup/ORCL_data_D-ORCL_I-1343950367_TS-USERS_FNO-4_1nsc2sef tag=TAG20170816T202759 RECID=13 STAMP=952201679
  472. channel c1: datafile copy complete, elapsed time: 00:00:01
  473. Finished backup at 16-AUG-17

  474. Starting Control File and SPFILE Autobackup at 16-AUG-17
  475. piece handle=+FRA/orcl/autobackup/2017_08_16/s_952201680.261.952201681 comment=NONE
  476. Finished Control File and SPFILE Autobackup at 16-AUG-17

  477. released channel: c1

  478. RMAN> backup tag 'my_controlfile_1' current controlfile;

  479. Starting backup at 16-AUG-17
  480. allocated channel: ORA_SBT_TAPE_1
  481. channel ORA_SBT_TAPE_1: SID=136 device type=SBT_TAPE
  482. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  483. allocated channel: ORA_SBT_TAPE_2
  484. channel ORA_SBT_TAPE_2: SID=195 device type=SBT_TAPE
  485. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  486. channel ORA_SBT_TAPE_1: starting full datafile backup set
  487. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  488. including current control file in backup set
  489. channel ORA_SBT_TAPE_1: starting piece 1 at 16-AUG-17
  490. channel ORA_SBT_TAPE_1: finished piece 1 at 16-AUG-17
  491. piece handle=1psc2sii_1_1 tag=MY_CONTROLFILE_1 comment=API Version 2.0,MMS Version 10.4.0.4
  492. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  493. Finished backup at 16-AUG-17

  494. Starting Control File and SPFILE Autobackup at 16-AUG-17
  495. piece handle=c-1343950367-20170816-03 comment=API Version 2.0,MMS Version 10.4.0.4
  496. Finished Control File and SPFILE Autobackup at 16-AUG-17

  497. RMAN> list archivelog all;

  498. List of Archived Log Copies for database with db_unique_name ORCL
  499. =====================================================================

  500. Key     Thrd Seq     S Low Time
  501. ------- ---- ------- - ---------
  502. 19      1    27      A 14-AUG-17
  503.         Name: +FRA/orcl/archivelog/2017_08_14/thread_1_seq_27.262.952032659

  504. 20      1    28      A 14-AUG-17
  505.         Name: +FRA/orcl/archivelog/2017_08_16/thread_1_seq_28.272.952205453


  506. RMAN> backup tag 'my_archivelog_27-28'  archivelog sequence 27,28  delete all input ;

  507. RMAN-00571: ===========================================================
  508. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  509. RMAN-00571: ===========================================================
  510. RMAN-00558: error encountered while parsing input commands
  511. RMAN-01009: syntax error: found "comma": expecting one of: "all, archivelog, auxiliary, backupset, backup, channel, controlfilecopy, copy, current, database, datafilecopy, datafile, db_recovery_file_dest, delete, diskratio, filesperset, force, format, from, incarnation, include, keep, like, maxsetsize, noexclude, nokeep, not, plus, pool, recovery, reuse, section, skip readonly, skip, spfile, tablespace, tag, thread, to, (, ;"
  512. RMAN-01007: at line 1 column 57 file: standard input

  513. RMAN> backup tag 'my_archivelog_27-28'  archivelog   from sequence   27   until   sequence 28  delete all input ;

  514. Starting backup at 16-AUG-17
  515. using channel ORA_SBT_TAPE_1
  516. using channel ORA_SBT_TAPE_2
  517. skipping archived log file +FRA/orcl/archivelog/2017_08_14/thread_1_seq_27.262.952032659; already backed up 1 time(s)
  518. skipping archived log file +FRA/orcl/archivelog/2017_08_16/thread_1_seq_28.272.952205453; already backed up 1 time(s)
  519. channel ORA_SBT_TAPE_1: deleting archived log(s)
  520. archived log file name=+FRA/orcl/archivelog/2017_08_14/thread_1_seq_27.262.952032659 RECID=19 STAMP=952032658
  521. archived log file name=+FRA/orcl/archivelog/2017_08_16/thread_1_seq_28.272.952205453 RECID=20 STAMP=952205452
  522. Finished backup at 16-AUG-17

  523. RMAN> backup tag 'my_archivelog_27-28'  archivelog   from sequence   27   until   sequence 28  delete all input  force ;

  524. Starting backup at 16-AUG-17
  525. using channel ORA_SBT_TAPE_1
  526. using channel ORA_SBT_TAPE_2
  527. specification does not match any archived log in the repository
  528. backup cancelled because there are no files to backup
  529. Finished backup at 16-AUG-17

  530. RMAN>
  531. user interrupt received
  532. backup tag 'my_archivelog_27-28'   archivelog   from sequence   27   until   sequence 28  delete all input   ;

  533. Starting backup at 16-AUG-17
  534. using channel ORA_SBT_TAPE_1
  535. using channel ORA_SBT_TAPE_2
  536. specification does not match any archived log in the repository
  537. backup cancelled because there are no files to backup
  538. Finished backup at 16-AUG-17

  539. RMAN>

  540. RMAN>

  541. RMAN> sql "alter system switch logfile";

  542. sql statement: alter system switch logfile

  543. RMAN>  sql "alter system switch logfile";

  544. sql statement: alter system switch logfile

  545. RMAN> list archivellog all;

  546. RMAN-00571: ===========================================================
  547. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  548. RMAN-00571: ===========================================================
  549. RMAN-00558: error encountered while parsing input commands
  550. RMAN-01009: syntax error: found "identifier": expecting one of: "all, archivelog, backed, backuppiece, backupset, backup, completed, controlfilecopy, copy, datafilecopy, db_unique_name, device, expired, failure, foreign, global, incarnation, like, proxy, recoverable, restore, script, tag"
  551. RMAN-01008: the bad identifier was: archivellog
  552. RMAN-01007: at line 1 column 6 file: standard input

  553. RMAN> list archivelog all;

  554. List of Archived Log Copies for database with db_unique_name ORCL
  555. =====================================================================

  556. Key     Thrd Seq     S Low Time
  557. ------- ---- ------- - ---------
  558. 21      1    29      A 16-AUG-17
  559.         Name: +FRA/orcl/archivelog/2017_08_16/thread_1_seq_29.272.952205455

  560. 22      1    30      A 16-AUG-17
  561.         Name: +FRA/orcl/archivelog/2017_08_16/thread_1_seq_30.262.952202065


  562. RMAN> backup tag 'my_archivelog_29-30'   archivelog   from sequence   29   until   sequence 30  delete all input   ;

  563. Starting backup at 16-AUG-17
  564. using channel ORA_SBT_TAPE_1
  565. using channel ORA_SBT_TAPE_2
  566. channel ORA_SBT_TAPE_1: starting archived log backup set
  567. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  568. input archived log thread=1 sequence=29 RECID=21 STAMP=952202060
  569. channel ORA_SBT_TAPE_1: starting piece 1 at 16-AUG-17
  570. RMAN-03009: failure of backup command on ORA_SBT_TAPE_2 channel at 08/16/2017 20:34:56
  571. ORA-01013: user requested cancel of current operation
  572. continuing other job steps, job failed will not be re-run



  573. channel ORA_SBT_TAPE_1: finished piece 1 at 16-AUG-17
  574. piece handle=1rsc2srg_1_1 tag=MY_ARCHIVELOG_29-30 comment=API Version 2.0,MMS Version 10.4.0.4
  575. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  576. channel ORA_SBT_TAPE_1: deleting archived log(s)
  577. archived log file name=+FRA/orcl/archivelog/2017_08_16/thread_1_seq_29.272.952205455 RECID=21 STAMP=952202060
  578. RMAN-00571: ===========================================================
  579. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  580. RMAN-00571: ===========================================================

  581. RMAN-03009: failure of backup command on ORA_SBT_TAPE_2 channel at 08/16/2017 20:34:56
  582. ORA-01013: user requested cancel of current operation

  583. RMAN>
  584. RMAN>
  585. RMAN>
  586. RMAN> exit


  587. Recovery Manager complete.
  588. [oracle@station90 ~]$ rman target /

  589. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Aug 16 20:35:41 2017

  590. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  591. connected to target database: ORCL (DBID=1343950367)

  592. RMAN> backup tag 'my_archivelog_29-30'   archivelog   from sequence   29   until   sequence 30  delete all input   ;

  593. Starting backup at 16-AUG-17
  594. using target database control file instead of recovery catalog
  595. allocated channel: ORA_SBT_TAPE_1
  596. channel ORA_SBT_TAPE_1: SID=136 device type=SBT_TAPE
  597. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  598. allocated channel: ORA_SBT_TAPE_2
  599. channel ORA_SBT_TAPE_2: SID=13 device type=SBT_TAPE
  600. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  601. channel ORA_SBT_TAPE_1: starting archived log backup set
  602. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  603. input archived log thread=1 sequence=30 RECID=22 STAMP=952202064
  604. channel ORA_SBT_TAPE_1: starting piece 1 at 16-AUG-17
  605. channel ORA_SBT_TAPE_1: finished piece 1 at 16-AUG-17
  606. piece handle=1ssc2stc_1_1 tag=MY_ARCHIVELOG_29-30 comment=API Version 2.0,MMS Version 10.4.0.4
  607. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  608. channel ORA_SBT_TAPE_1: deleting archived log(s)
  609. archived log file name=+FRA/orcl/archivelog/2017_08_16/thread_1_seq_30.262.952202065 RECID=22 STAMP=952202064
  610. Finished backup at 16-AUG-17

  611. Starting Control File and SPFILE Autobackup at 16-AUG-17
  612. piece handle=c-1343950367-20170816-04 comment=API Version 2.0,MMS Version 10.4.0.4
  613. Finished Control File and SPFILE Autobackup at 16-AUG-17

  614. RMAN> list archivelog all;

  615. specification does not match any archived log in the repository

  616. RMAN> list backup ;


  617. List of Backup Sets
  618. ===================


  619. BS Key  Size       Device Type Elapsed Time Completion Time
  620. ------- ---------- ----------- ------------ ---------------
  621. 39      4.00M      SBT_TAPE    00:00:16     14-AUG-17      
  622.         BP Key: 39   Status: AVAILABLE  Compressed: NO  Tag: TAG20170814T213058
  623.         Handle: 1csbtnci_1_1   Media: station90-000003

  624.   List of Archived Logs in backup set 39
  625.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  626.   ---- ------- ---------- --------- ---------- ---------
  627.   1    27      1103423    14-AUG-17 1105603    14-AUG-17

  628. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  629. ------- ---- -- ---------- ----------- ------------ ---------------
  630. 40      Full    9.50M      SBT_TAPE    00:00:15     14-AUG-17      
  631.         BP Key: 40   Status: AVAILABLE  Compressed: NO  Tag: TAG20170814T213124
  632.         Handle: c-1343950367-20170814-01   Media: station90-000003
  633.   SPFILE Included: Modification time: 14-AUG-17
  634.   SPFILE db_unique_name: ORCL
  635.   Control File Included: Ckp SCN: 1105658      Ckp time: 14-AUG-17

  636. BS Key  Type LV Size
  637. ------- ---- -- ----------
  638. 41      Incr 1  14.58M
  639.   List of Datafiles in backup set 41
  640.   File LV Type Ckp SCN    Ckp Time  Name
  641.   ---- -- ---- ---------- --------- ----
  642.   1    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/system.256.816169553
  643.   2    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
  644.   3    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
  645.   4    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/users.259.816169553
  646.   5    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/example.265.816169651

  647.   Backup Set Copy #1 of backup set 41
  648.   Device Type Elapsed Time Completion Time Compressed Tag
  649.   ----------- ------------ --------------- ---------- ---
  650.   DISK        00:00:01     15-AUG-17       NO         ORA_OEM_LEVEL_0

  651.     List of Backup Pieces for backup set 41 Copy #1
  652.     BP Key  Pc# Status      Piece Name
  653.     ------- --- ----------- ----------
  654.     41      1   AVAILABLE   +FRA/orcl/backupset/2017_08_15/nnndn1_ora_oem_level_0_0.268.952119027

  655.   Backup Set Copy #2 of backup set 41
  656.   Device Type Elapsed Time Completion Time Compressed Tag
  657.   ----------- ------------ --------------- ---------- ---
  658.   SBT_TAPE    00:00:01     15-AUG-17       NO         ORA_OEM_LEVEL_0

  659.     List of Backup Pieces for backup set 41 Copy #2
  660.     BP Key  Pc# Status      Media                   Piece Name
  661.     ------- --- ----------- ----------------------- ----------
  662.     45      1   AVAILABLE   station90-000003        1esc0bni_1_2

  663. BS Key  Type LV Size
  664. ------- ---- -- ----------
  665. 42      Full    9.36M
  666.   SPFILE Included: Modification time: 15-AUG-17
  667.   SPFILE db_unique_name: ORCL
  668.   Control File Included: Ckp SCN: 1108098      Ckp time: 15-AUG-17

  669.   Backup Set Copy #1 of backup set 42
  670.   Device Type Elapsed Time Completion Time Compressed Tag
  671.   ----------- ------------ --------------- ---------- ---
  672.   DISK        00:00:00     15-AUG-17       NO         TAG20170815T213029

  673.     List of Backup Pieces for backup set 42 Copy #1
  674.     BP Key  Pc# Status      Piece Name
  675.     ------- --- ----------- ----------
  676.     42      1   AVAILABLE   +FRA/orcl/autobackup/2017_08_15/s_952119029.269.952119029

  677.   Backup Set Copy #2 of backup set 42
  678.   Device Type Elapsed Time Completion Time Compressed Tag
  679.   ----------- ------------ --------------- ---------- ---
  680.   SBT_TAPE    00:00:00     15-AUG-17       NO         TAG20170815T213029

  681.     List of Backup Pieces for backup set 42 Copy #2
  682.     BP Key  Pc# Status      Media                   Piece Name
  683.     ------- --- ----------- ----------------------- ----------
  684.     47      1   AVAILABLE   station90-000003        c-1343950367-20170815-00

  685. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  686. ------- ---- -- ---------- ----------- ------------ ---------------
  687. 43      Full    425.25M    SBT_TAPE    00:00:26     15-AUG-17      
  688.         BP Key: 43   Status: AVAILABLE  Compressed: NO  Tag: TAG20170815T213042
  689.         Handle: 1hsc0bo2_1_1   Media: station90-000003
  690.   List of Datafiles in backup set 43
  691.   File LV Type Ckp SCN    Ckp Time  Name
  692.   ---- -- ---- ---------- --------- ----
  693.   2       Full 1105463    14-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
  694.   3       Full 1105481    14-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
  695.   4       Full 1105510    14-AUG-17 +DATA/orcl/datafile/users.259.816169553

  696. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  697. ------- ---- -- ---------- ----------- ------------ ---------------
  698. 44      Full    657.75M    SBT_TAPE    00:00:29     15-AUG-17      
  699.         BP Key: 44   Status: AVAILABLE  Compressed: NO  Tag: TAG20170815T213042
  700.         Handle: 1gsc0bo2_1_1   Media: station90-000004
  701.   List of Datafiles in backup set 44
  702.   File LV Type Ckp SCN    Ckp Time  Name
  703.   ---- -- ---- ---------- --------- ----
  704.   1       Full 1105450    14-AUG-17 +DATA/orcl/datafile/system.256.816169553
  705.   5       Full 1105495    14-AUG-17 +DATA/orcl/datafile/example.265.816169651

  706. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  707. ------- ---- -- ---------- ----------- ------------ ---------------
  708. 45      Full    9.50M      SBT_TAPE    00:00:16     15-AUG-17      
  709.         BP Key: 48   Status: AVAILABLE  Compressed: NO  Tag: TAG20170815T213209
  710.         Handle: c-1343950367-20170815-01   Media: station90-000003
  711.   SPFILE Included: Modification time: 15-AUG-17
  712.   SPFILE db_unique_name: ORCL
  713.   Control File Included: Ckp SCN: 1108330      Ckp time: 15-AUG-17

  714. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  715. ------- ---- -- ---------- ----------- ------------ ---------------
  716. 46      Incr 1  15.79M     DISK        00:00:02     16-AUG-17      
  717.         BP Key: 49   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  718.         Piece Name: +FRA/orcl/backupset/2017_08_16/nnndn1_ora_oem_level_0_0.270.952205439
  719.   List of Datafiles in backup set 46
  720.   File LV Type Ckp SCN    Ckp Time  Name
  721.   ---- -- ---- ---------- --------- ----
  722.   1    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/system.256.816169553
  723.   2    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
  724.   3    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
  725.   4    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/users.259.816169553
  726.   5    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/example.265.816169651

  727. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  728. ------- ---- -- ---------- ----------- ------------ ---------------
  729. 47      Full    9.36M      DISK        00:00:01     16-AUG-17      
  730.         BP Key: 50   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T213039
  731.         Piece Name: +FRA/orcl/autobackup/2017_08_16/s_952205439.271.952205441
  732.   SPFILE Included: Modification time: 16-AUG-17
  733.   SPFILE db_unique_name: ORCL
  734.   Control File Included: Ckp SCN: 1111909      Ckp time: 16-AUG-17

  735. BS Key  Size       Device Type Elapsed Time Completion Time
  736. ------- ---------- ----------- ------------ ---------------
  737. 48      22.00M     SBT_TAPE    00:00:16     16-AUG-17      
  738.         BP Key: 51   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T213053
  739.         Handle: 1lsc304d_1_1   Media: station90-000003

  740.   List of Archived Logs in backup set 48
  741.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  742.   ---- ------- ---------- --------- ---------- ---------
  743.   1    28      1105603    14-AUG-17 1112021    16-AUG-17

  744. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  745. ------- ---- -- ---------- ----------- ------------ ---------------
  746. 49      Full    9.50M      SBT_TAPE    00:00:15     16-AUG-17      
  747.         BP Key: 52   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T213118
  748.         Handle: c-1343950367-20170816-01   Media: station90-000003
  749.   SPFILE Included: Modification time: 16-AUG-17
  750.   SPFILE db_unique_name: ORCL
  751.   Control File Included: Ckp SCN: 1112070      Ckp time: 16-AUG-17

  752. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  753. ------- ---- -- ---------- ----------- ------------ ---------------
  754. 50      Full    9.36M      DISK        00:00:01     16-AUG-17      
  755.         BP Key: 53   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T202800
  756.         Piece Name: +FRA/orcl/autobackup/2017_08_16/s_952201680.261.952201681
  757.   SPFILE Included: Modification time: 16-AUG-17
  758.   SPFILE db_unique_name: ORCL
  759.   Control File Included: Ckp SCN: 1118617      Ckp time: 16-AUG-17

  760. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  761. ------- ---- -- ---------- ----------- ------------ ---------------
  762. 51      Full    9.50M      SBT_TAPE    00:00:16     16-AUG-17      
  763.         BP Key: 54   Status: AVAILABLE  Compressed: NO  Tag: MY_CONTROLFILE_1
  764.         Handle: 1psc2sii_1_1   Media: station90-000003
  765.   Control File Included: Ckp SCN: 1118687      Ckp time: 16-AUG-17

  766. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  767. ------- ---- -- ---------- ----------- ------------ ---------------
  768. 52      Full    9.50M      SBT_TAPE    00:00:15     16-AUG-17      
  769.         BP Key: 55   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T203036
  770.         Handle: c-1343950367-20170816-03   Media: station90-000003
  771.   SPFILE Included: Modification time: 16-AUG-17
  772.   SPFILE db_unique_name: ORCL
  773.   Control File Included: Ckp SCN: 1118702      Ckp time: 16-AUG-17

  774. BS Key  Size       Device Type Elapsed Time Completion Time
  775. ------- ---------- ----------- ------------ ---------------
  776. 53      11.75M     SBT_TAPE    00:00:16     16-AUG-17      
  777.         BP Key: 56   Status: AVAILABLE  Compressed: NO  Tag: MY_ARCHIVELOG_29-30
  778.         Handle: 1rsc2srg_1_1   Media: station90-000003

  779.   List of Archived Logs in backup set 53
  780.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  781.   ---- ------- ---------- --------- ---------- ---------
  782.   1    29      1112021    16-AUG-17 1118839    16-AUG-17

  783. BS Key  Size       Device Type Elapsed Time Completion Time
  784. ------- ---------- ----------- ------------ ---------------
  785. 54      256.00K    SBT_TAPE    00:00:15     16-AUG-17      
  786.         BP Key: 57   Status: AVAILABLE  Compressed: NO  Tag: MY_ARCHIVELOG_29-30
  787.         Handle: 1ssc2stc_1_1   Media: station90-000003

  788.   List of Archived Logs in backup set 54
  789.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  790.   ---- ------- ---------- --------- ---------- ---------
  791.   1    30      1118839    16-AUG-17 1118850    16-AUG-17

  792. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  793. ------- ---- -- ---------- ----------- ------------ ---------------
  794. 55      Full    9.50M      SBT_TAPE    00:00:16     16-AUG-17      
  795.         BP Key: 58   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T203621
  796.         Handle: c-1343950367-20170816-04   Media: station90-000003
  797.   SPFILE Included: Modification time: 16-AUG-17
  798.   SPFILE db_unique_name: ORCL
  799.   Control File Included: Ckp SCN: 1118934      Ckp time: 16-AUG-17

  800. RMAN> backup backupset 50 ;

  801. Starting backup at 16-AUG-17
  802. using channel ORA_SBT_TAPE_1
  803. using channel ORA_SBT_TAPE_2
  804. skipping backup set key 50; already backed up 1 time(s)
  805. Finished backup at 16-AUG-17

  806. RMAN> backup backupset 50  force delete input  ;

  807. Starting backup at 16-AUG-17
  808. using channel ORA_SBT_TAPE_1
  809. using channel ORA_SBT_TAPE_2
  810. channel ORA_SBT_TAPE_1: input backup set: count=56, stamp=952201680, piece=1
  811. channel ORA_SBT_TAPE_1: starting piece 1 at 16-AUG-17
  812. channel ORA_SBT_TAPE_1: backup piece +FRA/orcl/autobackup/2017_08_16/s_952201680.261.952201681
  813. piece handle=1osc2seg_1_2 comment=API Version 2.0,MMS Version 10.4.0.4
  814. channel ORA_SBT_TAPE_1: finished piece 1 at 16-AUG-17
  815. channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:00:15
  816. deleted backup piece
  817. backup piece handle=+FRA/orcl/autobackup/2017_08_16/s_952201680.261.952201681 RECID=53 STAMP=952201681
  818. Finished backup at 16-AUG-17

  819. Starting Control File and SPFILE Autobackup at 16-AUG-17
  820. piece handle=c-1343950367-20170816-05 comment=API Version 2.0,MMS Version 10.4.0.4
  821. Finished Control File and SPFILE Autobackup at 16-AUG-17

  822. RMAN> list backup;


  823. List of Backup Sets
  824. ===================


  825. BS Key  Size       Device Type Elapsed Time Completion Time
  826. ------- ---------- ----------- ------------ ---------------
  827. 39      4.00M      SBT_TAPE    00:00:16     14-AUG-17      
  828.         BP Key: 39   Status: AVAILABLE  Compressed: NO  Tag: TAG20170814T213058
  829.         Handle: 1csbtnci_1_1   Media: station90-000003

  830.   List of Archived Logs in backup set 39
  831.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  832.   ---- ------- ---------- --------- ---------- ---------
  833.   1    27      1103423    14-AUG-17 1105603    14-AUG-17

  834. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  835. ------- ---- -- ---------- ----------- ------------ ---------------
  836. 40      Full    9.50M      SBT_TAPE    00:00:15     14-AUG-17      
  837.         BP Key: 40   Status: AVAILABLE  Compressed: NO  Tag: TAG20170814T213124
  838.         Handle: c-1343950367-20170814-01   Media: station90-000003
  839.   SPFILE Included: Modification time: 14-AUG-17
  840.   SPFILE db_unique_name: ORCL
  841.   Control File Included: Ckp SCN: 1105658      Ckp time: 14-AUG-17

  842. BS Key  Type LV Size
  843. ------- ---- -- ----------
  844. 41      Incr 1  14.58M
  845.   List of Datafiles in backup set 41
  846.   File LV Type Ckp SCN    Ckp Time  Name
  847.   ---- -- ---- ---------- --------- ----
  848.   1    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/system.256.816169553
  849.   2    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
  850.   3    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
  851.   4    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/users.259.816169553
  852.   5    1  Incr 1108088    15-AUG-17 +DATA/orcl/datafile/example.265.816169651

  853.   Backup Set Copy #1 of backup set 41
  854.   Device Type Elapsed Time Completion Time Compressed Tag
  855.   ----------- ------------ --------------- ---------- ---
  856.   DISK        00:00:01     15-AUG-17       NO         ORA_OEM_LEVEL_0

  857.     List of Backup Pieces for backup set 41 Copy #1
  858.     BP Key  Pc# Status      Piece Name
  859.     ------- --- ----------- ----------
  860.     41      1   AVAILABLE   +FRA/orcl/backupset/2017_08_15/nnndn1_ora_oem_level_0_0.268.952119027

  861.   Backup Set Copy #2 of backup set 41
  862.   Device Type Elapsed Time Completion Time Compressed Tag
  863.   ----------- ------------ --------------- ---------- ---
  864.   SBT_TAPE    00:00:01     15-AUG-17       NO         ORA_OEM_LEVEL_0

  865.     List of Backup Pieces for backup set 41 Copy #2
  866.     BP Key  Pc# Status      Media                   Piece Name
  867.     ------- --- ----------- ----------------------- ----------
  868.     45      1   AVAILABLE   station90-000003        1esc0bni_1_2

  869. BS Key  Type LV Size
  870. ------- ---- -- ----------
  871. 42      Full    9.36M
  872.   SPFILE Included: Modification time: 15-AUG-17
  873.   SPFILE db_unique_name: ORCL
  874.   Control File Included: Ckp SCN: 1108098      Ckp time: 15-AUG-17

  875.   Backup Set Copy #1 of backup set 42
  876.   Device Type Elapsed Time Completion Time Compressed Tag
  877.   ----------- ------------ --------------- ---------- ---
  878.   DISK        00:00:00     15-AUG-17       NO         TAG20170815T213029

  879.     List of Backup Pieces for backup set 42 Copy #1
  880.     BP Key  Pc# Status      Piece Name
  881.     ------- --- ----------- ----------
  882.     42      1   AVAILABLE   +FRA/orcl/autobackup/2017_08_15/s_952119029.269.952119029

  883.   Backup Set Copy #2 of backup set 42
  884.   Device Type Elapsed Time Completion Time Compressed Tag
  885.   ----------- ------------ --------------- ---------- ---
  886.   SBT_TAPE    00:00:00     15-AUG-17       NO         TAG20170815T213029

  887.     List of Backup Pieces for backup set 42 Copy #2
  888.     BP Key  Pc# Status      Media                   Piece Name
  889.     ------- --- ----------- ----------------------- ----------
  890.     47      1   AVAILABLE   station90-000003        c-1343950367-20170815-00

  891. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  892. ------- ---- -- ---------- ----------- ------------ ---------------
  893. 43      Full    425.25M    SBT_TAPE    00:00:26     15-AUG-17      
  894.         BP Key: 43   Status: AVAILABLE  Compressed: NO  Tag: TAG20170815T213042
  895.         Handle: 1hsc0bo2_1_1   Media: station90-000003
  896.   List of Datafiles in backup set 43
  897.   File LV Type Ckp SCN    Ckp Time  Name
  898.   ---- -- ---- ---------- --------- ----
  899.   2       Full 1105463    14-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
  900.   3       Full 1105481    14-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
  901.   4       Full 1105510    14-AUG-17 +DATA/orcl/datafile/users.259.816169553

  902. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  903. ------- ---- -- ---------- ----------- ------------ ---------------
  904. 44      Full    657.75M    SBT_TAPE    00:00:29     15-AUG-17      
  905.         BP Key: 44   Status: AVAILABLE  Compressed: NO  Tag: TAG20170815T213042
  906.         Handle: 1gsc0bo2_1_1   Media: station90-000004
  907.   List of Datafiles in backup set 44
  908.   File LV Type Ckp SCN    Ckp Time  Name
  909.   ---- -- ---- ---------- --------- ----
  910.   1       Full 1105450    14-AUG-17 +DATA/orcl/datafile/system.256.816169553
  911.   5       Full 1105495    14-AUG-17 +DATA/orcl/datafile/example.265.816169651

  912. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  913. ------- ---- -- ---------- ----------- ------------ ---------------
  914. 45      Full    9.50M      SBT_TAPE    00:00:16     15-AUG-17      
  915.         BP Key: 48   Status: AVAILABLE  Compressed: NO  Tag: TAG20170815T213209
  916.         Handle: c-1343950367-20170815-01   Media: station90-000003
  917.   SPFILE Included: Modification time: 15-AUG-17
  918.   SPFILE db_unique_name: ORCL
  919.   Control File Included: Ckp SCN: 1108330      Ckp time: 15-AUG-17

  920. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  921. ------- ---- -- ---------- ----------- ------------ ---------------
  922. 46      Incr 1  15.79M     DISK        00:00:02     16-AUG-17      
  923.         BP Key: 49   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  924.         Piece Name: +FRA/orcl/backupset/2017_08_16/nnndn1_ora_oem_level_0_0.270.952205439
  925.   List of Datafiles in backup set 46
  926.   File LV Type Ckp SCN    Ckp Time  Name
  927.   ---- -- ---- ---------- --------- ----
  928.   1    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/system.256.816169553
  929.   2    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
  930.   3    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
  931.   4    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/users.259.816169553
  932.   5    1  Incr 1111892    16-AUG-17 +DATA/orcl/datafile/example.265.816169651

  933. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  934. ------- ---- -- ---------- ----------- ------------ ---------------
  935. 47      Full    9.36M      DISK        00:00:01     16-AUG-17      
  936.         BP Key: 50   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T213039
  937.         Piece Name: +FRA/orcl/autobackup/2017_08_16/s_952205439.271.952205441
  938.   SPFILE Included: Modification time: 16-AUG-17
  939.   SPFILE db_unique_name: ORCL
  940.   Control File Included: Ckp SCN: 1111909      Ckp time: 16-AUG-17

  941. BS Key  Size       Device Type Elapsed Time Completion Time
  942. ------- ---------- ----------- ------------ ---------------
  943. 48      22.00M     SBT_TAPE    00:00:16     16-AUG-17      
  944.         BP Key: 51   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T213053
  945.         Handle: 1lsc304d_1_1   Media: station90-000003

  946.   List of Archived Logs in backup set 48
  947.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  948.   ---- ------- ---------- --------- ---------- ---------
  949.   1    28      1105603    14-AUG-17 1112021    16-AUG-17

  950. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  951. ------- ---- -- ---------- ----------- ------------ ---------------
  952. 49      Full    9.50M      SBT_TAPE    00:00:15     16-AUG-17      
  953.         BP Key: 52   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T213118
  954.         Handle: c-1343950367-20170816-01   Media: station90-000003
  955.   SPFILE Included: Modification time: 16-AUG-17
  956.   SPFILE db_unique_name: ORCL
  957.   Control File Included: Ckp SCN: 1112070      Ckp time: 16-AUG-17

  958. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  959. ------- ---- -- ---------- ----------- ------------ ---------------
  960. 50      Full    9.36M      SBT_TAPE    00:00:01     16-AUG-17      
  961.         BP Key: 59   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T202800
  962.         Handle: 1osc2seg_1_2   Media: station90-000003
  963.   SPFILE Included: Modification time: 16-AUG-17
  964.   SPFILE db_unique_name: ORCL
  965.   Control File Included: Ckp SCN: 1118617      Ckp time: 16-AUG-17

  966. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  967. ------- ---- -- ---------- ----------- ------------ ---------------
  968. 51      Full    9.50M      SBT_TAPE    00:00:16     16-AUG-17      
  969.         BP Key: 54   Status: AVAILABLE  Compressed: NO  Tag: MY_CONTROLFILE_1
  970.         Handle: 1psc2sii_1_1   Media: station90-000003
  971.   Control File Included: Ckp SCN: 1118687      Ckp time: 16-AUG-17

  972. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  973. ------- ---- -- ---------- ----------- ------------ ---------------
  974. 52      Full    9.50M      SBT_TAPE    00:00:15     16-AUG-17      
  975.         BP Key: 55   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T203036
  976.         Handle: c-1343950367-20170816-03   Media: station90-000003
  977.   SPFILE Included: Modification time: 16-AUG-17
  978.   SPFILE db_unique_name: ORCL
  979.   Control File Included: Ckp SCN: 1118702      Ckp time: 16-AUG-17

  980. BS Key  Size       Device Type Elapsed Time Completion Time
  981. ------- ---------- ----------- ------------ ---------------
  982. 53      11.75M     SBT_TAPE    00:00:16     16-AUG-17      
  983.         BP Key: 56   Status: AVAILABLE  Compressed: NO  Tag: MY_ARCHIVELOG_29-30
  984.         Handle: 1rsc2srg_1_1   Media: station90-000003

  985.   List of Archived Logs in backup set 53
  986.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  987.   ---- ------- ---------- --------- ---------- ---------
  988.   1    29      1112021    16-AUG-17 1118839    16-AUG-17

  989. BS Key  Size       Device Type Elapsed Time Completion Time
  990. ------- ---------- ----------- ------------ ---------------
  991. 54      256.00K    SBT_TAPE    00:00:15     16-AUG-17      
  992.         BP Key: 57   Status: AVAILABLE  Compressed: NO  Tag: MY_ARCHIVELOG_29-30
  993.         Handle: 1ssc2stc_1_1   Media: station90-000003

  994.   List of Archived Logs in backup set 54
  995.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  996.   ---- ------- ---------- --------- ---------- ---------
  997.   1    30      1118839    16-AUG-17 1118850    16-AUG-17

  998. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  999. ------- ---- -- ---------- ----------- ------------ ---------------
  1000. 55      Full    9.50M      SBT_TAPE    00:00:16     16-AUG-17      
  1001.         BP Key: 58   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T203621
  1002.         Handle: c-1343950367-20170816-04   Media: station90-000003
  1003.   SPFILE Included: Modification time: 16-AUG-17
  1004.   SPFILE db_unique_name: ORCL
  1005.   Control File Included: Ckp SCN: 1118934      Ckp time: 16-AUG-17

  1006. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  1007. ------- ---- -- ---------- ----------- ------------ ---------------
  1008. 56      Full    9.50M      SBT_TAPE    00:00:15     16-AUG-17      
  1009.         BP Key: 60   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T205557
  1010.         Handle: c-1343950367-20170816-05   Media: station90-000003
  1011.   SPFILE Included: Modification time: 16-AUG-17
  1012.   SPFILE db_unique_name: ORCL
  1013.   Control File Included: Ckp SCN: 1119429      Ckp time: 16-AUG-17

  1014. RMAN> delete noprompt backup;

  1015. allocated channel: ORA_DISK_1
  1016. channel ORA_DISK_1: SID=17 device type=DISK
  1017. allocated channel: ORA_DISK_2
  1018. channel ORA_DISK_2: SID=77 device type=DISK
  1019. allocated channel: ORA_DISK_3
  1020. channel ORA_DISK_3: SID=142 device type=DISK
  1021. allocated channel: ORA_DISK_4
  1022. channel ORA_DISK_4: SID=201 device type=DISK
  1023. allocated channel: ORA_DISK_5
  1024. channel ORA_DISK_5: SID=18 device type=DISK
  1025. allocated channel: ORA_DISK_6
  1026. channel ORA_DISK_6: SID=79 device type=DISK
  1027. allocated channel: ORA_DISK_7
  1028. channel ORA_DISK_7: SID=144 device type=DISK
  1029. allocated channel: ORA_DISK_8
  1030. channel ORA_DISK_8: SID=203 device type=DISK
  1031. using channel ORA_SBT_TAPE_1
  1032. using channel ORA_SBT_TAPE_2

  1033. List of Backup Pieces
  1034. BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
  1035. ------- ------- --- --- ----------- ----------- ----------
  1036. 39      39      1   1   AVAILABLE   SBT_TAPE    1csbtnci_1_1
  1037. 40      40      1   1   AVAILABLE   SBT_TAPE    c-1343950367-20170814-01
  1038. 41      41      1   1   AVAILABLE   DISK        +FRA/orcl/backupset/2017_08_15/nnndn1_ora_oem_level_0_0.268.952119027
  1039. 45      41      1   2   AVAILABLE   SBT_TAPE    1esc0bni_1_2
  1040. 42      42      1   1   AVAILABLE   DISK        +FRA/orcl/autobackup/2017_08_15/s_952119029.269.952119029
  1041. 47      42      1   2   AVAILABLE   SBT_TAPE    c-1343950367-20170815-00
  1042. 43      43      1   1   AVAILABLE   SBT_TAPE    1hsc0bo2_1_1
  1043. 44      44      1   1   AVAILABLE   SBT_TAPE    1gsc0bo2_1_1
  1044. 48      45      1   1   AVAILABLE   SBT_TAPE    c-1343950367-20170815-01
  1045. 49      46      1   1   AVAILABLE   DISK        +FRA/orcl/backupset/2017_08_16/nnndn1_ora_oem_level_0_0.270.952205439
  1046. 50      47      1   1   AVAILABLE   DISK        +FRA/orcl/autobackup/2017_08_16/s_952205439.271.952205441
  1047. 51      48      1   1   AVAILABLE   SBT_TAPE    1lsc304d_1_1
  1048. 52      49      1   1   AVAILABLE   SBT_TAPE    c-1343950367-20170816-01
  1049. 59      50      1   2   AVAILABLE   SBT_TAPE    1osc2seg_1_2
  1050. 54      51      1   1   AVAILABLE   SBT_TAPE    1psc2sii_1_1
  1051. 55      52      1   1   AVAILABLE   SBT_TAPE    c-1343950367-20170816-03
  1052. 56      53      1   1   AVAILABLE   SBT_TAPE    1rsc2srg_1_1
  1053. 57      54      1   1   AVAILABLE   SBT_TAPE    1ssc2stc_1_1
  1054. 58      55      1   1   AVAILABLE   SBT_TAPE    c-1343950367-20170816-04
  1055. 60      56      1   1   AVAILABLE   SBT_TAPE    c-1343950367-20170816-05
  1056. deleted backup piece
  1057. backup piece handle=1csbtnci_1_1 RECID=39 STAMP=952032658
  1058. deleted backup piece
  1059. backup piece handle=c-1343950367-20170814-01 RECID=40 STAMP=952032684
  1060. deleted backup piece
  1061. backup piece handle=1esc0bni_1_2 RECID=45 STAMP=952119079
  1062. deleted backup piece
  1063. backup piece handle=c-1343950367-20170815-00 RECID=47 STAMP=952119104
  1064. deleted backup piece
  1065. backup piece handle=1hsc0bo2_1_1 RECID=43 STAMP=952119043
  1066. deleted backup piece
  1067. backup piece handle=1gsc0bo2_1_1 RECID=44 STAMP=952119042
  1068. deleted backup piece
  1069. backup piece handle=c-1343950367-20170815-01 RECID=48 STAMP=952119129
  1070. deleted backup piece
  1071. backup piece handle=1lsc304d_1_1 RECID=51 STAMP=952205453
  1072. deleted backup piece
  1073. backup piece handle=c-1343950367-20170816-01 RECID=52 STAMP=952205478
  1074. deleted backup piece
  1075. backup piece handle=1osc2seg_1_2 RECID=59 STAMP=952203342
  1076. deleted backup piece
  1077. backup piece handle=1psc2sii_1_1 RECID=54 STAMP=952201811
  1078. deleted backup piece
  1079. backup piece handle=c-1343950367-20170816-03 RECID=55 STAMP=952201836
  1080. deleted backup piece
  1081. backup piece handle=1rsc2srg_1_1 RECID=56 STAMP=952202096
  1082. deleted backup piece
  1083. backup piece handle=1ssc2stc_1_1 RECID=57 STAMP=952202156
  1084. deleted backup piece
  1085. backup piece handle=c-1343950367-20170816-04 RECID=58 STAMP=952202182
  1086. deleted backup piece
  1087. backup piece handle=c-1343950367-20170816-05 RECID=60 STAMP=952203357
  1088. Deleted 16 objects

  1089. deleted backup piece
  1090. backup piece handle=+FRA/orcl/backupset/2017_08_15/nnndn1_ora_oem_level_0_0.268.952119027 RECID=41 STAMP=952119027
  1091. deleted backup piece
  1092. backup piece handle=+FRA/orcl/autobackup/2017_08_15/s_952119029.269.952119029 RECID=42 STAMP=952119029
  1093. deleted backup piece
  1094. backup piece handle=+FRA/orcl/backupset/2017_08_16/nnndn1_ora_oem_level_0_0.270.952205439 RECID=49 STAMP=952205438
  1095. deleted backup piece
  1096. backup piece handle=+FRA/orcl/autobackup/2017_08_16/s_952205439.271.952205441 RECID=50 STAMP=952205439
  1097. Deleted 4 objects


  1098. RMAN> list backup ;

  1099. specification does not match any backup in the repository

  1100. RMAN> list copy;

  1101. specification does not match any control file copy in the repository
  1102. List of Datafile Copies
  1103. =======================

  1104. Key     File S Completion Time Ckp SCN    Ckp Time      
  1105. ------- ---- - --------------- ---------- ---------------
  1106. 10      1    A 16-AUG-17       1108088    15-AUG-17      
  1107.         Name: +FRA/orcl/datafile/system.267.952032625
  1108.         Tag: ORA_OEM_LEVEL_0

  1109. 11      2    A 16-AUG-17       1108088    15-AUG-17      
  1110.         Name: +FRA/orcl/datafile/sysaux.266.952032633
  1111.         Tag: ORA_OEM_LEVEL_0

  1112. 9       3    A 16-AUG-17       1108088    15-AUG-17      
  1113.         Name: +FRA/orcl/datafile/undotbs1.265.952032641
  1114.         Tag: ORA_OEM_LEVEL_0

  1115. 13      4    A 16-AUG-17       1118610    16-AUG-17      
  1116.         Name: /home/oracle/mybackup/ORCL_data_D-ORCL_I-1343950367_TS-USERS_FNO-4_1nsc2sef
  1117.         Tag: TAG20170816T202759

  1118. 8       4    A 16-AUG-17       1108088    15-AUG-17      
  1119.         Name: +FRA/orcl/datafile/users.263.952032645
  1120.         Tag: ORA_OEM_LEVEL_0

  1121. 7       5    A 16-AUG-17       1108088    15-AUG-17      
  1122.         Name: +FRA/orcl/datafile/example.264.952032643
  1123.         Tag: ORA_OEM_LEVEL_0

  1124. List of Archived Log Copies for database with db_unique_name ORCL
  1125. =====================================================================

  1126. Key     Thrd Seq     S Low Time
  1127. ------- ---- ------- - ---------
  1128. 23      1    31      A 16-AUG-17
  1129.         Name: +FRA/orcl/archivelog/2017_08_16/thread_1_seq_31.261.952203887

  1130. 24      1    32      A 16-AUG-17
  1131.         Name: +FRA/orcl/archivelog/2017_08_16/thread_1_seq_32.262.952203973


  1132. RMAN> delete noprompt copy;

  1133. released channel: ORA_DISK_1
  1134. released channel: ORA_DISK_2
  1135. released channel: ORA_DISK_3
  1136. released channel: ORA_DISK_4
  1137. released channel: ORA_DISK_5
  1138. released channel: ORA_DISK_6
  1139. released channel: ORA_DISK_7
  1140. released channel: ORA_DISK_8
  1141. released channel: ORA_SBT_TAPE_1
  1142. released channel: ORA_SBT_TAPE_2
  1143. allocated channel: ORA_DISK_1
  1144. channel ORA_DISK_1: SID=136 device type=DISK
  1145. allocated channel: ORA_DISK_2
  1146. channel ORA_DISK_2: SID=13 device type=DISK
  1147. allocated channel: ORA_DISK_3
  1148. channel ORA_DISK_3: SID=17 device type=DISK
  1149. allocated channel: ORA_DISK_4
  1150. channel ORA_DISK_4: SID=77 device type=DISK
  1151. allocated channel: ORA_DISK_5
  1152. channel ORA_DISK_5: SID=142 device type=DISK
  1153. allocated channel: ORA_DISK_6
  1154. channel ORA_DISK_6: SID=201 device type=DISK
  1155. allocated channel: ORA_DISK_7
  1156. channel ORA_DISK_7: SID=18 device type=DISK
  1157. allocated channel: ORA_DISK_8
  1158. channel ORA_DISK_8: SID=79 device type=DISK
  1159. specification does not match any control file copy in the repository
  1160. List of Datafile Copies
  1161. =======================

  1162. Key     File S Completion Time Ckp SCN    Ckp Time      
  1163. ------- ---- - --------------- ---------- ---------------
  1164. 10      1    A 16-AUG-17       1108088    15-AUG-17      
  1165.         Name: +FRA/orcl/datafile/system.267.952032625
  1166.         Tag: ORA_OEM_LEVEL_0

  1167. 11      2    A 16-AUG-17       1108088    15-AUG-17      
  1168.         Name: +FRA/orcl/datafile/sysaux.266.952032633
  1169.         Tag: ORA_OEM_LEVEL_0

  1170. 9       3    A 16-AUG-17       1108088    15-AUG-17      
  1171.         Name: +FRA/orcl/datafile/undotbs1.265.952032641
  1172.         Tag: ORA_OEM_LEVEL_0

  1173. 13      4    A 16-AUG-17       1118610    16-AUG-17      
  1174.         Name: /home/oracle/mybackup/ORCL_data_D-ORCL_I-1343950367_TS-USERS_FNO-4_1nsc2sef
  1175.         Tag: TAG20170816T202759

  1176. 8       4    A 16-AUG-17       1108088    15-AUG-17      
  1177.         Name: +FRA/orcl/datafile/users.263.952032645
  1178.         Tag: ORA_OEM_LEVEL_0

  1179. 7       5    A 16-AUG-17       1108088    15-AUG-17      
  1180.         Name: +FRA/orcl/datafile/example.264.952032643
  1181.         Tag: ORA_OEM_LEVEL_0

  1182. List of Archived Log Copies for database with db_unique_name ORCL
  1183. =====================================================================

  1184. Key     Thrd Seq     S Low Time
  1185. ------- ---- ------- - ---------
  1186. 23      1    31      A 16-AUG-17
  1187.         Name: +FRA/orcl/archivelog/2017_08_16/thread_1_seq_31.261.952203887

  1188. 24      1    32      A 16-AUG-17
  1189.         Name: +FRA/orcl/archivelog/2017_08_16/thread_1_seq_32.262.952203973

  1190. deleted datafile copy
  1191. datafile copy file name=+FRA/orcl/datafile/system.267.952032625 RECID=10 STAMP=952205433
  1192. deleted datafile copy
  1193. datafile copy file name=+FRA/orcl/datafile/sysaux.266.952032633 RECID=11 STAMP=952205433
  1194. deleted datafile copy
  1195. datafile copy file name=+FRA/orcl/datafile/undotbs1.265.952032641 RECID=9 STAMP=952205432
  1196. deleted datafile copy
  1197. datafile copy file name=/home/oracle/mybackup/ORCL_data_D-ORCL_I-1343950367_TS-USERS_FNO-4_1nsc2sef RECID=13 STAMP=952201679
  1198. deleted datafile copy
  1199. datafile copy file name=+FRA/orcl/datafile/users.263.952032645 RECID=8 STAMP=952205432
  1200. deleted datafile copy
  1201. datafile copy file name=+FRA/orcl/datafile/example.264.952032643 RECID=7 STAMP=952205432
  1202. deleted archived log
  1203. archived log file name=+FRA/orcl/archivelog/2017_08_16/thread_1_seq_31.261.952203887 RECID=23 STAMP=952203886
  1204. deleted archived log
  1205. archived log file name=+FRA/orcl/archivelog/2017_08_16/thread_1_seq_32.262.952203973 RECID=24 STAMP=952203973
  1206. Deleted 8 objects


  1207. RMAN> list copy;

  1208. specification does not match any datafile copy in the repository
  1209. specification does not match any control file copy in the repository
  1210. specification does not match any archived log in the repository

  1211. RMAN> backup tag '1_WHOLE_INCR0' incremental level 0 database plus archivelog delete all input;


  1212. Starting backup at 16-AUG-17
  1213. current log archived
  1214. released channel: ORA_DISK_1
  1215. released channel: ORA_DISK_2
  1216. released channel: ORA_DISK_3
  1217. released channel: ORA_DISK_4
  1218. released channel: ORA_DISK_5
  1219. released channel: ORA_DISK_6
  1220. released channel: ORA_DISK_7
  1221. released channel: ORA_DISK_8
  1222. allocated channel: ORA_SBT_TAPE_1
  1223. channel ORA_SBT_TAPE_1: SID=136 device type=SBT_TAPE
  1224. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  1225. allocated channel: ORA_SBT_TAPE_2
  1226. channel ORA_SBT_TAPE_2: SID=13 device type=SBT_TAPE
  1227. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  1228. channel ORA_SBT_TAPE_1: starting archived log backup set
  1229. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  1230. input archived log thread=1 sequence=33 RECID=25 STAMP=952204557
  1231. channel ORA_SBT_TAPE_1: starting piece 1 at 16-AUG-17
  1232. channel ORA_SBT_TAPE_1: finished piece 1 at 16-AUG-17
  1233. piece handle=1vsc2v8o_1_1 tag=1_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  1234. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  1235. channel ORA_SBT_TAPE_1: deleting archived log(s)
  1236. archived log file name=+FRA/orcl/archivelog/2017_08_16/thread_1_seq_33.262.952204557 RECID=25 STAMP=952204557
  1237. Finished backup at 16-AUG-17

  1238. Starting backup at 16-AUG-17
  1239. using channel ORA_SBT_TAPE_1
  1240. using channel ORA_SBT_TAPE_2
  1241. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  1242. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  1243. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  1244. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  1245. channel ORA_SBT_TAPE_1: starting piece 1 at 16-AUG-17
  1246. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  1247. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  1248. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  1249. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  1250. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  1251. channel ORA_SBT_TAPE_2: starting piece 1 at 16-AUG-17
  1252. channel ORA_SBT_TAPE_1: finished piece 1 at 16-AUG-17
  1253. piece handle=20sc2v9i_1_1 tag=1_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  1254. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  1255. channel ORA_SBT_TAPE_2: finished piece 1 at 16-AUG-17
  1256. piece handle=21sc2v9i_1_1 tag=1_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  1257. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  1258. Finished backup at 16-AUG-17

  1259. Starting backup at 16-AUG-17
  1260. current log archived
  1261. using channel ORA_SBT_TAPE_1
  1262. using channel ORA_SBT_TAPE_2
  1263. channel ORA_SBT_TAPE_1: starting archived log backup set
  1264. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  1265. input archived log thread=1 sequence=34 RECID=26 STAMP=952204620
  1266. channel ORA_SBT_TAPE_1: starting piece 1 at 16-AUG-17
  1267. channel ORA_SBT_TAPE_1: finished piece 1 at 16-AUG-17
  1268. piece handle=22sc2vac_1_1 tag=1_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  1269. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  1270. channel ORA_SBT_TAPE_1: deleting archived log(s)
  1271. archived log file name=+FRA/orcl/archivelog/2017_08_16/thread_1_seq_34.262.952204621 RECID=26 STAMP=952204620
  1272. Finished backup at 16-AUG-17

  1273. Starting Control File and SPFILE Autobackup at 16-AUG-17
  1274. piece handle=c-1343950367-20170816-06 comment=API Version 2.0,MMS Version 10.4.0.4
  1275. Finished Control File and SPFILE Autobackup at 16-AUG-17

  1276. RMAN> exit


  1277. Recovery Manager complete.
  1278. [oracle@station90 ~]$ ls
  1279. a.sql                    mail            osb.txt            select_t04209_uname.sql  ttio.rcv                  模板  下载
  1280. copytape-root.sh         mybackup        pfile.txt          spfile.ora               update2_t04209_uname.sql  视频  音乐
  1281. create_t04209_uname.sql  mylink.txt      rac_tns            spfileorcl.ora           update_t04209_uname.sql   图片  桌面
  1282. initorcl.ora             oradiag_oracle  revertape-root.sh  tnsnames.ora             公共的                    文档
  1283. [oracle@station90 ~]$ vim .bash_profile
  1284. [oracle@station90 ~]$ vim .bash_profile
  1285. [oracle@station90 ~]$ . .bash_profile
  1286. [oracle@station90 ~]$ date
  1287. 2017年 08月 17日 星期四 21:20:56 CST
  1288. [oracle@station90 ~]$ rman target /

  1289. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Aug 17 21:21:01 2017

  1290. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  1291. connected to target database: ORCL (DBID=1343950367)

  1292. RMAN> backup tag '2_WHOLE_INCR0' incremental level 0 database plus archivelog delete all input;


  1293. Starting backup at 2017-08-17:21:21:37
  1294. current log archived
  1295. using target database control file instead of recovery catalog
  1296. allocated channel: ORA_SBT_TAPE_1
  1297. channel ORA_SBT_TAPE_1: SID=77 device type=SBT_TAPE
  1298. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  1299. allocated channel: ORA_SBT_TAPE_2
  1300. channel ORA_SBT_TAPE_2: SID=194 device type=SBT_TAPE
  1301. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  1302. channel ORA_SBT_TAPE_1: starting archived log backup set
  1303. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  1304. input archived log thread=1 sequence=35 RECID=27 STAMP=952291279
  1305. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-17:21:21:51
  1306. channel ORA_SBT_TAPE_2: starting archived log backup set
  1307. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
  1308. input archived log thread=1 sequence=36 RECID=28 STAMP=952291300
  1309. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-08-17:21:21:52
  1310. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-17:21:22:17
  1311. piece handle=24sc5jvf_1_1 tag=2_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  1312. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
  1313. channel ORA_SBT_TAPE_1: deleting archived log(s)
  1314. archived log file name=+FRA/orcl/archivelog/2017_08_17/thread_1_seq_35.262.952291279 RECID=27 STAMP=952291279
  1315. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-08-17:21:22:17
  1316. piece handle=25sc5jvg_1_1 tag=2_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  1317. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  1318. channel ORA_SBT_TAPE_2: deleting archived log(s)
  1319. archived log file name=+FRA/orcl/archivelog/2017_08_17/thread_1_seq_36.261.952291301 RECID=28 STAMP=952291300
  1320. Finished backup at 2017-08-17:21:22:17

  1321. Starting backup at 2017-08-17:21:22:17
  1322. using channel ORA_SBT_TAPE_1
  1323. using channel ORA_SBT_TAPE_2
  1324. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  1325. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  1326. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  1327. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  1328. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-17:21:22:17
  1329. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  1330. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  1331. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  1332. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  1333. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  1334. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-08-17:21:22:18
  1335. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-17:21:22:43
  1336. piece handle=26sc5k09_1_1 tag=2_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  1337. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
  1338. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-08-17:21:22:43
  1339. piece handle=27sc5k09_1_1 tag=2_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  1340. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  1341. Finished backup at 2017-08-17:21:22:43

  1342. Starting backup at 2017-08-17:21:22:43
  1343. current log archived
  1344. using channel ORA_SBT_TAPE_1
  1345. using channel ORA_SBT_TAPE_2
  1346. channel ORA_SBT_TAPE_1: starting archived log backup set
  1347. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  1348. input archived log thread=1 sequence=37 RECID=29 STAMP=952291363
  1349. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-17:21:22:44
  1350. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-17:21:23:09
  1351. piece handle=28sc5k13_1_1 tag=2_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  1352. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  1353. channel ORA_SBT_TAPE_1: deleting archived log(s)
  1354. archived log file name=+FRA/orcl/archivelog/2017_08_17/thread_1_seq_37.261.952291363 RECID=29 STAMP=952291363
  1355. Finished backup at 2017-08-17:21:23:09

  1356. Starting Control File and SPFILE Autobackup at 2017-08-17:21:23:09
  1357. piece handle=c-1343950367-20170817-00 comment=API Version 2.0,MMS Version 10.4.0.4
  1358. Finished Control File and SPFILE Autobackup at 2017-08-17:21:23:34

  1359. RMAN> exit


  1360. Recovery Manager complete.
  1361. [oracle@station90 ~]$ rman target /

  1362. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Aug 17 23:58:15 2017

  1363. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  1364. connected to target database: ORCL (DBID=1343950367)

  1365. RMAN> report obsolete ;

  1366. using target database control file instead of recovery catalog
  1367. RMAN retention policy will be applied to the command
  1368. RMAN retention policy is set to recovery window of 1 days
  1369. Report of obsolete backups and copies
  1370. Type                 Key    Completion Time    Filename/Handle
  1371. -------------------- ------ ------------------ --------------------
  1372. Backup Set           57     2017-08-16:21:16:23
  1373.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1374. RMAN> list backupset 57;


  1375. List of Backup Sets
  1376. ===================


  1377. BS Key  Size       Device Type Elapsed Time Completion Time   
  1378. ------- ---------- ----------- ------------ -------------------
  1379. 57      13.75M     SBT_TAPE    00:00:15     2017-08-16:21:16:23
  1380.         BP Key: 61   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  1381.         Handle: 1vsc2v8o_1_1   Media: station90-000005

  1382.   List of Archived Logs in backup set 57
  1383.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1384.   ---- ------- ---------- ------------------- ---------- ---------
  1385.   1    33      1126178    2017-08-16:21:06:13 1136362    2017-08-16:21:15:56

  1386. RMAN> report obsolete ;

  1387. RMAN retention policy will be applied to the command
  1388. RMAN retention policy is set to recovery window of 1 days
  1389. Report of obsolete backups and copies
  1390. Type                 Key    Completion Time    Filename/Handle
  1391. -------------------- ------ ------------------ --------------------
  1392. Backup Set           57     2017-08-16:21:16:23
  1393.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1394. RMAN> report obsolete ;

  1395. RMAN retention policy will be applied to the command
  1396. RMAN retention policy is set to recovery window of 1 days
  1397. Report of obsolete backups and copies
  1398. Type                 Key    Completion Time    Filename/Handle
  1399. -------------------- ------ ------------------ --------------------
  1400. Backup Set           57     2017-08-16:21:16:23
  1401.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1402. RMAN> report obsolete ;

  1403. RMAN retention policy will be applied to the command
  1404. RMAN retention policy is set to recovery window of 1 days
  1405. Report of obsolete backups and copies
  1406. Type                 Key    Completion Time    Filename/Handle
  1407. -------------------- ------ ------------------ --------------------
  1408. Backup Set           57     2017-08-16:21:16:23
  1409.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1410. RMAN> report obsolete ;

  1411. RMAN retention policy will be applied to the command
  1412. RMAN retention policy is set to recovery window of 1 days
  1413. Report of obsolete backups and copies
  1414. Type                 Key    Completion Time    Filename/Handle
  1415. -------------------- ------ ------------------ --------------------
  1416. Backup Set           57     2017-08-16:21:16:23
  1417.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1418. RMAN> report obsolete ;

  1419. RMAN retention policy will be applied to the command
  1420. RMAN retention policy is set to recovery window of 1 days
  1421. Report of obsolete backups and copies
  1422. Type                 Key    Completion Time    Filename/Handle
  1423. -------------------- ------ ------------------ --------------------
  1424. Backup Set           57     2017-08-16:21:16:23
  1425.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1426. RMAN> report obsolete ;

  1427. RMAN retention policy will be applied to the command
  1428. RMAN retention policy is set to recovery window of 1 days
  1429. Report of obsolete backups and copies
  1430. Type                 Key    Completion Time    Filename/Handle
  1431. -------------------- ------ ------------------ --------------------
  1432. Backup Set           57     2017-08-16:21:16:23
  1433.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1434. RMAN> report obsolete ;

  1435. RMAN retention policy will be applied to the command
  1436. RMAN retention policy is set to recovery window of 1 days
  1437. Report of obsolete backups and copies
  1438. Type                 Key    Completion Time    Filename/Handle
  1439. -------------------- ------ ------------------ --------------------
  1440. Backup Set           57     2017-08-16:21:16:23
  1441.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1442. RMAN> report obsolete ;

  1443. RMAN retention policy will be applied to the command
  1444. RMAN retention policy is set to recovery window of 1 days
  1445. Report of obsolete backups and copies
  1446. Type                 Key    Completion Time    Filename/Handle
  1447. -------------------- ------ ------------------ --------------------
  1448. Backup Set           57     2017-08-16:21:16:23
  1449.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1450. RMAN> report obsolete ;

  1451. RMAN retention policy will be applied to the command
  1452. RMAN retention policy is set to recovery window of 1 days
  1453. Report of obsolete backups and copies
  1454. Type                 Key    Completion Time    Filename/Handle
  1455. -------------------- ------ ------------------ --------------------
  1456. Backup Set           57     2017-08-16:21:16:23
  1457.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1458. RMAN> list backup;


  1459. List of Backup Sets
  1460. ===================


  1461. BS Key  Size       Device Type Elapsed Time Completion Time   
  1462. ------- ---------- ----------- ------------ -------------------
  1463. 57      13.75M     SBT_TAPE    00:00:15     2017-08-16:21:16:23
  1464.         BP Key: 61   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  1465.         Handle: 1vsc2v8o_1_1   Media: station90-000005

  1466.   List of Archived Logs in backup set 57
  1467.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1468.   ---- ------- ---------- ------------------- ---------- ---------
  1469.   1    33      1126178    2017-08-16:21:06:13 1136362    2017-08-16:21:15:56

  1470. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1471. ------- ---- -- ---------- ----------- ------------ -------------------
  1472. 58      Incr 0  658.00M    SBT_TAPE    00:00:18     2017-08-16:21:16:52
  1473.         BP Key: 62   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  1474.         Handle: 20sc2v9i_1_1   Media: station90-000005
  1475.   List of Datafiles in backup set 58
  1476.   File LV Type Ckp SCN    Ckp Time            Name
  1477.   ---- -- ---- ---------- ------------------- ----
  1478.   1    0  Incr 1136650    2017-08-16:21:16:34 +DATA/orcl/datafile/system.256.816169553
  1479.   5    0  Incr 1136650    2017-08-16:21:16:34 +DATA/orcl/datafile/example.265.816169651

  1480. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1481. ------- ---- -- ---------- ----------- ------------ -------------------
  1482. 59      Incr 0  474.25M    SBT_TAPE    00:00:20     2017-08-16:21:16:54
  1483.         BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  1484.         Handle: 21sc2v9i_1_1   Media: station90-000006
  1485.   List of Datafiles in backup set 59
  1486.   File LV Type Ckp SCN    Ckp Time            Name
  1487.   ---- -- ---- ---------- ------------------- ----
  1488.   2    0  Incr 1136653    2017-08-16:21:16:35 +DATA/orcl/datafile/sysaux.257.816169553
  1489.   3    0  Incr 1136653    2017-08-16:21:16:35 +DATA/orcl/datafile/undotbs1.258.816169553
  1490.   4    0  Incr 1136653    2017-08-16:21:16:35 +DATA/orcl/datafile/users.259.816169553

  1491. BS Key  Size       Device Type Elapsed Time Completion Time   
  1492. ------- ---------- ----------- ------------ -------------------
  1493. 60      768.00K    SBT_TAPE    00:00:16     2017-08-16:21:17:16
  1494.         BP Key: 64   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  1495.         Handle: 22sc2vac_1_1   Media: station90-000005

  1496.   List of Archived Logs in backup set 60
  1497.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1498.   ---- ------- ---------- ------------------- ---------- ---------
  1499.   1    34      1136362    2017-08-16:21:15:56 1136762    2017-08-16:21:17:00

  1500. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1501. ------- ---- -- ---------- ----------- ------------ -------------------
  1502. 61      Full    9.50M      SBT_TAPE    00:00:15     2017-08-16:21:17:41
  1503.         BP Key: 65   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T211726
  1504.         Handle: c-1343950367-20170816-06   Media: station90-000005
  1505.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  1506.   SPFILE db_unique_name: ORCL
  1507.   Control File Included: Ckp SCN: 1136943      Ckp time: 2017-08-16:21:17:26

  1508. BS Key  Size       Device Type Elapsed Time Completion Time   
  1509. ------- ---------- ----------- ------------ -------------------
  1510. 62      22.25M     SBT_TAPE    00:00:16     2017-08-17:21:22:07
  1511.         BP Key: 66   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  1512.         Handle: 24sc5jvf_1_1   Media: station90-000005

  1513.   List of Archived Logs in backup set 62
  1514.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1515.   ---- ------- ---------- ------------------- ---------- ---------
  1516.   1    35      1136762    2017-08-16:21:17:00 1140768    2017-08-17:21:21:19

  1517. BS Key  Size       Device Type Elapsed Time Completion Time   
  1518. ------- ---------- ----------- ------------ -------------------
  1519. 63      1.50M      SBT_TAPE    00:00:24     2017-08-17:21:22:16
  1520.         BP Key: 67   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  1521.         Handle: 25sc5jvg_1_1   Media: station90-000006

  1522.   List of Archived Logs in backup set 63
  1523.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1524.   ---- ------- ---------- ------------------- ---------- ---------
  1525.   1    36      1140768    2017-08-17:21:21:19 1141334    2017-08-17:21:21:39

  1526. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1527. ------- ---- -- ---------- ----------- ------------ -------------------
  1528. 64      Incr 0  658.00M    SBT_TAPE    00:00:19     2017-08-17:21:22:36
  1529.         BP Key: 68   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  1530.         Handle: 26sc5k09_1_1   Media: station90-000005
  1531.   List of Datafiles in backup set 64
  1532.   File LV Type Ckp SCN    Ckp Time            Name
  1533.   ---- -- ---- ---------- ------------------- ----
  1534.   1    0  Incr 1141789    2017-08-17:21:22:18 +DATA/orcl/datafile/system.256.816169553
  1535.   5    0  Incr 1141789    2017-08-17:21:22:18 +DATA/orcl/datafile/example.265.816169651

  1536. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1537. ------- ---- -- ---------- ----------- ------------ -------------------
  1538. 65      Incr 0  461.00M    SBT_TAPE    00:00:21     2017-08-17:21:22:38
  1539.         BP Key: 69   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  1540.         Handle: 27sc5k09_1_1   Media: station90-000006
  1541.   List of Datafiles in backup set 65
  1542.   File LV Type Ckp SCN    Ckp Time            Name
  1543.   ---- -- ---- ---------- ------------------- ----
  1544.   2    0  Incr 1141792    2017-08-17:21:22:18 +DATA/orcl/datafile/sysaux.257.816169553
  1545.   3    0  Incr 1141792    2017-08-17:21:22:18 +DATA/orcl/datafile/undotbs1.258.816169553
  1546.   4    0  Incr 1141792    2017-08-17:21:22:18 +DATA/orcl/datafile/users.259.816169553

  1547. BS Key  Size       Device Type Elapsed Time Completion Time   
  1548. ------- ---------- ----------- ------------ -------------------
  1549. 66      2.25M      SBT_TAPE    00:00:16     2017-08-17:21:22:59
  1550.         BP Key: 70   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  1551.         Handle: 28sc5k13_1_1   Media: station90-000005

  1552.   List of Archived Logs in backup set 66
  1553.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1554.   ---- ------- ---------- ------------------- ---------- ---------
  1555.   1    37      1141334    2017-08-17:21:21:39 1141844    2017-08-17:21:22:43

  1556. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1557. ------- ---- -- ---------- ----------- ------------ -------------------
  1558. 67      Full    9.50M      SBT_TAPE    00:00:16     2017-08-17:21:23:25
  1559.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T212309
  1560.         Handle: c-1343950367-20170817-00   Media: station90-000005
  1561.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  1562.   SPFILE db_unique_name: ORCL
  1563.   Control File Included: Ckp SCN: 1141877      Ckp time: 2017-08-17:21:23:09

  1564. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1565. ------- ---- -- ---------- ----------- ------------ -------------------
  1566. 68      Full    9.36M      DISK        00:00:01     2017-08-17:23:59:37
  1567.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T235936
  1568.         Piece Name: +FRA/orcl/autobackup/2017_08_17/s_952300776.271.952300777
  1569.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  1570.   SPFILE db_unique_name: ORCL
  1571.   Control File Included: Ckp SCN: 1160572      Ckp time: 2017-08-17:23:59:36

  1572. BS Key  Size       Device Type Elapsed Time Completion Time   
  1573. ------- ---------- ----------- ------------ -------------------
  1574. 69      11.50M     SBT_TAPE    00:00:16     2017-08-18:00:00:06
  1575.         BP Key: 73   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T235950
  1576.         Handle: 2hsc5t7m_1_1   Media: station90-000005

  1577.   List of Archived Logs in backup set 69
  1578.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1579.   ---- ------- ---------- ------------------- ---------- ---------
  1580.   1    40      1157900    2017-08-17:23:59:20 1160826    2017-08-17:23:59:49

  1581. BS Key  Size       Device Type Elapsed Time Completion Time   
  1582. ------- ---------- ----------- ------------ -------------------
  1583. 70      37.50M     SBT_TAPE    00:00:24     2017-08-18:00:00:14
  1584.         BP Key: 74   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T235950
  1585.         Handle: 2gsc5t7m_1_1   Media: station90-000006

  1586.   List of Archived Logs in backup set 70
  1587.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1588.   ---- ------- ---------- ------------------- ---------- ---------
  1589.   1    38      1141844    2017-08-17:21:22:43 1154066    2017-08-17:23:58:39
  1590.   1    39      1154066    2017-08-17:23:58:39 1157900    2017-08-17:23:59:20

  1591. RMAN> exit


  1592. Recovery Manager complete.
  1593. [oracle@station90 ~]$ rman target /

  1594. Recovery Manager: Release 11.2.0.1.0 - Production on Fri Aug 18 21:20:04 2017

  1595. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  1596. connected to target database: ORCL (DBID=1343950367)

  1597. RMAN> report obsolete ;

  1598. using target database control file instead of recovery catalog
  1599. RMAN retention policy will be applied to the command
  1600. RMAN retention policy is set to recovery window of 1 days
  1601. Report of obsolete backups and copies
  1602. Type                 Key    Completion Time    Filename/Handle
  1603. -------------------- ------ ------------------ --------------------
  1604. Backup Set           57     2017-08-16:21:16:23
  1605.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1606. RMAN> report obsolete ;

  1607. RMAN retention policy will be applied to the command
  1608. RMAN retention policy is set to recovery window of 1 days
  1609. Report of obsolete backups and copies
  1610. Type                 Key    Completion Time    Filename/Handle
  1611. -------------------- ------ ------------------ --------------------
  1612. Backup Set           57     2017-08-16:21:16:23
  1613.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1614. RMAN> report obsolete ;

  1615. RMAN retention policy will be applied to the command
  1616. RMAN retention policy is set to recovery window of 1 days
  1617. Report of obsolete backups and copies
  1618. Type                 Key    Completion Time    Filename/Handle
  1619. -------------------- ------ ------------------ --------------------
  1620. Backup Set           57     2017-08-16:21:16:23
  1621.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1622. RMAN> report obsolete ;

  1623. RMAN retention policy will be applied to the command
  1624. RMAN retention policy is set to recovery window of 1 days
  1625. Report of obsolete backups and copies
  1626. Type                 Key    Completion Time    Filename/Handle
  1627. -------------------- ------ ------------------ --------------------
  1628. Backup Set           57     2017-08-16:21:16:23
  1629.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1630. RMAN> report obsolete ;

  1631. RMAN retention policy will be applied to the command
  1632. RMAN retention policy is set to recovery window of 1 days
  1633. Report of obsolete backups and copies
  1634. Type                 Key    Completion Time    Filename/Handle
  1635. -------------------- ------ ------------------ --------------------
  1636. Backup Set           57     2017-08-16:21:16:23
  1637.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1638. RMAN> report obsolete ;

  1639. RMAN retention policy will be applied to the command
  1640. RMAN retention policy is set to recovery window of 1 days
  1641. Report of obsolete backups and copies
  1642. Type                 Key    Completion Time    Filename/Handle
  1643. -------------------- ------ ------------------ --------------------
  1644. Backup Set           57     2017-08-16:21:16:23
  1645.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1646. RMAN> report obsolete ;

  1647. RMAN retention policy will be applied to the command
  1648. RMAN retention policy is set to recovery window of 1 days
  1649. Report of obsolete backups and copies
  1650. Type                 Key    Completion Time    Filename/Handle
  1651. -------------------- ------ ------------------ --------------------
  1652. Backup Set           57     2017-08-16:21:16:23
  1653.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1654. RMAN> report obsolete ;

  1655. RMAN retention policy will be applied to the command
  1656. RMAN retention policy is set to recovery window of 1 days
  1657. Report of obsolete backups and copies
  1658. Type                 Key    Completion Time    Filename/Handle
  1659. -------------------- ------ ------------------ --------------------
  1660. Backup Set           57     2017-08-16:21:16:23
  1661.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1662. RMAN> report obsolete ;

  1663. RMAN retention policy will be applied to the command
  1664. RMAN retention policy is set to recovery window of 1 days
  1665. Report of obsolete backups and copies
  1666. Type                 Key    Completion Time    Filename/Handle
  1667. -------------------- ------ ------------------ --------------------
  1668. Backup Set           57     2017-08-16:21:16:23
  1669.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1670. RMAN> report obsolete ;

  1671. RMAN retention policy will be applied to the command
  1672. RMAN retention policy is set to recovery window of 1 days
  1673. Report of obsolete backups and copies
  1674. Type                 Key    Completion Time    Filename/Handle
  1675. -------------------- ------ ------------------ --------------------
  1676. Backup Set           57     2017-08-16:21:16:23
  1677.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1678. RMAN> report obsolete ;

  1679. RMAN retention policy will be applied to the command
  1680. RMAN retention policy is set to recovery window of 1 days
  1681. Report of obsolete backups and copies
  1682. Type                 Key    Completion Time    Filename/Handle
  1683. -------------------- ------ ------------------ --------------------
  1684. Backup Set           57     2017-08-16:21:16:23
  1685.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1686. RMAN> report obsolete ;

  1687. RMAN retention policy will be applied to the command
  1688. RMAN retention policy is set to recovery window of 1 days
  1689. Report of obsolete backups and copies
  1690. Type                 Key    Completion Time    Filename/Handle
  1691. -------------------- ------ ------------------ --------------------
  1692. Backup Set           57     2017-08-16:21:16:23
  1693.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1694. RMAN> report obsolete ;

  1695. RMAN retention policy will be applied to the command
  1696. RMAN retention policy is set to recovery window of 1 days
  1697. Report of obsolete backups and copies
  1698. Type                 Key    Completion Time    Filename/Handle
  1699. -------------------- ------ ------------------ --------------------
  1700. Backup Set           57     2017-08-16:21:16:23
  1701.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1702. RMAN> report obsolete ;

  1703. RMAN retention policy will be applied to the command
  1704. RMAN retention policy is set to recovery window of 1 days
  1705. Report of obsolete backups and copies
  1706. Type                 Key    Completion Time    Filename/Handle
  1707. -------------------- ------ ------------------ --------------------
  1708. Backup Set           57     2017-08-16:21:16:23
  1709.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1710. RMAN> report obsolete ;

  1711. RMAN retention policy will be applied to the command
  1712. RMAN retention policy is set to recovery window of 1 days
  1713. Report of obsolete backups and copies
  1714. Type                 Key    Completion Time    Filename/Handle
  1715. -------------------- ------ ------------------ --------------------
  1716. Backup Set           57     2017-08-16:21:16:23
  1717.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1718. RMAN> report obsolete ;

  1719. RMAN retention policy will be applied to the command
  1720. RMAN retention policy is set to recovery window of 1 days
  1721. Report of obsolete backups and copies
  1722. Type                 Key    Completion Time    Filename/Handle
  1723. -------------------- ------ ------------------ --------------------
  1724. Backup Set           57     2017-08-16:21:16:23
  1725.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1726. RMAN> report obsolete ;

  1727. RMAN retention policy will be applied to the command
  1728. RMAN retention policy is set to recovery window of 1 days
  1729. Report of obsolete backups and copies
  1730. Type                 Key    Completion Time    Filename/Handle
  1731. -------------------- ------ ------------------ --------------------
  1732. Backup Set           57     2017-08-16:21:16:23
  1733.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1734. RMAN> report obsolete ;

  1735. RMAN retention policy will be applied to the command
  1736. RMAN retention policy is set to recovery window of 1 days
  1737. Report of obsolete backups and copies
  1738. Type                 Key    Completion Time    Filename/Handle
  1739. -------------------- ------ ------------------ --------------------
  1740. Backup Set           57     2017-08-16:21:16:23
  1741.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1742. RMAN> report obsolete ;

  1743. RMAN retention policy will be applied to the command
  1744. RMAN retention policy is set to recovery window of 1 days
  1745. Report of obsolete backups and copies
  1746. Type                 Key    Completion Time    Filename/Handle
  1747. -------------------- ------ ------------------ --------------------
  1748. Backup Set           57     2017-08-16:21:16:23
  1749.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1750. RMAN> report obsolete ;

  1751. RMAN retention policy will be applied to the command
  1752. RMAN retention policy is set to recovery window of 1 days
  1753. Report of obsolete backups and copies
  1754. Type                 Key    Completion Time    Filename/Handle
  1755. -------------------- ------ ------------------ --------------------
  1756. Backup Set           57     2017-08-16:21:16:23
  1757.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1758. RMAN> report obsolete ;

  1759. RMAN retention policy will be applied to the command
  1760. RMAN retention policy is set to recovery window of 1 days
  1761. Report of obsolete backups and copies
  1762. Type                 Key    Completion Time    Filename/Handle
  1763. -------------------- ------ ------------------ --------------------
  1764. Backup Set           57     2017-08-16:21:16:23
  1765.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1766. RMAN> report obsolete ;

  1767. RMAN retention policy will be applied to the command
  1768. RMAN retention policy is set to recovery window of 1 days
  1769. Report of obsolete backups and copies
  1770. Type                 Key    Completion Time    Filename/Handle
  1771. -------------------- ------ ------------------ --------------------
  1772. Backup Set           57     2017-08-16:21:16:23
  1773.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1774. RMAN> report obsolete ;

  1775. RMAN retention policy will be applied to the command
  1776. RMAN retention policy is set to recovery window of 1 days
  1777. Report of obsolete backups and copies
  1778. Type                 Key    Completion Time    Filename/Handle
  1779. -------------------- ------ ------------------ --------------------
  1780. Backup Set           57     2017-08-16:21:16:23
  1781.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1782. RMAN> report obsolete ;

  1783. RMAN retention policy will be applied to the command
  1784. RMAN retention policy is set to recovery window of 1 days
  1785. Report of obsolete backups and copies
  1786. Type                 Key    Completion Time    Filename/Handle
  1787. -------------------- ------ ------------------ --------------------
  1788. Backup Set           57     2017-08-16:21:16:23
  1789.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1790. RMAN> report obsolete ;

  1791. RMAN retention policy will be applied to the command
  1792. RMAN retention policy is set to recovery window of 1 days
  1793. Report of obsolete backups and copies
  1794. Type                 Key    Completion Time    Filename/Handle
  1795. -------------------- ------ ------------------ --------------------
  1796. Backup Set           57     2017-08-16:21:16:23
  1797.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1798. RMAN> report obsolete ;

  1799. RMAN retention policy will be applied to the command
  1800. RMAN retention policy is set to recovery window of 1 days
  1801. Report of obsolete backups and copies
  1802. Type                 Key    Completion Time    Filename/Handle
  1803. -------------------- ------ ------------------ --------------------
  1804. Backup Set           57     2017-08-16:21:16:23
  1805.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1806. RMAN> report obsolete ;

  1807. RMAN retention policy will be applied to the command
  1808. RMAN retention policy is set to recovery window of 1 days
  1809. Report of obsolete backups and copies
  1810. Type                 Key    Completion Time    Filename/Handle
  1811. -------------------- ------ ------------------ --------------------
  1812. Backup Set           57     2017-08-16:21:16:23
  1813.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1814. RMAN> report obsolete ;

  1815. RMAN retention policy will be applied to the command
  1816. RMAN retention policy is set to recovery window of 1 days
  1817. Report of obsolete backups and copies
  1818. Type                 Key    Completion Time    Filename/Handle
  1819. -------------------- ------ ------------------ --------------------
  1820. Backup Set           57     2017-08-16:21:16:23
  1821.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1822. RMAN> report obsolete ;

  1823. RMAN retention policy will be applied to the command
  1824. RMAN retention policy is set to recovery window of 1 days
  1825. Report of obsolete backups and copies
  1826. Type                 Key    Completion Time    Filename/Handle
  1827. -------------------- ------ ------------------ --------------------
  1828. Backup Set           57     2017-08-16:21:16:23
  1829.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1830. RMAN> report obsolete ;

  1831. RMAN retention policy will be applied to the command
  1832. RMAN retention policy is set to recovery window of 1 days
  1833. Report of obsolete backups and copies
  1834. Type                 Key    Completion Time    Filename/Handle
  1835. -------------------- ------ ------------------ --------------------
  1836. Backup Set           57     2017-08-16:21:16:23
  1837.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1838. RMAN> report obsolete ;

  1839. RMAN retention policy will be applied to the command
  1840. RMAN retention policy is set to recovery window of 1 days
  1841. Report of obsolete backups and copies
  1842. Type                 Key    Completion Time    Filename/Handle
  1843. -------------------- ------ ------------------ --------------------
  1844. Backup Set           57     2017-08-16:21:16:23
  1845.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1846. RMAN> report obsolete ;

  1847. RMAN retention policy will be applied to the command
  1848. RMAN retention policy is set to recovery window of 1 days
  1849. Report of obsolete backups and copies
  1850. Type                 Key    Completion Time    Filename/Handle
  1851. -------------------- ------ ------------------ --------------------
  1852. Backup Set           57     2017-08-16:21:16:23
  1853.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1854. RMAN> report obsolete ;

  1855. RMAN retention policy will be applied to the command
  1856. RMAN retention policy is set to recovery window of 1 days
  1857. Report of obsolete backups and copies
  1858. Type                 Key    Completion Time    Filename/Handle
  1859. -------------------- ------ ------------------ --------------------
  1860. Backup Set           57     2017-08-16:21:16:23
  1861.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1862. RMAN> report obsolete ;

  1863. RMAN retention policy will be applied to the command
  1864. RMAN retention policy is set to recovery window of 1 days
  1865. Report of obsolete backups and copies
  1866. Type                 Key    Completion Time    Filename/Handle
  1867. -------------------- ------ ------------------ --------------------
  1868. Backup Set           57     2017-08-16:21:16:23
  1869.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1870. RMAN> report obsolete ;

  1871. RMAN retention policy will be applied to the command
  1872. RMAN retention policy is set to recovery window of 1 days
  1873. Report of obsolete backups and copies
  1874. Type                 Key    Completion Time    Filename/Handle
  1875. -------------------- ------ ------------------ --------------------
  1876. Backup Set           57     2017-08-16:21:16:23
  1877.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1878. RMAN> report obsolete ;

  1879. RMAN retention policy will be applied to the command
  1880. RMAN retention policy is set to recovery window of 1 days
  1881. report obsolete ;
  1882. Report of obsolete backups and copies
  1883. Type                 Key    Completion Time    Filename/Handle
  1884. -------------------- ------ ------------------ --------------------
  1885. Backup Set           57     2017-08-16:21:16:23
  1886.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1887. RMAN>
  1888. RMAN retention policy will be applied to the command
  1889. RMAN retention policy is set to recovery window of 1 days
  1890. Report of obsolete backups and copies
  1891. Type                 Key    Completion Time    Filename/Handle
  1892. -------------------- ------ ------------------ --------------------
  1893. Backup Set           57     2017-08-16:21:16:23
  1894.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1895. RMAN> report obsolete ;

  1896. RMAN retention policy will be applied to the command
  1897. RMAN retention policy is set to recovery window of 1 days
  1898. Report of obsolete backups and copies
  1899. Type                 Key    Completion Time    Filename/Handle
  1900. -------------------- ------ ------------------ --------------------
  1901. Backup Set           57     2017-08-16:21:16:23
  1902.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1903. RMAN> report obsolete ;

  1904. RMAN retention policy will be applied to the command
  1905. RMAN retention policy is set to recovery window of 1 days
  1906. Report of obsolete backups and copies
  1907. Type                 Key    Completion Time    Filename/Handle
  1908. -------------------- ------ ------------------ --------------------
  1909. Backup Set           57     2017-08-16:21:16:23
  1910.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1911. RMAN> report obsolete ;

  1912. RMAN retention policy will be applied to the command
  1913. RMAN retention policy is set to recovery window of 1 days
  1914. Report of obsolete backups and copies
  1915. Type                 Key    Completion Time    Filename/Handle
  1916. -------------------- ------ ------------------ --------------------
  1917. Backup Set           57     2017-08-16:21:16:23
  1918.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1919. RMAN> report obsolete ;

  1920. RMAN retention policy will be applied to the command
  1921. RMAN retention policy is set to recovery window of 1 days
  1922. Report of obsolete backups and copies
  1923. Type                 Key    Completion Time    Filename/Handle
  1924. -------------------- ------ ------------------ --------------------
  1925. Backup Set           57     2017-08-16:21:16:23
  1926.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1927. RMAN> report obsolete ;

  1928. RMAN retention policy will be applied to the command
  1929. RMAN retention policy is set to recovery window of 1 days
  1930. Report of obsolete backups and copies
  1931. Type                 Key    Completion Time    Filename/Handle
  1932. -------------------- ------ ------------------ --------------------
  1933. Backup Set           57     2017-08-16:21:16:23
  1934.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1935. RMAN> report obsolete ;

  1936. RMAN retention policy will be applied to the command
  1937. RMAN retention policy is set to recovery window of 1 days
  1938. Report of obsolete backups and copies
  1939. Type                 Key    Completion Time    Filename/Handle
  1940. -------------------- ------ ------------------ --------------------
  1941. Backup Set           57     2017-08-16:21:16:23
  1942.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1943. RMAN> report obsolete ;

  1944. RMAN retention policy will be applied to the command
  1945. RMAN retention policy is set to recovery window of 1 days
  1946. Report of obsolete backups and copies
  1947. Type                 Key    Completion Time    Filename/Handle
  1948. -------------------- ------ ------------------ --------------------
  1949. Backup Set           57     2017-08-16:21:16:23
  1950.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1951. RMAN> report obsolete ;

  1952. RMAN retention policy will be applied to the command
  1953. RMAN retention policy is set to recovery window of 1 days
  1954. Report of obsolete backups and copies
  1955. Type                 Key    Completion Time    Filename/Handle
  1956. -------------------- ------ ------------------ --------------------
  1957. Backup Set           57     2017-08-16:21:16:23
  1958.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1959. RMAN> report obsolete ;

  1960. RMAN retention policy will be applied to the command
  1961. RMAN retention policy is set to recovery window of 1 days
  1962. Report of obsolete backups and copies
  1963. Type                 Key    Completion Time    Filename/Handle
  1964. -------------------- ------ ------------------ --------------------
  1965. Backup Set           57     2017-08-16:21:16:23
  1966.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1967. RMAN> report obsolete ;

  1968. RMAN retention policy will be applied to the command
  1969. RMAN retention policy is set to recovery window of 1 days
  1970. Report of obsolete backups and copies
  1971. Type                 Key    Completion Time    Filename/Handle
  1972. -------------------- ------ ------------------ --------------------
  1973. Backup Set           57     2017-08-16:21:16:23
  1974.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1975. RMAN> report obsolete ;

  1976. RMAN retention policy will be applied to the command
  1977. RMAN retention policy is set to recovery window of 1 days
  1978. Report of obsolete backups and copies
  1979. Type                 Key    Completion Time    Filename/Handle
  1980. -------------------- ------ ------------------ --------------------
  1981. Backup Set           57     2017-08-16:21:16:23
  1982.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1983. RMAN> report obsolete ;

  1984. RMAN retention policy will be applied to the command
  1985. RMAN retention policy is set to recovery window of 1 days
  1986. Report of obsolete backups and copies
  1987. Type                 Key    Completion Time    Filename/Handle
  1988. -------------------- ------ ------------------ --------------------
  1989. Backup Set           57     2017-08-16:21:16:23
  1990.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1991. RMAN> report obsolete ;

  1992. RMAN retention policy will be applied to the command
  1993. RMAN retention policy is set to recovery window of 1 days
  1994. Report of obsolete backups and copies
  1995. Type                 Key    Completion Time    Filename/Handle
  1996. -------------------- ------ ------------------ --------------------
  1997. Backup Set           57     2017-08-16:21:16:23
  1998.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  1999. RMAN> report obsolete ;

  2000. RMAN retention policy will be applied to the command
  2001. RMAN retention policy is set to recovery window of 1 days
  2002. Report of obsolete backups and copies
  2003. Type                 Key    Completion Time    Filename/Handle
  2004. -------------------- ------ ------------------ --------------------
  2005. Backup Set           57     2017-08-16:21:16:23
  2006.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2007. RMAN> report obsolete ;

  2008. RMAN retention policy will be applied to the command
  2009. RMAN retention policy is set to recovery window of 1 days
  2010. Report of obsolete backups and copies
  2011. Type                 Key    Completion Time    Filename/Handle
  2012. -------------------- ------ ------------------ --------------------
  2013. Backup Set           57     2017-08-16:21:16:23
  2014.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2015. RMAN> report obsolete ;

  2016. RMAN retention policy will be applied to the command
  2017. RMAN retention policy is set to recovery window of 1 days
  2018. Report of obsolete backups and copies
  2019. Type                 Key    Completion Time    Filename/Handle
  2020. -------------------- ------ ------------------ --------------------
  2021. Backup Set           57     2017-08-16:21:16:23
  2022.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2023. RMAN> report obsolete ;

  2024. RMAN retention policy will be applied to the command
  2025. RMAN retention policy is set to recovery window of 1 days
  2026. Report of obsolete backups and copies
  2027. Type                 Key    Completion Time    Filename/Handle
  2028. -------------------- ------ ------------------ --------------------
  2029. Backup Set           57     2017-08-16:21:16:23
  2030.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2031. RMAN> report obsolete ;

  2032. RMAN retention policy will be applied to the command
  2033. RMAN retention policy is set to recovery window of 1 days
  2034. Report of obsolete backups and copies
  2035. Type                 Key    Completion Time    Filename/Handle
  2036. -------------------- ------ ------------------ --------------------
  2037. Backup Set           57     2017-08-16:21:16:23
  2038.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2039. RMAN> report obsolete ;

  2040. RMAN retention policy will be applied to the command
  2041. RMAN retention policy is set to recovery window of 1 days
  2042. Report of obsolete backups and copies
  2043. Type                 Key    Completion Time    Filename/Handle
  2044. -------------------- ------ ------------------ --------------------
  2045. Backup Set           57     2017-08-16:21:16:23
  2046.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2047. RMAN> report obsolete ;

  2048. RMAN retention policy will be applied to the command
  2049. RMAN retention policy is set to recovery window of 1 days
  2050. Report of obsolete backups and copies
  2051. Type                 Key    Completion Time    Filename/Handle
  2052. -------------------- ------ ------------------ --------------------
  2053. Backup Set           57     2017-08-16:21:16:23
  2054.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2055. RMAN> report obsolete ;

  2056. RMAN retention policy will be applied to the command
  2057. RMAN retention policy is set to recovery window of 1 days
  2058. Report of obsolete backups and copies
  2059. Type                 Key    Completion Time    Filename/Handle
  2060. -------------------- ------ ------------------ --------------------
  2061. Backup Set           57     2017-08-16:21:16:23
  2062.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2063. RMAN> report obsolete ;

  2064. RMAN retention policy will be applied to the command
  2065. RMAN retention policy is set to recovery window of 1 days
  2066. Report of obsolete backups and copies
  2067. Type                 Key    Completion Time    Filename/Handle
  2068. -------------------- ------ ------------------ --------------------
  2069. Backup Set           57     2017-08-16:21:16:23
  2070.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2071. RMAN> report obsolete ;

  2072. RMAN retention policy will be applied to the command
  2073. RMAN retention policy is set to recovery window of 1 days
  2074. Report of obsolete backups and copies
  2075. Type                 Key    Completion Time    Filename/Handle
  2076. -------------------- ------ ------------------ --------------------
  2077. Backup Set           57     2017-08-16:21:16:23
  2078.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2079. RMAN> report obsolete ;

  2080. RMAN retention policy will be applied to the command
  2081. RMAN retention policy is set to recovery window of 1 days
  2082. Report of obsolete backups and copies
  2083. Type                 Key    Completion Time    Filename/Handle
  2084. -------------------- ------ ------------------ --------------------
  2085. Backup Set           57     2017-08-16:21:16:23
  2086.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2087. RMAN> report obsolete ;

  2088. RMAN retention policy will be applied to the command
  2089. RMAN retention policy is set to recovery window of 1 days
  2090. Report of obsolete backups and copies
  2091. Type                 Key    Completion Time    Filename/Handle
  2092. -------------------- ------ ------------------ --------------------
  2093. Backup Set           57     2017-08-16:21:16:23
  2094.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2095. RMAN> report obsolete ;

  2096. RMAN retention policy will be applied to the command
  2097. RMAN retention policy is set to recovery window of 1 days
  2098. Report of obsolete backups and copies
  2099. Type                 Key    Completion Time    Filename/Handle
  2100. -------------------- ------ ------------------ --------------------
  2101. Backup Set           57     2017-08-16:21:16:23
  2102.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2103. RMAN> report obsolete ;

  2104. RMAN retention policy will be applied to the command
  2105. RMAN retention policy is set to recovery window of 1 days
  2106. Report of obsolete backups and copies
  2107. Type                 Key    Completion Time    Filename/Handle
  2108. -------------------- ------ ------------------ --------------------
  2109. Backup Set           57     2017-08-16:21:16:23
  2110.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2111. RMAN> report obsolete ;

  2112. RMAN retention policy will be applied to the command
  2113. RMAN retention policy is set to recovery window of 1 days
  2114. Report of obsolete backups and copies
  2115. Type                 Key    Completion Time    Filename/Handle
  2116. -------------------- ------ ------------------ --------------------
  2117. Backup Set           57     2017-08-16:21:16:23
  2118.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2119. RMAN> report obsolete ;

  2120. RMAN retention policy will be applied to the command
  2121. RMAN retention policy is set to recovery window of 1 days
  2122. Report of obsolete backups and copies
  2123. Type                 Key    Completion Time    Filename/Handle
  2124. -------------------- ------ ------------------ --------------------
  2125. Backup Set           57     2017-08-16:21:16:23
  2126.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2127. RMAN> report obsolete ;

  2128. RMAN retention policy will be applied to the command
  2129. RMAN retention policy is set to recovery window of 1 days
  2130. Report of obsolete backups and copies
  2131. Type                 Key    Completion Time    Filename/Handle
  2132. -------------------- ------ ------------------ --------------------
  2133. Backup Set           57     2017-08-16:21:16:23
  2134.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2135. RMAN> report obsolete ;

  2136. RMAN retention policy will be applied to the command
  2137. RMAN retention policy is set to recovery window of 1 days
  2138. Report of obsolete backups and copies
  2139. Type                 Key    Completion Time    Filename/Handle
  2140. -------------------- ------ ------------------ --------------------
  2141. Backup Set           57     2017-08-16:21:16:23
  2142.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2143. RMAN> report obsolete ;

  2144. RMAN retention policy will be applied to the command
  2145. RMAN retention policy is set to recovery window of 1 days
  2146. Report of obsolete backups and copies
  2147. Type                 Key    Completion Time    Filename/Handle
  2148. -------------------- ------ ------------------ --------------------
  2149. Backup Set           57     2017-08-16:21:16:23
  2150.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2151. RMAN> report obsolete ;

  2152. RMAN retention policy will be applied to the command
  2153. RMAN retention policy is set to recovery window of 1 days
  2154. Report of obsolete backups and copies
  2155. Type                 Key    Completion Time    Filename/Handle
  2156. -------------------- ------ ------------------ --------------------
  2157. Backup Set           57     2017-08-16:21:16:23
  2158.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2159. RMAN> report obsolete ;

  2160. RMAN retention policy will be applied to the command
  2161. RMAN retention policy is set to recovery window of 1 days
  2162. Report of obsolete backups and copies
  2163. Type                 Key    Completion Time    Filename/Handle
  2164. -------------------- ------ ------------------ --------------------
  2165. Backup Set           57     2017-08-16:21:16:23
  2166.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1

  2167. RMAN> list backup;


  2168. List of Backup Sets
  2169. ===================


  2170. BS Key  Size       Device Type Elapsed Time Completion Time   
  2171. ------- ---------- ----------- ------------ -------------------
  2172. 57      13.75M     SBT_TAPE    00:00:15     2017-08-16:21:16:23
  2173.         BP Key: 61   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  2174.         Handle: 1vsc2v8o_1_1   Media: station90-000005

  2175.   List of Archived Logs in backup set 57
  2176.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2177.   ---- ------- ---------- ------------------- ---------- ---------
  2178.   1    33      1126178    2017-08-16:21:06:13 1136362    2017-08-16:21:15:56

  2179. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2180. ------- ---- -- ---------- ----------- ------------ -------------------
  2181. 58      Incr 0  658.00M    SBT_TAPE    00:00:18     2017-08-16:21:16:52
  2182.         BP Key: 62   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  2183.         Handle: 20sc2v9i_1_1   Media: station90-000005
  2184.   List of Datafiles in backup set 58
  2185.   File LV Type Ckp SCN    Ckp Time            Name
  2186.   ---- -- ---- ---------- ------------------- ----
  2187.   1    0  Incr 1136650    2017-08-16:21:16:34 +DATA/orcl/datafile/system.256.816169553
  2188.   5    0  Incr 1136650    2017-08-16:21:16:34 +DATA/orcl/datafile/example.265.816169651

  2189. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2190. ------- ---- -- ---------- ----------- ------------ -------------------
  2191. 59      Incr 0  474.25M    SBT_TAPE    00:00:20     2017-08-16:21:16:54
  2192.         BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  2193.         Handle: 21sc2v9i_1_1   Media: station90-000006
  2194.   List of Datafiles in backup set 59
  2195.   File LV Type Ckp SCN    Ckp Time            Name
  2196.   ---- -- ---- ---------- ------------------- ----
  2197.   2    0  Incr 1136653    2017-08-16:21:16:35 +DATA/orcl/datafile/sysaux.257.816169553
  2198.   3    0  Incr 1136653    2017-08-16:21:16:35 +DATA/orcl/datafile/undotbs1.258.816169553
  2199.   4    0  Incr 1136653    2017-08-16:21:16:35 +DATA/orcl/datafile/users.259.816169553

  2200. BS Key  Size       Device Type Elapsed Time Completion Time   
  2201. ------- ---------- ----------- ------------ -------------------
  2202. 60      768.00K    SBT_TAPE    00:00:16     2017-08-16:21:17:16
  2203.         BP Key: 64   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  2204.         Handle: 22sc2vac_1_1   Media: station90-000005

  2205.   List of Archived Logs in backup set 60
  2206.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2207.   ---- ------- ---------- ------------------- ---------- ---------
  2208.   1    34      1136362    2017-08-16:21:15:56 1136762    2017-08-16:21:17:00

  2209. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2210. ------- ---- -- ---------- ----------- ------------ -------------------
  2211. 61      Full    9.50M      SBT_TAPE    00:00:15     2017-08-16:21:17:41
  2212.         BP Key: 65   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T211726
  2213.         Handle: c-1343950367-20170816-06   Media: station90-000005
  2214.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2215.   SPFILE db_unique_name: ORCL
  2216.   Control File Included: Ckp SCN: 1136943      Ckp time: 2017-08-16:21:17:26

  2217. BS Key  Size       Device Type Elapsed Time Completion Time   
  2218. ------- ---------- ----------- ------------ -------------------
  2219. 62      22.25M     SBT_TAPE    00:00:16     2017-08-17:21:22:07
  2220.         BP Key: 66   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  2221.         Handle: 24sc5jvf_1_1   Media: station90-000005

  2222.   List of Archived Logs in backup set 62
  2223.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2224.   ---- ------- ---------- ------------------- ---------- ---------
  2225.   1    35      1136762    2017-08-16:21:17:00 1140768    2017-08-17:21:21:19

  2226. BS Key  Size       Device Type Elapsed Time Completion Time   
  2227. ------- ---------- ----------- ------------ -------------------
  2228. 63      1.50M      SBT_TAPE    00:00:24     2017-08-17:21:22:16
  2229.         BP Key: 67   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  2230.         Handle: 25sc5jvg_1_1   Media: station90-000006

  2231.   List of Archived Logs in backup set 63
  2232.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2233.   ---- ------- ---------- ------------------- ---------- ---------
  2234.   1    36      1140768    2017-08-17:21:21:19 1141334    2017-08-17:21:21:39

  2235. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2236. ------- ---- -- ---------- ----------- ------------ -------------------
  2237. 64      Incr 0  658.00M    SBT_TAPE    00:00:19     2017-08-17:21:22:36
  2238.         BP Key: 68   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  2239.         Handle: 26sc5k09_1_1   Media: station90-000005
  2240.   List of Datafiles in backup set 64
  2241.   File LV Type Ckp SCN    Ckp Time            Name
  2242.   ---- -- ---- ---------- ------------------- ----
  2243.   1    0  Incr 1141789    2017-08-17:21:22:18 +DATA/orcl/datafile/system.256.816169553
  2244.   5    0  Incr 1141789    2017-08-17:21:22:18 +DATA/orcl/datafile/example.265.816169651

  2245. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2246. ------- ---- -- ---------- ----------- ------------ -------------------
  2247. 65      Incr 0  461.00M    SBT_TAPE    00:00:21     2017-08-17:21:22:38
  2248.         BP Key: 69   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  2249.         Handle: 27sc5k09_1_1   Media: station90-000006
  2250.   List of Datafiles in backup set 65
  2251.   File LV Type Ckp SCN    Ckp Time            Name
  2252.   ---- -- ---- ---------- ------------------- ----
  2253.   2    0  Incr 1141792    2017-08-17:21:22:18 +DATA/orcl/datafile/sysaux.257.816169553
  2254.   3    0  Incr 1141792    2017-08-17:21:22:18 +DATA/orcl/datafile/undotbs1.258.816169553
  2255.   4    0  Incr 1141792    2017-08-17:21:22:18 +DATA/orcl/datafile/users.259.816169553

  2256. BS Key  Size       Device Type Elapsed Time Completion Time   
  2257. ------- ---------- ----------- ------------ -------------------
  2258. 66      2.25M      SBT_TAPE    00:00:16     2017-08-17:21:22:59
  2259.         BP Key: 70   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  2260.         Handle: 28sc5k13_1_1   Media: station90-000005

  2261.   List of Archived Logs in backup set 66
  2262.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2263.   ---- ------- ---------- ------------------- ---------- ---------
  2264.   1    37      1141334    2017-08-17:21:21:39 1141844    2017-08-17:21:22:43

  2265. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2266. ------- ---- -- ---------- ----------- ------------ -------------------
  2267. 67      Full    9.50M      SBT_TAPE    00:00:16     2017-08-17:21:23:25
  2268.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T212309
  2269.         Handle: c-1343950367-20170817-00   Media: station90-000005
  2270.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2271.   SPFILE db_unique_name: ORCL
  2272.   Control File Included: Ckp SCN: 1141877      Ckp time: 2017-08-17:21:23:09

  2273. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2274. ------- ---- -- ---------- ----------- ------------ -------------------
  2275. 68      Full    9.36M      DISK        00:00:01     2017-08-17:23:59:37
  2276.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T235936
  2277.         Piece Name: +FRA/orcl/autobackup/2017_08_17/s_952300776.271.952300777
  2278.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2279.   SPFILE db_unique_name: ORCL
  2280.   Control File Included: Ckp SCN: 1160572      Ckp time: 2017-08-17:23:59:36

  2281. BS Key  Size       Device Type Elapsed Time Completion Time   
  2282. ------- ---------- ----------- ------------ -------------------
  2283. 69      11.50M     SBT_TAPE    00:00:16     2017-08-18:00:00:06
  2284.         BP Key: 73   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T235950
  2285.         Handle: 2hsc5t7m_1_1   Media: station90-000005

  2286.   List of Archived Logs in backup set 69
  2287.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2288.   ---- ------- ---------- ------------------- ---------- ---------
  2289.   1    40      1157900    2017-08-17:23:59:20 1160826    2017-08-17:23:59:49

  2290. BS Key  Size       Device Type Elapsed Time Completion Time   
  2291. ------- ---------- ----------- ------------ -------------------
  2292. 70      37.50M     SBT_TAPE    00:00:24     2017-08-18:00:00:14
  2293.         BP Key: 74   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T235950
  2294.         Handle: 2gsc5t7m_1_1   Media: station90-000006

  2295.   List of Archived Logs in backup set 70
  2296.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2297.   ---- ------- ---------- ------------------- ---------- ---------
  2298.   1    38      1141844    2017-08-17:21:22:43 1154066    2017-08-17:23:58:39
  2299.   1    39      1154066    2017-08-17:23:58:39 1157900    2017-08-17:23:59:20

  2300. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2301. ------- ---- -- ---------- ----------- ------------ -------------------
  2302. 71      Full    9.50M      SBT_TAPE    00:00:16     2017-08-18:00:00:34
  2303.         BP Key: 75   Status: AVAILABLE  Compressed: NO  Tag: TAG20170818T000018
  2304.         Handle: c-1343950367-20170818-00   Media: station90-000006
  2305.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2306.   SPFILE db_unique_name: ORCL
  2307.   Control File Included: Ckp SCN: 1204844      Ckp time: 2017-08-18:00:00:18

  2308. RMAN> report obsolete ;

  2309. RMAN retention policy will be applied to the command
  2310. RMAN retention policy is set to recovery window of 1 days
  2311. Report of obsolete backups and copies
  2312. Type                 Key    Completion Time    Filename/Handle
  2313. -------------------- ------ ------------------ --------------------
  2314. Backup Set           57     2017-08-16:21:16:23
  2315.   Backup Piece       61     2017-08-16:21:16:23 1vsc2v8o_1_1
  2316. Backup Set           58     2017-08-16:21:16:52
  2317.   Backup Piece       62     2017-08-16:21:16:52 20sc2v9i_1_1
  2318. Backup Set           59     2017-08-16:21:16:54
  2319.   Backup Piece       63     2017-08-16:21:16:54 21sc2v9i_1_1
  2320. Backup Set           60     2017-08-16:21:17:16
  2321.   Backup Piece       64     2017-08-16:21:17:16 22sc2vac_1_1

  2322. RMAN> list backupset 58,59,60 ;


  2323. List of Backup Sets
  2324. ===================


  2325. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2326. ------- ---- -- ---------- ----------- ------------ -------------------
  2327. 58      Incr 0  658.00M    SBT_TAPE    00:00:18     2017-08-16:21:16:52
  2328.         BP Key: 62   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  2329.         Handle: 20sc2v9i_1_1   Media: station90-000005
  2330.   List of Datafiles in backup set 58
  2331.   File LV Type Ckp SCN    Ckp Time            Name
  2332.   ---- -- ---- ---------- ------------------- ----
  2333.   1    0  Incr 1136650    2017-08-16:21:16:34 +DATA/orcl/datafile/system.256.816169553
  2334.   5    0  Incr 1136650    2017-08-16:21:16:34 +DATA/orcl/datafile/example.265.816169651

  2335. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2336. ------- ---- -- ---------- ----------- ------------ -------------------
  2337. 59      Incr 0  474.25M    SBT_TAPE    00:00:20     2017-08-16:21:16:54
  2338.         BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  2339.         Handle: 21sc2v9i_1_1   Media: station90-000006
  2340.   List of Datafiles in backup set 59
  2341.   File LV Type Ckp SCN    Ckp Time            Name
  2342.   ---- -- ---- ---------- ------------------- ----
  2343.   2    0  Incr 1136653    2017-08-16:21:16:35 +DATA/orcl/datafile/sysaux.257.816169553
  2344.   3    0  Incr 1136653    2017-08-16:21:16:35 +DATA/orcl/datafile/undotbs1.258.816169553
  2345.   4    0  Incr 1136653    2017-08-16:21:16:35 +DATA/orcl/datafile/users.259.816169553

  2346. BS Key  Size       Device Type Elapsed Time Completion Time   
  2347. ------- ---------- ----------- ------------ -------------------
  2348. 60      768.00K    SBT_TAPE    00:00:16     2017-08-16:21:17:16
  2349.         BP Key: 64   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  2350.         Handle: 22sc2vac_1_1   Media: station90-000005

  2351.   List of Archived Logs in backup set 60
  2352.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2353.   ---- ------- ---------- ------------------- ---------- ---------
  2354.   1    34      1136362    2017-08-16:21:15:56 1136762    2017-08-16:21:17:00

  2355. RMAN> report need backup;

  2356. RMAN retention policy will be applied to the command
  2357. RMAN retention policy is set to recovery window of 1 days
  2358. Report of files that must be backed up to satisfy 1 days recovery window
  2359. File Days  Name
  2360. ---- ----- -----------------------------------------------------

  2361. RMAN> exit


  2362. Recovery Manager complete.
  2363. [oracle@station90 ~]$ rman target /

  2364. Recovery Manager: Release 11.2.0.1.0 - Production on Fri Aug 18 23:59:04 2017

  2365. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  2366. connected to target database: ORCL (DBID=1343950367)

  2367. RMAN> report need backup;

  2368. using target database control file instead of recovery catalog
  2369. RMAN retention policy will be applied to the command
  2370. RMAN retention policy is set to recovery window of 1 days
  2371. Report of files that must be backed up to satisfy 1 days recovery window
  2372. File Days  Name
  2373. ---- ----- -----------------------------------------------------

  2374. RMAN> report need backup;

  2375. RMAN retention policy will be applied to the command
  2376. RMAN retention policy is set to recovery window of 1 days
  2377. Report of files that must be backed up to satisfy 1 days recovery window
  2378. File Days  Name
  2379. ---- ----- -----------------------------------------------------

  2380. RMAN> report need backup;

  2381. RMAN retention policy will be applied to the command
  2382. RMAN retention policy is set to recovery window of 1 days
  2383. Report of files that must be backed up to satisfy 1 days recovery window
  2384. File Days  Name
  2385. ---- ----- -----------------------------------------------------
  2386. 1    2     +DATA/orcl/datafile/system.256.816169553
  2387. 2    2     +DATA/orcl/datafile/sysaux.257.816169553
  2388. 3    2     +DATA/orcl/datafile/undotbs1.258.816169553
  2389. 4    2     +DATA/orcl/datafile/users.259.816169553
  2390. 5    2     +DATA/orcl/datafile/example.265.816169651

  2391. RMAN> report need backup;

  2392. RMAN retention policy will be applied to the command
  2393. RMAN retention policy is set to recovery window of 1 days
  2394. Report of files that must be backed up to satisfy 1 days recovery window
  2395. File Days  Name
  2396. ---- ----- -----------------------------------------------------

  2397. RMAN> backup tag '3_WHOLE_INCR0' incremental level 0 database plus archivelog delete all input;


  2398. Starting backup at 2017-08-19:00:06:59
  2399. current log archived
  2400. allocated channel: ORA_SBT_TAPE_1
  2401. channel ORA_SBT_TAPE_1: SID=130 device type=SBT_TAPE
  2402. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  2403. allocated channel: ORA_SBT_TAPE_2
  2404. channel ORA_SBT_TAPE_2: SID=15 device type=SBT_TAPE
  2405. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  2406. skipping archived log file +FRA/orcl/archivelog/2017_08_17/thread_1_seq_38.261.952300719; already backed up 1 time(s)
  2407. skipping archived log file +FRA/orcl/archivelog/2017_08_17/thread_1_seq_39.263.952300761; already backed up 1 time(s)
  2408. skipping archived log file +FRA/orcl/archivelog/2017_08_17/thread_1_seq_40.270.952300789; already backed up 1 time(s)
  2409. skipping archived log file +FRA/orcl/archivelog/2017_08_18/thread_1_seq_41.269.952300809; already backed up 1 time(s)
  2410. skipping archived log file +FRA/orcl/archivelog/2017_08_18/thread_1_seq_42.268.952300813; already backed up 1 time(s)
  2411. skipping archived log file +FRA/orcl/archivelog/2017_08_18/thread_1_seq_43.272.952300819; already backed up 1 time(s)
  2412. skipping archived log file +FRA/orcl/archivelog/2017_08_18/thread_1_seq_44.273.952300825; already backed up 1 time(s)
  2413. skipping archived log file +FRA/orcl/archivelog/2017_08_18/thread_1_seq_45.274.952377661; already backed up 1 time(s)
  2414. skipping archived log file +FRA/orcl/archivelog/2017_08_18/thread_1_seq_46.275.952387169; already backed up 1 time(s)
  2415. skipping archived log file +FRA/orcl/archivelog/2017_08_19/thread_1_seq_47.278.952387223; already backed up 1 time(s)
  2416. channel ORA_SBT_TAPE_1: starting archived log backup set
  2417. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  2418. input archived log thread=1 sequence=48 RECID=40 STAMP=952387619
  2419. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:00:07:11
  2420. channel ORA_SBT_TAPE_2: deleting archived log(s)
  2421. archived log file name=+FRA/orcl/archivelog/2017_08_17/thread_1_seq_38.261.952300719 RECID=30 STAMP=952300719
  2422. archived log file name=+FRA/orcl/archivelog/2017_08_17/thread_1_seq_39.263.952300761 RECID=31 STAMP=952300761
  2423. archived log file name=+FRA/orcl/archivelog/2017_08_17/thread_1_seq_40.270.952300789 RECID=32 STAMP=952300790
  2424. archived log file name=+FRA/orcl/archivelog/2017_08_18/thread_1_seq_41.269.952300809 RECID=33 STAMP=952300809
  2425. archived log file name=+FRA/orcl/archivelog/2017_08_18/thread_1_seq_42.268.952300813 RECID=34 STAMP=952300813
  2426. archived log file name=+FRA/orcl/archivelog/2017_08_18/thread_1_seq_43.272.952300819 RECID=35 STAMP=952300818
  2427. archived log file name=+FRA/orcl/archivelog/2017_08_18/thread_1_seq_44.273.952300825 RECID=36 STAMP=952300824
  2428. archived log file name=+FRA/orcl/archivelog/2017_08_18/thread_1_seq_45.274.952377661 RECID=37 STAMP=952377661
  2429. archived log file name=+FRA/orcl/archivelog/2017_08_18/thread_1_seq_46.275.952387169 RECID=38 STAMP=952387170
  2430. archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_47.278.952387223 RECID=39 STAMP=952387222
  2431. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:00:07:27
  2432. piece handle=2osc8i1f_1_1 tag=3_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  2433. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:16
  2434. channel ORA_SBT_TAPE_1: deleting archived log(s)
  2435. archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_48.279.952387619 RECID=40 STAMP=952387619
  2436. Finished backup at 2017-08-19:00:07:27

  2437. Starting backup at 2017-08-19:00:07:27
  2438. using channel ORA_SBT_TAPE_1
  2439. using channel ORA_SBT_TAPE_2
  2440. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  2441. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  2442. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  2443. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  2444. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  2445. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:00:07:27
  2446. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  2447. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  2448. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  2449. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  2450. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-08-19:00:07:27
  2451. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:00:07:52
  2452. piece handle=2psc8i1v_1_1 tag=3_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  2453. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  2454. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-08-19:00:07:52
  2455. piece handle=2qsc8i1v_1_1 tag=3_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  2456. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  2457. Finished backup at 2017-08-19:00:07:52

  2458. Starting backup at 2017-08-19:00:07:53
  2459. current log archived
  2460. using channel ORA_SBT_TAPE_1
  2461. using channel ORA_SBT_TAPE_2
  2462. channel ORA_SBT_TAPE_1: starting archived log backup set
  2463. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  2464. input archived log thread=1 sequence=49 RECID=41 STAMP=952387673
  2465. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:00:07:53
  2466. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:00:08:18
  2467. piece handle=2rsc8i2p_1_1 tag=3_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  2468. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  2469. channel ORA_SBT_TAPE_1: deleting archived log(s)
  2470. archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_49.279.952387673 RECID=41 STAMP=952387673
  2471. Finished backup at 2017-08-19:00:08:18

  2472. Starting Control File and SPFILE Autobackup at 2017-08-19:00:08:18
  2473. piece handle=c-1343950367-20170819-02 comment=API Version 2.0,MMS Version 10.4.0.4
  2474. Finished Control File and SPFILE Autobackup at 2017-08-19:00:08:44

  2475. RMAN> list backup;


  2476. List of Backup Sets
  2477. ===================


  2478. BS Key  Size       Device Type Elapsed Time Completion Time   
  2479. ------- ---------- ----------- ------------ -------------------
  2480. 57      13.75M     SBT_TAPE    00:00:15     2017-08-16:21:16:23
  2481.         BP Key: 61   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  2482.         Handle: 1vsc2v8o_1_1   Media: station90-000005

  2483.   List of Archived Logs in backup set 57
  2484.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2485.   ---- ------- ---------- ------------------- ---------- ---------
  2486.   1    33      1126178    2017-08-16:21:06:13 1136362    2017-08-16:21:15:56

  2487. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2488. ------- ---- -- ---------- ----------- ------------ -------------------
  2489. 58      Incr 0  658.00M    SBT_TAPE    00:00:18     2017-08-16:21:16:52
  2490.         BP Key: 62   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  2491.         Handle: 20sc2v9i_1_1   Media: station90-000005
  2492.   List of Datafiles in backup set 58
  2493.   File LV Type Ckp SCN    Ckp Time            Name
  2494.   ---- -- ---- ---------- ------------------- ----
  2495.   1    0  Incr 1136650    2017-08-16:21:16:34 +DATA/orcl/datafile/system.256.816169553
  2496.   5    0  Incr 1136650    2017-08-16:21:16:34 +DATA/orcl/datafile/example.265.816169651

  2497. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2498. ------- ---- -- ---------- ----------- ------------ -------------------
  2499. 59      Incr 0  474.25M    SBT_TAPE    00:00:20     2017-08-16:21:16:54
  2500.         BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  2501.         Handle: 21sc2v9i_1_1   Media: station90-000006
  2502.   List of Datafiles in backup set 59
  2503.   File LV Type Ckp SCN    Ckp Time            Name
  2504.   ---- -- ---- ---------- ------------------- ----
  2505.   2    0  Incr 1136653    2017-08-16:21:16:35 +DATA/orcl/datafile/sysaux.257.816169553
  2506.   3    0  Incr 1136653    2017-08-16:21:16:35 +DATA/orcl/datafile/undotbs1.258.816169553
  2507.   4    0  Incr 1136653    2017-08-16:21:16:35 +DATA/orcl/datafile/users.259.816169553

  2508. BS Key  Size       Device Type Elapsed Time Completion Time   
  2509. ------- ---------- ----------- ------------ -------------------
  2510. 60      768.00K    SBT_TAPE    00:00:16     2017-08-16:21:17:16
  2511.         BP Key: 64   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  2512.         Handle: 22sc2vac_1_1   Media: station90-000005

  2513.   List of Archived Logs in backup set 60
  2514.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2515.   ---- ------- ---------- ------------------- ---------- ---------
  2516.   1    34      1136362    2017-08-16:21:15:56 1136762    2017-08-16:21:17:00

  2517. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2518. ------- ---- -- ---------- ----------- ------------ -------------------
  2519. 61      Full    9.50M      SBT_TAPE    00:00:15     2017-08-16:21:17:41
  2520.         BP Key: 65   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T211726
  2521.         Handle: c-1343950367-20170816-06   Media: station90-000005
  2522.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2523.   SPFILE db_unique_name: ORCL
  2524.   Control File Included: Ckp SCN: 1136943      Ckp time: 2017-08-16:21:17:26

  2525. BS Key  Size       Device Type Elapsed Time Completion Time   
  2526. ------- ---------- ----------- ------------ -------------------
  2527. 62      22.25M     SBT_TAPE    00:00:16     2017-08-17:21:22:07
  2528.         BP Key: 66   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  2529.         Handle: 24sc5jvf_1_1   Media: station90-000005

  2530.   List of Archived Logs in backup set 62
  2531.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2532.   ---- ------- ---------- ------------------- ---------- ---------
  2533.   1    35      1136762    2017-08-16:21:17:00 1140768    2017-08-17:21:21:19

  2534. BS Key  Size       Device Type Elapsed Time Completion Time   
  2535. ------- ---------- ----------- ------------ -------------------
  2536. 63      1.50M      SBT_TAPE    00:00:24     2017-08-17:21:22:16
  2537.         BP Key: 67   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  2538.         Handle: 25sc5jvg_1_1   Media: station90-000006

  2539.   List of Archived Logs in backup set 63
  2540.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2541.   ---- ------- ---------- ------------------- ---------- ---------
  2542.   1    36      1140768    2017-08-17:21:21:19 1141334    2017-08-17:21:21:39

  2543. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2544. ------- ---- -- ---------- ----------- ------------ -------------------
  2545. 64      Incr 0  658.00M    SBT_TAPE    00:00:19     2017-08-17:21:22:36
  2546.         BP Key: 68   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  2547.         Handle: 26sc5k09_1_1   Media: station90-000005
  2548.   List of Datafiles in backup set 64
  2549.   File LV Type Ckp SCN    Ckp Time            Name
  2550.   ---- -- ---- ---------- ------------------- ----
  2551.   1    0  Incr 1141789    2017-08-17:21:22:18 +DATA/orcl/datafile/system.256.816169553
  2552.   5    0  Incr 1141789    2017-08-17:21:22:18 +DATA/orcl/datafile/example.265.816169651

  2553. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2554. ------- ---- -- ---------- ----------- ------------ -------------------
  2555. 65      Incr 0  461.00M    SBT_TAPE    00:00:21     2017-08-17:21:22:38
  2556.         BP Key: 69   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  2557.         Handle: 27sc5k09_1_1   Media: station90-000006
  2558.   List of Datafiles in backup set 65
  2559.   File LV Type Ckp SCN    Ckp Time            Name
  2560.   ---- -- ---- ---------- ------------------- ----
  2561.   2    0  Incr 1141792    2017-08-17:21:22:18 +DATA/orcl/datafile/sysaux.257.816169553
  2562.   3    0  Incr 1141792    2017-08-17:21:22:18 +DATA/orcl/datafile/undotbs1.258.816169553
  2563.   4    0  Incr 1141792    2017-08-17:21:22:18 +DATA/orcl/datafile/users.259.816169553

  2564. BS Key  Size       Device Type Elapsed Time Completion Time   
  2565. ------- ---------- ----------- ------------ -------------------
  2566. 66      2.25M      SBT_TAPE    00:00:16     2017-08-17:21:22:59
  2567.         BP Key: 70   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  2568.         Handle: 28sc5k13_1_1   Media: station90-000005

  2569.   List of Archived Logs in backup set 66
  2570.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2571.   ---- ------- ---------- ------------------- ---------- ---------
  2572.   1    37      1141334    2017-08-17:21:21:39 1141844    2017-08-17:21:22:43

  2573. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2574. ------- ---- -- ---------- ----------- ------------ -------------------
  2575. 67      Full    9.50M      SBT_TAPE    00:00:16     2017-08-17:21:23:25
  2576.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T212309
  2577.         Handle: c-1343950367-20170817-00   Media: station90-000005
  2578.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2579.   SPFILE db_unique_name: ORCL
  2580.   Control File Included: Ckp SCN: 1141877      Ckp time: 2017-08-17:21:23:09

  2581. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2582. ------- ---- -- ---------- ----------- ------------ -------------------
  2583. 68      Full    9.36M      DISK        00:00:01     2017-08-17:23:59:37
  2584.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T235936
  2585.         Piece Name: +FRA/orcl/autobackup/2017_08_17/s_952300776.271.952300777
  2586.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2587.   SPFILE db_unique_name: ORCL
  2588.   Control File Included: Ckp SCN: 1160572      Ckp time: 2017-08-17:23:59:36

  2589. BS Key  Size       Device Type Elapsed Time Completion Time   
  2590. ------- ---------- ----------- ------------ -------------------
  2591. 69      11.50M     SBT_TAPE    00:00:16     2017-08-18:00:00:06
  2592.         BP Key: 73   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T235950
  2593.         Handle: 2hsc5t7m_1_1   Media: station90-000005

  2594.   List of Archived Logs in backup set 69
  2595.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2596.   ---- ------- ---------- ------------------- ---------- ---------
  2597.   1    40      1157900    2017-08-17:23:59:20 1160826    2017-08-17:23:59:49

  2598. BS Key  Size       Device Type Elapsed Time Completion Time   
  2599. ------- ---------- ----------- ------------ -------------------
  2600. 70      37.50M     SBT_TAPE    00:00:24     2017-08-18:00:00:14
  2601.         BP Key: 74   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T235950
  2602.         Handle: 2gsc5t7m_1_1   Media: station90-000006

  2603.   List of Archived Logs in backup set 70
  2604.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2605.   ---- ------- ---------- ------------------- ---------- ---------
  2606.   1    38      1141844    2017-08-17:21:22:43 1154066    2017-08-17:23:58:39
  2607.   1    39      1154066    2017-08-17:23:58:39 1157900    2017-08-17:23:59:20

  2608. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2609. ------- ---- -- ---------- ----------- ------------ -------------------
  2610. 71      Full    9.50M      SBT_TAPE    00:00:16     2017-08-18:00:00:34
  2611.         BP Key: 75   Status: AVAILABLE  Compressed: NO  Tag: TAG20170818T000018
  2612.         Handle: c-1343950367-20170818-00   Media: station90-000006
  2613.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2614.   SPFILE db_unique_name: ORCL
  2615.   Control File Included: Ckp SCN: 1204844      Ckp time: 2017-08-18:00:00:18

  2616. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2617. ------- ---- -- ---------- ----------- ------------ -------------------
  2618. 72      Incr 1  152.67M    DISK        00:00:05     2017-08-19:00:00:07
  2619.         BP Key: 76   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  2620.         Piece Name: +FRA/orcl/backupset/2017_08_19/nnndn1_ora_oem_level_0_0.276.952387205
  2621.   List of Datafiles in backup set 72
  2622.   File LV Type Ckp SCN    Ckp Time            Name
  2623.   ---- -- ---- ---------- ------------------- ----
  2624.   1    1  Incr 1223427    2017-08-19:00:00:02 +DATA/orcl/datafile/system.256.816169553
  2625.   2    1  Incr 1223427    2017-08-19:00:00:02 +DATA/orcl/datafile/sysaux.257.816169553
  2626.   3    1  Incr 1223427    2017-08-19:00:00:02 +DATA/orcl/datafile/undotbs1.258.816169553
  2627.   4    1  Incr 1223427    2017-08-19:00:00:02 +DATA/orcl/datafile/users.259.816169553
  2628.   5    1  Incr 1223427    2017-08-19:00:00:02 +DATA/orcl/datafile/example.265.816169651

  2629. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2630. ------- ---- -- ---------- ----------- ------------ -------------------
  2631. 73      Full    9.42M      DISK        00:00:01     2017-08-19:00:00:10
  2632.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: TAG20170819T000009
  2633.         Piece Name: +FRA/orcl/autobackup/2017_08_19/s_952387209.277.952387211
  2634.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2635.   SPFILE db_unique_name: ORCL
  2636.   Control File Included: Ckp SCN: 1223959      Ckp time: 2017-08-19:00:00:09

  2637. BS Key  Size       Device Type Elapsed Time Completion Time   
  2638. ------- ---------- ----------- ------------ -------------------
  2639. 74      106.25M    SBT_TAPE    00:00:16     2017-08-19:00:00:39
  2640.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: TAG20170819T000023
  2641.         Handle: 2lsc8hkn_1_1   Media: station90-000005

  2642.   List of Archived Logs in backup set 74
  2643.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2644.   ---- ------- ---------- ------------------- ---------- ---------
  2645.   1    41      1160826    2017-08-17:23:59:49 1164373    2017-08-18:00:00:08
  2646.   1    42      1164373    2017-08-18:00:00:08 1181436    2017-08-18:00:00:12
  2647.   1    43      1181436    2017-08-18:00:00:12 1197181    2017-08-18:00:00:17

  2648. BS Key  Size       Device Type Elapsed Time Completion Time   
  2649. ------- ---------- ----------- ------------ -------------------
  2650. 75      74.75M     SBT_TAPE    00:00:24     2017-08-19:00:00:47
  2651.         BP Key: 79   Status: AVAILABLE  Compressed: NO  Tag: TAG20170819T000023
  2652.         Handle: 2msc8hkn_1_1   Media: station90-000006

  2653.   List of Archived Logs in backup set 75
  2654.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2655.   ---- ------- ---------- ------------------- ---------- ---------
  2656.   1    44      1197181    2017-08-18:00:00:17 1211256    2017-08-18:00:00:24
  2657.   1    45      1211256    2017-08-18:00:00:24 1214393    2017-08-18:21:21:01
  2658.   1    46      1214393    2017-08-18:21:21:01 1221380    2017-08-18:23:59:29
  2659.   1    47      1221380    2017-08-18:23:59:29 1224095    2017-08-19:00:00:22

  2660. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2661. ------- ---- -- ---------- ----------- ------------ -------------------
  2662. 76      Full    9.50M      SBT_TAPE    00:00:16     2017-08-19:00:01:04
  2663.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: TAG20170819T000048
  2664.         Handle: c-1343950367-20170819-01   Media: station90-000005
  2665.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2666.   SPFILE db_unique_name: ORCL
  2667.   Control File Included: Ckp SCN: 1224150      Ckp time: 2017-08-19:00:00:48

  2668. BS Key  Size       Device Type Elapsed Time Completion Time   
  2669. ------- ---------- ----------- ------------ -------------------
  2670. 77      8.25M      SBT_TAPE    00:00:15     2017-08-19:00:07:26
  2671.         BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: 3_WHOLE_INCR0
  2672.         Handle: 2osc8i1f_1_1   Media: station90-000005

  2673.   List of Archived Logs in backup set 77
  2674.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2675.   ---- ------- ---------- ------------------- ---------- ---------
  2676.   1    48      1224095    2017-08-19:00:00:22 1225478    2017-08-19:00:06:59

  2677. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2678. ------- ---- -- ---------- ----------- ------------ -------------------
  2679. 78      Incr 0  667.50M    SBT_TAPE    00:00:22     2017-08-19:00:07:49
  2680.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: 3_WHOLE_INCR0
  2681.         Handle: 2psc8i1v_1_1   Media: station90-000005
  2682.   List of Datafiles in backup set 78
  2683.   File LV Type Ckp SCN    Ckp Time            Name
  2684.   ---- -- ---- ---------- ------------------- ----
  2685.   1    0  Incr 1225511    2017-08-19:00:07:27 +DATA/orcl/datafile/system.256.816169553
  2686.   4    0  Incr 1225372    2017-08-19:00:05:17 +DATA/orcl/datafile/users.259.816169553
  2687.   5    0  Incr 1225511    2017-08-19:00:07:27 +DATA/orcl/datafile/example.265.816169651

  2688. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2689. ------- ---- -- ---------- ----------- ------------ -------------------
  2690. 79      Incr 0  476.50M    SBT_TAPE    00:00:22     2017-08-19:00:07:49
  2691.         BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: 3_WHOLE_INCR0
  2692.         Handle: 2qsc8i1v_1_1   Media: station90-000006
  2693.   List of Datafiles in backup set 79
  2694.   File LV Type Ckp SCN    Ckp Time            Name
  2695.   ---- -- ---- ---------- ------------------- ----
  2696.   2    0  Incr 1225514    2017-08-19:00:07:28 +DATA/orcl/datafile/sysaux.257.816169553
  2697.   3    0  Incr 1225514    2017-08-19:00:07:28 +DATA/orcl/datafile/undotbs1.258.816169553

  2698. BS Key  Size       Device Type Elapsed Time Completion Time   
  2699. ------- ---------- ----------- ------------ -------------------
  2700. 80      256.00K    SBT_TAPE    00:00:16     2017-08-19:00:08:09
  2701.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: 3_WHOLE_INCR0
  2702.         Handle: 2rsc8i2p_1_1   Media: station90-000005

  2703.   List of Archived Logs in backup set 80
  2704.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2705.   ---- ------- ---------- ------------------- ---------- ---------
  2706.   1    49      1225478    2017-08-19:00:06:59 1225533    2017-08-19:00:07:53

  2707. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2708. ------- ---- -- ---------- ----------- ------------ -------------------
  2709. 81      Full    9.50M      SBT_TAPE    00:00:15     2017-08-19:00:08:34
  2710.         BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20170819T000819
  2711.         Handle: c-1343950367-20170819-02   Media: station90-000005
  2712.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2713.   SPFILE db_unique_name: ORCL
  2714.   Control File Included: Ckp SCN: 1225565      Ckp time: 2017-08-19:00:08:19

  2715. RMAN> backup tag '4_WHOLE_INCR0' incremental level 0 database plus archivelog delete all input;


  2716. Starting backup at 2017-08-19:00:10:49
  2717. current log archived
  2718. using channel ORA_SBT_TAPE_1
  2719. using channel ORA_SBT_TAPE_2
  2720. channel ORA_SBT_TAPE_1: starting archived log backup set
  2721. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  2722. input archived log thread=1 sequence=50 RECID=42 STAMP=952387850
  2723. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:00:10:50
  2724. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:00:11:15
  2725. piece handle=2tsc8i8a_1_1 tag=4_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  2726. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  2727. channel ORA_SBT_TAPE_1: deleting archived log(s)
  2728. archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_50.279.952387851 RECID=42 STAMP=952387850
  2729. Finished backup at 2017-08-19:00:11:15

  2730. Starting backup at 2017-08-19:00:11:15
  2731. using channel ORA_SBT_TAPE_1
  2732. using channel ORA_SBT_TAPE_2
  2733. skipping datafile 4; already backed up 1 time(s)
  2734. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  2735. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  2736. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  2737. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  2738. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:00:11:16
  2739. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  2740. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  2741. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  2742. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  2743. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-08-19:00:11:16
  2744. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:00:11:41
  2745. piece handle=2usc8i94_1_1 tag=4_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  2746. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  2747. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-08-19:00:11:51
  2748. piece handle=2vsc8i94_1_1 tag=4_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  2749. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:35
  2750. Finished backup at 2017-08-19:00:11:51

  2751. Starting backup at 2017-08-19:00:11:51
  2752. current log archived
  2753. using channel ORA_SBT_TAPE_1
  2754. using channel ORA_SBT_TAPE_2
  2755. channel ORA_SBT_TAPE_1: starting archived log backup set
  2756. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  2757. input archived log thread=1 sequence=51 RECID=43 STAMP=952387912
  2758. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:00:11:52
  2759. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:00:12:17
  2760. piece handle=30sc8ia8_1_1 tag=4_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  2761. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  2762. channel ORA_SBT_TAPE_1: deleting archived log(s)
  2763. archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_51.279.952387913 RECID=43 STAMP=952387912
  2764. Finished backup at 2017-08-19:00:12:17

  2765. Starting Control File and SPFILE Autobackup at 2017-08-19:00:12:17
  2766. piece handle=c-1343950367-20170819-03 comment=API Version 2.0,MMS Version 10.4.0.4
  2767. Finished Control File and SPFILE Autobackup at 2017-08-19:00:12:42

  2768. RMAN> list backup;


  2769. List of Backup Sets
  2770. ===================


  2771. BS Key  Size       Device Type Elapsed Time Completion Time   
  2772. ------- ---------- ----------- ------------ -------------------
  2773. 57      13.75M     SBT_TAPE    00:00:15     2017-08-16:21:16:23
  2774.         BP Key: 61   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  2775.         Handle: 1vsc2v8o_1_1   Media: station90-000005

  2776.   List of Archived Logs in backup set 57
  2777.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2778.   ---- ------- ---------- ------------------- ---------- ---------
  2779.   1    33      1126178    2017-08-16:21:06:13 1136362    2017-08-16:21:15:56

  2780. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2781. ------- ---- -- ---------- ----------- ------------ -------------------
  2782. 58      Incr 0  658.00M    SBT_TAPE    00:00:18     2017-08-16:21:16:52
  2783.         BP Key: 62   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  2784.         Handle: 20sc2v9i_1_1   Media: station90-000005
  2785.   List of Datafiles in backup set 58
  2786.   File LV Type Ckp SCN    Ckp Time            Name
  2787.   ---- -- ---- ---------- ------------------- ----
  2788.   1    0  Incr 1136650    2017-08-16:21:16:34 +DATA/orcl/datafile/system.256.816169553
  2789.   5    0  Incr 1136650    2017-08-16:21:16:34 +DATA/orcl/datafile/example.265.816169651

  2790. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2791. ------- ---- -- ---------- ----------- ------------ -------------------
  2792. 59      Incr 0  474.25M    SBT_TAPE    00:00:20     2017-08-16:21:16:54
  2793.         BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  2794.         Handle: 21sc2v9i_1_1   Media: station90-000006
  2795.   List of Datafiles in backup set 59
  2796.   File LV Type Ckp SCN    Ckp Time            Name
  2797.   ---- -- ---- ---------- ------------------- ----
  2798.   2    0  Incr 1136653    2017-08-16:21:16:35 +DATA/orcl/datafile/sysaux.257.816169553
  2799.   3    0  Incr 1136653    2017-08-16:21:16:35 +DATA/orcl/datafile/undotbs1.258.816169553
  2800.   4    0  Incr 1136653    2017-08-16:21:16:35 +DATA/orcl/datafile/users.259.816169553

  2801. BS Key  Size       Device Type Elapsed Time Completion Time   
  2802. ------- ---------- ----------- ------------ -------------------
  2803. 60      768.00K    SBT_TAPE    00:00:16     2017-08-16:21:17:16
  2804.         BP Key: 64   Status: AVAILABLE  Compressed: NO  Tag: 1_WHOLE_INCR0
  2805.         Handle: 22sc2vac_1_1   Media: station90-000005

  2806.   List of Archived Logs in backup set 60
  2807.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2808.   ---- ------- ---------- ------------------- ---------- ---------
  2809.   1    34      1136362    2017-08-16:21:15:56 1136762    2017-08-16:21:17:00

  2810. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2811. ------- ---- -- ---------- ----------- ------------ -------------------
  2812. 61      Full    9.50M      SBT_TAPE    00:00:15     2017-08-16:21:17:41
  2813.         BP Key: 65   Status: AVAILABLE  Compressed: NO  Tag: TAG20170816T211726
  2814.         Handle: c-1343950367-20170816-06   Media: station90-000005
  2815.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2816.   SPFILE db_unique_name: ORCL
  2817.   Control File Included: Ckp SCN: 1136943      Ckp time: 2017-08-16:21:17:26

  2818. BS Key  Size       Device Type Elapsed Time Completion Time   
  2819. ------- ---------- ----------- ------------ -------------------
  2820. 62      22.25M     SBT_TAPE    00:00:16     2017-08-17:21:22:07
  2821.         BP Key: 66   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  2822.         Handle: 24sc5jvf_1_1   Media: station90-000005

  2823.   List of Archived Logs in backup set 62
  2824.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2825.   ---- ------- ---------- ------------------- ---------- ---------
  2826.   1    35      1136762    2017-08-16:21:17:00 1140768    2017-08-17:21:21:19

  2827. BS Key  Size       Device Type Elapsed Time Completion Time   
  2828. ------- ---------- ----------- ------------ -------------------
  2829. 63      1.50M      SBT_TAPE    00:00:24     2017-08-17:21:22:16
  2830.         BP Key: 67   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  2831.         Handle: 25sc5jvg_1_1   Media: station90-000006

  2832.   List of Archived Logs in backup set 63
  2833.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2834.   ---- ------- ---------- ------------------- ---------- ---------
  2835.   1    36      1140768    2017-08-17:21:21:19 1141334    2017-08-17:21:21:39

  2836. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2837. ------- ---- -- ---------- ----------- ------------ -------------------
  2838. 64      Incr 0  658.00M    SBT_TAPE    00:00:19     2017-08-17:21:22:36
  2839.         BP Key: 68   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  2840.         Handle: 26sc5k09_1_1   Media: station90-000005
  2841.   List of Datafiles in backup set 64
  2842.   File LV Type Ckp SCN    Ckp Time            Name
  2843.   ---- -- ---- ---------- ------------------- ----
  2844.   1    0  Incr 1141789    2017-08-17:21:22:18 +DATA/orcl/datafile/system.256.816169553
  2845.   5    0  Incr 1141789    2017-08-17:21:22:18 +DATA/orcl/datafile/example.265.816169651

  2846. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2847. ------- ---- -- ---------- ----------- ------------ -------------------
  2848. 65      Incr 0  461.00M    SBT_TAPE    00:00:21     2017-08-17:21:22:38
  2849.         BP Key: 69   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  2850.         Handle: 27sc5k09_1_1   Media: station90-000006
  2851.   List of Datafiles in backup set 65
  2852.   File LV Type Ckp SCN    Ckp Time            Name
  2853.   ---- -- ---- ---------- ------------------- ----
  2854.   2    0  Incr 1141792    2017-08-17:21:22:18 +DATA/orcl/datafile/sysaux.257.816169553
  2855.   3    0  Incr 1141792    2017-08-17:21:22:18 +DATA/orcl/datafile/undotbs1.258.816169553
  2856.   4    0  Incr 1141792    2017-08-17:21:22:18 +DATA/orcl/datafile/users.259.816169553

  2857. BS Key  Size       Device Type Elapsed Time Completion Time   
  2858. ------- ---------- ----------- ------------ -------------------
  2859. 66      2.25M      SBT_TAPE    00:00:16     2017-08-17:21:22:59
  2860.         BP Key: 70   Status: AVAILABLE  Compressed: NO  Tag: 2_WHOLE_INCR0
  2861.         Handle: 28sc5k13_1_1   Media: station90-000005

  2862.   List of Archived Logs in backup set 66
  2863.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2864.   ---- ------- ---------- ------------------- ---------- ---------
  2865.   1    37      1141334    2017-08-17:21:21:39 1141844    2017-08-17:21:22:43

  2866. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2867. ------- ---- -- ---------- ----------- ------------ -------------------
  2868. 67      Full    9.50M      SBT_TAPE    00:00:16     2017-08-17:21:23:25
  2869.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T212309
  2870.         Handle: c-1343950367-20170817-00   Media: station90-000005
  2871.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2872.   SPFILE db_unique_name: ORCL
  2873.   Control File Included: Ckp SCN: 1141877      Ckp time: 2017-08-17:21:23:09

  2874. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2875. ------- ---- -- ---------- ----------- ------------ -------------------
  2876. 68      Full    9.36M      DISK        00:00:01     2017-08-17:23:59:37
  2877.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T235936
  2878.         Piece Name: +FRA/orcl/autobackup/2017_08_17/s_952300776.271.952300777
  2879.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2880.   SPFILE db_unique_name: ORCL
  2881.   Control File Included: Ckp SCN: 1160572      Ckp time: 2017-08-17:23:59:36

  2882. BS Key  Size       Device Type Elapsed Time Completion Time   
  2883. ------- ---------- ----------- ------------ -------------------
  2884. 69      11.50M     SBT_TAPE    00:00:16     2017-08-18:00:00:06
  2885.         BP Key: 73   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T235950
  2886.         Handle: 2hsc5t7m_1_1   Media: station90-000005

  2887.   List of Archived Logs in backup set 69
  2888.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2889.   ---- ------- ---------- ------------------- ---------- ---------
  2890.   1    40      1157900    2017-08-17:23:59:20 1160826    2017-08-17:23:59:49

  2891. BS Key  Size       Device Type Elapsed Time Completion Time   
  2892. ------- ---------- ----------- ------------ -------------------
  2893. 70      37.50M     SBT_TAPE    00:00:24     2017-08-18:00:00:14
  2894.         BP Key: 74   Status: AVAILABLE  Compressed: NO  Tag: TAG20170817T235950
  2895.         Handle: 2gsc5t7m_1_1   Media: station90-000006

  2896.   List of Archived Logs in backup set 70
  2897.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2898.   ---- ------- ---------- ------------------- ---------- ---------
  2899.   1    38      1141844    2017-08-17:21:22:43 1154066    2017-08-17:23:58:39
  2900.   1    39      1154066    2017-08-17:23:58:39 1157900    2017-08-17:23:59:20

  2901. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2902. ------- ---- -- ---------- ----------- ------------ -------------------
  2903. 71      Full    9.50M      SBT_TAPE    00:00:16     2017-08-18:00:00:34
  2904.         BP Key: 75   Status: AVAILABLE  Compressed: NO  Tag: TAG20170818T000018
  2905.         Handle: c-1343950367-20170818-00   Media: station90-000006
  2906.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2907.   SPFILE db_unique_name: ORCL
  2908.   Control File Included: Ckp SCN: 1204844      Ckp time: 2017-08-18:00:00:18

  2909. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2910. ------- ---- -- ---------- ----------- ------------ -------------------
  2911. 72      Incr 1  152.67M    DISK        00:00:05     2017-08-19:00:00:07
  2912.         BP Key: 76   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  2913.         Piece Name: +FRA/orcl/backupset/2017_08_19/nnndn1_ora_oem_level_0_0.276.952387205
  2914.   List of Datafiles in backup set 72
  2915.   File LV Type Ckp SCN    Ckp Time            Name
  2916.   ---- -- ---- ---------- ------------------- ----
  2917.   1    1  Incr 1223427    2017-08-19:00:00:02 +DATA/orcl/datafile/system.256.816169553
  2918.   2    1  Incr 1223427    2017-08-19:00:00:02 +DATA/orcl/datafile/sysaux.257.816169553
  2919.   3    1  Incr 1223427    2017-08-19:00:00:02 +DATA/orcl/datafile/undotbs1.258.816169553
  2920.   4    1  Incr 1223427    2017-08-19:00:00:02 +DATA/orcl/datafile/users.259.816169553
  2921.   5    1  Incr 1223427    2017-08-19:00:00:02 +DATA/orcl/datafile/example.265.816169651

  2922. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2923. ------- ---- -- ---------- ----------- ------------ -------------------
  2924. 73      Full    9.42M      DISK        00:00:01     2017-08-19:00:00:10
  2925.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: TAG20170819T000009
  2926.         Piece Name: +FRA/orcl/autobackup/2017_08_19/s_952387209.277.952387211
  2927.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2928.   SPFILE db_unique_name: ORCL
  2929.   Control File Included: Ckp SCN: 1223959      Ckp time: 2017-08-19:00:00:09

  2930. BS Key  Size       Device Type Elapsed Time Completion Time   
  2931. ------- ---------- ----------- ------------ -------------------
  2932. 74      106.25M    SBT_TAPE    00:00:16     2017-08-19:00:00:39
  2933.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: TAG20170819T000023
  2934.         Handle: 2lsc8hkn_1_1   Media: station90-000005

  2935.   List of Archived Logs in backup set 74
  2936.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2937.   ---- ------- ---------- ------------------- ---------- ---------
  2938.   1    41      1160826    2017-08-17:23:59:49 1164373    2017-08-18:00:00:08
  2939.   1    42      1164373    2017-08-18:00:00:08 1181436    2017-08-18:00:00:12
  2940.   1    43      1181436    2017-08-18:00:00:12 1197181    2017-08-18:00:00:17

  2941. BS Key  Size       Device Type Elapsed Time Completion Time   
  2942. ------- ---------- ----------- ------------ -------------------
  2943. 75      74.75M     SBT_TAPE    00:00:24     2017-08-19:00:00:47
  2944.         BP Key: 79   Status: AVAILABLE  Compressed: NO  Tag: TAG20170819T000023
  2945.         Handle: 2msc8hkn_1_1   Media: station90-000006

  2946.   List of Archived Logs in backup set 75
  2947.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2948.   ---- ------- ---------- ------------------- ---------- ---------
  2949.   1    44      1197181    2017-08-18:00:00:17 1211256    2017-08-18:00:00:24
  2950.   1    45      1211256    2017-08-18:00:00:24 1214393    2017-08-18:21:21:01
  2951.   1    46      1214393    2017-08-18:21:21:01 1221380    2017-08-18:23:59:29
  2952.   1    47      1221380    2017-08-18:23:59:29 1224095    2017-08-19:00:00:22

  2953. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2954. ------- ---- -- ---------- ----------- ------------ -------------------
  2955. 76      Full    9.50M      SBT_TAPE    00:00:16     2017-08-19:00:01:04
  2956.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: TAG20170819T000048
  2957.         Handle: c-1343950367-20170819-01   Media: station90-000005
  2958.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  2959.   SPFILE db_unique_name: ORCL
  2960.   Control File Included: Ckp SCN: 1224150      Ckp time: 2017-08-19:00:00:48

  2961. BS Key  Size       Device Type Elapsed Time Completion Time   
  2962. ------- ---------- ----------- ------------ -------------------
  2963. 77      8.25M      SBT_TAPE    00:00:15     2017-08-19:00:07:26
  2964.         BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: 3_WHOLE_INCR0
  2965.         Handle: 2osc8i1f_1_1   Media: station90-000005

  2966.   List of Archived Logs in backup set 77
  2967.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2968.   ---- ------- ---------- ------------------- ---------- ---------
  2969.   1    48      1224095    2017-08-19:00:00:22 1225478    2017-08-19:00:06:59

  2970. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2971. ------- ---- -- ---------- ----------- ------------ -------------------
  2972. 78      Incr 0  667.50M    SBT_TAPE    00:00:22     2017-08-19:00:07:49
  2973.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: 3_WHOLE_INCR0
  2974.         Handle: 2psc8i1v_1_1   Media: station90-000005
  2975.   List of Datafiles in backup set 78
  2976.   File LV Type Ckp SCN    Ckp Time            Name
  2977.   ---- -- ---- ---------- ------------------- ----
  2978.   1    0  Incr 1225511    2017-08-19:00:07:27 +DATA/orcl/datafile/system.256.816169553
  2979.   4    0  Incr 1225372    2017-08-19:00:05:17 +DATA/orcl/datafile/users.259.816169553
  2980.   5    0  Incr 1225511    2017-08-19:00:07:27 +DATA/orcl/datafile/example.265.816169651

  2981. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2982. ------- ---- -- ---------- ----------- ------------ -------------------
  2983. 79      Incr 0  476.50M    SBT_TAPE    00:00:22     2017-08-19:00:07:49
  2984.         BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: 3_WHOLE_INCR0
  2985.         Handle: 2qsc8i1v_1_1   Media: station90-000006
  2986.   List of Datafiles in backup set 79
  2987.   File LV Type Ckp SCN    Ckp Time            Name
  2988.   ---- -- ---- ---------- ------------------- ----
  2989.   2    0  Incr 1225514    2017-08-19:00:07:28 +DATA/orcl/datafile/sysaux.257.816169553
  2990.   3    0  Incr 1225514    2017-08-19:00:07:28 +DATA/orcl/datafile/undotbs1.258.816169553

  2991. BS Key  Size       Device Type Elapsed Time Completion Time   
  2992. ------- ---------- ----------- ------------ -------------------
  2993. 80      256.00K    SBT_TAPE    00:00:16     2017-08-19:00:08:09
  2994.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: 3_WHOLE_INCR0
  2995.         Handle: 2rsc8i2p_1_1   Media: station90-000005

  2996.   List of Archived Logs in backup set 80
  2997.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2998.   ---- ------- ---------- ------------------- ---------- ---------
  2999.   1    49      1225478    2017-08-19:00:06:59 1225533    2017-08-19:00:07:53

  3000. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  3001. ------- ---- -- ---------- ----------- ------------ -------------------
  3002. 81      Full    9.50M      SBT_TAPE    00:00:15     2017-08-19:00:08:34
  3003.         BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20170819T000819
  3004.         Handle: c-1343950367-20170819-02   Media: station90-000005
  3005.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  3006.   SPFILE db_unique_name: ORCL
  3007.   Control File Included: Ckp SCN: 1225565      Ckp time: 2017-08-19:00:08:19

  3008. BS Key  Size       Device Type Elapsed Time Completion Time   
  3009. ------- ---------- ----------- ------------ -------------------
  3010. 82      512.00K    SBT_TAPE    00:00:17     2017-08-19:00:11:07
  3011.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: 4_WHOLE_INCR0
  3012.         Handle: 2tsc8i8a_1_1   Media: station90-000005

  3013.   List of Archived Logs in backup set 82
  3014.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  3015.   ---- ------- ---------- ------------------- ---------- ---------
  3016.   1    50      1225533    2017-08-19:00:07:53 1225793    2017-08-19:00:10:50

  3017. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  3018. ------- ---- -- ---------- ----------- ------------ -------------------
  3019. 83      Incr 0  664.25M    SBT_TAPE    00:00:18     2017-08-19:00:11:34
  3020.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: 4_WHOLE_INCR0
  3021.         Handle: 2usc8i94_1_1   Media: station90-000005
  3022.   List of Datafiles in backup set 83
  3023.   File LV Type Ckp SCN    Ckp Time            Name
  3024.   ---- -- ---- ---------- ------------------- ----
  3025.   1    0  Incr 1225822    2017-08-19:00:11:16 +DATA/orcl/datafile/system.256.816169553
  3026.   5    0  Incr 1225822    2017-08-19:00:11:16 +DATA/orcl/datafile/example.265.816169651

  3027. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  3028. ------- ---- -- ---------- ----------- ------------ -------------------
  3029. 84      Incr 0  476.50M    SBT_TAPE    00:00:27     2017-08-19:00:11:43
  3030.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: 4_WHOLE_INCR0
  3031.         Handle: 2vsc8i94_1_1   Media: station90-000006
  3032.   List of Datafiles in backup set 84
  3033.   File LV Type Ckp SCN    Ckp Time            Name
  3034.   ---- -- ---- ---------- ------------------- ----
  3035.   2    0  Incr 1225825    2017-08-19:00:11:16 +DATA/orcl/datafile/sysaux.257.816169553
  3036.   3    0  Incr 1225825    2017-08-19:00:11:16 +DATA/orcl/datafile/undotbs1.258.816169553

  3037. BS Key  Size       Device Type Elapsed Time Completion Time   
  3038. ------- ---------- ----------- ------------ -------------------
  3039. 85      256.00K    SBT_TAPE    00:00:17     2017-08-19:00:12:09
  3040.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: 4_WHOLE_INCR0
  3041.         Handle: 30sc8ia8_1_1   Media: station90-000005

  3042.   List of Archived Logs in backup set 85
  3043.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  3044.   ---- ------- ---------- ------------------- ---------- ---------
  3045.   1    51      1225793    2017-08-19:00:10:50 1225851    2017-08-19:00:11:51

  3046. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  3047. ------- ---- -- ---------- ----------- ------------ -------------------
  3048. 86      Full    9.50M      SBT_TAPE    00:00:16     2017-08-19:00:12:33
  3049.         BP Key: 90   Status: AVAILABLE  Compressed: NO  Tag: TAG20170819T001217
  3050.         Handle: c-1343950367-20170819-03   Media: station90-000005
  3051.   SPFILE Included: Modification time: 2017-08-16:16:06:56
  3052.   SPFILE db_unique_name: ORCL
  3053.   Control File Included: Ckp SCN: 1225873      Ckp time: 2017-08-19:00:12:17

  3054. RMAN> exit


  3055. Recovery Manager complete.
  3056. [oracle@station90 ~]$ rman target /

  3057. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 23:56:31 2017

  3058. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  3059. connected to target database: ORCL (DBID=1343950367)

  3060. RMAN> backup tag '5_WHOLE_INCR0' incremental level 0 database plus archivelog delete all input;


  3061. Starting backup at 2017-08-19:23:56:45
  3062. current log archived
  3063. using target database control file instead of recovery catalog
  3064. allocated channel: ORA_SBT_TAPE_1
  3065. channel ORA_SBT_TAPE_1: SID=80 device type=SBT_TAPE
  3066. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  3067. allocated channel: ORA_SBT_TAPE_2
  3068. channel ORA_SBT_TAPE_2: SID=74 device type=SBT_TAPE
  3069. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  3070. channel ORA_SBT_TAPE_1: starting archived log backup set
  3071. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  3072. input archived log thread=1 sequence=52 RECID=44 STAMP=952473384
  3073. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:23:56:59
  3074. channel ORA_SBT_TAPE_2: starting archived log backup set
  3075. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
  3076. input archived log thread=1 sequence=53 RECID=45 STAMP=952473407
  3077. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-08-19:23:56:59
  3078. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:23:57:34
  3079. piece handle=32scb5qb_1_1 tag=5_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  3080. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
  3081. channel ORA_SBT_TAPE_1: deleting archived log(s)
  3082. archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_52.279.952473385 RECID=44 STAMP=952473384
  3083. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-08-19:23:57:34
  3084. piece handle=33scb5qb_1_1 tag=5_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  3085. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:35
  3086. channel ORA_SBT_TAPE_2: deleting archived log(s)
  3087. archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_53.278.952473407 RECID=45 STAMP=952473407
  3088. Finished backup at 2017-08-19:23:57:49

  3089. Starting backup at 2017-08-19:23:57:49
  3090. using channel ORA_SBT_TAPE_1
  3091. using channel ORA_SBT_TAPE_2
  3092. skipping datafile 4; already backed up 1 time(s)
  3093. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  3094. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  3095. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  3096. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  3097. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:23:57:50
  3098. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  3099. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  3100. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  3101. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  3102. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-08-19:23:57:50
  3103. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:23:58:15
  3104. piece handle=38scb5rt_1_1 tag=5_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  3105. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  3106. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-08-19:23:58:15
  3107. piece handle=39scb5ru_1_1 tag=5_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  3108. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  3109. Finished backup at 2017-08-19:23:58:15

  3110. Starting backup at 2017-08-19:23:58:15
  3111. current log archived
  3112. using channel ORA_SBT_TAPE_1
  3113. using channel ORA_SBT_TAPE_2
  3114. skipping archived log file +FRA/orcl/archivelog/2017_08_19/thread_1_seq_54.273.952473447; already backed up 1 time(s)
  3115. channel ORA_SBT_TAPE_1: starting archived log backup set
  3116. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  3117. input archived log thread=1 sequence=55 RECID=47 STAMP=952473495
  3118. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:23:58:16
  3119. channel ORA_SBT_TAPE_2: deleting archived log(s)
  3120. archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_54.273.952473447 RECID=46 STAMP=952473446
  3121. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:23:58:31
  3122. piece handle=3bscb5so_1_1 tag=5_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  3123. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:15
  3124. channel ORA_SBT_TAPE_1: deleting archived log(s)
  3125. archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_55.279.952473495 RECID=47 STAMP=952473495
  3126. Finished backup at 2017-08-19:23:58:31

  3127. Starting Control File and SPFILE Autobackup at 2017-08-19:23:58:31
  3128. piece handle=c-1343950367-20170819-06 comment=API Version 2.0,MMS Version 10.4.0.4
  3129. Finished Control File and SPFILE Autobackup at 2017-08-19:23:58:56

  3130. RMAN> backup tag '6_WHOLE_INCR0' incremental level 0 database plus archivelog delete all input;


  3131. Starting backup at 2017-08-20:00:00:08
  3132. current log archived
  3133. using channel ORA_SBT_TAPE_1
  3134. using channel ORA_SBT_TAPE_2
  3135. skipping archived log file +FRA/orcl/archivelog/2017_08_19/thread_1_seq_53.278.952473407; already backed up 2 time(s)
  3136. channel ORA_SBT_TAPE_1: starting archived log backup set
  3137. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  3138. input archived log thread=1 sequence=56 RECID=48 STAMP=952473608
  3139. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-20:00:00:08
  3140. channel ORA_SBT_TAPE_2: deleting archived log(s)
  3141. archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_53.278.952473407 RECID=45 STAMP=952473407
  3142. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-20:00:00:34
  3143. piece handle=3dscb608_1_1 tag=6_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  3144. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
  3145. channel ORA_SBT_TAPE_1: deleting archived log(s)
  3146. archived log file name=+FRA/orcl/archivelog/2017_08_20/thread_1_seq_56.279.952473609 RECID=48 STAMP=952473608
  3147. Finished backup at 2017-08-20:00:00:34

  3148. Starting backup at 2017-08-20:00:00:34
  3149. using channel ORA_SBT_TAPE_1
  3150. using channel ORA_SBT_TAPE_2
  3151. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  3152. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  3153. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  3154. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  3155. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  3156. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-20:00:00:34
  3157. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  3158. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  3159. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  3160. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  3161. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-08-20:00:00:34
  3162. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-20:00:00:59
  3163. piece handle=3escb612_1_1 tag=6_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  3164. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  3165. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-08-20:00:00:59
  3166. piece handle=3fscb612_1_1 tag=6_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  3167. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  3168. Finished backup at 2017-08-20:00:00:59

  3169. Starting backup at 2017-08-20:00:00:59
  3170. current log archived
  3171. using channel ORA_SBT_TAPE_1
  3172. using channel ORA_SBT_TAPE_2
  3173. channel ORA_SBT_TAPE_1: starting archived log backup set
  3174. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  3175. input archived log thread=1 sequence=57 RECID=49 STAMP=952473660
  3176. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-20:00:01:00
  3177. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-20:00:01:25
  3178. piece handle=3gscb61s_1_1 tag=6_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  3179. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  3180. channel ORA_SBT_TAPE_1: deleting archived log(s)
  3181. archived log file name=+FRA/orcl/archivelog/2017_08_20/thread_1_seq_57.279.952473661 RECID=49 STAMP=952473660
  3182. Finished backup at 2017-08-20:00:01:25

  3183. Starting Control File and SPFILE Autobackup at 2017-08-20:00:01:25
  3184. piece handle=c-1343950367-20170820-00 comment=API Version 2.0,MMS Version 10.4.0.4
  3185. Finished Control File and SPFILE Autobackup at 2017-08-20:00:01:50

  3186. RMAN> e/users.259.816169553

  3187. RMAN-00571: ===========================================================
  3188. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  3189. RMAN-00571: ===========================================================
  3190. RMAN-00558: error encountered while parsing input commands
  3191. RMAN-01009: syntax error: found "identifier": expecting one of: "advise, allocate, alter, backup, @, catalog, change, configure, connect, convert, copy, create, crosscheck, delete, drop, duplicate, exit, flashback, grant, host, import, list, mount, open, print, quit, recover, register, release, repair, replace, report, reset, restore, resync, revoke, run, send, set, show, shutdown, spool, sql, startup, switch, transport, unregister, upgrade, validate, {, "
  3192. RMAN-01008: the bad identifier was: e
  3193. RMAN-01007: at line 1 column 1 file: standard input

  3194. RMAN>
复制代码



回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-28 23:44 , Processed in 0.068258 second(s), 24 queries .

快速回复 返回顶部 返回列表