设为首页收藏本站

Botang唐波's Oracle Station

查看: 275|回复: 0

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

[复制链接]

685

主题

1045

帖子

7638

积分

管理员

Rank: 9Rank: 9Rank: 9

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

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

  4. RMAN> configure  exclude for tablespace users;

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

  7. RMAN>  show exclude;

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

  10. RMAN> show all;

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

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

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

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

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

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

  32. old RMAN configuration parameters:
  33. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' MAXPIECESIZE 100 M;
  34. new RMAN configuration parameters:
  35. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  36. new RMAN configuration parameters are successfully stored

  37. RMAN> show all;

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

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

  60. Starting backup at 2018-04-27:00:45:58
  61. allocated channel: ORA_SBT_TAPE_1
  62. channel ORA_SBT_TAPE_1: SID=18 device type=SBT_TAPE
  63. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  64. allocated channel: ORA_SBT_TAPE_2
  65. channel ORA_SBT_TAPE_2: SID=145 device type=SBT_TAPE
  66. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  67. RMAN-00571: ===========================================================
  68. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  69. RMAN-00571: ===========================================================
  70. RMAN-03002: failure of backup command at 04/27/2018 00:46:11
  71. RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect

  72. RMAN> show all;

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

  94. RMAN> exit


  95. Recovery Manager complete.
  96. [oracle@station90 ~]$ rman target /

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

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

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

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

  101. Starting backup at 2018-04-27:00:46:28
  102. using target database control file instead of recovery catalog
  103. allocated channel: ORA_SBT_TAPE_1
  104. channel ORA_SBT_TAPE_1: SID=18 device type=SBT_TAPE
  105. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  106. allocated channel: ORA_SBT_TAPE_2
  107. channel ORA_SBT_TAPE_2: SID=145 device type=SBT_TAPE
  108. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  109. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  110. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  111. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.973682053
  112. backing up blocks 1 through 12800
  113. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-04-27:00:46:40
  114. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  115. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  116. input datafile file number=00005 name=+DATA/orcl/datafile/example.262.973682055
  117. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-04-27:00:46:41
  118. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-04-27:00:47:06
  119. piece handle=3lt1bkbg_1_1 tag=F_SYSTEM_EXAMPLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  120. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
  121. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  122. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  123. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.973682053
  124. backing up blocks 12801 through 25600
  125. channel ORA_SBT_TAPE_1: starting piece 2 at 2018-04-27:00:47:06
  126. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-04-27:00:47:06
  127. piece handle=3mt1bkbg_1_1 tag=F_SYSTEM_EXAMPLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  128. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  129. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  130. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  131. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.973682053
  132. backing up blocks 25601 through 38400
  133. channel ORA_SBT_TAPE_2: starting piece 3 at 2018-04-27:00:47:06
  134. channel ORA_SBT_TAPE_1: finished piece 2 at 2018-04-27:00:47:31
  135. piece handle=3lt1bkbg_2_1 tag=F_SYSTEM_EXAMPLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  136. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  137. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  138. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  139. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.973682053
  140. backing up blocks 38401 through 51200
  141. channel ORA_SBT_TAPE_1: starting piece 4 at 2018-04-27:00:47:31
  142. channel ORA_SBT_TAPE_2: finished piece 3 at 2018-04-27:00:47:31
  143. piece handle=3lt1bkbg_3_1 tag=F_SYSTEM_EXAMPLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  144. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  145. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  146. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  147. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.973682053
  148. backing up blocks 51201 through 64000
  149. channel ORA_SBT_TAPE_2: starting piece 5 at 2018-04-27:00:47:31
  150. channel ORA_SBT_TAPE_1: finished piece 4 at 2018-04-27:00:47:56
  151. piece handle=3lt1bkbg_4_1 tag=F_SYSTEM_EXAMPLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  152. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  153. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  154. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  155. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.973682053
  156. backing up blocks 64001 through 76800
  157. channel ORA_SBT_TAPE_1: starting piece 6 at 2018-04-27:00:47:56
  158. channel ORA_SBT_TAPE_2: finished piece 5 at 2018-04-27:00:47:56
  159. piece handle=3lt1bkbg_5_1 tag=F_SYSTEM_EXAMPLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
  160. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  161. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  162. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  163. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.973682053
  164. backing up blocks 76801 through 89600
  165. 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

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

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

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

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

  35.   Backup Set Copy #1 of backup set 101
  36.   Device Type Elapsed Time Completion Time     Compressed Tag
  37.   ----------- ------------ ------------------- ---------- ---
  38.   SBT_TAPE    00:01:32     2018-04-27:00:48:12 NO         F_SYSTEM_EXAMPLE_INCR0

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

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

  58. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  59. ------- ---- -- ---------- ----------- ------------ -------------------
  60. 103     Full    9.75M      SBT_TAPE    00:00:24     2018-04-27:00:48:46
  61.         BP Key: 116   Status: AVAILABLE  Compressed: NO  Tag: TAG20180427T004822
  62.         Handle: c-1343950367-20180427-05   Media: station90-000012
  63.   SPFILE Included: Modification time: 2018-04-20:19:34:30
  64.   SPFILE db_unique_name: ORCL
  65.   Control File Included: Ckp SCN: 2601114      Ckp time: 2018-04-27:00:48:22

  66. 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> }

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

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

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

  29. RMAN> list backup;
复制代码




回复

使用道具 举报

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

本版积分规则

QQ|手机版|Botang唐波's Oracle Station   

GMT+8, 2018-7-22 12:37 , Processed in 0.226270 second(s), 24 queries .

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