开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 4077-12c管理类OCP认证班第四期 › 课程第33/34次（2018-04-22星期日上下午）
返回列表 发新帖
查看: 2144|回复: 0

课程第33/34次（2018-04-22星期日上下午）

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2018-4-22 10:10:48 | 显示全部楼层 |阅读模式
  1. RMAN> show exclude;

  3. RMAN configuration parameters for database with db_unique_name ORCL are:
  4. RMAN configuration has no stored or default parameters

  6. RMAN> configure  exclude for tablespace users;

  8. Tablespace USERS will be excluded from future whole database backups
  9. new RMAN configuration parameters are successfully stored

  11. RMAN>  show exclude;

  13. RMAN configuration parameters for database with db_unique_name ORCL are:
  14. CONFIGURE EXCLUDE FOR TABLESPACE 'USERS';

  16. RMAN> show all;

  18. RMAN configuration parameters for database with db_unique_name ORCL are:
  19. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  20. CONFIGURE BACKUP OPTIMIZATION ON;
  21. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  22. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  23. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  24. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  25. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  26. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  27. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  28. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  29. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  30. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  31. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  32. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  33. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  34. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  35. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  36. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  37. CONFIGURE EXCLUDE FOR TABLESPACE 'USERS';
  38. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  39. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  41. RMAN>
复制代码
一个备份集下面多个备份 片例子1：
新的分片备份方式：
  1. RMAN> show all;

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

  25. RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';

  27. old RMAN configuration parameters:
  28. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' MAXPIECESIZE 100 M;
  29. new RMAN configuration parameters:
  30. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  31. new RMAN configuration parameters are successfully stored
  32. released channel: ORA_SBT_TAPE_1
  33. released channel: ORA_SBT_TAPE_2

  35. RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';

  37. old RMAN configuration parameters:
  38. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' MAXPIECESIZE 100 M;
  39. new RMAN configuration parameters:
  40. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  41. new RMAN configuration parameters are successfully stored

  43. RMAN> show all;

  45. RMAN configuration parameters for database with db_unique_name ORCL are:
  46. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  47. CONFIGURE BACKUP OPTIMIZATION ON;
  48. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  49. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  50. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  51. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  52. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  53. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  54. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  55. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  56. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  57. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  58. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  59. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  60. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  61. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  62. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  63. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  64. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  65. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  67. RMAN> backup  section size 100M  tag 'F_SYSTEM_EXAMPLE_INCR0' incremental level 0 tablespace system, example ;

  69. Starting backup at 2018-04-27:00:45:58
  70. allocated channel: ORA_SBT_TAPE_1
  71. channel ORA_SBT_TAPE_1: SID=18 device type=SBT_TAPE
  72. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  73. allocated channel: ORA_SBT_TAPE_2
  74. channel ORA_SBT_TAPE_2: SID=145 device type=SBT_TAPE
  75. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  76. RMAN-00571: ===========================================================
  77. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  78. RMAN-00571: ===========================================================
  79. RMAN-03002: failure of backup command at 04/27/2018 00:46:11
  80. RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect

  82. RMAN> show all;

  84. RMAN configuration parameters for database with db_unique_name ORCL are:
  85. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  86. CONFIGURE BACKUP OPTIMIZATION ON;
  87. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  88. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  89. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  90. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  91. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  92. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  93. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  94. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  95. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  96. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  97. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  98. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  99. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  100. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  101. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  102. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  103. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  104. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  106. RMAN> exit


  109. Recovery Manager complete.
  110. [oracle@station90 ~]$ rman target /

  112. Recovery Manager: Release 11.2.0.1.0 - Production on Fri Apr 27 00:46:24 2018

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

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

  118. RMAN> backup  section size 100M  tag 'F_SYSTEM_EXAMPLE_INCR0' incremental level 0 tablespace system, example ;

  120. Starting backup at 2018-04-27:00:46:28
  121. using target database control file instead of recovery catalog
  122. allocated channel: ORA_SBT_TAPE_1
  123. channel ORA_SBT_TAPE_1: SID=18 device type=SBT_TAPE
  124. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  125. allocated channel: ORA_SBT_TAPE_2
  126. channel ORA_SBT_TAPE_2: SID=145 device type=SBT_TAPE
  127. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  128. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  129. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  130. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.973682053
  131. backing up blocks 1 through 12800
  132. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-04-27:00:46:40
  133. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  134. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  135. input datafile file number=00005 name=+DATA/orcl/datafile/example.262.973682055
  136. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-04-27:00:46:41
  137. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-04-27:00:47:06
  138. piece handle=3lt1bkbg_1_1 tag=F_SYSTEM_EXAMPLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  139. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
  140. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  141. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  142. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.973682053
  143. backing up blocks 12801 through 25600
  144. channel ORA_SBT_TAPE_1: starting piece 2 at 2018-04-27:00:47:06
  145. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-04-27:00:47:06
  146. piece handle=3mt1bkbg_1_1 tag=F_SYSTEM_EXAMPLE_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. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.973682053
  151. backing up blocks 25601 through 38400
  152. channel ORA_SBT_TAPE_2: starting piece 3 at 2018-04-27:00:47:06
  153. channel ORA_SBT_TAPE_1: finished piece 2 at 2018-04-27:00:47:31
  154. piece handle=3lt1bkbg_2_1 tag=F_SYSTEM_EXAMPLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  155. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  156. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  157. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  158. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.973682053
  159. backing up blocks 38401 through 51200
  160. channel ORA_SBT_TAPE_1: starting piece 4 at 2018-04-27:00:47:31
  161. channel ORA_SBT_TAPE_2: finished piece 3 at 2018-04-27:00:47:31
  162. piece handle=3lt1bkbg_3_1 tag=F_SYSTEM_EXAMPLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  163. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  164. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  165. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  166. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.973682053
  167. backing up blocks 51201 through 64000
  168. channel ORA_SBT_TAPE_2: starting piece 5 at 2018-04-27:00:47:31
  169. channel ORA_SBT_TAPE_1: finished piece 4 at 2018-04-27:00:47:56
  170. piece handle=3lt1bkbg_4_1 tag=F_SYSTEM_EXAMPLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  171. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  172. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  173. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  174. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.973682053
  175. backing up blocks 64001 through 76800
  176. channel ORA_SBT_TAPE_1: starting piece 6 at 2018-04-27:00:47:56
  177. channel ORA_SBT_TAPE_2: finished piece 5 at 2018-04-27:00:47:56
  178. piece handle=3lt1bkbg_5_1 tag=F_SYSTEM_EXAMPLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  179. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  180. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  181. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  182. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.973682053
  183. backing up blocks 76801 through 89600
  184. channel ORA_SBT_TAPE_2: starting piece 7 at 2018-04-27:00:47:57

复制代码

充分利用了通道2：
  1. 99      Incr 0  606.00M    SBT_TAPE    00:02:45     2018-04-27:00:43:01
  2.   List of Datafiles in backup set 99
  3.   File LV Type Ckp SCN    Ckp Time            Name
  4.   ---- -- ---- ---------- ------------------- ----
  5.   1    0  Incr 2600551    2018-04-27:00:40:16 +DATA/orcl/datafile/system.256.973682053

  7.   Backup Set Copy #1 of backup set 99
  8.   Device Type Elapsed Time Completion Time     Compressed Tag
  9.   ----------- ------------ ------------------- ---------- ---
  10.   SBT_TAPE    00:02:45     2018-04-27:00:43:01 NO         E_SYSTEM_EXAMPLE_INCR0

  12.     List of Backup Pieces for backup set 99 Copy #1
  13.     BP Key  Pc# Status      Media                   Piece Name
  14.     ------- --- ----------- ----------------------- ----------
  15.     100     1   AVAILABLE   station90-000012        3it1bjvg_1_1
  16.     101     2   AVAILABLE   station90-000012        3it1bjvg_2_1
  17.     102     3   AVAILABLE   station90-000012        3it1bjvg_3_1
  18.     103     4   AVAILABLE   station90-000012        3it1bjvg_4_1
  19.     104     5   AVAILABLE   station90-000012        3it1bjvg_5_1
  20.     105     6   AVAILABLE   station90-000012        3it1bjvg_6_1
  21.     106     7   AVAILABLE   station90-000012        3it1bjvg_7_1

  23. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  24. ------- ---- -- ---------- ----------- ------------ -------------------
  25. 100     Full    9.75M      SBT_TAPE    00:00:16     2018-04-27:00:43:27
  26.         BP Key: 107   Status: AVAILABLE  Compressed: NO  Tag: TAG20180427T004311
  27.         Handle: c-1343950367-20180427-04   Media: station90-000012
  28.   SPFILE Included: Modification time: 2018-04-20:19:34:30
  29.   SPFILE db_unique_name: ORCL
  30.   Control File Included: Ckp SCN: 2600736      Ckp time: 2018-04-27:00:43:11

  32. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  33. ------- ---- -- ---------- ----------- ------------ -------------------
  34. 101     Incr 0  606.50M    SBT_TAPE    00:01:32     2018-04-27:00:48:12
  35.   List of Datafiles in backup set 101
  36.   File LV Type Ckp SCN    Ckp Time            Name
  37.   ---- -- ---- ---------- ------------------- ----
  38.   1    0  Incr 2600961    2018-04-27:00:46:40 +DATA/orcl/datafile/system.256.973682053

  40.   Backup Set Copy #1 of backup set 101
  41.   Device Type Elapsed Time Completion Time     Compressed Tag
  42.   ----------- ------------ ------------------- ---------- ---
  43.   SBT_TAPE    00:01:32     2018-04-27:00:48:12 NO         F_SYSTEM_EXAMPLE_INCR0

  45.     List of Backup Pieces for backup set 101 Copy #1
  46.     BP Key  Pc# Status      Media                   Piece Name
  47.     ------- --- ----------- ----------------------- ----------
  48.     108     1   AVAILABLE   station90-000013        3lt1bkbg_1_1
  49.     110     2   AVAILABLE   station90-000012        3lt1bkbg_2_1
  50.     111     3   AVAILABLE   station90-000013        3lt1bkbg_3_1
  51.     112     4   AVAILABLE   station90-000013        3lt1bkbg_4_1
  52.     113     5   AVAILABLE   station90-000012        3lt1bkbg_5_1
  53.     114     6   AVAILABLE   station90-000012        3lt1bkbg_6_1
  54.     115     7   AVAILABLE   station90-000013        3lt1bkbg_7_1

  56. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  57. ------- ---- -- ---------- ----------- ------------ -------------------
  58. 102     Incr 0  69.75M     SBT_TAPE    00:00:24     2018-04-27:00:47:04
  59.         BP Key: 109   Status: AVAILABLE  Compressed: NO  Tag: F_SYSTEM_EXAMPLE_INCR0
  60.         Handle: 3mt1bkbg_1_1   Media: station90-000012
  61.   List of Datafiles in backup set 102
  62.   File LV Type Ckp SCN    Ckp Time            Name
  63.   ---- -- ---- ---------- ------------------- ----
  64.   5    0  Incr 2600962    2018-04-27:00:46:41 +DATA/orcl/datafile/example.262.973682055

  66. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  67. ------- ---- -- ---------- ----------- ------------ -------------------
  68. 103     Full    9.75M      SBT_TAPE    00:00:24     2018-04-27:00:48:46
  69.         BP Key: 116   Status: AVAILABLE  Compressed: NO  Tag: TAG20180427T004822
  70.         Handle: c-1343950367-20180427-05   Media: station90-000012
  71.   SPFILE Included: Modification time: 2018-04-20:19:34:30
  72.   SPFILE db_unique_name: ORCL
  73.   Control File Included: Ckp SCN: 2601114      Ckp time: 2018-04-27:00:48:22

  75. RMAN>
复制代码
一个备份集下面多个备份 片例子2：
duplex备份：
  1. RMAN> run {
  2. 2> allocate channel c1 device type disk format '/home/oracle/backup1/%U','/home/oracle/backup2/%U';
  3. 3> backup tablespace users ;
  4. 4> }

  6. released channel: ORA_DISK_1
  7. released channel: ORA_DISK_2
  8. released channel: ORA_DISK_3
  9. released channel: ORA_DISK_4
  10. released channel: ORA_DISK_5
  11. released channel: ORA_DISK_6
  12. released channel: ORA_DISK_7
  13. released channel: ORA_DISK_8
  14. allocated channel: c1
  15. channel c1: SID=18 device type=DISK

  17. Starting backup at 2018-04-27:01:02:05
  18. channel c1: starting full datafile backup set
  19. channel c1: specifying datafile(s) in backup set
  20. input datafile file number=00004 name=+DATA/orcl/datafile/users.261.973682055
  21. channel c1: starting piece 1 at 2018-04-27:01:02:06
  22. channel c1: finished piece 1 at 2018-04-27:01:02:07 with 2 copies and tag TAG20180427T010205
  23. piece handle=/home/oracle/backup1/43t1bl8e_1_1 comment=NONE
  24. piece handle=/home/oracle/backup2/43t1bl8e_1_2 comment=NONE
  25. channel c1: backup set complete, elapsed time: 00:00:01
  26. Finished backup at 2018-04-27:01:02:07

  28. Starting Control File and SPFILE Autobackup at 2018-04-27:01:02:07
  29. piece handle=+FRA/orcl/autobackup/2018_04_27/s_974509327.304.974509327 comment=NONE
  30. Finished Control File and SPFILE Autobackup at 2018-04-27:01:02:08
  31. released channel: c1

  33. RMAN> list backup;
复制代码




回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-4-19 14:47 , Processed in 0.135514 second(s), 24 queries .

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