开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 10004-11g管理类OCP认证班第三期 › 课程第36次：2016-06-17星期五
返回列表 发新帖
查看: 1098|回复: 0

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

[复制链接]
botang

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 /

  4. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 22 22:16:51 2016

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

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

  10. RMAN> list backup;

  12. using target database control file instead of recovery catalog

  14. List of Backup Sets
  15. ===================


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

  28. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  29. ------- ---- -- ---------- ----------- ------------ -------------------
  30. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  31.         BP Key: 214   Status: AVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  32.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  33.   List of Datafiles in backup set 198
  34.   File LV Type Ckp SCN    Ckp Time            Name
  35.   ---- -- ---- ---------- ------------------- ----
  36.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915062657

  38. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  39. ------- ---- -- ---------- ----------- ------------ -------------------
  40. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  41.         BP Key: 215   Status: AVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  42.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  43.   List of Datafiles in backup set 199
  44.   File LV Type Ckp SCN    Ckp Time            Name
  45.   ---- -- ---- ---------- ------------------- ----
  46.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915062657

  48. RMAN> change backupset 197 unAVAILABLE;

  50. changed backup piece unavailable
  51. backup piece handle=6or8lfc9_1_1 RECID=213 STAMP=915062153
  52. Changed 1 objects to UNAVAILABLE status


  55. RMAN> change backupset 198 unAVAILABLE;

  57. changed backup piece unavailable
  58. backup piece handle=6rr8lg8a_1_1 RECID=214 STAMP=915063050
  59. Changed 1 objects to UNAVAILABLE status


  62. RMAN> list backup;


  65. List of Backup Sets
  66. ===================


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

  79. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  80. ------- ---- -- ---------- ----------- ------------ -------------------
  81. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  82.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  83.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  84.   List of Datafiles in backup set 198
  85.   File LV Type Ckp SCN    Ckp Time            Name
  86.   ---- -- ---- ---------- ------------------- ----
  87.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915062657

  89. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  90. ------- ---- -- ---------- ----------- ------------ -------------------
  91. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  92.         BP Key: 215   Status: AVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  93.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  94.   List of Datafiles in backup set 199
  95.   File LV Type Ckp SCN    Ckp Time            Name
  96.   ---- -- ---- ---------- ------------------- ----
  97.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915062657

  99. RMAN> exit


  102. Recovery Manager complete.
  103. [oracle@station90 ~]$ rman target /

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

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

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

  111. RMAN> restore datafile 4;

  113. Starting restore at 2016-06-22:22:23:52
  114. using target database control file instead of recovery catalog
  115. allocated channel: ORA_DISK_1
  116. channel ORA_DISK_1: SID=198 device type=DISK
  117. allocated channel: ORA_DISK_2
  118. channel ORA_DISK_2: SID=22 device type=DISK
  119. allocated channel: ORA_DISK_3
  120. channel ORA_DISK_3: SID=86 device type=DISK
  121. allocated channel: ORA_DISK_4
  122. channel ORA_DISK_4: SID=140 device type=DISK
  123. allocated channel: ORA_DISK_5
  124. channel ORA_DISK_5: SID=206 device type=DISK
  125. allocated channel: ORA_DISK_6
  126. channel ORA_DISK_6: SID=15 device type=DISK
  127. allocated channel: ORA_DISK_7
  128. channel ORA_DISK_7: SID=149 device type=DISK
  129. allocated channel: ORA_DISK_8
  130. channel ORA_DISK_8: SID=200 device type=DISK
  131. allocated channel: ORA_SBT_TAPE_1
  132. channel ORA_SBT_TAPE_1: SID=20 device type=SBT_TAPE
  133. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  134. allocated channel: ORA_SBT_TAPE_2
  135. channel ORA_SBT_TAPE_2: SID=145 device type=SBT_TAPE
  136. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  137. allocated channel: ORA_SBT_TAPE_3
  138. channel ORA_SBT_TAPE_3: SID=9 device type=SBT_TAPE
  139. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  140. allocated channel: ORA_SBT_TAPE_4
  141. channel ORA_SBT_TAPE_4: SID=81 device type=SBT_TAPE
  142. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  143. allocated channel: ORA_SBT_TAPE_5
  144. channel ORA_SBT_TAPE_5: SID=24 device type=SBT_TAPE
  145. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  146. allocated channel: ORA_SBT_TAPE_6
  147. channel ORA_SBT_TAPE_6: SID=203 device type=SBT_TAPE
  148. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  149. allocated channel: ORA_SBT_TAPE_7
  150. channel ORA_SBT_TAPE_7: SID=75 device type=SBT_TAPE
  151. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  152. allocated channel: ORA_SBT_TAPE_8
  153. channel ORA_SBT_TAPE_8: SID=193 device type=SBT_TAPE
  154. channel ORA_SBT_TAPE_8: Oracle Secure Backup

  156. channel ORA_SBT_TAPE_1: starting datafile backup set restore
  157. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  158. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.259.915062657
  159. channel ORA_SBT_TAPE_1: reading from backup piece 6ur8qi9u_1_1
  160. RMAN-00571: ===========================================================
  161. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  162. RMAN-00571: ===========================================================
  163. RMAN-03002: failure of restore command at 06/22/2016 22:25:16
  164. ORA-19870: error while restoring backup piece 6ur8qi9u_1_1
  165. ORA-19913: unable to decrypt backup
  166. ORA-28365: wallet is not open

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

  170. executing command: SET decryption

  172. RMAN> restore datafile 4;

  174. Starting restore at 2016-06-22:22:26:57
  175. using channel ORA_DISK_1
  176. using channel ORA_DISK_2
  177. using channel ORA_DISK_3
  178. using channel ORA_DISK_4
  179. using channel ORA_DISK_5
  180. using channel ORA_DISK_6
  181. using channel ORA_DISK_7
  182. using channel ORA_DISK_8
  183. using channel ORA_SBT_TAPE_1
  184. using channel ORA_SBT_TAPE_2
  185. using channel ORA_SBT_TAPE_3
  186. using channel ORA_SBT_TAPE_4
  187. using channel ORA_SBT_TAPE_5
  188. using channel ORA_SBT_TAPE_6
  189. using channel ORA_SBT_TAPE_7
  190. using channel ORA_SBT_TAPE_8

  192. channel ORA_SBT_TAPE_1: starting datafile backup set restore
  193. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  194. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.259.915062657
  195. channel ORA_SBT_TAPE_1: reading from backup piece 6ur8qi9u_1_1
  196. channel ORA_SBT_TAPE_1: piece handle=6ur8qi9u_1_1 tag=3DET_USERS_INCR0
  197. channel ORA_SBT_TAPE_1: restored backup piece 1
  198. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
  199. Finished restore at 2016-06-22:22:27:33

  201. RMAN> recover datafile 4 ;

  203. Starting recover at 2016-06-22:22:27:41
  204. using channel ORA_DISK_1
  205. using channel ORA_DISK_2
  206. using channel ORA_DISK_3
  207. using channel ORA_DISK_4
  208. using channel ORA_DISK_5
  209. using channel ORA_DISK_6
  210. using channel ORA_DISK_7
  211. using channel ORA_DISK_8
  212. using channel ORA_SBT_TAPE_1
  213. using channel ORA_SBT_TAPE_2
  214. using channel ORA_SBT_TAPE_3
  215. using channel ORA_SBT_TAPE_4
  216. using channel ORA_SBT_TAPE_5
  217. using channel ORA_SBT_TAPE_6
  218. using channel ORA_SBT_TAPE_7
  219. using channel ORA_SBT_TAPE_8

  221. starting media recovery

  223. 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
  224. 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
  225. 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
  226. 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
  227. 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
  228. 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
  229. archived log file name=+FRA/orcl/archivelog/2016_06_22/thread_1_seq_134.325.915229249 thread=1 sequence=134
  230. archived log file name=+FRA/orcl/archivelog/2016_06_22/thread_1_seq_135.324.915229249 thread=1 sequence=135
  231. archived log file name=+FRA/orcl/archivelog/2016_06_22/thread_1_seq_136.327.915229251 thread=1 sequence=136
  232. archived log file name=+FRA/orcl/archivelog/2016_06_22/thread_1_seq_137.279.915229253 thread=1 sequence=137
  233. media recovery complete, elapsed time: 00:00:01
  234. Finished recover at 2016-06-22:22:27:43

  236. RMAN> list backup;


  239. List of Backup Sets
  240. ===================


  243. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  244. ------- ---- -- ---------- ----------- ------------ -------------------
  245. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  246.         BP Key: 213   Status: UNAVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  247.         Handle: 6or8lfc9_1_1   Media: station90-000019
  248.   List of Datafiles in backup set 197
  249.   File LV Type Ckp SCN    Ckp Time            Name
  250.   ---- -- ---- ---------- ------------------- ----
  251.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915229637

  253. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  254. ------- ---- -- ---------- ----------- ------------ -------------------
  255. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  256.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  257.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  258.   List of Datafiles in backup set 198
  259.   File LV Type Ckp SCN    Ckp Time            Name
  260.   ---- -- ---- ---------- ------------------- ----
  261.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915229637

  263. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  264. ------- ---- -- ---------- ----------- ------------ -------------------
  265. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  266.         BP Key: 215   Status: AVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  267.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  268.   List of Datafiles in backup set 199
  269.   File LV Type Ckp SCN    Ckp Time            Name
  270.   ---- -- ---- ---------- ------------------- ----
  271.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915229637

  273. RMAN> change backupset 199 unAVAILABLE;

  275. changed backup piece unavailable
  276. backup piece handle=6ur8qi9u_1_1 RECID=215 STAMP=915228991
  277. Changed 1 objects to UNAVAILABLE status


  280. RMAN> change backupset 197  AVAILABLE;

  282. using channel ORA_DISK_1
  283. using channel ORA_DISK_2
  284. using channel ORA_DISK_3
  285. using channel ORA_DISK_4
  286. using channel ORA_DISK_5
  287. using channel ORA_DISK_6
  288. using channel ORA_DISK_7
  289. using channel ORA_DISK_8
  290. using channel ORA_SBT_TAPE_1
  291. using channel ORA_SBT_TAPE_2
  292. using channel ORA_SBT_TAPE_3
  293. using channel ORA_SBT_TAPE_4
  294. using channel ORA_SBT_TAPE_5
  295. using channel ORA_SBT_TAPE_6
  296. using channel ORA_SBT_TAPE_7
  297. using channel ORA_SBT_TAPE_8
  298. changed backup piece available
  299. backup piece handle=6or8lfc9_1_1 RECID=213 STAMP=915062153
  300. Changed 1 objects to AVAILABLE status


  303. RMAN>  list backup of tablespace users ;


  306. List of Backup Sets
  307. ===================


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

  320. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  321. ------- ---- -- ---------- ----------- ------------ -------------------
  322. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  323.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  324.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  325.   List of Datafiles in backup set 198
  326.   File LV Type Ckp SCN    Ckp Time            Name
  327.   ---- -- ---- ---------- ------------------- ----
  328.   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

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

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

  360. RMAN> report need backup incremental 1 ;

  362. Report of files that need more than 1 incrementals during recovery
  363. File Incrementals Name
  364. ---- ------------ ----------------------------------------------

  366. RMAN> report need backup incremental 0 ;

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

  373. RMAN> report need backup incremental 1 ;

  375. Report of files that need more than 1 incrementals during recovery
  376. File Incrementals Name
  377. ---- ------------ ----------------------------------------------

  379. RMAN> list backup ;


  382. List of Backup Sets
  383. ===================


  386. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  387. ------- ---- -- ---------- ----------- ------------ -------------------
  388. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  389.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  390.         Handle: 6or8lfc9_1_1   Media: station90-000019
  391.   List of Datafiles in backup set 197
  392.   File LV Type Ckp SCN    Ckp Time            Name
  393.   ---- -- ---- ---------- ------------------- ----
  394.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  396. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  397. ------- ---- -- ---------- ----------- ------------ -------------------
  398. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  399.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  400.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  401.   List of Datafiles in backup set 198
  402.   File LV Type Ckp SCN    Ckp Time            Name
  403.   ---- -- ---- ---------- ------------------- ----
  404.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  406. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  407. ------- ---- -- ---------- ----------- ------------ -------------------
  408. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  409.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  410.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  411.   List of Datafiles in backup set 199
  412.   File LV Type Ckp SCN    Ckp Time            Name
  413.   ---- -- ---- ---------- ------------------- ----
  414.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  416. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  417. ------- ---- -- ---------- ----------- ------------ -------------------
  418. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  419.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  420.         Handle: 6vr8qkce_1_1   Media: station90-000019
  421.   List of Datafiles in backup set 200
  422.   File LV Type Ckp SCN    Ckp Time            Name
  423.   ---- -- ---- ---------- ------------------- ----
  424.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  426. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  427. ------- ---- -- ---------- ----------- ------------ -------------------
  428. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  429.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  430.         Handle: 70r8qke1_1_1   Media: station90-000019
  431.   List of Datafiles in backup set 201
  432.   File LV Type Ckp SCN    Ckp Time            Name
  433.   ---- -- ---- ---------- ------------------- ----
  434.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  436. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  437. ------- ---- -- ---------- ----------- ------------ -------------------
  438. 202     Incr 1  256.00K    SBT_TAPE    00:00:16     2016-06-22:22:59:40
  439.         BP Key: 218   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1C
  440.         Handle: 71r8qkqc_1_1   Media: station90-000019
  441.   List of Datafiles in backup set 202
  442.   File LV Type Ckp SCN    Ckp Time            Name
  443.   ---- -- ---- ---------- ------------------- ----
  444.   4    1  Incr 2244060    2016-06-22:22:59:24 +DATA/orcl/datafile/users.259.915231377

  446. RMAN> report need backup incremental 0;

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

  453. RMAN> report need backup incremental 1;

  455. Report of files that need more than 1 incrementals during recovery
  456. File Incrementals Name
  457. ---- ------------ ----------------------------------------------

  459. RMAN> delete backupset 202;

  461. using channel ORA_DISK_1
  462. using channel ORA_DISK_2
  463. using channel ORA_DISK_3
  464. using channel ORA_DISK_4
  465. using channel ORA_DISK_5
  466. using channel ORA_DISK_6
  467. using channel ORA_DISK_7
  468. using channel ORA_DISK_8
  469. using channel ORA_SBT_TAPE_1
  470. using channel ORA_SBT_TAPE_2
  471. using channel ORA_SBT_TAPE_3
  472. using channel ORA_SBT_TAPE_4
  473. using channel ORA_SBT_TAPE_5
  474. using channel ORA_SBT_TAPE_6
  475. using channel ORA_SBT_TAPE_7
  476. using channel ORA_SBT_TAPE_8

  478. List of Backup Pieces
  479. BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
  480. ------- ------- --- --- ----------- ----------- ----------
  481. 218     202     1   1   AVAILABLE   SBT_TAPE    71r8qkqc_1_1

  483. Do you really want to delete the above objects (enter YES or NO)? YES
  484. deleted backup piece
  485. backup piece handle=71r8qkqc_1_1 RECID=218 STAMP=915231564
  486. Deleted 1 objects


  489. RMAN> report need backup incremental 1;

  491. Report of files that need more than 1 incrementals during recovery
  492. File Incrementals Name
  493. ---- ------------ ----------------------------------------------
  494. 4    2            +DATA/orcl/datafile/users.259.915231377

  496. RMAN> report need backup incremental 2;

  498. Report of files that need more than 2 incrementals during recovery
  499. File Incrementals Name
  500. ---- ------------ ----------------------------------------------

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

  504. Starting backup at 2016-06-22:23:06:56
  505. released channel: ORA_DISK_1
  506. released channel: ORA_DISK_2
  507. released channel: ORA_DISK_3
  508. released channel: ORA_DISK_4
  509. released channel: ORA_DISK_5
  510. released channel: ORA_DISK_6
  511. released channel: ORA_DISK_7
  512. released channel: ORA_DISK_8
  513. using channel ORA_SBT_TAPE_1
  514. using channel ORA_SBT_TAPE_2
  515. using channel ORA_SBT_TAPE_3
  516. using channel ORA_SBT_TAPE_4
  517. using channel ORA_SBT_TAPE_5
  518. using channel ORA_SBT_TAPE_6
  519. using channel ORA_SBT_TAPE_7
  520. using channel ORA_SBT_TAPE_8
  521. channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set
  522. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  523. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915231377
  524. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-22:23:06:56
  525. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-22:23:07:21
  526. piece handle=72r8ql8g_1_1 tag=6T_USERS_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
  527. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  528. Finished backup at 2016-06-22:23:07:21

  530. RMAN> report need backup incremental 2;

  532. Report of files that need more than 2 incrementals during recovery
  533. File Incrementals Name
  534. ---- ------------ ----------------------------------------------
  535. 4    3            +DATA/orcl/datafile/users.259.915231377

  537. RMAN> report need backup incremental 0;

  539. Report of files that need more than 0 incrementals during recovery
  540. File Incrementals Name
  541. ---- ------------ ----------------------------------------------
  542. 4    3            +DATA/orcl/datafile/users.259.915231377

  544. RMAN> report need backup incremental 1;

  546. Report of files that need more than 1 incrementals during recovery
  547. File Incrementals Name
  548. ---- ------------ ----------------------------------------------
  549. 4    3            +DATA/orcl/datafile/users.259.915231377

  551. RMAN> exit


  554. Recovery Manager complete.
  555. [oracle@station90 ~]$ rman target  /

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

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

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

  563. RMAN> list backup;

  565. using target database control file instead of recovery catalog

  567. List of Backup Sets
  568. ===================


  571. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  572. ------- ---- -- ---------- ----------- ------------ -------------------
  573. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  574.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  575.         Handle: 6or8lfc9_1_1   Media: station90-000019
  576.   List of Datafiles in backup set 197
  577.   File LV Type Ckp SCN    Ckp Time            Name
  578.   ---- -- ---- ---------- ------------------- ----
  579.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  581. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  582. ------- ---- -- ---------- ----------- ------------ -------------------
  583. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  584.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  585.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  586.   List of Datafiles in backup set 198
  587.   File LV Type Ckp SCN    Ckp Time            Name
  588.   ---- -- ---- ---------- ------------------- ----
  589.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  591. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  592. ------- ---- -- ---------- ----------- ------------ -------------------
  593. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  594.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  595.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  596.   List of Datafiles in backup set 199
  597.   File LV Type Ckp SCN    Ckp Time            Name
  598.   ---- -- ---- ---------- ------------------- ----
  599.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  601. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  602. ------- ---- -- ---------- ----------- ------------ -------------------
  603. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  604.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  605.         Handle: 6vr8qkce_1_1   Media: station90-000019
  606.   List of Datafiles in backup set 200
  607.   File LV Type Ckp SCN    Ckp Time            Name
  608.   ---- -- ---- ---------- ------------------- ----
  609.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  611. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  612. ------- ---- -- ---------- ----------- ------------ -------------------
  613. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  614.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  615.         Handle: 70r8qke1_1_1   Media: station90-000019
  616.   List of Datafiles in backup set 201
  617.   File LV Type Ckp SCN    Ckp Time            Name
  618.   ---- -- ---- ---------- ------------------- ----
  619.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  621. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  622. ------- ---- -- ---------- ----------- ------------ -------------------
  623. 203     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  624.         BP Key: 219   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  625.         Handle: 72r8ql8g_1_1   Media: station90-000019
  626.   List of Datafiles in backup set 203
  627.   File LV Type Ckp SCN    Ckp Time            Name
  628.   ---- -- ---- ---------- ------------------- ----
  629.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  631. RMAN> show all;

  633. RMAN configuration parameters for database with db_unique_name ORCL are:
  634. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  635. CONFIGURE BACKUP OPTIMIZATION ON;
  636. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  637. CONFIGURE CONTROLFILE AUTOBACKUP OFF;
  638. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  639. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  640. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO COMPRESSED BACKUPSET;
  641. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  642. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  643. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  644. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  645. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  646. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  647. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  648. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  649. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  650. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  651. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  652. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  653. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  654. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  655. CONFIGURE ENCRYPTION FOR DATABASE ON;
  656. CONFIGURE ENCRYPTION ALGORITHM 'AES256';
  657. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  658. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  659. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  661. RMAN> backup backupset 197 delete input;

  663. Starting backup at 2016-06-22:23:15:29
  664. allocated channel: ORA_SBT_TAPE_1
  665. channel ORA_SBT_TAPE_1: SID=193 device type=SBT_TAPE
  666. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  667. allocated channel: ORA_SBT_TAPE_2
  668. channel ORA_SBT_TAPE_2: SID=139 device type=SBT_TAPE
  669. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  670. allocated channel: ORA_SBT_TAPE_3
  671. channel ORA_SBT_TAPE_3: SID=9 device type=SBT_TAPE
  672. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  673. allocated channel: ORA_SBT_TAPE_4
  674. channel ORA_SBT_TAPE_4: SID=194 device type=SBT_TAPE
  675. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  676. allocated channel: ORA_SBT_TAPE_5
  677. channel ORA_SBT_TAPE_5: SID=148 device type=SBT_TAPE
  678. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  679. allocated channel: ORA_SBT_TAPE_6
  680. channel ORA_SBT_TAPE_6: SID=21 device type=SBT_TAPE
  681. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  682. allocated channel: ORA_SBT_TAPE_7
  683. channel ORA_SBT_TAPE_7: SID=149 device type=SBT_TAPE
  684. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  685. allocated channel: ORA_SBT_TAPE_8
  686. channel ORA_SBT_TAPE_8: SID=198 device type=SBT_TAPE
  687. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  688. RMAN-00571: ===========================================================
  689. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  690. RMAN-00571: ===========================================================
  691. RMAN-03002: failure of backup command at 06/22/2016 23:16:12
  692. RMAN-06160: no backup pieces found for backup set key: 197

  694. RMAN> run {
  695. 2> allocate channel c1 device type disk;
  696. 3> backup  tag '7D_USERS_INCR0'  incremental level 0  tablespace users ;
  697. 4> }

  699. released channel: ORA_SBT_TAPE_1
  700. released channel: ORA_SBT_TAPE_2
  701. released channel: ORA_SBT_TAPE_3
  702. released channel: ORA_SBT_TAPE_4
  703. released channel: ORA_SBT_TAPE_5
  704. released channel: ORA_SBT_TAPE_6
  705. released channel: ORA_SBT_TAPE_7
  706. released channel: ORA_SBT_TAPE_8
  707. allocated channel: c1
  708. channel c1: SID=193 device type=DISK

  710. Starting backup at 2016-06-22:23:17:38
  711. channel c1: starting compressed incremental level 0 datafile backup set
  712. channel c1: specifying datafile(s) in backup set
  713. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915231377
  714. channel c1: starting piece 1 at 2016-06-22:23:17:38
  715. channel c1: finished piece 1 at 2016-06-22:23:17:39
  716. piece handle=+FRA/orcl/backupset/2016_06_22/nnndn0_7d_users_incr0_0.291.915232659 tag=7D_USERS_INCR0 comment=NONE
  717. channel c1: backup set complete, elapsed time: 00:00:01
  718. Finished backup at 2016-06-22:23:17:39
  719. released channel: c1

  721. RMAN> list backup;


  724. List of Backup Sets
  725. ===================


  728. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  729. ------- ---- -- ---------- ----------- ------------ -------------------
  730. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  731.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  732.         Handle: 6or8lfc9_1_1   Media: station90-000019
  733.   List of Datafiles in backup set 197
  734.   File LV Type Ckp SCN    Ckp Time            Name
  735.   ---- -- ---- ---------- ------------------- ----
  736.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  738. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  739. ------- ---- -- ---------- ----------- ------------ -------------------
  740. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  741.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  742.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  743.   List of Datafiles in backup set 198
  744.   File LV Type Ckp SCN    Ckp Time            Name
  745.   ---- -- ---- ---------- ------------------- ----
  746.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  748. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  749. ------- ---- -- ---------- ----------- ------------ -------------------
  750. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  751.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  752.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  753.   List of Datafiles in backup set 199
  754.   File LV Type Ckp SCN    Ckp Time            Name
  755.   ---- -- ---- ---------- ------------------- ----
  756.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  758. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  759. ------- ---- -- ---------- ----------- ------------ -------------------
  760. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  761.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  762.         Handle: 6vr8qkce_1_1   Media: station90-000019
  763.   List of Datafiles in backup set 200
  764.   File LV Type Ckp SCN    Ckp Time            Name
  765.   ---- -- ---- ---------- ------------------- ----
  766.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  768. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  769. ------- ---- -- ---------- ----------- ------------ -------------------
  770. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  771.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  772.         Handle: 70r8qke1_1_1   Media: station90-000019
  773.   List of Datafiles in backup set 201
  774.   File LV Type Ckp SCN    Ckp Time            Name
  775.   ---- -- ---- ---------- ------------------- ----
  776.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  778. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  779. ------- ---- -- ---------- ----------- ------------ -------------------
  780. 203     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  781.         BP Key: 219   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  782.         Handle: 72r8ql8g_1_1   Media: station90-000019
  783.   List of Datafiles in backup set 203
  784.   File LV Type Ckp SCN    Ckp Time            Name
  785.   ---- -- ---- ---------- ------------------- ----
  786.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  788. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  789. ------- ---- -- ---------- ----------- ------------ -------------------
  790. 204     Incr 0  1.02M      DISK        00:00:01     2016-06-22:23:17:39
  791.         BP Key: 220   Status: AVAILABLE  Compressed: YES  Tag: 7D_USERS_INCR0
  792.         Piece Name: +FRA/orcl/backupset/2016_06_22/nnndn0_7d_users_incr0_0.291.915232659
  793.   List of Datafiles in backup set 204
  794.   File LV Type Ckp SCN    Ckp Time            Name
  795.   ---- -- ---- ---------- ------------------- ----
  796.   4    0  Incr 2246402    2016-06-22:23:17:38 +DATA/orcl/datafile/users.259.915231377

  798. RMAN> backup backupset 204 delete input;

  800. Starting backup at 2016-06-22:23:18:00
  801. allocated channel: ORA_SBT_TAPE_1
  802. channel ORA_SBT_TAPE_1: SID=193 device type=SBT_TAPE
  803. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  804. allocated channel: ORA_SBT_TAPE_2
  805. channel ORA_SBT_TAPE_2: SID=139 device type=SBT_TAPE
  806. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  807. allocated channel: ORA_SBT_TAPE_3
  808. channel ORA_SBT_TAPE_3: SID=9 device type=SBT_TAPE
  809. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  810. allocated channel: ORA_SBT_TAPE_4
  811. channel ORA_SBT_TAPE_4: SID=194 device type=SBT_TAPE
  812. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  813. allocated channel: ORA_SBT_TAPE_5
  814. channel ORA_SBT_TAPE_5: SID=148 device type=SBT_TAPE
  815. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  816. allocated channel: ORA_SBT_TAPE_6
  817. channel ORA_SBT_TAPE_6: SID=21 device type=SBT_TAPE
  818. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  819. allocated channel: ORA_SBT_TAPE_7
  820. channel ORA_SBT_TAPE_7: SID=149 device type=SBT_TAPE
  821. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  822. allocated channel: ORA_SBT_TAPE_8
  823. channel ORA_SBT_TAPE_8: SID=198 device type=SBT_TAPE
  824. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  825. skipping backup set key 204; already backed up 1 time(s)
  826. deleted backup piece
  827. backup piece handle=+FRA/orcl/backupset/2016_06_22/nnndn0_7d_users_incr0_0.291.915232659 RECID=220 STAMP=915232658
  828. Finished backup at 2016-06-22:23:18:44

  830. RMAN> list backup;


  833. List of Backup Sets
  834. ===================


  837. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  838. ------- ---- -- ---------- ----------- ------------ -------------------
  839. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  840.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  841.         Handle: 6or8lfc9_1_1   Media: station90-000019
  842.   List of Datafiles in backup set 197
  843.   File LV Type Ckp SCN    Ckp Time            Name
  844.   ---- -- ---- ---------- ------------------- ----
  845.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  847. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  848. ------- ---- -- ---------- ----------- ------------ -------------------
  849. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  850.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  851.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  852.   List of Datafiles in backup set 198
  853.   File LV Type Ckp SCN    Ckp Time            Name
  854.   ---- -- ---- ---------- ------------------- ----
  855.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  857. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  858. ------- ---- -- ---------- ----------- ------------ -------------------
  859. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  860.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  861.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  862.   List of Datafiles in backup set 199
  863.   File LV Type Ckp SCN    Ckp Time            Name
  864.   ---- -- ---- ---------- ------------------- ----
  865.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  867. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  868. ------- ---- -- ---------- ----------- ------------ -------------------
  869. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  870.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  871.         Handle: 6vr8qkce_1_1   Media: station90-000019
  872.   List of Datafiles in backup set 200
  873.   File LV Type Ckp SCN    Ckp Time            Name
  874.   ---- -- ---- ---------- ------------------- ----
  875.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  877. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  878. ------- ---- -- ---------- ----------- ------------ -------------------
  879. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  880.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  881.         Handle: 70r8qke1_1_1   Media: station90-000019
  882.   List of Datafiles in backup set 201
  883.   File LV Type Ckp SCN    Ckp Time            Name
  884.   ---- -- ---- ---------- ------------------- ----
  885.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  887. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  888. ------- ---- -- ---------- ----------- ------------ -------------------
  889. 203     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  890.         BP Key: 219   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  891.         Handle: 72r8ql8g_1_1   Media: station90-000019
  892.   List of Datafiles in backup set 203
  893.   File LV Type Ckp SCN    Ckp Time            Name
  894.   ---- -- ---- ---------- ------------------- ----
  895.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  897. RMAN> run {
  898. 2> backup  tag '8D_USERS_INCR0'  incremental level 0  tablespace users ;
  899. 3>
  900. user interrupt received

  902. user interrupt received

  904. 4>

  906. RMAN-00571: ===========================================================
  907. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  908. RMAN-00571: ===========================================================
  909. RMAN-00558: error encountered while parsing input commands
  910. 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, }"
  911. RMAN-01007: at line 4 column 1 file: standard input

  913. RMAN>

  915. RMAN> exit


  918. Recovery Manager complete.
  919. [oracle@station90 ~]$ rman target  /

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

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

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

  927. RMAN> run {
  928. 2> allocate channel c1 device type disk;
  929. 3> backup  tag '8D_USERS_INCR0'  incremental level 0  tablespace users ;
  930. 4> }

  932. using target database control file instead of recovery catalog
  933. allocated channel: c1
  934. channel c1: SID=145 device type=DISK

  936. Starting backup at 2016-06-22:23:19:51
  937. channel c1: starting compressed incremental level 0 datafile backup set
  938. channel c1: specifying datafile(s) in backup set
  939. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915231377
  940. channel c1: starting piece 1 at 2016-06-22:23:19:51
  941. channel c1: finished piece 1 at 2016-06-22:23:19:52
  942. piece handle=+FRA/orcl/backupset/2016_06_22/nnndn0_8d_users_incr0_0.291.915232791 tag=8D_USERS_INCR0 comment=NONE
  943. channel c1: backup set complete, elapsed time: 00:00:01
  944. Finished backup at 2016-06-22:23:19:52
  945. released channel: c1

  947. RMAN> list backup;


  950. List of Backup Sets
  951. ===================


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

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

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

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

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

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

  1014. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1015. ------- ---- -- ---------- ----------- ------------ -------------------
  1016. 205     Incr 0  1.02M      DISK        00:00:00     2016-06-22:23:19:51
  1017.         BP Key: 221   Status: AVAILABLE  Compressed: YES  Tag: 8D_USERS_INCR0
  1018.         Piece Name: +FRA/orcl/backupset/2016_06_22/nnndn0_8d_users_incr0_0.291.915232791
  1019.   List of Datafiles in backup set 205
  1020.   File LV Type Ckp SCN    Ckp Time            Name
  1021.   ---- -- ---- ---------- ------------------- ----
  1022.   4    0  Incr 2246580    2016-06-22:23:19:51 +DATA/orcl/datafile/users.259.915231377

  1024. RMAN> backup backupset 204  force   delete input  ;

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

  1028. user interrupt received

  1030. user interrupt received

  1032. user interrupt received

  1034. user interrupt received

  1036. user interrupt received


  1039. user interrupt received

  1041. user interrupt received


  1044. user interrupt received
  1045. RMAN-00571: ===========================================================
  1046. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  1047. RMAN-00571: ===========================================================
  1048. RMAN-03002: failure of backup command at 06/22/2016 23:20:39
  1049. ORA-03111: break received on communication channel

  1051. RMAN>
  1052. RMAN>
  1053. RMAN> exit


  1056. Recovery Manager complete.
  1057. [oracle@station90 ~]$ rman target  /

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

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

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

  1065. RMAN> list backup;

  1067. using target database control file instead of recovery catalog

  1069. List of Backup Sets
  1070. ===================


  1073. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1074. ------- ---- -- ---------- ----------- ------------ -------------------
  1075. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  1076.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  1077.         Handle: 6or8lfc9_1_1   Media: station90-000019
  1078.   List of Datafiles in backup set 197
  1079.   File LV Type Ckp SCN    Ckp Time            Name
  1080.   ---- -- ---- ---------- ------------------- ----
  1081.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  1083. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1084. ------- ---- -- ---------- ----------- ------------ -------------------
  1085. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  1086.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  1087.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  1088.   List of Datafiles in backup set 198
  1089.   File LV Type Ckp SCN    Ckp Time            Name
  1090.   ---- -- ---- ---------- ------------------- ----
  1091.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  1093. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1094. ------- ---- -- ---------- ----------- ------------ -------------------
  1095. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  1096.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  1097.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  1098.   List of Datafiles in backup set 199
  1099.   File LV Type Ckp SCN    Ckp Time            Name
  1100.   ---- -- ---- ---------- ------------------- ----
  1101.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  1103. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1104. ------- ---- -- ---------- ----------- ------------ -------------------
  1105. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  1106.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  1107.         Handle: 6vr8qkce_1_1   Media: station90-000019
  1108.   List of Datafiles in backup set 200
  1109.   File LV Type Ckp SCN    Ckp Time            Name
  1110.   ---- -- ---- ---------- ------------------- ----
  1111.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  1113. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1114. ------- ---- -- ---------- ----------- ------------ -------------------
  1115. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  1116.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  1117.         Handle: 70r8qke1_1_1   Media: station90-000019
  1118.   List of Datafiles in backup set 201
  1119.   File LV Type Ckp SCN    Ckp Time            Name
  1120.   ---- -- ---- ---------- ------------------- ----
  1121.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  1123. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1124. ------- ---- -- ---------- ----------- ------------ -------------------
  1125. 203     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  1126.         BP Key: 219   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  1127.         Handle: 72r8ql8g_1_1   Media: station90-000019
  1128.   List of Datafiles in backup set 203
  1129.   File LV Type Ckp SCN    Ckp Time            Name
  1130.   ---- -- ---- ---------- ------------------- ----
  1131.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  1133. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1134. ------- ---- -- ---------- ----------- ------------ -------------------
  1135. 205     Incr 0  1.02M      DISK        00:00:00     2016-06-22:23:19:51
  1136.         BP Key: 221   Status: AVAILABLE  Compressed: YES  Tag: 8D_USERS_INCR0
  1137.         Piece Name: +FRA/orcl/backupset/2016_06_22/nnndn0_8d_users_incr0_0.291.915232791
  1138.   List of Datafiles in backup set 205
  1139.   File LV Type Ckp SCN    Ckp Time            Name
  1140.   ---- -- ---- ---------- ------------------- ----
  1141.   4    0  Incr 2246580    2016-06-22:23:19:51 +DATA/orcl/datafile/users.259.915231377

  1143. RMAN> backup backupset 205  force   delete input  ;

  1145. Starting backup at 2016-06-22:23:20:51
  1146. allocated channel: ORA_SBT_TAPE_1
  1147. channel ORA_SBT_TAPE_1: SID=81 device type=SBT_TAPE
  1148. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  1149. allocated channel: ORA_SBT_TAPE_2
  1150. channel ORA_SBT_TAPE_2: SID=194 device type=SBT_TAPE
  1151. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  1152. allocated channel: ORA_SBT_TAPE_3
  1153. channel ORA_SBT_TAPE_3: SID=139 device type=SBT_TAPE
  1154. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  1155. allocated channel: ORA_SBT_TAPE_4
  1156. channel ORA_SBT_TAPE_4: SID=9 device type=SBT_TAPE
  1157. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  1158. allocated channel: ORA_SBT_TAPE_5
  1159. channel ORA_SBT_TAPE_5: SID=17 device type=SBT_TAPE
  1160. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  1161. allocated channel: ORA_SBT_TAPE_6
  1162. channel ORA_SBT_TAPE_6: SID=150 device type=SBT_TAPE
  1163. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  1164. allocated channel: ORA_SBT_TAPE_7
  1165. channel ORA_SBT_TAPE_7: SID=197 device type=SBT_TAPE
  1166. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  1167. allocated channel: ORA_SBT_TAPE_8
  1168. channel ORA_SBT_TAPE_8: SID=75 device type=SBT_TAPE
  1169. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  1170. channel ORA_SBT_TAPE_1: input backup set: count=228, stamp=915232791, piece=1
  1171. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-22:23:21:36
  1172. channel ORA_SBT_TAPE_1: backup piece +FRA/orcl/backupset/2016_06_22/nnndn0_8d_users_incr0_0.291.915232791
  1173. piece handle=74r8qm0n_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1174. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-22:23:22:01
  1175. channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:00:25
  1176. deleted backup piece
  1177. backup piece handle=+FRA/orcl/backupset/2016_06_22/nnndn0_8d_users_incr0_0.291.915232791 RECID=221 STAMP=915232791
  1178. Finished backup at 2016-06-22:23:22:01

  1180. RMAN> list backup;


  1183. List of Backup Sets
  1184. ===================


  1187. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1188. ------- ---- -- ---------- ----------- ------------ -------------------
  1189. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  1190.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  1191.         Handle: 6or8lfc9_1_1   Media: station90-000019
  1192.   List of Datafiles in backup set 197
  1193.   File LV Type Ckp SCN    Ckp Time            Name
  1194.   ---- -- ---- ---------- ------------------- ----
  1195.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  1197. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1198. ------- ---- -- ---------- ----------- ------------ -------------------
  1199. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  1200.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  1201.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  1202.   List of Datafiles in backup set 198
  1203.   File LV Type Ckp SCN    Ckp Time            Name
  1204.   ---- -- ---- ---------- ------------------- ----
  1205.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  1207. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1208. ------- ---- -- ---------- ----------- ------------ -------------------
  1209. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  1210.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  1211.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  1212.   List of Datafiles in backup set 199
  1213.   File LV Type Ckp SCN    Ckp Time            Name
  1214.   ---- -- ---- ---------- ------------------- ----
  1215.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  1217. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1218. ------- ---- -- ---------- ----------- ------------ -------------------
  1219. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  1220.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  1221.         Handle: 6vr8qkce_1_1   Media: station90-000019
  1222.   List of Datafiles in backup set 200
  1223.   File LV Type Ckp SCN    Ckp Time            Name
  1224.   ---- -- ---- ---------- ------------------- ----
  1225.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  1227. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1228. ------- ---- -- ---------- ----------- ------------ -------------------
  1229. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  1230.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  1231.         Handle: 70r8qke1_1_1   Media: station90-000019
  1232.   List of Datafiles in backup set 201
  1233.   File LV Type Ckp SCN    Ckp Time            Name
  1234.   ---- -- ---- ---------- ------------------- ----
  1235.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  1237. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1238. ------- ---- -- ---------- ----------- ------------ -------------------
  1239. 203     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  1240.         BP Key: 219   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  1241.         Handle: 72r8ql8g_1_1   Media: station90-000019
  1242.   List of Datafiles in backup set 203
  1243.   File LV Type Ckp SCN    Ckp Time            Name
  1244.   ---- -- ---- ---------- ------------------- ----
  1245.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  1247. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1248. ------- ---- -- ---------- ----------- ------------ -------------------
  1249. 205     Incr 0  1.02M      SBT_TAPE    00:00:00     2016-06-22:23:19:51
  1250.         BP Key: 222   Status: AVAILABLE  Compressed: YES  Tag: 8D_USERS_INCR0
  1251.         Handle: 74r8qm0n_1_2   Media: station90-000019
  1252.   List of Datafiles in backup set 205
  1253.   File LV Type Ckp SCN    Ckp Time            Name
  1254.   ---- -- ---- ---------- ------------------- ----
  1255.   4    0  Incr 2246580    2016-06-22:23:19:51 +DATA/orcl/datafile/users.259.915231377

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

  1259. Starting backup at 2016-06-22:23:24:36
  1260. using channel ORA_SBT_TAPE_1
  1261. using channel ORA_SBT_TAPE_2
  1262. using channel ORA_SBT_TAPE_3
  1263. using channel ORA_SBT_TAPE_4
  1264. using channel ORA_SBT_TAPE_5
  1265. using channel ORA_SBT_TAPE_6
  1266. using channel ORA_SBT_TAPE_7
  1267. using channel ORA_SBT_TAPE_8
  1268. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  1269. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  1270. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  1271. backing up blocks 1 through 12800
  1272. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-22:23:24:36
  1273. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  1274. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  1275. channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
  1276. channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
  1277. including current SPFILE in backup set
  1278. channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-22:23:24:37
  1279. channel ORA_SBT_TAPE_4: starting incremental level 0 datafile backup set
  1280. channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
  1281. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  1282. backing up blocks 12801 through 25600
  1283. channel ORA_SBT_TAPE_4: starting piece 2 at 2016-06-22:23:24:37
  1284. channel ORA_SBT_TAPE_5: starting incremental level 0 datafile backup set
  1285. channel ORA_SBT_TAPE_5: specifying datafile(s) in backup set
  1286. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  1287. backing up blocks 25601 through 38400
  1288. channel ORA_SBT_TAPE_5: starting piece 3 at 2016-06-22:23:24:37
  1289. channel ORA_SBT_TAPE_6: starting incremental level 0 datafile backup set
  1290. channel ORA_SBT_TAPE_6: specifying datafile(s) in backup set
  1291. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  1292. backing up blocks 38401 through 51200
  1293. channel ORA_SBT_TAPE_6: starting piece 4 at 2016-06-22:23:24:37
  1294. channel ORA_SBT_TAPE_7: starting incremental level 0 datafile backup set
  1295. channel ORA_SBT_TAPE_7: specifying datafile(s) in backup set
  1296. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  1297. backing up blocks 51201 through 64000
  1298. channel ORA_SBT_TAPE_7: starting piece 5 at 2016-06-22:23:24:37
  1299. channel ORA_SBT_TAPE_8: starting incremental level 0 datafile backup set
  1300. channel ORA_SBT_TAPE_8: specifying datafile(s) in backup set
  1301. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  1302. backing up blocks 64001 through 76800
  1303. channel ORA_SBT_TAPE_8: starting piece 6 at 2016-06-22:23:24:38
  1304. including current control file in backup set
  1305. channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-22:23:24:38
  1306. channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-22:23:25:03
  1307. piece handle=77r8qm9k_1_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1308. channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:00:26
  1309. channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
  1310. channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
  1311. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
  1312. backing up blocks 76801 through 89600
  1313. channel ORA_SBT_TAPE_3: starting piece 7 at 2016-06-22:23:25:03
  1314. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-22:23:25:06
  1315. piece handle=75r8qm9k_1_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1316. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:30
  1317. channel ORA_SBT_TAPE_4: finished piece 2 at 2016-06-22:23:25:28
  1318. piece handle=75r8qm9k_2_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1319. channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:00:51
  1320. channel ORA_SBT_TAPE_7: finished piece 5 at 2016-06-22:23:25:38
  1321. piece handle=75r8qm9k_5_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1322. channel ORA_SBT_TAPE_7: backup set complete, elapsed time: 00:01:01
  1323. channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-22:23:26:07
  1324. piece handle=76r8qm9k_1_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1325. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:29
  1326. channel ORA_SBT_TAPE_5: finished piece 3 at 2016-06-22:23:26:07
  1327. piece handle=75r8qm9k_3_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1328. channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:01:30
  1329. channel ORA_SBT_TAPE_6: finished piece 4 at 2016-06-22:23:26:27
  1330. piece handle=75r8qm9k_4_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1331. channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:01:50
  1332. channel ORA_SBT_TAPE_8: finished piece 6 at 2016-06-22:23:26:27
  1333. piece handle=75r8qm9k_6_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1334. channel ORA_SBT_TAPE_8: backup set complete, elapsed time: 00:01:49
  1335. channel ORA_SBT_TAPE_3: finished piece 7 at 2016-06-22:23:26:47
  1336. piece handle=75r8qm9k_7_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  1337. channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:01:44
  1338. Finished backup at 2016-06-22:23:26:47

  1340. RMAN> list backup of tablespace system ;


  1343. List of Backup Sets
  1344. ===================


  1347. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1348. ------- ---- -- ---------- ----------- ------------ -------------------
  1349. 207     Incr 0  605.25M    SBT_TAPE    00:02:06     2016-06-22:23:26:42
  1350.   List of Datafiles in backup set 207
  1351.   File LV Type Ckp SCN    Ckp Time            Name
  1352.   ---- -- ---- ---------- ------------------- ----
  1353.   1    0  Incr 2246939    2016-06-22:23:24:36 +DATA/orcl/datafile/system.256.914102913

  1355.   Backup Set Copy #1 of backup set 207
  1356.   Device Type Elapsed Time Completion Time     Compressed Tag
  1357.   ----------- ------------ ------------------- ---------- ---
  1358.   SBT_TAPE    00:02:06     2016-06-22:23:26:42 NO         1T_SYSTEM_INCR0

  1360.     List of Backup Pieces for backup set 207 Copy #1
  1361.     BP Key  Pc# Status      Media                   Piece Name
  1362.     ------- --- ----------- ----------------------- ----------
  1363.     224     1   AVAILABLE   station90-000019        75r8qm9k_1_1
  1364.     225     2   AVAILABLE   station90-000020        75r8qm9k_2_1
  1365.     228     3   AVAILABLE   station90-000019        75r8qm9k_3_1
  1366.     229     4   AVAILABLE   station90-000020        75r8qm9k_4_1
  1367.     226     5   AVAILABLE   station90-000019        75r8qm9k_5_1
  1368.     230     6   AVAILABLE   station90-000019        75r8qm9k_6_1
  1369.     231     7   AVAILABLE   station90-000020        75r8qm9k_7_1

  1371. RMAN> validate datafile 1 ;

  1373. Starting validate at 2016-06-22:23:30:37
  1374. released channel: ORA_SBT_TAPE_1
  1375. released channel: ORA_SBT_TAPE_2
  1376. released channel: ORA_SBT_TAPE_3
  1377. released channel: ORA_SBT_TAPE_4
  1378. released channel: ORA_SBT_TAPE_5
  1379. released channel: ORA_SBT_TAPE_6
  1380. released channel: ORA_SBT_TAPE_7
  1381. released channel: ORA_SBT_TAPE_8
  1382. allocated channel: ORA_DISK_1
  1383. channel ORA_DISK_1: SID=81 device type=DISK
  1384. allocated channel: ORA_DISK_2
  1385. channel ORA_DISK_2: SID=194 device type=DISK
  1386. 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            

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

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

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

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

  126. RMAN>
  127. user interrupt received

  129. user interrupt received


  132. RMAN>

  134. RMAN>

  136. RMAN> exit


  139. Recovery Manager complete.
  140. [oracle@station90 ~]$ rman target  /

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

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

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

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

  150. Starting backup at 2016-06-22:23:48:51
  151. current log archived

  153. using target database control file instead of recovery catalog
  154. allocated channel: ORA_SBT_TAPE_1
  155. channel ORA_SBT_TAPE_1: SID=75 device type=SBT_TAPE
  156. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  157. allocated channel: ORA_SBT_TAPE_2
  158. channel ORA_SBT_TAPE_2: SID=197 device type=SBT_TAPE
  159. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  160. allocated channel: ORA_SBT_TAPE_3
  161. channel ORA_SBT_TAPE_3: SID=150 device type=SBT_TAPE
  162. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  163. allocated channel: ORA_SBT_TAPE_4
  164. channel ORA_SBT_TAPE_4: SID=20 device type=SBT_TAPE
  165. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  166. allocated channel: ORA_SBT_TAPE_5
  167. channel ORA_SBT_TAPE_5: SID=148 device type=SBT_TAPE
  168. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  169. allocated channel: ORA_SBT_TAPE_6
  170. channel ORA_SBT_TAPE_6: SID=145 device type=SBT_TAPE
  171. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  172. allocated channel: ORA_SBT_TAPE_7
  173. channel ORA_SBT_TAPE_7: SID=206 device type=SBT_TAPE
  174. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  175. allocated channel: ORA_SBT_TAPE_8
  176. channel ORA_SBT_TAPE_8: SID=71 device type=SBT_TAPE
  177. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  178. RMAN-00571: ===========================================================
  179. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  180. RMAN-00571: ===========================================================
  181. RMAN-03002: failure of backup command at 06/22/2016 23:49:35
  182. RMAN-06522: KEEP FOREVER option is not supported without the recovery catalog

  184. RMAN> exit


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

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

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

  194. connected to target database: ORCL (DBID=1343950367)
  195. RMAN-00571: ===========================================================
  196. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  197. RMAN-00571: ===========================================================
  198. RMAN-00554: initialization of internal recovery manager package failed
  199. RMAN-04004: error from recovery catalog database: ORA-01017: invalid username/password; logon denied
  200. [oracle@station90 ~]$ . oraenv
  201. ORACLE_SID = [orcl] ? rcat
  202. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
  203. [oracle@station90 ~]$ sqlplus /nolog

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

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

  209. SQL> conn / as sysdba
  210. Connected.
  211. SQL> create user u90 identified by oracle_4U default tablespace rcat quota unlimited on rcat ;

  213. User created.

  215. SQL> grant recovery_catalog_owner to u90;

  217. Grant succeeded.

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

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

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

  231. connected to target database: ORCL (DBID=1343950367)
  232. connected to recovery catalog database

  234. RMAN> create catalog

  236. ;
  237. recovery catalog created

  239. RMAN>
  240. RMAN-00571: ===========================================================
  241. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  242. RMAN-00571: ===========================================================
  243. RMAN-00558: error encountered while parsing input commands
  244. 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, {, "
  245. RMAN-01007: at line 1 column 1 file: standard input

  247. RMAN> register database ;

  249. database registered in recovery catalog
  250. starting full resync of recovery catalog
  251. full resync complete

  253. RMAN> exit


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

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

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

  263. connected to target database: ORCL (DBID=1343950367)
  264. connected to recovery catalog database

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

  268. Starting backup at 2016-06-22:23:52:34
  269. current log archived

  271. allocated channel: ORA_SBT_TAPE_1
  272. channel ORA_SBT_TAPE_1: SID=148 device type=SBT_TAPE
  273. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  274. allocated channel: ORA_SBT_TAPE_2
  275. channel ORA_SBT_TAPE_2: SID=20 device type=SBT_TAPE
  276. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  277. allocated channel: ORA_SBT_TAPE_3
  278. channel ORA_SBT_TAPE_3: SID=150 device type=SBT_TAPE
  279. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  280. allocated channel: ORA_SBT_TAPE_4
  281. channel ORA_SBT_TAPE_4: SID=145 device type=SBT_TAPE
  282. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  283. allocated channel: ORA_SBT_TAPE_5
  284. channel ORA_SBT_TAPE_5: SID=9 device type=SBT_TAPE
  285. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  286. allocated channel: ORA_SBT_TAPE_6
  287. channel ORA_SBT_TAPE_6: SID=149 device type=SBT_TAPE
  288. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  289. allocated channel: ORA_SBT_TAPE_7
  290. channel ORA_SBT_TAPE_7: SID=212 device type=SBT_TAPE
  291. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  292. allocated channel: ORA_SBT_TAPE_8
  293. channel ORA_SBT_TAPE_8: SID=81 device type=SBT_TAPE
  294. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  295. backup will never be obsolete
  296. archived logs required to recover from this backup will be backed up
  297. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  298. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  299. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915231377
  300. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-22:23:53:19
  301. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-22:23:53:44
  302. piece handle=7qr8qnvf_1_1 tag=9T_USERS_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  303. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25

  305. using channel ORA_SBT_TAPE_1
  306. using channel ORA_SBT_TAPE_2
  307. using channel ORA_SBT_TAPE_3
  308. using channel ORA_SBT_TAPE_4
  309. using channel ORA_SBT_TAPE_5
  310. using channel ORA_SBT_TAPE_6
  311. using channel ORA_SBT_TAPE_7
  312. using channel ORA_SBT_TAPE_8
  313. backup will never be obsolete
  314. archived logs required to recover from this backup will be backed up
  315. channel ORA_SBT_TAPE_1: starting full datafile backup set
  316. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  317. including current SPFILE in backup set
  318. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-22:23:53:45
  319. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-22:23:54:10
  320. piece handle=7rr8qo08_1_1 tag=9T_USERS_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  321. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25

  323. current log archived
  324. using channel ORA_SBT_TAPE_1
  325. using channel ORA_SBT_TAPE_2
  326. using channel ORA_SBT_TAPE_3
  327. using channel ORA_SBT_TAPE_4
  328. using channel ORA_SBT_TAPE_5
  329. using channel ORA_SBT_TAPE_6
  330. using channel ORA_SBT_TAPE_7
  331. using channel ORA_SBT_TAPE_8
  332. backup will never be obsolete
  333. archived logs required to recover from this backup will be backed up
  334. channel ORA_SBT_TAPE_1: starting archived log backup set
  335. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  336. input archived log thread=1 sequence=149 RECID=391 STAMP=915234850
  337. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-22:23:54:12
  338. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-22:23:54:37
  339. piece handle=7sr8qo14_1_1 tag=9T_USERS_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  340. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25

  342. using channel ORA_SBT_TAPE_1
  343. using channel ORA_SBT_TAPE_2
  344. using channel ORA_SBT_TAPE_3
  345. using channel ORA_SBT_TAPE_4
  346. using channel ORA_SBT_TAPE_5
  347. using channel ORA_SBT_TAPE_6
  348. using channel ORA_SBT_TAPE_7
  349. using channel ORA_SBT_TAPE_8
  350. backup will never be obsolete
  351. archived logs required to recover from this backup will be backed up
  352. channel ORA_SBT_TAPE_1: starting full datafile backup set
  353. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  354. including current control file in backup set
  355. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-22:23:54:38
  356. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-22:23:55:03
  357. piece handle=7tr8qo1t_1_1 tag=9T_USERS_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  358. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  359. Finished backup at 2016-06-22:23:55:03

  361. RMAN> list backup;


  364. List of Backup Sets
  365. ===================


  368. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  369. ------- ---- -- ---------- ----------- ------------ -------------------
  370. 661     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  371.         BP Key: 673   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  372.         Handle: 6or8lfc9_1_1   Media: station90-000019
  373.   List of Datafiles in backup set 661
  374.   File LV Type Ckp SCN    Ckp Time            Name
  375.   ---- -- ---- ---------- ------------------- ----
  376.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  378. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  379. ------- ---- -- ---------- ----------- ------------ -------------------
  380. 662     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  381.         BP Key: 674   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  382.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  383.   List of Datafiles in backup set 662
  384.   File LV Type Ckp SCN    Ckp Time            Name
  385.   ---- -- ---- ---------- ------------------- ----
  386.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  388. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  389. ------- ---- -- ---------- ----------- ------------ -------------------
  390. 663     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  391.         BP Key: 675   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  392.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  393.   List of Datafiles in backup set 663
  394.   File LV Type Ckp SCN    Ckp Time            Name
  395.   ---- -- ---- ---------- ------------------- ----
  396.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  398. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  399. ------- ---- -- ---------- ----------- ------------ -------------------
  400. 664     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  401.         BP Key: 676   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  402.         Handle: 6vr8qkce_1_1   Media: station90-000019
  403.   List of Datafiles in backup set 664
  404.   File LV Type Ckp SCN    Ckp Time            Name
  405.   ---- -- ---- ---------- ------------------- ----
  406.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  408. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  409. ------- ---- -- ---------- ----------- ------------ -------------------
  410. 665     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  411.         BP Key: 677   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  412.         Handle: 70r8qke1_1_1   Media: station90-000019
  413.   List of Datafiles in backup set 665
  414.   File LV Type Ckp SCN    Ckp Time            Name
  415.   ---- -- ---- ---------- ------------------- ----
  416.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  418. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  419. ------- ---- -- ---------- ----------- ------------ -------------------
  420. 666     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  421.         BP Key: 678   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  422.         Handle: 72r8ql8g_1_1   Media: station90-000019
  423.   List of Datafiles in backup set 666
  424.   File LV Type Ckp SCN    Ckp Time            Name
  425.   ---- -- ---- ---------- ------------------- ----
  426.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  428. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  429. ------- ---- -- ---------- ----------- ------------ -------------------
  430. 668     Incr 0  1.02M      SBT_TAPE    00:00:00     2016-06-22:23:19:51
  431.         BP Key: 679   Status: AVAILABLE  Compressed: YES  Tag: 8D_USERS_INCR0
  432.         Handle: 74r8qm0n_1_2   Media: station90-000019
  433.   List of Datafiles in backup set 668
  434.   File LV Type Ckp SCN    Ckp Time            Name
  435.   ---- -- ---- ---------- ------------------- ----
  436.   4    0  Incr 2246580    2016-06-22:23:19:51 +DATA/orcl/datafile/users.259.915231377

  438. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  439. ------- ---- -- ---------- ----------- ------------ -------------------
  440. 669     Incr 0  256.00K    SBT_TAPE    00:00:26     2016-06-22:23:25:02
  441.         BP Key: 680   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
  442.         Handle: 77r8qm9k_1_1   Media: station90-000020
  443.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  444.   SPFILE db_unique_name: ORCL

  446. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  447. ------- ---- -- ---------- ----------- ------------ -------------------
  448. 670     Incr 0  605.25M    SBT_TAPE    00:02:06     2016-06-22:23:26:42
  449.   List of Datafiles in backup set 670
  450.   File LV Type Ckp SCN    Ckp Time            Name
  451.   ---- -- ---- ---------- ------------------- ----
  452.   1    0  Incr 2246939    2016-06-22:23:24:36 +DATA/orcl/datafile/system.256.914102913

  454.   Backup Set Copy #1 of backup set 670
  455.   Device Type Elapsed Time Completion Time     Compressed Tag
  456.   ----------- ------------ ------------------- ---------- ---
  457.   SBT_TAPE    00:02:06     2016-06-22:23:26:42 NO         1T_SYSTEM_INCR0

  459.     List of Backup Pieces for backup set 670 Copy #1
  460.     BP Key  Pc# Status      Media                   Piece Name
  461.     ------- --- ----------- ----------------------- ----------
  462.     681     1   AVAILABLE   station90-000019        75r8qm9k_1_1
  463.     682     2   AVAILABLE   station90-000020        75r8qm9k_2_1
  464.     685     3   AVAILABLE   station90-000019        75r8qm9k_3_1
  465.     686     4   AVAILABLE   station90-000020        75r8qm9k_4_1
  466.     683     5   AVAILABLE   station90-000019        75r8qm9k_5_1
  467.     687     6   AVAILABLE   station90-000019        75r8qm9k_6_1
  468.     688     7   AVAILABLE   station90-000020        75r8qm9k_7_1

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

  477. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  478. ------- ---- -- ---------- ----------- ------------ -------------------
  479. 835     Incr 0  1.50M      SBT_TAPE    00:00:24     2016-06-22:23:53:43
  480.         BP Key: 838   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  481.         Handle: 7qr8qnvf_1_1   Media: station90-000019
  482.         Keep: BACKUP_LOGS        Until: FOREVER        
  483.   List of Datafiles in backup set 835
  484.   File LV Type Ckp SCN    Ckp Time            Name
  485.   ---- -- ---- ---------- ------------------- ----
  486.   4    0  Incr 2248807    2016-06-22:23:53:19 +DATA/orcl/datafile/users.259.915231377

  488. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  489. ------- ---- -- ---------- ----------- ------------ -------------------
  490. 836     Full    256.00K    SBT_TAPE    00:00:16     2016-06-22:23:54:00
  491.         BP Key: 839   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  492.         Handle: 7rr8qo08_1_1   Media: station90-000019
  493.         Keep: BACKUP_LOGS        Until: FOREVER        
  494.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  495.   SPFILE db_unique_name: ORCL

  497. BS Key  Size       Device Type Elapsed Time Completion Time   
  498. ------- ---------- ----------- ------------ -------------------
  499. 907     256.00K    SBT_TAPE    00:00:15     2016-06-22:23:54:27
  500.         BP Key: 910   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  501.         Handle: 7sr8qo14_1_1   Media: station90-000019
  502.         Keep: BACKUP_LOGS        Until: FOREVER        

  504.   List of Archived Logs in backup set 907
  505.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  506.   ---- ------- ---------- ------------------- ---------- ---------
  507.   1    149     2248741    2016-06-22:23:52:34 2248837    2016-06-22:23:54:10

  509. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  510. ------- ---- -- ---------- ----------- ------------ -------------------
  511. 908     Full    9.75M      SBT_TAPE    00:00:16     2016-06-22:23:54:53
  512.         BP Key: 911   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  513.         Handle: 7tr8qo1t_1_1   Media: station90-000019
  514.         Keep: BACKUP_LOGS        Until: FOREVER        
  515.   Control File Included: Ckp SCN: 2248924      Ckp time: 2016-06-22:23:54:37

  517. RMAN> run {
  518. 2>
  519. user interrupt received
  520. allocate channel c1 devic

  522. RMAN-00571: ===========================================================
  523. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  524. RMAN-00571: ===========================================================
  525. RMAN-00558: error encountered while parsing input commands
  526. RMAN-01009: syntax error: found "identifier": expecting one of: "device, type"
  527. RMAN-01008: the bad identifier was: devic
  528. RMAN-01007: at line 2 column 21 file: standard input

  530. RMAN>

  532. RMAN>

  534. RMAN> show all;

  536. RMAN configuration parameters for database with db_unique_name ORCL are:
  537. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  538. CONFIGURE BACKUP OPTIMIZATION ON;
  539. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  540. CONFIGURE CONTROLFILE AUTOBACKUP OFF;
  541. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  542. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  543. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO COMPRESSED BACKUPSET;
  544. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  545. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  546. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  547. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  548. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  549. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  550. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  551. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  552. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  553. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  554. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  555. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  556. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  557. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  558. CONFIGURE ENCRYPTION FOR DATABASE ON;
  559. CONFIGURE ENCRYPTION ALGORITHM 'AES256';
  560. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  561. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  562. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  564. RMAN> CONFIGURE DEFAULT DEVICE TYPE TO   disk;

  566. old RMAN configuration parameters:
  567. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  568. new RMAN configuration parameters:
  569. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  570. new RMAN configuration parameters are successfully stored
  571. RMAN-00571: ===========================================================
  572. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  573. RMAN-00571: ===========================================================
  574. RMAN-03002: failure of configure command at 06/22/2016 23:58:37
  575. ORA-01013: user requested cancel of current operation

  577. RMAN> CONFIGURE DEFAULT DEVICE TYPE TO   disk;


  580. starting full resync of recovery catalog
  581. full resync complete
  582. old RMAN configuration parameters:
  583. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  584. new RMAN configuration parameters:
  585. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  586. new RMAN configuration parameters are successfully stored
  587. released channel: ORA_SBT_TAPE_1
  588. RMAN-00571: ===========================================================
  589. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  590. RMAN-00571: ===========================================================
  591. RMAN-03002: failure of configure command at 06/22/2016 23:58:47
  592. ORA-01013: user requested cancel of current operation

  594. RMAN>
  595. RMAN>

  597. RMAN> exit


  600. Recovery Manager complete.
  601. [oracle@station90 ~]$
  602. [oracle@station90 ~]$ rman target  /  catalog u90/oracle_4U@rcat

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

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

  608. connected to target database: ORCL (DBID=1343950367)
  609. connected to recovery catalog database

  611. RMAN> CONFIGURE DEFAULT DEVICE TYPE TO   disk;

  613. old RMAN configuration parameters:
  614. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  615. new RMAN configuration parameters:
  616. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  617. new RMAN configuration parameters are successfully stored
  618. starting full resync of recovery catalog
  619. full resync complete

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

  623. Starting backup at 2016-06-22:23:59:24
  624. current log archived

  626. allocated channel: ORA_DISK_1
  627. channel ORA_DISK_1: SID=17 device type=DISK
  628. allocated channel: ORA_DISK_2
  629. channel ORA_DISK_2: SID=145 device type=DISK
  630. allocated channel: ORA_DISK_3
  631. channel ORA_DISK_3: SID=194 device type=DISK
  632. allocated channel: ORA_DISK_4
  633. channel ORA_DISK_4: SID=9 device type=DISK
  634. allocated channel: ORA_DISK_5
  635. channel ORA_DISK_5: SID=81 device type=DISK
  636. allocated channel: ORA_DISK_6
  637. channel ORA_DISK_6: SID=149 device type=DISK
  638. allocated channel: ORA_DISK_7
  639. channel ORA_DISK_7: SID=203 device type=DISK
  640. allocated channel: ORA_DISK_8
  641. channel ORA_DISK_8: SID=20 device type=DISK
  642. backup will never be obsolete
  643. archived logs required to recover from this backup will be backed up
  644. channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set
  645. channel ORA_DISK_1: specifying datafile(s) in backup set
  646. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915231377
  647. channel ORA_DISK_1: starting piece 1 at 2016-06-22:23:59:27
  648. RMAN-00571: ===========================================================
  649. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  650. RMAN-00571: ===========================================================
  651. RMAN-03002: failure of backup command at 06/22/2016 23:59:28
  652. ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes

  654. RMAN> run
  655. 2> {
  656. 3> allocate channel c1 device type disk format '/home/oracle/manual_backup/%U.bkp';
  657. 4> backup tag '10T_USERS_INCR0' incremental level 0 tablespace users keep forever;
  658. 5> }

  660. released channel: ORA_DISK_1
  661. released channel: ORA_DISK_2
  662. released channel: ORA_DISK_3
  663. released channel: ORA_DISK_4
  664. released channel: ORA_DISK_5
  665. released channel: ORA_DISK_6
  666. released channel: ORA_DISK_7
  667. released channel: ORA_DISK_8
  668. allocated channel: c1
  669. channel c1: SID=17 device type=DISK

  671. Starting backup at 2016-06-23:00:00:16
  672. current log archived

  674. backup will never be obsolete
  675. archived logs required to recover from this backup will be backed up
  676. channel c1: starting compressed incremental level 0 datafile backup set
  677. channel c1: specifying datafile(s) in backup set
  678. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915231377
  679. channel c1: starting piece 1 at 2016-06-23:00:00:18
  680. channel c1: finished piece 1 at 2016-06-23:00:00:19
  681. piece handle=/home/oracle/manual_backup/7vr8qoci_1_1.bkp tag=10T_USERS_INCR0 comment=NONE
  682. channel c1: backup set complete, elapsed time: 00:00:01

  684. backup will never be obsolete
  685. archived logs required to recover from this backup will be backed up
  686. channel c1: starting compressed full datafile backup set
  687. channel c1: specifying datafile(s) in backup set
  688. including current SPFILE in backup set
  689. channel c1: starting piece 1 at 2016-06-23:00:00:19
  690. channel c1: finished piece 1 at 2016-06-23:00:00:20
  691. piece handle=/home/oracle/manual_backup/80r8qocj_1_1.bkp tag=10T_USERS_INCR0 comment=NONE
  692. channel c1: backup set complete, elapsed time: 00:00:01

  694. current log archived
  695. backup will never be obsolete
  696. archived logs required to recover from this backup will be backed up
  697. channel c1: starting compressed archived log backup set
  698. channel c1: specifying archived log(s) in backup set
  699. input archived log thread=1 sequence=152 RECID=397 STAMP=915235223
  700. channel c1: starting piece 1 at 2016-06-23:00:00:24
  701. channel c1: finished piece 1 at 2016-06-23:00:00:25
  702. piece handle=/home/oracle/manual_backup/81r8qoco_1_1.bkp tag=10T_USERS_INCR0 comment=NONE
  703. channel c1: backup set complete, elapsed time: 00:00:01

  705. backup will never be obsolete
  706. archived logs required to recover from this backup will be backed up
  707. channel c1: starting compressed full datafile backup set
  708. channel c1: specifying datafile(s) in backup set
  709. including current control file in backup set
  710. channel c1: starting piece 1 at 2016-06-23:00:00:26
  711. channel c1: finished piece 1 at 2016-06-23:00:00:27
  712. piece handle=/home/oracle/manual_backup/82r8qocp_1_1.bkp tag=10T_USERS_INCR0 comment=NONE
  713. channel c1: backup set complete, elapsed time: 00:00:01
  714. Finished backup at 2016-06-23:00:00:27
  715. released channel: c1

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

  719. Starting backup at 2016-06-23:00:01:40
  720. current log archived

  722. allocated channel: ORA_DISK_1
  723. channel ORA_DISK_1: SID=17 device type=DISK
  724. allocated channel: ORA_DISK_2
  725. channel ORA_DISK_2: SID=145 device type=DISK
  726. allocated channel: ORA_DISK_3
  727. channel ORA_DISK_3: SID=194 device type=DISK
  728. allocated channel: ORA_DISK_4
  729. channel ORA_DISK_4: SID=9 device type=DISK
  730. allocated channel: ORA_DISK_5
  731. channel ORA_DISK_5: SID=81 device type=DISK
  732. allocated channel: ORA_DISK_6
  733. channel ORA_DISK_6: SID=149 device type=DISK
  734. allocated channel: ORA_DISK_7
  735. channel ORA_DISK_7: SID=203 device type=DISK
  736. allocated channel: ORA_DISK_8
  737. channel ORA_DISK_8: SID=20 device type=DISK
  738. backup will be obsolete on date 2017-06-23:00:01:45
  739. archived logs required to recover from this backup will be backed up
  740. channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set
  741. channel ORA_DISK_1: specifying datafile(s) in backup set
  742. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915231377
  743. channel ORA_DISK_1: starting piece 1 at 2016-06-23:00:01:45
  744. RMAN-00571: ===========================================================
  745. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  746. RMAN-00571: ===========================================================
  747. RMAN-03002: failure of backup command at 06/23/2016 00:01:46
  748. ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes

  750. RMAN> exit


  753. Recovery Manager complete.

  755. [oracle@station90 ~]$
  756. [oracle@station90 ~]$ rman target  /  

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

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

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

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

  769. using target database control file instead of recovery catalog
  770. allocated channel: c1
  771. channel c1: SID=145 device type=DISK

  773. Starting backup at 2016-06-23:00:02:41
  774. current log archived

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

  786. backup will be obsolete on date 2017-06-23:00:02:45
  787. archived logs required to recover from this backup will be backed up
  788. channel c1: starting compressed full datafile backup set
  789. channel c1: specifying datafile(s) in backup set
  790. including current SPFILE in backup set
  791. channel c1: starting piece 1 at 2016-06-23:00:02:45
  792. channel c1: finished piece 1 at 2016-06-23:00:02:46
  793. piece handle=/home/oracle/manual_backup/85r8qoh5_1_1.bkp tag=11T_USERS_INCR0 comment=NONE
  794. channel c1: backup set complete, elapsed time: 00:00:01


  797. current log archived
  798. backup will be obsolete on date 2017-06-23:00:02:50
  799. archived logs required to recover from this backup will be backed up
  800. channel c1: starting compressed archived log backup set
  801. channel c1: specifying archived log(s) in backup set
  802. input archived log thread=1 sequence=155 RECID=403 STAMP=915235369
  803. channel c1: starting piece 1 at 2016-06-23:00:02:50
  804. channel c1: finished piece 1 at 2016-06-23:00:02:51
  805. piece handle=/home/oracle/manual_backup/86r8qoha_1_1.bkp tag=11T_USERS_INCR0 comment=NONE
  806. channel c1: backup set complete, elapsed time: 00:00:01

  808. backup will be obsolete on date 2017-06-23:00:02:51
  809. archived logs required to recover from this backup will be backed up
  810. channel c1: starting compressed full datafile backup set
  811. channel c1: specifying datafile(s) in backup set
  812. including current control file in backup set
  813. channel c1: starting piece 1 at 2016-06-23:00:02:52
  814. channel c1: finished piece 1 at 2016-06-23:00:02:53
  815. piece handle=/home/oracle/manual_backup/87r8qohb_1_1.bkp tag=11T_USERS_INCR0 comment=NONE
  816. channel c1: backup set complete, elapsed time: 00:00:01
  817. Finished backup at 2016-06-23:00:02:53
  818. released channel: c1

  820. RMAN> list backup ;


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


  827. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  828. ------- ---- -- ---------- ----------- ------------ -------------------
  829. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  830.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  831.         Handle: 6or8lfc9_1_1   Media: station90-000019
  832.   List of Datafiles in backup set 197
  833.   File LV Type Ckp SCN    Ckp Time            Name
  834.   ---- -- ---- ---------- ------------------- ----
  835.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  837. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  838. ------- ---- -- ---------- ----------- ------------ -------------------
  839. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  840.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  841.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  842.   List of Datafiles in backup set 198
  843.   File LV Type Ckp SCN    Ckp Time            Name
  844.   ---- -- ---- ---------- ------------------- ----
  845.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  847. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  848. ------- ---- -- ---------- ----------- ------------ -------------------
  849. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  850.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  851.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  852.   List of Datafiles in backup set 199
  853.   File LV Type Ckp SCN    Ckp Time            Name
  854.   ---- -- ---- ---------- ------------------- ----
  855.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  857. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  858. ------- ---- -- ---------- ----------- ------------ -------------------
  859. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  860.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  861.         Handle: 6vr8qkce_1_1   Media: station90-000019
  862.   List of Datafiles in backup set 200
  863.   File LV Type Ckp SCN    Ckp Time            Name
  864.   ---- -- ---- ---------- ------------------- ----
  865.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  867. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  868. ------- ---- -- ---------- ----------- ------------ -------------------
  869. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  870.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  871.         Handle: 70r8qke1_1_1   Media: station90-000019
  872.   List of Datafiles in backup set 201
  873.   File LV Type Ckp SCN    Ckp Time            Name
  874.   ---- -- ---- ---------- ------------------- ----
  875.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  877. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  878. ------- ---- -- ---------- ----------- ------------ -------------------
  879. 203     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  880.         BP Key: 219   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  881.         Handle: 72r8ql8g_1_1   Media: station90-000019
  882.   List of Datafiles in backup set 203
  883.   File LV Type Ckp SCN    Ckp Time            Name
  884.   ---- -- ---- ---------- ------------------- ----
  885.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  887. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  888. ------- ---- -- ---------- ----------- ------------ -------------------
  889. 205     Incr 0  1.02M      SBT_TAPE    00:00:00     2016-06-22:23:19:51
  890.         BP Key: 222   Status: AVAILABLE  Compressed: YES  Tag: 8D_USERS_INCR0
  891.         Handle: 74r8qm0n_1_2   Media: station90-000019
  892.   List of Datafiles in backup set 205
  893.   File LV Type Ckp SCN    Ckp Time            Name
  894.   ---- -- ---- ---------- ------------------- ----
  895.   4    0  Incr 2246580    2016-06-22:23:19:51 +DATA/orcl/datafile/users.259.915231377

  897. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  898. ------- ---- -- ---------- ----------- ------------ -------------------
  899. 206     Incr 0  256.00K    SBT_TAPE    00:00:26     2016-06-22:23:25:02
  900.         BP Key: 223   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
  901.         Handle: 77r8qm9k_1_1   Media: station90-000020
  902.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  903.   SPFILE db_unique_name: ORCL

  905. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  906. ------- ---- -- ---------- ----------- ------------ -------------------
  907. 207     Incr 0  605.25M    SBT_TAPE    00:02:06     2016-06-22:23:26:42
  908.   List of Datafiles in backup set 207
  909.   File LV Type Ckp SCN    Ckp Time            Name
  910.   ---- -- ---- ---------- ------------------- ----
  911.   1    0  Incr 2246939    2016-06-22:23:24:36 +DATA/orcl/datafile/system.256.914102913

  913.   Backup Set Copy #1 of backup set 207
  914.   Device Type Elapsed Time Completion Time     Compressed Tag
  915.   ----------- ------------ ------------------- ---------- ---
  916.   SBT_TAPE    00:02:06     2016-06-22:23:26:42 NO         1T_SYSTEM_INCR0

  918.     List of Backup Pieces for backup set 207 Copy #1
  919.     BP Key  Pc# Status      Media                   Piece Name
  920.     ------- --- ----------- ----------------------- ----------
  921.     224     1   AVAILABLE   station90-000019        75r8qm9k_1_1
  922.     225     2   AVAILABLE   station90-000020        75r8qm9k_2_1
  923.     228     3   AVAILABLE   station90-000019        75r8qm9k_3_1
  924.     229     4   AVAILABLE   station90-000020        75r8qm9k_4_1
  925.     226     5   AVAILABLE   station90-000019        75r8qm9k_5_1
  926.     230     6   AVAILABLE   station90-000019        75r8qm9k_6_1
  927.     231     7   AVAILABLE   station90-000020        75r8qm9k_7_1

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

  936. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  937. ------- ---- -- ---------- ----------- ------------ -------------------
  938. 209     Incr 0  1.50M      SBT_TAPE    00:00:24     2016-06-22:23:53:43
  939.         BP Key: 232   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  940.         Handle: 7qr8qnvf_1_1   Media: station90-000019
  941.         Keep: BACKUP_LOGS        Until: FOREVER        
  942.   List of Datafiles in backup set 209
  943.   File LV Type Ckp SCN    Ckp Time            Name
  944.   ---- -- ---- ---------- ------------------- ----
  945.   4    0  Incr 2248807    2016-06-22:23:53:19 +DATA/orcl/datafile/users.259.915231377

  947. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  948. ------- ---- -- ---------- ----------- ------------ -------------------
  949. 210     Full    256.00K    SBT_TAPE    00:00:16     2016-06-22:23:54:00
  950.         BP Key: 233   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  951.         Handle: 7rr8qo08_1_1   Media: station90-000019
  952.         Keep: BACKUP_LOGS        Until: FOREVER        
  953.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  954.   SPFILE db_unique_name: ORCL

  956. BS Key  Size       Device Type Elapsed Time Completion Time   
  957. ------- ---------- ----------- ------------ -------------------
  958. 211     256.00K    SBT_TAPE    00:00:15     2016-06-22:23:54:27
  959.         BP Key: 234   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  960.         Handle: 7sr8qo14_1_1   Media: station90-000019
  961.         Keep: BACKUP_LOGS        Until: FOREVER        

  963.   List of Archived Logs in backup set 211
  964.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  965.   ---- ------- ---------- ------------------- ---------- ---------
  966.   1    149     2248741    2016-06-22:23:52:34 2248837    2016-06-22:23:54:10

  968. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  969. ------- ---- -- ---------- ----------- ------------ -------------------
  970. 212     Full    9.75M      SBT_TAPE    00:00:16     2016-06-22:23:54:53
  971.         BP Key: 235   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  972.         Handle: 7tr8qo1t_1_1   Media: station90-000019
  973.         Keep: BACKUP_LOGS        Until: FOREVER        
  974.   Control File Included: Ckp SCN: 2248924      Ckp time: 2016-06-22:23:54:37

  976. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  977. ------- ---- -- ---------- ----------- ------------ -------------------
  978. 213     Incr 0  1.02M      DISK        00:00:00     2016-06-23:00:00:18
  979.         BP Key: 236   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  980.         Piece Name: /home/oracle/manual_backup/7vr8qoci_1_1.bkp
  981.         Keep: BACKUP_LOGS        Until: FOREVER        
  982.   List of Datafiles in backup set 213
  983.   File LV Type Ckp SCN    Ckp Time            Name
  984.   ---- -- ---- ---------- ------------------- ----
  985.   4    0  Incr 2250315    2016-06-23:00:00:18 +DATA/orcl/datafile/users.259.915231377

  987. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  988. ------- ---- -- ---------- ----------- ------------ -------------------
  989. 214     Full    80.00K     DISK        00:00:00     2016-06-23:00:00:19
  990.         BP Key: 237   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  991.         Piece Name: /home/oracle/manual_backup/80r8qocj_1_1.bkp
  992.         Keep: BACKUP_LOGS        Until: FOREVER        
  993.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  994.   SPFILE db_unique_name: ORCL

  996. BS Key  Size       Device Type Elapsed Time Completion Time   
  997. ------- ---------- ----------- ------------ -------------------
  998. 215     9.00K      DISK        00:00:00     2016-06-23:00:00:24
  999.         BP Key: 238   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  1000.         Piece Name: /home/oracle/manual_backup/81r8qoco_1_1.bkp
  1001.         Keep: BACKUP_LOGS        Until: FOREVER        

  1003.   List of Archived Logs in backup set 215
  1004.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1005.   ---- ------- ---------- ------------------- ---------- ---------
  1006.   1    152     2250302    2016-06-23:00:00:17 2250324    2016-06-23:00:00:23

  1008. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1009. ------- ---- -- ---------- ----------- ------------ -------------------
  1010. 216     Full    1.11M      DISK        00:00:02     2016-06-23:00:00:27
  1011.         BP Key: 239   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  1012.         Piece Name: /home/oracle/manual_backup/82r8qocp_1_1.bkp
  1013.         Keep: BACKUP_LOGS        Until: FOREVER        
  1014.   Control File Included: Ckp SCN: 2250338      Ckp time: 2016-06-23:00:00:25

  1016. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1017. ------- ---- -- ---------- ----------- ------------ -------------------
  1018. 217     Incr 0  1.02M      DISK        00:00:00     2016-06-23:00:02:44
  1019.         BP Key: 240   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  1020.         Piece Name: /home/oracle/manual_backup/84r8qoh4_1_1.bkp
  1021.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:44
  1022.   List of Datafiles in backup set 217
  1023.   File LV Type Ckp SCN    Ckp Time            Name
  1024.   ---- -- ---- ---------- ------------------- ----
  1025.   4    0  Incr 2250544    2016-06-23:00:02:44 +DATA/orcl/datafile/users.259.915231377

  1027. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1028. ------- ---- -- ---------- ----------- ------------ -------------------
  1029. 218     Full    80.00K     DISK        00:00:00     2016-06-23:00:02:45
  1030.         BP Key: 241   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  1031.         Piece Name: /home/oracle/manual_backup/85r8qoh5_1_1.bkp
  1032.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:45
  1033.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  1034.   SPFILE db_unique_name: ORCL

  1036. BS Key  Size       Device Type Elapsed Time Completion Time   
  1037. ------- ---------- ----------- ------------ -------------------
  1038. 219     7.50K      DISK        00:00:00     2016-06-23:00:02:50
  1039.         BP Key: 242   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  1040.         Piece Name: /home/oracle/manual_backup/86r8qoha_1_1.bkp
  1041.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:50

  1043.   List of Archived Logs in backup set 219
  1044.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1045.   ---- ------- ---------- ------------------- ---------- ---------
  1046.   1    155     2250539    2016-06-23:00:02:43 2250564    2016-06-23:00:02:49

  1048. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1049. ------- ---- -- ---------- ----------- ------------ -------------------
  1050. 220     Full    1.11M      DISK        00:00:01     2016-06-23:00:02:52
  1051.         BP Key: 243   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  1052.         Piece Name: /home/oracle/manual_backup/87r8qohb_1_1.bkp
  1053.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:51
  1054.   Control File Included: Ckp SCN: 2250569      Ckp time: 2016-06-23:00:02:51

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

  1058. allocated channel: ORA_DISK_1
  1059. channel ORA_DISK_1: SID=145 device type=DISK
  1060. allocated channel: ORA_DISK_2
  1061. channel ORA_DISK_2: SID=149 device type=DISK
  1062. allocated channel: ORA_DISK_3
  1063. channel ORA_DISK_3: SID=20 device type=DISK
  1064. allocated channel: ORA_DISK_4
  1065. channel ORA_DISK_4: SID=194 device type=DISK
  1066. allocated channel: ORA_DISK_5
  1067. channel ORA_DISK_5: SID=9 device type=DISK
  1068. allocated channel: ORA_DISK_6
  1069. channel ORA_DISK_6: SID=86 device type=DISK
  1070. allocated channel: ORA_DISK_7
  1071. channel ORA_DISK_7: SID=150 device type=DISK
  1072. allocated channel: ORA_DISK_8
  1073. channel ORA_DISK_8: SID=198 device type=DISK
  1074. allocated channel: ORA_SBT_TAPE_1
  1075. channel ORA_SBT_TAPE_1: SID=17 device type=SBT_TAPE
  1076. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  1077. allocated channel: ORA_SBT_TAPE_2
  1078. channel ORA_SBT_TAPE_2: SID=200 device type=SBT_TAPE
  1079. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  1080. allocated channel: ORA_SBT_TAPE_3
  1081. channel ORA_SBT_TAPE_3: SID=85 device type=SBT_TAPE
  1082. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  1083. allocated channel: ORA_SBT_TAPE_4
  1084. channel ORA_SBT_TAPE_4: SID=15 device type=SBT_TAPE
  1085. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  1086. allocated channel: ORA_SBT_TAPE_5
  1087. channel ORA_SBT_TAPE_5: SID=22 device type=SBT_TAPE
  1088. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  1089. allocated channel: ORA_SBT_TAPE_6
  1090. channel ORA_SBT_TAPE_6: SID=195 device type=SBT_TAPE
  1091. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  1092. allocated channel: ORA_SBT_TAPE_7
  1093. channel ORA_SBT_TAPE_7: SID=205 device type=SBT_TAPE
  1094. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  1095. allocated channel: ORA_SBT_TAPE_8
  1096. channel ORA_SBT_TAPE_8: SID=91 device type=SBT_TAPE
  1097. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  1098. keep attributes for the backup are changed
  1099. backup will be obsolete on date 2016-08-22:00:04:40
  1100. backup set key=197 RECID=197 STAMP=915062177

  1102. RMAN> list backup ;


  1105. List of Backup Sets
  1106. ===================


  1109. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1110. ------- ---- -- ---------- ----------- ------------ -------------------
  1111. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
  1112.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
  1113.         Handle: 6or8lfc9_1_1   Media: station90-000019
  1114.         Keep: BACKUP_LOGS        Until: 2016-08-22:00:04:40
  1115.   List of Datafiles in backup set 197
  1116.   File LV Type Ckp SCN    Ckp Time            Name
  1117.   ---- -- ---- ---------- ------------------- ----
  1118.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915231377

  1120. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1121. ------- ---- -- ---------- ----------- ------------ -------------------
  1122. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
  1123.         BP Key: 214   Status: UNAVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
  1124.         Handle: 6rr8lg8a_1_1   Media: station90-000019
  1125.   List of Datafiles in backup set 198
  1126.   File LV Type Ckp SCN    Ckp Time            Name
  1127.   ---- -- ---- ---------- ------------------- ----
  1128.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915231377

  1130. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1131. ------- ---- -- ---------- ----------- ------------ -------------------
  1132. 199     Incr 0  1.25M      SBT_TAPE    00:00:25     2016-06-22:22:16:55
  1133.         BP Key: 215   Status: UNAVAILABLE  Compressed: NO  Tag: 3DET_USERS_INCR0
  1134.         Handle: 6ur8qi9u_1_1   Media: station90-000019
  1135.   List of Datafiles in backup set 199
  1136.   File LV Type Ckp SCN    Ckp Time            Name
  1137.   ---- -- ---- ---------- ------------------- ----
  1138.   4    0  Incr 2237850    2016-06-22:22:16:31 +DATA/orcl/datafile/users.259.915231377

  1140. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1141. ------- ---- -- ---------- ----------- ------------ -------------------
  1142. 200     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:22:52:22
  1143.         BP Key: 216   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1
  1144.         Handle: 6vr8qkce_1_1   Media: station90-000019
  1145.   List of Datafiles in backup set 200
  1146.   File LV Type Ckp SCN    Ckp Time            Name
  1147.   ---- -- ---- ---------- ------------------- ----
  1148.   4    1  Incr 2243125    2016-06-22:22:51:59 +DATA/orcl/datafile/users.259.915231377

  1150. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1151. ------- ---- -- ---------- ----------- ------------ -------------------
  1152. 201     Incr 1  256.00K    SBT_TAPE    00:00:22     2016-06-22:22:53:11
  1153.         BP Key: 217   Status: AVAILABLE  Compressed: NO  Tag: 5T_USERS_INCR1
  1154.         Handle: 70r8qke1_1_1   Media: station90-000019
  1155.   List of Datafiles in backup set 201
  1156.   File LV Type Ckp SCN    Ckp Time            Name
  1157.   ---- -- ---- ---------- ------------------- ----
  1158.   4    1  Incr 2243188    2016-06-22:22:52:49 +DATA/orcl/datafile/users.259.915231377

  1160. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1161. ------- ---- -- ---------- ----------- ------------ -------------------
  1162. 203     Incr 1  256.00K    SBT_TAPE    00:00:24     2016-06-22:23:07:20
  1163.         BP Key: 219   Status: AVAILABLE  Compressed: NO  Tag: 6T_USERS_INCR1
  1164.         Handle: 72r8ql8g_1_1   Media: station90-000019
  1165.   List of Datafiles in backup set 203
  1166.   File LV Type Ckp SCN    Ckp Time            Name
  1167.   ---- -- ---- ---------- ------------------- ----
  1168.   4    1  Incr 2245398    2016-06-22:23:06:56 +DATA/orcl/datafile/users.259.915231377

  1170. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1171. ------- ---- -- ---------- ----------- ------------ -------------------
  1172. 205     Incr 0  1.02M      SBT_TAPE    00:00:00     2016-06-22:23:19:51
  1173.         BP Key: 222   Status: AVAILABLE  Compressed: YES  Tag: 8D_USERS_INCR0
  1174.         Handle: 74r8qm0n_1_2   Media: station90-000019
  1175.   List of Datafiles in backup set 205
  1176.   File LV Type Ckp SCN    Ckp Time            Name
  1177.   ---- -- ---- ---------- ------------------- ----
  1178.   4    0  Incr 2246580    2016-06-22:23:19:51 +DATA/orcl/datafile/users.259.915231377

  1180. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1181. ------- ---- -- ---------- ----------- ------------ -------------------
  1182. 206     Incr 0  256.00K    SBT_TAPE    00:00:26     2016-06-22:23:25:02
  1183.         BP Key: 223   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
  1184.         Handle: 77r8qm9k_1_1   Media: station90-000020
  1185.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  1186.   SPFILE db_unique_name: ORCL

  1188. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1189. ------- ---- -- ---------- ----------- ------------ -------------------
  1190. 207     Incr 0  605.25M    SBT_TAPE    00:02:06     2016-06-22:23:26:42
  1191.   List of Datafiles in backup set 207
  1192.   File LV Type Ckp SCN    Ckp Time            Name
  1193.   ---- -- ---- ---------- ------------------- ----
  1194.   1    0  Incr 2246939    2016-06-22:23:24:36 +DATA/orcl/datafile/system.256.914102913

  1196.   Backup Set Copy #1 of backup set 207
  1197.   Device Type Elapsed Time Completion Time     Compressed Tag
  1198.   ----------- ------------ ------------------- ---------- ---
  1199.   SBT_TAPE    00:02:06     2016-06-22:23:26:42 NO         1T_SYSTEM_INCR0

  1201.     List of Backup Pieces for backup set 207 Copy #1
  1202.     BP Key  Pc# Status      Media                   Piece Name
  1203.     ------- --- ----------- ----------------------- ----------
  1204.     224     1   AVAILABLE   station90-000019        75r8qm9k_1_1
  1205.     225     2   AVAILABLE   station90-000020        75r8qm9k_2_1
  1206.     228     3   AVAILABLE   station90-000019        75r8qm9k_3_1
  1207.     229     4   AVAILABLE   station90-000020        75r8qm9k_4_1
  1208.     226     5   AVAILABLE   station90-000019        75r8qm9k_5_1
  1209.     230     6   AVAILABLE   station90-000019        75r8qm9k_6_1
  1210.     231     7   AVAILABLE   station90-000020        75r8qm9k_7_1

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

  1219. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1220. ------- ---- -- ---------- ----------- ------------ -------------------
  1221. 209     Incr 0  1.50M      SBT_TAPE    00:00:24     2016-06-22:23:53:43
  1222.         BP Key: 232   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  1223.         Handle: 7qr8qnvf_1_1   Media: station90-000019
  1224.         Keep: BACKUP_LOGS        Until: FOREVER        
  1225.   List of Datafiles in backup set 209
  1226.   File LV Type Ckp SCN    Ckp Time            Name
  1227.   ---- -- ---- ---------- ------------------- ----
  1228.   4    0  Incr 2248807    2016-06-22:23:53:19 +DATA/orcl/datafile/users.259.915231377

  1230. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1231. ------- ---- -- ---------- ----------- ------------ -------------------
  1232. 210     Full    256.00K    SBT_TAPE    00:00:16     2016-06-22:23:54:00
  1233.         BP Key: 233   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  1234.         Handle: 7rr8qo08_1_1   Media: station90-000019
  1235.         Keep: BACKUP_LOGS        Until: FOREVER        
  1236.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  1237.   SPFILE db_unique_name: ORCL

  1239. BS Key  Size       Device Type Elapsed Time Completion Time   
  1240. ------- ---------- ----------- ------------ -------------------
  1241. 211     256.00K    SBT_TAPE    00:00:15     2016-06-22:23:54:27
  1242.         BP Key: 234   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  1243.         Handle: 7sr8qo14_1_1   Media: station90-000019
  1244.         Keep: BACKUP_LOGS        Until: FOREVER        

  1246.   List of Archived Logs in backup set 211
  1247.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1248.   ---- ------- ---------- ------------------- ---------- ---------
  1249.   1    149     2248741    2016-06-22:23:52:34 2248837    2016-06-22:23:54:10

  1251. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1252. ------- ---- -- ---------- ----------- ------------ -------------------
  1253. 212     Full    9.75M      SBT_TAPE    00:00:16     2016-06-22:23:54:53
  1254.         BP Key: 235   Status: AVAILABLE  Compressed: NO  Tag: 9T_USERS_INCR0
  1255.         Handle: 7tr8qo1t_1_1   Media: station90-000019
  1256.         Keep: BACKUP_LOGS        Until: FOREVER        
  1257.   Control File Included: Ckp SCN: 2248924      Ckp time: 2016-06-22:23:54:37

  1259. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1260. ------- ---- -- ---------- ----------- ------------ -------------------
  1261. 213     Incr 0  1.02M      DISK        00:00:00     2016-06-23:00:00:18
  1262.         BP Key: 236   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  1263.         Piece Name: /home/oracle/manual_backup/7vr8qoci_1_1.bkp
  1264.         Keep: BACKUP_LOGS        Until: FOREVER        
  1265.   List of Datafiles in backup set 213
  1266.   File LV Type Ckp SCN    Ckp Time            Name
  1267.   ---- -- ---- ---------- ------------------- ----
  1268.   4    0  Incr 2250315    2016-06-23:00:00:18 +DATA/orcl/datafile/users.259.915231377

  1270. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1271. ------- ---- -- ---------- ----------- ------------ -------------------
  1272. 214     Full    80.00K     DISK        00:00:00     2016-06-23:00:00:19
  1273.         BP Key: 237   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  1274.         Piece Name: /home/oracle/manual_backup/80r8qocj_1_1.bkp
  1275.         Keep: BACKUP_LOGS        Until: FOREVER        
  1276.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  1277.   SPFILE db_unique_name: ORCL

  1279. BS Key  Size       Device Type Elapsed Time Completion Time   
  1280. ------- ---------- ----------- ------------ -------------------
  1281. 215     9.00K      DISK        00:00:00     2016-06-23:00:00:24
  1282.         BP Key: 238   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  1283.         Piece Name: /home/oracle/manual_backup/81r8qoco_1_1.bkp
  1284.         Keep: BACKUP_LOGS        Until: FOREVER        

  1286.   List of Archived Logs in backup set 215
  1287.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1288.   ---- ------- ---------- ------------------- ---------- ---------
  1289.   1    152     2250302    2016-06-23:00:00:17 2250324    2016-06-23:00:00:23

  1291. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1292. ------- ---- -- ---------- ----------- ------------ -------------------
  1293. 216     Full    1.11M      DISK        00:00:02     2016-06-23:00:00:27
  1294.         BP Key: 239   Status: AVAILABLE  Compressed: YES  Tag: 10T_USERS_INCR0
  1295.         Piece Name: /home/oracle/manual_backup/82r8qocp_1_1.bkp
  1296.         Keep: BACKUP_LOGS        Until: FOREVER        
  1297.   Control File Included: Ckp SCN: 2250338      Ckp time: 2016-06-23:00:00:25

  1299. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1300. ------- ---- -- ---------- ----------- ------------ -------------------
  1301. 217     Incr 0  1.02M      DISK        00:00:00     2016-06-23:00:02:44
  1302.         BP Key: 240   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  1303.         Piece Name: /home/oracle/manual_backup/84r8qoh4_1_1.bkp
  1304.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:44
  1305.   List of Datafiles in backup set 217
  1306.   File LV Type Ckp SCN    Ckp Time            Name
  1307.   ---- -- ---- ---------- ------------------- ----
  1308.   4    0  Incr 2250544    2016-06-23:00:02:44 +DATA/orcl/datafile/users.259.915231377

  1310. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1311. ------- ---- -- ---------- ----------- ------------ -------------------
  1312. 218     Full    80.00K     DISK        00:00:00     2016-06-23:00:02:45
  1313.         BP Key: 241   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  1314.         Piece Name: /home/oracle/manual_backup/85r8qoh5_1_1.bkp
  1315.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:45
  1316.   SPFILE Included: Modification time: 2016-06-20:21:57:28
  1317.   SPFILE db_unique_name: ORCL

  1319. BS Key  Size       Device Type Elapsed Time Completion Time   
  1320. ------- ---------- ----------- ------------ -------------------
  1321. 219     7.50K      DISK        00:00:00     2016-06-23:00:02:50
  1322.         BP Key: 242   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  1323.         Piece Name: /home/oracle/manual_backup/86r8qoha_1_1.bkp
  1324.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:50

  1326.   List of Archived Logs in backup set 219
  1327.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1328.   ---- ------- ---------- ------------------- ---------- ---------
  1329.   1    155     2250539    2016-06-23:00:02:43 2250564    2016-06-23:00:02:49

  1331. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1332. ------- ---- -- ---------- ----------- ------------ -------------------
  1333. 220     Full    1.11M      DISK        00:00:01     2016-06-23:00:02:52
  1334.         BP Key: 243   Status: AVAILABLE  Compressed: YES  Tag: 11T_USERS_INCR0
  1335.         Piece Name: /home/oracle/manual_backup/87r8qohb_1_1.bkp
  1336.         Keep: BACKUP_LOGS        Until: 2017-06-23:00:02:51
  1337.   Control File Included: Ckp SCN: 2250569      Ckp time: 2016-06-23:00:02:51

  1339. RMAN> backup recovery files;

  1341. Starting backup at 2016-06-23:00:09:32
  1342. released channel: ORA_SBT_TAPE_1
  1343. released channel: ORA_SBT_TAPE_2
  1344. released channel: ORA_SBT_TAPE_3
  1345. released channel: ORA_SBT_TAPE_4
  1346. released channel: ORA_SBT_TAPE_5
  1347. released channel: ORA_SBT_TAPE_6
  1348. released channel: ORA_SBT_TAPE_7
  1349. released channel: ORA_SBT_TAPE_8
  1350. using channel ORA_DISK_1
  1351. using channel ORA_DISK_2
  1352. using channel ORA_DISK_3
  1353. using channel ORA_DISK_4
  1354. using channel ORA_DISK_5
  1355. using channel ORA_DISK_6
  1356. using channel ORA_DISK_7
  1357. using channel ORA_DISK_8
  1358. specification does not match any datafile copy in the repository
  1359. RMAN-00571: ===========================================================
  1360. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  1361. RMAN-00571: ===========================================================
  1362. RMAN-03002: failure of backup command at 06/23/2016 00:09:43
  1363. RMAN-06603: TO DESTINATION option must be specified with RECOVERY AREA, RECOVERY FILES or DB_RECOVERY_FILE_DEST on disk device

  1365. RMAN> show all;

  1367. RMAN configuration parameters for database with db_unique_name ORCL are:
  1368. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  1369. CONFIGURE BACKUP OPTIMIZATION ON;
  1370. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  1371. CONFIGURE CONTROLFILE AUTOBACKUP OFF;
  1372. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  1373. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  1374. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO COMPRESSED BACKUPSET;
  1375. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  1376. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  1377. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  1378. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  1379. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  1380. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1381. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1382. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1383. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1384. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1385. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1386. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1387. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1388. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  1389. CONFIGURE ENCRYPTION FOR DATABASE ON;
  1390. CONFIGURE ENCRYPTION ALGORITHM 'AES256';
  1391. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  1392. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  1393. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  1395. RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;

  1397. old RMAN configuration parameters:
  1398. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  1399. new RMAN configuration parameters:
  1400. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  1401. new RMAN configuration parameters are successfully stored
  1402. released channel: ORA_DISK_1
  1403. released channel: ORA_DISK_2
  1404. released channel: ORA_DISK_3
  1405. released channel: ORA_DISK_4
  1406. released channel: ORA_DISK_5
  1407. released channel: ORA_DISK_6
  1408. released channel: ORA_DISK_7
  1409. released channel: ORA_DISK_8

  1411. RMAN> backup recovery files;

  1413. Starting backup at 2016-06-23:00:10:13
  1414. allocated channel: ORA_SBT_TAPE_1
  1415. channel ORA_SBT_TAPE_1: SID=145 device type=SBT_TAPE
  1416. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  1417. allocated channel: ORA_SBT_TAPE_2
  1418. channel ORA_SBT_TAPE_2: SID=149 device type=SBT_TAPE
  1419. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  1420. allocated channel: ORA_SBT_TAPE_3
  1421. channel ORA_SBT_TAPE_3: SID=20 device type=SBT_TAPE
  1422. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  1423. allocated channel: ORA_SBT_TAPE_4
  1424. channel ORA_SBT_TAPE_4: SID=194 device type=SBT_TAPE
  1425. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  1426. allocated channel: ORA_SBT_TAPE_5
  1427. channel ORA_SBT_TAPE_5: SID=9 device type=SBT_TAPE
  1428. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  1429. allocated channel: ORA_SBT_TAPE_6
  1430. channel ORA_SBT_TAPE_6: SID=86 device type=SBT_TAPE
  1431. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  1432. allocated channel: ORA_SBT_TAPE_7
  1433. channel ORA_SBT_TAPE_7: SID=150 device type=SBT_TAPE
  1434. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  1435. allocated channel: ORA_SBT_TAPE_8
  1436. channel ORA_SBT_TAPE_8: SID=198 device type=SBT_TAPE
  1437. channel ORA_SBT_TAPE_8: Oracle Secure Backup
  1438. specification does not match any datafile copy in the repository
  1439. channel ORA_SBT_TAPE_1: starting archived log backup set
  1440. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  1441. input archived log thread=1 sequence=112 RECID=317 STAMP=915062314
  1442. input archived log thread=1 sequence=113 RECID=319 STAMP=915062314
  1443. input archived log thread=1 sequence=114 RECID=321 STAMP=915062316
  1444. input archived log thread=1 sequence=115 RECID=323 STAMP=915062316
  1445. input archived log thread=1 sequence=116 RECID=325 STAMP=915062319
  1446. input archived log thread=1 sequence=117 RECID=327 STAMP=915062321
  1447. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-23:00:10:56
  1448. channel ORA_SBT_TAPE_2: starting archived log backup set
  1449. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
  1450. input archived log thread=1 sequence=118 RECID=329 STAMP=915104382
  1451. input archived log thread=1 sequence=119 RECID=331 STAMP=915110675
  1452. input archived log thread=1 sequence=120 RECID=333 STAMP=915119696
  1453. channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-23:00:10:56
  1454. channel ORA_SBT_TAPE_3: starting archived log backup set
  1455. channel ORA_SBT_TAPE_3: specifying archived log(s) in backup set
  1456. input archived log thread=1 sequence=121 RECID=335 STAMP=915127492
  1457. input archived log thread=1 sequence=122 RECID=337 STAMP=915141022
  1458. input archived log thread=1 sequence=123 RECID=339 STAMP=915141629
  1459. channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-23:00:10:56
  1460. channel ORA_SBT_TAPE_4: starting archived log backup set
  1461. channel ORA_SBT_TAPE_4: specifying archived log(s) in backup set
  1462. input archived log thread=1 sequence=124 RECID=341 STAMP=915141644
  1463. input archived log thread=1 sequence=125 RECID=343 STAMP=915143332
  1464. input archived log thread=1 sequence=126 RECID=345 STAMP=915148804
  1465. channel ORA_SBT_TAPE_4: starting piece 1 at 2016-06-23:00:10:56
  1466. channel ORA_SBT_TAPE_5: starting archived log backup set
  1467. channel ORA_SBT_TAPE_5: specifying archived log(s) in backup set
  1468. input archived log thread=1 sequence=127 RECID=347 STAMP=915156125
  1469. input archived log thread=1 sequence=128 RECID=349 STAMP=915193693
  1470. input archived log thread=1 sequence=129 RECID=351 STAMP=915201135
  1471. channel ORA_SBT_TAPE_5: starting piece 1 at 2016-06-23:00:10:57
  1472. channel ORA_SBT_TAPE_6: starting archived log backup set
  1473. channel ORA_SBT_TAPE_6: specifying archived log(s) in backup set
  1474. input archived log thread=1 sequence=130 RECID=353 STAMP=915208934
  1475. input archived log thread=1 sequence=131 RECID=355 STAMP=915215997
  1476. input archived log thread=1 sequence=132 RECID=357 STAMP=915228239
  1477. channel ORA_SBT_TAPE_6: starting piece 1 at 2016-06-23:00:10:57
  1478. channel ORA_SBT_TAPE_7: starting archived log backup set
  1479. channel ORA_SBT_TAPE_7: specifying archived log(s) in backup set
  1480. input archived log thread=1 sequence=133 RECID=359 STAMP=915228270
  1481. input archived log thread=1 sequence=134 RECID=361 STAMP=915229248
  1482. input archived log thread=1 sequence=135 RECID=363 STAMP=915229248
  1483. input archived log thread=1 sequence=136 RECID=365 STAMP=915229251
  1484. input archived log thread=1 sequence=137 RECID=367 STAMP=915229252
  1485. input archived log thread=1 sequence=138 RECID=369 STAMP=915229254
  1486. channel ORA_SBT_TAPE_7: starting piece 1 at 2016-06-23:00:10:57
  1487. channel ORA_SBT_TAPE_8: starting archived log backup set
  1488. channel ORA_SBT_TAPE_8: specifying archived log(s) in backup set
  1489. input archived log thread=1 sequence=139 RECID=371 STAMP=915229255
  1490. input archived log thread=1 sequence=140 RECID=373 STAMP=915230831
  1491. input archived log thread=1 sequence=141 RECID=375 STAMP=915231294
  1492. input archived log thread=1 sequence=142 RECID=377 STAMP=915231294
  1493. input archived log thread=1 sequence=143 RECID=379 STAMP=915231296
  1494. input archived log thread=1 sequence=144 RECID=381 STAMP=915231296
  1495. channel ORA_SBT_TAPE_8: starting piece 1 at 2016-06-23:00:10:57
  1496. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-23:00:11:32
  1497. piece handle=88r8qp0g_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1498. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:36
  1499. channel ORA_SBT_TAPE_1: starting archived log backup set
  1500. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  1501. input archived log thread=1 sequence=145 RECID=383 STAMP=915231299
  1502. input archived log thread=1 sequence=146 RECID=385 STAMP=915231300
  1503. input archived log thread=1 sequence=147 RECID=387 STAMP=915234531
  1504. input archived log thread=1 sequence=148 RECID=389 STAMP=915234754
  1505. input archived log thread=1 sequence=149 RECID=391 STAMP=915234850
  1506. input archived log thread=1 sequence=150 RECID=393 STAMP=915235164
  1507. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-23:00:11:32
  1508. channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-23:00:11:32
  1509. piece handle=89r8qp0g_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1510. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:36
  1511. channel ORA_SBT_TAPE_2: starting archived log backup set
  1512. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
  1513. input archived log thread=1 sequence=151 RECID=395 STAMP=915235217
  1514. input archived log thread=1 sequence=152 RECID=397 STAMP=915235223
  1515. input archived log thread=1 sequence=153 RECID=399 STAMP=915235303
  1516. input archived log thread=1 sequence=154 RECID=401 STAMP=915235364
  1517. input archived log thread=1 sequence=155 RECID=403 STAMP=915235369
  1518. channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-23:00:11:32
  1519. channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-23:00:11:57
  1520. piece handle=8ar8qp0g_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1521. channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:01:01
  1522. channel ORA_SBT_TAPE_4: finished piece 1 at 2016-06-23:00:11:58
  1523. piece handle=8br8qp0g_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1524. channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:01:02
  1525. channel ORA_SBT_TAPE_3: input backup set: count=255, stamp=915235218, piece=1
  1526. channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-23:00:11:59
  1527. channel ORA_SBT_TAPE_3: backup piece /home/oracle/manual_backup/7vr8qoci_1_1.bkp
  1528. channel ORA_SBT_TAPE_4: input backup set: count=256, stamp=915235219, piece=1
  1529. channel ORA_SBT_TAPE_4: starting piece 1 at 2016-06-23:00:11:59
  1530. channel ORA_SBT_TAPE_4: backup piece /home/oracle/manual_backup/80r8qocj_1_1.bkp
  1531. channel ORA_SBT_TAPE_7: finished piece 1 at 2016-06-23:00:12:24
  1532. piece handle=8er8qp0h_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1533. channel ORA_SBT_TAPE_7: backup set complete, elapsed time: 00:01:27
  1534. channel ORA_SBT_TAPE_7: input backup set: count=257, stamp=915235224, piece=1
  1535. channel ORA_SBT_TAPE_7: starting piece 1 at 2016-06-23:00:12:24
  1536. channel ORA_SBT_TAPE_7: backup piece /home/oracle/manual_backup/81r8qoco_1_1.bkp
  1537. channel ORA_SBT_TAPE_8: finished piece 1 at 2016-06-23:00:12:24
  1538. piece handle=8fr8qp0h_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1539. channel ORA_SBT_TAPE_8: backup set complete, elapsed time: 00:01:27
  1540. channel ORA_SBT_TAPE_8: input backup set: count=258, stamp=915235225, piece=1
  1541. channel ORA_SBT_TAPE_8: starting piece 1 at 2016-06-23:00:12:24
  1542. channel ORA_SBT_TAPE_8: backup piece /home/oracle/manual_backup/82r8qocp_1_1.bkp
  1543. channel ORA_SBT_TAPE_5: finished piece 1 at 2016-06-23:00:12:39
  1544. piece handle=8cr8qp0g_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1545. channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:01:42
  1546. channel ORA_SBT_TAPE_5: input backup set: count=260, stamp=915235364, piece=1
  1547. channel ORA_SBT_TAPE_5: starting piece 1 at 2016-06-23:00:12:39
  1548. channel ORA_SBT_TAPE_5: backup piece /home/oracle/manual_backup/84r8qoh4_1_1.bkp
  1549. channel ORA_SBT_TAPE_6: finished piece 1 at 2016-06-23:00:12:46
  1550. piece handle=8dr8qp0h_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1551. channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:01:49
  1552. channel ORA_SBT_TAPE_6: input backup set: count=261, stamp=915235365, piece=1
  1553. channel ORA_SBT_TAPE_6: starting piece 1 at 2016-06-23:00:12:46
  1554. channel ORA_SBT_TAPE_6: backup piece /home/oracle/manual_backup/85r8qoh5_1_1.bkp
  1555. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-23:00:13:01
  1556. piece handle=8gr8qp1k_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1557. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:29
  1558. channel ORA_SBT_TAPE_1: input backup set: count=262, stamp=915235370, piece=1
  1559. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-23:00:13:01
  1560. channel ORA_SBT_TAPE_1: backup piece /home/oracle/manual_backup/86r8qoha_1_1.bkp
  1561. channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-23:00:13:01
  1562. piece handle=8hr8qp1k_1_1 tag=TAG20160623T001055 comment=API Version 2.0,MMS Version 10.3.0.2
  1563. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:29
  1564. channel ORA_SBT_TAPE_2: input backup set: count=263, stamp=915235371, piece=1
  1565. channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-23:00:13:01
  1566. channel ORA_SBT_TAPE_2: backup piece /home/oracle/manual_backup/87r8qohb_1_1.bkp
  1567. piece handle=7vr8qoci_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1568. channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-23:00:13:26
  1569. channel ORA_SBT_TAPE_3: backup piece complete, elapsed time: 00:01:27
  1570. piece handle=80r8qocj_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1571. channel ORA_SBT_TAPE_4: finished piece 1 at 2016-06-23:00:13:26
  1572. channel ORA_SBT_TAPE_4: backup piece complete, elapsed time: 00:01:27
  1573. piece handle=81r8qoco_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1574. channel ORA_SBT_TAPE_7: finished piece 1 at 2016-06-23:00:13:36
  1575. channel ORA_SBT_TAPE_7: backup piece complete, elapsed time: 00:01:12
  1576. piece handle=82r8qocp_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1577. channel ORA_SBT_TAPE_8: finished piece 1 at 2016-06-23:00:13:46
  1578. channel ORA_SBT_TAPE_8: backup piece complete, elapsed time: 00:01:22
  1579. piece handle=85r8qoh5_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1580. channel ORA_SBT_TAPE_6: finished piece 1 at 2016-06-23:00:13:56
  1581. channel ORA_SBT_TAPE_6: backup piece complete, elapsed time: 00:01:10
  1582. piece handle=84r8qoh4_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1583. channel ORA_SBT_TAPE_5: finished piece 1 at 2016-06-23:00:14:06
  1584. channel ORA_SBT_TAPE_5: backup piece complete, elapsed time: 00:01:27
  1585. piece handle=86r8qoha_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1586. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-23:00:14:26
  1587. channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:01:25
  1588. piece handle=87r8qohb_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  1589. channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-23:00:14:26
  1590. channel ORA_SBT_TAPE_2: backup piece complete, elapsed time: 00:01:25
  1591. Finished backup at 2016-06-23:00:14:26

  1593. RMAN> backup recovery files;

  1595. Starting backup at 2016-06-23:00:14:32
  1596. using channel ORA_SBT_TAPE_1
  1597. using channel ORA_SBT_TAPE_2
  1598. using channel ORA_SBT_TAPE_3
  1599. using channel ORA_SBT_TAPE_4
  1600. using channel ORA_SBT_TAPE_5
  1601. using channel ORA_SBT_TAPE_6
  1602. using channel ORA_SBT_TAPE_7
  1603. using channel ORA_SBT_TAPE_8
  1604. specification does not match any datafile copy in the repository
  1605. skipping archived log file +FRA/orcl/archivelog/2016_06_20/thread_1_seq_112.334.915062313; already backed up 1 time(s)
  1606. skipping archived log file /home/oracle/archivelog/1_112_913410354.dbf; already backed up 1 time(s)
  1607. skipping archived log file +FRA/orcl/archivelog/2016_06_20/thread_1_seq_113.328.915062315; already backed up 1 time(s)
  1608. skipping archived log file /home/oracle/archivelog/1_113_913410354.dbf; already backed up 1 time(s)
  1609. skipping archived log file +FRA/orcl/archivelog/2016_06_20/thread_1_seq_114.305.915062315; already backed up 1 time(s)
  1610. skipping archived log file /home/oracle/archivelog/1_114_913410354.dbf; already backed up 1 time(s)
  1611. skipping archived log file +FRA/orcl/archivelog/2016_06_20/thread_1_seq_115.341.915062317; already backed up 1 time(s)
  1612. skipping archived log file /home/oracle/archivelog/1_115_913410354.dbf; already backed up 1 time(s)
  1613. skipping archived log file +FRA/orcl/archivelog/2016_06_20/thread_1_seq_116.308.915062319; already backed up 1 time(s)
  1614. skipping archived log file /home/oracle/archivelog/1_116_913410354.dbf; already backed up 1 time(s)
  1615. skipping archived log file +FRA/orcl/archivelog/2016_06_20/thread_1_seq_117.314.915062321; already backed up 1 time(s)
  1616. skipping archived log file /home/oracle/archivelog/1_117_913410354.dbf; already backed up 1 time(s)
  1617. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_118.311.915104383; already backed up 1 time(s)
  1618. skipping archived log file /home/oracle/archivelog/1_118_913410354.dbf; already backed up 1 time(s)
  1619. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_119.309.915110675; already backed up 1 time(s)
  1620. skipping archived log file /home/oracle/archivelog/1_119_913410354.dbf; already backed up 1 time(s)
  1621. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_120.310.915119695; already backed up 1 time(s)
  1622. skipping archived log file /home/oracle/archivelog/1_120_913410354.dbf; already backed up 1 time(s)
  1623. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_121.268.915127491; already backed up 1 time(s)
  1624. skipping archived log file /home/oracle/archivelog/1_121_913410354.dbf; already backed up 1 time(s)
  1625. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_122.316.915141023; already backed up 1 time(s)
  1626. skipping archived log file /home/oracle/archivelog/1_122_913410354.dbf; already backed up 1 time(s)
  1627. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_123.306.915141629; already backed up 1 time(s)
  1628. skipping archived log file /home/oracle/archivelog/1_123_913410354.dbf; already backed up 1 time(s)
  1629. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_124.300.915141645; already backed up 1 time(s)
  1630. skipping archived log file /home/oracle/archivelog/1_124_913410354.dbf; already backed up 1 time(s)
  1631. skipping archived log file +FRA/orcl/archivelog/2016_06_21/thread_1_seq_125.303.915143331; already backed up 1 time(s)
  1632. skipping archived log file /home/oracle/archivelog/1_125_913410354.dbf; already backed up 1 time(s)
  1633. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_126.301.915148803; already backed up 1 time(s)
  1634. skipping archived log file /home/oracle/archivelog/1_126_913410354.dbf; already backed up 1 time(s)
  1635. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_127.318.915156125; already backed up 1 time(s)
  1636. skipping archived log file /home/oracle/archivelog/1_127_913410354.dbf; already backed up 1 time(s)
  1637. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_128.331.915193693; already backed up 1 time(s)
  1638. skipping archived log file /home/oracle/archivelog/1_128_913410354.dbf; already backed up 1 time(s)
  1639. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_129.326.915201135; already backed up 1 time(s)
  1640. skipping archived log file /home/oracle/archivelog/1_129_913410354.dbf; already backed up 1 time(s)
  1641. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_130.332.915208933; already backed up 1 time(s)
  1642. skipping archived log file /home/oracle/archivelog/1_130_913410354.dbf; already backed up 1 time(s)
  1643. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_131.333.915215997; already backed up 1 time(s)
  1644. skipping archived log file /home/oracle/archivelog/1_131_913410354.dbf; already backed up 1 time(s)
  1645. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_132.313.915228239; already backed up 1 time(s)
  1646. skipping archived log file /home/oracle/archivelog/1_132_913410354.dbf; already backed up 1 time(s)
  1647. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_133.323.915228269; already backed up 1 time(s)
  1648. skipping archived log file /home/oracle/archivelog/1_133_913410354.dbf; already backed up 1 time(s)
  1649. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_134.325.915229249; already backed up 1 time(s)
  1650. skipping archived log file /home/oracle/archivelog/1_134_913410354.dbf; already backed up 1 time(s)
  1651. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_135.324.915229249; already backed up 1 time(s)
  1652. skipping archived log file /home/oracle/archivelog/1_135_913410354.dbf; already backed up 1 time(s)
  1653. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_136.327.915229251; already backed up 1 time(s)
  1654. skipping archived log file /home/oracle/archivelog/1_136_913410354.dbf; already backed up 1 time(s)
  1655. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_137.279.915229253; already backed up 1 time(s)
  1656. skipping archived log file /home/oracle/archivelog/1_137_913410354.dbf; already backed up 1 time(s)
  1657. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_138.298.915229255; already backed up 1 time(s)
  1658. skipping archived log file /home/oracle/archivelog/1_138_913410354.dbf; already backed up 1 time(s)
  1659. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_139.267.915229255; already backed up 1 time(s)
  1660. skipping archived log file /home/oracle/archivelog/1_139_913410354.dbf; already backed up 1 time(s)
  1661. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_140.287.915230831; already backed up 1 time(s)
  1662. skipping archived log file /home/oracle/archivelog/1_140_913410354.dbf; already backed up 1 time(s)
  1663. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_141.269.915231295; already backed up 1 time(s)
  1664. skipping archived log file /home/oracle/archivelog/1_141_913410354.dbf; already backed up 1 time(s)
  1665. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_142.317.915231295; already backed up 1 time(s)
  1666. skipping archived log file /home/oracle/archivelog/1_142_913410354.dbf; already backed up 1 time(s)
  1667. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_143.319.915231297; already backed up 1 time(s)
  1668. skipping archived log file /home/oracle/archivelog/1_143_913410354.dbf; already backed up 1 time(s)
  1669. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_144.320.915231297; already backed up 1 time(s)
  1670. skipping archived log file /home/oracle/archivelog/1_144_913410354.dbf; already backed up 1 time(s)
  1671. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_145.321.915231299; already backed up 1 time(s)
  1672. skipping archived log file /home/oracle/archivelog/1_145_913410354.dbf; already backed up 1 time(s)
  1673. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_146.322.915231299; already backed up 1 time(s)
  1674. skipping archived log file /home/oracle/archivelog/1_146_913410354.dbf; already backed up 1 time(s)
  1675. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_147.291.915234531; already backed up 1 time(s)
  1676. skipping archived log file /home/oracle/archivelog/1_147_913410354.dbf; already backed up 1 time(s)
  1677. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_148.295.915234755; already backed up 1 time(s)
  1678. skipping archived log file /home/oracle/archivelog/1_148_913410354.dbf; already backed up 1 time(s)
  1679. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_149.280.915234851; already backed up 1 time(s)
  1680. skipping archived log file /home/oracle/archivelog/1_149_913410354.dbf; already backed up 1 time(s)
  1681. skipping archived log file +FRA/orcl/archivelog/2016_06_22/thread_1_seq_150.290.915235165; already backed up 1 time(s)
  1682. skipping archived log file /home/oracle/archivelog/1_150_913410354.dbf; already backed up 1 time(s)
  1683. skipping archived log file +FRA/orcl/archivelog/2016_06_23/thread_1_seq_151.293.915235217; already backed up 1 time(s)
  1684. skipping archived log file /home/oracle/archivelog/1_151_913410354.dbf; already backed up 1 time(s)
  1685. skipping archived log file +FRA/orcl/archivelog/2016_06_23/thread_1_seq_152.289.915235223; already backed up 1 time(s)
  1686. skipping archived log file /home/oracle/archivelog/1_152_913410354.dbf; already backed up 1 time(s)
  1687. skipping archived log file +FRA/orcl/archivelog/2016_06_23/thread_1_seq_153.292.915235303; already backed up 1 time(s)
  1688. skipping archived log file /home/oracle/archivelog/1_153_913410354.dbf; already backed up 1 time(s)
  1689. skipping archived log file +FRA/orcl/archivelog/2016_06_23/thread_1_seq_154.288.915235363; already backed up 1 time(s)
  1690. skipping archived log file /home/oracle/archivelog/1_154_913410354.dbf; already backed up 1 time(s)
  1691. skipping archived log file +FRA/orcl/archivelog/2016_06_23/thread_1_seq_155.286.915235369; already backed up 1 time(s)
  1692. skipping archived log file /home/oracle/archivelog/1_155_913410354.dbf; already backed up 1 time(s)
  1693. channel ORA_SBT_TAPE_1: input backup set: count=255, stamp=915235218, piece=1
  1694. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-23:00:14:33
  1695. channel ORA_SBT_TAPE_1: backup piece /home/oracle/manual_backup/7vr8qoci_1_1.bkp
  1696. channel ORA_SBT_TAPE_2: input backup set: count=256, stamp=915235219, piece=1
  1697. channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-23:00:14:33
  1698. channel ORA_SBT_TAPE_2: backup piece /home/oracle/manual_backup/80r8qocj_1_1.bkp
  1699. channel ORA_SBT_TAPE_3: input backup set: count=257, stamp=915235224, piece=1
  1700. channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-23:00:14:34
  1701. channel ORA_SBT_TAPE_3: backup piece /home/oracle/manual_backup/81r8qoco_1_1.bkp
  1702. channel ORA_SBT_TAPE_4: input backup set: count=258, stamp=915235225, piece=1
  1703. channel ORA_SBT_TAPE_4: starting piece 1 at 2016-06-23:00:14:34
  1704. channel ORA_SBT_TAPE_4: backup piece /home/oracle/manual_backup/82r8qocp_1_1.bkp
  1705. channel ORA_SBT_TAPE_5: input backup set: count=260, stamp=915235364, piece=1
  1706. channel ORA_SBT_TAPE_5: starting piece 1 at 2016-06-23:00:14:34
  1707. channel ORA_SBT_TAPE_5: backup piece /home/oracle/manual_backup/84r8qoh4_1_1.bkp
  1708. channel ORA_SBT_TAPE_6: input backup set: count=261, stamp=915235365, piece=1
  1709. channel ORA_SBT_TAPE_6: starting piece 1 at 2016-06-23:00:14:34
  1710. channel ORA_SBT_TAPE_6: backup piece /home/oracle/manual_backup/85r8qoh5_1_1.bkp
  1711. channel ORA_SBT_TAPE_7: input backup set: count=262, stamp=915235370, piece=1
  1712. channel ORA_SBT_TAPE_7: starting piece 1 at 2016-06-23:00:14:34
  1713. channel ORA_SBT_TAPE_7: backup piece /home/oracle/manual_backup/86r8qoha_1_1.bkp
  1714. channel ORA_SBT_TAPE_8: input backup set: count=263, stamp=915235371, piece=1
  1715. channel ORA_SBT_TAPE_8: starting piece 1 at 2016-06-23:00:14:34
  1716. channel ORA_SBT_TAPE_8: backup piece /home/oracle/manual_backup/87r8qohb_1_1.bkp
  1717. piece handle=82r8qocp_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1718. channel ORA_SBT_TAPE_4: finished piece 1 at 2016-06-23:00:14:56
  1719. channel ORA_SBT_TAPE_4: backup piece complete, elapsed time: 00:00:22
  1720. piece handle=85r8qoh5_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1721. channel ORA_SBT_TAPE_6: finished piece 1 at 2016-06-23:00:14:56
  1722. channel ORA_SBT_TAPE_6: backup piece complete, elapsed time: 00:00:22
  1723. piece handle=87r8qohb_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1724. channel ORA_SBT_TAPE_8: finished piece 1 at 2016-06-23:00:15:06
  1725. channel ORA_SBT_TAPE_8: backup piece complete, elapsed time: 00:00:32
  1726. piece handle=7vr8qoci_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1727. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-23:00:15:16
  1728. channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:00:43
  1729. piece handle=86r8qoha_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1730. channel ORA_SBT_TAPE_7: finished piece 1 at 2016-06-23:00:15:26
  1731. channel ORA_SBT_TAPE_7: backup piece complete, elapsed time: 00:00:52
  1732. piece handle=81r8qoco_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1733. channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-23:00:15:36
  1734. channel ORA_SBT_TAPE_3: backup piece complete, elapsed time: 00:01:03
  1735. piece handle=84r8qoh4_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1736. channel ORA_SBT_TAPE_5: finished piece 1 at 2016-06-23:00:15:46
  1737. channel ORA_SBT_TAPE_5: backup piece complete, elapsed time: 00:01:12
  1738. piece handle=80r8qocj_1_3 comment=API Version 2.0,MMS Version 10.3.0.2
  1739. channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-23:00:15:56
  1740. channel ORA_SBT_TAPE_2: backup piece complete, elapsed time: 00:01:23
  1741. Finished backup at 2016-06-23:00:15:56

  1743. RMAN>
复制代码

复制代码


回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-11-1 09:04 , Processed in 0.057739 second(s), 24 queries .

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