Bo's Oracle Station

查看: 862|回复: 0

课程第36次:2016-06-17星期五

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2016-6-18 09:42:18 | 显示全部楼层 |阅读模式
本帖最后由 botang 于 2016-6-18 09:48 编辑

【上完1Z0-053的第5章】:rman的备份毕业季
【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】:共9章(0 1 2 3 4 5 10 11 12)
加密rman配置续:
  1. [root@station90 桌面]# su - oracle
  2. [oracle@station90 ~]$ rman target /

  3. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 22 22:16:51 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. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  13.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  14.         Handle: 6or8lfc9_1_1   Media: station90-000019
  15.   List of Datafiles in backup set 197
  16.   File LV Type Ckp SCN    Ckp Time            Name
  17.   ---- -- ---- ---------- ------------------- ----
  18.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915062657

  19. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  20. ------- ---- -- ---------- ----------- ------------ -------------------
  21. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  22.         BP Key: 214   Status: AVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  23.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  24.   List of Datafiles in backup set 198
  25.   File LV Type Ckp SCN    Ckp Time            Name
  26.   ---- -- ---- ---------- ------------------- ----
  27.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915062657

  28. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  29. ------- ---- -- ---------- ----------- ------------ -------------------
  30. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  31.         BP Key: 215   Status: AVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  32.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  33.   List of Datafiles in backup set 199
  34.   File LV Type Ckp SCN    Ckp Time            Name
  35.   ---- -- ---- ---------- ------------------- ----
  36.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915062657

  37. RMAN> change backupset 197 unAVAILABLE;

  38. changed backup piece unavailable
  39. backup piece handle=6or8lfc9_1_1 RECID=213 STAMP=915062153
  40. Changed 1 objects to UNAVAILABLE status


  41. RMAN> change backupset 198 unAVAILABLE;

  42. changed backup piece unavailable
  43. backup piece handle=6rr8lg8a_1_1 RECID=214 STAMP=915063050
  44. Changed 1 objects to UNAVAILABLE status


  45. RMAN> list backup;


  46. List of Backup Sets
  47. ===================


  48. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  49. ------- ---- -- ---------- ----------- ------------ -------------------
  50. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  51.         BP Key: 213   Status: UNAVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  52.         Handle: 6or8lfc9_1_1   Media: station90-000019
  53.   List of Datafiles in backup set 197
  54.   File LV Type Ckp SCN    Ckp Time            Name
  55.   ---- -- ---- ---------- ------------------- ----
  56.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915062657

  57. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  58. ------- ---- -- ---------- ----------- ------------ -------------------
  59. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  60.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  61.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  62.   List of Datafiles in backup set 198
  63.   File LV Type Ckp SCN    Ckp Time            Name
  64.   ---- -- ---- ---------- ------------------- ----
  65.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915062657

  66. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  67. ------- ---- -- ---------- ----------- ------------ -------------------
  68. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  69.         BP Key: 215   Status: AVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  70.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  71.   List of Datafiles in backup set 199
  72.   File LV Type Ckp SCN    Ckp Time            Name
  73.   ---- -- ---- ---------- ------------------- ----
  74.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915062657

  75. RMAN> exit


  76. Recovery Manager complete.
  77. [oracle@station90 ~]$ rman target /

  78. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 22 22:23:45 2016

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

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

  81. RMAN> restore datafile 4;

  82. Starting restore at 2016-06-22:22:23:52
  83. using target database control file instead of recovery catalog
  84. allocated channel: ORA_DISK_1
  85. channel ORA_DISK_1: SID=198 device type=DISK
  86. allocated channel: ORA_DISK_2
  87. channel ORA_DISK_2: SID=22 device type=DISK
  88. allocated channel: ORA_DISK_3
  89. channel ORA_DISK_3: SID=86 device type=DISK
  90. allocated channel: ORA_DISK_4
  91. channel ORA_DISK_4: SID=140 device type=DISK
  92. allocated channel: ORA_DISK_5
  93. channel ORA_DISK_5: SID=206 device type=DISK
  94. allocated channel: ORA_DISK_6
  95. channel ORA_DISK_6: SID=15 device type=DISK
  96. allocated channel: ORA_DISK_7
  97. channel ORA_DISK_7: SID=149 device type=DISK
  98. allocated channel: ORA_DISK_8
  99. channel ORA_DISK_8: SID=200 device type=DISK
  100. allocated channel: ORA_SBT_TAPE_1
  101. channel ORA_SBT_TAPE_1: SID=20 device type=SBT_TAPE
  102. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  103. allocated channel: ORA_SBT_TAPE_2
  104. channel ORA_SBT_TAPE_2: SID=145 device type=SBT_TAPE
  105. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  106. allocated channel: ORA_SBT_TAPE_3
  107. channel ORA_SBT_TAPE_3: SID=9 device type=SBT_TAPE
  108. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  109. allocated channel: ORA_SBT_TAPE_4
  110. channel ORA_SBT_TAPE_4: SID=81 device type=SBT_TAPE
  111. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  112. allocated channel: ORA_SBT_TAPE_5
  113. channel ORA_SBT_TAPE_5: SID=24 device type=SBT_TAPE
  114. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  115. allocated channel: ORA_SBT_TAPE_6
  116. channel ORA_SBT_TAPE_6: SID=203 device type=SBT_TAPE
  117. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  118. allocated channel: ORA_SBT_TAPE_7
  119. channel ORA_SBT_TAPE_7: SID=75 device type=SBT_TAPE
  120. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  121. allocated channel: ORA_SBT_TAPE_8
  122. channel ORA_SBT_TAPE_8: SID=193 device type=SBT_TAPE
  123. channel ORA_SBT_TAPE_8: Oracle Secure Backup

  124. channel ORA_SBT_TAPE_1: starting datafile backup set restore
  125. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  126. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.259.915062657
  127. channel ORA_SBT_TAPE_1: reading from backup piece 6ur8qi9u_1_1
  128. RMAN-00571: ===========================================================
  129. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  130. RMAN-00571: ===========================================================
  131. RMAN-03002: failure of restore command at 06/22/2016 22:25:16
  132. ORA-19870: error while restoring backup piece 6ur8qi9u_1_1
  133. ORA-19913: unable to decrypt backup
  134. ORA-28365: wallet is not open

  135. RMAN> set  decryption identified by "microsoft12","cisco12";

  136. executing command: SET decryption

  137. RMAN> restore datafile 4;

  138. Starting restore at 2016-06-22:22:26:57
  139. using channel ORA_DISK_1
  140. using channel ORA_DISK_2
  141. using channel ORA_DISK_3
  142. using channel ORA_DISK_4
  143. using channel ORA_DISK_5
  144. using channel ORA_DISK_6
  145. using channel ORA_DISK_7
  146. using 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 datafile backup set restore
  156. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  157. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.259.915062657
  158. channel ORA_SBT_TAPE_1: reading from backup piece 6ur8qi9u_1_1
  159. channel ORA_SBT_TAPE_1: piece handle=6ur8qi9u_1_1 tag=3DET_USERS_INCR0
  160. channel ORA_SBT_TAPE_1: restored backup piece 1
  161. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
  162. Finished restore at 2016-06-22:22:27:33

  163. RMAN> recover datafile 4 ;

  164. Starting recover at 2016-06-22:22:27:41
  165. using channel ORA_DISK_1
  166. using channel ORA_DISK_2
  167. using channel ORA_DISK_3
  168. using channel ORA_DISK_4
  169. using channel ORA_DISK_5
  170. using channel ORA_DISK_6
  171. using channel ORA_DISK_7
  172. using channel ORA_DISK_8
  173. using channel ORA_SBT_TAPE_1
  174. using channel ORA_SBT_TAPE_2
  175. using channel ORA_SBT_TAPE_3
  176. using channel ORA_SBT_TAPE_4
  177. using channel ORA_SBT_TAPE_5
  178. using channel ORA_SBT_TAPE_6
  179. using channel ORA_SBT_TAPE_7
  180. using channel ORA_SBT_TAPE_8

  181. starting media recovery

  182. archived log for thread 1 with sequence 134 is already on disk as file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_134.325.915229249
  183. archived log for thread 1 with sequence 135 is already on disk as file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_135.324.915229249
  184. archived log for thread 1 with sequence 136 is already on disk as file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_136.327.915229251
  185. archived log for thread 1 with sequence 137 is already on disk as file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_137.279.915229253
  186. archived log for thread 1 with sequence 138 is already on disk as file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_138.298.915229255
  187. archived log for thread 1 with sequence 139 is already on disk as file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_139.267.915229255
  188. archived log file name=+FRA/orcl/archivelog/2016_06_22/thread_1_seq_134.325.915229249 thread=1 sequence=134
  189. archived log file name=+FRA/orcl/archivelog/2016_06_22/thread_1_seq_135.324.915229249 thread=1 sequence=135
  190. archived log file name=+FRA/orcl/archivelog/2016_06_22/thread_1_seq_136.327.915229251 thread=1 sequence=136
  191. archived log file name=+FRA/orcl/archivelog/2016_06_22/thread_1_seq_137.279.915229253 thread=1 sequence=137
  192. media recovery complete, elapsed time: 00:00:01
  193. Finished recover at 2016-06-22:22:27:43

  194. RMAN> list backup;


  195. List of Backup Sets
  196. ===================


  197. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  198. ------- ---- -- ---------- ----------- ------------ -------------------
  199. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  200.         BP Key: 213   Status: UNAVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  201.         Handle: 6or8lfc9_1_1   Media: station90-000019
  202.   List of Datafiles in backup set 197
  203.   File LV Type Ckp SCN    Ckp Time            Name
  204.   ---- -- ---- ---------- ------------------- ----
  205.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915229637

  206. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  207. ------- ---- -- ---------- ----------- ------------ -------------------
  208. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  209.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  210.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  211.   List of Datafiles in backup set 198
  212.   File LV Type Ckp SCN    Ckp Time            Name
  213.   ---- -- ---- ---------- ------------------- ----
  214.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915229637

  215. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  216. ------- ---- -- ---------- ----------- ------------ -------------------
  217. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  218.         BP Key: 215   Status: AVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  219.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  220.   List of Datafiles in backup set 199
  221.   File LV Type Ckp SCN    Ckp Time            Name
  222.   ---- -- ---- ---------- ------------------- ----
  223.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915229637

  224. RMAN> change backupset 199 unAVAILABLE;

  225. changed backup piece unavailable
  226. backup piece handle=6ur8qi9u_1_1 RECID=215 STAMP=915228991
  227. Changed 1 objects to UNAVAILABLE status


  228. RMAN> change backupset 197  AVAILABLE;

  229. using channel ORA_DISK_1
  230. using channel ORA_DISK_2
  231. using channel ORA_DISK_3
  232. using channel ORA_DISK_4
  233. using channel ORA_DISK_5
  234. using channel ORA_DISK_6
  235. using channel ORA_DISK_7
  236. using channel ORA_DISK_8
  237. using channel ORA_SBT_TAPE_1
  238. using channel ORA_SBT_TAPE_2
  239. using channel ORA_SBT_TAPE_3
  240. using channel ORA_SBT_TAPE_4
  241. using channel ORA_SBT_TAPE_5
  242. using channel ORA_SBT_TAPE_6
  243. using channel ORA_SBT_TAPE_7
  244. using channel ORA_SBT_TAPE_8
  245. changed backup piece available
  246. backup piece handle=6or8lfc9_1_1 RECID=213 STAMP=915062153
  247. Changed 1 objects to AVAILABLE status


  248. RMAN>  list backup of tablespace users ;


  249. List of Backup Sets
  250. ===================


  251. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  252. ------- ---- -- ---------- ----------- ------------ -------------------
  253. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  254.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  255.         Handle: 6or8lfc9_1_1   Media: station90-000019
  256.   List of Datafiles in backup set 197
  257.   File LV Type Ckp SCN    Ckp Time            Name
  258.   ---- -- ---- ---------- ------------------- ----
  259.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  260. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  261. ------- ---- -- ---------- ----------- ------------ -------------------
  262. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  263.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  264.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  265.   List of Datafiles in backup set 198
  266.   File LV Type Ckp SCN    Ckp Time            Name
  267.   ---- -- ---- ---------- ------------------- ----
  268.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  269. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  270. ------- ---- -- ---------- ----------- ------------ -------------------
  271. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  272.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  273.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  274.   List of Datafiles in backup set 199
  275.   File LV Type Ckp SCN    Ckp Time            Name
  276.   ---- -- ---- ---------- ------------------- ----
  277.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  278. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  279. ------- ---- -- ---------- ----------- ------------ -------------------
  280. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  281.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  282.         Handle: 6vr8qkce_1_1   Media: station90-000019
  283.   List of Datafiles in backup set 200
  284.   File LV Type Ckp SCN    Ckp Time            Name
  285.   ---- -- ---- ---------- ------------------- ----
  286.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  287. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  288. ------- ---- -- ---------- ----------- ------------ -------------------
  289. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  290.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  291.         Handle: 70r8qke1_1_1   Media: station90-000019
  292.   List of Datafiles in backup set 201
  293.   File LV Type Ckp SCN    Ckp Time            Name
  294.   ---- -- ---- ---------- ------------------- ----
  295.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  296. RMAN> report need backup incremental 1 ;

  297. Report of files that need more than 1 incrementals during recovery
  298. File Incrementals Name
  299. ---- ------------ ----------------------------------------------

  300. RMAN> report need backup incremental 0 ;

  301. Report of files that need more than 0 incrementals during recovery
  302. File Incrementals Name
  303. ---- ------------ ----------------------------------------------
  304. 4    1            +DATA/orcl/datafile/users.259.915231377

  305. RMAN> report need backup incremental 1 ;

  306. Report of files that need more than 1 incrementals during recovery
  307. File Incrementals Name
  308. ---- ------------ ----------------------------------------------

  309. RMAN> list backup ;


  310. List of Backup Sets
  311. ===================


  312. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  313. ------- ---- -- ---------- ----------- ------------ -------------------
  314. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  315.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  316.         Handle: 6or8lfc9_1_1   Media: station90-000019
  317.   List of Datafiles in backup set 197
  318.   File LV Type Ckp SCN    Ckp Time            Name
  319.   ---- -- ---- ---------- ------------------- ----
  320.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  321. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  322. ------- ---- -- ---------- ----------- ------------ -------------------
  323. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  324.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  325.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  326.   List of Datafiles in backup set 198
  327.   File LV Type Ckp SCN    Ckp Time            Name
  328.   ---- -- ---- ---------- ------------------- ----
  329.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  330. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  331. ------- ---- -- ---------- ----------- ------------ -------------------
  332. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  333.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  334.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  335.   List of Datafiles in backup set 199
  336.   File LV Type Ckp SCN    Ckp Time            Name
  337.   ---- -- ---- ---------- ------------------- ----
  338.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  339. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  340. ------- ---- -- ---------- ----------- ------------ -------------------
  341. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  342.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  343.         Handle: 6vr8qkce_1_1   Media: station90-000019
  344.   List of Datafiles in backup set 200
  345.   File LV Type Ckp SCN    Ckp Time            Name
  346.   ---- -- ---- ---------- ------------------- ----
  347.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  348. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  349. ------- ---- -- ---------- ----------- ------------ -------------------
  350. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  351.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  352.         Handle: 70r8qke1_1_1   Media: station90-000019
  353.   List of Datafiles in backup set 201
  354.   File LV Type Ckp SCN    Ckp Time            Name
  355.   ---- -- ---- ---------- ------------------- ----
  356.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  357. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  358. ------- ---- -- ---------- ----------- ------------ -------------------
  359. 202     Incr 1  256.00K    SBT_TAPE    00:00:16     2016-06-22:22:59:40
  360.         BP Key: 218   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1C
  361.         Handle: 71r8qkqc_1_1   Media: station90-000019
  362.   List of Datafiles in backup set 202
  363.   File LV Type Ckp SCN    Ckp Time            Name
  364.   ---- -- ---- ---------- ------------------- ----
  365.   4    1  Incr 2244060    2016-06-22:22:59:24 +DATA/orcl/datafile/users.259.915231377

  366. RMAN> report need backup incremental 0;

  367. Report of files that need more than 0 incrementals during recovery
  368. File Incrementals Name
  369. ---- ------------ ----------------------------------------------
  370. 4    1            +DATA/orcl/datafile/users.259.915231377

  371. RMAN> report need backup incremental 1;

  372. Report of files that need more than 1 incrementals during recovery
  373. File Incrementals Name
  374. ---- ------------ ----------------------------------------------

  375. RMAN> delete backupset 202;

  376. using channel ORA_DISK_1
  377. using channel ORA_DISK_2
  378. using channel ORA_DISK_3
  379. using channel ORA_DISK_4
  380. using channel ORA_DISK_5
  381. using channel ORA_DISK_6
  382. using channel ORA_DISK_7
  383. using channel ORA_DISK_8
  384. using channel ORA_SBT_TAPE_1
  385. using channel ORA_SBT_TAPE_2
  386. using channel ORA_SBT_TAPE_3
  387. using channel ORA_SBT_TAPE_4
  388. using channel ORA_SBT_TAPE_5
  389. using channel ORA_SBT_TAPE_6
  390. using channel ORA_SBT_TAPE_7
  391. using channel ORA_SBT_TAPE_8

  392. List of Backup Pieces
  393. BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
  394. ------- ------- --- --- ----------- ----------- ----------
  395. 218     202     1   1   AVAILABLE   SBT_TAPE    71r8qkqc_1_1

  396. Do you really want to delete the above objects (enter YES or NO)? YES
  397. deleted backup piece
  398. backup piece handle=71r8qkqc_1_1 RECID=218 STAMP=915231564
  399. Deleted 1 objects


  400. RMAN> report need backup incremental 1;

  401. Report of files that need more than 1 incrementals during recovery
  402. File Incrementals Name
  403. ---- ------------ ----------------------------------------------
  404. 4    2            +DATA/orcl/datafile/users.259.915231377

  405. RMAN> report need backup incremental 2;

  406. Report of files that need more than 2 incrementals during recovery
  407. File Incrementals Name
  408. ---- ------------ ----------------------------------------------

  409. RMAN> backup tag '6T_USERS_INCR1' incremental level 1 tablespace users ;

  410. Starting backup at 2016-06-22:23:06:56
  411. released channel: ORA_DISK_1
  412. released channel: ORA_DISK_2
  413. released channel: ORA_DISK_3
  414. released channel: ORA_DISK_4
  415. released channel: ORA_DISK_5
  416. released channel: ORA_DISK_6
  417. released channel: ORA_DISK_7
  418. released channel: ORA_DISK_8
  419. using channel ORA_SBT_TAPE_1
  420. using channel ORA_SBT_TAPE_2
  421. using channel ORA_SBT_TAPE_3
  422. using channel ORA_SBT_TAPE_4
  423. using channel ORA_SBT_TAPE_5
  424. using channel ORA_SBT_TAPE_6
  425. using channel ORA_SBT_TAPE_7
  426. using channel ORA_SBT_TAPE_8
  427. channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set
  428. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  429. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915231377
  430. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-22:23:06:56
  431. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-22:23:07:21
  432. piece handle=72r8ql8g_1_1 tag=6T_USERS_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
  433. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  434. Finished backup at 2016-06-22:23:07:21

  435. RMAN> report need backup incremental 2;

  436. Report of files that need more than 2 incrementals during recovery
  437. File Incrementals Name
  438. ---- ------------ ----------------------------------------------
  439. 4    3            +DATA/orcl/datafile/users.259.915231377

  440. RMAN> report need backup incremental 0;

  441. Report of files that need more than 0 incrementals during recovery
  442. File Incrementals Name
  443. ---- ------------ ----------------------------------------------
  444. 4    3            +DATA/orcl/datafile/users.259.915231377

  445. RMAN> report need backup incremental 1;

  446. Report of files that need more than 1 incrementals during recovery
  447. File Incrementals Name
  448. ---- ------------ ----------------------------------------------
  449. 4    3            +DATA/orcl/datafile/users.259.915231377

  450. RMAN> exit


  451. Recovery Manager complete.
  452. [oracle@station90 ~]$ rman target  /

  453. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 22 23:14:23 2016

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

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

  456. RMAN> list backup;

  457. using target database control file instead of recovery catalog

  458. List of Backup Sets
  459. ===================


  460. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  461. ------- ---- -- ---------- ----------- ------------ -------------------
  462. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  463.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  464.         Handle: 6or8lfc9_1_1   Media: station90-000019
  465.   List of Datafiles in backup set 197
  466.   File LV Type Ckp SCN    Ckp Time            Name
  467.   ---- -- ---- ---------- ------------------- ----
  468.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  469. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  470. ------- ---- -- ---------- ----------- ------------ -------------------
  471. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  472.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  473.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  474.   List of Datafiles in backup set 198
  475.   File LV Type Ckp SCN    Ckp Time            Name
  476.   ---- -- ---- ---------- ------------------- ----
  477.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  478. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  479. ------- ---- -- ---------- ----------- ------------ -------------------
  480. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  481.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  482.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  483.   List of Datafiles in backup set 199
  484.   File LV Type Ckp SCN    Ckp Time            Name
  485.   ---- -- ---- ---------- ------------------- ----
  486.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  487. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  488. ------- ---- -- ---------- ----------- ------------ -------------------
  489. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  490.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  491.         Handle: 6vr8qkce_1_1   Media: station90-000019
  492.   List of Datafiles in backup set 200
  493.   File LV Type Ckp SCN    Ckp Time            Name
  494.   ---- -- ---- ---------- ------------------- ----
  495.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  496. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  497. ------- ---- -- ---------- ----------- ------------ -------------------
  498. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  499.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  500.         Handle: 70r8qke1_1_1   Media: station90-000019
  501.   List of Datafiles in backup set 201
  502.   File LV Type Ckp SCN    Ckp Time            Name
  503.   ---- -- ---- ---------- ------------------- ----
  504.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  505. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  506. ------- ---- -- ---------- ----------- ------------ -------------------
  507. 203     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  508.         BP Key: 219   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  509.         Handle: 72r8ql8g_1_1   Media: station90-000019
  510.   List of Datafiles in backup set 203
  511.   File LV Type Ckp SCN    Ckp Time            Name
  512.   ---- -- ---- ---------- ------------------- ----
  513.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  514. RMAN> show all;

  515. RMAN configuration parameters for database with db_unique_name ORCL are:
  516. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  517. CONFIGURE BACKUP OPTIMIZATION ON;
  518. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  519. CONFIGURE CONTROLFILE AUTOBACKUP OFF;
  520. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  521. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  522. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO COMPRESSED BACKUPSET;
  523. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  524. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  525. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  526. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  527. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  528. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  529. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  530. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  531. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  532. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  533. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  534. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  535. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  536. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  537. CONFIGURE ENCRYPTION FOR DATABASE ON;
  538. CONFIGURE ENCRYPTION ALGORITHM 'AES256';
  539. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  540. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  541. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  542. RMAN> backup backupset 197 delete input;

  543. Starting backup at 2016-06-22:23:15:29
  544. allocated channel: ORA_SBT_TAPE_1
  545. channel ORA_SBT_TAPE_1: SID=193 device type=SBT_TAPE
  546. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  547. allocated channel: ORA_SBT_TAPE_2
  548. channel ORA_SBT_TAPE_2: SID=139 device type=SBT_TAPE
  549. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  550. allocated channel: ORA_SBT_TAPE_3
  551. channel ORA_SBT_TAPE_3: SID=9 device type=SBT_TAPE
  552. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  553. allocated channel: ORA_SBT_TAPE_4
  554. channel ORA_SBT_TAPE_4: SID=194 device type=SBT_TAPE
  555. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  556. allocated channel: ORA_SBT_TAPE_5
  557. channel ORA_SBT_TAPE_5: SID=148 device type=SBT_TAPE
  558. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  559. allocated channel: ORA_SBT_TAPE_6
  560. channel ORA_SBT_TAPE_6: SID=21 device type=SBT_TAPE
  561. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  562. allocated channel: ORA_SBT_TAPE_7
  563. channel ORA_SBT_TAPE_7: SID=149 device type=SBT_TAPE
  564. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  565. allocated channel: ORA_SBT_TAPE_8
  566. channel ORA_SBT_TAPE_8: SID=198 device type=SBT_TAPE
  567. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  568. RMAN-00571: ===========================================================
  569. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  570. RMAN-00571: ===========================================================
  571. RMAN-03002: failure of backup command at 06/22/2016 23:16:12
  572. RMAN-06160: no backup pieces found for backup set key: 197

  573. RMAN> run {
  574. 2> allocate channel c1 device type disk;
  575. 3> backup  tag '7D_USERS_INCR0'  incremental level 0  tablespace users ;
  576. 4> }

  577. released channel: ORA_SBT_TAPE_1
  578. released channel: ORA_SBT_TAPE_2
  579. released channel: ORA_SBT_TAPE_3
  580. released channel: ORA_SBT_TAPE_4
  581. released channel: ORA_SBT_TAPE_5
  582. released channel: ORA_SBT_TAPE_6
  583. released channel: ORA_SBT_TAPE_7
  584. released channel: ORA_SBT_TAPE_8
  585. allocated channel: c1
  586. channel c1: SID=193 device type=DISK

  587. Starting backup at 2016-06-22:23:17:38
  588. channel c1: starting compressed incremental level 0 datafile backup set
  589. channel c1: specifying datafile(s) in backup set
  590. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915231377
  591. channel c1: starting piece 1 at 2016-06-22:23:17:38
  592. channel c1: finished piece 1 at 2016-06-22:23:17:39
  593. piece handle=+FRA/orcl/backupset/2016_06_22/nnndn0_7d_users_incr0_0.291.915232659 tag=7D_USERS_INCR0 comment=NONE
  594. channel c1: backup set complete, elapsed time: 00:00:01
  595. Finished backup at 2016-06-22:23:17:39
  596. released channel: c1

  597. RMAN> list backup;


  598. List of Backup Sets
  599. ===================


  600. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  601. ------- ---- -- ---------- ----------- ------------ -------------------
  602. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  603.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  604.         Handle: 6or8lfc9_1_1   Media: station90-000019
  605.   List of Datafiles in backup set 197
  606.   File LV Type Ckp SCN    Ckp Time            Name
  607.   ---- -- ---- ---------- ------------------- ----
  608.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  609. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  610. ------- ---- -- ---------- ----------- ------------ -------------------
  611. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  612.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  613.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  614.   List of Datafiles in backup set 198
  615.   File LV Type Ckp SCN    Ckp Time            Name
  616.   ---- -- ---- ---------- ------------------- ----
  617.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  618. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  619. ------- ---- -- ---------- ----------- ------------ -------------------
  620. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  621.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  622.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  623.   List of Datafiles in backup set 199
  624.   File LV Type Ckp SCN    Ckp Time            Name
  625.   ---- -- ---- ---------- ------------------- ----
  626.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  627. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  628. ------- ---- -- ---------- ----------- ------------ -------------------
  629. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  630.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  631.         Handle: 6vr8qkce_1_1   Media: station90-000019
  632.   List of Datafiles in backup set 200
  633.   File LV Type Ckp SCN    Ckp Time            Name
  634.   ---- -- ---- ---------- ------------------- ----
  635.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  636. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  637. ------- ---- -- ---------- ----------- ------------ -------------------
  638. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  639.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  640.         Handle: 70r8qke1_1_1   Media: station90-000019
  641.   List of Datafiles in backup set 201
  642.   File LV Type Ckp SCN    Ckp Time            Name
  643.   ---- -- ---- ---------- ------------------- ----
  644.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  645. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  646. ------- ---- -- ---------- ----------- ------------ -------------------
  647. 203     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  648.         BP Key: 219   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  649.         Handle: 72r8ql8g_1_1   Media: station90-000019
  650.   List of Datafiles in backup set 203
  651.   File LV Type Ckp SCN    Ckp Time            Name
  652.   ---- -- ---- ---------- ------------------- ----
  653.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  654. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  655. ------- ---- -- ---------- ----------- ------------ -------------------
  656. 204     Incr 0  1.02M      DISK        00:00:01     2016-06-22:23:17:39
  657.         BP Key: 220   Status: AVAILABLE  Compressed: YES  Tag: 7D_USERS_INCR0
  658.         Piece Name: +FRA/orcl/backupset/2016_06_22/nnndn0_7d_users_incr0_0.291.915232659
  659.   List of Datafiles in backup set 204
  660.   File LV Type Ckp SCN    Ckp Time            Name
  661.   ---- -- ---- ---------- ------------------- ----
  662.   4    0  Incr 2246402    2016-06-22:23:17:38 +DATA/orcl/datafile/users.259.915231377

  663. RMAN> backup backupset 204 delete input;

  664. Starting backup at 2016-06-22:23:18:00
  665. allocated channel: ORA_SBT_TAPE_1
  666. channel ORA_SBT_TAPE_1: SID=193 device type=SBT_TAPE
  667. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  668. allocated channel: ORA_SBT_TAPE_2
  669. channel ORA_SBT_TAPE_2: SID=139 device type=SBT_TAPE
  670. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  671. allocated channel: ORA_SBT_TAPE_3
  672. channel ORA_SBT_TAPE_3: SID=9 device type=SBT_TAPE
  673. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  674. allocated channel: ORA_SBT_TAPE_4
  675. channel ORA_SBT_TAPE_4: SID=194 device type=SBT_TAPE
  676. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  677. allocated channel: ORA_SBT_TAPE_5
  678. channel ORA_SBT_TAPE_5: SID=148 device type=SBT_TAPE
  679. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  680. allocated channel: ORA_SBT_TAPE_6
  681. channel ORA_SBT_TAPE_6: SID=21 device type=SBT_TAPE
  682. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  683. allocated channel: ORA_SBT_TAPE_7
  684. channel ORA_SBT_TAPE_7: SID=149 device type=SBT_TAPE
  685. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  686. allocated channel: ORA_SBT_TAPE_8
  687. channel ORA_SBT_TAPE_8: SID=198 device type=SBT_TAPE
  688. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  689. skipping backup set key 204; already backed up 1 time(s)
  690. deleted backup piece
  691. backup piece handle=+FRA/orcl/backupset/2016_06_22/nnndn0_7d_users_incr0_0.291.915232659 RECID=220 STAMP=915232658
  692. Finished backup at 2016-06-22:23:18:44

  693. RMAN> list backup;


  694. List of Backup Sets
  695. ===================


  696. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  697. ------- ---- -- ---------- ----------- ------------ -------------------
  698. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  699.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  700.         Handle: 6or8lfc9_1_1   Media: station90-000019
  701.   List of Datafiles in backup set 197
  702.   File LV Type Ckp SCN    Ckp Time            Name
  703.   ---- -- ---- ---------- ------------------- ----
  704.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  705. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  706. ------- ---- -- ---------- ----------- ------------ -------------------
  707. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  708.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  709.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  710.   List of Datafiles in backup set 198
  711.   File LV Type Ckp SCN    Ckp Time            Name
  712.   ---- -- ---- ---------- ------------------- ----
  713.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  714. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  715. ------- ---- -- ---------- ----------- ------------ -------------------
  716. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  717.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  718.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  719.   List of Datafiles in backup set 199
  720.   File LV Type Ckp SCN    Ckp Time            Name
  721.   ---- -- ---- ---------- ------------------- ----
  722.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  723. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  724. ------- ---- -- ---------- ----------- ------------ -------------------
  725. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  726.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  727.         Handle: 6vr8qkce_1_1   Media: station90-000019
  728.   List of Datafiles in backup set 200
  729.   File LV Type Ckp SCN    Ckp Time            Name
  730.   ---- -- ---- ---------- ------------------- ----
  731.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  732. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  733. ------- ---- -- ---------- ----------- ------------ -------------------
  734. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  735.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  736.         Handle: 70r8qke1_1_1   Media: station90-000019
  737.   List of Datafiles in backup set 201
  738.   File LV Type Ckp SCN    Ckp Time            Name
  739.   ---- -- ---- ---------- ------------------- ----
  740.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  741. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  742. ------- ---- -- ---------- ----------- ------------ -------------------
  743. 203     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  744.         BP Key: 219   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  745.         Handle: 72r8ql8g_1_1   Media: station90-000019
  746.   List of Datafiles in backup set 203
  747.   File LV Type Ckp SCN    Ckp Time            Name
  748.   ---- -- ---- ---------- ------------------- ----
  749.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  750. RMAN> run {
  751. 2> backup  tag '8D_USERS_INCR0'  incremental level 0  tablespace users ;
  752. 3>
  753. user interrupt received

  754. user interrupt received

  755. 4>

  756. RMAN-00571: ===========================================================
  757. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  758. RMAN-00571: ===========================================================
  759. RMAN-00558: error encountered while parsing input commands
  760. RMAN-01009: syntax error: found "end-of-file": 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, }"
  761. RMAN-01007: at line 4 column 1 file: standard input

  762. RMAN>

  763. RMAN> exit


  764. Recovery Manager complete.
  765. [oracle@station90 ~]$ rman target  /

  766. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 22 23:19:36 2016

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

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

  769. RMAN> run {
  770. 2> allocate channel c1 device type disk;
  771. 3> backup  tag '8D_USERS_INCR0'  incremental level 0  tablespace users ;
  772. 4> }

  773. using target database control file instead of recovery catalog
  774. allocated channel: c1
  775. channel c1: SID=145 device type=DISK

  776. Starting backup at 2016-06-22:23:19:51
  777. channel c1: starting compressed incremental level 0 datafile backup set
  778. channel c1: specifying datafile(s) in backup set
  779. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915231377
  780. channel c1: starting piece 1 at 2016-06-22:23:19:51
  781. channel c1: finished piece 1 at 2016-06-22:23:19:52
  782. piece handle=+FRA/orcl/backupset/2016_06_22/nnndn0_8d_users_incr0_0.291.915232791 tag=8D_USERS_INCR0 comment=NONE
  783. channel c1: backup set complete, elapsed time: 00:00:01
  784. Finished backup at 2016-06-22:23:19:52
  785. released channel: c1

  786. RMAN> list backup;


  787. List of Backup Sets
  788. ===================


  789. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  790. ------- ---- -- ---------- ----------- ------------ -------------------
  791. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  792.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  793.         Handle: 6or8lfc9_1_1   Media: station90-000019
  794.   List of Datafiles in backup set 197
  795.   File LV Type Ckp SCN    Ckp Time            Name
  796.   ---- -- ---- ---------- ------------------- ----
  797.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  798. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  799. ------- ---- -- ---------- ----------- ------------ -------------------
  800. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  801.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  802.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  803.   List of Datafiles in backup set 198
  804.   File LV Type Ckp SCN    Ckp Time            Name
  805.   ---- -- ---- ---------- ------------------- ----
  806.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  807. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  808. ------- ---- -- ---------- ----------- ------------ -------------------
  809. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  810.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  811.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  812.   List of Datafiles in backup set 199
  813.   File LV Type Ckp SCN    Ckp Time            Name
  814.   ---- -- ---- ---------- ------------------- ----
  815.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  816. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  817. ------- ---- -- ---------- ----------- ------------ -------------------
  818. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  819.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  820.         Handle: 6vr8qkce_1_1   Media: station90-000019
  821.   List of Datafiles in backup set 200
  822.   File LV Type Ckp SCN    Ckp Time            Name
  823.   ---- -- ---- ---------- ------------------- ----
  824.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  825. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  826. ------- ---- -- ---------- ----------- ------------ -------------------
  827. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  828.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  829.         Handle: 70r8qke1_1_1   Media: station90-000019
  830.   List of Datafiles in backup set 201
  831.   File LV Type Ckp SCN    Ckp Time            Name
  832.   ---- -- ---- ---------- ------------------- ----
  833.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  834. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  835. ------- ---- -- ---------- ----------- ------------ -------------------
  836. 203     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  837.         BP Key: 219   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  838.         Handle: 72r8ql8g_1_1   Media: station90-000019
  839.   List of Datafiles in backup set 203
  840.   File LV Type Ckp SCN    Ckp Time            Name
  841.   ---- -- ---- ---------- ------------------- ----
  842.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  843. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  844. ------- ---- -- ---------- ----------- ------------ -------------------
  845. 205     Incr 0  1.02M      DISK        00:00:00     2016-06-22:23:19:51
  846.         BP Key: 221   Status: AVAILABLE  Compressed: YES  Tag: 8D_USERS_INCR0
  847.         Piece Name: +FRA/orcl/backupset/2016_06_22/nnndn0_8d_users_incr0_0.291.915232791
  848.   List of Datafiles in backup set 205
  849.   File LV Type Ckp SCN    Ckp Time            Name
  850.   ---- -- ---- ---------- ------------------- ----
  851.   4    0  Incr 2246580    2016-06-22:23:19:51 +DATA/orcl/datafile/users.259.915231377

  852. RMAN> backup backupset 204  force   delete input  ;

  853. Starting backup at 2016-06-22:23:20:35

  854. user interrupt received

  855. user interrupt received

  856. user interrupt received

  857. user interrupt received

  858. user interrupt received


  859. user interrupt received

  860. user interrupt received


  861. user interrupt received
  862. RMAN-00571: ===========================================================
  863. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  864. RMAN-00571: ===========================================================
  865. RMAN-03002: failure of backup command at 06/22/2016 23:20:39
  866. ORA-03111: break received on communication channel

  867. RMAN>
  868. RMAN>
  869. RMAN> exit


  870. Recovery Manager complete.
  871. [oracle@station90 ~]$ rman target  /

  872. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 22 23:20:44 2016

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

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

  875. RMAN> list backup;

  876. using target database control file instead of recovery catalog

  877. List of Backup Sets
  878. ===================


  879. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  880. ------- ---- -- ---------- ----------- ------------ -------------------
  881. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  882.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  883.         Handle: 6or8lfc9_1_1   Media: station90-000019
  884.   List of Datafiles in backup set 197
  885.   File LV Type Ckp SCN    Ckp Time            Name
  886.   ---- -- ---- ---------- ------------------- ----
  887.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  888. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  889. ------- ---- -- ---------- ----------- ------------ -------------------
  890. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  891.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  892.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  893.   List of Datafiles in backup set 198
  894.   File LV Type Ckp SCN    Ckp Time            Name
  895.   ---- -- ---- ---------- ------------------- ----
  896.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  897. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  898. ------- ---- -- ---------- ----------- ------------ -------------------
  899. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  900.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  901.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  902.   List of Datafiles in backup set 199
  903.   File LV Type Ckp SCN    Ckp Time            Name
  904.   ---- -- ---- ---------- ------------------- ----
  905.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  906. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  907. ------- ---- -- ---------- ----------- ------------ -------------------
  908. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  909.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  910.         Handle: 6vr8qkce_1_1   Media: station90-000019
  911.   List of Datafiles in backup set 200
  912.   File LV Type Ckp SCN    Ckp Time            Name
  913.   ---- -- ---- ---------- ------------------- ----
  914.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  915. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  916. ------- ---- -- ---------- ----------- ------------ -------------------
  917. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  918.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  919.         Handle: 70r8qke1_1_1   Media: station90-000019
  920.   List of Datafiles in backup set 201
  921.   File LV Type Ckp SCN    Ckp Time            Name
  922.   ---- -- ---- ---------- ------------------- ----
  923.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  924. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  925. ------- ---- -- ---------- ----------- ------------ -------------------
  926. 203     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  927.         BP Key: 219   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  928.         Handle: 72r8ql8g_1_1   Media: station90-000019
  929.   List of Datafiles in backup set 203
  930.   File LV Type Ckp SCN    Ckp Time            Name
  931.   ---- -- ---- ---------- ------------------- ----
  932.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  933. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  934. ------- ---- -- ---------- ----------- ------------ -------------------
  935. 205     Incr 0  1.02M      DISK        00:00:00     2016-06-22:23:19:51
  936.         BP Key: 221   Status: AVAILABLE  Compressed: YES  Tag: 8D_USERS_INCR0
  937.         Piece Name: +FRA/orcl/backupset/2016_06_22/nnndn0_8d_users_incr0_0.291.915232791
  938.   List of Datafiles in backup set 205
  939.   File LV Type Ckp SCN    Ckp Time            Name
  940.   ---- -- ---- ---------- ------------------- ----
  941.   4    0  Incr 2246580    2016-06-22:23:19:51 +DATA/orcl/datafile/users.259.915231377

  942. RMAN> backup backupset 205  force   delete input  ;

  943. Starting backup at 2016-06-22:23:20:51
  944. allocated channel: ORA_SBT_TAPE_1
  945. channel ORA_SBT_TAPE_1: SID=81 device type=SBT_TAPE
  946. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  947. allocated channel: ORA_SBT_TAPE_2
  948. channel ORA_SBT_TAPE_2: SID=194 device type=SBT_TAPE
  949. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  950. allocated channel: ORA_SBT_TAPE_3
  951. channel ORA_SBT_TAPE_3: SID=139 device type=SBT_TAPE
  952. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  953. allocated channel: ORA_SBT_TAPE_4
  954. channel ORA_SBT_TAPE_4: SID=9 device type=SBT_TAPE
  955. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  956. allocated channel: ORA_SBT_TAPE_5
  957. channel ORA_SBT_TAPE_5: SID=17 device type=SBT_TAPE
  958. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  959. allocated channel: ORA_SBT_TAPE_6
  960. channel ORA_SBT_TAPE_6: SID=150 device type=SBT_TAPE
  961. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  962. allocated channel: ORA_SBT_TAPE_7
  963. channel ORA_SBT_TAPE_7: SID=197 device type=SBT_TAPE
  964. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  965. allocated channel: ORA_SBT_TAPE_8
  966. channel ORA_SBT_TAPE_8: SID=75 device type=SBT_TAPE
  967. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  968. channel ORA_SBT_TAPE_1: input backup set: count=228, stamp=915232791, piece=1
  969. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-22:23:21:36
  970. channel ORA_SBT_TAPE_1: backup piece +FRA/orcl/backupset/2016_06_22/nnndn0_8d_users_incr0_0.291.915232791
  971. piece handle=74r8qm0n_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  972. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-22:23:22:01
  973. channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:00:25
  974. deleted backup piece
  975. backup piece handle=+FRA/orcl/backupset/2016_06_22/nnndn0_8d_users_incr0_0.291.915232791 RECID=221 STAMP=915232791
  976. Finished backup at 2016-06-22:23:22:01

  977. RMAN> list backup;


  978. List of Backup Sets
  979. ===================


  980. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  981. ------- ---- -- ---------- ----------- ------------ -------------------
  982. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  983.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  984.         Handle: 6or8lfc9_1_1   Media: station90-000019
  985.   List of Datafiles in backup set 197
  986.   File LV Type Ckp SCN    Ckp Time            Name
  987.   ---- -- ---- ---------- ------------------- ----
  988.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  989. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  990. ------- ---- -- ---------- ----------- ------------ -------------------
  991. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  992.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  993.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  994.   List of Datafiles in backup set 198
  995.   File LV Type Ckp SCN    Ckp Time            Name
  996.   ---- -- ---- ---------- ------------------- ----
  997.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  998. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  999. ------- ---- -- ---------- ----------- ------------ -------------------
  1000. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  1001.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  1002.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  1003.   List of Datafiles in backup set 199
  1004.   File LV Type Ckp SCN    Ckp Time            Name
  1005.   ---- -- ---- ---------- ------------------- ----
  1006.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  1007. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1008. ------- ---- -- ---------- ----------- ------------ -------------------
  1009. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  1010.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  1011.         Handle: 6vr8qkce_1_1   Media: station90-000019
  1012.   List of Datafiles in backup set 200
  1013.   File LV Type Ckp SCN    Ckp Time            Name
  1014.   ---- -- ---- ---------- ------------------- ----
  1015.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  1016. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1017. ------- ---- -- ---------- ----------- ------------ -------------------
  1018. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  1019.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  1020.         Handle: 70r8qke1_1_1   Media: station90-000019
  1021.   List of Datafiles in backup set 201
  1022.   File LV Type Ckp SCN    Ckp Time            Name
  1023.   ---- -- ---- ---------- ------------------- ----
  1024.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  1025. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1026. ------- ---- -- ---------- ----------- ------------ -------------------
  1027. 203     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  1028.         BP Key: 219   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  1029.         Handle: 72r8ql8g_1_1   Media: station90-000019
  1030.   List of Datafiles in backup set 203
  1031.   File LV Type Ckp SCN    Ckp Time            Name
  1032.   ---- -- ---- ---------- ------------------- ----
  1033.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  1034. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1035. ------- ---- -- ---------- ----------- ------------ -------------------
  1036. 205     Incr 0  1.02M      SBT_TAPE    00:00:00     2016-06-22:23:19:51
  1037.         BP Key: 222   Status: AVAILABLE  Compressed: YES  Tag: 8D_USERS_INCR0
  1038.         Handle: 74r8qm0n_1_2   Media: station90-000019
  1039.   List of Datafiles in backup set 205
  1040.   File LV Type Ckp SCN    Ckp Time            Name
  1041.   ---- -- ---- ---------- ------------------- ----
  1042.   4    0  Incr 2246580    2016-06-22:23:19:51 +DATA/orcl/datafile/users.259.915231377

  1043. RMAN> backup  tag '1T_SYSTEM_INCR0'  section size 100M   incremental level 0     tablespace system ;

  1044. Starting backup at 2016-06-22:23:24:36
  1045. using channel ORA_SBT_TAPE_1
  1046. using channel ORA_SBT_TAPE_2
  1047. using channel ORA_SBT_TAPE_3
  1048. using channel ORA_SBT_TAPE_4
  1049. using channel ORA_SBT_TAPE_5
  1050. using channel ORA_SBT_TAPE_6
  1051. using channel ORA_SBT_TAPE_7
  1052. using channel ORA_SBT_TAPE_8
  1053. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  1054. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  1055. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  1056. backing up blocks 1 through 12800
  1057. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-22:23:24:36
  1058. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  1059. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  1060. channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
  1061. channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
  1062. including current SPFILE in backup set
  1063. channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-22:23:24:37
  1064. channel ORA_SBT_TAPE_4: starting incremental level 0 datafile backup set
  1065. channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
  1066. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  1067. backing up blocks 12801 through 25600
  1068. channel ORA_SBT_TAPE_4: starting piece 2 at 2016-06-22:23:24:37
  1069. channel ORA_SBT_TAPE_5: starting incremental level 0 datafile backup set
  1070. channel ORA_SBT_TAPE_5: specifying datafile(s) in backup set
  1071. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  1072. backing up blocks 25601 through 38400
  1073. channel ORA_SBT_TAPE_5: starting piece 3 at 2016-06-22:23:24:37
  1074. channel ORA_SBT_TAPE_6: starting incremental level 0 datafile backup set
  1075. channel ORA_SBT_TAPE_6: specifying datafile(s) in backup set
  1076. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  1077. backing up blocks 38401 through 51200
  1078. channel ORA_SBT_TAPE_6: starting piece 4 at 2016-06-22:23:24:37
  1079. channel ORA_SBT_TAPE_7: starting incremental level 0 datafile backup set
  1080. channel ORA_SBT_TAPE_7: specifying datafile(s) in backup set
  1081. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  1082. backing up blocks 51201 through 64000
  1083. channel ORA_SBT_TAPE_7: starting piece 5 at 2016-06-22:23:24:37
  1084. channel ORA_SBT_TAPE_8: starting incremental level 0 datafile backup set
  1085. channel ORA_SBT_TAPE_8: specifying datafile(s) in backup set
  1086. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  1087. backing up blocks 64001 through 76800
  1088. channel ORA_SBT_TAPE_8: starting piece 6 at 2016-06-22:23:24:38
  1089. including current control file in backup set
  1090. channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-22:23:24:38
  1091. channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-22:23:25:03
  1092. piece handle=77r8qm9k_1_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1093. channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:00:26
  1094. channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
  1095. channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
  1096. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  1097. backing up blocks 76801 through 89600
  1098. channel ORA_SBT_TAPE_3: starting piece 7 at 2016-06-22:23:25:03
  1099. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-22:23:25:06
  1100. piece handle=75r8qm9k_1_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1101. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:30
  1102. channel ORA_SBT_TAPE_4: finished piece 2 at 2016-06-22:23:25:28
  1103. piece handle=75r8qm9k_2_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1104. channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:00:51
  1105. channel ORA_SBT_TAPE_7: finished piece 5 at 2016-06-22:23:25:38
  1106. piece handle=75r8qm9k_5_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1107. channel ORA_SBT_TAPE_7: backup set complete, elapsed time: 00:01:01
  1108. channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-22:23:26:07
  1109. piece handle=76r8qm9k_1_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1110. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:29
  1111. channel ORA_SBT_TAPE_5: finished piece 3 at 2016-06-22:23:26:07
  1112. piece handle=75r8qm9k_3_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1113. channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:01:30
  1114. channel ORA_SBT_TAPE_6: finished piece 4 at 2016-06-22:23:26:27
  1115. piece handle=75r8qm9k_4_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1116. channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:01:50
  1117. channel ORA_SBT_TAPE_8: finished piece 6 at 2016-06-22:23:26:27
  1118. piece handle=75r8qm9k_6_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1119. channel ORA_SBT_TAPE_8: backup set complete, elapsed time: 00:01:49
  1120. channel ORA_SBT_TAPE_3: finished piece 7 at 2016-06-22:23:26:47
  1121. piece handle=75r8qm9k_7_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1122. channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:01:44
  1123. Finished backup at 2016-06-22:23:26:47

  1124. RMAN> list backup of tablespace system ;


  1125. List of Backup Sets
  1126. ===================


  1127. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1128. ------- ---- -- ---------- ----------- ------------ -------------------
  1129. 207     Incr 0  605.25M    SBT_TAPE    00:02:06     2016-06-22:23:26:42
  1130.   List of Datafiles in backup set 207
  1131.   File LV Type Ckp SCN    Ckp Time            Name
  1132.   ---- -- ---- ---------- ------------------- ----
  1133.   1    0  Incr 2246939    2016-06-22:23:24:36 +DATA/orcl/datafile/system.256.914102913

  1134.   Backup Set Copy #1 of backup set 207
  1135.   Device Type Elapsed Time Completion Time     Compressed Tag
  1136.   ----------- ------------ ------------------- ---------- ---
  1137.   SBT_TAPE    00:02:06     2016-06-22:23:26:42 NO         1T_SYSTEM_INCR0

  1138.     List of Backup Pieces for backup set 207 Copy #1
  1139.     BP Key  Pc# Status      Media                   Piece Name
  1140.     ------- --- ----------- ----------------------- ----------
  1141.     224     1   AVAILABLE   station90-000019        75r8qm9k_1_1
  1142.     225     2   AVAILABLE   station90-000020        75r8qm9k_2_1
  1143.     228     3   AVAILABLE   station90-000019        75r8qm9k_3_1
  1144.     229     4   AVAILABLE   station90-000020        75r8qm9k_4_1
  1145.     226     5   AVAILABLE   station90-000019        75r8qm9k_5_1
  1146.     230     6   AVAILABLE   station90-000019        75r8qm9k_6_1
  1147.     231     7   AVAILABLE   station90-000020        75r8qm9k_7_1

  1148. RMAN> validate datafile 1 ;

  1149. Starting validate at 2016-06-22:23:30:37
  1150. released channel: ORA_SBT_TAPE_1
  1151. released channel: ORA_SBT_TAPE_2
  1152. released channel: ORA_SBT_TAPE_3
  1153. released channel: ORA_SBT_TAPE_4
  1154. released channel: ORA_SBT_TAPE_5
  1155. released channel: ORA_SBT_TAPE_6
  1156. released channel: ORA_SBT_TAPE_7
  1157. released channel: ORA_SBT_TAPE_8
  1158. allocated channel: ORA_DISK_1
  1159. channel ORA_DISK_1: SID=81 device type=DISK
  1160. allocated channel: ORA_DISK_2
  1161. channel ORA_DISK_2: SID=194 device type=DISK
  1162. allocated channel: ORA_DISK_3





复制代码
select  * from v$block_change_tracking;

alter database disable block change tracking;

alter database enable block change tracking using file '+FRA';

select  * from v$restore_point;
  1. channel ORA_DISK_3: SID=139 device type=DISK
  2. allocated channel: ORA_DISK_4
  3. channel ORA_DISK_4: SID=9 device type=DISK
  4. allocated channel: ORA_DISK_5
  5. channel ORA_DISK_5: SID=17 device type=DISK
  6. allocated channel: ORA_DISK_6
  7. channel ORA_DISK_6: SID=150 device type=DISK
  8. allocated channel: ORA_DISK_7
  9. channel ORA_DISK_7: SID=197 device type=DISK
  10. allocated channel: ORA_DISK_8
  11. channel ORA_DISK_8: SID=75 device type=DISK
  12. channel ORA_DISK_1: starting validation of datafile
  13. channel ORA_DISK_1: specifying datafile(s) for validation
  14. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  15. channel ORA_DISK_2: starting validation of datafile
  16. channel ORA_DISK_2: specifying datafile(s) for validation
  17. including current SPFILE in backup set
  18. channel ORA_DISK_3: starting validation of datafile
  19. channel ORA_DISK_3: specifying datafile(s) for validation
  20. including current control file for validation
  21. channel ORA_DISK_2: validation complete, elapsed time: 00:00:00
  22. List of Control File and SPFILE
  23. ===============================
  24. File Type    Status Blocks Failing Blocks Examined
  25. ------------ ------ -------------- ---------------
  26. SPFILE       OK     0              2               
  27. channel ORA_DISK_3: validation complete, elapsed time: 00:00:01
  28. List of Control File and SPFILE
  29. ===============================
  30. File Type    Status Blocks Failing Blocks Examined
  31. ------------ ------ -------------- ---------------
  32. Control File OK     0              614            
  33. channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
  34. List of Datafiles
  35. =================
  36. File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
  37. ---- ------ -------------- ------------ --------------- ----------
  38. 1    OK     0              13302        89611           2247313   
  39.   File Name: +DATA/orcl/datafile/system.256.914102913
  40.   Block Type Blocks Failing Blocks Processed
  41.   ---------- -------------- ----------------
  42.   Data       0              60322           
  43.   Index      0              12401           
  44.   Other      0              3575            

  45. Finished validate at 2016-06-22:23:30:54

  46. RMAN> validate datafile 1  section size 100M  ;

  47. Starting validate at 2016-06-22:23:32:31
  48. using channel ORA_DISK_1
  49. using channel ORA_DISK_2
  50. using channel ORA_DISK_3
  51. using channel ORA_DISK_4
  52. using channel ORA_DISK_5
  53. using channel ORA_DISK_6
  54. using channel ORA_DISK_7
  55. using channel ORA_DISK_8
  56. channel ORA_DISK_1: starting validation of datafile
  57. channel ORA_DISK_1: specifying datafile(s) for validation
  58. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  59. validating blocks 1 through 12800
  60. channel ORA_DISK_2: starting validation of datafile
  61. channel ORA_DISK_2: specifying datafile(s) for validation
  62. including current SPFILE in backup set
  63. channel ORA_DISK_3: starting validation of datafile
  64. channel ORA_DISK_3: specifying datafile(s) for validation
  65. including current control file for validation
  66. channel ORA_DISK_2: validation complete, elapsed time: 00:00:00
  67. List of Control File and SPFILE
  68. ===============================
  69. File Type    Status Blocks Failing Blocks Examined
  70. ------------ ------ -------------- ---------------
  71. SPFILE       OK     0              2               
  72. channel ORA_DISK_2: starting validation of datafile
  73. channel ORA_DISK_2: specifying datafile(s) for validation
  74. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  75. validating blocks 12801 through 25600
  76. channel ORA_DISK_4: starting validation of datafile
  77. channel ORA_DISK_4: specifying datafile(s) for validation
  78. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  79. validating blocks 25601 through 38400
  80. channel ORA_DISK_5: starting validation of datafile
  81. channel ORA_DISK_5: specifying datafile(s) for validation
  82. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  83. validating blocks 38401 through 51200
  84. channel ORA_DISK_6: starting validation of datafile
  85. channel ORA_DISK_6: specifying datafile(s) for validation
  86. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  87. validating blocks 51201 through 64000
  88. channel ORA_DISK_7: starting validation of datafile
  89. channel ORA_DISK_7: specifying datafile(s) for validation
  90. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  91. validating blocks 64001 through 76800
  92. channel ORA_DISK_8: starting validation of datafile
  93. channel ORA_DISK_8: specifying datafile(s) for validation
  94. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  95. validating blocks 76801 through 89600
  96. channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
  97. channel ORA_DISK_2: validation complete, elapsed time: 00:00:01
  98. channel ORA_DISK_3: validation complete, elapsed time: 00:00:02
  99. List of Control File and SPFILE
  100. ===============================
  101. File Type    Status Blocks Failing Blocks Examined
  102. ------------ ------ -------------- ---------------
  103. Control File OK     0              614            
  104. channel ORA_DISK_4: validation complete, elapsed time: 00:00:01
  105. channel ORA_DISK_5: validation complete, elapsed time: 00:00:01
  106. channel ORA_DISK_6: validation complete, elapsed time: 00:00:01
  107. channel ORA_DISK_7: validation complete, elapsed time: 00:00:01
  108. channel ORA_DISK_8: validation complete, elapsed time: 00:00:01
  109. List of Datafiles
  110. =================
  111. File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
  112. ---- ------ -------------- ------------ --------------- ----------
  113. 1    OK     0              13302        89605           2247483   
  114.   File Name: +DATA/orcl/datafile/system.256.914102913
  115.   Block Type Blocks Failing Blocks Processed
  116.   ---------- -------------- ----------------
  117.   Data       0              60322           
  118.   Index      0              12401           
  119.   Other      0              3569            

  120. Finished validate at 2016-06-22:23:32:35

  121. RMAN>
  122. user interrupt received

  123. user interrupt received


  124. RMAN>

  125. RMAN>

  126. RMAN> exit


  127. Recovery Manager complete.
  128. [oracle@station90 ~]$ rman target  /

  129. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 22 23:47:44 2016

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

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

  132. RMAN> backup tag '9T_USERS_INCR0' incremental level 0 tablespace users keep forever;

  133. Starting backup at 2016-06-22:23:48:51
  134. current log archived

  135. using target database control file instead of recovery catalog
  136. allocated channel: ORA_SBT_TAPE_1
  137. channel ORA_SBT_TAPE_1: SID=75 device type=SBT_TAPE
  138. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  139. allocated channel: ORA_SBT_TAPE_2
  140. channel ORA_SBT_TAPE_2: SID=197 device type=SBT_TAPE
  141. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  142. allocated channel: ORA_SBT_TAPE_3
  143. channel ORA_SBT_TAPE_3: SID=150 device type=SBT_TAPE
  144. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  145. allocated channel: ORA_SBT_TAPE_4
  146. channel ORA_SBT_TAPE_4: SID=20 device type=SBT_TAPE
  147. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  148. allocated channel: ORA_SBT_TAPE_5
  149. channel ORA_SBT_TAPE_5: SID=148 device type=SBT_TAPE
  150. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  151. allocated channel: ORA_SBT_TAPE_6
  152. channel ORA_SBT_TAPE_6: SID=145 device type=SBT_TAPE
  153. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  154. allocated channel: ORA_SBT_TAPE_7
  155. channel ORA_SBT_TAPE_7: SID=206 device type=SBT_TAPE
  156. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  157. allocated channel: ORA_SBT_TAPE_8
  158. channel ORA_SBT_TAPE_8: SID=71 device type=SBT_TAPE
  159. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  160. RMAN-00571: ===========================================================
  161. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  162. RMAN-00571: ===========================================================
  163. RMAN-03002: failure of backup command at 06/22/2016 23:49:35
  164. RMAN-06522: KEEP FOREVER option is not supported without the recovery catalog

  165. RMAN> exit


  166. Recovery Manager complete.
  167. [oracle@station90 ~]$ rman target  /  catalog u90/oracle_4U@rcat

  168. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 22 23:50:35 2016

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

  170. connected to target database: ORCL (DBID=1343950367)
  171. RMAN-00571: ===========================================================
  172. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  173. RMAN-00571: ===========================================================
  174. RMAN-00554: initialization of internal recovery manager package failed
  175. RMAN-04004: error from recovery catalog database: ORA-01017: invalid username/password; logon denied
  176. [oracle@station90 ~]$ . oraenv
  177. ORACLE_SID = [orcl] ? rcat
  178. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
  179. [oracle@station90 ~]$ sqlplus /nolog

  180. SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 22 23:50:51 2016

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

  182. SQL> conn / as sysdba
  183. Connected.
  184. SQL> create user u90 identified by oracle_4U default tablespace rcat quota unlimited on rcat ;

  185. User created.

  186. SQL> grant recovery_catalog_owner to u90;

  187. Grant succeeded.

  188. SQL> exit
  189. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  190. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  191. [oracle@station90 ~]$ . oraenv
  192. ORACLE_SID = [rcat] ? orcl
  193. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
  194. [oracle@station90 ~]$ rman target  /  catalog u90/oracle_4U@rcat

  195. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 22 23:51:50 2016

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

  197. connected to target database: ORCL (DBID=1343950367)
  198. connected to recovery catalog database

  199. RMAN> create catalog

  200. ;
  201. recovery catalog created

  202. RMAN>
  203. RMAN-00571: ===========================================================
  204. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  205. RMAN-00571: ===========================================================
  206. RMAN-00558: error encountered while parsing input commands
  207. RMAN-01009: syntax error: found ";": expecting one of: "advise, allocate, alter, backup, @, catalog, change, configure, connect, convert, copy, create, crosscheck, delete, drop, duplicate, exit, flashback, grant, host, import, list, mount, open, print, quit, recover, register, release, repair, replace, report, reset, restore, resync, revoke, run, send, set, show, shutdown, spool, sql, startup, switch, transport, unregister, upgrade, validate, {, "
  208. RMAN-01007: at line 1 column 1 file: standard input

  209. RMAN> register database ;

  210. database registered in recovery catalog
  211. starting full resync of recovery catalog
  212. full resync complete

  213. RMAN> exit


  214. Recovery Manager complete.
  215. [oracle@station90 ~]$ rman target  /  catalog u90/oracle_4U@rcat

  216. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 22 23:52:29 2016

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

  218. connected to target database: ORCL (DBID=1343950367)
  219. connected to recovery catalog database

  220. RMAN> backup tag '9T_USERS_INCR0' incremental level 0 tablespace users keep forever;

  221. Starting backup at 2016-06-22:23:52:34
  222. current log archived

  223. allocated channel: ORA_SBT_TAPE_1
  224. channel ORA_SBT_TAPE_1: SID=148 device type=SBT_TAPE
  225. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  226. allocated channel: ORA_SBT_TAPE_2
  227. channel ORA_SBT_TAPE_2: SID=20 device type=SBT_TAPE
  228. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  229. allocated channel: ORA_SBT_TAPE_3
  230. channel ORA_SBT_TAPE_3: SID=150 device type=SBT_TAPE
  231. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  232. allocated channel: ORA_SBT_TAPE_4
  233. channel ORA_SBT_TAPE_4: SID=145 device type=SBT_TAPE
  234. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  235. allocated channel: ORA_SBT_TAPE_5
  236. channel ORA_SBT_TAPE_5: SID=9 device type=SBT_TAPE
  237. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  238. allocated channel: ORA_SBT_TAPE_6
  239. channel ORA_SBT_TAPE_6: SID=149 device type=SBT_TAPE
  240. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  241. allocated channel: ORA_SBT_TAPE_7
  242. channel ORA_SBT_TAPE_7: SID=212 device type=SBT_TAPE
  243. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  244. allocated channel: ORA_SBT_TAPE_8
  245. channel ORA_SBT_TAPE_8: SID=81 device type=SBT_TAPE
  246. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  247. backup will never be obsolete
  248. archived logs required to recover from this backup will be backed up
  249. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  250. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  251. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915231377
  252. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-22:23:53:19
  253. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-22:23:53:44
  254. piece handle=7qr8qnvf_1_1 tag=9T_USERS_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  255. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25

  256. using channel ORA_SBT_TAPE_1
  257. using channel ORA_SBT_TAPE_2
  258. using channel ORA_SBT_TAPE_3
  259. using channel ORA_SBT_TAPE_4
  260. using channel ORA_SBT_TAPE_5
  261. using channel ORA_SBT_TAPE_6
  262. using channel ORA_SBT_TAPE_7
  263. using channel ORA_SBT_TAPE_8
  264. backup will never be obsolete
  265. archived logs required to recover from this backup will be backed up
  266. channel ORA_SBT_TAPE_1: starting full datafile backup set
  267. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  268. including current SPFILE in backup set
  269. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-22:23:53:45
  270. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-22:23:54:10
  271. piece handle=7rr8qo08_1_1 tag=9T_USERS_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  272. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25

  273. current log archived
  274. using channel ORA_SBT_TAPE_1
  275. using channel ORA_SBT_TAPE_2
  276. using channel ORA_SBT_TAPE_3
  277. using channel ORA_SBT_TAPE_4
  278. using channel ORA_SBT_TAPE_5
  279. using channel ORA_SBT_TAPE_6
  280. using channel ORA_SBT_TAPE_7
  281. using channel ORA_SBT_TAPE_8
  282. backup will never be obsolete
  283. archived logs required to recover from this backup will be backed up
  284. channel ORA_SBT_TAPE_1: starting archived log backup set
  285. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  286. input archived log thread=1 sequence=149 RECID=391 STAMP=915234850
  287. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-22:23:54:12
  288. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-22:23:54:37
  289. piece handle=7sr8qo14_1_1 tag=9T_USERS_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  290. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25

  291. using channel ORA_SBT_TAPE_1
  292. using channel ORA_SBT_TAPE_2
  293. using channel ORA_SBT_TAPE_3
  294. using channel ORA_SBT_TAPE_4
  295. using channel ORA_SBT_TAPE_5
  296. using channel ORA_SBT_TAPE_6
  297. using channel ORA_SBT_TAPE_7
  298. using channel ORA_SBT_TAPE_8
  299. backup will never be obsolete
  300. archived logs required to recover from this backup will be backed up
  301. channel ORA_SBT_TAPE_1: starting full datafile backup set
  302. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  303. including current control file in backup set
  304. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-22:23:54:38
  305. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-22:23:55:03
  306. piece handle=7tr8qo1t_1_1 tag=9T_USERS_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  307. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  308. Finished backup at 2016-06-22:23:55:03

  309. RMAN> list backup;


  310. List of Backup Sets
  311. ===================


  312. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  313. ------- ---- -- ---------- ----------- ------------ -------------------
  314. 661     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  315.         BP Key: 673   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  316.         Handle: 6or8lfc9_1_1   Media: station90-000019
  317.   List of Datafiles in backup set 661
  318.   File LV Type Ckp SCN    Ckp Time            Name
  319.   ---- -- ---- ---------- ------------------- ----
  320.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  321. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  322. ------- ---- -- ---------- ----------- ------------ -------------------
  323. 662     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  324.         BP Key: 674   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  325.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  326.   List of Datafiles in backup set 662
  327.   File LV Type Ckp SCN    Ckp Time            Name
  328.   ---- -- ---- ---------- ------------------- ----
  329.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  330. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  331. ------- ---- -- ---------- ----------- ------------ -------------------
  332. 663     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  333.         BP Key: 675   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  334.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  335.   List of Datafiles in backup set 663
  336.   File LV Type Ckp SCN    Ckp Time            Name
  337.   ---- -- ---- ---------- ------------------- ----
  338.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  339. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  340. ------- ---- -- ---------- ----------- ------------ -------------------
  341. 664     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  342.         BP Key: 676   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  343.         Handle: 6vr8qkce_1_1   Media: station90-000019
  344.   List of Datafiles in backup set 664
  345.   File LV Type Ckp SCN    Ckp Time            Name
  346.   ---- -- ---- ---------- ------------------- ----
  347.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  348. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  349. ------- ---- -- ---------- ----------- ------------ -------------------
  350. 665     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  351.         BP Key: 677   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  352.         Handle: 70r8qke1_1_1   Media: station90-000019
  353.   List of Datafiles in backup set 665
  354.   File LV Type Ckp SCN    Ckp Time            Name
  355.   ---- -- ---- ---------- ------------------- ----
  356.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  357. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  358. ------- ---- -- ---------- ----------- ------------ -------------------
  359. 666     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  360.         BP Key: 678   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  361.         Handle: 72r8ql8g_1_1   Media: station90-000019
  362.   List of Datafiles in backup set 666
  363.   File LV Type Ckp SCN    Ckp Time            Name
  364.   ---- -- ---- ---------- ------------------- ----
  365.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  366. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  367. ------- ---- -- ---------- ----------- ------------ -------------------
  368. 668     Incr 0  1.02M      SBT_TAPE    00:00:00     2016-06-22:23:19:51
  369.         BP Key: 679   Status: AVAILABLE  Compressed: YES  Tag: 8D_USERS_INCR0
  370.         Handle: 74r8qm0n_1_2   Media: station90-000019
  371.   List of Datafiles in backup set 668
  372.   File LV Type Ckp SCN    Ckp Time            Name
  373.   ---- -- ---- ---------- ------------------- ----
  374.   4    0  Incr 2246580    2016-06-22:23:19:51 +DATA/orcl/datafile/users.259.915231377

  375. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  376. ------- ---- -- ---------- ----------- ------------ -------------------
  377. 669     Incr 0  256.00K    SBT_TAPE    00:00:26     2016-06-22:23:25:02
  378.         BP Key: 680   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
  379.         Handle: 77r8qm9k_1_1   Media: station90-000020
  380.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  381.   SPFILE db_unique_name: ORCL

  382. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  383. ------- ---- -- ---------- ----------- ------------ -------------------
  384. 670     Incr 0  605.25M    SBT_TAPE    00:02:06     2016-06-22:23:26:42
  385.   List of Datafiles in backup set 670
  386.   File LV Type Ckp SCN    Ckp Time            Name
  387.   ---- -- ---- ---------- ------------------- ----
  388.   1    0  Incr 2246939    2016-06-22:23:24:36 +DATA/orcl/datafile/system.256.914102913

  389.   Backup Set Copy #1 of backup set 670
  390.   Device Type Elapsed Time Completion Time     Compressed Tag
  391.   ----------- ------------ ------------------- ---------- ---
  392.   SBT_TAPE    00:02:06     2016-06-22:23:26:42 NO         1T_SYSTEM_INCR0

  393.     List of Backup Pieces for backup set 670 Copy #1
  394.     BP Key  Pc# Status      Media                   Piece Name
  395.     ------- --- ----------- ----------------------- ----------
  396.     681     1   AVAILABLE   station90-000019        75r8qm9k_1_1
  397.     682     2   AVAILABLE   station90-000020        75r8qm9k_2_1
  398.     685     3   AVAILABLE   station90-000019        75r8qm9k_3_1
  399.     686     4   AVAILABLE   station90-000020        75r8qm9k_4_1
  400.     683     5   AVAILABLE   station90-000019        75r8qm9k_5_1
  401.     687     6   AVAILABLE   station90-000019        75r8qm9k_6_1
  402.     688     7   AVAILABLE   station90-000020        75r8qm9k_7_1

  403. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  404. ------- ---- -- ---------- ----------- ------------ -------------------
  405. 671     Incr 0  9.75M      SBT_TAPE    00:01:21     2016-06-22:23:25:57
  406.         BP Key: 684   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
  407.         Handle: 76r8qm9k_1_1   Media: station90-000020
  408.   Control File Included: Ckp SCN: 2246940      Ckp time: 2016-06-22:23:24:36

  409. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  410. ------- ---- -- ---------- ----------- ------------ -------------------
  411. 835     Incr 0  1.50M      SBT_TAPE    00:00:24     2016-06-22:23:53:43
  412.         BP Key: 838   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  413.         Handle: 7qr8qnvf_1_1   Media: station90-000019
  414.         Keep: BACKUP_LOGS        Until: FOREVER        
  415.   List of Datafiles in backup set 835
  416.   File LV Type Ckp SCN    Ckp Time            Name
  417.   ---- -- ---- ---------- ------------------- ----
  418.   4    0  Incr 2248807    2016-06-22:23:53:19 +DATA/orcl/datafile/users.259.915231377

  419. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  420. ------- ---- -- ---------- ----------- ------------ -------------------
  421. 836     Full    256.00K    SBT_TAPE    00:00:16     2016-06-22:23:54:00
  422.         BP Key: 839   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  423.         Handle: 7rr8qo08_1_1   Media: station90-000019
  424.         Keep: BACKUP_LOGS        Until: FOREVER        
  425.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  426.   SPFILE db_unique_name: ORCL

  427. BS Key  Size       Device Type Elapsed Time Completion Time   
  428. ------- ---------- ----------- ------------ -------------------
  429. 907     256.00K    SBT_TAPE    00:00:15     2016-06-22:23:54:27
  430.         BP Key: 910   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  431.         Handle: 7sr8qo14_1_1   Media: station90-000019
  432.         Keep: BACKUP_LOGS        Until: FOREVER        

  433.   List of Archived Logs in backup set 907
  434.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  435.   ---- ------- ---------- ------------------- ---------- ---------
  436.   1    149     2248741    2016-06-22:23:52:34 2248837    2016-06-22:23:54:10

  437. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  438. ------- ---- -- ---------- ----------- ------------ -------------------
  439. 908     Full    9.75M      SBT_TAPE    00:00:16     2016-06-22:23:54:53
  440.         BP Key: 911   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  441.         Handle: 7tr8qo1t_1_1   Media: station90-000019
  442.         Keep: BACKUP_LOGS        Until: FOREVER        
  443.   Control File Included: Ckp SCN: 2248924      Ckp time: 2016-06-22:23:54:37

  444. RMAN> run {
  445. 2>
  446. user interrupt received
  447. allocate channel c1 devic

  448. RMAN-00571: ===========================================================
  449. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  450. RMAN-00571: ===========================================================
  451. RMAN-00558: error encountered while parsing input commands
  452. RMAN-01009: syntax error: found "identifier": expecting one of: "device, type"
  453. RMAN-01008: the bad identifier was: devic
  454. RMAN-01007: at line 2 column 21 file: standard input

  455. RMAN>

  456. RMAN>

  457. RMAN> show all;

  458. RMAN configuration parameters for database with db_unique_name ORCL are:
  459. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  460. CONFIGURE BACKUP OPTIMIZATION ON;
  461. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  462. CONFIGURE CONTROLFILE AUTOBACKUP OFF;
  463. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  464. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  465. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO COMPRESSED BACKUPSET;
  466. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  467. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  468. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  469. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  470. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  471. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  472. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  473. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  474. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  475. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  476. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  477. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  478. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  479. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  480. CONFIGURE ENCRYPTION FOR DATABASE ON;
  481. CONFIGURE ENCRYPTION ALGORITHM 'AES256';
  482. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  483. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  484. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  485. RMAN> CONFIGURE DEFAULT DEVICE TYPE TO   disk;

  486. old RMAN configuration parameters:
  487. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  488. new RMAN configuration parameters:
  489. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  490. new RMAN configuration parameters are successfully stored
  491. RMAN-00571: ===========================================================
  492. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  493. RMAN-00571: ===========================================================
  494. RMAN-03002: failure of configure command at 06/22/2016 23:58:37
  495. ORA-01013: user requested cancel of current operation

  496. RMAN> CONFIGURE DEFAULT DEVICE TYPE TO   disk;


  497. starting full resync of recovery catalog
  498. full resync complete
  499. old RMAN configuration parameters:
  500. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  501. new RMAN configuration parameters:
  502. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  503. new RMAN configuration parameters are successfully stored
  504. released channel: ORA_SBT_TAPE_1
  505. RMAN-00571: ===========================================================
  506. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  507. RMAN-00571: ===========================================================
  508. RMAN-03002: failure of configure command at 06/22/2016 23:58:47
  509. ORA-01013: user requested cancel of current operation

  510. RMAN>
  511. RMAN>

  512. RMAN> exit


  513. Recovery Manager complete.
  514. [oracle@station90 ~]$
  515. [oracle@station90 ~]$ rman target  /  catalog u90/oracle_4U@rcat

  516. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 22 23:58:51 2016

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

  518. connected to target database: ORCL (DBID=1343950367)
  519. connected to recovery catalog database

  520. RMAN> CONFIGURE DEFAULT DEVICE TYPE TO   disk;

  521. old RMAN configuration parameters:
  522. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  523. new RMAN configuration parameters:
  524. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  525. new RMAN configuration parameters are successfully stored
  526. starting full resync of recovery catalog
  527. full resync complete

  528. RMAN> backup tag '10T_USERS_INCR0' incremental level 0 tablespace users keep forever;

  529. Starting backup at 2016-06-22:23:59:24
  530. current log archived

  531. allocated channel: ORA_DISK_1
  532. channel ORA_DISK_1: SID=17 device type=DISK
  533. allocated channel: ORA_DISK_2
  534. channel ORA_DISK_2: SID=145 device type=DISK
  535. allocated channel: ORA_DISK_3
  536. channel ORA_DISK_3: SID=194 device type=DISK
  537. allocated channel: ORA_DISK_4
  538. channel ORA_DISK_4: SID=9 device type=DISK
  539. allocated channel: ORA_DISK_5
  540. channel ORA_DISK_5: SID=81 device type=DISK
  541. allocated channel: ORA_DISK_6
  542. channel ORA_DISK_6: SID=149 device type=DISK
  543. allocated channel: ORA_DISK_7
  544. channel ORA_DISK_7: SID=203 device type=DISK
  545. allocated channel: ORA_DISK_8
  546. channel ORA_DISK_8: SID=20 device type=DISK
  547. backup will never be obsolete
  548. archived logs required to recover from this backup will be backed up
  549. channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set
  550. channel ORA_DISK_1: specifying datafile(s) in backup set
  551. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915231377
  552. channel ORA_DISK_1: starting piece 1 at 2016-06-22:23:59:27
  553. RMAN-00571: ===========================================================
  554. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  555. RMAN-00571: ===========================================================
  556. RMAN-03002: failure of backup command at 06/22/2016 23:59:28
  557. ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes

  558. RMAN> run
  559. 2> {
  560. 3> allocate channel c1 device type disk format '/home/oracle/manual_backup/%U.bkp';
  561. 4> backup tag '10T_USERS_INCR0' incremental level 0 tablespace users keep forever;
  562. 5> }

  563. released channel: ORA_DISK_1
  564. released channel: ORA_DISK_2
  565. released channel: ORA_DISK_3
  566. released channel: ORA_DISK_4
  567. released channel: ORA_DISK_5
  568. released channel: ORA_DISK_6
  569. released channel: ORA_DISK_7
  570. released channel: ORA_DISK_8
  571. allocated channel: c1
  572. channel c1: SID=17 device type=DISK

  573. Starting backup at 2016-06-23:00:00:16
  574. current log archived

  575. backup will never be obsolete
  576. archived logs required to recover from this backup will be backed up
  577. channel c1: starting compressed incremental level 0 datafile backup set
  578. channel c1: specifying datafile(s) in backup set
  579. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915231377
  580. channel c1: starting piece 1 at 2016-06-23:00:00:18
  581. channel c1: finished piece 1 at 2016-06-23:00:00:19
  582. piece handle=/home/oracle/manual_backup/7vr8qoci_1_1.bkp tag=10T_USERS_INCR0 comment=NONE
  583. channel c1: backup set complete, elapsed time: 00:00:01

  584. backup will never be obsolete
  585. archived logs required to recover from this backup will be backed up
  586. channel c1: starting compressed full datafile backup set
  587. channel c1: specifying datafile(s) in backup set
  588. including current SPFILE in backup set
  589. channel c1: starting piece 1 at 2016-06-23:00:00:19
  590. channel c1: finished piece 1 at 2016-06-23:00:00:20
  591. piece handle=/home/oracle/manual_backup/80r8qocj_1_1.bkp tag=10T_USERS_INCR0 comment=NONE
  592. channel c1: backup set complete, elapsed time: 00:00:01

  593. current log archived
  594. backup will never be obsolete
  595. archived logs required to recover from this backup will be backed up
  596. channel c1: starting compressed archived log backup set
  597. channel c1: specifying archived log(s) in backup set
  598. input archived log thread=1 sequence=152 RECID=397 STAMP=915235223
  599. channel c1: starting piece 1 at 2016-06-23:00:00:24
  600. channel c1: finished piece 1 at 2016-06-23:00:00:25
  601. piece handle=/home/oracle/manual_backup/81r8qoco_1_1.bkp tag=10T_USERS_INCR0 comment=NONE
  602. channel c1: backup set complete, elapsed time: 00:00:01

  603. backup will never be obsolete
  604. archived logs required to recover from this backup will be backed up
  605. channel c1: starting compressed full datafile backup set
  606. channel c1: specifying datafile(s) in backup set
  607. including current control file in backup set
  608. channel c1: starting piece 1 at 2016-06-23:00:00:26
  609. channel c1: finished piece 1 at 2016-06-23:00:00:27
  610. piece handle=/home/oracle/manual_backup/82r8qocp_1_1.bkp tag=10T_USERS_INCR0 comment=NONE
  611. channel c1: backup set complete, elapsed time: 00:00:01
  612. Finished backup at 2016-06-23:00:00:27
  613. released channel: c1

  614. RMAN> backup tag '11T_USERS_INCR0' incremental level 0 tablespace users keep  until time 'sysdate + 365'  restore point rsp2;

  615. Starting backup at 2016-06-23:00:01:40
  616. current log archived

  617. allocated channel: ORA_DISK_1
  618. channel ORA_DISK_1: SID=17 device type=DISK
  619. allocated channel: ORA_DISK_2
  620. channel ORA_DISK_2: SID=145 device type=DISK
  621. allocated channel: ORA_DISK_3
  622. channel ORA_DISK_3: SID=194 device type=DISK
  623. allocated channel: ORA_DISK_4
  624. channel ORA_DISK_4: SID=9 device type=DISK
  625. allocated channel: ORA_DISK_5
  626. channel ORA_DISK_5: SID=81 device type=DISK
  627. allocated channel: ORA_DISK_6
  628. channel ORA_DISK_6: SID=149 device type=DISK
  629. allocated channel: ORA_DISK_7
  630. channel ORA_DISK_7: SID=203 device type=DISK
  631. allocated channel: ORA_DISK_8
  632. channel ORA_DISK_8: SID=20 device type=DISK
  633. backup will be obsolete on date 2017-06-23:00:01:45
  634. archived logs required to recover from this backup will be backed up
  635. channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set
  636. channel ORA_DISK_1: specifying datafile(s) in backup set
  637. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915231377
  638. channel ORA_DISK_1: starting piece 1 at 2016-06-23:00:01:45
  639. RMAN-00571: ===========================================================
  640. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  641. RMAN-00571: ===========================================================
  642. RMAN-03002: failure of backup command at 06/23/2016 00:01:46
  643. ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes

  644. RMAN> exit


  645. Recovery Manager complete.

  646. [oracle@station90 ~]$
  647. [oracle@station90 ~]$ rman target  /  

  648. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 23 00:02:03 2016

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

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

  651. RMAN> run {
  652. 2> allocate channel c1 device type disk format '/home/oracle/manual_backup/%U.bkp';
  653. 3> backup tag '11T_USERS_INCR0' incremental level 0 tablespace users keep  until time 'sysdate + 365'  restore point rsp2;
  654. 4> }

  655. using target database control file instead of recovery catalog
  656. allocated channel: c1
  657. channel c1: SID=145 device type=DISK

  658. Starting backup at 2016-06-23:00:02:41
  659. current log archived

  660. backup will be obsolete on date 2017-06-23:00:02:44
  661. archived logs required to recover from this backup will be backed up
  662. channel c1: starting compressed incremental level 0 datafile backup set
  663. channel c1: specifying datafile(s) in backup set
  664. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915231377
  665. channel c1: starting piece 1 at 2016-06-23:00:02:44
  666. channel c1: finished piece 1 at 2016-06-23:00:02:45
  667. piece handle=/home/oracle/manual_backup/84r8qoh4_1_1.bkp tag=11T_USERS_INCR0 comment=NONE
  668. channel c1: backup set complete, elapsed time: 00:00:01

  669. backup will be obsolete on date 2017-06-23:00:02:45
  670. archived logs required to recover from this backup will be backed up
  671. channel c1: starting compressed full datafile backup set
  672. channel c1: specifying datafile(s) in backup set
  673. including current SPFILE in backup set
  674. channel c1: starting piece 1 at 2016-06-23:00:02:45
  675. channel c1: finished piece 1 at 2016-06-23:00:02:46
  676. piece handle=/home/oracle/manual_backup/85r8qoh5_1_1.bkp tag=11T_USERS_INCR0 comment=NONE
  677. channel c1: backup set complete, elapsed time: 00:00:01


  678. current log archived
  679. backup will be obsolete on date 2017-06-23:00:02:50
  680. archived logs required to recover from this backup will be backed up
  681. channel c1: starting compressed archived log backup set
  682. channel c1: specifying archived log(s) in backup set
  683. input archived log thread=1 sequence=155 RECID=403 STAMP=915235369
  684. channel c1: starting piece 1 at 2016-06-23:00:02:50
  685. channel c1: finished piece 1 at 2016-06-23:00:02:51
  686. piece handle=/home/oracle/manual_backup/86r8qoha_1_1.bkp tag=11T_USERS_INCR0 comment=NONE
  687. channel c1: backup set complete, elapsed time: 00:00:01

  688. backup will be obsolete on date 2017-06-23:00:02:51
  689. archived logs required to recover from this backup will be backed up
  690. channel c1: starting compressed full datafile backup set
  691. channel c1: specifying datafile(s) in backup set
  692. including current control file in backup set
  693. channel c1: starting piece 1 at 2016-06-23:00:02:52
  694. channel c1: finished piece 1 at 2016-06-23:00:02:53
  695. piece handle=/home/oracle/manual_backup/87r8qohb_1_1.bkp tag=11T_USERS_INCR0 comment=NONE
  696. channel c1: backup set complete, elapsed time: 00:00:01
  697. Finished backup at 2016-06-23:00:02:53
  698. released channel: c1

  699. RMAN> list backup ;


  700. List of Backup Sets
  701. ===================


  702. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  703. ------- ---- -- ---------- ----------- ------------ -------------------
  704. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  705.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  706.         Handle: 6or8lfc9_1_1   Media: station90-000019
  707.   List of Datafiles in backup set 197
  708.   File LV Type Ckp SCN    Ckp Time            Name
  709.   ---- -- ---- ---------- ------------------- ----
  710.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  711. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  712. ------- ---- -- ---------- ----------- ------------ -------------------
  713. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  714.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  715.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  716.   List of Datafiles in backup set 198
  717.   File LV Type Ckp SCN    Ckp Time            Name
  718.   ---- -- ---- ---------- ------------------- ----
  719.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  720. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  721. ------- ---- -- ---------- ----------- ------------ -------------------
  722. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  723.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  724.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  725.   List of Datafiles in backup set 199
  726.   File LV Type Ckp SCN    Ckp Time            Name
  727.   ---- -- ---- ---------- ------------------- ----
  728.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  729. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  730. ------- ---- -- ---------- ----------- ------------ -------------------
  731. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  732.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  733.         Handle: 6vr8qkce_1_1   Media: station90-000019
  734.   List of Datafiles in backup set 200
  735.   File LV Type Ckp SCN    Ckp Time            Name
  736.   ---- -- ---- ---------- ------------------- ----
  737.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  738. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  739. ------- ---- -- ---------- ----------- ------------ -------------------
  740. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  741.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  742.         Handle: 70r8qke1_1_1   Media: station90-000019
  743.   List of Datafiles in backup set 201
  744.   File LV Type Ckp SCN    Ckp Time            Name
  745.   ---- -- ---- ---------- ------------------- ----
  746.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  747. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  748. ------- ---- -- ---------- ----------- ------------ -------------------
  749. 203     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  750.         BP Key: 219   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  751.         Handle: 72r8ql8g_1_1   Media: station90-000019
  752.   List of Datafiles in backup set 203
  753.   File LV Type Ckp SCN    Ckp Time            Name
  754.   ---- -- ---- ---------- ------------------- ----
  755.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  756. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  757. ------- ---- -- ---------- ----------- ------------ -------------------
  758. 205     Incr 0  1.02M      SBT_TAPE    00:00:00     2016-06-22:23:19:51
  759.         BP Key: 222   Status: AVAILABLE  Compressed: YES  Tag: 8D_USERS_INCR0
  760.         Handle: 74r8qm0n_1_2   Media: station90-000019
  761.   List of Datafiles in backup set 205
  762.   File LV Type Ckp SCN    Ckp Time            Name
  763.   ---- -- ---- ---------- ------------------- ----
  764.   4    0  Incr 2246580    2016-06-22:23:19:51 +DATA/orcl/datafile/users.259.915231377

  765. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  766. ------- ---- -- ---------- ----------- ------------ -------------------
  767. 206     Incr 0  256.00K    SBT_TAPE    00:00:26     2016-06-22:23:25:02
  768.         BP Key: 223   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
  769.         Handle: 77r8qm9k_1_1   Media: station90-000020
  770.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  771.   SPFILE db_unique_name: ORCL

  772. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  773. ------- ---- -- ---------- ----------- ------------ -------------------
  774. 207     Incr 0  605.25M    SBT_TAPE    00:02:06     2016-06-22:23:26:42
  775.   List of Datafiles in backup set 207
  776.   File LV Type Ckp SCN    Ckp Time            Name
  777.   ---- -- ---- ---------- ------------------- ----
  778.   1    0  Incr 2246939    2016-06-22:23:24:36 +DATA/orcl/datafile/system.256.914102913

  779.   Backup Set Copy #1 of backup set 207
  780.   Device Type Elapsed Time Completion Time     Compressed Tag
  781.   ----------- ------------ ------------------- ---------- ---
  782.   SBT_TAPE    00:02:06     2016-06-22:23:26:42 NO         1T_SYSTEM_INCR0

  783.     List of Backup Pieces for backup set 207 Copy #1
  784.     BP Key  Pc# Status      Media                   Piece Name
  785.     ------- --- ----------- ----------------------- ----------
  786.     224     1   AVAILABLE   station90-000019        75r8qm9k_1_1
  787.     225     2   AVAILABLE   station90-000020        75r8qm9k_2_1
  788.     228     3   AVAILABLE   station90-000019        75r8qm9k_3_1
  789.     229     4   AVAILABLE   station90-000020        75r8qm9k_4_1
  790.     226     5   AVAILABLE   station90-000019        75r8qm9k_5_1
  791.     230     6   AVAILABLE   station90-000019        75r8qm9k_6_1
  792.     231     7   AVAILABLE   station90-000020        75r8qm9k_7_1

  793. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  794. ------- ---- -- ---------- ----------- ------------ -------------------
  795. 208     Incr 0  9.75M      SBT_TAPE    00:01:21     2016-06-22:23:25:57
  796.         BP Key: 227   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
  797.         Handle: 76r8qm9k_1_1   Media: station90-000020
  798.   Control File Included: Ckp SCN: 2246940      Ckp time: 2016-06-22:23:24:36

  799. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  800. ------- ---- -- ---------- ----------- ------------ -------------------
  801. 209     Incr 0  1.50M      SBT_TAPE    00:00:24     2016-06-22:23:53:43
  802.         BP Key: 232   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  803.         Handle: 7qr8qnvf_1_1   Media: station90-000019
  804.         Keep: BACKUP_LOGS        Until: FOREVER        
  805.   List of Datafiles in backup set 209
  806.   File LV Type Ckp SCN    Ckp Time            Name
  807.   ---- -- ---- ---------- ------------------- ----
  808.   4    0  Incr 2248807    2016-06-22:23:53:19 +DATA/orcl/datafile/users.259.915231377

  809. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  810. ------- ---- -- ---------- ----------- ------------ -------------------
  811. 210     Full    256.00K    SBT_TAPE    00:00:16     2016-06-22:23:54:00
  812.         BP Key: 233   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  813.         Handle: 7rr8qo08_1_1   Media: station90-000019
  814.         Keep: BACKUP_LOGS        Until: FOREVER        
  815.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  816.   SPFILE db_unique_name: ORCL

  817. BS Key  Size       Device Type Elapsed Time Completion Time   
  818. ------- ---------- ----------- ------------ -------------------
  819. 211     256.00K    SBT_TAPE    00:00:15     2016-06-22:23:54:27
  820.         BP Key: 234   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  821.         Handle: 7sr8qo14_1_1   Media: station90-000019
  822.         Keep: BACKUP_LOGS        Until: FOREVER        

  823.   List of Archived Logs in backup set 211
  824.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  825.   ---- ------- ---------- ------------------- ---------- ---------
  826.   1    149     2248741    2016-06-22:23:52:34 2248837    2016-06-22:23:54:10

  827. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  828. ------- ---- -- ---------- ----------- ------------ -------------------
  829. 212     Full    9.75M      SBT_TAPE    00:00:16     2016-06-22:23:54:53
  830.         BP Key: 235   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  831.         Handle: 7tr8qo1t_1_1   Media: station90-000019
  832.         Keep: BACKUP_LOGS        Until: FOREVER        
  833.   Control File Included: Ckp SCN: 2248924      Ckp time: 2016-06-22:23:54:37

  834. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  835. ------- ---- -- ---------- ----------- ------------ -------------------
  836. 213     Incr 0  1.02M      DISK        00:00:00     2016-06-23:00:00:18
  837.         BP Key: 236   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  838.         Piece Name: /home/oracle/manual_backup/7vr8qoci_1_1.bkp
  839.         Keep: BACKUP_LOGS        Until: FOREVER        
  840.   List of Datafiles in backup set 213
  841.   File LV Type Ckp SCN    Ckp Time            Name
  842.   ---- -- ---- ---------- ------------------- ----
  843.   4    0  Incr 2250315    2016-06-23:00:00:18 +DATA/orcl/datafile/users.259.915231377

  844. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  845. ------- ---- -- ---------- ----------- ------------ -------------------
  846. 214     Full    80.00K     DISK        00:00:00     2016-06-23:00:00:19
  847.         BP Key: 237   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  848.         Piece Name: /home/oracle/manual_backup/80r8qocj_1_1.bkp
  849.         Keep: BACKUP_LOGS        Until: FOREVER        
  850.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  851.   SPFILE db_unique_name: ORCL

  852. BS Key  Size       Device Type Elapsed Time Completion Time   
  853. ------- ---------- ----------- ------------ -------------------
  854. 215     9.00K      DISK        00:00:00     2016-06-23:00:00:24
  855.         BP Key: 238   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  856.         Piece Name: /home/oracle/manual_backup/81r8qoco_1_1.bkp
  857.         Keep: BACKUP_LOGS        Until: FOREVER        

  858.   List of Archived Logs in backup set 215
  859.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  860.   ---- ------- ---------- ------------------- ---------- ---------
  861.   1    152     2250302    2016-06-23:00:00:17 2250324    2016-06-23:00:00:23

  862. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  863. ------- ---- -- ---------- ----------- ------------ -------------------
  864. 216     Full    1.11M      DISK        00:00:02     2016-06-23:00:00:27
  865.         BP Key: 239   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  866.         Piece Name: /home/oracle/manual_backup/82r8qocp_1_1.bkp
  867.         Keep: BACKUP_LOGS        Until: FOREVER        
  868.   Control File Included: Ckp SCN: 2250338      Ckp time: 2016-06-23:00:00:25

  869. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  870. ------- ---- -- ---------- ----------- ------------ -------------------
  871. 217     Incr 0  1.02M      DISK        00:00:00     2016-06-23:00:02:44
  872.         BP Key: 240   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  873.         Piece Name: /home/oracle/manual_backup/84r8qoh4_1_1.bkp
  874.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:44
  875.   List of Datafiles in backup set 217
  876.   File LV Type Ckp SCN    Ckp Time            Name
  877.   ---- -- ---- ---------- ------------------- ----
  878.   4    0  Incr 2250544    2016-06-23:00:02:44 +DATA/orcl/datafile/users.259.915231377

  879. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  880. ------- ---- -- ---------- ----------- ------------ -------------------
  881. 218     Full    80.00K     DISK        00:00:00     2016-06-23:00:02:45
  882.         BP Key: 241   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  883.         Piece Name: /home/oracle/manual_backup/85r8qoh5_1_1.bkp
  884.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:45
  885.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  886.   SPFILE db_unique_name: ORCL

  887. BS Key  Size       Device Type Elapsed Time Completion Time   
  888. ------- ---------- ----------- ------------ -------------------
  889. 219     7.50K      DISK        00:00:00     2016-06-23:00:02:50
  890.         BP Key: 242   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  891.         Piece Name: /home/oracle/manual_backup/86r8qoha_1_1.bkp
  892.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:50

  893.   List of Archived Logs in backup set 219
  894.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  895.   ---- ------- ---------- ------------------- ---------- ---------
  896.   1    155     2250539    2016-06-23:00:02:43 2250564    2016-06-23:00:02:49

  897. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  898. ------- ---- -- ---------- ----------- ------------ -------------------
  899. 220     Full    1.11M      DISK        00:00:01     2016-06-23:00:02:52
  900.         BP Key: 243   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  901.         Piece Name: /home/oracle/manual_backup/87r8qohb_1_1.bkp
  902.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:51
  903.   Control File Included: Ckp SCN: 2250569      Ckp time: 2016-06-23:00:02:51

  904. RMAN> change backupset 197 keep until time 'sysdate +60';

  905. allocated channel: ORA_DISK_1
  906. channel ORA_DISK_1: SID=145 device type=DISK
  907. allocated channel: ORA_DISK_2
  908. channel ORA_DISK_2: SID=149 device type=DISK
  909. allocated channel: ORA_DISK_3
  910. channel ORA_DISK_3: SID=20 device type=DISK
  911. allocated channel: ORA_DISK_4
  912. channel ORA_DISK_4: SID=194 device type=DISK
  913. allocated channel: ORA_DISK_5
  914. channel ORA_DISK_5: SID=9 device type=DISK
  915. allocated channel: ORA_DISK_6
  916. channel ORA_DISK_6: SID=86 device type=DISK
  917. allocated channel: ORA_DISK_7
  918. channel ORA_DISK_7: SID=150 device type=DISK
  919. allocated channel: ORA_DISK_8
  920. channel ORA_DISK_8: SID=198 device type=DISK
  921. allocated channel: ORA_SBT_TAPE_1
  922. channel ORA_SBT_TAPE_1: SID=17 device type=SBT_TAPE
  923. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  924. allocated channel: ORA_SBT_TAPE_2
  925. channel ORA_SBT_TAPE_2: SID=200 device type=SBT_TAPE
  926. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  927. allocated channel: ORA_SBT_TAPE_3
  928. channel ORA_SBT_TAPE_3: SID=85 device type=SBT_TAPE
  929. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  930. allocated channel: ORA_SBT_TAPE_4
  931. channel ORA_SBT_TAPE_4: SID=15 device type=SBT_TAPE
  932. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  933. allocated channel: ORA_SBT_TAPE_5
  934. channel ORA_SBT_TAPE_5: SID=22 device type=SBT_TAPE
  935. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  936. allocated channel: ORA_SBT_TAPE_6
  937. channel ORA_SBT_TAPE_6: SID=195 device type=SBT_TAPE
  938. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  939. allocated channel: ORA_SBT_TAPE_7
  940. channel ORA_SBT_TAPE_7: SID=205 device type=SBT_TAPE
  941. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  942. allocated channel: ORA_SBT_TAPE_8
  943. channel ORA_SBT_TAPE_8: SID=91 device type=SBT_TAPE
  944. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  945. keep attributes for the backup are changed
  946. backup will be obsolete on date 2016-08-22:00:04:40
  947. backup set key=197 RECID=197 STAMP=915062177

  948. RMAN> list backup ;


  949. List of Backup Sets
  950. ===================


  951. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  952. ------- ---- -- ---------- ----------- ------------ -------------------
  953. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  954.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  955.         Handle: 6or8lfc9_1_1   Media: station90-000019
  956.         Keep: BACKUP_LOGS        Until: 2016-08-22:00:04:40
  957.   List of Datafiles in backup set 197
  958.   File LV Type Ckp SCN    Ckp Time            Name
  959.   ---- -- ---- ---------- ------------------- ----
  960.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  961. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  962. ------- ---- -- ---------- ----------- ------------ -------------------
  963. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  964.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  965.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  966.   List of Datafiles in backup set 198
  967.   File LV Type Ckp SCN    Ckp Time            Name
  968.   ---- -- ---- ---------- ------------------- ----
  969.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  970. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  971. ------- ---- -- ---------- ----------- ------------ -------------------
  972. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  973.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  974.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  975.   List of Datafiles in backup set 199
  976.   File LV Type Ckp SCN    Ckp Time            Name
  977.   ---- -- ---- ---------- ------------------- ----
  978.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  979. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  980. ------- ---- -- ---------- ----------- ------------ -------------------
  981. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  982.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  983.         Handle: 6vr8qkce_1_1   Media: station90-000019
  984.   List of Datafiles in backup set 200
  985.   File LV Type Ckp SCN    Ckp Time            Name
  986.   ---- -- ---- ---------- ------------------- ----
  987.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  988. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  989. ------- ---- -- ---------- ----------- ------------ -------------------
  990. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  991.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  992.         Handle: 70r8qke1_1_1   Media: station90-000019
  993.   List of Datafiles in backup set 201
  994.   File LV Type Ckp SCN    Ckp Time            Name
  995.   ---- -- ---- ---------- ------------------- ----
  996.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  997. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  998. ------- ---- -- ---------- ----------- ------------ -------------------
  999. 203     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  1000.         BP Key: 219   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  1001.         Handle: 72r8ql8g_1_1   Media: station90-000019
  1002.   List of Datafiles in backup set 203
  1003.   File LV Type Ckp SCN    Ckp Time            Name
  1004.   ---- -- ---- ---------- ------------------- ----
  1005.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  1006. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1007. ------- ---- -- ---------- ----------- ------------ -------------------
  1008. 205     Incr 0  1.02M      SBT_TAPE    00:00:00     2016-06-22:23:19:51
  1009.         BP Key: 222   Status: AVAILABLE  Compressed: YES  Tag: 8D_USERS_INCR0
  1010.         Handle: 74r8qm0n_1_2   Media: station90-000019
  1011.   List of Datafiles in backup set 205
  1012.   File LV Type Ckp SCN    Ckp Time            Name
  1013.   ---- -- ---- ---------- ------------------- ----
  1014.   4    0  Incr 2246580    2016-06-22:23:19:51 +DATA/orcl/datafile/users.259.915231377

  1015. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1016. ------- ---- -- ---------- ----------- ------------ -------------------
  1017. 206     Incr 0  256.00K    SBT_TAPE    00:00:26     2016-06-22:23:25:02
  1018.         BP Key: 223   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
  1019.         Handle: 77r8qm9k_1_1   Media: station90-000020
  1020.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  1021.   SPFILE db_unique_name: ORCL

  1022. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1023. ------- ---- -- ---------- ----------- ------------ -------------------
  1024. 207     Incr 0  605.25M    SBT_TAPE    00:02:06     2016-06-22:23:26:42
  1025.   List of Datafiles in backup set 207
  1026.   File LV Type Ckp SCN    Ckp Time            Name
  1027.   ---- -- ---- ---------- ------------------- ----
  1028.   1    0  Incr 2246939    2016-06-22:23:24:36 +DATA/orcl/datafile/system.256.914102913

  1029.   Backup Set Copy #1 of backup set 207
  1030.   Device Type Elapsed Time Completion Time     Compressed Tag
  1031.   ----------- ------------ ------------------- ---------- ---
  1032.   SBT_TAPE    00:02:06     2016-06-22:23:26:42 NO         1T_SYSTEM_INCR0

  1033.     List of Backup Pieces for backup set 207 Copy #1
  1034.     BP Key  Pc# Status      Media                   Piece Name
  1035.     ------- --- ----------- ----------------------- ----------
  1036.     224     1   AVAILABLE   station90-000019        75r8qm9k_1_1
  1037.     225     2   AVAILABLE   station90-000020        75r8qm9k_2_1
  1038.     228     3   AVAILABLE   station90-000019        75r8qm9k_3_1
  1039.     229     4   AVAILABLE   station90-000020        75r8qm9k_4_1
  1040.     226     5   AVAILABLE   station90-000019        75r8qm9k_5_1
  1041.     230     6   AVAILABLE   station90-000019        75r8qm9k_6_1
  1042.     231     7   AVAILABLE   station90-000020        75r8qm9k_7_1

  1043. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1044. ------- ---- -- ---------- ----------- ------------ -------------------
  1045. 208     Incr 0  9.75M      SBT_TAPE    00:01:21     2016-06-22:23:25:57
  1046.         BP Key: 227   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
  1047.         Handle: 76r8qm9k_1_1   Media: station90-000020
  1048.   Control File Included: Ckp SCN: 2246940      Ckp time: 2016-06-22:23:24:36

  1049. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1050. ------- ---- -- ---------- ----------- ------------ -------------------
  1051. 209     Incr 0  1.50M      SBT_TAPE    00:00:24     2016-06-22:23:53:43
  1052.         BP Key: 232   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  1053.         Handle: 7qr8qnvf_1_1   Media: station90-000019
  1054.         Keep: BACKUP_LOGS        Until: FOREVER        
  1055.   List of Datafiles in backup set 209
  1056.   File LV Type Ckp SCN    Ckp Time            Name
  1057.   ---- -- ---- ---------- ------------------- ----
  1058.   4    0  Incr 2248807    2016-06-22:23:53:19 +DATA/orcl/datafile/users.259.915231377

  1059. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1060. ------- ---- -- ---------- ----------- ------------ -------------------
  1061. 210     Full    256.00K    SBT_TAPE    00:00:16     2016-06-22:23:54:00
  1062.         BP Key: 233   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  1063.         Handle: 7rr8qo08_1_1   Media: station90-000019
  1064.         Keep: BACKUP_LOGS        Until: FOREVER        
  1065.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  1066.   SPFILE db_unique_name: ORCL

  1067. BS Key  Size       Device Type Elapsed Time Completion Time   
  1068. ------- ---------- ----------- ------------ -------------------
  1069. 211     256.00K    SBT_TAPE    00:00:15     2016-06-22:23:54:27
  1070.         BP Key: 234   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  1071.         Handle: 7sr8qo14_1_1   Media: station90-000019
  1072.         Keep: BACKUP_LOGS        Until: FOREVER        

  1073.   List of Archived Logs in backup set 211
  1074.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1075.   ---- ------- ---------- ------------------- ---------- ---------
  1076.   1    149     2248741    2016-06-22:23:52:34 2248837    2016-06-22:23:54:10

  1077. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1078. ------- ---- -- ---------- ----------- ------------ -------------------
  1079. 212     Full    9.75M      SBT_TAPE    00:00:16     2016-06-22:23:54:53
  1080.         BP Key: 235   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  1081.         Handle: 7tr8qo1t_1_1   Media: station90-000019
  1082.         Keep: BACKUP_LOGS        Until: FOREVER        
  1083.   Control File Included: Ckp SCN: 2248924      Ckp time: 2016-06-22:23:54:37

  1084. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1085. ------- ---- -- ---------- ----------- ------------ -------------------
  1086. 213     Incr 0  1.02M      DISK        00:00:00     2016-06-23:00:00:18
  1087.         BP Key: 236   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  1088.         Piece Name: /home/oracle/manual_backup/7vr8qoci_1_1.bkp
  1089.         Keep: BACKUP_LOGS        Until: FOREVER        
  1090.   List of Datafiles in backup set 213
  1091.   File LV Type Ckp SCN    Ckp Time            Name
  1092.   ---- -- ---- ---------- ------------------- ----
  1093.   4    0  Incr 2250315    2016-06-23:00:00:18 +DATA/orcl/datafile/users.259.915231377

  1094. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1095. ------- ---- -- ---------- ----------- ------------ -------------------
  1096. 214     Full    80.00K     DISK        00:00:00     2016-06-23:00:00:19
  1097.         BP Key: 237   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  1098.         Piece Name: /home/oracle/manual_backup/80r8qocj_1_1.bkp
  1099.         Keep: BACKUP_LOGS        Until: FOREVER        
  1100.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  1101.   SPFILE db_unique_name: ORCL

  1102. BS Key  Size       Device Type Elapsed Time Completion Time   
  1103. ------- ---------- ----------- ------------ -------------------
  1104. 215     9.00K      DISK        00:00:00     2016-06-23:00:00:24
  1105.         BP Key: 238   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  1106.         Piece Name: /home/oracle/manual_backup/81r8qoco_1_1.bkp
  1107.         Keep: BACKUP_LOGS        Until: FOREVER        

  1108.   List of Archived Logs in backup set 215
  1109.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1110.   ---- ------- ---------- ------------------- ---------- ---------
  1111.   1    152     2250302    2016-06-23:00:00:17 2250324    2016-06-23:00:00:23

  1112. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1113. ------- ---- -- ---------- ----------- ------------ -------------------
  1114. 216     Full    1.11M      DISK        00:00:02     2016-06-23:00:00:27
  1115.         BP Key: 239   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  1116.         Piece Name: /home/oracle/manual_backup/82r8qocp_1_1.bkp
  1117.         Keep: BACKUP_LOGS        Until: FOREVER        
  1118.   Control File Included: Ckp SCN: 2250338      Ckp time: 2016-06-23:00:00:25

  1119. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1120. ------- ---- -- ---------- ----------- ------------ -------------------
  1121. 217     Incr 0  1.02M      DISK        00:00:00     2016-06-23:00:02:44
  1122.         BP Key: 240   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  1123.         Piece Name: /home/oracle/manual_backup/84r8qoh4_1_1.bkp
  1124.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:44
  1125.   List of Datafiles in backup set 217
  1126.   File LV Type Ckp SCN    Ckp Time            Name
  1127.   ---- -- ---- ---------- ------------------- ----
  1128.   4    0  Incr 2250544    2016-06-23:00:02:44 +DATA/orcl/datafile/users.259.915231377

  1129. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1130. ------- ---- -- ---------- ----------- ------------ -------------------
  1131. 218     Full    80.00K     DISK        00:00:00     2016-06-23:00:02:45
  1132.         BP Key: 241   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  1133.         Piece Name: /home/oracle/manual_backup/85r8qoh5_1_1.bkp
  1134.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:45
  1135.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  1136.   SPFILE db_unique_name: ORCL

  1137. BS Key  Size       Device Type Elapsed Time Completion Time   
  1138. ------- ---------- ----------- ------------ -------------------
  1139. 219     7.50K      DISK        00:00:00     2016-06-23:00:02:50
  1140.         BP Key: 242   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  1141.         Piece Name: /home/oracle/manual_backup/86r8qoha_1_1.bkp
  1142.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:50

  1143.   List of Archived Logs in backup set 219
  1144.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1145.   ---- ------- ---------- ------------------- ---------- ---------
  1146.   1    155     2250539    2016-06-23:00:02:43 2250564    2016-06-23:00:02:49

  1147. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1148. ------- ---- -- ---------- ----------- ------------ -------------------
  1149. 220     Full    1.11M      DISK        00:00:01     2016-06-23:00:02:52
  1150.         BP Key: 243   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  1151.         Piece Name: /home/oracle/manual_backup/87r8qohb_1_1.bkp
  1152.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:51
  1153.   Control File Included: Ckp SCN: 2250569      Ckp time: 2016-06-23:00:02:51

  1154. RMAN> backup recovery files;

  1155. Starting backup at 2016-06-23:00:09:32
  1156. released channel: ORA_SBT_TAPE_1
  1157. released channel: ORA_SBT_TAPE_2
  1158. released channel: ORA_SBT_TAPE_3
  1159. released channel: ORA_SBT_TAPE_4
  1160. released channel: ORA_SBT_TAPE_5
  1161. released channel: ORA_SBT_TAPE_6
  1162. released channel: ORA_SBT_TAPE_7
  1163. released channel: ORA_SBT_TAPE_8
  1164. using channel ORA_DISK_1
  1165. using channel ORA_DISK_2
  1166. using channel ORA_DISK_3
  1167. using channel ORA_DISK_4
  1168. using channel ORA_DISK_5
  1169. using channel ORA_DISK_6
  1170. using channel ORA_DISK_7
  1171. using channel ORA_DISK_8
  1172. specification does not match any datafile copy in the repository
  1173. RMAN-00571: ===========================================================
  1174. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  1175. RMAN-00571: ===========================================================
  1176. RMAN-03002: failure of backup command at 06/23/2016 00:09:43
  1177. RMAN-06603: TO DESTINATION option must be specified with RECOVERY AREA, RECOVERY FILES or DB_RECOVERY_FILE_DEST on disk device

  1178. RMAN> show all;

  1179. RMAN configuration parameters for database with db_unique_name ORCL are:
  1180. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  1181. CONFIGURE BACKUP OPTIMIZATION ON;
  1182. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  1183. CONFIGURE CONTROLFILE AUTOBACKUP OFF;
  1184. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  1185. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  1186. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO COMPRESSED BACKUPSET;
  1187. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  1188. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  1189. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  1190. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  1191. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  1192. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1193. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1194. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1195. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1196. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1197. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1198. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1199. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1200. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  1201. CONFIGURE ENCRYPTION FOR DATABASE ON;
  1202. CONFIGURE ENCRYPTION ALGORITHM 'AES256';
  1203. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  1204. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  1205. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  1206. RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;

  1207. old RMAN configuration parameters:
  1208. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  1209. new RMAN configuration parameters:
  1210. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  1211. new RMAN configuration parameters are successfully stored
  1212. released channel: ORA_DISK_1
  1213. released channel: ORA_DISK_2
  1214. released channel: ORA_DISK_3
  1215. released channel: ORA_DISK_4
  1216. released channel: ORA_DISK_5
  1217. released channel: ORA_DISK_6
  1218. released channel: ORA_DISK_7
  1219. released channel: ORA_DISK_8

  1220. RMAN> backup recovery files;

  1221. Starting backup at 2016-06-23:00:10:13
  1222. allocated channel: ORA_SBT_TAPE_1
  1223. channel ORA_SBT_TAPE_1: SID=145 device type=SBT_TAPE
  1224. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  1225. allocated channel: ORA_SBT_TAPE_2
  1226. channel ORA_SBT_TAPE_2: SID=149 device type=SBT_TAPE
  1227. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  1228. allocated channel: ORA_SBT_TAPE_3
  1229. channel ORA_SBT_TAPE_3: SID=20 device type=SBT_TAPE
  1230. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  1231. allocated channel: ORA_SBT_TAPE_4
  1232. channel ORA_SBT_TAPE_4: SID=194 device type=SBT_TAPE
  1233. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  1234. allocated channel: ORA_SBT_TAPE_5
  1235. channel ORA_SBT_TAPE_5: SID=9 device type=SBT_TAPE
  1236. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  1237. allocated channel: ORA_SBT_TAPE_6
  1238. channel ORA_SBT_TAPE_6: SID=86 device type=SBT_TAPE
  1239. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  1240. allocated channel: ORA_SBT_TAPE_7
  1241. channel ORA_SBT_TAPE_7: SID=150 device type=SBT_TAPE
  1242. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  1243. allocated channel: ORA_SBT_TAPE_8
  1244. channel ORA_SBT_TAPE_8: SID=198 device type=SBT_TAPE
  1245. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  1246. specification does not match any datafile copy in the repository
  1247. channel ORA_SBT_TAPE_1: starting archived log backup set
  1248. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  1249. input archived log thread=1 sequence=112 RECID=317 STAMP=915062314
  1250. input archived log thread=1 sequence=113 RECID=319 STAMP=915062314
  1251. input archived log thread=1 sequence=114 RECID=321 STAMP=915062316
  1252. input archived log thread=1 sequence=115 RECID=323 STAMP=915062316
  1253. input archived log thread=1 sequence=116 RECID=325 STAMP=915062319
  1254. input archived log thread=1 sequence=117 RECID=327 STAMP=915062321
  1255. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-23:00:10:56
  1256. channel ORA_SBT_TAPE_2: starting archived log backup set
  1257. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
  1258. input archived log thread=1 sequence=118 RECID=329 STAMP=915104382
  1259. input archived log thread=1 sequence=119 RECID=331 STAMP=915110675
  1260. input archived log thread=1 sequence=120 RECID=333 STAMP=915119696
  1261. channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-23:00:10:56
  1262. channel ORA_SBT_TAPE_3: starting archived log backup set
  1263. channel ORA_SBT_TAPE_3: specifying archived log(s) in backup set
  1264. input archived log thread=1 sequence=121 RECID=335 STAMP=915127492
  1265. input archived log thread=1 sequence=122 RECID=337 STAMP=915141022
  1266. input archived log thread=1 sequence=123 RECID=339 STAMP=915141629
  1267. channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-23:00:10:56
  1268. channel ORA_SBT_TAPE_4: starting archived log backup set
  1269. channel ORA_SBT_TAPE_4: specifying archived log(s) in backup set
  1270. input archived log thread=1 sequence=124 RECID=341 STAMP=915141644
  1271. input archived log thread=1 sequence=125 RECID=343 STAMP=915143332
  1272. input archived log thread=1 sequence=126 RECID=345 STAMP=915148804
  1273. channel ORA_SBT_TAPE_4: starting piece 1 at 2016-06-23:00:10:56
  1274. channel ORA_SBT_TAPE_5: starting archived log backup set
  1275. channel ORA_SBT_TAPE_5: specifying archived log(s) in backup set
  1276. input archived log thread=1 sequence=127 RECID=347 STAMP=915156125
  1277. input archived log thread=1 sequence=128 RECID=349 STAMP=915193693
  1278. input archived log thread=1 sequence=129 RECID=351 STAMP=915201135
  1279. channel ORA_SBT_TAPE_5: starting piece 1 at 2016-06-23:00:10:57
  1280. channel ORA_SBT_TAPE_6: starting archived log backup set
  1281. channel ORA_SBT_TAPE_6: specifying archived log(s) in backup set
  1282. input archived log thread=1 sequence=130 RECID=353 STAMP=915208934
  1283. input archived log thread=1 sequence=131 RECID=355 STAMP=915215997
  1284. input archived log thread=1 sequence=132 RECID=357 STAMP=915228239
  1285. channel ORA_SBT_TAPE_6: starting piece 1 at 2016-06-23:00:10:57
  1286. channel ORA_SBT_TAPE_7: starting archived log backup set
  1287. channel ORA_SBT_TAPE_7: specifying archived log(s) in backup set
  1288. input archived log thread=1 sequence=133 RECID=359 STAMP=915228270
  1289. input archived log thread=1 sequence=134 RECID=361 STAMP=915229248
  1290. input archived log thread=1 sequence=135 RECID=363 STAMP=915229248
  1291. input archived log thread=1 sequence=136 RECID=365 STAMP=915229251
  1292. input archived log thread=1 sequence=137 RECID=367 STAMP=915229252
  1293. input archived log thread=1 sequence=138 RECID=369 STAMP=915229254
  1294. channel ORA_SBT_TAPE_7: starting piece 1 at 2016-06-23:00:10:57
  1295. channel ORA_SBT_TAPE_8: starting archived log backup set
  1296. channel ORA_SBT_TAPE_8: specifying archived log(s) in backup set
  1297. input archived log thread=1 sequence=139 RECID=371 STAMP=915229255
  1298. input archived log thread=1 sequence=140 RECID=373 STAMP=915230831
  1299. input archived log thread=1 sequence=141 RECID=375 STAMP=915231294
  1300. input archived log thread=1 sequence=142 RECID=377 STAMP=915231294
  1301. input archived log thread=1 sequence=143 RECID=379 STAMP=915231296
  1302. input archived log thread=1 sequence=144 RECID=381 STAMP=915231296
  1303. channel ORA_SBT_TAPE_8: starting piece 1 at 2016-06-23:00:10:57
  1304. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-23:00:11:32
  1305. piece handle=88r8qp0g_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1306. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:36
  1307. channel ORA_SBT_TAPE_1: starting archived log backup set
  1308. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  1309. input archived log thread=1 sequence=145 RECID=383 STAMP=915231299
  1310. input archived log thread=1 sequence=146 RECID=385 STAMP=915231300
  1311. input archived log thread=1 sequence=147 RECID=387 STAMP=915234531
  1312. input archived log thread=1 sequence=148 RECID=389 STAMP=915234754
  1313. input archived log thread=1 sequence=149 RECID=391 STAMP=915234850
  1314. input archived log thread=1 sequence=150 RECID=393 STAMP=915235164
  1315. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-23:00:11:32
  1316. channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-23:00:11:32
  1317. piece handle=89r8qp0g_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1318. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:36
  1319. channel ORA_SBT_TAPE_2: starting archived log backup set
  1320. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
  1321. input archived log thread=1 sequence=151 RECID=395 STAMP=915235217
  1322. input archived log thread=1 sequence=152 RECID=397 STAMP=915235223
  1323. input archived log thread=1 sequence=153 RECID=399 STAMP=915235303
  1324. input archived log thread=1 sequence=154 RECID=401 STAMP=915235364
  1325. input archived log thread=1 sequence=155 RECID=403 STAMP=915235369
  1326. channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-23:00:11:32
  1327. channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-23:00:11:57
  1328. piece handle=8ar8qp0g_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1329. channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:01:01
  1330. channel ORA_SBT_TAPE_4: finished piece 1 at 2016-06-23:00:11:58
  1331. piece handle=8br8qp0g_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1332. channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:01:02
  1333. channel ORA_SBT_TAPE_3: input backup set: count=255, stamp=915235218, piece=1
  1334. channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-23:00:11:59
  1335. channel ORA_SBT_TAPE_3: backup piece /home/oracle/manual_backup/7vr8qoci_1_1.bkp
  1336. channel ORA_SBT_TAPE_4: input backup set: count=256, stamp=915235219, piece=1
  1337. channel ORA_SBT_TAPE_4: starting piece 1 at 2016-06-23:00:11:59
  1338. channel ORA_SBT_TAPE_4: backup piece /home/oracle/manual_backup/80r8qocj_1_1.bkp
  1339. channel ORA_SBT_TAPE_7: finished piece 1 at 2016-06-23:00:12:24
  1340. piece handle=8er8qp0h_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1341. channel ORA_SBT_TAPE_7: backup set complete, elapsed time: 00:01:27
  1342. channel ORA_SBT_TAPE_7: input backup set: count=257, stamp=915235224, piece=1
  1343. channel ORA_SBT_TAPE_7: starting piece 1 at 2016-06-23:00:12:24
  1344. channel ORA_SBT_TAPE_7: backup piece /home/oracle/manual_backup/81r8qoco_1_1.bkp
  1345. channel ORA_SBT_TAPE_8: finished piece 1 at 2016-06-23:00:12:24
  1346. piece handle=8fr8qp0h_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1347. channel ORA_SBT_TAPE_8: backup set complete, elapsed time: 00:01:27
  1348. channel ORA_SBT_TAPE_8: input backup set: count=258, stamp=915235225, piece=1
  1349. channel ORA_SBT_TAPE_8: starting piece 1 at 2016-06-23:00:12:24
  1350. channel ORA_SBT_TAPE_8: backup piece /home/oracle/manual_backup/82r8qocp_1_1.bkp
  1351. channel ORA_SBT_TAPE_5: finished piece 1 at 2016-06-23:00:12:39
  1352. piece handle=8cr8qp0g_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1353. channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:01:42
  1354. channel ORA_SBT_TAPE_5: input backup set: count=260, stamp=915235364, piece=1
  1355. channel ORA_SBT_TAPE_5: starting piece 1 at 2016-06-23:00:12:39
  1356. channel ORA_SBT_TAPE_5: backup piece /home/oracle/manual_backup/84r8qoh4_1_1.bkp
  1357. channel ORA_SBT_TAPE_6: finished piece 1 at 2016-06-23:00:12:46
  1358. piece handle=8dr8qp0h_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1359. channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:01:49
  1360. channel ORA_SBT_TAPE_6: input backup set: count=261, stamp=915235365, piece=1
  1361. channel ORA_SBT_TAPE_6: starting piece 1 at 2016-06-23:00:12:46
  1362. channel ORA_SBT_TAPE_6: backup piece /home/oracle/manual_backup/85r8qoh5_1_1.bkp
  1363. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-23:00:13:01
  1364. piece handle=8gr8qp1k_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1365. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:29
  1366. channel ORA_SBT_TAPE_1: input backup set: count=262, stamp=915235370, piece=1
  1367. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-23:00:13:01
  1368. channel ORA_SBT_TAPE_1: backup piece /home/oracle/manual_backup/86r8qoha_1_1.bkp
  1369. channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-23:00:13:01
  1370. piece handle=8hr8qp1k_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1371. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:29
  1372. channel ORA_SBT_TAPE_2: input backup set: count=263, stamp=915235371, piece=1
  1373. channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-23:00:13:01
  1374. channel ORA_SBT_TAPE_2: backup piece /home/oracle/manual_backup/87r8qohb_1_1.bkp
  1375. piece handle=7vr8qoci_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1376. channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-23:00:13:26
  1377. channel ORA_SBT_TAPE_3: backup piece complete, elapsed time: 00:01:27
  1378. piece handle=80r8qocj_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1379. channel ORA_SBT_TAPE_4: finished piece 1 at 2016-06-23:00:13:26
  1380. channel ORA_SBT_TAPE_4: backup piece complete, elapsed time: 00:01:27
  1381. piece handle=81r8qoco_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1382. channel ORA_SBT_TAPE_7: finished piece 1 at 2016-06-23:00:13:36
  1383. channel ORA_SBT_TAPE_7: backup piece complete, elapsed time: 00:01:12
  1384. piece handle=82r8qocp_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1385. channel ORA_SBT_TAPE_8: finished piece 1 at 2016-06-23:00:13:46
  1386. channel ORA_SBT_TAPE_8: backup piece complete, elapsed time: 00:01:22
  1387. piece handle=85r8qoh5_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1388. channel ORA_SBT_TAPE_6: finished piece 1 at 2016-06-23:00:13:56
  1389. channel ORA_SBT_TAPE_6: backup piece complete, elapsed time: 00:01:10
  1390. piece handle=84r8qoh4_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1391. channel ORA_SBT_TAPE_5: finished piece 1 at 2016-06-23:00:14:06
  1392. channel ORA_SBT_TAPE_5: backup piece complete, elapsed time: 00:01:27
  1393. piece handle=86r8qoha_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1394. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-23:00:14:26
  1395. channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:01:25
  1396. piece handle=87r8qohb_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1397. channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-23:00:14:26
  1398. channel ORA_SBT_TAPE_2: backup piece complete, elapsed time: 00:01:25
  1399. Finished backup at 2016-06-23:00:14:26

  1400. RMAN> backup recovery files;

  1401. Starting backup at 2016-06-23:00:14:32
  1402. using channel ORA_SBT_TAPE_1
  1403. using channel ORA_SBT_TAPE_2
  1404. using channel ORA_SBT_TAPE_3
  1405. using channel ORA_SBT_TAPE_4
  1406. using channel ORA_SBT_TAPE_5
  1407. using channel ORA_SBT_TAPE_6
  1408. using channel ORA_SBT_TAPE_7
  1409. using channel ORA_SBT_TAPE_8
  1410. specification does not match any datafile copy in the repository
  1411. skipping archived log file +FRA/orcl/archivelog/2016_06_20/thread_1_seq_112.334.915062313; already backed up 1 time(s)
  1412. skipping archived log file /home/oracle/archivelog/1_112_913410354.dbf; already backed up 1 time(s)
  1413. skipping archived log file +FRA/orcl/archivelog/2016_06_20/thread_1_seq_113.328.915062315; already backed up 1 time(s)
  1414. skipping archived log file /home/oracle/archivelog/1_113_913410354.dbf; already backed up 1 time(s)
  1415. skipping archived log file +FRA/orcl/archivelog/2016_06_20/thread_1_seq_114.305.915062315; already backed up 1 time(s)
  1416. skipping archived log file /home/oracle/archivelog/1_114_913410354.dbf; already backed up 1 time(s)
  1417. skipping archived log file +FRA/orcl/archivelog/2016_06_20/thread_1_seq_115.341.915062317; already backed up 1 time(s)
  1418. skipping archived log file /home/oracle/archivelog/1_115_913410354.dbf; already backed up 1 time(s)
  1419. skipping archived log file +FRA/orcl/archivelog/2016_06_20/thread_1_seq_116.308.915062319; already backed up 1 time(s)
  1420. skipping archived log file /home/oracle/archivelog/1_116_913410354.dbf; already backed up 1 time(s)
  1421. skipping archived log file +FRA/orcl/archivelog/2016_06_20/thread_1_seq_117.314.915062321; already backed up 1 time(s)
  1422. skipping archived log file /home/oracle/archivelog/1_117_913410354.dbf; already backed up 1 time(s)
  1423. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_118.311.915104383; already backed up 1 time(s)
  1424. skipping archived log file /home/oracle/archivelog/1_118_913410354.dbf; already backed up 1 time(s)
  1425. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_119.309.915110675; already backed up 1 time(s)
  1426. skipping archived log file /home/oracle/archivelog/1_119_913410354.dbf; already backed up 1 time(s)
  1427. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_120.310.915119695; already backed up 1 time(s)
  1428. skipping archived log file /home/oracle/archivelog/1_120_913410354.dbf; already backed up 1 time(s)
  1429. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_121.268.915127491; already backed up 1 time(s)
  1430. skipping archived log file /home/oracle/archivelog/1_121_913410354.dbf; already backed up 1 time(s)
  1431. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_122.316.915141023; already backed up 1 time(s)
  1432. skipping archived log file /home/oracle/archivelog/1_122_913410354.dbf; already backed up 1 time(s)
  1433. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_123.306.915141629; already backed up 1 time(s)
  1434. skipping archived log file /home/oracle/archivelog/1_123_913410354.dbf; already backed up 1 time(s)
  1435. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_124.300.915141645; already backed up 1 time(s)
  1436. skipping archived log file /home/oracle/archivelog/1_124_913410354.dbf; already backed up 1 time(s)
  1437. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_125.303.915143331; already backed up 1 time(s)
  1438. skipping archived log file /home/oracle/archivelog/1_125_913410354.dbf; already backed up 1 time(s)
  1439. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_126.301.915148803; already backed up 1 time(s)
  1440. skipping archived log file /home/oracle/archivelog/1_126_913410354.dbf; already backed up 1 time(s)
  1441. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_127.318.915156125; already backed up 1 time(s)
  1442. skipping archived log file /home/oracle/archivelog/1_127_913410354.dbf; already backed up 1 time(s)
  1443. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_128.331.915193693; already backed up 1 time(s)
  1444. skipping archived log file /home/oracle/archivelog/1_128_913410354.dbf; already backed up 1 time(s)
  1445. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_129.326.915201135; already backed up 1 time(s)
  1446. skipping archived log file /home/oracle/archivelog/1_129_913410354.dbf; already backed up 1 time(s)
  1447. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_130.332.915208933; already backed up 1 time(s)
  1448. skipping archived log file /home/oracle/archivelog/1_130_913410354.dbf; already backed up 1 time(s)
  1449. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_131.333.915215997; already backed up 1 time(s)
  1450. skipping archived log file /home/oracle/archivelog/1_131_913410354.dbf; already backed up 1 time(s)
  1451. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_132.313.915228239; already backed up 1 time(s)
  1452. skipping archived log file /home/oracle/archivelog/1_132_913410354.dbf; already backed up 1 time(s)
  1453. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_133.323.915228269; already backed up 1 time(s)
  1454. skipping archived log file /home/oracle/archivelog/1_133_913410354.dbf; already backed up 1 time(s)
  1455. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_134.325.915229249; already backed up 1 time(s)
  1456. skipping archived log file /home/oracle/archivelog/1_134_913410354.dbf; already backed up 1 time(s)
  1457. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_135.324.915229249; already backed up 1 time(s)
  1458. skipping archived log file /home/oracle/archivelog/1_135_913410354.dbf; already backed up 1 time(s)
  1459. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_136.327.915229251; already backed up 1 time(s)
  1460. skipping archived log file /home/oracle/archivelog/1_136_913410354.dbf; already backed up 1 time(s)
  1461. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_137.279.915229253; already backed up 1 time(s)
  1462. skipping archived log file /home/oracle/archivelog/1_137_913410354.dbf; already backed up 1 time(s)
  1463. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_138.298.915229255; already backed up 1 time(s)
  1464. skipping archived log file /home/oracle/archivelog/1_138_913410354.dbf; already backed up 1 time(s)
  1465. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_139.267.915229255; already backed up 1 time(s)
  1466. skipping archived log file /home/oracle/archivelog/1_139_913410354.dbf; already backed up 1 time(s)
  1467. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_140.287.915230831; already backed up 1 time(s)
  1468. skipping archived log file /home/oracle/archivelog/1_140_913410354.dbf; already backed up 1 time(s)
  1469. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_141.269.915231295; already backed up 1 time(s)
  1470. skipping archived log file /home/oracle/archivelog/1_141_913410354.dbf; already backed up 1 time(s)
  1471. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_142.317.915231295; already backed up 1 time(s)
  1472. skipping archived log file /home/oracle/archivelog/1_142_913410354.dbf; already backed up 1 time(s)
  1473. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_143.319.915231297; already backed up 1 time(s)
  1474. skipping archived log file /home/oracle/archivelog/1_143_913410354.dbf; already backed up 1 time(s)
  1475. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_144.320.915231297; already backed up 1 time(s)
  1476. skipping archived log file /home/oracle/archivelog/1_144_913410354.dbf; already backed up 1 time(s)
  1477. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_145.321.915231299; already backed up 1 time(s)
  1478. skipping archived log file /home/oracle/archivelog/1_145_913410354.dbf; already backed up 1 time(s)
  1479. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_146.322.915231299; already backed up 1 time(s)
  1480. skipping archived log file /home/oracle/archivelog/1_146_913410354.dbf; already backed up 1 time(s)
  1481. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_147.291.915234531; already backed up 1 time(s)
  1482. skipping archived log file /home/oracle/archivelog/1_147_913410354.dbf; already backed up 1 time(s)
  1483. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_148.295.915234755; already backed up 1 time(s)
  1484. skipping archived log file /home/oracle/archivelog/1_148_913410354.dbf; already backed up 1 time(s)
  1485. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_149.280.915234851; already backed up 1 time(s)
  1486. skipping archived log file /home/oracle/archivelog/1_149_913410354.dbf; already backed up 1 time(s)
  1487. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_150.290.915235165; already backed up 1 time(s)
  1488. skipping archived log file /home/oracle/archivelog/1_150_913410354.dbf; already backed up 1 time(s)
  1489. skipping archived log file +FRA/orcl/archivelog/2016_06_23/thread_1_seq_151.293.915235217; already backed up 1 time(s)
  1490. skipping archived log file /home/oracle/archivelog/1_151_913410354.dbf; already backed up 1 time(s)
  1491. skipping archived log file +FRA/orcl/archivelog/2016_06_23/thread_1_seq_152.289.915235223; already backed up 1 time(s)
  1492. skipping archived log file /home/oracle/archivelog/1_152_913410354.dbf; already backed up 1 time(s)
  1493. skipping archived log file +FRA/orcl/archivelog/2016_06_23/thread_1_seq_153.292.915235303; already backed up 1 time(s)
  1494. skipping archived log file /home/oracle/archivelog/1_153_913410354.dbf; already backed up 1 time(s)
  1495. skipping archived log file +FRA/orcl/archivelog/2016_06_23/thread_1_seq_154.288.915235363; already backed up 1 time(s)
  1496. skipping archived log file /home/oracle/archivelog/1_154_913410354.dbf; already backed up 1 time(s)
  1497. skipping archived log file +FRA/orcl/archivelog/2016_06_23/thread_1_seq_155.286.915235369; already backed up 1 time(s)
  1498. skipping archived log file /home/oracle/archivelog/1_155_913410354.dbf; already backed up 1 time(s)
  1499. channel ORA_SBT_TAPE_1: input backup set: count=255, stamp=915235218, piece=1
  1500. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-23:00:14:33
  1501. channel ORA_SBT_TAPE_1: backup piece /home/oracle/manual_backup/7vr8qoci_1_1.bkp
  1502. channel ORA_SBT_TAPE_2: input backup set: count=256, stamp=915235219, piece=1
  1503. channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-23:00:14:33
  1504. channel ORA_SBT_TAPE_2: backup piece /home/oracle/manual_backup/80r8qocj_1_1.bkp
  1505. channel ORA_SBT_TAPE_3: input backup set: count=257, stamp=915235224, piece=1
  1506. channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-23:00:14:34
  1507. channel ORA_SBT_TAPE_3: backup piece /home/oracle/manual_backup/81r8qoco_1_1.bkp
  1508. channel ORA_SBT_TAPE_4: input backup set: count=258, stamp=915235225, piece=1
  1509. channel ORA_SBT_TAPE_4: starting piece 1 at 2016-06-23:00:14:34
  1510. channel ORA_SBT_TAPE_4: backup piece /home/oracle/manual_backup/82r8qocp_1_1.bkp
  1511. channel ORA_SBT_TAPE_5: input backup set: count=260, stamp=915235364, piece=1
  1512. channel ORA_SBT_TAPE_5: starting piece 1 at 2016-06-23:00:14:34
  1513. channel ORA_SBT_TAPE_5: backup piece /home/oracle/manual_backup/84r8qoh4_1_1.bkp
  1514. channel ORA_SBT_TAPE_6: input backup set: count=261, stamp=915235365, piece=1
  1515. channel ORA_SBT_TAPE_6: starting piece 1 at 2016-06-23:00:14:34
  1516. channel ORA_SBT_TAPE_6: backup piece /home/oracle/manual_backup/85r8qoh5_1_1.bkp
  1517. channel ORA_SBT_TAPE_7: input backup set: count=262, stamp=915235370, piece=1
  1518. channel ORA_SBT_TAPE_7: starting piece 1 at 2016-06-23:00:14:34
  1519. channel ORA_SBT_TAPE_7: backup piece /home/oracle/manual_backup/86r8qoha_1_1.bkp
  1520. channel ORA_SBT_TAPE_8: input backup set: count=263, stamp=915235371, piece=1
  1521. channel ORA_SBT_TAPE_8: starting piece 1 at 2016-06-23:00:14:34
  1522. channel ORA_SBT_TAPE_8: backup piece /home/oracle/manual_backup/87r8qohb_1_1.bkp
  1523. piece handle=82r8qocp_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1524. channel ORA_SBT_TAPE_4: finished piece 1 at 2016-06-23:00:14:56
  1525. channel ORA_SBT_TAPE_4: backup piece complete, elapsed time: 00:00:22
  1526. piece handle=85r8qoh5_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1527. channel ORA_SBT_TAPE_6: finished piece 1 at 2016-06-23:00:14:56
  1528. channel ORA_SBT_TAPE_6: backup piece complete, elapsed time: 00:00:22
  1529. piece handle=87r8qohb_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1530. channel ORA_SBT_TAPE_8: finished piece 1 at 2016-06-23:00:15:06
  1531. channel ORA_SBT_TAPE_8: backup piece complete, elapsed time: 00:00:32
  1532. piece handle=7vr8qoci_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1533. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-23:00:15:16
  1534. channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:00:43
  1535. piece handle=86r8qoha_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1536. channel ORA_SBT_TAPE_7: finished piece 1 at 2016-06-23:00:15:26
  1537. channel ORA_SBT_TAPE_7: backup piece complete, elapsed time: 00:00:52
  1538. piece handle=81r8qoco_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1539. channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-23:00:15:36
  1540. channel ORA_SBT_TAPE_3: backup piece complete, elapsed time: 00:01:03
  1541. piece handle=84r8qoh4_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1542. channel ORA_SBT_TAPE_5: finished piece 1 at 2016-06-23:00:15:46
  1543. channel ORA_SBT_TAPE_5: backup piece complete, elapsed time: 00:01:12
  1544. piece handle=80r8qocj_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1545. channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-23:00:15:56
  1546. channel ORA_SBT_TAPE_2: backup piece complete, elapsed time: 00:01:23
  1547. Finished backup at 2016-06-23:00:15:56

  1548. RMAN>
复制代码

复制代码


回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 01:11 , Processed in 0.048536 second(s), 24 queries .

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