开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 4082-11g管理类OCP认证班第七期（WDP提速） › 课程第28次
返回列表 发新帖
查看: 1069|回复: 0

课程第28次

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2019-7-20 09:10:56 | 显示全部楼层 |阅读模式
2019-07-20
并行度是由输入文件的个数决定的，
         是由通道来执行完成，而通道是由设备来提供的。


磁带机：

  1. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
复制代码
磁盘：
  1. RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM  8  BACKUP TYPE TO BACKUPSET;
复制代码
对于磁带机，为了确定卷标通常会去“实例化”并行度的通道：

  1. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station76)';
  2. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station76)';
复制代码
                                                                                                                                                                                                              
https://192.168.0.76:1158/em/console/database/rec/config?event=start&target=orcl.example.com&type=oracle_database

下面研究一下"maxpiecesize":

改配置之前的show all:

  1. <p>RMAN> show all;</p><p>RMAN configuration parameters for database with db_unique_name ORCL are:
  2. CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
  3. CONFIGURE BACKUP OPTIMIZATION OFF; # default
  4. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  5. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
  6. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  7. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  8. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  9. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  10. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  11. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  12. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  13. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  14. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station76)';
  15. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station76)';
  16. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  17. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  18. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  19. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  20. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  21. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

复制代码
改配置之后：
请注意：CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 250 M;

  1. RMAN> show all;

  3. starting full resync of recovery catalog
  4. full resync complete
  5. RMAN configuration parameters for database with db_unique_name ORCL are:
  6. CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
  7. CONFIGURE BACKUP OPTIMIZATION OFF; # default
  8. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  9. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
  10. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  11. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  12. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  13. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  14. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  15. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  16. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  17. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  18. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station76)';
  19. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station76)';
  20. CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 250 M;
  21. CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station76)' MAXPIECESIZE 250 M;
  22. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  23. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  24. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  25. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  26. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  27. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
复制代码
  1. RMAN>  backup tag '2T-WHOLE-INCR0'  incremental level 0 database plus archivelog delete all input ;


  4. Starting backup at 20-JUL-19
  5. current log archived
  6. allocated channel: ORA_SBT_TAPE_1
  7. channel ORA_SBT_TAPE_1: SID=73 device type=SBT_TAPE
  8. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  9. allocated channel: ORA_SBT_TAPE_2
  10. channel ORA_SBT_TAPE_2: SID=78 device type=SBT_TAPE
  11. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  12. channel ORA_SBT_TAPE_1: starting archived log backup set
  13. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  14. input archived log thread=1 sequence=6 RECID=1 STAMP=1013962566
  15. input archived log thread=1 sequence=7 RECID=2 STAMP=1013962567
  16. input archived log thread=1 sequence=8 RECID=3 STAMP=1013962569
  17. input archived log thread=1 sequence=9 RECID=4 STAMP=1013962572
  18. input archived log thread=1 sequence=10 RECID=5 STAMP=1013962572
  19. input archived log thread=1 sequence=11 RECID=6 STAMP=1013962574
  20. input archived log thread=1 sequence=12 RECID=7 STAMP=1013962576
  21. input archived log thread=1 sequence=13 RECID=8 STAMP=1013962580
  22. input archived log thread=1 sequence=14 RECID=9 STAMP=1013962581
  23. input archived log thread=1 sequence=15 RECID=10 STAMP=1013963203
  24. input archived log thread=1 sequence=16 RECID=11 STAMP=1013963204
  25. input archived log thread=1 sequence=17 RECID=12 STAMP=1013963208
  26. input archived log thread=1 sequence=18 RECID=13 STAMP=1013963210
  27. input archived log thread=1 sequence=19 RECID=14 STAMP=1013963211
  28. input archived log thread=1 sequence=20 RECID=15 STAMP=1013963213
  29. input archived log thread=1 sequence=21 RECID=16 STAMP=1013963213
  30. input archived log thread=1 sequence=22 RECID=17 STAMP=1013963214
  31. input archived log thread=1 sequence=23 RECID=18 STAMP=1013963215
  32. input archived log thread=1 sequence=24 RECID=19 STAMP=1013963216
  33. input archived log thread=1 sequence=25 RECID=20 STAMP=1013963217
  34. channel ORA_SBT_TAPE_1: starting piece 1 at 20-JUL-19
  35. channel ORA_SBT_TAPE_2: starting archived log backup set
  36. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
  37. input archived log thread=1 sequence=26 RECID=21 STAMP=1013963217
  38. input archived log thread=1 sequence=27 RECID=22 STAMP=1013963218
  39. input archived log thread=1 sequence=28 RECID=23 STAMP=1013963219
  40. input archived log thread=1 sequence=29 RECID=24 STAMP=1013963219
  41. input archived log thread=1 sequence=30 RECID=25 STAMP=1013963220
  42. input archived log thread=1 sequence=31 RECID=26 STAMP=1013963220
  43. input archived log thread=1 sequence=32 RECID=27 STAMP=1013963221
  44. input archived log thread=1 sequence=33 RECID=28 STAMP=1013963222
  45. input archived log thread=1 sequence=34 RECID=29 STAMP=1013963222
  46. input archived log thread=1 sequence=35 RECID=30 STAMP=1013966650
  47. input archived log thread=1 sequence=36 RECID=32 STAMP=1013970799
  48. input archived log thread=1 sequence=37 RECID=31 STAMP=1013970799
  49. input archived log thread=1 sequence=38 RECID=33 STAMP=1013970808
  50. input archived log thread=1 sequence=39 RECID=34 STAMP=1013970808
  51. input archived log thread=1 sequence=40 RECID=35 STAMP=1013970811
  52. input archived log thread=1 sequence=41 RECID=36 STAMP=1013970811
  53. input archived log thread=1 sequence=42 RECID=37 STAMP=1014072930
  54. input archived log thread=1 sequence=43 RECID=38 STAMP=1014073619
  55. input archived log thread=1 sequence=44 RECID=39 STAMP=1014073954
  56. channel ORA_SBT_TAPE_2: starting piece 1 at 20-JUL-19
  57. channel ORA_SBT_TAPE_1: finished piece 1 at 20-JUL-19
  58. piece handle=0fu735s6_1_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  59. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  60. channel ORA_SBT_TAPE_1: deleting archived log(s)
  61. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_6.262.1013962565 RECID=1 STAMP=1013962566
  62. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_7.263.1013962567 RECID=2 STAMP=1013962567
  63. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_8.264.1013962569 RECID=3 STAMP=1013962569
  64. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_9.265.1013962571 RECID=4 STAMP=1013962572
  65. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_10.266.1013962573 RECID=5 STAMP=1013962572
  66. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_11.267.1013962573 RECID=6 STAMP=1013962574
  67. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_12.268.1013962577 RECID=7 STAMP=1013962576
  68. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_13.269.1013962579 RECID=8 STAMP=1013962580
  69. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_14.270.1013962581 RECID=9 STAMP=1013962581
  70. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_15.271.1013963203 RECID=10 STAMP=1013963203
  71. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_16.272.1013963205 RECID=11 STAMP=1013963204
  72. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_17.273.1013963209 RECID=12 STAMP=1013963208
  73. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_18.274.1013963211 RECID=13 STAMP=1013963210
  74. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_19.275.1013963211 RECID=14 STAMP=1013963211
  75. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_20.276.1013963213 RECID=15 STAMP=1013963213
  76. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_21.277.1013963213 RECID=16 STAMP=1013963213
  77. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_22.278.1013963215 RECID=17 STAMP=1013963214
  78. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_23.279.1013963215 RECID=18 STAMP=1013963215
  79. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_24.280.1013963217 RECID=19 STAMP=1013963216
  80. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_25.281.1013963217 RECID=20 STAMP=1013963217
  81. channel ORA_SBT_TAPE_1: starting archived log backup set
  82. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  83. input archived log thread=1 sequence=45 RECID=40 STAMP=1014077306
  84. channel ORA_SBT_TAPE_1: starting piece 1 at 20-JUL-19
  85. channel ORA_SBT_TAPE_2: finished piece 1 at 20-JUL-19
  86. piece handle=0gu735s7_1_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  87. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:32
  88. channel ORA_SBT_TAPE_2: deleting archived log(s)
  89. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_26.282.1013963217 RECID=21 STAMP=1013963217
  90. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_27.283.1013963219 RECID=22 STAMP=1013963218
  91. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_28.284.1013963219 RECID=23 STAMP=1013963219
  92. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_29.285.1013963219 RECID=24 STAMP=1013963219
  93. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_30.286.1013963219 RECID=25 STAMP=1013963220
  94. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_31.287.1013963221 RECID=26 STAMP=1013963220
  95. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_32.288.1013963221 RECID=27 STAMP=1013963221
  96. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_33.289.1013963223 RECID=28 STAMP=1013963222
  97. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_34.290.1013963223 RECID=29 STAMP=1013963222
  98. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_35.291.1013966651 RECID=30 STAMP=1013966650
  99. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_36.292.1013970799 RECID=32 STAMP=1013970799
  100. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_37.293.1013970799 RECID=31 STAMP=1013970799
  101. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_38.294.1013970809 RECID=33 STAMP=1013970808
  102. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_39.295.1013970809 RECID=34 STAMP=1013970808
  103. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_40.296.1013970811 RECID=35 STAMP=1013970811
  104. archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_41.297.1013970811 RECID=36 STAMP=1013970811
  105. archived log file name=+FRA/orcl/archivelog/2019_07_19/thread_1_seq_42.298.1014072929 RECID=37 STAMP=1014072930
  106. archived log file name=+FRA/orcl/archivelog/2019_07_19/thread_1_seq_43.300.1014073619 RECID=38 STAMP=1014073619
  107. archived log file name=+FRA/orcl/archivelog/2019_07_19/thread_1_seq_44.301.1014073951 RECID=39 STAMP=1014073954
  108. channel ORA_SBT_TAPE_1: finished piece 1 at 20-JUL-19
  109. piece handle=0hu735t7_1_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  110. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:18
  111. channel ORA_SBT_TAPE_1: deleting archived log(s)
  112. archived log file name=+FRA/orcl/archivelog/2019_07_20/thread_1_seq_45.303.1014077305 RECID=40 STAMP=1014077306
  113. Finished backup at 20-JUL-19

  115. Starting backup at 20-JUL-19
  116. using channel ORA_SBT_TAPE_1
  117. using channel ORA_SBT_TAPE_2
  118. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  119. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  120. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1013960881
  121. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.1013960987
  122. channel ORA_SBT_TAPE_1: starting piece 1 at 20-JUL-19
  123. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  124. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  125. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.1013960883
  126. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.1013960883
  127. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1013960885
  128. channel ORA_SBT_TAPE_2: starting piece 1 at 20-JUL-19
  129. channel ORA_SBT_TAPE_2: finished piece 1 at 20-JUL-19
  130. piece handle=0ju735ts_1_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  131. channel ORA_SBT_TAPE_2: starting piece 2 at 20-JUL-19
  132. channel ORA_SBT_TAPE_1: finished piece 1 at 20-JUL-19
  133. piece handle=0iu735ts_1_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  134. channel ORA_SBT_TAPE_1: starting piece 2 at 20-JUL-19
  135. channel ORA_SBT_TAPE_2: finished piece 2 at 20-JUL-19
  136. piece handle=0ju735ts_2_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  137. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:47
  138. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  139. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  140. including current control file in backup set
  141. channel ORA_SBT_TAPE_2: starting piece 1 at 20-JUL-19
  142. channel ORA_SBT_TAPE_1: finished piece 2 at 20-JUL-19
  143. piece handle=0iu735ts_2_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  144. channel ORA_SBT_TAPE_1: starting piece 3 at 20-JUL-19
  145. channel ORA_SBT_TAPE_2: finished piece 1 at 20-JUL-19
  146. piece handle=0ku735vd_1_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  147. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  148. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  149. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  150. including current SPFILE in backup set
  151. channel ORA_SBT_TAPE_2: starting piece 1 at 20-JUL-19
  152. channel ORA_SBT_TAPE_2: finished piece 1 at 20-JUL-19
  153. piece handle=0lu73607_1_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  154. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  155. channel ORA_SBT_TAPE_1: finished piece 3 at 20-JUL-19
  156. piece handle=0iu735ts_3_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  157. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:50
  158. Finished backup at 20-JUL-19

  160. Starting backup at 20-JUL-19
  161. current log archived
  162. using channel ORA_SBT_TAPE_1
  163. using channel ORA_SBT_TAPE_2
  164. channel ORA_SBT_TAPE_1: starting archived log backup set
  165. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  166. input archived log thread=1 sequence=46 RECID=41 STAMP=1014077483
  167. channel ORA_SBT_TAPE_1: starting piece 1 at 20-JUL-19
  168. channel ORA_SBT_TAPE_1: finished piece 1 at 20-JUL-19
  169. piece handle=0mu7361d_1_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  170. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:15
  171. channel ORA_SBT_TAPE_1: deleting archived log(s)
  172. archived log file name=+FRA/orcl/archivelog/2019_07_20/thread_1_seq_46.303.1014077483 RECID=41 STAMP=1014077483
  173. Finished backup at 20-JUL-19

  175. RMAN> list backup of tablespace system;


  178. List of Backup Sets
  179. ===================


  182. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  183. ------- ---- -- ---------- ----------- ------------ ---------------
  184. 157     Full    647.25M    SBT_TAPE    00:03:16     18-JUL-19
  185.         BP Key: 169   Status: AVAILABLE  Compressed: NO  Tag: TAG20190718T173340
  186.         Handle: 04u6vqbl_1_1   Media: station76-000001
  187.   List of Datafiles in backup set 157
  188.   File LV Type Ckp SCN    Ckp Time  Name
  189.   ---- -- ---- ---------- --------- ----
  190.   1       Full 1034213    18-JUL-19 +DATA/orcl/datafile/system.256.1013960881

  192. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  193. ------- ---- -- ---------- ----------- ------------ ---------------
  194. 161     Full    648.75M    SBT_TAPE    00:04:00     18-JUL-19
  195.         BP Key: 173   Status: AVAILABLE  Compressed: NO  Tag: TAG20190718T182614
  196.         Handle: 08u6vte7_1_1   Media: station76-000001,station76-000003
  197.   List of Datafiles in backup set 161
  198.   File LV Type Ckp SCN    Ckp Time  Name
  199.   ---- -- ---- ---------- --------- ----
  200.   1       Full 1037207    18-JUL-19 +DATA/orcl/datafile/system.256.1013960881

  202. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  203. ------- ---- -- ---------- ----------- ------------ ---------------
  204. 165     Full    649.00M    SBT_TAPE    00:00:28     18-JUL-19
  205.         BP Key: 177   Status: AVAILABLE  Compressed: NO  Tag: TAG20190718T183055
  206.         Handle: 0cu6vtmv_1_1   Media: station76-000003
  207.   List of Datafiles in backup set 165
  208.   File LV Type Ckp SCN    Ckp Time  Name
  209.   ---- -- ---- ---------- --------- ----
  210.   1       Full 1037443    18-JUL-19 +DATA/orcl/datafile/system.256.1013960881

  212. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  213. ------- ---- -- ---------- ----------- ------------ ---------------
  214. 286     Incr 0  712.75M    SBT_TAPE    00:01:46     20-JUL-19
  215.   List of Datafiles in backup set 286
  216.   File LV Type Ckp SCN    Ckp Time  Name
  217.   ---- -- ---- ---------- --------- ----
  218.   1    0  Incr 1082359    20-JUL-19 +DATA/orcl/datafile/system.256.1013960881

  220.   Backup Set Copy #1 of backup set 286
  221.   Device Type Elapsed Time Completion Time Compressed Tag
  222.   ----------- ------------ --------------- ---------- ---
  223.   SBT_TAPE    00:01:46     20-JUL-19       NO         2T-WHOLE-INCR0

  225.     List of Backup Pieces for backup set 286 Copy #1
  226.     BP Key  Pc# Status      Media                   Piece Name
  227.     ------- --- ----------- ----------------------- ----------
  228.     292     1   AVAILABLE   station76-000002        0iu735ts_1_1
  229.     293     2   AVAILABLE   station76-000002,station76-000004 0iu735ts_2_1
  230.     294     3   AVAILABLE   station76-000004        0iu735ts_3_1

  232. RMAN>
复制代码
如果RMAN默认去磁带机，但是临时要去磁盘，请参考：
  1. Recovery Manager: Release 11.2.0.4.0 - Production on Sat Jul 20 00:42:04 2019

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

  5. RMAN>
  6. connected to target database: ORCL (DBID=1541741703)
  7. using target database control file instead of recovery catalog

  9. RMAN>
  10. echo set on


  13. RMAN> set command id to 'BACKUP_ORCL.EXAMPL_072019124141';
  14. executing command: SET COMMAND ID


  17. RMAN> backup incremental level 1 cumulative device type disk tag 'BACKUP_ORCL.EXAMPL_072019124141' database;
  18. Starting backup at 20-JUL-19
  19. allocated channel: ORA_DISK_1
  20. channel ORA_DISK_1: SID=53 device type=DISK
  21. allocated channel: ORA_DISK_2
  22. channel ORA_DISK_2: SID=72 device type=DISK
  23. allocated channel: ORA_DISK_3
  24. channel ORA_DISK_3: SID=59 device type=DISK
  25. allocated channel: ORA_DISK_4
  26. channel ORA_DISK_4: SID=49 device type=DISK
  27. allocated channel: ORA_DISK_5
  28. channel ORA_DISK_5: SID=42 device type=DISK
  29. allocated channel: ORA_DISK_6
  30. channel ORA_DISK_6: SID=1 device type=DISK
  31. allocated channel: ORA_DISK_7
  32. channel ORA_DISK_7: SID=48 device type=DISK
  33. allocated channel: ORA_DISK_8
  34. channel ORA_DISK_8: SID=80 device type=DISK
  35. channel ORA_DISK_1: starting incremental level 1 datafile backup set
  36. channel ORA_DISK_1: specifying datafile(s) in backup set
  37. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1013960881
  38. channel ORA_DISK_1: starting piece 1 at 20-JUL-19
  39. channel ORA_DISK_2: starting incremental level 1 datafile backup set
  40. channel ORA_DISK_2: specifying datafile(s) in backup set
  41. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.1013960883
  42. channel ORA_DISK_2: starting piece 1 at 20-JUL-19
  43. channel ORA_DISK_3: starting incremental level 1 datafile backup set
  44. channel ORA_DISK_3: specifying datafile(s) in backup set
  45. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.1013960987
  46. channel ORA_DISK_3: starting piece 1 at 20-JUL-19
  47. channel ORA_DISK_4: starting incremental level 1 datafile backup set
  48. channel ORA_DISK_4: specifying datafile(s) in backup set
  49. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.1013960883
  50. channel ORA_DISK_4: starting piece 1 at 20-JUL-19
  51. channel ORA_DISK_5: starting incremental level 1 datafile backup set
  52. channel ORA_DISK_5: specifying datafile(s) in backup set
  53. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1013960885
  54. channel ORA_DISK_5: starting piece 1 at 20-JUL-19
  55. channel ORA_DISK_5: finished piece 1 at 20-JUL-19
  56. piece handle=+FRA/orcl/backupset/2019_07_20/nnndn1_backup_orcl.exampl_0720191241_0.297.1014079337 tag=BACKUP_ORCL.EXAMPL_072019124141 comment=NONE
  57. channel ORA_DISK_5: backup set complete, elapsed time: 00:00:03
  58. channel ORA_DISK_1: finished piece 1 at 20-JUL-19
  59. piece handle=+FRA/orcl/backupset/2019_07_20/nnndn1_backup_orcl.exampl_0720191241_0.303.1014079335 tag=BACKUP_ORCL.EXAMPL_072019124141 comment=NONE
  60. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
  61. channel ORA_DISK_2: finished piece 1 at 20-JUL-19
  62. piece handle=+FRA/orcl/backupset/2019_07_20/nnndn1_backup_orcl.exampl_0720191241_0.301.1014079335 tag=BACKUP_ORCL.EXAMPL_072019124141 comment=NONE
  63. channel ORA_DISK_2: backup set complete, elapsed time: 00:00:08
  64. channel ORA_DISK_3: finished piece 1 at 20-JUL-19
  65. piece handle=+FRA/orcl/backupset/2019_07_20/nnndn1_backup_orcl.exampl_0720191241_0.300.1014079335 tag=BACKUP_ORCL.EXAMPL_072019124141 comment=NONE
  66. channel ORA_DISK_3: backup set complete, elapsed time: 00:00:08
  67. channel ORA_DISK_4: finished piece 1 at 20-JUL-19
  68. piece handle=+FRA/orcl/backupset/2019_07_20/nnndn1_backup_orcl.exampl_0720191241_0.298.1014079335 tag=BACKUP_ORCL.EXAMPL_072019124141 comment=NONE
  69. channel ORA_DISK_4: backup set complete, elapsed time: 00:00:08
  70. Finished backup at 20-JUL-19

  72. Starting Control File and SPFILE Autobackup at 20-JUL-19
  73. piece handle=+FRA/orcl/autobackup/2019_07_20/s_1014079343.296.1014079343 comment=NONE
  74. Finished Control File and SPFILE Autobackup at 20-JUL-19


  77. RMAN> backup device type disk tag 'BACKUP_ORCL.EXAMPL_072019124141' archivelog all not backed up delete all input;
  78. Starting backup at 20-JUL-19
  79. current log archived
  80. using channel ORA_DISK_1
  81. using channel ORA_DISK_2
  82. using channel ORA_DISK_3
  83. using channel ORA_DISK_4
  84. using channel ORA_DISK_5
  85. using channel ORA_DISK_6
  86. using channel ORA_DISK_7
  87. using channel ORA_DISK_8
  88. channel ORA_DISK_1: starting archived log backup set
  89. channel ORA_DISK_1: specifying archived log(s) in backup set
  90. input archived log thread=1 sequence=47 RECID=42 STAMP=1014079348
  91. channel ORA_DISK_1: starting piece 1 at 20-JUL-19
  92. channel ORA_DISK_1: finished piece 1 at 20-JUL-19
  93. piece handle=+FRA/orcl/backupset/2019_07_20/annnf0_backup_orcl.exampl_0720191241_0.294.1014079349 tag=BACKUP_ORCL.EXAMPL_072019124141 comment=NONE
  94. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
  95. channel ORA_DISK_1: deleting archived log(s)
  96. archived log file name=+FRA/orcl/archivelog/2019_07_20/thread_1_seq_47.295.1014079347 RECID=42 STAMP=1014079348
  97. Finished backup at 20-JUL-19

  99. Starting Control File and SPFILE Autobackup at 20-JUL-19
  100. piece handle=+FRA/orcl/autobackup/2019_07_20/s_1014079351.295.1014079353 comment=NONE
  101. Finished Control File and SPFILE Autobackup at 20-JUL-19


  104. RMAN> exit;

  106. Recovery Manager complete.


复制代码
  1. ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
  2. ORACLE_SID=orcl
  3. ORACLE_BASE=/u01/app/oracle

  5. */3  * * * *   /u01/app/oracle/product/11.2.0/dbhome_1/bin/rman  target / catalog u76/oracle_4U@rcat cmdfile=/home/oracle/backupusers.rcv
复制代码













回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-5-9 19:58 , Processed in 0.039209 second(s), 24 queries .

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