开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › SECOUG活动（活动结束图标变灰，但是欢迎继续发帖！） › SECOUG第一期长期技术沙龙 › 第9次活动：2017-08-20（星期日晚上7:00-10:00）
返回列表 发新帖
查看: 2071|回复: 0

第9次活动：2017-08-20（星期日晚上7:00-10:00）

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-8-20 19:44:57 | 显示全部楼层 |阅读模式
  1. RMAN>  run {
  2. 2> allocate channel c2 device type disk format '/home/oracle/dir1/%U','/home/oracle/dir2/%U';
  3. 3> backup tag 'COPIES6' copies 2     tablespace users;
  4. 4> }

  6. allocated channel: c2
  7. channel c2: SID=76 device type=DISK

  9. Starting backup at 2017-08-20:19:44:01
  10. channel c2: starting full datafile backup set
  11. channel c2: specifying datafile(s) in backup set
  12. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  13. channel c2: starting piece 1 at 2017-08-20:19:44:01
  14. channel c2: finished piece 1 at 2017-08-20:19:44:02 with 2 copies and tag COPIES6
  15. piece handle=/home/oracle/dir1/1iscdbc1_1_1 comment=NONE
  16. piece handle=/home/oracle/dir2/1iscdbc1_1_2 comment=NONE
  17. channel c2: backup set complete, elapsed time: 00:00:01
  18. Finished backup at 2017-08-20:19:44:02

  20. Starting Control File and SPFILE Autobackup at 2017-08-20:19:44:03
  21. piece handle=+FRA/orcl/autobackup/2017_08_20/s_952544643.279.952544643 comment=NONE
  22. Finished Control File and SPFILE Autobackup at 2017-08-20:19:44:04
  23. released channel: c2
复制代码
  1. RMAN> run {
  2. 2> allocate channel c1 device type sbt maxpiecesize 50M ;
  3. 3> backup tag 'MUTI1' tablespace sysaux;
  4. 4> }

  6. allocated channel: c1
  7. channel c1: SID=76 device type=SBT_TAPE
  8. channel c1: Oracle Secure Backup

  10. Starting backup at 2017-08-20:19:52:15
  11. channel c1: starting full datafile backup set
  12. channel c1: specifying datafile(s) in backup set
  13. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  14. channel c1: starting piece 1 at 2017-08-20:19:52:15
  15. channel c1: finished piece 1 at 2017-08-20:19:52:40
  16. piece handle=1kscdbrf_1_1 tag=MUTI1 comment=API Version 2.0,MMS Version 10.4.0.4
  17. channel c1: starting piece 2 at 2017-08-20:19:52:40
  18. channel c1: finished piece 2 at 2017-08-20:19:52:55
  19. piece handle=1kscdbrf_2_1 tag=MUTI1 comment=API Version 2.0,MMS Version 10.4.0.4
  20. channel c1: starting piece 3 at 2017-08-20:19:52:55
  21. channel c1: finished piece 3 at 2017-08-20:19:53:10
  22. piece handle=1kscdbrf_3_1 tag=MUTI1 comment=API Version 2.0,MMS Version 10.4.0.4
  23. channel c1: starting piece 4 at 2017-08-20:19:53:10
  24. channel c1: finished piece 4 at 2017-08-20:19:53:35
  25. piece handle=1kscdbrf_4_1 tag=MUTI1 comment=API Version 2.0,MMS Version 10.4.0.4
  26. channel c1: starting piece 5 at 2017-08-20:19:53:35
  27. channel c1: finished piece 5 at 2017-08-20:19:53:50
  28. piece handle=1kscdbrf_5_1 tag=MUTI1 comment=API Version 2.0,MMS Version 10.4.0.4
  29. channel c1: starting piece 6 at 2017-08-20:19:53:50
  30. channel c1: finished piece 6 at 2017-08-20:19:54:05
  31. piece handle=1kscdbrf_6_1 tag=MUTI1 comment=API Version 2.0,MMS Version 10.4.0.4
  32. channel c1: starting piece 7 at 2017-08-20:19:54:05
  33. channel c1: finished piece 7 at 2017-08-20:19:54:30
  34. piece handle=1kscdbrf_7_1 tag=MUTI1 comment=API Version 2.0,MMS Version 10.4.0.4
  35. channel c1: starting piece 8 at 2017-08-20:19:54:30
  36. channel c1: finished piece 8 at 2017-08-20:19:54:55
  37. piece handle=1kscdbrf_8_1 tag=MUTI1 comment=API Version 2.0,MMS Version 10.4.0.4
  38. channel c1: starting piece 9 at 2017-08-20:19:54:55
  39. channel c1: finished piece 9 at 2017-08-20:19:55:10
  40. piece handle=1kscdbrf_9_1 tag=MUTI1 comment=API Version 2.0,MMS Version 10.4.0.4
  41. channel c1: backup set complete, elapsed time: 00:02:55
  42. Finished backup at 2017-08-20:19:55:10

  44. Starting Control File and SPFILE Autobackup at 2017-08-20:19:55:10
  45. piece handle=c-1343950367-20170820-06 comment=API Version 2.0,MMS Version 10.4.0.4
  46. Finished Control File and SPFILE Autobackup at 2017-08-20:19:55:35
  47. released channel: c1
复制代码
Screenshot.png


  1. RMAN> set encryption on identified by "microsoft123" only;

  3. executing command: SET encryption

  5. RMAN> backup tag 'PASSWD' tablespace example;

  7. Starting backup at 2017-08-20:21:47:28
  8. using channel ORA_SBT_TAPE_1
  9. using channel ORA_SBT_TAPE_2
  10. channel ORA_SBT_TAPE_1: starting full datafile backup set
  11. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  12. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  13. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-20:21:47:28
  14. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-20:21:47:53
  15. piece handle=24scdijg_1_1 tag=PASSWD comment=API Version 2.0,MMS Version 10.4.0.4
  16. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  17. Finished backup at 2017-08-20:21:47:53

  19. Starting Control File and SPFILE Autobackup at 2017-08-20:21:47:53
  20. piece handle=c-1343950367-20170820-0c comment=API Version 2.0,MMS Version 10.4.0.4
  21. Finished Control File and SPFILE Autobackup at 2017-08-20:21:48:18

  23. RMAN> list backup of tablespace example;


  26. List of Backup Sets
  27. ===================


  30. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  31. ------- ---- -- ---------- ----------- ------------ -------------------
  32. 35      Incr 0  657.75M    SBT_TAPE    00:00:27     2017-05-18:16:43:26
  33.         BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: 0T_INCR0_WHOLE
  34.         Handle: 12s4ih4j_1_1   Media: station90-000001
  35.   List of Datafiles in backup set 35
  36.   File LV Type Ckp SCN    Ckp Time            Name
  37.   ---- -- ---- ---------- ------------------- ----
  38.   5    0  Incr 1057421    2017-05-18:16:42:59 +DATA/orcl/datafile/example.265.816169651

  40. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  41. ------- ---- -- ---------- ----------- ------------ -------------------
  42. 55      Full    87.75M     SBT_TAPE    00:00:17     2017-08-20:20:00:28
  43.         BP Key: 69   Status: AVAILABLE  Compressed: NO  Tag: EXCLUDE1
  44.         Handle: 1pscdcab_1_1   Media: station90-000001
  45.   List of Datafiles in backup set 55
  46.   File LV Type Ckp SCN    Ckp Time            Name
  47.   ---- -- ---- ---------- ------------------- ----
  48.   5       Full 1132719    2017-08-20:20:00:12 +DATA/orcl/datafile/example.265.816169651

  50. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  51. ------- ---- -- ---------- ----------- ------------ -------------------
  52. 66      Full    69.63M     SBT_TAPE    00:00:16     2017-08-20:21:47:44
  53.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: PASSWD
  54.         Handle: 24scdijg_1_1   Media: station90-000001
  55.   List of Datafiles in backup set 66
  56.   File LV Type Ckp SCN    Ckp Time            Name
  57.   ---- -- ---- ---------- ------------------- ----
  58.   5       Full 1140564    2017-08-20:21:47:28 +DATA/orcl/datafile/example.265.816169651

  60. RMAN> restore tablespace example from tag 'PASSWD';

  62. Starting restore at 2017-08-20:21:49:10
  63. allocated channel: ORA_DISK_1
  64. channel ORA_DISK_1: SID=203 device type=DISK
  65. allocated channel: ORA_DISK_2
  66. channel ORA_DISK_2: SID=79 device type=DISK
  67. allocated channel: ORA_DISK_3
  68. channel ORA_DISK_3: SID=143 device type=DISK
  69. allocated channel: ORA_DISK_4
  70. channel ORA_DISK_4: SID=204 device type=DISK
  71. allocated channel: ORA_DISK_5
  72. channel ORA_DISK_5: SID=18 device type=DISK
  73. allocated channel: ORA_DISK_6
  74. channel ORA_DISK_6: SID=80 device type=DISK
  75. allocated channel: ORA_DISK_7
  76. channel ORA_DISK_7: SID=144 device type=DISK
  77. allocated channel: ORA_DISK_8
  78. channel ORA_DISK_8: SID=205 device type=DISK
  79. using channel ORA_SBT_TAPE_1
  80. using channel ORA_SBT_TAPE_2

  82. channel ORA_SBT_TAPE_1: starting datafile backup set restore
  83. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  84. channel ORA_SBT_TAPE_1: restoring datafile 00005 to +DATA/orcl/datafile/example.265.816169651
  85. channel ORA_SBT_TAPE_1: reading from backup piece 24scdijg_1_1
  86. RMAN-00571: ===========================================================
  87. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  88. RMAN-00571: ===========================================================
  89. RMAN-03002: failure of restore command at 08/20/2017 21:49:36
  90. ORA-19870: error while restoring backup piece 24scdijg_1_1
  91. ORA-19913: unable to decrypt backup
  92. ORA-28365: wallet is not open

  94. RMAN> set decrypt identified by "java123456","a123456","bwqhqwkeq";

  96. RMAN-00571: ===========================================================
  97. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  98. RMAN-00571: ===========================================================
  99. RMAN-00558: error encountered while parsing input commands
  100. RMAN-01009: syntax error: found "identifier": expecting one of: "archivelog, autobackup, auxiliary, auxname, backup, command, compression, controlfile, database, dbid, decryption, echo, encryption, high, incarnation, maxcorrupt, maxseq, newname, nocfau, restore, snapshot, to restore point, until restore point, until"
  101. RMAN-01008: the bad identifier was: decrypt
  102. RMAN-01007: at line 1 column 5 file: standard input

  104. RMAN> set decryption identified by "java123456","a123456","bwqhqwkeq";

  106. executing command: SET decryption

  108. RMAN> restore tablespace example from tag 'PASSWD';

  110. Starting restore at 2017-08-20:21:50:46
  111. using channel ORA_DISK_1
  112. using channel ORA_DISK_2
  113. using channel ORA_DISK_3
  114. using channel ORA_DISK_4
  115. using channel ORA_DISK_5
  116. using channel ORA_DISK_6
  117. using channel ORA_DISK_7
  118. using channel ORA_DISK_8
  119. using channel ORA_SBT_TAPE_1
  120. using channel ORA_SBT_TAPE_2

  122. channel ORA_SBT_TAPE_1: starting datafile backup set restore
  123. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  124. channel ORA_SBT_TAPE_1: restoring datafile 00005 to +DATA/orcl/datafile/example.265.816169651
  125. channel ORA_SBT_TAPE_1: reading from backup piece 24scdijg_1_1
  126. RMAN-00571: ===========================================================
  127. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  128. RMAN-00571: ===========================================================
  129. RMAN-03002: failure of restore command at 08/20/2017 21:51:12
  130. ORA-19870: error while restoring backup piece 24scdijg_1_1
  131. ORA-19913: unable to decrypt backup
  132. ORA-28365: wallet is not open

  134. RMAN> set decryption identified by "java123456","a123456","bwqhqwkeq","microsoft123";

  136. executing command: SET decryption

  138. RMAN> restore tablespace example from tag 'PASSWD';

  140. Starting restore at 2017-08-20:21:51:49
  141. using channel ORA_DISK_1
  142. using channel ORA_DISK_2
  143. using channel ORA_DISK_3
  144. using channel ORA_DISK_4
  145. using channel ORA_DISK_5
  146. using channel ORA_DISK_6
  147. using channel ORA_DISK_7
  148. using channel ORA_DISK_8
  149. using channel ORA_SBT_TAPE_1
  150. using channel ORA_SBT_TAPE_2

  152. channel ORA_SBT_TAPE_1: starting datafile backup set restore
  153. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  154. channel ORA_SBT_TAPE_1: restoring datafile 00005 to +DATA/orcl/datafile/example.265.816169651
  155. channel ORA_SBT_TAPE_1: reading from backup piece 24scdijg_1_1
  156. channel ORA_SBT_TAPE_1: piece handle=24scdijg_1_1 tag=PASSWD
  157. channel ORA_SBT_TAPE_1: restored backup piece 1
  158. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
  159. Finished restore at 2017-08-20:21:52:15
复制代码


回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-4-29 14:24 , Processed in 0.039202 second(s), 27 queries .

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