Bo's Oracle Station

查看: 864|回复: 4

课程第33次(2016-06-12星期五):配置可恢复性,了解rman retention policy指导的三件事情(report obsolete;repo

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2016-6-13 10:45:22 | 显示全部楼层 |阅读模式
本帖最后由 botang 于 2016-6-13 11:34 编辑

【上完1Z0-053的第2章】:配置可恢复性,了解rman retention policy指导的三件事情(report obsolete;report need backup和备份优化策略失效)
【1Z0-051】:共10章(0 1 2 3 4 5 6 7 8 9)
【1Z0-052】:共12章(0 1 2 3 4 5 6 9 10 14 15 16)
【1Z0-053】:共6章(0 1 2 10 11 12)
  1. select  * from v_$session s where s.PROGRAM  like '%rman%';

  2. select log_mode from v$database;

  3. select  * from v$archived_log   order by first_change#  desc;
复制代码


  1. Recovery Manager complete.
  2. [oracle@station90 ~]$ rman target  /  

  3. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 14 11:46:37 2016

  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       Device Type Elapsed Time Completion Time
  11. ------- ---- -- ---------- ----------- ------------ ---------------
  12. 75      Full    9.61M      DISK        00:00:00     06-JUN-16      
  13.         BP Key: 75   Status: AVAILABLE  Compressed: NO  Tag: TAG20160606T213606
  14.         Piece Name: +FRA/orcl/autobackup/2016_06_06/s_913844166.270.913844167
  15.   SPFILE Included: Modification time: 02-JUN-16
  16.   SPFILE db_unique_name: ORCL
  17.   Control File Included: Ckp SCN: 1544220      Ckp time: 06-JUN-16

  18. BS Key  Size       Device Type Elapsed Time Completion Time
  19. ------- ---------- ----------- ------------ ---------------
  20. 76      4.63M      SBT_TAPE    00:00:15     06-JUN-16      
  21.         BP Key: 76   Status: AVAILABLE  Compressed: NO  Tag: TAG20160606T213612
  22.         Handle: 2nr7g9uc_1_1   Media: station90-000013

  23.   List of Archived Logs in backup set 76
  24.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  25.   ---- ------- ---------- --------- ---------- ---------
  26.   1    27      1541455    06-JUN-16 1544415    06-JUN-16

  27. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  28. ------- ---- -- ---------- ----------- ------------ ---------------
  29. 77      Full    9.63M      SBT_TAPE    00:00:21     06-JUN-16      
  30.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: TAG20160606T213637
  31.         Handle: c-1343950367-20160606-03   Media: station90-000013
  32.   SPFILE Included: Modification time: 02-JUN-16
  33.   SPFILE db_unique_name: ORCL
  34.   Control File Included: Ckp SCN: 1544448      Ckp time: 06-JUN-16

  35. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  36. ------- ---- -- ---------- ----------- ------------ ---------------
  37. 78      Incr 1  13.34M     DISK        00:00:04     07-JUN-16      
  38.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  39.         Piece Name: +FRA/orcl/backupset/2016_06_07/nnndn1_ora_oem_level_0_0.272.913930533
  40.   List of Datafiles in backup set 78
  41.   File LV Type Ckp SCN    Ckp Time  Name
  42.   ---- -- ---- ---------- --------- ----
  43.   1    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/system.256.914102913
  44.   2    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553
  45.   3    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553
  46.   5    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/example.265.816169651

  47. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  48. ------- ---- -- ---------- ----------- ------------ ---------------
  49. 79      Full    9.61M      DISK        00:00:01     07-JUN-16      
  50.         BP Key: 79   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213536
  51.         Piece Name: +FRA/orcl/autobackup/2016_06_07/s_913930536.277.913930537
  52.   SPFILE Included: Modification time: 07-JUN-16
  53.   SPFILE db_unique_name: ORCL
  54.   Control File Included: Ckp SCN: 1547197      Ckp time: 07-JUN-16

  55. BS Key  Size       Device Type Elapsed Time Completion Time
  56. ------- ---------- ----------- ------------ ---------------
  57. 80      16.63M     SBT_TAPE    00:00:24     07-JUN-16      
  58.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213543
  59.         Handle: 2rr7iu9g_1_1   Media: station90-000013

  60.   List of Archived Logs in backup set 80
  61.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  62.   ---- ------- ---------- --------- ---------- ---------
  63.   1    28      1544415    06-JUN-16 1547833    07-JUN-16

  64. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  65. ------- ---- -- ---------- ----------- ------------ ---------------
  66. 81      Full    9.63M      SBT_TAPE    00:00:15     07-JUN-16      
  67.         BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213609
  68.         Handle: c-1343950367-20160607-01   Media: station90-000013
  69.   SPFILE Included: Modification time: 07-JUN-16
  70.   SPFILE db_unique_name: ORCL
  71.   Control File Included: Ckp SCN: 1548030      Ckp time: 07-JUN-16

  72. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  73. ------- ---- -- ---------- ----------- ------------ ---------------
  74. 82      Incr 1  16.52M     DISK        00:00:03     08-JUN-16      
  75.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  76.         Piece Name: +FRA/orcl/backupset/2016_06_08/nnndn1_ora_oem_level_0_0.279.914016939
  77.   List of Datafiles in backup set 82
  78.   File LV Type Ckp SCN    Ckp Time  Name
  79.   ---- -- ---- ---------- --------- ----
  80.   1    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/system.256.914102913
  81.   2    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553
  82.   3    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553
  83.   5    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/example.265.816169651

  84. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  85. ------- ---- -- ---------- ----------- ------------ ---------------
  86. 83      Full    9.61M      DISK        00:00:01     08-JUN-16      
  87.         BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213539
  88.         Piece Name: +FRA/orcl/autobackup/2016_06_08/s_914016939.280.914016941
  89.   SPFILE Included: Modification time: 08-JUN-16
  90.   SPFILE db_unique_name: ORCL
  91.   Control File Included: Ckp SCN: 1550834      Ckp time: 08-JUN-16

  92. BS Key  Size       Device Type Elapsed Time Completion Time
  93. ------- ---------- ----------- ------------ ---------------
  94. 84      9.69M      SBT_TAPE    00:00:23     08-JUN-16      
  95.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213546
  96.         Handle: 2vr7lilj_1_1   Media: station90-000013

  97.   List of Archived Logs in backup set 84
  98.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  99.   ---- ------- ---------- --------- ---------- ---------
  100.   1    29      1547833    07-JUN-16 1551061    08-JUN-16

  101. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  102. ------- ---- -- ---------- ----------- ------------ ---------------
  103. 85      Full    9.63M      SBT_TAPE    00:00:16     08-JUN-16      
  104.         BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213612
  105.         Handle: c-1343950367-20160608-01   Media: station90-000013
  106.   SPFILE Included: Modification time: 08-JUN-16
  107.   SPFILE db_unique_name: ORCL
  108.   Control File Included: Ckp SCN: 1551112      Ckp time: 08-JUN-16

  109. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  110. ------- ---- -- ---------- ----------- ------------ ---------------
  111. 86      Full    600.75M    SBT_TAPE    00:02:09     09-JUN-16      
  112.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T201727
  113.         Handle: 31r7o2en_1_1   Media: station90-000013
  114.   List of Datafiles in backup set 86
  115.   File LV Type Ckp SCN    Ckp Time  Name
  116.   ---- -- ---- ---------- --------- ----
  117.   1       Full 1577433    09-JUN-16 +DATA/orcl/datafile/system.256.914102913

  118. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  119. ------- ---- -- ---------- ----------- ------------ ---------------
  120. 87      Full    9.63M      SBT_TAPE    00:00:55     09-JUN-16      
  121.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T201943
  122.         Handle: c-1343950367-20160609-00   Media: station90-000013
  123.   SPFILE Included: Modification time: 09-JUN-16
  124.   SPFILE db_unique_name: ORCL
  125.   Control File Included: Ckp SCN: 1577543      Ckp time: 09-JUN-16

  126. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  127. ------- ---- -- ---------- ----------- ------------ ---------------
  128. 88      Full    1.06M      SBT_TAPE    00:00:15     09-JUN-16      
  129.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202130
  130.         Handle: 33r7o2ma_1_1   Media: station90-000013
  131.   List of Datafiles in backup set 88
  132.   File LV Type Ckp SCN    Ckp Time  Name
  133.   ---- -- ---- ---------- --------- ----
  134.   4       Full 1577931    09-JUN-16 +DATA/orcl/datafile/users.259.914101365

  135. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  136. ------- ---- -- ---------- ----------- ------------ ---------------
  137. 89      Full    9.63M      SBT_TAPE    00:00:16     09-JUN-16      
  138.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202155
  139.         Handle: c-1343950367-20160609-01   Media: station90-000013
  140.   SPFILE Included: Modification time: 09-JUN-16
  141.   SPFILE db_unique_name: ORCL
  142.   Control File Included: Ckp SCN: 1577971      Ckp time: 09-JUN-16

  143. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  144. ------- ---- -- ---------- ----------- ------------ ---------------
  145. 90      Full    9.61M      DISK        00:00:01     09-JUN-16      
  146.         BP Key: 90   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T205016
  147.         Piece Name: +FRA/orcl/autobackup/2016_06_09/s_914100616.313.914100617
  148.   SPFILE Included: Modification time: 09-JUN-16
  149.   SPFILE db_unique_name: ORCL
  150.   Control File Included: Ckp SCN: 1579657      Ckp time: 09-JUN-16

  151. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  152. ------- ---- -- ---------- ----------- ------------ ---------------
  153. 91      Full    9.61M      DISK        00:00:00     09-JUN-16      
  154.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T211017
  155.         Piece Name: +FRA/orcl/autobackup/2016_06_09/s_914101817.298.914101817
  156.   SPFILE Included: Modification time: 09-JUN-16
  157.   SPFILE db_unique_name: ORCL
  158.   Control File Included: Ckp SCN: 1581203      Ckp time: 09-JUN-16

  159. RMAN> list backup summary ;


  160. List of Backups
  161. ===============
  162. Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
  163. ------- -- -- - ----------- --------------- ------- ------- ---------- ---
  164. 75      B  F  A DISK        06-JUN-16       1       1       NO         TAG20160606T213606
  165. 76      B  A  A SBT_TAPE    06-JUN-16       1       1       NO         TAG20160606T213612
  166. 77      B  F  A SBT_TAPE    06-JUN-16       1       1       NO         TAG20160606T213637
  167. 78      B  1  A DISK        07-JUN-16       1       1       NO         ORA_OEM_LEVEL_0
  168. 79      B  F  A DISK        07-JUN-16       1       1       NO         TAG20160607T213536
  169. 80      B  A  A SBT_TAPE    07-JUN-16       1       1       NO         TAG20160607T213543
  170. 81      B  F  A SBT_TAPE    07-JUN-16       1       1       NO         TAG20160607T213609
  171. 82      B  1  A DISK        08-JUN-16       1       1       NO         ORA_OEM_LEVEL_0
  172. 83      B  F  A DISK        08-JUN-16       1       1       NO         TAG20160608T213539
  173. 84      B  A  A SBT_TAPE    08-JUN-16       1       1       NO         TAG20160608T213546
  174. 85      B  F  A SBT_TAPE    08-JUN-16       1       1       NO         TAG20160608T213612
  175. 86      B  F  A SBT_TAPE    09-JUN-16       1       1       NO         TAG20160609T201727
  176. 87      B  F  A SBT_TAPE    09-JUN-16       1       1       NO         TAG20160609T201943
  177. 88      B  F  A SBT_TAPE    09-JUN-16       1       1       NO         TAG20160609T202130
  178. 89      B  F  A SBT_TAPE    09-JUN-16       1       1       NO         TAG20160609T202155
  179. 90      B  F  A DISK        09-JUN-16       1       1       NO         TAG20160609T205016
  180. 91      B  F  A DISK        09-JUN-16       1       1       NO         TAG20160609T211017

  181. RMAN> list backupset 77;


  182. List of Backup Sets
  183. ===================


  184. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  185. ------- ---- -- ---------- ----------- ------------ ---------------
  186. 77      Full    9.63M      SBT_TAPE    00:00:21     06-JUN-16      
  187.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: TAG20160606T213637
  188.         Handle: c-1343950367-20160606-03   Media: station90-000013
  189.   Control File Included: Ckp SCN: 1544448      Ckp time: 06-JUN-16
  190.   SPFILE Included: Modification time: 02-JUN-16
  191.   SPFILE db_unique_name: ORCL

  192. RMAN> list backup;


  193. List of Backup Sets
  194. ===================


  195. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  196. ------- ---- -- ---------- ----------- ------------ ---------------
  197. 75      Full    9.61M      DISK        00:00:00     06-JUN-16      
  198.         BP Key: 75   Status: AVAILABLE  Compressed: NO  Tag: TAG20160606T213606
  199.         Piece Name: +FRA/orcl/autobackup/2016_06_06/s_913844166.270.913844167
  200.   SPFILE Included: Modification time: 02-JUN-16
  201.   SPFILE db_unique_name: ORCL
  202.   Control File Included: Ckp SCN: 1544220      Ckp time: 06-JUN-16

  203. BS Key  Size       Device Type Elapsed Time Completion Time
  204. ------- ---------- ----------- ------------ ---------------
  205. 76      4.63M      SBT_TAPE    00:00:15     06-JUN-16      
  206.         BP Key: 76   Status: AVAILABLE  Compressed: NO  Tag: TAG20160606T213612
  207.         Handle: 2nr7g9uc_1_1   Media: station90-000013

  208.   List of Archived Logs in backup set 76
  209.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  210.   ---- ------- ---------- --------- ---------- ---------
  211.   1    27      1541455    06-JUN-16 1544415    06-JUN-16

  212. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  213. ------- ---- -- ---------- ----------- ------------ ---------------
  214. 77      Full    9.63M      SBT_TAPE    00:00:21     06-JUN-16      
  215.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: TAG20160606T213637
  216.         Handle: c-1343950367-20160606-03   Media: station90-000013
  217.   SPFILE Included: Modification time: 02-JUN-16
  218.   SPFILE db_unique_name: ORCL
  219.   Control File Included: Ckp SCN: 1544448      Ckp time: 06-JUN-16

  220. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  221. ------- ---- -- ---------- ----------- ------------ ---------------
  222. 78      Incr 1  13.34M     DISK        00:00:04     07-JUN-16      
  223.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  224.         Piece Name: +FRA/orcl/backupset/2016_06_07/nnndn1_ora_oem_level_0_0.272.913930533
  225.   List of Datafiles in backup set 78
  226.   File LV Type Ckp SCN    Ckp Time  Name
  227.   ---- -- ---- ---------- --------- ----
  228.   1    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/system.256.914102913
  229.   2    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553
  230.   3    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553
  231.   5    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/example.265.816169651

  232. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  233. ------- ---- -- ---------- ----------- ------------ ---------------
  234. 79      Full    9.61M      DISK        00:00:01     07-JUN-16      
  235.         BP Key: 79   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213536
  236.         Piece Name: +FRA/orcl/autobackup/2016_06_07/s_913930536.277.913930537
  237.   SPFILE Included: Modification time: 07-JUN-16
  238.   SPFILE db_unique_name: ORCL
  239.   Control File Included: Ckp SCN: 1547197      Ckp time: 07-JUN-16

  240. BS Key  Size       Device Type Elapsed Time Completion Time
  241. ------- ---------- ----------- ------------ ---------------
  242. 80      16.63M     SBT_TAPE    00:00:24     07-JUN-16      
  243.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213543
  244.         Handle: 2rr7iu9g_1_1   Media: station90-000013

  245.   List of Archived Logs in backup set 80
  246.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  247.   ---- ------- ---------- --------- ---------- ---------
  248.   1    28      1544415    06-JUN-16 1547833    07-JUN-16

  249. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  250. ------- ---- -- ---------- ----------- ------------ ---------------
  251. 81      Full    9.63M      SBT_TAPE    00:00:15     07-JUN-16      
  252.         BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213609
  253.         Handle: c-1343950367-20160607-01   Media: station90-000013
  254.   SPFILE Included: Modification time: 07-JUN-16
  255.   SPFILE db_unique_name: ORCL
  256.   Control File Included: Ckp SCN: 1548030      Ckp time: 07-JUN-16

  257. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  258. ------- ---- -- ---------- ----------- ------------ ---------------
  259. 82      Incr 1  16.52M     DISK        00:00:03     08-JUN-16      
  260.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  261.         Piece Name: +FRA/orcl/backupset/2016_06_08/nnndn1_ora_oem_level_0_0.279.914016939
  262.   List of Datafiles in backup set 82
  263.   File LV Type Ckp SCN    Ckp Time  Name
  264.   ---- -- ---- ---------- --------- ----
  265.   1    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/system.256.914102913
  266.   2    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553
  267.   3    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553
  268.   5    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/example.265.816169651

  269. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  270. ------- ---- -- ---------- ----------- ------------ ---------------
  271. 83      Full    9.61M      DISK        00:00:01     08-JUN-16      
  272.         BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213539
  273.         Piece Name: +FRA/orcl/autobackup/2016_06_08/s_914016939.280.914016941
  274.   SPFILE Included: Modification time: 08-JUN-16
  275.   SPFILE db_unique_name: ORCL
  276.   Control File Included: Ckp SCN: 1550834      Ckp time: 08-JUN-16

  277. BS Key  Size       Device Type Elapsed Time Completion Time
  278. ------- ---------- ----------- ------------ ---------------
  279. 84      9.69M      SBT_TAPE    00:00:23     08-JUN-16      
  280.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213546
  281.         Handle: 2vr7lilj_1_1   Media: station90-000013

  282.   List of Archived Logs in backup set 84
  283.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  284.   ---- ------- ---------- --------- ---------- ---------
  285.   1    29      1547833    07-JUN-16 1551061    08-JUN-16

  286. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  287. ------- ---- -- ---------- ----------- ------------ ---------------
  288. 85      Full    9.63M      SBT_TAPE    00:00:16     08-JUN-16      
  289.         BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213612
  290.         Handle: c-1343950367-20160608-01   Media: station90-000013
  291.   SPFILE Included: Modification time: 08-JUN-16
  292.   SPFILE db_unique_name: ORCL
  293.   Control File Included: Ckp SCN: 1551112      Ckp time: 08-JUN-16

  294. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  295. ------- ---- -- ---------- ----------- ------------ ---------------
  296. 86      Full    600.75M    SBT_TAPE    00:02:09     09-JUN-16      
  297.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T201727
  298.         Handle: 31r7o2en_1_1   Media: station90-000013
  299.   List of Datafiles in backup set 86
  300.   File LV Type Ckp SCN    Ckp Time  Name
  301.   ---- -- ---- ---------- --------- ----
  302.   1       Full 1577433    09-JUN-16 +DATA/orcl/datafile/system.256.914102913

  303. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  304. ------- ---- -- ---------- ----------- ------------ ---------------
  305. 87      Full    9.63M      SBT_TAPE    00:00:55     09-JUN-16      
  306.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T201943
  307.         Handle: c-1343950367-20160609-00   Media: station90-000013
  308.   SPFILE Included: Modification time: 09-JUN-16
  309.   SPFILE db_unique_name: ORCL
  310.   Control File Included: Ckp SCN: 1577543      Ckp time: 09-JUN-16

  311. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  312. ------- ---- -- ---------- ----------- ------------ ---------------
  313. 88      Full    1.06M      SBT_TAPE    00:00:15     09-JUN-16      
  314.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202130
  315.         Handle: 33r7o2ma_1_1   Media: station90-000013
  316.   List of Datafiles in backup set 88
  317.   File LV Type Ckp SCN    Ckp Time  Name
  318.   ---- -- ---- ---------- --------- ----
  319.   4       Full 1577931    09-JUN-16 +DATA/orcl/datafile/users.259.914101365

  320. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  321. ------- ---- -- ---------- ----------- ------------ ---------------
  322. 89      Full    9.63M      SBT_TAPE    00:00:16     09-JUN-16      
  323.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202155
  324.         Handle: c-1343950367-20160609-01   Media: station90-000013
  325.   SPFILE Included: Modification time: 09-JUN-16
  326.   SPFILE db_unique_name: ORCL
  327.   Control File Included: Ckp SCN: 1577971      Ckp time: 09-JUN-16

  328. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  329. ------- ---- -- ---------- ----------- ------------ ---------------
  330. 90      Full    9.61M      DISK        00:00:01     09-JUN-16      
  331.         BP Key: 90   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T205016
  332.         Piece Name: +FRA/orcl/autobackup/2016_06_09/s_914100616.313.914100617
  333.   SPFILE Included: Modification time: 09-JUN-16
  334.   SPFILE db_unique_name: ORCL
  335.   Control File Included: Ckp SCN: 1579657      Ckp time: 09-JUN-16

  336. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  337. ------- ---- -- ---------- ----------- ------------ ---------------
  338. 91      Full    9.61M      DISK        00:00:00     09-JUN-16      
  339.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T211017
  340.         Piece Name: +FRA/orcl/autobackup/2016_06_09/s_914101817.298.914101817
  341.   SPFILE Included: Modification time: 09-JUN-16
  342.   SPFILE db_unique_name: ORCL
  343.   Control File Included: Ckp SCN: 1581203      Ckp time: 09-JUN-16

  344. RMAN>

复制代码



回复

使用道具 举报

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
 楼主| 发表于 2016-6-13 10:57:43 | 显示全部楼层

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     14-JUN-16      
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 14-JUN-16
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     14-JUN-16      
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1858946    14-JUN-16 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     14-JUN-16      
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4    0  Incr 1858958    14-JUN-16 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     14-JUN-16      
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 1858949    14-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     14-JUN-16      
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 14-JUN-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     14-JUN-16      
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 1858955    14-JUN-16 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     14-JUN-16      
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    0  Incr 1858952    14-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553

RMAN> exit


Recovery Manager complete.
[oracle@station90 archivelog]$ export NLS_DATE_FORMAT='YYYY-MM-DD:HH24:MI:SS'
[oracle@station90 archivelog]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 14 13:00:20 2016

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

connected to target database: ORCL (DBID=1343950367)

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     2016-06-14:12:54:16
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     2016-06-14:12:55:00
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1858946    2016-06-14:12:53:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     2016-06-14:12:55:18
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1858958    2016-06-14:12:53:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     2016-06-14:12:55:44
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1858949    2016-06-14:12:53:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     2016-06-14:12:55:59
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 2016-06-14:12:53:51

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     2016-06-14:12:56:02
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1858955    2016-06-14:12:53:51 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     2016-06-14:12:56:18
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1858952    2016-06-14:12:53:50 +DATA/orcl/datafile/undotbs1.258.816169553

RMAN> exit


Recovery Manager complete.
[oracle@station90 archivelog]$ exit
logout
[root@station90 ~]# date
2016年 06月 14日 星期二 13:01:00 CST
[root@station90 ~]# export LANG=en_US
[root@station90 ~]# date
Tue Jun 14 13:01:09 CST 2016
[root@station90 ~]# date -s "Tue Jun 15 13:01:09 CST 2016"
Wed Jun 15 13:01:09 CST 2016
[root@station90 ~]# date
Wed Jun 15 13:01:14 CST 2016
[root@station90 ~]# su - oracle
[oracle@station90 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 15 13:01:25 2016

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

connected to target database: ORCL (DBID=1343950367)

RMAN> backup tag '2T_WHOLE_INCR0'   incremental level 0 database ;

Starting backup at 15-JUN-16

using target database control file instead of recovery catalog
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=80 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=140 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: SID=202 device type=SBT_TAPE
channel ORA_SBT_TAPE_3: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: SID=203 device type=SBT_TAPE
channel ORA_SBT_TAPE_4: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_5
channel ORA_SBT_TAPE_5: SID=78 device type=SBT_TAPE
channel ORA_SBT_TAPE_5: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_6
channel ORA_SBT_TAPE_6: SID=15 device type=SBT_TAPE
channel ORA_SBT_TAPE_6: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_7
channel ORA_SBT_TAPE_7: SID=75 device type=SBT_TAPE
channel ORA_SBT_TAPE_7: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_8
channel ORA_SBT_TAPE_8: SID=141 device type=SBT_TAPE
channel ORA_SBT_TAPE_8: Oracle Secure Backup
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
channel ORA_SBT_TAPE_1: starting piece 1 at 15-JUN-16
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
channel ORA_SBT_TAPE_2: starting piece 1 at 15-JUN-16
channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
channel ORA_SBT_TAPE_3: starting piece 1 at 15-JUN-16
channel ORA_SBT_TAPE_4: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
channel ORA_SBT_TAPE_4: starting piece 1 at 15-JUN-16
channel ORA_SBT_TAPE_5: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_5: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
channel ORA_SBT_TAPE_5: starting piece 1 at 15-JUN-16
channel ORA_SBT_TAPE_6: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_6: specifying datafile(s) in backup set
channel ORA_SBT_TAPE_7: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_7: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_SBT_TAPE_7: starting piece 1 at 15-JUN-16
including current control file in backup set
channel ORA_SBT_TAPE_6: starting piece 1 at 15-JUN-16
channel ORA_SBT_TAPE_7: finished piece 1 at 15-JUN-16
piece handle=4fr8735o_1_1 tag=2T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_7: backup set complete, elapsed time: 00:00:26
channel ORA_SBT_TAPE_1: finished piece 1 at 15-JUN-16
piece handle=49r8735n_1_1 tag=2T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:07
channel ORA_SBT_TAPE_4: finished piece 1 at 15-JUN-16
piece handle=4cr8735n_1_1 tag=2T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:01:27
channel ORA_SBT_TAPE_5: finished piece 1 at 15-JUN-16
piece handle=4dr8735n_1_1 tag=2T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:01:26
channel ORA_SBT_TAPE_6: finished piece 1 at 15-JUN-16
piece handle=4er8735o_1_1 tag=2T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:01:45
channel ORA_SBT_TAPE_2: finished piece 1 at 15-JUN-16
piece handle=4ar8735n_1_1 tag=2T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:02:17
channel ORA_SBT_TAPE_3: finished piece 1 at 15-JUN-16
piece handle=4br8735n_1_1 tag=2T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:02:27
Finished backup at 15-JUN-16

RMAN>
RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     14-JUN-16      
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 14-JUN-16
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     14-JUN-16      
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1858946    14-JUN-16 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     14-JUN-16      
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4    0  Incr 1858958    14-JUN-16 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     14-JUN-16      
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 1858949    14-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     14-JUN-16      
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 14-JUN-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     14-JUN-16      
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 1858955    14-JUN-16 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     14-JUN-16      
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    0  Incr 1858952    14-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
126     Incr 0  128.00K    SBT_TAPE    00:00:24     15-JUN-16      
        BP Key: 126   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4fr8735o_1_1   Media: station90-000016
  SPFILE Included: Modification time: 14-JUN-16
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
127     Incr 0  602.69M    SBT_TAPE    00:01:06     15-JUN-16      
        BP Key: 127   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 49r8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 127
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1860003    15-JUN-16 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
128     Incr 0  1.13M      SBT_TAPE    00:01:21     15-JUN-16      
        BP Key: 128   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4dr8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 128
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4    0  Incr 1860015    15-JUN-16 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
129     Incr 0  14.94M     SBT_TAPE    00:01:26     15-JUN-16      
        BP Key: 129   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4cr8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 129
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 1860012    15-JUN-16 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
130     Incr 0  9.63M      SBT_TAPE    00:01:40     15-JUN-16      
        BP Key: 130   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4er8735o_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1860013      Ckp time: 15-JUN-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
131     Incr 0  510.00M    SBT_TAPE    00:02:09     15-JUN-16      
        BP Key: 131   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4ar8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 131
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 1860006    15-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
132     Incr 0  3.38M      SBT_TAPE    00:02:22     15-JUN-16      
        BP Key: 132   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4br8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 132
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    0  Incr 1860009    15-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553

RMAN> exit


Recovery Manager complete.
[oracle@station90 ~]$ exit
logout
[root@station90 ~]# date
Wed Jun 15 13:06:55 CST 2016
[root@station90 ~]# date -s "Wed Jun 16 13:06:55 CST 2016"
Thu Jun 16 13:06:55 CST 2016
[root@station90 ~]# date
Thu Jun 16 13:06:58 CST 2016
[root@station90 ~]# su - oracle
[oracle@station90 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 16 13:07:04 2016

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

connected to target database: ORCL (DBID=1343950367)

RMAN> report obsolete;

using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           120    14-JUN-16         
  Backup Piece       120    14-JUN-16          42r84eau_1_1
Backup Set           122    14-JUN-16         
  Backup Piece       122    14-JUN-16          43r84eau_1_1
Backup Set           125    14-JUN-16         
  Backup Piece       125    14-JUN-16          44r84eau_1_1
Backup Set           124    14-JUN-16         
  Backup Piece       124    14-JUN-16          45r84eau_1_1
Backup Set           121    14-JUN-16         
  Backup Piece       121    14-JUN-16          46r84eau_1_1
Backup Set           123    14-JUN-16         
  Backup Piece       123    14-JUN-16          47r84eav_1_1
Backup Set           119    14-JUN-16         
  Backup Piece       119    14-JUN-16          48r84eav_1_1

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

RMAN> exit


Recovery Manager complete.
[oracle@station90 ~]$ exit
logout
[root@station90 ~]# date
Thu Jun 16 13:09:24 CST 2016
[root@station90 ~]# date -s "Thu Jun 15 23:59:00 CST 2016"
Wed Jun 15 23:59:00 CST 2016
[root@station90 ~]# su - oracle
[oracle@station90 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 15 23:59:05 2016

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

connected to target database: ORCL (DBID=1343950367)

RMAN> report obsolete;

using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> list backupset 126;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
126     Incr 0  128.00K    SBT_TAPE    00:00:24     15-JUN-16      
        BP Key: 126   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4fr8735o_1_1   Media: station90-000016
  SPFILE Included: Modification time: 14-JUN-16
  SPFILE db_unique_name: ORCL

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     14-JUN-16      
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 14-JUN-16
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     14-JUN-16      
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1858946    14-JUN-16 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     14-JUN-16      
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4    0  Incr 1858958    14-JUN-16 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     14-JUN-16      
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 1858949    14-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     14-JUN-16      
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 14-JUN-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     14-JUN-16      
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 1858955    14-JUN-16 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     14-JUN-16      
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    0  Incr 1858952    14-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
126     Incr 0  128.00K    SBT_TAPE    00:00:24     15-JUN-16      
        BP Key: 126   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4fr8735o_1_1   Media: station90-000016
  SPFILE Included: Modification time: 14-JUN-16
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
127     Incr 0  602.69M    SBT_TAPE    00:01:06     15-JUN-16      
        BP Key: 127   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 49r8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 127
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1860003    15-JUN-16 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
128     Incr 0  1.13M      SBT_TAPE    00:01:21     15-JUN-16      
        BP Key: 128   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4dr8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 128
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4    0  Incr 1860015    15-JUN-16 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
129     Incr 0  14.94M     SBT_TAPE    00:01:26     15-JUN-16      
        BP Key: 129   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4cr8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 129
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 1860012    15-JUN-16 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
130     Incr 0  9.63M      SBT_TAPE    00:01:40     15-JUN-16      
        BP Key: 130   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4er8735o_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1860013      Ckp time: 15-JUN-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
131     Incr 0  510.00M    SBT_TAPE    00:02:09     15-JUN-16      
        BP Key: 131   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4ar8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 131
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 1860006    15-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
132     Incr 0  3.38M      SBT_TAPE    00:02:22     15-JUN-16      
        BP Key: 132   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4br8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 132
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    0  Incr 1860009    15-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553

RMAN> exit


Recovery Manager complete.
[oracle@station90 ~]$ vim .bash_profile
[oracle@station90 ~]$ . .bash_profile
[oracle@station90 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 16 00:01:28 2016

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

connected to target database: ORCL (DBID=1343950367)

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     2016-06-14:12:54:16
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     2016-06-14:12:55:00
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1858946    2016-06-14:12:53:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     2016-06-14:12:55:18
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1858958    2016-06-14:12:53:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     2016-06-14:12:55:44
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1858949    2016-06-14:12:53:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     2016-06-14:12:55:59
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 2016-06-14:12:53:51

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     2016-06-14:12:56:02
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1858955    2016-06-14:12:53:51 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     2016-06-14:12:56:18
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1858952    2016-06-14:12:53:50 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
126     Incr 0  128.00K    SBT_TAPE    00:00:24     2016-06-15:13:02:08
        BP Key: 126   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4fr8735o_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
127     Incr 0  602.69M    SBT_TAPE    00:01:06     2016-06-15:13:02:49
        BP Key: 127   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 49r8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 127
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1860003    2016-06-15:13:01:43 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
128     Incr 0  1.13M      SBT_TAPE    00:01:21     2016-06-15:13:03:04
        BP Key: 128   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4dr8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 128
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1860015    2016-06-15:13:01:44 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
129     Incr 0  14.94M     SBT_TAPE    00:01:26     2016-06-15:13:03:09
        BP Key: 129   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4cr8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 129
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1860012    2016-06-15:13:01:44 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
130     Incr 0  9.63M      SBT_TAPE    00:01:40     2016-06-15:13:03:24
        BP Key: 130   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4er8735o_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1860013      Ckp time: 2016-06-15:13:01:44

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
131     Incr 0  510.00M    SBT_TAPE    00:02:09     2016-06-15:13:03:52
        BP Key: 131   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4ar8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 131
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1860006    2016-06-15:13:01:43 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
132     Incr 0  3.38M      SBT_TAPE    00:02:22     2016-06-15:13:04:05
        BP Key: 132   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4br8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 132
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1860009    2016-06-15:13:01:44 +DATA/orcl/datafile/undotbs1.258.816169553

RMAN> exit


Recovery Manager complete.
[oracle@station90 ~]$ exit
logout
[root@station90 ~]# date
Thu Jun 16 00:01:50 CST 2016
[root@station90 ~]# date -s "Thu Jun 16 13:01:08 CST 2016"
Thu Jun 16 13:01:08 CST 2016
[root@station90 ~]# date
Thu Jun 16 13:01:09 CST 2016
[root@station90 ~]# su - orace
su: user orace does not exist
[root@station90 ~]# su - oracle
[oracle@station90 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 16 13:01:18 2016

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

connected to target database: ORCL (DBID=1343950367)

RMAN> report obsolete;

using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           120    2016-06-14:12:55:00
  Backup Piece       120    2016-06-14:12:55:00 42r84eau_1_1
Backup Set           122    2016-06-14:12:55:44
  Backup Piece       122    2016-06-14:12:55:44 43r84eau_1_1
Backup Set           125    2016-06-14:12:56:18
  Backup Piece       125    2016-06-14:12:56:18 44r84eau_1_1
Backup Set           124    2016-06-14:12:56:02
  Backup Piece       124    2016-06-14:12:56:02 45r84eau_1_1
Backup Set           121    2016-06-14:12:55:18
  Backup Piece       121    2016-06-14:12:55:18 46r84eau_1_1
Backup Set           123    2016-06-14:12:55:59
  Backup Piece       123    2016-06-14:12:55:59 47r84eav_1_1
Backup Set           119    2016-06-14:12:54:16
  Backup Piece       119    2016-06-14:12:54:16 48r84eav_1_1

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> exit


Recovery Manager complete.
[oracle@station90 ~]$ exit
logout
[root@station90 ~]# date
Thu Jun 16 13:03:29 CST 2016
[root@station90 ~]# date -s "Thu Jun 16 23:59:00 CST 2016"
Thu Jun 16 23:59:00 CST 2016
[root@station90 ~]# su - oracle
[oracle@station90 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 16 23:59:06 2016

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

connected to target database: ORCL (DBID=1343950367)

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

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

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------
1    2     +DATA/orcl/datafile/system.256.914102913
2    2     +DATA/orcl/datafile/sysaux.257.816169553
3    2     +DATA/orcl/datafile/undotbs1.258.816169553
4    2     +DATA/orcl/datafile/users.259.914101365
5    2     +DATA/orcl/datafile/example.265.816169651

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

RMAN> backup tag '3T_WHOLE_INCR0' incremental level 0  database ;

Starting backup at 2016-06-17:00:04:46
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=78 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=202 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: SID=79 device type=SBT_TAPE
channel ORA_SBT_TAPE_3: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: SID=141 device type=SBT_TAPE
channel ORA_SBT_TAPE_4: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_5
channel ORA_SBT_TAPE_5: SID=201 device type=SBT_TAPE
channel ORA_SBT_TAPE_5: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_6
channel ORA_SBT_TAPE_6: SID=203 device type=SBT_TAPE
channel ORA_SBT_TAPE_6: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_7
channel ORA_SBT_TAPE_7: SID=18 device type=SBT_TAPE
channel ORA_SBT_TAPE_7: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_8
channel ORA_SBT_TAPE_8: SID=75 device type=SBT_TAPE
channel ORA_SBT_TAPE_8: Oracle Secure Backup
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-17:00:04:50
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-17:00:04:50
channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-17:00:04:50
channel ORA_SBT_TAPE_4: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
channel ORA_SBT_TAPE_4: starting piece 1 at 2016-06-17:00:04:50
channel ORA_SBT_TAPE_5: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_5: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
channel ORA_SBT_TAPE_5: starting piece 1 at 2016-06-17:00:04:50
channel ORA_SBT_TAPE_6: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_6: specifying datafile(s) in backup set
channel ORA_SBT_TAPE_7: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_7: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_SBT_TAPE_7: starting piece 1 at 2016-06-17:00:04:51
including current control file in backup set
channel ORA_SBT_TAPE_6: starting piece 1 at 2016-06-17:00:04:52
channel ORA_SBT_TAPE_7: finished piece 1 at 2016-06-17:00:05:17
piece handle=4mr8aud3_1_1 tag=3T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_7: backup set complete, elapsed time: 00:00:26
channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-17:00:05:47
piece handle=4gr8aud2_1_1 tag=3T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:57
channel ORA_SBT_TAPE_4: finished piece 1 at 2016-06-17:00:06:07
piece handle=4jr8aud2_1_1 tag=3T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:01:17
channel ORA_SBT_TAPE_6: finished piece 1 at 2016-06-17:00:06:07
piece handle=4lr8aud3_1_1 tag=3T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:01:15
channel ORA_SBT_TAPE_5: finished piece 1 at 2016-06-17:00:06:27
piece handle=4kr8aud2_1_1 tag=3T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:01:37
channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-17:00:06:57
piece handle=4hr8aud2_1_1 tag=3T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:02:07
channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-17:00:07:17
piece handle=4ir8aud2_1_1 tag=3T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:02:27
Finished backup at 2016-06-17:00:07:17

RMAN> list backup ;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     2016-06-14:12:54:16
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     2016-06-14:12:55:00
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1858946    2016-06-14:12:53:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     2016-06-14:12:55:18
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1858958    2016-06-14:12:53:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     2016-06-14:12:55:44
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1858949    2016-06-14:12:53:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     2016-06-14:12:55:59
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 2016-06-14:12:53:51

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     2016-06-14:12:56:02
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1858955    2016-06-14:12:53:51 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     2016-06-14:12:56:18
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1858952    2016-06-14:12:53:50 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
126     Incr 0  128.00K    SBT_TAPE    00:00:24     2016-06-15:13:02:08
        BP Key: 126   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4fr8735o_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
127     Incr 0  602.69M    SBT_TAPE    00:01:06     2016-06-15:13:02:49
        BP Key: 127   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 49r8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 127
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1860003    2016-06-15:13:01:43 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
128     Incr 0  1.13M      SBT_TAPE    00:01:21     2016-06-15:13:03:04
        BP Key: 128   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4dr8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 128
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1860015    2016-06-15:13:01:44 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
129     Incr 0  14.94M     SBT_TAPE    00:01:26     2016-06-15:13:03:09
        BP Key: 129   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4cr8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 129
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1860012    2016-06-15:13:01:44 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
130     Incr 0  9.63M      SBT_TAPE    00:01:40     2016-06-15:13:03:24
        BP Key: 130   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4er8735o_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1860013      Ckp time: 2016-06-15:13:01:44

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
131     Incr 0  510.00M    SBT_TAPE    00:02:09     2016-06-15:13:03:52
        BP Key: 131   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4ar8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 131
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1860006    2016-06-15:13:01:43 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
132     Incr 0  3.38M      SBT_TAPE    00:02:22     2016-06-15:13:04:05
        BP Key: 132   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4br8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 132
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1860009    2016-06-15:13:01:44 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
133     Incr 0  128.00K    SBT_TAPE    00:00:24     2016-06-17:00:05:15
        BP Key: 133   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4mr8aud3_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
134     Incr 0  603.19M    SBT_TAPE    00:00:54     2016-06-17:00:05:44
        BP Key: 134   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4gr8aud2_1_1   Media: station90-000015
  List of Datafiles in backup set 134
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1900632    2016-06-17:00:04:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
135     Incr 0  14.94M     SBT_TAPE    00:01:09     2016-06-17:00:05:59
        BP Key: 135   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4jr8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 135
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1900584    2016-06-17:00:04:06 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
136     Incr 0  9.63M      SBT_TAPE    00:01:12     2016-06-17:00:06:03
        BP Key: 136   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4lr8aud3_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1900639      Ckp time: 2016-06-17:00:04:50

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
137     Incr 0  1.13M      SBT_TAPE    00:01:27     2016-06-17:00:06:17
        BP Key: 137   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4kr8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 137
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1900641    2016-06-17:00:04:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
138     Incr 0  512.94M    SBT_TAPE    00:02:01     2016-06-17:00:06:51
        BP Key: 138   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4hr8aud2_1_1   Media: station90-000015
  List of Datafiles in backup set 138
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1900635    2016-06-17:00:04:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
139     Incr 0  53.00M     SBT_TAPE    00:02:18     2016-06-17:00:07:08
        BP Key: 139   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4ir8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 139
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1900638    2016-06-17:00:04:50 +DATA/orcl/datafile/undotbs1.258.816169553

RMAN> backup tag '4T_WHOLE_INCR0' incremental level 0  database ;

Starting backup at 2016-06-17:00:08:42
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_SBT_TAPE_3
using channel ORA_SBT_TAPE_4
using channel ORA_SBT_TAPE_5
using channel ORA_SBT_TAPE_6
using channel ORA_SBT_TAPE_7
using channel ORA_SBT_TAPE_8
skipping datafile 5; already backed up 1 time(s)
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-17:00:08:42
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-17:00:08:42
channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-17:00:08:42
channel ORA_SBT_TAPE_4: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
channel ORA_SBT_TAPE_4: starting piece 1 at 2016-06-17:00:08:43
channel ORA_SBT_TAPE_5: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_5: specifying datafile(s) in backup set
channel ORA_SBT_TAPE_6: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_6: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_SBT_TAPE_6: starting piece 1 at 2016-06-17:00:08:43
including current control file in backup set
channel ORA_SBT_TAPE_5: starting piece 1 at 2016-06-17:00:08:44
channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-17:00:09:29
piece handle=4or8auka_1_1 tag=4T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:47
channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-17:00:09:39
piece handle=4nr8auka_1_1 tag=4T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:57
channel ORA_SBT_TAPE_4: finished piece 1 at 2016-06-17:00:09:59
piece handle=4qr8auka_1_1 tag=4T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:01:16
channel ORA_SBT_TAPE_6: finished piece 1 at 2016-06-17:00:10:09
piece handle=4sr8aukb_1_1 tag=4T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:01:26
channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-17:00:10:29
piece handle=4pr8auka_1_1 tag=4T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:01:47
channel ORA_SBT_TAPE_5: finished piece 1 at 2016-06-17:00:10:29
piece handle=4rr8aukb_1_1 tag=4T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:01:45
Finished backup at 2016-06-17:00:10:29

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     2016-06-14:12:54:16
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     2016-06-14:12:55:00
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1858946    2016-06-14:12:53:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     2016-06-14:12:55:18
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1858958    2016-06-14:12:53:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     2016-06-14:12:55:44
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1858949    2016-06-14:12:53:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     2016-06-14:12:55:59
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 2016-06-14:12:53:51

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     2016-06-14:12:56:02
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1858955    2016-06-14:12:53:51 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     2016-06-14:12:56:18
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1858952    2016-06-14:12:53:50 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
126     Incr 0  128.00K    SBT_TAPE    00:00:24     2016-06-15:13:02:08
        BP Key: 126   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4fr8735o_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
127     Incr 0  602.69M    SBT_TAPE    00:01:06     2016-06-15:13:02:49
        BP Key: 127   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 49r8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 127
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1860003    2016-06-15:13:01:43 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
128     Incr 0  1.13M      SBT_TAPE    00:01:21     2016-06-15:13:03:04
        BP Key: 128   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4dr8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 128
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1860015    2016-06-15:13:01:44 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
129     Incr 0  14.94M     SBT_TAPE    00:01:26     2016-06-15:13:03:09
        BP Key: 129   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4cr8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 129
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1860012    2016-06-15:13:01:44 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
130     Incr 0  9.63M      SBT_TAPE    00:01:40     2016-06-15:13:03:24
        BP Key: 130   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4er8735o_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1860013      Ckp time: 2016-06-15:13:01:44

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
131     Incr 0  510.00M    SBT_TAPE    00:02:09     2016-06-15:13:03:52
        BP Key: 131   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4ar8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 131
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1860006    2016-06-15:13:01:43 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
132     Incr 0  3.38M      SBT_TAPE    00:02:22     2016-06-15:13:04:05
        BP Key: 132   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4br8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 132
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1860009    2016-06-15:13:01:44 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
133     Incr 0  128.00K    SBT_TAPE    00:00:24     2016-06-17:00:05:15
        BP Key: 133   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4mr8aud3_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
134     Incr 0  603.19M    SBT_TAPE    00:00:54     2016-06-17:00:05:44
        BP Key: 134   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4gr8aud2_1_1   Media: station90-000015
  List of Datafiles in backup set 134
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1900632    2016-06-17:00:04:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
135     Incr 0  14.94M     SBT_TAPE    00:01:09     2016-06-17:00:05:59
        BP Key: 135   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4jr8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 135
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1900584    2016-06-17:00:04:06 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
136     Incr 0  9.63M      SBT_TAPE    00:01:12     2016-06-17:00:06:03
        BP Key: 136   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4lr8aud3_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1900639      Ckp time: 2016-06-17:00:04:50

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
137     Incr 0  1.13M      SBT_TAPE    00:01:27     2016-06-17:00:06:17
        BP Key: 137   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4kr8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 137
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1900641    2016-06-17:00:04:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
138     Incr 0  512.94M    SBT_TAPE    00:02:01     2016-06-17:00:06:51
        BP Key: 138   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4hr8aud2_1_1   Media: station90-000015
  List of Datafiles in backup set 138
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1900635    2016-06-17:00:04:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
139     Incr 0  53.00M     SBT_TAPE    00:02:18     2016-06-17:00:07:08
        BP Key: 139   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4ir8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 139
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1900638    2016-06-17:00:04:50 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
140     Incr 0  512.94M    SBT_TAPE    00:00:45     2016-06-17:00:09:27
        BP Key: 140   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4or8auka_1_1   Media: station90-000016
  List of Datafiles in backup set 140
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1900779    2016-06-17:00:08:42 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
141     Incr 0  603.19M    SBT_TAPE    00:00:56     2016-06-17:00:09:38
        BP Key: 141   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4nr8auka_1_1   Media: station90-000015
  List of Datafiles in backup set 141
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1900776    2016-06-17:00:08:42 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
142     Incr 0  1.13M      SBT_TAPE    00:01:13     2016-06-17:00:09:55
        BP Key: 142   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4qr8auka_1_1   Media: station90-000015
  List of Datafiles in backup set 142
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1900785    2016-06-17:00:08:43 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
143     Incr 0  128.00K    SBT_TAPE    00:01:20     2016-06-17:00:10:03
        BP Key: 143   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4sr8aukb_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
144     Incr 0  53.00M     SBT_TAPE    00:01:39     2016-06-17:00:10:21
        BP Key: 144   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4pr8auka_1_1   Media: station90-000015
  List of Datafiles in backup set 144
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1900782    2016-06-17:00:08:43 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
145     Incr 0  9.63M      SBT_TAPE    00:01:40     2016-06-17:00:10:23
        BP Key: 145   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4rr8aukb_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1900784      Ckp time: 2016-06-17:00:08:43

RMAN> exit


Recovery Manager complete.
[oracle@station90 ~]$ exit
logout
[root@station90 ~]# date
Fri Jun 17 00:15:33 CST 2016
[root@station90 ~]# date -s "Fri Jun 17 23:59:00 CST 2016"
Fri Jun 17 23:59:00 CST 2016
[root@station90 ~]# date
Fri Jun 17 23:59:02 CST 2016
[root@station90 ~]# su - oracle
[oracle@station90 ~]$ rman target /  

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Jun 17 23:59:07 2016

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

connected to target database: ORCL (DBID=1343950367)

RMAN> backup tag '5T_WHOLE_INCR0' incremental level 0  database ;

Starting backup at 2016-06-17:23:59:14
using target database control file instead of recovery catalog
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=201 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=18 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: SID=82 device type=SBT_TAPE
channel ORA_SBT_TAPE_3: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: SID=142 device type=SBT_TAPE
channel ORA_SBT_TAPE_4: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_5
channel ORA_SBT_TAPE_5: SID=202 device type=SBT_TAPE
channel ORA_SBT_TAPE_5: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_6
channel ORA_SBT_TAPE_6: SID=8 device type=SBT_TAPE
channel ORA_SBT_TAPE_6: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_7
channel ORA_SBT_TAPE_7: SID=80 device type=SBT_TAPE
channel ORA_SBT_TAPE_7: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_8
channel ORA_SBT_TAPE_8: SID=144 device type=SBT_TAPE
channel ORA_SBT_TAPE_8: Oracle Secure Backup
skipping datafile 5; already backed up 1 time(s)
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-17:23:59:18
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-17:23:59:18
channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-17:23:59:18
channel ORA_SBT_TAPE_4: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
channel ORA_SBT_TAPE_4: starting piece 1 at 2016-06-17:23:59:18
channel ORA_SBT_TAPE_5: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_5: specifying datafile(s) in backup set
channel ORA_SBT_TAPE_6: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_6: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_SBT_TAPE_6: starting piece 1 at 2016-06-17:23:59:19
including current control file in backup set
channel ORA_SBT_TAPE_5: starting piece 1 at 2016-06-17:23:59:20
channel ORA_SBT_TAPE_5: finished piece 1 at 2016-06-17:23:59:45
piece handle=51r8diem_1_1 tag=5T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_6: finished piece 1 at 2016-06-17:23:59:45
piece handle=52r8dien_1_1 tag=5T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:00:26
channel ORA_SBT_TAPE_4: finished piece 1 at 2016-06-18:00:00:05
piece handle=50r8diem_1_1 tag=5T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:00:47
channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-18:00:00:25
piece handle=4ur8diem_1_1 tag=5T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:07
channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-18:00:00:55
piece handle=4vr8diem_1_1 tag=5T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:01:37
channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-18:00:01:25
piece handle=4tr8diem_1_1 tag=5T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:02:07
Finished backup at 2016-06-18:00:01:25

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     2016-06-14:12:54:16
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     2016-06-14:12:55:00
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1858946    2016-06-14:12:53:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     2016-06-14:12:55:18
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1858958    2016-06-14:12:53:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     2016-06-14:12:55:44
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1858949    2016-06-14:12:53:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     2016-06-14:12:55:59
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 2016-06-14:12:53:51

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     2016-06-14:12:56:02
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1858955    2016-06-14:12:53:51 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     2016-06-14:12:56:18
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1858952    2016-06-14:12:53:50 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
126     Incr 0  128.00K    SBT_TAPE    00:00:24     2016-06-15:13:02:08
        BP Key: 126   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4fr8735o_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
127     Incr 0  602.69M    SBT_TAPE    00:01:06     2016-06-15:13:02:49
        BP Key: 127   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 49r8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 127
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1860003    2016-06-15:13:01:43 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
128     Incr 0  1.13M      SBT_TAPE    00:01:21     2016-06-15:13:03:04
        BP Key: 128   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4dr8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 128
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1860015    2016-06-15:13:01:44 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
129     Incr 0  14.94M     SBT_TAPE    00:01:26     2016-06-15:13:03:09
        BP Key: 129   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4cr8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 129
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1860012    2016-06-15:13:01:44 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
130     Incr 0  9.63M      SBT_TAPE    00:01:40     2016-06-15:13:03:24
        BP Key: 130   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4er8735o_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1860013      Ckp time: 2016-06-15:13:01:44

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
131     Incr 0  510.00M    SBT_TAPE    00:02:09     2016-06-15:13:03:52
        BP Key: 131   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4ar8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 131
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1860006    2016-06-15:13:01:43 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
132     Incr 0  3.38M      SBT_TAPE    00:02:22     2016-06-15:13:04:05
        BP Key: 132   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4br8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 132
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1860009    2016-06-15:13:01:44 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
133     Incr 0  128.00K    SBT_TAPE    00:00:24     2016-06-17:00:05:15
        BP Key: 133   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4mr8aud3_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
134     Incr 0  603.19M    SBT_TAPE    00:00:54     2016-06-17:00:05:44
        BP Key: 134   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4gr8aud2_1_1   Media: station90-000015
  List of Datafiles in backup set 134
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1900632    2016-06-17:00:04:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
135     Incr 0  14.94M     SBT_TAPE    00:01:09     2016-06-17:00:05:59
        BP Key: 135   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4jr8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 135
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1900584    2016-06-17:00:04:06 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
136     Incr 0  9.63M      SBT_TAPE    00:01:12     2016-06-17:00:06:03
        BP Key: 136   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4lr8aud3_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1900639      Ckp time: 2016-06-17:00:04:50

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
137     Incr 0  1.13M      SBT_TAPE    00:01:27     2016-06-17:00:06:17
        BP Key: 137   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4kr8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 137
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1900641    2016-06-17:00:04:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
138     Incr 0  512.94M    SBT_TAPE    00:02:01     2016-06-17:00:06:51
        BP Key: 138   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4hr8aud2_1_1   Media: station90-000015
  List of Datafiles in backup set 138
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1900635    2016-06-17:00:04:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
139     Incr 0  53.00M     SBT_TAPE    00:02:18     2016-06-17:00:07:08
        BP Key: 139   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4ir8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 139
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1900638    2016-06-17:00:04:50 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
140     Incr 0  512.94M    SBT_TAPE    00:00:45     2016-06-17:00:09:27
        BP Key: 140   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4or8auka_1_1   Media: station90-000016
  List of Datafiles in backup set 140
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1900779    2016-06-17:00:08:42 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
141     Incr 0  603.19M    SBT_TAPE    00:00:56     2016-06-17:00:09:38
        BP Key: 141   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4nr8auka_1_1   Media: station90-000015
  List of Datafiles in backup set 141
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1900776    2016-06-17:00:08:42 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
142     Incr 0  1.13M      SBT_TAPE    00:01:13     2016-06-17:00:09:55
        BP Key: 142   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4qr8auka_1_1   Media: station90-000015
  List of Datafiles in backup set 142
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1900785    2016-06-17:00:08:43 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
143     Incr 0  128.00K    SBT_TAPE    00:01:20     2016-06-17:00:10:03
        BP Key: 143   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4sr8aukb_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
144     Incr 0  53.00M     SBT_TAPE    00:01:39     2016-06-17:00:10:21
        BP Key: 144   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4pr8auka_1_1   Media: station90-000015
  List of Datafiles in backup set 144
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1900782    2016-06-17:00:08:43 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
145     Incr 0  9.63M      SBT_TAPE    00:01:40     2016-06-17:00:10:23
        BP Key: 145   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4rr8aukb_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1900784      Ckp time: 2016-06-17:00:08:43

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
146     Incr 0  128.00K    SBT_TAPE    00:00:23     2016-06-17:23:59:42
        BP Key: 146   Status: AVAILABLE  Compressed: NO  Tag: 5T_WHOLE_INCR0
        Handle: 52r8dien_1_1   Media: station90-000015
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
147     Incr 0  9.63M      SBT_TAPE    00:00:26     2016-06-17:23:59:44
        BP Key: 147   Status: AVAILABLE  Compressed: NO  Tag: 5T_WHOLE_INCR0
        Handle: 51r8diem_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1904473      Ckp time: 2016-06-17:23:59:19

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
148     Incr 0  1.13M      SBT_TAPE    00:00:43     2016-06-18:00:00:01
        BP Key: 148   Status: AVAILABLE  Compressed: NO  Tag: 5T_WHOLE_INCR0
        Handle: 50r8diem_1_1   Media: station90-000015
  List of Datafiles in backup set 148
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1904474    2016-06-17:23:59:19 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
149     Incr 0  513.88M    SBT_TAPE    00:01:05     2016-06-18:00:00:23
        BP Key: 149   Status: AVAILABLE  Compressed: NO  Tag: 5T_WHOLE_INCR0
        Handle: 4ur8diem_1_1   Media: station90-000016
  List of Datafiles in backup set 149
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1904431    2016-06-17:23:59:18 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
150     Incr 0  56.06M     SBT_TAPE    00:01:27     2016-06-18:00:00:45
        BP Key: 150   Status: AVAILABLE  Compressed: NO  Tag: 5T_WHOLE_INCR0
        Handle: 4vr8diem_1_1   Media: station90-000016
  List of Datafiles in backup set 150
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1904461    2016-06-17:23:59:19 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
151     Incr 0  603.19M    SBT_TAPE    00:02:05     2016-06-18:00:01:23
        BP Key: 151   Status: AVAILABLE  Compressed: NO  Tag: 5T_WHOLE_INCR0
        Handle: 4tr8diem_1_1   Media: station90-000015
  List of Datafiles in backup set 151
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1904425    2016-06-17:23:59:18 +DATA/orcl/datafile/system.256.914102913

RMAN> backup tag '6T_WHOLE_INCR0' incremental level 0  database ;

Starting backup at 2016-06-18:00:07:28
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_SBT_TAPE_3
using channel ORA_SBT_TAPE_4
using channel ORA_SBT_TAPE_5
using channel ORA_SBT_TAPE_6
using channel ORA_SBT_TAPE_7
using channel ORA_SBT_TAPE_8
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-18:00:07:29
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-18:00:07:29
channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-18:00:07:29
channel ORA_SBT_TAPE_4: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
channel ORA_SBT_TAPE_4: starting piece 1 at 2016-06-18:00:07:29
channel ORA_SBT_TAPE_5: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_5: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
channel ORA_SBT_TAPE_5: starting piece 1 at 2016-06-18:00:07:30
channel ORA_SBT_TAPE_6: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_6: specifying datafile(s) in backup set
channel ORA_SBT_TAPE_7: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_7: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_SBT_TAPE_7: starting piece 1 at 2016-06-18:00:07:30
including current control file in backup set
channel ORA_SBT_TAPE_6: starting piece 1 at 2016-06-18:00:07:31
channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-18:00:08:16
piece handle=54r8diu1_1_1 tag=6T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:47
channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-18:00:08:26
piece handle=53r8diu1_1_1 tag=6T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:57
channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-18:00:08:46
piece handle=55r8diu1_1_1 tag=6T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:01:17
channel ORA_SBT_TAPE_4: finished piece 1 at 2016-06-18:00:08:46
piece handle=56r8diu1_1_1 tag=6T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:01:17
channel ORA_SBT_TAPE_5: finished piece 1 at 2016-06-18:00:09:06
piece handle=57r8diu2_1_1 tag=6T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:01:36
channel ORA_SBT_TAPE_6: finished piece 1 at 2016-06-18:00:09:06
piece handle=58r8diu2_1_1 tag=6T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:01:35
channel ORA_SBT_TAPE_7: finished piece 1 at 2016-06-18:00:09:27
piece handle=59r8diu2_1_1 tag=6T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_7: backup set complete, elapsed time: 00:01:57
Finished backup at 2016-06-18:00:09:27

RMAN>
回复 支持 1 反对 0

使用道具 举报

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
 楼主| 发表于 2016-6-13 10:51:57 | 显示全部楼层
本帖最后由 botang 于 2016-6-13 10:53 编辑
  1. RMAN> report obsolete;

  2. RMAN retention policy will be applied to the command
  3. RMAN retention policy is set to recovery window of 1 days
  4. Report of obsolete backups and copies
  5. Type                 Key    Completion Time    Filename/Handle
  6. -------------------- ------ ------------------ --------------------
  7. Archive Log          194    06-JUN-16          +FRA/orcl/archivelog/2016_06_06/thread_1_seq_27.271.913844171
  8. Backup Set           75     06-JUN-16         
  9.   Backup Piece       75     06-JUN-16          +FRA/orcl/autobackup/2016_06_06/s_913844166.270.913844167
  10. Backup Set           76     06-JUN-16         
  11.   Backup Piece       76     06-JUN-16          2nr7g9uc_1_1
  12. Backup Set           77     06-JUN-16         
  13.   Backup Piece       77     06-JUN-16          c-1343950367-20160606-03
  14. Backup Set           78     07-JUN-16         
  15.   Backup Piece       78     07-JUN-16          +FRA/orcl/backupset/2016_06_07/nnndn1_ora_oem_level_0_0.272.913930533
  16. Backup Set           79     07-JUN-16         
  17.   Backup Piece       79     07-JUN-16          +FRA/orcl/autobackup/2016_06_07/s_913930536.277.913930537
  18. Backup Set           81     07-JUN-16         
  19.   Backup Piece       81     07-JUN-16          c-1343950367-20160607-01
  20. Datafile Copy        27     08-JUN-16          +FRA/orcl/datafile/system.268.913844129
  21. Backup Set           83     08-JUN-16         
  22.   Backup Piece       83     08-JUN-16          +FRA/orcl/autobackup/2016_06_08/s_914016939.280.914016941
  23. Backup Set           85     08-JUN-16         
  24.   Backup Piece       85     08-JUN-16          c-1343950367-20160608-01
  25. Backup Set           87     09-JUN-16         
  26.   Backup Piece       87     09-JUN-16          c-1343950367-20160609-00
  27. Backup Set           89     09-JUN-16         
  28.   Backup Piece       89     09-JUN-16          c-1343950367-20160609-01
  29. Backup Set           90     09-JUN-16         
  30.   Backup Piece       90     09-JUN-16          +FRA/orcl/autobackup/2016_06_09/s_914100616.313.914100617

  31. RMAN> delete obsolete ;

  32. RMAN retention policy will be applied to the command
  33. RMAN retention policy is set to recovery window of 1 days
  34. allocated channel: ORA_DISK_1
  35. channel ORA_DISK_1: SID=130 device type=DISK
  36. allocated channel: ORA_DISK_2
  37. channel ORA_DISK_2: SID=198 device type=DISK
  38. allocated channel: ORA_DISK_3
  39. channel ORA_DISK_3: SID=199 device type=DISK
  40. allocated channel: ORA_DISK_4
  41. channel ORA_DISK_4: SID=13 device type=DISK
  42. allocated channel: ORA_DISK_5
  43. channel ORA_DISK_5: SID=192 device type=DISK
  44. allocated channel: ORA_DISK_6
  45. channel ORA_DISK_6: SID=10 device type=DISK
  46. allocated channel: ORA_DISK_7
  47. channel ORA_DISK_7: SID=75 device type=DISK
  48. allocated channel: ORA_DISK_8
  49. channel ORA_DISK_8: SID=140 device type=DISK
  50. allocated channel: ORA_SBT_TAPE_1
  51. channel ORA_SBT_TAPE_1: SID=193 device type=SBT_TAPE
  52. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  53. allocated channel: ORA_SBT_TAPE_2
  54. channel ORA_SBT_TAPE_2: SID=11 device type=SBT_TAPE
  55. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  56. allocated channel: ORA_SBT_TAPE_3
  57. channel ORA_SBT_TAPE_3: SID=74 device type=SBT_TAPE
  58. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  59. allocated channel: ORA_SBT_TAPE_4
  60. channel ORA_SBT_TAPE_4: SID=141 device type=SBT_TAPE
  61. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  62. allocated channel: ORA_SBT_TAPE_5
  63. channel ORA_SBT_TAPE_5: SID=191 device type=SBT_TAPE
  64. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  65. allocated channel: ORA_SBT_TAPE_6
  66. channel ORA_SBT_TAPE_6: SID=9 device type=SBT_TAPE
  67. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  68. allocated channel: ORA_SBT_TAPE_7
  69. channel ORA_SBT_TAPE_7: SID=71 device type=SBT_TAPE
  70. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  71. allocated channel: ORA_SBT_TAPE_8
  72. channel ORA_SBT_TAPE_8: SID=136 device type=SBT_TAPE
  73. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  74. Deleting the following obsolete backups and copies:
  75. Type                 Key    Completion Time    Filename/Handle
  76. -------------------- ------ ------------------ --------------------
  77. Archive Log          194    06-JUN-16          +FRA/orcl/archivelog/2016_06_06/thread_1_seq_27.271.913844171
  78. Backup Set           75     06-JUN-16         
  79.   Backup Piece       75     06-JUN-16          +FRA/orcl/autobackup/2016_06_06/s_913844166.270.913844167
  80. Backup Set           76     06-JUN-16         
  81.   Backup Piece       76     06-JUN-16          2nr7g9uc_1_1
  82. Backup Set           77     06-JUN-16         
  83.   Backup Piece       77     06-JUN-16          c-1343950367-20160606-03
  84. Backup Set           78     07-JUN-16         
  85.   Backup Piece       78     07-JUN-16          +FRA/orcl/backupset/2016_06_07/nnndn1_ora_oem_level_0_0.272.913930533
  86. Backup Set           79     07-JUN-16         
  87.   Backup Piece       79     07-JUN-16          +FRA/orcl/autobackup/2016_06_07/s_913930536.277.913930537
  88. Backup Set           81     07-JUN-16         
  89.   Backup Piece       81     07-JUN-16          c-1343950367-20160607-01
  90. Datafile Copy        27     08-JUN-16          +FRA/orcl/datafile/system.268.913844129
  91. Backup Set           83     08-JUN-16         
  92.   Backup Piece       83     08-JUN-16          +FRA/orcl/autobackup/2016_06_08/s_914016939.280.914016941
  93. Backup Set           85     08-JUN-16         
  94.   Backup Piece       85     08-JUN-16          c-1343950367-20160608-01
  95. Backup Set           87     09-JUN-16         
  96.   Backup Piece       87     09-JUN-16          c-1343950367-20160609-00
  97. Backup Set           89     09-JUN-16         
  98.   Backup Piece       89     09-JUN-16          c-1343950367-20160609-01
  99. Backup Set           90     09-JUN-16         
  100.   Backup Piece       90     09-JUN-16          +FRA/orcl/autobackup/2016_06_09/s_914100616.313.914100617

  101. Do you really want to delete the above objects (enter YES or NO)? YES
  102. deleted archived log
  103. archived log file name=+FRA/orcl/archivelog/2016_06_06/thread_1_seq_27.271.913844171 RECID=194 STAMP=913844171
  104. deleted backup piece
  105. backup piece handle=+FRA/orcl/autobackup/2016_06_06/s_913844166.270.913844167 RECID=75 STAMP=913844166
  106. deleted backup piece
  107. backup piece handle=+FRA/orcl/backupset/2016_06_07/nnndn1_ora_oem_level_0_0.272.913930533 RECID=78 STAMP=913930533
  108. deleted backup piece
  109. backup piece handle=+FRA/orcl/autobackup/2016_06_07/s_913930536.277.913930537 RECID=79 STAMP=913930537
  110. deleted backup piece
  111. backup piece handle=+FRA/orcl/autobackup/2016_06_08/s_914016939.280.914016941 RECID=83 STAMP=914016939
  112. deleted backup piece
  113. backup piece handle=+FRA/orcl/autobackup/2016_06_09/s_914100616.313.914100617 RECID=90 STAMP=914100616
  114. Deleted 6 objects


  115. RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
  116. RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
  117. RMAN-06210: List of Mismatched objects
  118. RMAN-06211: ==========================
  119. RMAN-06212:   Object Type   Filename/Handle
  120. RMAN-06213: --------------- ---------------------------------------------------
  121. RMAN-06214: Datafile Copy   +FRA/orcl/datafile/system.268.913844129

  122. deleted backup piece
  123. backup piece handle=2nr7g9uc_1_1 RECID=76 STAMP=913844172
  124. deleted backup piece
  125. backup piece handle=c-1343950367-20160606-03 RECID=77 STAMP=913844197
  126. deleted backup piece
  127. backup piece handle=c-1343950367-20160607-01 RECID=81 STAMP=913930569
  128. deleted backup piece
  129. backup piece handle=c-1343950367-20160608-01 RECID=85 STAMP=914016972
  130. deleted backup piece
  131. backup piece handle=c-1343950367-20160609-00 RECID=87 STAMP=914098783
  132. deleted backup piece
  133. backup piece handle=c-1343950367-20160609-01 RECID=89 STAMP=914098916
  134. Deleted 6 objects


  135. RMAN> run {
  136. 2> backup tag '1T_USERS_INCR0'  incremental level 0  tablespace users ;
  137. 3> }

  138. Starting backup at 14-JUN-16
  139. released channel: ORA_DISK_1
  140. released channel: ORA_DISK_2
  141. released channel: ORA_DISK_3
  142. released channel: ORA_DISK_4
  143. released channel: ORA_DISK_5
  144. released channel: ORA_DISK_6
  145. released channel: ORA_DISK_7
  146. released channel: ORA_DISK_8
  147. using channel ORA_SBT_TAPE_1
  148. using channel ORA_SBT_TAPE_2
  149. using channel ORA_SBT_TAPE_3
  150. using channel ORA_SBT_TAPE_4
  151. using channel ORA_SBT_TAPE_5
  152. using channel ORA_SBT_TAPE_6
  153. using channel ORA_SBT_TAPE_7
  154. using channel ORA_SBT_TAPE_8
  155. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  156. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  157. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
  158. channel ORA_SBT_TAPE_1: starting piece 1 at 14-JUN-16
  159. channel ORA_SBT_TAPE_1: finished piece 1 at 14-JUN-16
  160. piece handle=37r84aog_1_1 tag=1T_USERS_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  161. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:50
  162. Finished backup at 14-JUN-16

  163. Starting Control File and SPFILE Autobackup at 14-JUN-16
  164. piece handle=c-1343950367-20160614-00 comment=API Version 2.0,MMS Version 10.3.0.2
  165. Finished Control File and SPFILE Autobackup at 14-JUN-16

  166. RMAN> list backup;


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


  169. BS Key  Size       Device Type Elapsed Time Completion Time
  170. ------- ---------- ----------- ------------ ---------------
  171. 80      16.63M     SBT_TAPE    00:00:24     07-JUN-16      
  172.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213543
  173.         Handle: 2rr7iu9g_1_1   Media: station90-000013

  174.   List of Archived Logs in backup set 80
  175.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  176.   ---- ------- ---------- --------- ---------- ---------
  177.   1    28      1544415    06-JUN-16 1547833    07-JUN-16

  178. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  179. ------- ---- -- ---------- ----------- ------------ ---------------
  180. 82      Incr 1  16.52M     DISK        00:00:03     08-JUN-16      
  181.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  182.         Piece Name: +FRA/orcl/backupset/2016_06_08/nnndn1_ora_oem_level_0_0.279.914016939
  183.   List of Datafiles in backup set 82
  184.   File LV Type Ckp SCN    Ckp Time  Name
  185.   ---- -- ---- ---------- --------- ----
  186.   1    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/system.256.914102913
  187.   2    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553
  188.   3    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553
  189.   5    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/example.265.816169651

  190. BS Key  Size       Device Type Elapsed Time Completion Time
  191. ------- ---------- ----------- ------------ ---------------
  192. 84      9.69M      SBT_TAPE    00:00:23     08-JUN-16      
  193.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213546
  194.         Handle: 2vr7lilj_1_1   Media: station90-000013

  195.   List of Archived Logs in backup set 84
  196.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  197.   ---- ------- ---------- --------- ---------- ---------
  198.   1    29      1547833    07-JUN-16 1551061    08-JUN-16

  199. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  200. ------- ---- -- ---------- ----------- ------------ ---------------
  201. 86      Full    600.75M    SBT_TAPE    00:02:09     09-JUN-16      
  202.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T201727
  203.         Handle: 31r7o2en_1_1   Media: station90-000013
  204.   List of Datafiles in backup set 86
  205.   File LV Type Ckp SCN    Ckp Time  Name
  206.   ---- -- ---- ---------- --------- ----
  207.   1       Full 1577433    09-JUN-16 +DATA/orcl/datafile/system.256.914102913

  208. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  209. ------- ---- -- ---------- ----------- ------------ ---------------
  210. 88      Full    1.06M      SBT_TAPE    00:00:15     09-JUN-16      
  211.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202130
  212.         Handle: 33r7o2ma_1_1   Media: station90-000013
  213.   List of Datafiles in backup set 88
  214.   File LV Type Ckp SCN    Ckp Time  Name
  215.   ---- -- ---- ---------- --------- ----
  216.   4       Full 1577931    09-JUN-16 +DATA/orcl/datafile/users.259.914101365

  217. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  218. ------- ---- -- ---------- ----------- ------------ ---------------
  219. 91      Full    9.61M      DISK        00:00:00     09-JUN-16      
  220.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T211017
  221.         Piece Name: +FRA/orcl/autobackup/2016_06_09/s_914101817.298.914101817
  222.   SPFILE Included: Modification time: 09-JUN-16
  223.   SPFILE db_unique_name: ORCL
  224.   Control File Included: Ckp SCN: 1581203      Ckp time: 09-JUN-16

  225. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  226. ------- ---- -- ---------- ----------- ------------ ---------------
  227. 92      Incr 0  1.13M      SBT_TAPE    00:00:43     14-JUN-16      
  228.         BP Key: 92   Status: AVAILABLE  Compressed: NO  Tag: 1T_USERS_INCR0
  229.         Handle: 37r84aog_1_1   Media: station90-000013
  230.   List of Datafiles in backup set 92
  231.   File LV Type Ckp SCN    Ckp Time  Name
  232.   ---- -- ---- ---------- --------- ----
  233.   4    0  Incr 1835474    14-JUN-16 +DATA/orcl/datafile/users.259.914101365

  234. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  235. ------- ---- -- ---------- ----------- ------------ ---------------
  236. 93      Full    9.63M      SBT_TAPE    00:00:16     14-JUN-16      
  237.         BP Key: 93   Status: AVAILABLE  Compressed: NO  Tag: TAG20160614T115338
  238.         Handle: c-1343950367-20160614-00   Media: station90-000013
  239.   SPFILE Included: Modification time: 14-JUN-16
  240.   SPFILE db_unique_name: ORCL
  241.   Control File Included: Ckp SCN: 1835515      Ckp time: 14-JUN-16

  242. RMAN> show all;

  243. RMAN configuration parameters for database with db_unique_name ORCL are:
  244. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  245. CONFIGURE BACKUP OPTIMIZATION ON;
  246. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  247. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  248. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  249. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  250. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  251. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  252. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  253. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  254. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  255. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  256. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  257. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  258. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  259. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  260. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  261. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  262. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  263. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  264. CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  265. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  266. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  267. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  268. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  269. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  270. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  271. RMAN> CONFIGURE CONTROLFILE AUTOBACKUP
  272. 2>  off;

  273. old RMAN configuration parameters:
  274. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  275. new RMAN configuration parameters:
  276. CONFIGURE CONTROLFILE AUTOBACKUP OFF;
  277. new RMAN configuration parameters are successfully stored

  278. RMAN> list incarnation of database;


  279. List of Database Incarnations
  280. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  281. ------- ------- -------- ---------------- --- ---------- ----------
  282. 1       1       ORCL     1343950367       PARENT  1          15-AUG-09
  283. 2       2       ORCL     1343950367       PARENT  945184     23-MAY-13
  284. 3       3       ORCL     1343950367       PARENT  1068604    27-MAY-16
  285. 4       4       ORCL     1343950367       PARENT  1072117    27-MAY-16
  286. 5       5       ORCL     1343950367       PARENT  1122915    30-MAY-16
  287. 6       6       ORCL     1343950367       PARENT  1123573    30-MAY-16
  288. 7       7       ORCL     1343950367       PARENT  1125477    30-MAY-16
  289. 8       8       ORCL     1343950367       PARENT  1131819    30-MAY-16
  290. 9       9       ORCL     1343950367       PARENT  1218534    01-JUN-16
  291. 10      10      ORCL     1343950367       ORPHAN  1219114    01-JUN-16
  292. 11      11      ORCL     1343950367       PARENT  1219352    01-JUN-16
  293. 12      12      ORCL     1343950367       PARENT  1223810    01-JUN-16
  294. 13      13      ORCL     1343950367       ORPHAN  1265510    01-JUN-16
  295. 14      14      ORCL     1343950367       PARENT  1265510    01-JUN-16
  296. 15      15      ORCL     1343950367       CURRENT 1266539    01-JUN-16

  297. RMAN> run {
  298. 2> reset database to incarnation 14;

  299. RMAN-00571: ===========================================================
  300. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  301. RMAN-00571: ===========================================================
  302. RMAN-00558: error encountered while parsing input commands
  303. RMAN-01009: syntax error: found "reset": expecting one of: "advise, allocate, alter, backup, @, catalog, change, configure, convert, copy, crosscheck, delete, duplicate, execute, flashback, host, mount, open, recover, release, repair, report, restore, resync, send, set, show, shutdown, sql, startup, switch, transport, validate, "
  304. RMAN-01007: at line 2 column 1 file: standard input

  305. RMAN> reset database to incarnation 14;

  306. RMAN-00571: ===========================================================
  307. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  308. RMAN-00571: ===========================================================
  309. RMAN-03009: failure of reset database command on default channel at 06/14/2016 11:56:57
  310. ORA-19910: can not change recovery target incarnation in control file

  311. RMAN> exit


  312. Recovery Manager complete.
  313. [oracle@station90 ~]$ sqlplus /nolog

  314. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 14 11:58:44 2016

  315. Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  316. SQL> conn / as sysdba
  317. Connected.
  318. SQL> startup force
  319. ORACLE instance started.

  320. Total System Global Area 6680915968 bytes
  321. Fixed Size                    2213936 bytes
  322. Variable Size                 3556771792 bytes
  323. Database Buffers         3087007744 bytes
  324. Redo Buffers                   34922496 bytes
  325. Database mounted.
  326. Database opened.
  327. SQL> exit
  328. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  329. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  330. and Real Application Testing options
  331. [oracle@station90 ~]$ rman target /

  332. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 14 11:59:55 2016

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

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

  335. RMAN> backup tag '1T_SYSTEM_INCR0' incremental level 0 tablespace system ;

  336. Starting backup at 14-JUN-16
  337. using target database control file instead of recovery catalog
  338. allocated channel: ORA_SBT_TAPE_1
  339. channel ORA_SBT_TAPE_1: SID=137 device type=SBT_TAPE
  340. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  341. allocated channel: ORA_SBT_TAPE_2
  342. channel ORA_SBT_TAPE_2: SID=197 device type=SBT_TAPE
  343. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  344. allocated channel: ORA_SBT_TAPE_3
  345. channel ORA_SBT_TAPE_3: SID=8 device type=SBT_TAPE
  346. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  347. allocated channel: ORA_SBT_TAPE_4
  348. channel ORA_SBT_TAPE_4: SID=76 device type=SBT_TAPE
  349. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  350. allocated channel: ORA_SBT_TAPE_5
  351. channel ORA_SBT_TAPE_5: SID=135 device type=SBT_TAPE
  352. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  353. allocated channel: ORA_SBT_TAPE_6
  354. channel ORA_SBT_TAPE_6: SID=198 device type=SBT_TAPE
  355. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  356. allocated channel: ORA_SBT_TAPE_7
  357. channel ORA_SBT_TAPE_7: SID=11 device type=SBT_TAPE
  358. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  359. allocated channel: ORA_SBT_TAPE_8
  360. channel ORA_SBT_TAPE_8: SID=77 device type=SBT_TAPE
  361. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  362. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  363. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  364. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  365. channel ORA_SBT_TAPE_1: starting piece 1 at 14-JUN-16
  366. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  367. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  368. channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
  369. channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
  370. including current SPFILE in backup set
  371. channel ORA_SBT_TAPE_3: starting piece 1 at 14-JUN-16
  372. including current control file in backup set
  373. channel ORA_SBT_TAPE_2: starting piece 1 at 14-JUN-16
  374. channel ORA_SBT_TAPE_3: finished piece 1 at 14-JUN-16
  375. piece handle=3br84b92_1_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  376. channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:00:26
  377. channel ORA_SBT_TAPE_1: finished piece 1 at 14-JUN-16
  378. piece handle=39r84b92_1_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  379. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:06
  380. channel ORA_SBT_TAPE_2: finished piece 1 at 14-JUN-16
  381. piece handle=3ar84b92_1_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  382. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:15
  383. Finished backup at 14-JUN-16

  384. RMAN> list backup ;


  385. List of Backup Sets
  386. ===================


  387. BS Key  Size       Device Type Elapsed Time Completion Time
  388. ------- ---------- ----------- ------------ ---------------
  389. 80      16.63M     SBT_TAPE    00:00:24     07-JUN-16      
  390.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213543
  391.         Handle: 2rr7iu9g_1_1   Media: station90-000013

  392.   List of Archived Logs in backup set 80
  393.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  394.   ---- ------- ---------- --------- ---------- ---------
  395.   1    28      1544415    06-JUN-16 1547833    07-JUN-16

  396. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  397. ------- ---- -- ---------- ----------- ------------ ---------------
  398. 82      Incr 1  16.52M     DISK        00:00:03     08-JUN-16      
  399.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  400.         Piece Name: +FRA/orcl/backupset/2016_06_08/nnndn1_ora_oem_level_0_0.279.914016939
  401.   List of Datafiles in backup set 82
  402.   File LV Type Ckp SCN    Ckp Time  Name
  403.   ---- -- ---- ---------- --------- ----
  404.   1    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/system.256.914102913
  405.   2    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553
  406.   3    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553
  407.   5    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/example.265.816169651

  408. BS Key  Size       Device Type Elapsed Time Completion Time
  409. ------- ---------- ----------- ------------ ---------------
  410. 84      9.69M      SBT_TAPE    00:00:23     08-JUN-16      
  411.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213546
  412.         Handle: 2vr7lilj_1_1   Media: station90-000013

  413.   List of Archived Logs in backup set 84
  414.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  415.   ---- ------- ---------- --------- ---------- ---------
  416.   1    29      1547833    07-JUN-16 1551061    08-JUN-16

  417. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  418. ------- ---- -- ---------- ----------- ------------ ---------------
  419. 86      Full    600.75M    SBT_TAPE    00:02:09     09-JUN-16      
  420.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T201727
  421.         Handle: 31r7o2en_1_1   Media: station90-000013
  422.   List of Datafiles in backup set 86
  423.   File LV Type Ckp SCN    Ckp Time  Name
  424.   ---- -- ---- ---------- --------- ----
  425.   1       Full 1577433    09-JUN-16 +DATA/orcl/datafile/system.256.914102913

  426. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  427. ------- ---- -- ---------- ----------- ------------ ---------------
  428. 88      Full    1.06M      SBT_TAPE    00:00:15     09-JUN-16      
  429.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202130
  430.         Handle: 33r7o2ma_1_1   Media: station90-000013
  431.   List of Datafiles in backup set 88
  432.   File LV Type Ckp SCN    Ckp Time  Name
  433.   ---- -- ---- ---------- --------- ----
  434.   4       Full 1577931    09-JUN-16 +DATA/orcl/datafile/users.259.914101365

  435. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  436. ------- ---- -- ---------- ----------- ------------ ---------------
  437. 91      Full    9.61M      DISK        00:00:00     09-JUN-16      
  438.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T211017
  439.         Piece Name: +FRA/orcl/autobackup/2016_06_09/s_914101817.298.914101817
  440.   SPFILE Included: Modification time: 09-JUN-16
  441.   SPFILE db_unique_name: ORCL
  442.   Control File Included: Ckp SCN: 1581203      Ckp time: 09-JUN-16

  443. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  444. ------- ---- -- ---------- ----------- ------------ ---------------
  445. 92      Incr 0  1.13M      SBT_TAPE    00:00:43     14-JUN-16      
  446.         BP Key: 92   Status: AVAILABLE  Compressed: NO  Tag: 1T_USERS_INCR0
  447.         Handle: 37r84aog_1_1   Media: station90-000013
  448.   List of Datafiles in backup set 92
  449.   File LV Type Ckp SCN    Ckp Time  Name
  450.   ---- -- ---- ---------- --------- ----
  451.   4    0  Incr 1835474    14-JUN-16 +DATA/orcl/datafile/users.259.914101365

  452. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  453. ------- ---- -- ---------- ----------- ------------ ---------------
  454. 93      Full    9.63M      SBT_TAPE    00:00:16     14-JUN-16      
  455.         BP Key: 93   Status: AVAILABLE  Compressed: NO  Tag: TAG20160614T115338
  456.         Handle: c-1343950367-20160614-00   Media: station90-000013
  457.   SPFILE Included: Modification time: 14-JUN-16
  458.   SPFILE db_unique_name: ORCL
  459.   Control File Included: Ckp SCN: 1835515      Ckp time: 14-JUN-16

  460. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  461. ------- ---- -- ---------- ----------- ------------ ---------------
  462. 94      Incr 0  128.00K    SBT_TAPE    00:00:24     14-JUN-16      
  463.         BP Key: 94   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
  464.         Handle: 3br84b92_1_1   Media: station90-000013
  465.   SPFILE Included: Modification time: 14-JUN-16
  466.   SPFILE db_unique_name: ORCL

  467. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  468. ------- ---- -- ---------- ----------- ------------ ---------------
  469. 95      Incr 0  602.75M    SBT_TAPE    00:00:58     14-JUN-16      
  470.         BP Key: 95   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
  471.         Handle: 39r84b92_1_1   Media: station90-000014
  472.   List of Datafiles in backup set 95
  473.   File LV Type Ckp SCN    Ckp Time  Name
  474.   ---- -- ---- ---------- --------- ----
  475.   1    0  Incr 1856051    14-JUN-16 +DATA/orcl/datafile/system.256.914102913

  476. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  477. ------- ---- -- ---------- ----------- ------------ ---------------
  478. 96      Incr 0  9.63M      SBT_TAPE    00:01:10     14-JUN-16      
  479.         BP Key: 96   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
  480.         Handle: 3ar84b92_1_1   Media: station90-000013
  481.   Control File Included: Ckp SCN: 1856049      Ckp time: 14-JUN-16


复制代码
回复 支持 反对

使用道具 举报

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
 楼主| 发表于 2016-6-13 10:54:02 | 显示全部楼层
  1. RMAN> run {
  2. 2> allocate channel c1 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  3. 3> allocate channel c2 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  4. 4> allocate channel c3 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  5. 5> allocate channel c4 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  6. 6> allocate channel c5 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  7. 7> allocate channel c6 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  8. 8> allocate channel c7 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  9. 9> allocate channel c8 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  10. 10> backup tag '1T_WHOLE_INCR0' database  plus archivelog delete all input;
  11. 11> release c1;

  12. RMAN-00571: ===========================================================
  13. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  14. RMAN-00571: ===========================================================
  15. RMAN-00558: error encountered while parsing input commands
  16. RMAN-01009: syntax error: found "identifier": expecting one of: "channel"
  17. RMAN-01008: the bad identifier was: c1
  18. RMAN-01007: at line 11 column 9 file: standard input

  19. RMAN> run {
  20. 2> allocate channel c1 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  21. 3> allocate channel c2 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  22. 4> allocate channel c3 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  23. 5> allocate channel c4 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  24. 6> allocate channel c5 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  25. 7> allocate channel c6 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  26. 8> allocate channel c7 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  27. 9> allocate channel c8 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
  28. 10> backup tag '1T_WHOLE_INCR0' database  plus archivelog delete all input;
  29. 11> release channel c1;
  30. 12> release channel c2;
  31. 13> release channel c3;
  32. 14> release channel c4;
  33. 15> release channel c5;
  34. 16> release channel c6;
  35. 17> release channel c7;
  36. 18> release channel c8;
  37. 19> }

  38. released channel: ORA_SBT_TAPE_1
  39. released channel: ORA_SBT_TAPE_2
  40. released channel: ORA_SBT_TAPE_3
  41. released channel: ORA_SBT_TAPE_4
  42. released channel: ORA_SBT_TAPE_5
  43. released channel: ORA_SBT_TAPE_6
  44. released channel: ORA_SBT_TAPE_7
  45. released channel: ORA_SBT_TAPE_8
  46. allocated channel: c1
  47. channel c1: SID=137 device type=DISK

  48. allocated channel: c2
  49. channel c2: SID=197 device type=DISK

  50. allocated channel: c3
  51. channel c3: SID=8 device type=DISK

  52. allocated channel: c4
  53. channel c4: SID=76 device type=DISK

  54. allocated channel: c5
  55. channel c5: SID=135 device type=DISK

  56. allocated channel: c6
  57. channel c6: SID=198 device type=DISK

  58. allocated channel: c7
  59. channel c7: SID=11 device type=DISK

  60. allocated channel: c8
  61. channel c8: SID=77 device type=DISK


  62. Starting backup at 14-JUN-16
  63. current log archived
  64. channel c1: starting archived log backup set
  65. channel c1: specifying archived log(s) in backup set
  66. input archived log thread=1 sequence=28 RECID=195 STAMP=913930543
  67. input archived log thread=1 sequence=29 RECID=196 STAMP=914016946
  68. input archived log thread=1 sequence=30 RECID=197 STAMP=914058005
  69. input archived log thread=1 sequence=31 RECID=198 STAMP=914058288
  70. input archived log thread=1 sequence=32 RECID=199 STAMP=914065255
  71. channel c1: starting piece 1 at 14-JUN-16
  72. channel c2: starting archived log backup set
  73. channel c2: specifying archived log(s) in backup set
  74. input archived log thread=1 sequence=33 RECID=200 STAMP=914094157
  75. input archived log thread=1 sequence=34 RECID=201 STAMP=914097709
  76. input archived log thread=1 sequence=35 RECID=202 STAMP=914098167
  77. input archived log thread=1 sequence=36 RECID=203 STAMP=914100303
  78. input archived log thread=1 sequence=37 RECID=204 STAMP=914100303
  79. input archived log thread=1 sequence=38 RECID=205 STAMP=914100304
  80. channel c2: starting piece 1 at 14-JUN-16
  81. channel c3: starting archived log backup set
  82. channel c3: specifying archived log(s) in backup set
  83. input archived log thread=1 sequence=39 RECID=206 STAMP=914100305
  84. input archived log thread=1 sequence=40 RECID=207 STAMP=914100308
  85. input archived log thread=1 sequence=41 RECID=208 STAMP=914100311
  86. input archived log thread=1 sequence=42 RECID=209 STAMP=914102244
  87. input archived log thread=1 sequence=43 RECID=210 STAMP=914102244
  88. input archived log thread=1 sequence=44 RECID=211 STAMP=914102246
  89. channel c3: starting piece 1 at 14-JUN-16
  90. channel c4: starting archived log backup set
  91. channel c4: specifying archived log(s) in backup set
  92. input archived log thread=1 sequence=45 RECID=212 STAMP=914102248
  93. input archived log thread=1 sequence=46 RECID=213 STAMP=914102249
  94. input archived log thread=1 sequence=47 RECID=214 STAMP=914102252
  95. input archived log thread=1 sequence=48 RECID=215 STAMP=914148051
  96. input archived log thread=1 sequence=49 RECID=216 STAMP=914155256
  97. input archived log thread=1 sequence=50 RECID=217 STAMP=914164282
  98. channel c4: starting piece 1 at 14-JUN-16
  99. channel c5: starting archived log backup set
  100. channel c5: specifying archived log(s) in backup set
  101. input archived log thread=1 sequence=51 RECID=218 STAMP=914173019
  102. input archived log thread=1 sequence=52 RECID=219 STAMP=914180536
  103. input archived log thread=1 sequence=53 RECID=220 STAMP=914188041
  104. input archived log thread=1 sequence=54 RECID=221 STAMP=914191220
  105. channel c5: starting piece 1 at 14-JUN-16
  106. channel c6: starting archived log backup set
  107. channel c6: specifying archived log(s) in backup set
  108. input archived log thread=1 sequence=55 RECID=222 STAMP=914191248
  109. input archived log thread=1 sequence=56 RECID=223 STAMP=914191282
  110. input archived log thread=1 sequence=57 RECID=224 STAMP=914194805
  111. input archived log thread=1 sequence=58 RECID=225 STAMP=914230471
  112. channel c6: starting piece 1 at 14-JUN-16
  113. channel c7: starting archived log backup set
  114. channel c7: specifying archived log(s) in backup set
  115. input archived log thread=1 sequence=59 RECID=226 STAMP=914203593
  116. input archived log thread=1 sequence=60 RECID=227 STAMP=914249580
  117. input archived log thread=1 sequence=61 RECID=228 STAMP=914311234
  118. input archived log thread=1 sequence=62 RECID=229 STAMP=914311363
  119. channel c7: starting piece 1 at 14-JUN-16
  120. channel c8: starting archived log backup set
  121. channel c8: specifying archived log(s) in backup set
  122. input archived log thread=1 sequence=63 RECID=230 STAMP=914326016
  123. input archived log thread=1 sequence=64 RECID=231 STAMP=914335222
  124. input archived log thread=1 sequence=65 RECID=232 STAMP=914374433
  125. input archived log thread=1 sequence=66 RECID=233 STAMP=914403622
  126. input archived log thread=1 sequence=67 RECID=234 STAMP=914462073
  127. channel c8: starting piece 1 at 14-JUN-16
  128. channel c1: finished piece 1 at 14-JUN-16
  129. piece handle=/home/oracle/manual_backup/db_3cr84bpg_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  130. channel c1: backup set complete, elapsed time: 00:00:05
  131. channel c1: deleting archived log(s)
  132. archived log file name=+FRA/orcl/archivelog/2016_06_07/thread_1_seq_28.278.913930543 RECID=195 STAMP=913930543
  133. archived log file name=+FRA/orcl/archivelog/2016_06_08/thread_1_seq_29.281.914016947 RECID=196 STAMP=914016946
  134. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_30.282.914058005 RECID=197 STAMP=914058005
  135. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_31.283.914058287 RECID=198 STAMP=914058288
  136. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_32.284.914065255 RECID=199 STAMP=914065255
  137. channel c1: starting archived log backup set
  138. channel c1: specifying archived log(s) in backup set
  139. input archived log thread=1 sequence=68 RECID=235 STAMP=914462103
  140. input archived log thread=1 sequence=69 RECID=236 STAMP=914463848
  141. input archived log thread=1 sequence=70 RECID=237 STAMP=914480468
  142. input archived log thread=1 sequence=71 RECID=238 STAMP=914500742
  143. input archived log thread=1 sequence=72 RECID=239 STAMP=914501423
  144. channel c1: starting piece 1 at 14-JUN-16
  145. channel c2: finished piece 1 at 14-JUN-16
  146. piece handle=/home/oracle/manual_backup/db_3dr84bpg_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  147. channel c2: backup set complete, elapsed time: 00:00:06
  148. channel c2: deleting archived log(s)
  149. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_33.285.914094157 RECID=200 STAMP=914094157
  150. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_34.286.914097709 RECID=201 STAMP=914097709
  151. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_35.288.914098167 RECID=202 STAMP=914098167
  152. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_36.292.914100303 RECID=203 STAMP=914100303
  153. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_37.289.914100303 RECID=204 STAMP=914100303
  154. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_38.293.914100305 RECID=205 STAMP=914100304
  155. channel c3: finished piece 1 at 14-JUN-16
  156. piece handle=/home/oracle/manual_backup/db_3er84bph_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  157. channel c3: backup set complete, elapsed time: 00:00:07
  158. channel c3: deleting archived log(s)
  159. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_39.290.914100305 RECID=206 STAMP=914100305
  160. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_40.291.914100309 RECID=207 STAMP=914100308
  161. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_41.295.914100311 RECID=208 STAMP=914100311
  162. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_42.301.914102245 RECID=209 STAMP=914102244
  163. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_43.300.914102245 RECID=210 STAMP=914102244
  164. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_44.303.914102245 RECID=211 STAMP=914102246
  165. channel c4: finished piece 1 at 14-JUN-16
  166. piece handle=/home/oracle/manual_backup/db_3fr84bpi_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  167. channel c4: backup set complete, elapsed time: 00:00:06
  168. channel c4: deleting archived log(s)
  169. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_45.305.914102249 RECID=212 STAMP=914102248
  170. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_46.306.914102249 RECID=213 STAMP=914102249
  171. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_47.316.914102253 RECID=214 STAMP=914102252
  172. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_48.268.914148051 RECID=215 STAMP=914148051
  173. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_49.310.914155255 RECID=216 STAMP=914155256
  174. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_50.309.914164281 RECID=217 STAMP=914164282
  175. channel c5: finished piece 1 at 14-JUN-16
  176. piece handle=/home/oracle/manual_backup/db_3gr84bpi_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  177. channel c5: backup set complete, elapsed time: 00:00:07
  178. channel c5: deleting archived log(s)
  179. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_51.311.914173019 RECID=218 STAMP=914173019
  180. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_52.314.914180537 RECID=219 STAMP=914180536
  181. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_53.308.914188041 RECID=220 STAMP=914188041
  182. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_54.341.914191219 RECID=221 STAMP=914191220
  183. channel c6: finished piece 1 at 14-JUN-16
  184. piece handle=/home/oracle/manual_backup/db_3hr84bpj_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  185. channel c6: backup set complete, elapsed time: 00:00:06
  186. channel c6: deleting archived log(s)
  187. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_55.334.914191249 RECID=222 STAMP=914191248
  188. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_56.328.914191283 RECID=223 STAMP=914191282
  189. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_57.318.914194805 RECID=224 STAMP=914194805
  190. archived log file name=+FRA/orcl/archivelog/2016_06_11/thread_1_seq_58.331.914230471 RECID=225 STAMP=914230471
  191. channel c1: finished piece 1 at 14-JUN-16
  192. piece handle=/home/oracle/manual_backup/db_3kr84bpn_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  193. channel c1: backup set complete, elapsed time: 00:00:03
  194. channel c1: deleting archived log(s)
  195. archived log file name=+FRA/orcl/archivelog/2016_06_14/thread_1_seq_68.326.914462103 RECID=235 STAMP=914462103
  196. archived log file name=+FRA/orcl/archivelog/2016_06_14/thread_1_seq_69.332.914463847 RECID=236 STAMP=914463848
  197. archived log file name=+FRA/orcl/archivelog/2016_06_14/thread_1_seq_70.333.914480469 RECID=237 STAMP=914480468
  198. archived log file name=+FRA/orcl/archivelog/2016_06_14/thread_1_seq_71.313.914500743 RECID=238 STAMP=914500742
  199. archived log file name=+FRA/orcl/archivelog/2016_06_14/thread_1_seq_72.280.914501423 RECID=239 STAMP=914501423
  200. channel c7: finished piece 1 at 14-JUN-16
  201. piece handle=/home/oracle/manual_backup/db_3ir84bpk_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  202. channel c7: backup set complete, elapsed time: 00:00:06
  203. channel c7: deleting archived log(s)
  204. archived log file name=+FRA/orcl/archivelog/2016_06_11/thread_1_seq_59.319.914203593 RECID=226 STAMP=914203593
  205. archived log file name=+FRA/orcl/archivelog/2016_06_11/thread_1_seq_60.317.914249581 RECID=227 STAMP=914249580
  206. archived log file name=+FRA/orcl/archivelog/2016_06_12/thread_1_seq_61.320.914311233 RECID=228 STAMP=914311234
  207. archived log file name=+FRA/orcl/archivelog/2016_06_12/thread_1_seq_62.321.914311363 RECID=229 STAMP=914311363
  208. channel c8: finished piece 1 at 14-JUN-16
  209. piece handle=/home/oracle/manual_backup/db_3jr84bpk_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  210. channel c8: backup set complete, elapsed time: 00:00:05
  211. channel c8: deleting archived log(s)
  212. archived log file name=+FRA/orcl/archivelog/2016_06_12/thread_1_seq_63.322.914326017 RECID=230 STAMP=914326016
  213. archived log file name=+FRA/orcl/archivelog/2016_06_12/thread_1_seq_64.323.914335223 RECID=231 STAMP=914335222
  214. archived log file name=+FRA/orcl/archivelog/2016_06_13/thread_1_seq_65.324.914374433 RECID=232 STAMP=914374433
  215. archived log file name=+FRA/orcl/archivelog/2016_06_13/thread_1_seq_66.327.914403623 RECID=233 STAMP=914403622
  216. archived log file name=+FRA/orcl/archivelog/2016_06_14/thread_1_seq_67.325.914462073 RECID=234 STAMP=914462073
  217. Finished backup at 14-JUN-16

  218. Starting backup at 14-JUN-16
  219. channel c1: starting full datafile backup set
  220. channel c1: specifying datafile(s) in backup set
  221. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  222. channel c1: starting piece 1 at 14-JUN-16
  223. channel c2: starting full datafile backup set
  224. channel c2: specifying datafile(s) in backup set
  225. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  226. channel c2: starting piece 1 at 14-JUN-16
  227. channel c3: starting full datafile backup set
  228. channel c3: specifying datafile(s) in backup set
  229. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  230. channel c3: starting piece 1 at 14-JUN-16
  231. channel c4: starting full datafile backup set
  232. channel c4: specifying datafile(s) in backup set
  233. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  234. channel c4: starting piece 1 at 14-JUN-16
  235. channel c5: starting full datafile backup set
  236. channel c5: specifying datafile(s) in backup set
  237. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
  238. channel c5: starting piece 1 at 14-JUN-16
  239. channel c6: starting full datafile backup set
  240. channel c6: specifying datafile(s) in backup set
  241. channel c7: starting full datafile backup set
  242. channel c7: specifying datafile(s) in backup set
  243. including current SPFILE in backup set
  244. channel c7: starting piece 1 at 14-JUN-16
  245. channel c1: finished piece 1 at 14-JUN-16
  246. piece handle=/home/oracle/manual_backup/db_3lr84bps_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  247. channel c1: backup set complete, elapsed time: 00:00:10
  248. including current control file in backup set
  249. channel c6: starting piece 1 at 14-JUN-16
  250. channel c7: finished piece 1 at 14-JUN-16
  251. piece handle=/home/oracle/manual_backup/db_3rr84bpv_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  252. channel c7: backup set complete, elapsed time: 00:00:08
  253. channel c3: finished piece 1 at 14-JUN-16
  254. piece handle=/home/oracle/manual_backup/db_3nr84bps_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  255. channel c3: backup set complete, elapsed time: 00:00:11
  256. channel c2: finished piece 1 at 14-JUN-16
  257. piece handle=/home/oracle/manual_backup/db_3mr84bps_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  258. channel c2: backup set complete, elapsed time: 00:00:14
  259. channel c4: finished piece 1 at 14-JUN-16
  260. piece handle=/home/oracle/manual_backup/db_3or84bps_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  261. channel c4: backup set complete, elapsed time: 00:00:13
  262. channel c5: finished piece 1 at 14-JUN-16
  263. piece handle=/home/oracle/manual_backup/db_3pr84bpu_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  264. channel c5: backup set complete, elapsed time: 00:00:12
  265. channel c6: finished piece 1 at 14-JUN-16
  266. piece handle=/home/oracle/manual_backup/db_3qr84bpu_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  267. channel c6: backup set complete, elapsed time: 00:00:04
  268. Finished backup at 14-JUN-16

  269. Starting backup at 14-JUN-16
  270. current log archived
  271. channel c1: starting archived log backup set
  272. channel c1: specifying archived log(s) in backup set
  273. input archived log thread=1 sequence=73 RECID=240 STAMP=914501450
  274. channel c1: starting piece 1 at 14-JUN-16
  275. channel c1: finished piece 1 at 14-JUN-16
  276. piece handle=/home/oracle/manual_backup/db_3sr84bqb_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
  277. channel c1: backup set complete, elapsed time: 00:00:01
  278. channel c1: deleting archived log(s)
  279. archived log file name=+FRA/orcl/archivelog/2016_06_14/thread_1_seq_73.325.914501451 RECID=240 STAMP=914501450
  280. Finished backup at 14-JUN-16

  281. released channel: c1

  282. released channel: c2

  283. released channel: c3

  284. released channel: c4

  285. released channel: c5

  286. released channel: c6

  287. released channel: c7

  288. released channel: c8

  289. RMAN> list backup;


  290. List of Backup Sets
  291. ===================


  292. BS Key  Size       Device Type Elapsed Time Completion Time
  293. ------- ---------- ----------- ------------ ---------------
  294. 80      16.63M     SBT_TAPE    00:00:24     07-JUN-16      
  295.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213543
  296.         Handle: 2rr7iu9g_1_1   Media: station90-000013

  297.   List of Archived Logs in backup set 80
  298.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  299.   ---- ------- ---------- --------- ---------- ---------
  300.   1    28      1544415    06-JUN-16 1547833    07-JUN-16

  301. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  302. ------- ---- -- ---------- ----------- ------------ ---------------
  303. 82      Incr 1  16.52M     DISK        00:00:03     08-JUN-16      
  304.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  305.         Piece Name: +FRA/orcl/backupset/2016_06_08/nnndn1_ora_oem_level_0_0.279.914016939
  306.   List of Datafiles in backup set 82
  307.   File LV Type Ckp SCN    Ckp Time  Name
  308.   ---- -- ---- ---------- --------- ----
  309.   1    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/system.256.914102913
  310.   2    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553
  311.   3    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553
  312.   5    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/example.265.816169651

  313. BS Key  Size       Device Type Elapsed Time Completion Time
  314. ------- ---------- ----------- ------------ ---------------
  315. 84      9.69M      SBT_TAPE    00:00:23     08-JUN-16      
  316.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213546
  317.         Handle: 2vr7lilj_1_1   Media: station90-000013

  318.   List of Archived Logs in backup set 84
  319.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  320.   ---- ------- ---------- --------- ---------- ---------
  321.   1    29      1547833    07-JUN-16 1551061    08-JUN-16

  322. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  323. ------- ---- -- ---------- ----------- ------------ ---------------
  324. 86      Full    600.75M    SBT_TAPE    00:02:09     09-JUN-16      
  325.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T201727
  326.         Handle: 31r7o2en_1_1   Media: station90-000013
  327.   List of Datafiles in backup set 86
  328.   File LV Type Ckp SCN    Ckp Time  Name
  329.   ---- -- ---- ---------- --------- ----
  330.   1       Full 1577433    09-JUN-16 +DATA/orcl/datafile/system.256.914102913

  331. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  332. ------- ---- -- ---------- ----------- ------------ ---------------
  333. 88      Full    1.06M      SBT_TAPE    00:00:15     09-JUN-16      
  334.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202130
  335.         Handle: 33r7o2ma_1_1   Media: station90-000013
  336.   List of Datafiles in backup set 88
  337.   File LV Type Ckp SCN    Ckp Time  Name
  338.   ---- -- ---- ---------- --------- ----
  339.   4       Full 1577931    09-JUN-16 +DATA/orcl/datafile/users.259.914101365

  340. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  341. ------- ---- -- ---------- ----------- ------------ ---------------
  342. 91      Full    9.61M      DISK        00:00:00     09-JUN-16      
  343.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T211017
  344.         Piece Name: +FRA/orcl/autobackup/2016_06_09/s_914101817.298.914101817
  345.   SPFILE Included: Modification time: 09-JUN-16
  346.   SPFILE db_unique_name: ORCL
  347.   Control File Included: Ckp SCN: 1581203      Ckp time: 09-JUN-16

  348. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  349. ------- ---- -- ---------- ----------- ------------ ---------------
  350. 92      Incr 0  1.13M      SBT_TAPE    00:00:43     14-JUN-16      
  351.         BP Key: 92   Status: AVAILABLE  Compressed: NO  Tag: 1T_USERS_INCR0
  352.         Handle: 37r84aog_1_1   Media: station90-000013
  353.   List of Datafiles in backup set 92
  354.   File LV Type Ckp SCN    Ckp Time  Name
  355.   ---- -- ---- ---------- --------- ----
  356.   4    0  Incr 1835474    14-JUN-16 +DATA/orcl/datafile/users.259.914101365

  357. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  358. ------- ---- -- ---------- ----------- ------------ ---------------
  359. 93      Full    9.63M      SBT_TAPE    00:00:16     14-JUN-16      
  360.         BP Key: 93   Status: AVAILABLE  Compressed: NO  Tag: TAG20160614T115338
  361.         Handle: c-1343950367-20160614-00   Media: station90-000013
  362.   SPFILE Included: Modification time: 14-JUN-16
  363.   SPFILE db_unique_name: ORCL
  364.   Control File Included: Ckp SCN: 1835515      Ckp time: 14-JUN-16

  365. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  366. ------- ---- -- ---------- ----------- ------------ ---------------
  367. 94      Incr 0  128.00K    SBT_TAPE    00:00:24     14-JUN-16      
  368.         BP Key: 94   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
  369.         Handle: 3br84b92_1_1   Media: station90-000013
  370.   SPFILE Included: Modification time: 14-JUN-16
  371.   SPFILE db_unique_name: ORCL

  372. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  373. ------- ---- -- ---------- ----------- ------------ ---------------
  374. 95      Incr 0  602.75M    SBT_TAPE    00:00:58     14-JUN-16      
  375.         BP Key: 95   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
  376.         Handle: 39r84b92_1_1   Media: station90-000014
  377.   List of Datafiles in backup set 95
  378.   File LV Type Ckp SCN    Ckp Time  Name
  379.   ---- -- ---- ---------- --------- ----
  380.   1    0  Incr 1856051    14-JUN-16 +DATA/orcl/datafile/system.256.914102913

  381. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  382. ------- ---- -- ---------- ----------- ------------ ---------------
  383. 96      Incr 0  9.63M      SBT_TAPE    00:01:10     14-JUN-16      
  384.         BP Key: 96   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
  385.         Handle: 3ar84b92_1_1   Media: station90-000013
  386.   Control File Included: Ckp SCN: 1856049      Ckp time: 14-JUN-16

  387. BS Key  Size       Device Type Elapsed Time Completion Time
  388. ------- ---------- ----------- ------------ ---------------
  389. 97      83.06M     DISK        00:00:01     14-JUN-16      
  390.         BP Key: 97   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  391.         Piece Name: /home/oracle/manual_backup/db_3cr84bpg_1_1.bkp

  392.   List of Archived Logs in backup set 97
  393.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  394.   ---- ------- ---------- --------- ---------- ---------
  395.   1    28      1544415    06-JUN-16 1547833    07-JUN-16
  396.   1    29      1547833    07-JUN-16 1551061    08-JUN-16
  397.   1    30      1551061    08-JUN-16 1556025    09-JUN-16
  398.   1    31      1556025    09-JUN-16 1558620    09-JUN-16
  399.   1    32      1558620    09-JUN-16 1566664    09-JUN-16

  400. BS Key  Size       Device Type Elapsed Time Completion Time
  401. ------- ---------- ----------- ------------ ---------------
  402. 98      34.57M     DISK        00:00:01     14-JUN-16      
  403.         BP Key: 98   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  404.         Piece Name: /home/oracle/manual_backup/db_3dr84bpg_1_1.bkp

  405.   List of Archived Logs in backup set 98
  406.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  407.   ---- ------- ---------- --------- ---------- ---------
  408.   1    33      1566664    09-JUN-16 1571637    09-JUN-16
  409.   1    34      1571637    09-JUN-16 1576311    09-JUN-16
  410.   1    35      1576311    09-JUN-16 1576732    09-JUN-16
  411.   1    36      1576732    09-JUN-16 1579324    09-JUN-16
  412.   1    37      1579324    09-JUN-16 1579341    09-JUN-16
  413.   1    38      1579341    09-JUN-16 1579347    09-JUN-16

  414. BS Key  Size       Device Type Elapsed Time Completion Time
  415. ------- ---------- ----------- ------------ ---------------
  416. 99      4.40M      DISK        00:00:01     14-JUN-16      
  417.         BP Key: 99   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  418.         Piece Name: /home/oracle/manual_backup/db_3er84bph_1_1.bkp

  419.   List of Archived Logs in backup set 99
  420.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  421.   ---- ------- ---------- --------- ---------- ---------
  422.   1    39      1579347    09-JUN-16 1579350    09-JUN-16
  423.   1    40      1579350    09-JUN-16 1579357    09-JUN-16
  424.   1    41      1579357    09-JUN-16 1579362    09-JUN-16
  425.   1    42      1579362    09-JUN-16 1581794    09-JUN-16
  426.   1    43      1581794    09-JUN-16 1581798    09-JUN-16
  427.   1    44      1581798    09-JUN-16 1581804    09-JUN-16

  428. BS Key  Size       Device Type Elapsed Time Completion Time
  429. ------- ---------- ----------- ------------ ---------------
  430. 100     47.54M     DISK        00:00:00     14-JUN-16      
  431.         BP Key: 100   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  432.         Piece Name: /home/oracle/manual_backup/db_3fr84bpi_1_1.bkp

  433.   List of Archived Logs in backup set 100
  434.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  435.   ---- ------- ---------- --------- ---------- ---------
  436.   1    45      1581804    09-JUN-16 1581821    09-JUN-16
  437.   1    46      1581821    09-JUN-16 1581828    09-JUN-16
  438.   1    47      1581828    09-JUN-16 1581834    09-JUN-16
  439.   1    48      1581834    09-JUN-16 1589624    10-JUN-16
  440.   1    49      1589624    10-JUN-16 1597330    10-JUN-16
  441.   1    50      1597330    10-JUN-16 1606215    10-JUN-16

  442. BS Key  Size       Device Type Elapsed Time Completion Time
  443. ------- ---------- ----------- ------------ ---------------
  444. 101     81.24M     DISK        00:00:02     14-JUN-16      
  445.         BP Key: 101   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  446.         Piece Name: /home/oracle/manual_backup/db_3gr84bpi_1_1.bkp

  447.   List of Archived Logs in backup set 101
  448.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  449.   ---- ------- ---------- --------- ---------- ---------
  450.   1    51      1606215    10-JUN-16 1614895    10-JUN-16
  451.   1    52      1614895    10-JUN-16 1621126    10-JUN-16
  452.   1    53      1621126    10-JUN-16 1629156    10-JUN-16
  453.   1    54      1629156    10-JUN-16 1640810    10-JUN-16

  454. BS Key  Size       Device Type Elapsed Time Completion Time
  455. ------- ---------- ----------- ------------ ---------------
  456. 102     75.37M     DISK        00:00:01     14-JUN-16      
  457.         BP Key: 102   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  458.         Piece Name: /home/oracle/manual_backup/db_3hr84bpj_1_1.bkp

  459.   List of Archived Logs in backup set 102
  460.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  461.   ---- ------- ---------- --------- ---------- ---------
  462.   1    55      1640810    10-JUN-16 1643713    10-JUN-16
  463.   1    56      1643713    10-JUN-16 1647766    10-JUN-16
  464.   1    57      1647766    10-JUN-16 1652920    10-JUN-16
  465.   1    58      1652920    10-JUN-16 1658842    11-JUN-16

  466. BS Key  Size       Device Type Elapsed Time Completion Time
  467. ------- ---------- ----------- ------------ ---------------
  468. 103     71.79M     DISK        00:00:01     14-JUN-16      
  469.         BP Key: 103   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  470.         Piece Name: /home/oracle/manual_backup/db_3ir84bpk_1_1.bkp

  471.   List of Archived Logs in backup set 103
  472.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  473.   ---- ------- ---------- --------- ---------- ---------
  474.   1    59      1658842    11-JUN-16 1681438    11-JUN-16
  475.   1    60      1681438    11-JUN-16 1698387    11-JUN-16
  476.   1    61      1698387    11-JUN-16 1712256    12-JUN-16
  477.   1    62      1712256    12-JUN-16 1717419    12-JUN-16

  478. BS Key  Size       Device Type Elapsed Time Completion Time
  479. ------- ---------- ----------- ------------ ---------------
  480. 104     84.13M     DISK        00:00:02     14-JUN-16      
  481.         BP Key: 104   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  482.         Piece Name: /home/oracle/manual_backup/db_3jr84bpk_1_1.bkp

  483.   List of Archived Logs in backup set 104
  484.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  485.   ---- ------- ---------- --------- ---------- ---------
  486.   1    63      1717419    12-JUN-16 1728637    12-JUN-16
  487.   1    64      1728637    12-JUN-16 1734560    12-JUN-16
  488.   1    65      1734560    12-JUN-16 1761707    13-JUN-16
  489.   1    66      1761707    13-JUN-16 1776507    13-JUN-16
  490.   1    67      1776507    13-JUN-16 1792700    14-JUN-16

  491. BS Key  Size       Device Type Elapsed Time Completion Time
  492. ------- ---------- ----------- ------------ ---------------
  493. 105     61.08M     DISK        00:00:00     14-JUN-16      
  494.         BP Key: 105   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  495.         Piece Name: /home/oracle/manual_backup/db_3kr84bpn_1_1.bkp

  496.   List of Archived Logs in backup set 105
  497.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  498.   ---- ------- ---------- --------- ---------- ---------
  499.   1    68      1792700    14-JUN-16 1795688    14-JUN-16
  500.   1    69      1795688    14-JUN-16 1800404    14-JUN-16
  501.   1    70      1800404    14-JUN-16 1827856    14-JUN-16
  502.   1    71      1827856    14-JUN-16 1855748    14-JUN-16
  503.   1    72      1855748    14-JUN-16 1856632    14-JUN-16

  504. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  505. ------- ---- -- ---------- ----------- ------------ ---------------
  506. 106     Full    602.71M    DISK        00:00:07     14-JUN-16      
  507.         BP Key: 106   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  508.         Piece Name: /home/oracle/manual_backup/db_3lr84bps_1_1.bkp
  509.   List of Datafiles in backup set 106
  510.   File LV Type Ckp SCN    Ckp Time  Name
  511.   ---- -- ---- ---------- --------- ----
  512.   1       Full 1856660    14-JUN-16 +DATA/orcl/datafile/system.256.914102913

  513. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  514. ------- ---- -- ---------- ----------- ------------ ---------------
  515. 107     Full    80.00K     DISK        00:00:04     14-JUN-16      
  516.         BP Key: 107   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  517.         Piece Name: /home/oracle/manual_backup/db_3rr84bpv_1_1.bkp
  518.   SPFILE Included: Modification time: 14-JUN-16
  519.   SPFILE db_unique_name: ORCL

  520. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  521. ------- ---- -- ---------- ----------- ------------ ---------------
  522. 108     Full    4.41M      DISK        00:00:08     14-JUN-16      
  523.         BP Key: 108   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  524.         Piece Name: /home/oracle/manual_backup/db_3nr84bps_1_1.bkp
  525.   List of Datafiles in backup set 108
  526.   File LV Type Ckp SCN    Ckp Time  Name
  527.   ---- -- ---- ---------- --------- ----
  528.   3       Full 1856664    14-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553

  529. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  530. ------- ---- -- ---------- ----------- ------------ ---------------
  531. 109     Full    1.10M      DISK        00:00:10     14-JUN-16      
  532.         BP Key: 109   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  533.         Piece Name: /home/oracle/manual_backup/db_3pr84bpu_1_1.bkp
  534.   List of Datafiles in backup set 109
  535.   File LV Type Ckp SCN    Ckp Time  Name
  536.   ---- -- ---- ---------- --------- ----
  537.   4       Full 1856668    14-JUN-16 +DATA/orcl/datafile/users.259.914101365

  538. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  539. ------- ---- -- ---------- ----------- ------------ ---------------
  540. 110     Full    509.99M    DISK        00:00:12     14-JUN-16      
  541.         BP Key: 110   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  542.         Piece Name: /home/oracle/manual_backup/db_3mr84bps_1_1.bkp
  543.   List of Datafiles in backup set 110
  544.   File LV Type Ckp SCN    Ckp Time  Name
  545.   ---- -- ---- ---------- --------- ----
  546.   2       Full 1856662    14-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553

  547. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  548. ------- ---- -- ---------- ----------- ------------ ---------------
  549. 111     Full    14.94M     DISK        00:00:12     14-JUN-16      
  550.         BP Key: 111   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  551.         Piece Name: /home/oracle/manual_backup/db_3or84bps_1_1.bkp
  552.   List of Datafiles in backup set 111
  553.   File LV Type Ckp SCN    Ckp Time  Name
  554.   ---- -- ---- ---------- --------- ----
  555.   5       Full 1856669    14-JUN-16 +DATA/orcl/datafile/example.265.816169651

  556. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  557. ------- ---- -- ---------- ----------- ------------ ---------------
  558. 112     Full    9.58M      DISK        00:00:10     14-JUN-16      
  559.         BP Key: 112   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  560.         Piece Name: /home/oracle/manual_backup/db_3qr84bpu_1_1.bkp
  561.   Control File Included: Ckp SCN: 1856666      Ckp time: 14-JUN-16

  562. BS Key  Size       Device Type Elapsed Time Completion Time
  563. ------- ---------- ----------- ------------ ---------------
  564. 113     10.50K     DISK        00:00:00     14-JUN-16      
  565.         BP Key: 113   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  566.         Piece Name: /home/oracle/manual_backup/db_3sr84bqb_1_1.bkp

  567.   List of Archived Logs in backup set 113
  568.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  569.   ---- ------- ---------- --------- ---------- ---------
  570.   1    73      1856632    14-JUN-16 1856677    14-JUN-16

  571. RMAN> exit


  572. Recovery Manager complete.
  573. [oracle@station90 ~]$ ls
  574. 3_2014-05-21-1.sql       mail            rcat.sql                 tnsnames.ora              公共的  文档
  575. afiedt.buf               manual_backup   revertape-root.sh        ttio.rcv                  模板    下载
  576. copytape-root.sh         oradiag_oracle  select_t04209_uname.sql  update2_t04209_uname.sql  视频    音乐
  577. create_t04209_uname.sql  rac_tns         t05310.sql               update_t04209_uname.sql   图片    桌面
  578. [oracle@station90 ~]$ mkdir archivelog
  579. [oracle@station90 ~]$ cd archivelog/
  580. [oracle@station90 archivelog]$ ls
  581. [oracle@station90 archivelog]$ sqlplus /nolog

  582. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 14 12:23:57 2016

  583. Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  584. SQL> conn /as sysdba
  585. Connected.
  586. SQL> show parameter archive_LOG
  587. SQL> show parameter log_archive

  588. NAME                                     TYPE         VALUE
  589. ------------------------------------ ----------- ------------------------------
  590. log_archive_config                     string
  591. log_archive_dest                     string
  592. log_archive_dest_1                     string
  593. log_archive_dest_10                     string
  594. log_archive_dest_11                     string
  595. log_archive_dest_12                     string
  596. log_archive_dest_13                     string
  597. log_archive_dest_14                     string
  598. log_archive_dest_15                     string
  599. log_archive_dest_16                     string
  600. log_archive_dest_17                     string

  601. NAME                                     TYPE         VALUE
  602. ------------------------------------ ----------- ------------------------------
  603. log_archive_dest_18                     string
  604. log_archive_dest_19                     string
  605. log_archive_dest_2                     string
  606. log_archive_dest_20                     string
  607. log_archive_dest_21                     string
  608. log_archive_dest_22                     string
  609. log_archive_dest_23                     string
  610. log_archive_dest_24                     string
  611. log_archive_dest_25                     string
  612. log_archive_dest_26                     string
  613. log_archive_dest_27                     string

  614. NAME                                     TYPE         VALUE
  615. ------------------------------------ ----------- ------------------------------
  616. log_archive_dest_28                     string
  617. log_archive_dest_29                     string
  618. log_archive_dest_3                     string
  619. log_archive_dest_30                     string
  620. log_archive_dest_31                     string
  621. log_archive_dest_4                     string
  622. log_archive_dest_5                     string
  623. log_archive_dest_6                     string
  624. log_archive_dest_7                     string
  625. log_archive_dest_8                     string
  626. log_archive_dest_9                     string

  627. NAME                                     TYPE         VALUE
  628. ------------------------------------ ----------- ------------------------------
  629. log_archive_dest_state_1             string         enable
  630. log_archive_dest_state_10             string         enable
  631. log_archive_dest_state_11             string         enable
  632. log_archive_dest_state_12             string         enable
  633. log_archive_dest_state_13             string         enable
  634. log_archive_dest_state_14             string         enable
  635. log_archive_dest_state_15             string         enable
  636. log_archive_dest_state_16             string         enable
  637. log_archive_dest_state_17             string         enable
  638. log_archive_dest_state_18             string         enable
  639. log_archive_dest_state_19             string         enable

  640. NAME                                     TYPE         VALUE
  641. ------------------------------------ ----------- ------------------------------
  642. log_archive_dest_state_2             string         enable
  643. log_archive_dest_state_20             string         enable
  644. log_archive_dest_state_21             string         enable
  645. log_archive_dest_state_22             string         enable
  646. log_archive_dest_state_23             string         enable
  647. log_archive_dest_state_24             string         enable
  648. log_archive_dest_state_25             string         enable
  649. log_archive_dest_state_26             string         enable
  650. log_archive_dest_state_27             string         enable
  651. log_archive_dest_state_28             string         enable
  652. log_archive_dest_state_29             string         enable

  653. NAME                                     TYPE         VALUE
  654. ------------------------------------ ----------- ------------------------------
  655. log_archive_dest_state_3             string         enable
  656. log_archive_dest_state_30             string         enable
  657. log_archive_dest_state_31             string         enable
  658. log_archive_dest_state_4             string         enable
  659. log_archive_dest_state_5             string         enable
  660. log_archive_dest_state_6             string         enable
  661. log_archive_dest_state_7             string         enable
  662. log_archive_dest_state_8             string         enable
  663. log_archive_dest_state_9             string         enable
  664. log_archive_duplex_dest              string
  665. log_archive_format                     string         %t_%s_%r.dbf

  666. NAME                                     TYPE         VALUE
  667. ------------------------------------ ----------- ------------------------------
  668. log_archive_local_first              boolean         TRUE
  669. log_archive_max_processes             integer         4
  670. log_archive_min_succeed_dest             integer         1
  671. log_archive_start                     boolean         FALSE
  672. log_archive_trace                     integer         0
  673. SQL> alter system set log_archive_dest_1='location=use_db_recovery_file_dest';

  674. System altered.

  675. SQL> alter system set log_archive_dest_2='location=/home/oracle/archivelog';

  676. System altered.

  677. SQL> alter system switch logfile;

  678. System altered.

  679. SQL> alter system switch logfile;

  680. System altered.

  681. SQL> exit
  682. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  683. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  684. and Real Application Testing options
  685. [oracle@station90 archivelog]$ cd
  686. [oracle@station90 ~]$ . oraenv
  687. ORACLE_SID = [orcl] ? +ASM
  688. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
  689. [oracle@station90 ~]$ asmcmd
  690. ASMCMD> ls
  691. DATA/
  692. FRA/
  693. ASMCMD> cd FRA/
  694. ASMCMD> ls
  695. ORCL/
  696. ASMCMD> cd ORCL/
  697. ASMCMD> ls
  698. AUTOBACKUP/
  699. BACKUPSET/
  700. CHANGETRACKING/
  701. CONTROLFILE/
  702. DATAFILE/
  703. ONLINELOG/
  704. ASMCMD> exit
  705. [oracle@station90 ~]$ cd /home
  706. [oracle@station90 home]$ ls
  707. guests  oracle  oradev  orawb  vncviewer  vtl
  708. [oracle@station90 home]$ cd oracle
  709. [oracle@station90 ~]$ ls
  710. 3_2014-05-21-1.sql       mail            revertape-root.sh        update2_t04209_uname.sql  图片
  711. afiedt.buf               manual_backup   select_t04209_uname.sql  update_t04209_uname.sql   文档
  712. archivelog               oradiag_oracle  t05310.sql               公共的                    下载
  713. copytape-root.sh         rac_tns         tnsnames.ora             模板                      音乐
  714. create_t04209_uname.sql  rcat.sql        ttio.rcv                 视频                      桌面
  715. [oracle@station90 ~]$ cd archivelog/
  716. [oracle@station90 archivelog]$ l
  717. -bash: l: command not found
  718. [oracle@station90 archivelog]$ ls
  719. 1_74_913410354.dbf  1_75_913410354.dbf  1_76_913410354.dbf
  720. [oracle@station90 archivelog]$ sqlplus /nolog

  721. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 14 12:48:48 2016

  722. Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  723. SQL> conn / as sysdba
  724. Connected.
  725. SQL> alter system switch logfile ;
  726. alter system switch logfile
  727. *
  728. ERROR at line 1:
  729. ORA-01109: database not open


  730. SQL> exit
  731. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  732. With the Automatic Storage Management option
  733. [oracle@station90 archivelog]$ . oraenv
  734. ORACLE_SID = [+ASM] ? orcl
  735. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
  736. [oracle@station90 archivelog]$ sqlplus /nolog

  737. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 14 12:49:08 2016

  738. Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  739. SQL> conn / as sysdba
  740. Connected.
  741. SQL> alter system switch logfile;

  742. System altered.

  743. SQL> exit
  744. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  745. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  746. and Real Application Testing options
  747. [oracle@station90 archivelog]$ ls
  748. [oracle@station90 archivelog]$ pwd
  749. /home/oracle/archivelog

复制代码
回复 支持 反对

使用道具 举报

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
 楼主| 发表于 2016-6-13 10:56:14 | 显示全部楼层
本帖最后由 botang 于 2016-6-13 10:57 编辑
  1. [oracle@station90 archivelog]$ rman target /

  2. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 14 12:51:05 2016

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

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

  5. RMAN> delete noprompt backup;

  6. using target database control file instead of recovery catalog
  7. allocated channel: ORA_DISK_1
  8. channel ORA_DISK_1: SID=8 device type=DISK
  9. allocated channel: ORA_DISK_2
  10. channel ORA_DISK_2: SID=79 device type=DISK
  11. allocated channel: ORA_DISK_3
  12. channel ORA_DISK_3: SID=140 device type=DISK
  13. allocated channel: ORA_DISK_4
  14. channel ORA_DISK_4: SID=196 device type=DISK
  15. allocated channel: ORA_DISK_5
  16. channel ORA_DISK_5: SID=15 device type=DISK
  17. allocated channel: ORA_DISK_6
  18. channel ORA_DISK_6: SID=78 device type=DISK
  19. allocated channel: ORA_DISK_7
  20. channel ORA_DISK_7: SID=141 device type=DISK
  21. allocated channel: ORA_DISK_8
  22. channel ORA_DISK_8: SID=201 device type=DISK
  23. allocated channel: ORA_SBT_TAPE_1
  24. channel ORA_SBT_TAPE_1: SID=16 device type=SBT_TAPE
  25. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  26. allocated channel: ORA_SBT_TAPE_2
  27. channel ORA_SBT_TAPE_2: SID=80 device type=SBT_TAPE
  28. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  29. allocated channel: ORA_SBT_TAPE_3
  30. channel ORA_SBT_TAPE_3: SID=142 device type=SBT_TAPE
  31. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  32. allocated channel: ORA_SBT_TAPE_4
  33. channel ORA_SBT_TAPE_4: SID=202 device type=SBT_TAPE
  34. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  35. allocated channel: ORA_SBT_TAPE_5
  36. channel ORA_SBT_TAPE_5: SID=17 device type=SBT_TAPE
  37. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  38. allocated channel: ORA_SBT_TAPE_6
  39. channel ORA_SBT_TAPE_6: SID=81 device type=SBT_TAPE
  40. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  41. allocated channel: ORA_SBT_TAPE_7
  42. channel ORA_SBT_TAPE_7: SID=143 device type=SBT_TAPE
  43. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  44. allocated channel: ORA_SBT_TAPE_8
  45. channel ORA_SBT_TAPE_8: SID=203 device type=SBT_TAPE
  46. channel ORA_SBT_TAPE_8: Oracle Secure Backup

  47. List of Backup Pieces
  48. BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
  49. ------- ------- --- --- ----------- ----------- ----------
  50. 80      80      1   1   AVAILABLE   SBT_TAPE    2rr7iu9g_1_1
  51. 82      82      1   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_08/nnndn1_ora_oem_level_0_0.279.914016939
  52. 84      84      1   1   AVAILABLE   SBT_TAPE    2vr7lilj_1_1
  53. 86      86      1   1   AVAILABLE   SBT_TAPE    31r7o2en_1_1
  54. 88      88      1   1   AVAILABLE   SBT_TAPE    33r7o2ma_1_1
  55. 91      91      1   1   AVAILABLE   DISK        +FRA/orcl/autobackup/2016_06_09/s_914101817.298.914101817
  56. 92      92      1   1   AVAILABLE   SBT_TAPE    37r84aog_1_1
  57. 93      93      1   1   AVAILABLE   SBT_TAPE    c-1343950367-20160614-00
  58. 94      94      1   1   AVAILABLE   SBT_TAPE    3br84b92_1_1
  59. 95      95      1   1   AVAILABLE   SBT_TAPE    39r84b92_1_1
  60. 96      96      1   1   AVAILABLE   SBT_TAPE    3ar84b92_1_1
  61. 97      97      1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3cr84bpg_1_1.bkp
  62. 98      98      1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3dr84bpg_1_1.bkp
  63. 99      99      1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3er84bph_1_1.bkp
  64. 100     100     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3fr84bpi_1_1.bkp
  65. 101     101     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3gr84bpi_1_1.bkp
  66. 102     102     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3hr84bpj_1_1.bkp
  67. 103     103     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3ir84bpk_1_1.bkp
  68. 104     104     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3jr84bpk_1_1.bkp
  69. 105     105     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3kr84bpn_1_1.bkp
  70. 106     106     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3lr84bps_1_1.bkp
  71. 107     107     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3rr84bpv_1_1.bkp
  72. 108     108     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3nr84bps_1_1.bkp
  73. 109     109     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3pr84bpu_1_1.bkp
  74. 110     110     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3mr84bps_1_1.bkp
  75. 111     111     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3or84bps_1_1.bkp
  76. 112     112     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3qr84bpu_1_1.bkp
  77. 113     113     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3sr84bqb_1_1.bkp
  78. 114     114     1   1   AVAILABLE   SBT_TAPE    3tr84dsd_1_1
  79. 115     115     1   1   AVAILABLE   SBT_TAPE    3ur84dsd_1_1
  80. 116     116     1   1   AVAILABLE   SBT_TAPE    3vr84dsd_1_1
  81. 117     117     1   1   AVAILABLE   SBT_TAPE    41r84e3b_1_1
  82. 118     118     1   1   AVAILABLE   SBT_TAPE    40r84e3b_1_1
  83. deleted backup piece
  84. backup piece handle=+FRA/orcl/backupset/2016_06_08/nnndn1_ora_oem_level_0_0.279.914016939 RECID=82 STAMP=914016938
  85. deleted backup piece
  86. backup piece handle=+FRA/orcl/autobackup/2016_06_09/s_914101817.298.914101817 RECID=91 STAMP=914101817
  87. deleted backup piece
  88. backup piece handle=/home/oracle/manual_backup/db_3cr84bpg_1_1.bkp RECID=97 STAMP=914501424
  89. deleted backup piece
  90. backup piece handle=/home/oracle/manual_backup/db_3dr84bpg_1_1.bkp RECID=98 STAMP=914501425
  91. deleted backup piece
  92. backup piece handle=/home/oracle/manual_backup/db_3er84bph_1_1.bkp RECID=99 STAMP=914501426
  93. deleted backup piece
  94. backup piece handle=/home/oracle/manual_backup/db_3fr84bpi_1_1.bkp RECID=100 STAMP=914501426
  95. deleted backup piece
  96. backup piece handle=/home/oracle/manual_backup/db_3gr84bpi_1_1.bkp RECID=101 STAMP=914501427
  97. deleted backup piece
  98. backup piece handle=/home/oracle/manual_backup/db_3hr84bpj_1_1.bkp RECID=102 STAMP=914501427
  99. deleted backup piece
  100. backup piece handle=/home/oracle/manual_backup/db_3ir84bpk_1_1.bkp RECID=103 STAMP=914501428
  101. deleted backup piece
  102. backup piece handle=/home/oracle/manual_backup/db_3jr84bpk_1_1.bkp RECID=104 STAMP=914501429
  103. deleted backup piece
  104. backup piece handle=/home/oracle/manual_backup/db_3kr84bpn_1_1.bkp RECID=105 STAMP=914501431
  105. deleted backup piece
  106. backup piece handle=/home/oracle/manual_backup/db_3lr84bps_1_1.bkp RECID=106 STAMP=914501436
  107. deleted backup piece
  108. backup piece handle=/home/oracle/manual_backup/db_3rr84bpv_1_1.bkp RECID=107 STAMP=914501440
  109. deleted backup piece
  110. backup piece handle=/home/oracle/manual_backup/db_3nr84bps_1_1.bkp RECID=108 STAMP=914501443
  111. deleted backup piece
  112. backup piece handle=/home/oracle/manual_backup/db_3pr84bpu_1_1.bkp RECID=109 STAMP=914501443
  113. deleted backup piece
  114. backup piece handle=/home/oracle/manual_backup/db_3mr84bps_1_1.bkp RECID=110 STAMP=914501443
  115. deleted backup piece
  116. backup piece handle=/home/oracle/manual_backup/db_3or84bps_1_1.bkp RECID=111 STAMP=914501444
  117. deleted backup piece
  118. backup piece handle=/home/oracle/manual_backup/db_3qr84bpu_1_1.bkp RECID=112 STAMP=914501447
  119. deleted backup piece
  120. backup piece handle=/home/oracle/manual_backup/db_3sr84bqb_1_1.bkp RECID=113 STAMP=914501451
  121. Deleted 19 objects

  122. deleted backup piece
  123. backup piece handle=2rr7iu9g_1_1 RECID=80 STAMP=913930544
  124. deleted backup piece
  125. backup piece handle=2vr7lilj_1_1 RECID=84 STAMP=914016947
  126. deleted backup piece
  127. backup piece handle=31r7o2en_1_1 RECID=86 STAMP=914098648
  128. deleted backup piece
  129. backup piece handle=33r7o2ma_1_1 RECID=88 STAMP=914098890
  130. deleted backup piece
  131. backup piece handle=37r84aog_1_1 RECID=92 STAMP=914500369
  132. deleted backup piece
  133. backup piece handle=c-1343950367-20160614-00 RECID=93 STAMP=914500418
  134. deleted backup piece
  135. backup piece handle=3br84b92_1_1 RECID=94 STAMP=914500898
  136. deleted backup piece
  137. backup piece handle=39r84b92_1_1 RECID=95 STAMP=914500899
  138. deleted backup piece
  139. backup piece handle=3ar84b92_1_1 RECID=96 STAMP=914500899
  140. deleted backup piece
  141. backup piece handle=3tr84dsd_1_1 RECID=114 STAMP=914503565
  142. deleted backup piece
  143. backup piece handle=3ur84dsd_1_1 RECID=115 STAMP=914503565
  144. deleted backup piece
  145. backup piece handle=3vr84dsd_1_1 RECID=116 STAMP=914503565
  146. deleted backup piece
  147. backup piece handle=41r84e3b_1_1 RECID=117 STAMP=914503787
  148. deleted backup piece
  149. backup piece handle=40r84e3b_1_1 RECID=118 STAMP=914503787
  150. Deleted 14 objects


  151. RMAN> delete noprompt copy;

  152. released channel: ORA_DISK_1
  153. released channel: ORA_DISK_2
  154. released channel: ORA_DISK_3
  155. released channel: ORA_DISK_4
  156. released channel: ORA_DISK_5
  157. released channel: ORA_DISK_6
  158. released channel: ORA_DISK_7
  159. released channel: ORA_DISK_8
  160. released channel: ORA_SBT_TAPE_1
  161. released channel: ORA_SBT_TAPE_2
  162. released channel: ORA_SBT_TAPE_3
  163. released channel: ORA_SBT_TAPE_4
  164. released channel: ORA_SBT_TAPE_5
  165. released channel: ORA_SBT_TAPE_6
  166. released channel: ORA_SBT_TAPE_7
  167. released channel: ORA_SBT_TAPE_8
  168. allocated channel: ORA_DISK_1
  169. channel ORA_DISK_1: SID=8 device type=DISK
  170. allocated channel: ORA_DISK_2
  171. channel ORA_DISK_2: SID=79 device type=DISK
  172. allocated channel: ORA_DISK_3
  173. channel ORA_DISK_3: SID=140 device type=DISK
  174. allocated channel: ORA_DISK_4
  175. channel ORA_DISK_4: SID=196 device type=DISK
  176. allocated channel: ORA_DISK_5
  177. channel ORA_DISK_5: SID=15 device type=DISK
  178. allocated channel: ORA_DISK_6
  179. channel ORA_DISK_6: SID=78 device type=DISK
  180. allocated channel: ORA_DISK_7
  181. channel ORA_DISK_7: SID=141 device type=DISK
  182. allocated channel: ORA_DISK_8
  183. channel ORA_DISK_8: SID=201 device type=DISK
  184. specification does not match any control file copy in the repository
  185. specification does not match any archived log in the repository
  186. List of Datafile Copies
  187. =======================

  188. Key     File S Completion Time Ckp SCN    Ckp Time      
  189. ------- ---- - --------------- ---------- ---------------
  190. 27      1    A 08-JUN-16       1547159    07-JUN-16      
  191.         Name: +FRA/orcl/datafile/system.268.913844129
  192.         Tag: ORA_OEM_LEVEL_0

  193. 28      2    A 08-JUN-16       1547159    07-JUN-16      
  194.         Name: +FRA/orcl/datafile/sysaux.267.913844145
  195.         Tag: ORA_OEM_LEVEL_0

  196. 26      3    A 08-JUN-16       1547159    07-JUN-16      
  197.         Name: +FRA/orcl/datafile/undotbs1.287.913844159
  198.         Tag: ORA_OEM_LEVEL_0

  199. 25      5    A 08-JUN-16       1547159    07-JUN-16      
  200.         Name: +FRA/orcl/datafile/example.269.913844163
  201.         Tag: ORA_OEM_LEVEL_0

  202. deleted datafile copy
  203. datafile copy file name=+FRA/orcl/datafile/sysaux.267.913844145 RECID=28 STAMP=914016933
  204. deleted datafile copy
  205. datafile copy file name=+FRA/orcl/datafile/undotbs1.287.913844159 RECID=26 STAMP=914016932
  206. deleted datafile copy
  207. datafile copy file name=+FRA/orcl/datafile/example.269.913844163 RECID=25 STAMP=914016932
  208. Deleted 3 objects


  209. RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
  210. RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
  211. RMAN-06210: List of Mismatched objects
  212. RMAN-06211: ==========================
  213. RMAN-06212:   Object Type   Filename/Handle
  214. RMAN-06213: --------------- ---------------------------------------------------
  215. RMAN-06214: Datafile Copy   +FRA/orcl/datafile/system.268.913844129


  216. RMAN> crosscheck copy;

  217. released channel: ORA_DISK_1
  218. released channel: ORA_DISK_2
  219. released channel: ORA_DISK_3
  220. released channel: ORA_DISK_4
  221. released channel: ORA_DISK_5
  222. released channel: ORA_DISK_6
  223. released channel: ORA_DISK_7
  224. released channel: ORA_DISK_8
  225. allocated channel: ORA_DISK_1
  226. channel ORA_DISK_1: SID=8 device type=DISK
  227. allocated channel: ORA_DISK_2
  228. channel ORA_DISK_2: SID=79 device type=DISK
  229. allocated channel: ORA_DISK_3
  230. channel ORA_DISK_3: SID=140 device type=DISK
  231. allocated channel: ORA_DISK_4
  232. channel ORA_DISK_4: SID=196 device type=DISK
  233. allocated channel: ORA_DISK_5
  234. channel ORA_DISK_5: SID=15 device type=DISK
  235. allocated channel: ORA_DISK_6
  236. channel ORA_DISK_6: SID=78 device type=DISK
  237. allocated channel: ORA_DISK_7
  238. channel ORA_DISK_7: SID=141 device type=DISK
  239. allocated channel: ORA_DISK_8
  240. channel ORA_DISK_8: SID=201 device type=DISK
  241. specification does not match any control file copy in the repository
  242. specification does not match any archived log in the repository
  243. validation failed for datafile copy
  244. datafile copy file name=+FRA/orcl/datafile/system.268.913844129 RECID=27 STAMP=914016932
  245. Crosschecked 1 objects


  246. RMAN> delete expired copy;

  247. released channel: ORA_DISK_1
  248. released channel: ORA_DISK_2
  249. released channel: ORA_DISK_3
  250. released channel: ORA_DISK_4
  251. released channel: ORA_DISK_5
  252. released channel: ORA_DISK_6
  253. released channel: ORA_DISK_7
  254. released channel: ORA_DISK_8
  255. allocated channel: ORA_DISK_1
  256. channel ORA_DISK_1: SID=8 device type=DISK
  257. allocated channel: ORA_DISK_2
  258. channel ORA_DISK_2: SID=79 device type=DISK
  259. allocated channel: ORA_DISK_3
  260. channel ORA_DISK_3: SID=140 device type=DISK
  261. allocated channel: ORA_DISK_4
  262. channel ORA_DISK_4: SID=196 device type=DISK
  263. allocated channel: ORA_DISK_5
  264. channel ORA_DISK_5: SID=15 device type=DISK
  265. allocated channel: ORA_DISK_6
  266. channel ORA_DISK_6: SID=78 device type=DISK
  267. allocated channel: ORA_DISK_7
  268. channel ORA_DISK_7: SID=141 device type=DISK
  269. allocated channel: ORA_DISK_8
  270. channel ORA_DISK_8: SID=201 device type=DISK
  271. specification does not match any control file copy in the repository
  272. specification does not match any archived log in the repository
  273. List of Datafile Copies
  274. =======================

  275. Key     File S Completion Time Ckp SCN    Ckp Time      
  276. ------- ---- - --------------- ---------- ---------------
  277. 27      1    X 08-JUN-16       1547159    07-JUN-16      
  278.         Name: +FRA/orcl/datafile/system.268.913844129
  279.         Tag: ORA_OEM_LEVEL_0


  280. Do you really want to delete the above objects (enter YES or NO)? YES
  281. deleted datafile copy
  282. datafile copy file name=+FRA/orcl/datafile/system.268.913844129 RECID=27 STAMP=914016932
  283. Deleted 1 EXPIRED objects


  284. RMAN> list copy;

  285. specification does not match any datafile copy in the repository
  286. specification does not match any control file copy in the repository
  287. specification does not match any archived log in the repository

  288. RMAN> list backup;

  289. specification does not match any backup in the repository

  290. RMAN> show all;

  291. RMAN configuration parameters for database with db_unique_name ORCL are:
  292. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  293. CONFIGURE BACKUP OPTIMIZATION ON;
  294. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  295. CONFIGURE CONTROLFILE AUTOBACKUP OFF;
  296. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  297. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  298. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  299. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  300. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  301. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  302. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  303. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  304. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  305. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  306. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  307. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  308. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  309. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  310. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  311. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  312. CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  313. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  314. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  315. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  316. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  317. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  318. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  319. RMAN> backup tag '1T_WHOLE_INCR0'   incremental level 0 database ;

  320. Starting backup at 14-JUN-16
  321. released channel: ORA_DISK_1
  322. released channel: ORA_DISK_2
  323. released channel: ORA_DISK_3
  324. released channel: ORA_DISK_4
  325. released channel: ORA_DISK_5
  326. released channel: ORA_DISK_6
  327. released channel: ORA_DISK_7
  328. released channel: ORA_DISK_8
  329. allocated channel: ORA_SBT_TAPE_1
  330. channel ORA_SBT_TAPE_1: SID=8 device type=SBT_TAPE
  331. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  332. allocated channel: ORA_SBT_TAPE_2
  333. channel ORA_SBT_TAPE_2: SID=79 device type=SBT_TAPE
  334. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  335. allocated channel: ORA_SBT_TAPE_3
  336. channel ORA_SBT_TAPE_3: SID=140 device type=SBT_TAPE
  337. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  338. allocated channel: ORA_SBT_TAPE_4
  339. channel ORA_SBT_TAPE_4: SID=196 device type=SBT_TAPE
  340. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  341. allocated channel: ORA_SBT_TAPE_5
  342. channel ORA_SBT_TAPE_5: SID=15 device type=SBT_TAPE
  343. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  344. allocated channel: ORA_SBT_TAPE_6
  345. channel ORA_SBT_TAPE_6: SID=78 device type=SBT_TAPE
  346. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  347. allocated channel: ORA_SBT_TAPE_7
  348. channel ORA_SBT_TAPE_7: SID=141 device type=SBT_TAPE
  349. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  350. allocated channel: ORA_SBT_TAPE_8
  351. channel ORA_SBT_TAPE_8: SID=201 device type=SBT_TAPE
  352. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  353. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  354. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  355. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  356. channel ORA_SBT_TAPE_1: starting piece 1 at 14-JUN-16
  357. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  358. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  359. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  360. channel ORA_SBT_TAPE_2: starting piece 1 at 14-JUN-16
  361. channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
  362. channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
  363. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  364. channel ORA_SBT_TAPE_3: starting piece 1 at 14-JUN-16
  365. channel ORA_SBT_TAPE_4: starting incremental level 0 datafile backup set
  366. channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
  367. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  368. channel ORA_SBT_TAPE_4: starting piece 1 at 14-JUN-16
  369. channel ORA_SBT_TAPE_5: starting incremental level 0 datafile backup set
  370. channel ORA_SBT_TAPE_5: specifying datafile(s) in backup set
  371. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
  372. channel ORA_SBT_TAPE_5: starting piece 1 at 14-JUN-16
  373. channel ORA_SBT_TAPE_6: starting incremental level 0 datafile backup set
  374. channel ORA_SBT_TAPE_6: specifying datafile(s) in backup set
  375. channel ORA_SBT_TAPE_7: starting incremental level 0 datafile backup set
  376. channel ORA_SBT_TAPE_7: specifying datafile(s) in backup set
  377. including current SPFILE in backup set
  378. channel ORA_SBT_TAPE_7: starting piece 1 at 14-JUN-16
  379. including current control file in backup set
  380. channel ORA_SBT_TAPE_6: starting piece 1 at 14-JUN-16
  381. channel ORA_SBT_TAPE_7: finished piece 1 at 14-JUN-16
  382. piece handle=48r84eav_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  383. channel ORA_SBT_TAPE_7: backup set complete, elapsed time: 00:00:26
  384. channel ORA_SBT_TAPE_1: finished piece 1 at 14-JUN-16
  385. piece handle=42r84eau_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  386. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:17
  387. channel ORA_SBT_TAPE_5: finished piece 1 at 14-JUN-16
  388. piece handle=46r84eau_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  389. channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:01:36
  390. channel ORA_SBT_TAPE_2: finished piece 1 at 14-JUN-16
  391. piece handle=43r84eau_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  392. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:57
  393. channel ORA_SBT_TAPE_4: finished piece 1 at 14-JUN-16
  394. piece handle=45r84eau_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  395. channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:02:17
  396. channel ORA_SBT_TAPE_6: finished piece 1 at 14-JUN-16
  397. piece handle=47r84eav_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  398. channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:02:15
  399. channel ORA_SBT_TAPE_3: finished piece 1 at 14-JUN-16
  400. piece handle=44r84eau_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  401. channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:02:37
  402. Finished backup at 14-JUN-16


复制代码
回复 支持 反对

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 18:33 , Processed in 0.052997 second(s), 25 queries .

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