设为首页收藏本站

Botang唐波's Oracle Station

查看: 59|回复: 0

活动第25/26次

[复制链接]

659

主题

1018

帖子

7486

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
7486
发表于 2018-6-9 10:01:05 | 显示全部楼层 |阅读模式
增量备份和判断需要多少段增量备份的命令:
  1. [oracle@station87 ~]$ rman target /

  2. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 9 17:33:46 2018

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

  4. connected to target database: ORCL (DBID=1359978017)

  5. RMAN> list archivelog all;

  6. using target database control file instead of recovery catalog
  7. List of Archived Log Copies for database with db_unique_name ORCL
  8. =====================================================================

  9. Key     Thrd Seq     S Low Time           
  10. ------- ---- ------- - -------------------
  11. 44      1    48      A 2018-06-08:00:44:31
  12.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_48.278.978227071

  13. 45      1    49      A 2018-06-08:01:44:31
  14.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_49.275.978227073

  15. 46      1    50      A 2018-06-08:01:44:32
  16.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_50.277.978227077

  17. 47      1    51      A 2018-06-08:01:44:35
  18.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_51.276.978227079

  19. 48      1    52      A 2018-06-08:01:44:38
  20.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_52.274.978227083

  21. 49      1    53      A 2018-06-08:01:44:41
  22.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_53.273.978227085

  23. 50      1    54      A 2018-06-08:01:44:44
  24.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_54.272.978227785

  25. 51      1    55      A 2018-06-08:01:56:25
  26.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_55.271.978227787

  27. 52      1    56      A 2018-06-08:01:56:25
  28.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_56.270.978227787

  29. 53      1    57      A 2018-06-08:01:56:26
  30.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_57.267.978227789

  31. 54      1    58      A 2018-06-08:01:56:29
  32.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_58.260.978227793

  33. 55      1    59      A 2018-06-08:01:56:32
  34.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_59.269.978227793

  35. 56      1    60      A 2018-06-08:01:56:33
  36.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_60.287.978228469

  37. 57      1    61      A 2018-06-08:02:07:49
  38.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_61.286.978228471

  39. 58      1    62      A 2018-06-08:02:07:49
  40.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_62.285.978228471

  41. 59      1    63      A 2018-06-08:02:07:50
  42.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_63.284.978228473

  43. 60      1    64      A 2018-06-08:02:07:53
  44.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_64.283.978228477

  45. 61      1    65      A 2018-06-08:02:07:56
  46.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_65.282.978228477

  47. 62      1    66      A 2018-06-08:02:07:56
  48.         Name: +FRA/orcl/archivelog/2018_06_06/thread_1_seq_66.281.978065947

  49. 63      1    67      A 2018-06-06:04:59:06
  50.         Name: +FRA/orcl/archivelog/2018_06_06/thread_1_seq_67.280.978120771

  51. 64      1    68      A 2018-06-06:20:12:51
  52.         Name: +FRA/orcl/archivelog/2018_06_07/thread_1_seq_68.279.978195181

  53. 65      1    69      A 2018-06-07:16:53:00
  54.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_69.268.978236523

  55. 66      1    70      A 2018-06-08:04:22:01
  56.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_70.262.978236529

  57. 67      1    71      A 2018-06-08:04:22:06
  58.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_71.263.978236623

  59. 68      1    72      A 2018-06-08:04:23:43
  60.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_72.266.978236639

  61. 69      1    73      A 2018-06-08:04:23:57
  62.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_73.265.978236653

  63. 70      1    74      A 2018-06-08:04:24:10
  64.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_74.264.978236663

  65. 71      1    75      A 2018-06-08:04:24:21
  66.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_75.261.978237207

  67. 72      1    76      A 2018-06-08:04:33:25
  68.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_76.288.978237221

  69. 73      1    77      A 2018-06-08:04:33:39
  70.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_77.289.978237229

  71. 74      1    78      A 2018-06-08:04:33:46
  72.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_78.290.978237241

  73. 75      1    79      A 2018-06-08:04:34:01
  74.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_79.291.978237573

  75. 76      1    80      A 2018-06-08:04:39:31
  76.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_80.292.978237583

  77. 77      1    81      A 2018-06-08:04:39:42
  78.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_81.293.978239425

  79. 78      1    82      A 2018-06-08:05:10:25
  80.         Name: +FRA/orcl/archivelog/2018_06_09/thread_1_seq_82.296.978315691

  81. 79      1    83      A 2018-06-09:02:21:30
  82.         Name: +FRA/orcl/archivelog/2018_06_09/thread_1_seq_83.312.978328975

  83. 80      1    84      A 2018-06-09:06:02:55
  84.         Name: +FRA/orcl/archivelog/2018_06_09/thread_1_seq_84.317.978369677


  85. RMAN> backup tag '1T_ARCH78-80'  archivelog  from sequence 78 until sequence 80;

  86. Starting backup at 2018-06-09:17:35:40
  87. allocated channel: ORA_SBT_TAPE_1
  88. channel ORA_SBT_TAPE_1: SID=10 device type=SBT_TAPE
  89. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  90. allocated channel: ORA_SBT_TAPE_2
  91. channel ORA_SBT_TAPE_2: SID=12 device type=SBT_TAPE
  92. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  93. channel ORA_SBT_TAPE_1: starting archived log backup set
  94. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  95. input archived log thread=1 sequence=78 RECID=74 STAMP=978237243
  96. input archived log thread=1 sequence=79 RECID=75 STAMP=978237574
  97. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:17:35:50
  98. channel ORA_SBT_TAPE_2: starting archived log backup set
  99. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
  100. input archived log thread=1 sequence=80 RECID=76 STAMP=978237586
  101. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-06-09:17:35:50
  102. RMAN-00571: ===========================================================
  103. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  104. RMAN-00571: ===========================================================
  105. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 06/09/2018 17:35:50
  106. ORA-19914: unable to encrypt backup
  107. ORA-28365: wallet is not open

  108. RMAN> show all;

  109. RMAN configuration parameters for database with db_unique_name ORCL are:
  110. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  111. CONFIGURE BACKUP OPTIMIZATION ON;
  112. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  113. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  114. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  115. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  116. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  117. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  118. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  119. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  120. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  121. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  122. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
  123. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
  124. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  125. CONFIGURE ENCRYPTION FOR DATABASE ON;
  126. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  127. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  128. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  129. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  130. RMAN> CONFIGURE ENCRYPTION FOR DATABASE  off;

  131. old RMAN configuration parameters:
  132. CONFIGURE ENCRYPTION FOR DATABASE ON;
  133. new RMAN configuration parameters:
  134. CONFIGURE ENCRYPTION FOR DATABASE OFF;
  135. new RMAN configuration parameters are successfully stored

  136. RMAN> backup tag '1T_ARCH78-80'  archivelog  from sequence 78 until sequence 80;

  137. Starting backup at 2018-06-09:17:36:08
  138. using channel ORA_SBT_TAPE_1
  139. using channel ORA_SBT_TAPE_2
  140. channel ORA_SBT_TAPE_1: starting archived log backup set
  141. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  142. input archived log thread=1 sequence=78 RECID=74 STAMP=978237243
  143. input archived log thread=1 sequence=79 RECID=75 STAMP=978237574
  144. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:17:36:08
  145. channel ORA_SBT_TAPE_2: starting archived log backup set
  146. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
  147. input archived log thread=1 sequence=80 RECID=76 STAMP=978237586
  148. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-06-09:17:36:08
  149. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:17:37:23
  150. piece handle=2st51g08_1_1 tag=1T_ARCH78-80 comment=API Version 2.0,MMS Version 10.3.0.2
  151. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:15
  152. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-06-09:17:37:33
  153. piece handle=2tt51g08_1_1 tag=1T_ARCH78-80 comment=API Version 2.0,MMS Version 10.3.0.2
  154. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:25
  155. Finished backup at 2018-06-09:17:37:33

  156. Starting Control File and SPFILE Autobackup at 2018-06-09:17:37:33
  157. piece handle=c-1359978017-20180609-00 comment=API Version 2.0,MMS Version 10.3.0.2
  158. Finished Control File and SPFILE Autobackup at 2018-06-09:17:38:18

  159. RMAN> list backup;


  160. List of Backup Sets
  161. ===================


  162. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  163. ------- ---- -- ---------- ----------- ------------ -------------------
  164. 65      Incr 0  436.25M    SBT_TAPE    00:01:00     2018-06-08:01:08:17
  165.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSAUX_INCR0
  166.         Handle: 2ct4t1m5_1_1   Media: station87-000008
  167.   List of Datafiles in backup set 65
  168.   File LV Type Ckp SCN    Ckp Time            Name
  169.   ---- -- ---- ---------- ------------------- ----
  170.   2    0  Incr 1155660    2018-06-08:01:07:17 +DATA/orcl/datafile/sysaux.257.832197065

  171. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  172. ------- ---- -- ---------- ----------- ------------ -------------------
  173. 66      Full    10.00M     SBT_TAPE    00:00:39     2018-06-08:01:09:01
  174.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T010822
  175.         Handle: c-1359978017-20180608-07   Media: station87-000008
  176.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  177.   SPFILE db_unique_name: ORCL
  178.   Control File Included: Ckp SCN: 1155709      Ckp time: 2018-06-08:01:08:22

  179. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  180. ------- ---- -- ---------- ----------- ------------ -------------------
  181. 67      Incr 0  86.50M     SBT_TAPE    00:00:53     2018-06-08:01:13:00
  182.         BP Key: 73   Status: AVAILABLE  Compressed: YES  Tag: 2TC_SYSAUX_INCR0
  183.         Handle: 2et4t1v7_1_1   Media: station87-000008
  184.   List of Datafiles in backup set 67
  185.   File LV Type Ckp SCN    Ckp Time            Name
  186.   ---- -- ---- ---------- ------------------- ----
  187.   2    0  Incr 1155986    2018-06-08:01:12:07 +DATA/orcl/datafile/sysaux.257.832197065

  188. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  189. ------- ---- -- ---------- ----------- ------------ -------------------
  190. 68      Full    10.00M     SBT_TAPE    00:00:41     2018-06-08:01:13:43
  191.         BP Key: 74   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T011302
  192.         Handle: c-1359978017-20180608-08   Media: station87-000008
  193.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  194.   SPFILE db_unique_name: ORCL
  195.   Control File Included: Ckp SCN: 1156051      Ckp time: 2018-06-08:01:13:02

  196. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  197. ------- ---- -- ---------- ----------- ------------ -------------------
  198. 70      Full    10.00M     SBT_TAPE    00:00:27     2018-06-08:01:42:19
  199.         BP Key: 76   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T014152
  200.         Handle: c-1359978017-20180608-09   Media: station87-000008
  201.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  202.   SPFILE db_unique_name: ORCL
  203.   Control File Included: Ckp SCN: 1157970      Ckp time: 2018-06-08:01:41:52

  204. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  205. ------- ---- -- ---------- ----------- ------------ -------------------
  206. 71      Incr 0  3.50M      SBT_TAPE    00:00:56     2018-06-08:02:04:36
  207.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: 4TEDUAL_USERS_INCR0
  208.         Handle: 2kt4t4vs_1_1   Media: station87-000008
  209.   List of Datafiles in backup set 71
  210.   File LV Type Ckp SCN    Ckp Time            Name
  211.   ---- -- ---- ---------- ------------------- ----
  212.   4    0  Incr 1160195    2018-06-08:02:03:40 +DATA/orcl/datafile/users.259.978228669

  213. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  214. ------- ---- -- ---------- ----------- ------------ -------------------
  215. 72      Full    10.00M     SBT_TAPE    00:00:37     2018-06-08:02:05:22
  216.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T020445
  217.         Handle: c-1359978017-20180608-0a   Media: station87-000008
  218.   SPFILE Included: Modification time: 2018-06-08:02:04:15
  219.   SPFILE db_unique_name: ORCL
  220.   Control File Included: Ckp SCN: 1160247      Ckp time: 2018-06-08:02:04:45

  221. BS Key  Size       Device Type Elapsed Time Completion Time   
  222. ------- ---------- ----------- ------------ -------------------
  223. 73      87.00M     SBT_TAPE    00:01:13     2018-06-09:17:37:21
  224.         BP Key: 79   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  225.         Handle: 2st51g08_1_1   Media: station87-000008

  226.   List of Archived Logs in backup set 73
  227.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  228.   ---- ------- ---------- ------------------- ---------- ---------
  229.   1    78      1323993    2018-06-08:04:33:46 1328678    2018-06-08:04:34:01
  230.   1    79      1328678    2018-06-08:04:34:01 1340398    2018-06-08:04:39:31

  231. BS Key  Size       Device Type Elapsed Time Completion Time   
  232. ------- ---------- ----------- ------------ -------------------
  233. 74      46.00M     SBT_TAPE    00:01:20     2018-06-09:17:37:28
  234.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  235.         Handle: 2tt51g08_1_1   Media: station87-000009

  236.   List of Archived Logs in backup set 74
  237.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  238.   ---- ------- ---------- ------------------- ---------- ---------
  239.   1    80      1340398    2018-06-08:04:39:31 1344895    2018-06-08:04:39:42

  240. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  241. ------- ---- -- ---------- ----------- ------------ -------------------
  242. 75      Full    10.00M     SBT_TAPE    00:00:36     2018-06-09:17:38:09
  243.         BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T173733
  244.         Handle: c-1359978017-20180609-00   Media: station87-000008
  245.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  246.   SPFILE db_unique_name: ORCL
  247.   Control File Included: Ckp SCN: 1408511      Ckp time: 2018-06-09:17:37:33

  248. RMAN> backup  tag '2T_USERS_INCR1' incremental level 1 tablespace users;

  249. Starting backup at 2018-06-09:17:42:44
  250. using channel ORA_SBT_TAPE_1
  251. using channel ORA_SBT_TAPE_2
  252. channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set
  253. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  254. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.978228669
  255. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:17:42:44
  256. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:17:43:39
  257. piece handle=2vt51gck_1_1 tag=2T_USERS_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
  258. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:55
  259. Finished backup at 2018-06-09:17:43:39

  260. Starting Control File and SPFILE Autobackup at 2018-06-09:17:43:39
  261. piece handle=c-1359978017-20180609-01 comment=API Version 2.0,MMS Version 10.3.0.2
  262. Finished Control File and SPFILE Autobackup at 2018-06-09:17:44:24

  263. RMAN> list backup of tablespace users;


  264. List of Backup Sets
  265. ===================


  266. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  267. ------- ---- -- ---------- ----------- ------------ -------------------
  268. 71      Incr 0  3.50M      SBT_TAPE    00:00:56     2018-06-08:02:04:36
  269.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: 4TEDUAL_USERS_INCR0
  270.         Handle: 2kt4t4vs_1_1   Media: station87-000008
  271.   List of Datafiles in backup set 71
  272.   File LV Type Ckp SCN    Ckp Time            Name
  273.   ---- -- ---- ---------- ------------------- ----
  274.   4    0  Incr 1160195    2018-06-08:02:03:40 +DATA/orcl/datafile/users.259.978228669

  275. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  276. ------- ---- -- ---------- ----------- ------------ -------------------
  277. 76      Incr 1  30.50M     SBT_TAPE    00:00:48     2018-06-09:17:43:32
  278.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: 2T_USERS_INCR1
  279.         Handle: 2vt51gck_1_1   Media: station87-000009
  280.   List of Datafiles in backup set 76
  281.   File LV Type Ckp SCN    Ckp Time            Name
  282.   ---- -- ---- ---------- ------------------- ----
  283.   4    1  Incr 1408699    2018-06-09:17:42:44 +DATA/orcl/datafile/users.259.978228669

  284. RMAN> report need backup  incremental  1;  

  285. Report of files that need more than 1 incrementals during recovery
  286. File Incrementals Name
  287. ---- ------------ ----------------------------------------------

  288. RMAN> report need backup  incremental  0;

  289. Report of files that need more than 0 incrementals during recovery
  290. File Incrementals Name
  291. ---- ------------ ----------------------------------------------
  292. 4    1            +DATA/orcl/datafile/users.259.978228669

  293. RMAN> report need backup  incremental  1;

  294. Report of files that need more than 1 incrementals during recovery
  295. File Incrementals Name
  296. ---- ------------ ----------------------------------------------

  297. RMAN> backup  tag '3T_USERS_INCR1' incremental level 1 tablespace users;

  298. Starting backup at 2018-06-09:17:46:30
  299. using channel ORA_SBT_TAPE_1
  300. using channel ORA_SBT_TAPE_2
  301. channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set
  302. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  303. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.978228669
  304. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:17:46:30
  305. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:17:47:15
  306. piece handle=31t51gjm_1_1 tag=3T_USERS_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
  307. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45
  308. Finished backup at 2018-06-09:17:47:15

  309. Starting Control File and SPFILE Autobackup at 2018-06-09:17:47:15
  310. piece handle=c-1359978017-20180609-02 comment=API Version 2.0,MMS Version 10.3.0.2
  311. Finished Control File and SPFILE Autobackup at 2018-06-09:17:48:00

  312. RMAN>
复制代码

以下两个命令表示需要2个以上的增量备份记录段才能恢复完成的那些对象(表空间、数据库):
  1. RMAN> report need backup  incremental  1;

  2. Report of files that need more than 1 incrementals during recovery
  3. File Incrementals Name
  4. ---- ------------ ----------------------------------------------
  5. 4    2            +DATA/orcl/datafile/users.259.978228669

复制代码
  1. RMAN> backup  tag '4T_USERS_INCR1C' incremental level 1  cumulative      tablespace users;

  2. Starting backup at 2018-06-09:17:54:38
  3. using channel ORA_SBT_TAPE_1
  4. using channel ORA_SBT_TAPE_2
  5. channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set
  6. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  7. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.978228669
  8. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:17:54:38
  9. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:17:55:33
  10. piece handle=33t51h2u_1_1 tag=4T_USERS_INCR1C comment=API Version 2.0,MMS Version 10.3.0.2
  11. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:55
  12. Finished backup at 2018-06-09:17:55:33

  13. Starting Control File and SPFILE Autobackup at 2018-06-09:17:55:33
  14. piece handle=c-1359978017-20180609-03 comment=API Version 2.0,MMS Version 10.3.0.2
  15. Finished Control File and SPFILE Autobackup at 2018-06-09:17:56:08

  16. RMAN> report need backup  incremental  1;

  17. Report of files that need more than 1 incrementals during recovery
  18. File Incrementals Name
  19. ---- ------------ ----------------------------------------------

  20. RMAN> report need backup  incremental  0;

  21. Report of files that need more than 0 incrementals during recovery
  22. File Incrementals Name
  23. ---- ------------ ----------------------------------------------
  24. 4    1            +DATA/orcl/datafile/users.259.978228669

  25. RMAN>
复制代码

有了累积增量备份,就不需要之前做的那些差分增量备份:
  1. RMAN> backup  tag '4T_USERS_INCR1C' incremental level 1  cumulative      tablespace users;

  2. Starting backup at 2018-06-09:17:54:38
  3. using channel ORA_SBT_TAPE_1
  4. using channel ORA_SBT_TAPE_2
  5. channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set
  6. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  7. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.978228669
  8. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:17:54:38
  9. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:17:55:33
  10. piece handle=33t51h2u_1_1 tag=4T_USERS_INCR1C comment=API Version 2.0,MMS Version 10.3.0.2
  11. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:55
  12. Finished backup at 2018-06-09:17:55:33

  13. Starting Control File and SPFILE Autobackup at 2018-06-09:17:55:33
  14. piece handle=c-1359978017-20180609-03 comment=API Version 2.0,MMS Version 10.3.0.2
  15. Finished Control File and SPFILE Autobackup at 2018-06-09:17:56:08

  16. RMAN> report need backup  incremental  1;

  17. Report of files that need more than 1 incrementals during recovery
  18. File Incrementals Name
  19. ---- ------------ ----------------------------------------------

  20. RMAN> report need backup  incremental  0;

  21. Report of files that need more than 0 incrementals during recovery
  22. File Incrementals Name
  23. ---- ------------ ----------------------------------------------
  24. 4    1            +DATA/orcl/datafile/users.259.978228669
复制代码

加速增量备份的速度:
  1. SQL> alter database enable block change tracking using file '+fra';

  2. Database altered.

  3. SQL> exit
  4. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
  5. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  6. and Real Application Testing options
  7. [oracle@station87 ~]$ ps aux | grep ora_ctwr
  8. oracle   29589  0.0  0.4 960752 17992 ?        Ss   18:05   0:00 ora_ctwr_orcl
  9. oracle   29604  0.0  0.0   4220   628 pts/1    S+   18:05   0:00 grep ora_ctwr
  10. [oracle@station87 ~]$
复制代码
  1. [oracle@station87 ~]$ sqlplus /nolog

  2. SQL*Plus: Release 11.2.0.1.0 Production on Sat Jun 9 18:06:58 2018

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

  4. SQL> conn / as sysdba
  5. Connected.
  6. SQL> set linesize 1000
  7. SQL> select  * from v$block_change_tracking;

  8. STATUS           FILENAME                                                                                                                          BYTES
  9. ---------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------
  10. ENABLED    +FRA/orcl/changetracking/ctf.320.978372301                                                                                               11599872
复制代码

对磁盘上的备份集,再备份,目的都是为了转移它们到磁带机:

  1. RMAN> run {
  2. 2> allocate channel c1 device type disk ;  
  3. 3> backup tablespace users;
  4. 4> }

  5. allocated channel: c1
  6. channel c1: SID=72 device type=DISK

  7. Starting backup at 2018-06-09:18:14:08
  8. channel c1: starting full datafile backup set
  9. channel c1: specifying datafile(s) in backup set
  10. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.978228669
  11. channel c1: starting piece 1 at 2018-06-09:18:14:08
  12. channel c1: finished piece 1 at 2018-06-09:18:14:11
  13. piece handle=+FRA/orcl/backupset/2018_06_09/nnndf0_tag20180609t181408_0.321.978372849 tag=TAG20180609T181408 comment=NONE
  14. channel c1: backup set complete, elapsed time: 00:00:03
  15. Finished backup at 2018-06-09:18:14:11

  16. Starting Control File and SPFILE Autobackup at 2018-06-09:18:14:11
  17. piece handle=+FRA/orcl/autobackup/2018_06_09/s_978372851.322.978372853 comment=NONE
  18. Finished Control File and SPFILE Autobackup at 2018-06-09:18:14:14
  19. released channel: c1

  20. RMAN> list backup;


  21. List of Backup Sets
  22. ===================


  23. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  24. ------- ---- -- ---------- ----------- ------------ -------------------
  25. 65      Incr 0  436.25M    SBT_TAPE    00:01:00     2018-06-08:01:08:17
  26.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSAUX_INCR0
  27.         Handle: 2ct4t1m5_1_1   Media: station87-000008
  28.   List of Datafiles in backup set 65
  29.   File LV Type Ckp SCN    Ckp Time            Name
  30.   ---- -- ---- ---------- ------------------- ----
  31.   2    0  Incr 1155660    2018-06-08:01:07:17 +DATA/orcl/datafile/sysaux.257.832197065

  32. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  33. ------- ---- -- ---------- ----------- ------------ -------------------
  34. 66      Full    10.00M     SBT_TAPE    00:00:39     2018-06-08:01:09:01
  35.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T010822
  36.         Handle: c-1359978017-20180608-07   Media: station87-000008
  37.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  38.   SPFILE db_unique_name: ORCL
  39.   Control File Included: Ckp SCN: 1155709      Ckp time: 2018-06-08:01:08:22

  40. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  41. ------- ---- -- ---------- ----------- ------------ -------------------
  42. 67      Incr 0  86.50M     SBT_TAPE    00:00:53     2018-06-08:01:13:00
  43.         BP Key: 73   Status: AVAILABLE  Compressed: YES  Tag: 2TC_SYSAUX_INCR0
  44.         Handle: 2et4t1v7_1_1   Media: station87-000008
  45.   List of Datafiles in backup set 67
  46.   File LV Type Ckp SCN    Ckp Time            Name
  47.   ---- -- ---- ---------- ------------------- ----
  48.   2    0  Incr 1155986    2018-06-08:01:12:07 +DATA/orcl/datafile/sysaux.257.832197065

  49. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  50. ------- ---- -- ---------- ----------- ------------ -------------------
  51. 68      Full    10.00M     SBT_TAPE    00:00:41     2018-06-08:01:13:43
  52.         BP Key: 74   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T011302
  53.         Handle: c-1359978017-20180608-08   Media: station87-000008
  54.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  55.   SPFILE db_unique_name: ORCL
  56.   Control File Included: Ckp SCN: 1156051      Ckp time: 2018-06-08:01:13:02

  57. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  58. ------- ---- -- ---------- ----------- ------------ -------------------
  59. 70      Full    10.00M     SBT_TAPE    00:00:27     2018-06-08:01:42:19
  60.         BP Key: 76   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T014152
  61.         Handle: c-1359978017-20180608-09   Media: station87-000008
  62.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  63.   SPFILE db_unique_name: ORCL
  64.   Control File Included: Ckp SCN: 1157970      Ckp time: 2018-06-08:01:41:52

  65. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  66. ------- ---- -- ---------- ----------- ------------ -------------------
  67. 71      Incr 0  3.50M      SBT_TAPE    00:00:56     2018-06-08:02:04:36
  68.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: 4TEDUAL_USERS_INCR0
  69.         Handle: 2kt4t4vs_1_1   Media: station87-000008
  70.   List of Datafiles in backup set 71
  71.   File LV Type Ckp SCN    Ckp Time            Name
  72.   ---- -- ---- ---------- ------------------- ----
  73.   4    0  Incr 1160195    2018-06-08:02:03:40 +DATA/orcl/datafile/users.259.978228669

  74. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  75. ------- ---- -- ---------- ----------- ------------ -------------------
  76. 72      Full    10.00M     SBT_TAPE    00:00:37     2018-06-08:02:05:22
  77.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T020445
  78.         Handle: c-1359978017-20180608-0a   Media: station87-000008
  79.   SPFILE Included: Modification time: 2018-06-08:02:04:15
  80.   SPFILE db_unique_name: ORCL
  81.   Control File Included: Ckp SCN: 1160247      Ckp time: 2018-06-08:02:04:45

  82. BS Key  Size       Device Type Elapsed Time Completion Time   
  83. ------- ---------- ----------- ------------ -------------------
  84. 73      87.00M     SBT_TAPE    00:01:13     2018-06-09:17:37:21
  85.         BP Key: 79   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  86.         Handle: 2st51g08_1_1   Media: station87-000008

  87.   List of Archived Logs in backup set 73
  88.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  89.   ---- ------- ---------- ------------------- ---------- ---------
  90.   1    78      1323993    2018-06-08:04:33:46 1328678    2018-06-08:04:34:01
  91.   1    79      1328678    2018-06-08:04:34:01 1340398    2018-06-08:04:39:31

  92. BS Key  Size       Device Type Elapsed Time Completion Time   
  93. ------- ---------- ----------- ------------ -------------------
  94. 74      46.00M     SBT_TAPE    00:01:20     2018-06-09:17:37:28
  95.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  96.         Handle: 2tt51g08_1_1   Media: station87-000009

  97.   List of Archived Logs in backup set 74
  98.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  99.   ---- ------- ---------- ------------------- ---------- ---------
  100.   1    80      1340398    2018-06-08:04:39:31 1344895    2018-06-08:04:39:42

  101. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  102. ------- ---- -- ---------- ----------- ------------ -------------------
  103. 75      Full    10.00M     SBT_TAPE    00:00:36     2018-06-09:17:38:09
  104.         BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T173733
  105.         Handle: c-1359978017-20180609-00   Media: station87-000008
  106.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  107.   SPFILE db_unique_name: ORCL
  108.   Control File Included: Ckp SCN: 1408511      Ckp time: 2018-06-09:17:37:33

  109. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  110. ------- ---- -- ---------- ----------- ------------ -------------------
  111. 76      Incr 1  30.50M     SBT_TAPE    00:00:48     2018-06-09:17:43:32
  112.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: 2T_USERS_INCR1
  113.         Handle: 2vt51gck_1_1   Media: station87-000009
  114.   List of Datafiles in backup set 76
  115.   File LV Type Ckp SCN    Ckp Time            Name
  116.   ---- -- ---- ---------- ------------------- ----
  117.   4    1  Incr 1408699    2018-06-09:17:42:44 +DATA/orcl/datafile/users.259.978228669

  118. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  119. ------- ---- -- ---------- ----------- ------------ -------------------
  120. 77      Full    10.00M     SBT_TAPE    00:00:42     2018-06-09:17:44:21
  121.         BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174339
  122.         Handle: c-1359978017-20180609-01   Media: station87-000009
  123.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  124.   SPFILE db_unique_name: ORCL
  125.   Control File Included: Ckp SCN: 1408731      Ckp time: 2018-06-09:17:43:39

  126. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  127. ------- ---- -- ---------- ----------- ------------ -------------------
  128. 78      Incr 1  256.00K    SBT_TAPE    00:00:35     2018-06-09:17:47:05
  129.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: 3T_USERS_INCR1
  130.         Handle: 31t51gjm_1_1   Media: station87-000009
  131.   List of Datafiles in backup set 78
  132.   File LV Type Ckp SCN    Ckp Time            Name
  133.   ---- -- ---- ---------- ------------------- ----
  134.   4    1  Incr 1408937    2018-06-09:17:46:30 +DATA/orcl/datafile/users.259.978228669

  135. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  136. ------- ---- -- ---------- ----------- ------------ -------------------
  137. 79      Full    10.00M     SBT_TAPE    00:00:37     2018-06-09:17:47:52
  138.         BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174715
  139.         Handle: c-1359978017-20180609-02   Media: station87-000009
  140.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  141.   SPFILE db_unique_name: ORCL
  142.   Control File Included: Ckp SCN: 1408966      Ckp time: 2018-06-09:17:47:15

  143. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  144. ------- ---- -- ---------- ----------- ------------ -------------------
  145. 80      Incr 1  30.50M     SBT_TAPE    00:00:47     2018-06-09:17:55:25
  146.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1C
  147.         Handle: 33t51h2u_1_1   Media: station87-000009
  148.   List of Datafiles in backup set 80
  149.   File LV Type Ckp SCN    Ckp Time            Name
  150.   ---- -- ---- ---------- ------------------- ----
  151.   4    1  Incr 1409298    2018-06-09:17:54:38 +DATA/orcl/datafile/users.259.978228669

  152. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  153. ------- ---- -- ---------- ----------- ------------ -------------------
  154. 81      Full    10.00M     SBT_TAPE    00:00:28     2018-06-09:17:56:01
  155.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T175533
  156.         Handle: c-1359978017-20180609-03   Media: station87-000009
  157.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  158.   SPFILE db_unique_name: ORCL
  159.   Control File Included: Ckp SCN: 1409338      Ckp time: 2018-06-09:17:55:33

  160. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  161. ------- ---- -- ---------- ----------- ------------ -------------------
  162. 82      Full    33.70M     DISK        00:00:02     2018-06-09:18:14:10
  163.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181408
  164.         Piece Name: +FRA/orcl/backupset/2018_06_09/nnndf0_tag20180609t181408_0.321.978372849
  165.   List of Datafiles in backup set 82
  166.   File LV Type Ckp SCN    Ckp Time            Name
  167.   ---- -- ---- ---------- ------------------- ----
  168.   4       Full 1410584    2018-06-09:18:14:08 +DATA/orcl/datafile/users.259.978228669

  169. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  170. ------- ---- -- ---------- ----------- ------------ -------------------
  171. 83      Full    9.86M      DISK        00:00:01     2018-06-09:18:14:12
  172.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181411
  173.         Piece Name: +FRA/orcl/autobackup/2018_06_09/s_978372851.322.978372853
  174.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  175.   SPFILE db_unique_name: ORCL
  176.   Control File Included: Ckp SCN: 1410592      Ckp time: 2018-06-09:18:14:11

  177. RMAN> backup backupset 82 force delete input;

  178. Starting backup at 2018-06-09:18:15:15
  179. allocated channel: ORA_SBT_TAPE_1
  180. channel ORA_SBT_TAPE_1: SID=72 device type=SBT_TAPE
  181. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  182. allocated channel: ORA_SBT_TAPE_2
  183. channel ORA_SBT_TAPE_2: SID=197 device type=SBT_TAPE
  184. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  185. channel ORA_SBT_TAPE_1: input backup set: count=101, stamp=978372848, piece=1
  186. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:18:15:26
  187. channel ORA_SBT_TAPE_1: backup piece +FRA/orcl/backupset/2018_06_09/nnndf0_tag20180609t181408_0.321.978372849
  188. piece handle=35t51i7g_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  189. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:18:16:21
  190. channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:00:55
  191. deleted backup piece
  192. backup piece handle=+FRA/orcl/backupset/2018_06_09/nnndf0_tag20180609t181408_0.321.978372849 RECID=88 STAMP=978372848
  193. Finished backup at 2018-06-09:18:16:21

  194. Starting Control File and SPFILE Autobackup at 2018-06-09:18:16:21
  195. piece handle=c-1359978017-20180609-05 comment=API Version 2.0,MMS Version 10.3.0.2
  196. Finished Control File and SPFILE Autobackup at 2018-06-09:18:17:06

  197. RMAN> show all;

  198. RMAN configuration parameters for database with db_unique_name ORCL are:
  199. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  200. CONFIGURE BACKUP OPTIMIZATION ON;
  201. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  202. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  203. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  204. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  205. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  206. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  207. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  208. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  209. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  210. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  211. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
  212. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
  213. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  214. CONFIGURE ENCRYPTION FOR DATABASE OFF;
  215. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  216. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  217. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  218. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  219. RMAN> list backup;


  220. List of Backup Sets
  221. ===================


  222. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  223. ------- ---- -- ---------- ----------- ------------ -------------------
  224. 65      Incr 0  436.25M    SBT_TAPE    00:01:00     2018-06-08:01:08:17
  225.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSAUX_INCR0
  226.         Handle: 2ct4t1m5_1_1   Media: station87-000008
  227.   List of Datafiles in backup set 65
  228.   File LV Type Ckp SCN    Ckp Time            Name
  229.   ---- -- ---- ---------- ------------------- ----
  230.   2    0  Incr 1155660    2018-06-08:01:07:17 +DATA/orcl/datafile/sysaux.257.832197065

  231. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  232. ------- ---- -- ---------- ----------- ------------ -------------------
  233. 66      Full    10.00M     SBT_TAPE    00:00:39     2018-06-08:01:09:01
  234.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T010822
  235.         Handle: c-1359978017-20180608-07   Media: station87-000008
  236.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  237.   SPFILE db_unique_name: ORCL
  238.   Control File Included: Ckp SCN: 1155709      Ckp time: 2018-06-08:01:08:22

  239. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  240. ------- ---- -- ---------- ----------- ------------ -------------------
  241. 67      Incr 0  86.50M     SBT_TAPE    00:00:53     2018-06-08:01:13:00
  242.         BP Key: 73   Status: AVAILABLE  Compressed: YES  Tag: 2TC_SYSAUX_INCR0
  243.         Handle: 2et4t1v7_1_1   Media: station87-000008
  244.   List of Datafiles in backup set 67
  245.   File LV Type Ckp SCN    Ckp Time            Name
  246.   ---- -- ---- ---------- ------------------- ----
  247.   2    0  Incr 1155986    2018-06-08:01:12:07 +DATA/orcl/datafile/sysaux.257.832197065

  248. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  249. ------- ---- -- ---------- ----------- ------------ -------------------
  250. 68      Full    10.00M     SBT_TAPE    00:00:41     2018-06-08:01:13:43
  251.         BP Key: 74   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T011302
  252.         Handle: c-1359978017-20180608-08   Media: station87-000008
  253.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  254.   SPFILE db_unique_name: ORCL
  255.   Control File Included: Ckp SCN: 1156051      Ckp time: 2018-06-08:01:13:02

  256. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  257. ------- ---- -- ---------- ----------- ------------ -------------------
  258. 70      Full    10.00M     SBT_TAPE    00:00:27     2018-06-08:01:42:19
  259.         BP Key: 76   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T014152
  260.         Handle: c-1359978017-20180608-09   Media: station87-000008
  261.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  262.   SPFILE db_unique_name: ORCL
  263.   Control File Included: Ckp SCN: 1157970      Ckp time: 2018-06-08:01:41:52

  264. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  265. ------- ---- -- ---------- ----------- ------------ -------------------
  266. 71      Incr 0  3.50M      SBT_TAPE    00:00:56     2018-06-08:02:04:36
  267.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: 4TEDUAL_USERS_INCR0
  268.         Handle: 2kt4t4vs_1_1   Media: station87-000008
  269.   List of Datafiles in backup set 71
  270.   File LV Type Ckp SCN    Ckp Time            Name
  271.   ---- -- ---- ---------- ------------------- ----
  272.   4    0  Incr 1160195    2018-06-08:02:03:40 +DATA/orcl/datafile/users.259.978228669

  273. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  274. ------- ---- -- ---------- ----------- ------------ -------------------
  275. 72      Full    10.00M     SBT_TAPE    00:00:37     2018-06-08:02:05:22
  276.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T020445
  277.         Handle: c-1359978017-20180608-0a   Media: station87-000008
  278.   SPFILE Included: Modification time: 2018-06-08:02:04:15
  279.   SPFILE db_unique_name: ORCL
  280.   Control File Included: Ckp SCN: 1160247      Ckp time: 2018-06-08:02:04:45

  281. BS Key  Size       Device Type Elapsed Time Completion Time   
  282. ------- ---------- ----------- ------------ -------------------
  283. 73      87.00M     SBT_TAPE    00:01:13     2018-06-09:17:37:21
  284.         BP Key: 79   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  285.         Handle: 2st51g08_1_1   Media: station87-000008

  286.   List of Archived Logs in backup set 73
  287.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  288.   ---- ------- ---------- ------------------- ---------- ---------
  289.   1    78      1323993    2018-06-08:04:33:46 1328678    2018-06-08:04:34:01
  290.   1    79      1328678    2018-06-08:04:34:01 1340398    2018-06-08:04:39:31

  291. BS Key  Size       Device Type Elapsed Time Completion Time   
  292. ------- ---------- ----------- ------------ -------------------
  293. 74      46.00M     SBT_TAPE    00:01:20     2018-06-09:17:37:28
  294.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  295.         Handle: 2tt51g08_1_1   Media: station87-000009

  296.   List of Archived Logs in backup set 74
  297.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  298.   ---- ------- ---------- ------------------- ---------- ---------
  299.   1    80      1340398    2018-06-08:04:39:31 1344895    2018-06-08:04:39:42

  300. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  301. ------- ---- -- ---------- ----------- ------------ -------------------
  302. 75      Full    10.00M     SBT_TAPE    00:00:36     2018-06-09:17:38:09
  303.         BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T173733
  304.         Handle: c-1359978017-20180609-00   Media: station87-000008
  305.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  306.   SPFILE db_unique_name: ORCL
  307.   Control File Included: Ckp SCN: 1408511      Ckp time: 2018-06-09:17:37:33

  308. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  309. ------- ---- -- ---------- ----------- ------------ -------------------
  310. 76      Incr 1  30.50M     SBT_TAPE    00:00:48     2018-06-09:17:43:32
  311.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: 2T_USERS_INCR1
  312.         Handle: 2vt51gck_1_1   Media: station87-000009
  313.   List of Datafiles in backup set 76
  314.   File LV Type Ckp SCN    Ckp Time            Name
  315.   ---- -- ---- ---------- ------------------- ----
  316.   4    1  Incr 1408699    2018-06-09:17:42:44 +DATA/orcl/datafile/users.259.978228669

  317. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  318. ------- ---- -- ---------- ----------- ------------ -------------------
  319. 77      Full    10.00M     SBT_TAPE    00:00:42     2018-06-09:17:44:21
  320.         BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174339
  321.         Handle: c-1359978017-20180609-01   Media: station87-000009
  322.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  323.   SPFILE db_unique_name: ORCL
  324.   Control File Included: Ckp SCN: 1408731      Ckp time: 2018-06-09:17:43:39

  325. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  326. ------- ---- -- ---------- ----------- ------------ -------------------
  327. 78      Incr 1  256.00K    SBT_TAPE    00:00:35     2018-06-09:17:47:05
  328.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: 3T_USERS_INCR1
  329.         Handle: 31t51gjm_1_1   Media: station87-000009
  330.   List of Datafiles in backup set 78
  331.   File LV Type Ckp SCN    Ckp Time            Name
  332.   ---- -- ---- ---------- ------------------- ----
  333.   4    1  Incr 1408937    2018-06-09:17:46:30 +DATA/orcl/datafile/users.259.978228669

  334. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  335. ------- ---- -- ---------- ----------- ------------ -------------------
  336. 79      Full    10.00M     SBT_TAPE    00:00:37     2018-06-09:17:47:52
  337.         BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174715
  338.         Handle: c-1359978017-20180609-02   Media: station87-000009
  339.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  340.   SPFILE db_unique_name: ORCL
  341.   Control File Included: Ckp SCN: 1408966      Ckp time: 2018-06-09:17:47:15

  342. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  343. ------- ---- -- ---------- ----------- ------------ -------------------
  344. 80      Incr 1  30.50M     SBT_TAPE    00:00:47     2018-06-09:17:55:25
  345.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1C
  346.         Handle: 33t51h2u_1_1   Media: station87-000009
  347.   List of Datafiles in backup set 80
  348.   File LV Type Ckp SCN    Ckp Time            Name
  349.   ---- -- ---- ---------- ------------------- ----
  350.   4    1  Incr 1409298    2018-06-09:17:54:38 +DATA/orcl/datafile/users.259.978228669

  351. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  352. ------- ---- -- ---------- ----------- ------------ -------------------
  353. 81      Full    10.00M     SBT_TAPE    00:00:28     2018-06-09:17:56:01
  354.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T175533
  355.         Handle: c-1359978017-20180609-03   Media: station87-000009
  356.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  357.   SPFILE db_unique_name: ORCL
  358.   Control File Included: Ckp SCN: 1409338      Ckp time: 2018-06-09:17:55:33

  359. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  360. ------- ---- -- ---------- ----------- ------------ -------------------
  361. 82      Full    33.70M     SBT_TAPE    00:00:02     2018-06-09:18:14:10
  362.         BP Key: 90   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181408
  363.         Handle: 35t51i7g_1_2   Media: station87-000009
  364.   List of Datafiles in backup set 82
  365.   File LV Type Ckp SCN    Ckp Time            Name
  366.   ---- -- ---- ---------- ------------------- ----
  367.   4       Full 1410584    2018-06-09:18:14:08 +DATA/orcl/datafile/users.259.978228669

  368. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  369. ------- ---- -- ---------- ----------- ------------ -------------------
  370. 83      Full    9.86M      DISK        00:00:01     2018-06-09:18:14:12
  371.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181411
  372.         Piece Name: +FRA/orcl/autobackup/2018_06_09/s_978372851.322.978372853
  373.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  374.   SPFILE db_unique_name: ORCL
  375.   Control File Included: Ckp SCN: 1410592      Ckp time: 2018-06-09:18:14:11

  376. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  377. ------- ---- -- ---------- ----------- ------------ -------------------
  378. 84      Full    10.00M     SBT_TAPE    00:00:38     2018-06-09:18:16:59
  379.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181621
  380.         Handle: c-1359978017-20180609-05   Media: station87-000009
  381.   SPFILE Included: Modification time: 2018-06-09:18:15:20
  382.   SPFILE db_unique_name: ORCL
  383.   Control File Included: Ckp SCN: 1410754      Ckp time: 2018-06-09:18:16:21

  384. RMAN>
复制代码

maxpiecesize开片方式,任何时候都只有一个通道在运行:
  1. ob> lsjob
  2. Job ID           Sched time  Contents                       State
  3. ---------------- ----------- ------------------------------ ---------------------------------------
  4. oracle/69        none        database orcl (dbid=1359978017) processed; Oracle job(s) scheduled
  5. oracle/69.1      none        incremental backup             running since 2018/0
复制代码
section size开片方式,任何时候都有并行度:
  1. ob> lsjob
  2. Job ID           Sched time  Contents                       State
  3. ---------------- ----------- ------------------------------ ---------------------------------------
  4. oracle/70        none        database orcl (dbid=1359978017) processed; Oracle job(s) scheduled
  5. oracle/70.1      none        incremental backup             running since 2018/06/09.18:44
  6. oracle/70.2      none        incremental backup             running since 2018/06/09.18:44
复制代码
  1. RMAN> run {
  2. 2> allocate channel c1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)'  maxpiecesize 200M;
  3. 3> backup tag '5T_SYSTEM_INCR0'  copies 1 incremental level 0  tablespace system;
  4. 4> release channel c1;
  5. 5> }

  6. released channel: ORA_SBT_TAPE_1
  7. released channel: ORA_SBT_TAPE_2
  8. allocated channel: c1
  9. channel c1: SID=72 device type=SBT_TAPE
  10. channel c1: Oracle Secure Backup

  11. Starting backup at 2018-06-09:18:37:49
  12. channel c1: starting incremental level 0 datafile backup set
  13. channel c1: specifying datafile(s) in backup set
  14. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  15. channel c1: starting piece 1 at 2018-06-09:18:37:49
  16. channel c1: finished piece 1 at 2018-06-09:18:38:52
  17. piece handle=38t51jjt_1_1 tag=5T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  18. channel c1: starting piece 2 at 2018-06-09:18:38:52
  19. channel c1: finished piece 2 at 2018-06-09:18:39:37
  20. piece handle=38t51jjt_2_1 tag=5T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  21. channel c1: starting piece 3 at 2018-06-09:18:39:37
  22. channel c1: finished piece 3 at 2018-06-09:18:40:32
  23. piece handle=38t51jjt_3_1 tag=5T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  24. channel c1: backup set complete, elapsed time: 00:02:43
  25. channel c1: starting incremental level 0 datafile backup set
  26. channel c1: specifying datafile(s) in backup set
  27. including current control file in backup set
  28. including current SPFILE in backup set
  29. channel c1: starting piece 1 at 2018-06-09:18:40:33
  30. channel c1: finished piece 1 at 2018-06-09:18:41:18
  31. piece handle=39t51jp0_1_1 tag=5T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  32. channel c1: backup set complete, elapsed time: 00:00:45
  33. Finished backup at 2018-06-09:18:41:18

  34. released channel: c1

  35. RMAN> list backup;


  36. List of Backup Sets
  37. ===================


  38. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  39. ------- ---- -- ---------- ----------- ------------ -------------------
  40. 65      Incr 0  436.25M    SBT_TAPE    00:01:00     2018-06-08:01:08:17
  41.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSAUX_INCR0
  42.         Handle: 2ct4t1m5_1_1   Media: station87-000008
  43.   List of Datafiles in backup set 65
  44.   File LV Type Ckp SCN    Ckp Time            Name
  45.   ---- -- ---- ---------- ------------------- ----
  46.   2    0  Incr 1155660    2018-06-08:01:07:17 +DATA/orcl/datafile/sysaux.257.832197065

  47. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  48. ------- ---- -- ---------- ----------- ------------ -------------------
  49. 66      Full    10.00M     SBT_TAPE    00:00:39     2018-06-08:01:09:01
  50.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T010822
  51.         Handle: c-1359978017-20180608-07   Media: station87-000008
  52.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  53.   SPFILE db_unique_name: ORCL
  54.   Control File Included: Ckp SCN: 1155709      Ckp time: 2018-06-08:01:08:22

  55. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  56. ------- ---- -- ---------- ----------- ------------ -------------------
  57. 67      Incr 0  86.50M     SBT_TAPE    00:00:53     2018-06-08:01:13:00
  58.         BP Key: 73   Status: AVAILABLE  Compressed: YES  Tag: 2TC_SYSAUX_INCR0
  59.         Handle: 2et4t1v7_1_1   Media: station87-000008
  60.   List of Datafiles in backup set 67
  61.   File LV Type Ckp SCN    Ckp Time            Name
  62.   ---- -- ---- ---------- ------------------- ----
  63.   2    0  Incr 1155986    2018-06-08:01:12:07 +DATA/orcl/datafile/sysaux.257.832197065

  64. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  65. ------- ---- -- ---------- ----------- ------------ -------------------
  66. 68      Full    10.00M     SBT_TAPE    00:00:41     2018-06-08:01:13:43
  67.         BP Key: 74   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T011302
  68.         Handle: c-1359978017-20180608-08   Media: station87-000008
  69.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  70.   SPFILE db_unique_name: ORCL
  71.   Control File Included: Ckp SCN: 1156051      Ckp time: 2018-06-08:01:13:02

  72. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  73. ------- ---- -- ---------- ----------- ------------ -------------------
  74. 70      Full    10.00M     SBT_TAPE    00:00:27     2018-06-08:01:42:19
  75.         BP Key: 76   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T014152
  76.         Handle: c-1359978017-20180608-09   Media: station87-000008
  77.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  78.   SPFILE db_unique_name: ORCL
  79.   Control File Included: Ckp SCN: 1157970      Ckp time: 2018-06-08:01:41:52

  80. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  81. ------- ---- -- ---------- ----------- ------------ -------------------
  82. 71      Incr 0  3.50M      SBT_TAPE    00:00:56     2018-06-08:02:04:36
  83.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: 4TEDUAL_USERS_INCR0
  84.         Handle: 2kt4t4vs_1_1   Media: station87-000008
  85.   List of Datafiles in backup set 71
  86.   File LV Type Ckp SCN    Ckp Time            Name
  87.   ---- -- ---- ---------- ------------------- ----
  88.   4    0  Incr 1160195    2018-06-08:02:03:40 +DATA/orcl/datafile/users.259.978228669

  89. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  90. ------- ---- -- ---------- ----------- ------------ -------------------
  91. 72      Full    10.00M     SBT_TAPE    00:00:37     2018-06-08:02:05:22
  92.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T020445
  93.         Handle: c-1359978017-20180608-0a   Media: station87-000008
  94.   SPFILE Included: Modification time: 2018-06-08:02:04:15
  95.   SPFILE db_unique_name: ORCL
  96.   Control File Included: Ckp SCN: 1160247      Ckp time: 2018-06-08:02:04:45

  97. BS Key  Size       Device Type Elapsed Time Completion Time   
  98. ------- ---------- ----------- ------------ -------------------
  99. 73      87.00M     SBT_TAPE    00:01:13     2018-06-09:17:37:21
  100.         BP Key: 79   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  101.         Handle: 2st51g08_1_1   Media: station87-000008

  102.   List of Archived Logs in backup set 73
  103.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  104.   ---- ------- ---------- ------------------- ---------- ---------
  105.   1    78      1323993    2018-06-08:04:33:46 1328678    2018-06-08:04:34:01
  106.   1    79      1328678    2018-06-08:04:34:01 1340398    2018-06-08:04:39:31

  107. BS Key  Size       Device Type Elapsed Time Completion Time   
  108. ------- ---------- ----------- ------------ -------------------
  109. 74      46.00M     SBT_TAPE    00:01:20     2018-06-09:17:37:28
  110.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  111.         Handle: 2tt51g08_1_1   Media: station87-000009

  112.   List of Archived Logs in backup set 74
  113.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  114.   ---- ------- ---------- ------------------- ---------- ---------
  115.   1    80      1340398    2018-06-08:04:39:31 1344895    2018-06-08:04:39:42

  116. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  117. ------- ---- -- ---------- ----------- ------------ -------------------
  118. 75      Full    10.00M     SBT_TAPE    00:00:36     2018-06-09:17:38:09
  119.         BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T173733
  120.         Handle: c-1359978017-20180609-00   Media: station87-000008
  121.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  122.   SPFILE db_unique_name: ORCL
  123.   Control File Included: Ckp SCN: 1408511      Ckp time: 2018-06-09:17:37:33

  124. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  125. ------- ---- -- ---------- ----------- ------------ -------------------
  126. 76      Incr 1  30.50M     SBT_TAPE    00:00:48     2018-06-09:17:43:32
  127.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: 2T_USERS_INCR1
  128.         Handle: 2vt51gck_1_1   Media: station87-000009
  129.   List of Datafiles in backup set 76
  130.   File LV Type Ckp SCN    Ckp Time            Name
  131.   ---- -- ---- ---------- ------------------- ----
  132.   4    1  Incr 1408699    2018-06-09:17:42:44 +DATA/orcl/datafile/users.259.978228669

  133. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  134. ------- ---- -- ---------- ----------- ------------ -------------------
  135. 77      Full    10.00M     SBT_TAPE    00:00:42     2018-06-09:17:44:21
  136.         BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174339
  137.         Handle: c-1359978017-20180609-01   Media: station87-000009
  138.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  139.   SPFILE db_unique_name: ORCL
  140.   Control File Included: Ckp SCN: 1408731      Ckp time: 2018-06-09:17:43:39

  141. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  142. ------- ---- -- ---------- ----------- ------------ -------------------
  143. 78      Incr 1  256.00K    SBT_TAPE    00:00:35     2018-06-09:17:47:05
  144.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: 3T_USERS_INCR1
  145.         Handle: 31t51gjm_1_1   Media: station87-000009
  146.   List of Datafiles in backup set 78
  147.   File LV Type Ckp SCN    Ckp Time            Name
  148.   ---- -- ---- ---------- ------------------- ----
  149.   4    1  Incr 1408937    2018-06-09:17:46:30 +DATA/orcl/datafile/users.259.978228669

  150. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  151. ------- ---- -- ---------- ----------- ------------ -------------------
  152. 79      Full    10.00M     SBT_TAPE    00:00:37     2018-06-09:17:47:52
  153.         BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174715
  154.         Handle: c-1359978017-20180609-02   Media: station87-000009
  155.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  156.   SPFILE db_unique_name: ORCL
  157.   Control File Included: Ckp SCN: 1408966      Ckp time: 2018-06-09:17:47:15

  158. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  159. ------- ---- -- ---------- ----------- ------------ -------------------
  160. 80      Incr 1  30.50M     SBT_TAPE    00:00:47     2018-06-09:17:55:25
  161.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1C
  162.         Handle: 33t51h2u_1_1   Media: station87-000009
  163.   List of Datafiles in backup set 80
  164.   File LV Type Ckp SCN    Ckp Time            Name
  165.   ---- -- ---- ---------- ------------------- ----
  166.   4    1  Incr 1409298    2018-06-09:17:54:38 +DATA/orcl/datafile/users.259.978228669

  167. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  168. ------- ---- -- ---------- ----------- ------------ -------------------
  169. 81      Full    10.00M     SBT_TAPE    00:00:28     2018-06-09:17:56:01
  170.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T175533
  171.         Handle: c-1359978017-20180609-03   Media: station87-000009
  172.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  173.   SPFILE db_unique_name: ORCL
  174.   Control File Included: Ckp SCN: 1409338      Ckp time: 2018-06-09:17:55:33

  175. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  176. ------- ---- -- ---------- ----------- ------------ -------------------
  177. 82      Full    33.70M     SBT_TAPE    00:00:02     2018-06-09:18:14:10
  178.         BP Key: 90   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181408
  179.         Handle: 35t51i7g_1_2   Media: station87-000009
  180.   List of Datafiles in backup set 82
  181.   File LV Type Ckp SCN    Ckp Time            Name
  182.   ---- -- ---- ---------- ------------------- ----
  183.   4       Full 1410584    2018-06-09:18:14:08 +DATA/orcl/datafile/users.259.978228669

  184. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  185. ------- ---- -- ---------- ----------- ------------ -------------------
  186. 83      Full    9.86M      DISK        00:00:01     2018-06-09:18:14:12
  187.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181411
  188.         Piece Name: +FRA/orcl/autobackup/2018_06_09/s_978372851.322.978372853
  189.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  190.   SPFILE db_unique_name: ORCL
  191.   Control File Included: Ckp SCN: 1410592      Ckp time: 2018-06-09:18:14:11

  192. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  193. ------- ---- -- ---------- ----------- ------------ -------------------
  194. 84      Full    10.00M     SBT_TAPE    00:00:38     2018-06-09:18:16:59
  195.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181621
  196.         Handle: c-1359978017-20180609-05   Media: station87-000009
  197.   SPFILE Included: Modification time: 2018-06-09:18:15:20
  198.   SPFILE db_unique_name: ORCL
  199.   Control File Included: Ckp SCN: 1410754      Ckp time: 2018-06-09:18:16:21

  200. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  201. ------- ---- -- ---------- ----------- ------------ -------------------
  202. 85      Incr 0  597.50M    SBT_TAPE    00:02:39     2018-06-09:18:40:28
  203.   List of Datafiles in backup set 85
  204.   File LV Type Ckp SCN    Ckp Time            Name
  205.   ---- -- ---- ---------- ------------------- ----
  206.   1    0  Incr 1411610    2018-06-09:18:37:49 +DATA/orcl/datafile/system.256.832197063

  207.   Backup Set Copy #1 of backup set 85
  208.   Device Type Elapsed Time Completion Time     Compressed Tag
  209.   ----------- ------------ ------------------- ---------- ---
  210.   SBT_TAPE    00:02:39     2018-06-09:18:40:28 NO         5T_SYSTEM_INCR0

  211.     List of Backup Pieces for backup set 85 Copy #1
  212.     BP Key  Pc# Status      Media                   Piece Name
  213.     ------- --- ----------- ----------------------- ----------
  214.     92      1   AVAILABLE   station87-000009        38t51jjt_1_1
  215.     93      2   AVAILABLE   station87-000009        38t51jjt_2_1
  216.     94      3   AVAILABLE   station87-000009        38t51jjt_3_1

  217. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  218. ------- ---- -- ---------- ----------- ------------ -------------------
  219. 86      Incr 0  10.00M     SBT_TAPE    00:00:42     2018-06-09:18:41:14
  220.         BP Key: 95   Status: AVAILABLE  Compressed: NO  Tag: 5T_SYSTEM_INCR0
  221.         Handle: 39t51jp0_1_1   Media: station87-000009
  222.   SPFILE Included: Modification time: 2018-06-09:18:38:42
  223.   SPFILE db_unique_name: ORCL
  224.   Control File Included: Ckp SCN: 1411697      Ckp time: 2018-06-09:18:40:32

  225. RMAN> backup   section size 200M tag '6T_SYSTEM_INCR0'  copies 1 incremental level 0  tablespace system;

  226. Starting backup at 2018-06-09:18:43:54
  227. allocated channel: ORA_SBT_TAPE_1
  228. channel ORA_SBT_TAPE_1: SID=72 device type=SBT_TAPE
  229. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  230. allocated channel: ORA_SBT_TAPE_2
  231. channel ORA_SBT_TAPE_2: SID=197 device type=SBT_TAPE
  232. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  233. RMAN-00571: ===========================================================
  234. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  235. RMAN-00571: ===========================================================
  236. RMAN-03002: failure of backup command at 06/09/2018 18:44:06
  237. RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect

  238. RMAN> exit


  239. Recovery Manager complete.
  240. [oracle@station87 ~]$ rman target /

  241. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 9 18:44:17 2018

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

  243. connected to target database: ORCL (DBID=1359978017)

  244. RMAN> backup   section size 200M tag '6T_SYSTEM_INCR0'  copies 1 incremental level 0  tablespace system;

  245. Starting backup at 2018-06-09:18:44:19
  246. using target database control file instead of recovery catalog
  247. allocated channel: ORA_SBT_TAPE_1
  248. channel ORA_SBT_TAPE_1: SID=70 device type=SBT_TAPE
  249. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  250. allocated channel: ORA_SBT_TAPE_2
  251. channel ORA_SBT_TAPE_2: SID=197 device type=SBT_TAPE
  252. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  253. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  254. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  255. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  256. backing up blocks 1 through 25600
  257. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:18:44:30
  258. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  259. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  260. including current control file in backup set
  261. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-06-09:18:44:31
  262. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:18:45:36
  263. piece handle=3at51k0e_1_1 tag=6T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  264. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:06
  265. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  266. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  267. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  268. backing up blocks 25601 through 51200
  269. channel ORA_SBT_TAPE_1: starting piece 2 at 2018-06-09:18:45:37
  270. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-06-09:18:45:37
  271. piece handle=3bt51k0e_1_1 tag=6T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  272. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:06
  273. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  274. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  275. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  276. backing up blocks 51201 through 76800
  277. channel ORA_SBT_TAPE_2: starting piece 3 at 2018-06-09:18:45:37
  278. channel ORA_SBT_TAPE_1: finished piece 2 at 2018-06-09:18:46:32
  279. piece handle=3at51k0e_2_1 tag=6T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  280. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:55
  281. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  282. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  283. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  284. backing up blocks 76801 through 88320
  285. channel ORA_SBT_TAPE_1: starting piece 4 at 2018-06-09:18:46:32
  286. channel ORA_SBT_TAPE_2: finished piece 3 at 2018-06-09:18:46:35
  287. piece handle=3at51k0e_3_1 tag=6T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  288. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:58
  289. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  290. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  291. including current SPFILE in backup set
  292. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-06-09:18:46:36
  293. channel ORA_SBT_TAPE_1: finished piece 4 at 2018-06-09:18:47:21
  294. piece handle=3at51k0e_4_1 tag=6T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  295. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:49
  296. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-06-09:18:47:31
  297. piece handle=3ft51k4c_1_1 tag=6T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  298. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:55
  299. Finished backup at 2018-06-09:18:47:31

  300. RMAN> list backup;


  301. List of Backup Sets
  302. ===================


  303. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  304. ------- ---- -- ---------- ----------- ------------ -------------------
  305. 65      Incr 0  436.25M    SBT_TAPE    00:01:00     2018-06-08:01:08:17
  306.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSAUX_INCR0
  307.         Handle: 2ct4t1m5_1_1   Media: station87-000008
  308.   List of Datafiles in backup set 65
  309.   File LV Type Ckp SCN    Ckp Time            Name
  310.   ---- -- ---- ---------- ------------------- ----
  311.   2    0  Incr 1155660    2018-06-08:01:07:17 +DATA/orcl/datafile/sysaux.257.832197065

  312. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  313. ------- ---- -- ---------- ----------- ------------ -------------------
  314. 66      Full    10.00M     SBT_TAPE    00:00:39     2018-06-08:01:09:01
  315.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T010822
  316.         Handle: c-1359978017-20180608-07   Media: station87-000008
  317.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  318.   SPFILE db_unique_name: ORCL
  319.   Control File Included: Ckp SCN: 1155709      Ckp time: 2018-06-08:01:08:22

  320. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  321. ------- ---- -- ---------- ----------- ------------ -------------------
  322. 67      Incr 0  86.50M     SBT_TAPE    00:00:53     2018-06-08:01:13:00
  323.         BP Key: 73   Status: AVAILABLE  Compressed: YES  Tag: 2TC_SYSAUX_INCR0
  324.         Handle: 2et4t1v7_1_1   Media: station87-000008
  325.   List of Datafiles in backup set 67
  326.   File LV Type Ckp SCN    Ckp Time            Name
  327.   ---- -- ---- ---------- ------------------- ----
  328.   2    0  Incr 1155986    2018-06-08:01:12:07 +DATA/orcl/datafile/sysaux.257.832197065

  329. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  330. ------- ---- -- ---------- ----------- ------------ -------------------
  331. 68      Full    10.00M     SBT_TAPE    00:00:41     2018-06-08:01:13:43
  332.         BP Key: 74   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T011302
  333.         Handle: c-1359978017-20180608-08   Media: station87-000008
  334.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  335.   SPFILE db_unique_name: ORCL
  336.   Control File Included: Ckp SCN: 1156051      Ckp time: 2018-06-08:01:13:02

  337. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  338. ------- ---- -- ---------- ----------- ------------ -------------------
  339. 70      Full    10.00M     SBT_TAPE    00:00:27     2018-06-08:01:42:19
  340.         BP Key: 76   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T014152
  341.         Handle: c-1359978017-20180608-09   Media: station87-000008
  342.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  343.   SPFILE db_unique_name: ORCL
  344.   Control File Included: Ckp SCN: 1157970      Ckp time: 2018-06-08:01:41:52

  345. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  346. ------- ---- -- ---------- ----------- ------------ -------------------
  347. 71      Incr 0  3.50M      SBT_TAPE    00:00:56     2018-06-08:02:04:36
  348.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: 4TEDUAL_USERS_INCR0
  349.         Handle: 2kt4t4vs_1_1   Media: station87-000008
  350.   List of Datafiles in backup set 71
  351.   File LV Type Ckp SCN    Ckp Time            Name
  352.   ---- -- ---- ---------- ------------------- ----
  353.   4    0  Incr 1160195    2018-06-08:02:03:40 +DATA/orcl/datafile/users.259.978228669

  354. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  355. ------- ---- -- ---------- ----------- ------------ -------------------
  356. 72      Full    10.00M     SBT_TAPE    00:00:37     2018-06-08:02:05:22
  357.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T020445
  358.         Handle: c-1359978017-20180608-0a   Media: station87-000008
  359.   SPFILE Included: Modification time: 2018-06-08:02:04:15
  360.   SPFILE db_unique_name: ORCL
  361.   Control File Included: Ckp SCN: 1160247      Ckp time: 2018-06-08:02:04:45

  362. BS Key  Size       Device Type Elapsed Time Completion Time   
  363. ------- ---------- ----------- ------------ -------------------
  364. 73      87.00M     SBT_TAPE    00:01:13     2018-06-09:17:37:21
  365.         BP Key: 79   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  366.         Handle: 2st51g08_1_1   Media: station87-000008

  367.   List of Archived Logs in backup set 73
  368.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  369.   ---- ------- ---------- ------------------- ---------- ---------
  370.   1    78      1323993    2018-06-08:04:33:46 1328678    2018-06-08:04:34:01
  371.   1    79      1328678    2018-06-08:04:34:01 1340398    2018-06-08:04:39:31

  372. BS Key  Size       Device Type Elapsed Time Completion Time   
  373. ------- ---------- ----------- ------------ -------------------
  374. 74      46.00M     SBT_TAPE    00:01:20     2018-06-09:17:37:28
  375.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  376.         Handle: 2tt51g08_1_1   Media: station87-000009

  377.   List of Archived Logs in backup set 74
  378.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  379.   ---- ------- ---------- ------------------- ---------- ---------
  380.   1    80      1340398    2018-06-08:04:39:31 1344895    2018-06-08:04:39:42

  381. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  382. ------- ---- -- ---------- ----------- ------------ -------------------
  383. 75      Full    10.00M     SBT_TAPE    00:00:36     2018-06-09:17:38:09
  384.         BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T173733
  385.         Handle: c-1359978017-20180609-00   Media: station87-000008
  386.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  387.   SPFILE db_unique_name: ORCL
  388.   Control File Included: Ckp SCN: 1408511      Ckp time: 2018-06-09:17:37:33

  389. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  390. ------- ---- -- ---------- ----------- ------------ -------------------
  391. 76      Incr 1  30.50M     SBT_TAPE    00:00:48     2018-06-09:17:43:32
  392.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: 2T_USERS_INCR1
  393.         Handle: 2vt51gck_1_1   Media: station87-000009
  394.   List of Datafiles in backup set 76
  395.   File LV Type Ckp SCN    Ckp Time            Name
  396.   ---- -- ---- ---------- ------------------- ----
  397.   4    1  Incr 1408699    2018-06-09:17:42:44 +DATA/orcl/datafile/users.259.978228669

  398. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  399. ------- ---- -- ---------- ----------- ------------ -------------------
  400. 77      Full    10.00M     SBT_TAPE    00:00:42     2018-06-09:17:44:21
  401.         BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174339
  402.         Handle: c-1359978017-20180609-01   Media: station87-000009
  403.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  404.   SPFILE db_unique_name: ORCL
  405.   Control File Included: Ckp SCN: 1408731      Ckp time: 2018-06-09:17:43:39

  406. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  407. ------- ---- -- ---------- ----------- ------------ -------------------
  408. 78      Incr 1  256.00K    SBT_TAPE    00:00:35     2018-06-09:17:47:05
  409.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: 3T_USERS_INCR1
  410.         Handle: 31t51gjm_1_1   Media: station87-000009
  411.   List of Datafiles in backup set 78
  412.   File LV Type Ckp SCN    Ckp Time            Name
  413.   ---- -- ---- ---------- ------------------- ----
  414.   4    1  Incr 1408937    2018-06-09:17:46:30 +DATA/orcl/datafile/users.259.978228669

  415. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  416. ------- ---- -- ---------- ----------- ------------ -------------------
  417. 79      Full    10.00M     SBT_TAPE    00:00:37     2018-06-09:17:47:52
  418.         BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174715
  419.         Handle: c-1359978017-20180609-02   Media: station87-000009
  420.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  421.   SPFILE db_unique_name: ORCL
  422.   Control File Included: Ckp SCN: 1408966      Ckp time: 2018-06-09:17:47:15

  423. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  424. ------- ---- -- ---------- ----------- ------------ -------------------
  425. 80      Incr 1  30.50M     SBT_TAPE    00:00:47     2018-06-09:17:55:25
  426.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1C
  427.         Handle: 33t51h2u_1_1   Media: station87-000009
  428.   List of Datafiles in backup set 80
  429.   File LV Type Ckp SCN    Ckp Time            Name
  430.   ---- -- ---- ---------- ------------------- ----
  431.   4    1  Incr 1409298    2018-06-09:17:54:38 +DATA/orcl/datafile/users.259.978228669

  432. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  433. ------- ---- -- ---------- ----------- ------------ -------------------
  434. 81      Full    10.00M     SBT_TAPE    00:00:28     2018-06-09:17:56:01
  435.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T175533
  436.         Handle: c-1359978017-20180609-03   Media: station87-000009
  437.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  438.   SPFILE db_unique_name: ORCL
  439.   Control File Included: Ckp SCN: 1409338      Ckp time: 2018-06-09:17:55:33

  440. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  441. ------- ---- -- ---------- ----------- ------------ -------------------
  442. 82      Full    33.70M     SBT_TAPE    00:00:02     2018-06-09:18:14:10
  443.         BP Key: 90   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181408
  444.         Handle: 35t51i7g_1_2   Media: station87-000009
  445.   List of Datafiles in backup set 82
  446.   File LV Type Ckp SCN    Ckp Time            Name
  447.   ---- -- ---- ---------- ------------------- ----
  448.   4       Full 1410584    2018-06-09:18:14:08 +DATA/orcl/datafile/users.259.978228669

  449. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  450. ------- ---- -- ---------- ----------- ------------ -------------------
  451. 83      Full    9.86M      DISK        00:00:01     2018-06-09:18:14:12
  452.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181411
  453.         Piece Name: +FRA/orcl/autobackup/2018_06_09/s_978372851.322.978372853
  454.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  455.   SPFILE db_unique_name: ORCL
  456.   Control File Included: Ckp SCN: 1410592      Ckp time: 2018-06-09:18:14:11

  457. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  458. ------- ---- -- ---------- ----------- ------------ -------------------
  459. 84      Full    10.00M     SBT_TAPE    00:00:38     2018-06-09:18:16:59
  460.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181621
  461.         Handle: c-1359978017-20180609-05   Media: station87-000009
  462.   SPFILE Included: Modification time: 2018-06-09:18:15:20
  463.   SPFILE db_unique_name: ORCL
  464.   Control File Included: Ckp SCN: 1410754      Ckp time: 2018-06-09:18:16:21

  465. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  466. ------- ---- -- ---------- ----------- ------------ -------------------
  467. 85      Incr 0  597.50M    SBT_TAPE    00:02:39     2018-06-09:18:40:28
  468.   List of Datafiles in backup set 85
  469.   File LV Type Ckp SCN    Ckp Time            Name
  470.   ---- -- ---- ---------- ------------------- ----
  471.   1    0  Incr 1411610    2018-06-09:18:37:49 +DATA/orcl/datafile/system.256.832197063

  472.   Backup Set Copy #1 of backup set 85
  473.   Device Type Elapsed Time Completion Time     Compressed Tag
  474.   ----------- ------------ ------------------- ---------- ---
  475.   SBT_TAPE    00:02:39     2018-06-09:18:40:28 NO         5T_SYSTEM_INCR0

  476.     List of Backup Pieces for backup set 85 Copy #1
  477.     BP Key  Pc# Status      Media                   Piece Name
  478.     ------- --- ----------- ----------------------- ----------
  479.     92      1   AVAILABLE   station87-000009        38t51jjt_1_1
  480.     93      2   AVAILABLE   station87-000009        38t51jjt_2_1
  481.     94      3   AVAILABLE   station87-000009        38t51jjt_3_1

  482. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  483. ------- ---- -- ---------- ----------- ------------ -------------------
  484. 86      Incr 0  10.00M     SBT_TAPE    00:00:42     2018-06-09:18:41:14
  485.         BP Key: 95   Status: AVAILABLE  Compressed: NO  Tag: 5T_SYSTEM_INCR0
  486.         Handle: 39t51jp0_1_1   Media: station87-000009
  487.   SPFILE Included: Modification time: 2018-06-09:18:38:42
  488.   SPFILE db_unique_name: ORCL
  489.   Control File Included: Ckp SCN: 1411697      Ckp time: 2018-06-09:18:40:32

  490. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  491. ------- ---- -- ---------- ----------- ------------ -------------------
  492. 87      Incr 0  597.75M    SBT_TAPE    00:02:44     2018-06-09:18:47:14
  493.   List of Datafiles in backup set 87
  494.   File LV Type Ckp SCN    Ckp Time            Name
  495.   ---- -- ---- ---------- ------------------- ----
  496.   1    0  Incr 1411863    2018-06-09:18:44:30 +DATA/orcl/datafile/system.256.832197063

  497.   Backup Set Copy #1 of backup set 87
  498.   Device Type Elapsed Time Completion Time     Compressed Tag
  499.   ----------- ------------ ------------------- ---------- ---
  500.   SBT_TAPE    00:02:44     2018-06-09:18:47:14 NO         6T_SYSTEM_INCR0

  501.     List of Backup Pieces for backup set 87 Copy #1
  502.     BP Key  Pc# Status      Media                   Piece Name
  503.     ------- --- ----------- ----------------------- ----------
  504.     96      1   AVAILABLE   station87-000009        3at51k0e_1_1
  505.     98      2   AVAILABLE   station87-000009        3at51k0e_2_1
  506.     99      3   AVAILABLE   station87-000008        3at51k0e_3_1
  507.     100     4   AVAILABLE   station87-000009        3at51k0e_4_1

  508. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  509. ------- ---- -- ---------- ----------- ------------ -------------------
  510. 88      Incr 0  10.00M     SBT_TAPE    00:01:04     2018-06-09:18:45:34
  511.         BP Key: 97   Status: AVAILABLE  Compressed: NO  Tag: 6T_SYSTEM_INCR0
  512.         Handle: 3bt51k0e_1_1   Media: station87-000008
  513.   Control File Included: Ckp SCN: 1411864      Ckp time: 2018-06-09:18:44:30

  514. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  515. ------- ---- -- ---------- ----------- ------------ -------------------
  516. 89      Incr 0  256.00K    SBT_TAPE    00:00:49     2018-06-09:18:47:25
  517.         BP Key: 101   Status: AVAILABLE  Compressed: NO  Tag: 6T_SYSTEM_INCR0
  518.         Handle: 3ft51k4c_1_1   Media: station87-000008
  519.   SPFILE Included: Modification time: 2018-06-09:18:44:01
  520.   SPFILE db_unique_name: ORCL

  521. RMAN> list backup of tablespace system ;


  522. List of Backup Sets
  523. ===================


  524. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  525. ------- ---- -- ---------- ----------- ------------ -------------------
  526. 85      Incr 0  597.50M    SBT_TAPE    00:02:39     2018-06-09:18:40:28
  527.   List of Datafiles in backup set 85
  528.   File LV Type Ckp SCN    Ckp Time            Name
  529.   ---- -- ---- ---------- ------------------- ----
  530.   1    0  Incr 1411610    2018-06-09:18:37:49 +DATA/orcl/datafile/system.256.832197063

  531.   Backup Set Copy #1 of backup set 85
  532.   Device Type Elapsed Time Completion Time     Compressed Tag
  533.   ----------- ------------ ------------------- ---------- ---
  534.   SBT_TAPE    00:02:39     2018-06-09:18:40:28 NO         5T_SYSTEM_INCR0

  535.     List of Backup Pieces for backup set 85 Copy #1
  536.     BP Key  Pc# Status      Media                   Piece Name
  537.     ------- --- ----------- ----------------------- ----------
  538.     92      1   AVAILABLE   station87-000009        38t51jjt_1_1
  539.     93      2   AVAILABLE   station87-000009        38t51jjt_2_1
  540.     94      3   AVAILABLE   station87-000009        38t51jjt_3_1

  541. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  542. ------- ---- -- ---------- ----------- ------------ -------------------
  543. 87      Incr 0  597.75M    SBT_TAPE    00:02:44     2018-06-09:18:47:14
  544.   List of Datafiles in backup set 87
  545.   File LV Type Ckp SCN    Ckp Time            Name
  546.   ---- -- ---- ---------- ------------------- ----
  547.   1    0  Incr 1411863    2018-06-09:18:44:30 +DATA/orcl/datafile/system.256.832197063

  548.   Backup Set Copy #1 of backup set 87
  549.   Device Type Elapsed Time Completion Time     Compressed Tag
  550.   ----------- ------------ ------------------- ---------- ---
  551.   SBT_TAPE    00:02:44     2018-06-09:18:47:14 NO         6T_SYSTEM_INCR0

  552.     List of Backup Pieces for backup set 87 Copy #1
  553.     BP Key  Pc# Status      Media                   Piece Name
  554.     ------- --- ----------- ----------------------- ----------
  555.     96      1   AVAILABLE   station87-000009        3at51k0e_1_1
  556.     98      2   AVAILABLE   station87-000009        3at51k0e_2_1
  557.     99      3   AVAILABLE   station87-000008        3at51k0e_3_1
  558.     100     4   AVAILABLE   station87-000009        3at51k0e_4_1

  559. RMAN>
复制代码

归档性备份:
  1. RMAN> backup tag '7T_WHOLE_INCR0' incremental level 0 database keep until time 'sysdate+60' restore point rsp1;

  2. Starting backup at 2018-06-09:18:58:58
  3. current log archived

  4. using channel ORA_SBT_TAPE_1
  5. using channel ORA_SBT_TAPE_2
  6. backup will be obsolete on date 2018-08-08:18:58:59
  7. archived logs required to recover from this backup will be backed up
  8. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  9. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  10. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  11. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.978228669
  12. input datafile file number=00006 name=+DATA/orcl/datafile/tbsfda.267.978234227
  13. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.832197065
  14. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:18:58:59
  15. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  16. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  17. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.832197065
  18. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.832197353
  19. input datafile file number=00007 name=+DATA/orcl/datafile/tbsfda.268.978236837
  20. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-06-09:18:59:00
  21. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:19:00:55
  22. piece handle=3gt51krj_1_1 tag=7T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  23. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:56
  24. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-06-09:19:01:05
  25. piece handle=3ht51krj_1_1 tag=7T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  26. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:02:05

  27. using channel ORA_SBT_TAPE_1
  28. using channel ORA_SBT_TAPE_2
  29. backup will be obsolete on date 2018-08-08:19:01:05
  30. archived logs required to recover from this backup will be backed up
  31. channel ORA_SBT_TAPE_1: starting full datafile backup set
  32. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  33. including current SPFILE in backup set
  34. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:19:01:05
  35. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:19:01:40
  36. piece handle=3it51kvh_1_1 tag=7T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  37. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35


  38. current log archived
  39. using channel ORA_SBT_TAPE_1
  40. using channel ORA_SBT_TAPE_2
  41. backup will be obsolete on date 2018-08-08:19:01:41
  42. archived logs required to recover from this backup will be backed up
  43. channel ORA_SBT_TAPE_1: starting archived log backup set
  44. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  45. input archived log thread=1 sequence=86 RECID=82 STAMP=978375701
  46. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:19:01:41
  47. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:19:02:26
  48. piece handle=3jt51l0l_1_1 tag=7T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  49. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45

  50. using channel ORA_SBT_TAPE_1
  51. using channel ORA_SBT_TAPE_2
  52. backup will be obsolete on date 2018-08-08:19:02:26
  53. archived logs required to recover from this backup will be backed up
  54. channel ORA_SBT_TAPE_1: starting full datafile backup set
  55. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  56. including current control file in backup set
  57. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:19:02:28
  58. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:19:03:03
  59. piece handle=3kt51l23_1_1 tag=7T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  60. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
  61. Finished backup at 2018-06-09:19:03:03

  62. RMAN>
复制代码

rsp1.png


  1. RMAN> backup tag '7T_WHOLE_INCR0' incremental level 0 database keep forever  restore point rsp2;

  2. Starting backup at 2018-06-09:19:05:07
  3. current log archived

  4. using channel ORA_SBT_TAPE_1
  5. using channel ORA_SBT_TAPE_2
  6. RMAN-00571: ===========================================================
  7. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  8. RMAN-00571: ===========================================================
  9. RMAN-03002: failure of backup command at 06/09/2018 19:05:07
  10. RMAN-06522: KEEP FOREVER option is not supported without the recovery catalog
复制代码

如果要forever就需要连接recovery catalog:
  1. RMAN> backup tag '7T_WHOLE_INCR0' incremental level 0 database keep forever  restore point rsp2;

  2. Starting backup at 2018-06-09:19:06:01
  3. starting full resync of recovery catalog
  4. full resync complete
  5. current log archived

  6. allocated channel: ORA_SBT_TAPE_1
  7. channel ORA_SBT_TAPE_1: SID=70 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=200 device type=SBT_TAPE
  11. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  12. backup will never be obsolete
  13. archived logs required to recover from this backup will be backed up
  14. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  15. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  16. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  17. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.978228669
  18. input datafile file number=00006 name=+DATA/orcl/datafile/tbsfda.267.978234227
  19. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.832197065
  20. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:19:06:21
  21. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  22. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  23. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.832197065
  24. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.832197353
  25. input datafile file number=00007 name=+DATA/orcl/datafile/tbsfda.268.978236837
  26. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-06-09:19:06:21
复制代码

rsp2.png

注意以下的KEEP标签:
  1. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2. ------- ---- -- ---------- ----------- ------------ -------------------
  3. 1468    Incr 0  654.00M    SBT_TAPE    00:01:55     2018-06-09:19:00:54
  4.         BP Key: 1502   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  5.         Handle: 3gt51krj_1_1   Media: station87-000009
  6.         Keep: BACKUP_LOGS        Until: 2018-08-08:18:58:59
  7.   List of Datafiles in backup set 1468
  8.   File LV Type Ckp SCN    Ckp Time            Name
  9.   ---- -- ---- ---------- ------------------- ----
  10.   1    0  Incr 1412529    2018-06-09:18:59:00 +DATA/orcl/datafile/system.256.832197063
  11.   3    0  Incr 1412529    2018-06-09:18:59:00 +DATA/orcl/datafile/undotbs1.258.832197065
  12.   4    0  Incr 1412529    2018-06-09:18:59:00 +DATA/orcl/datafile/users.259.978228669
  13.   6    0  Incr 1412529    2018-06-09:18:59:00 +DATA/orcl/datafile/tbsfda.267.978234227

  14. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  15. ------- ---- -- ---------- ----------- ------------ -------------------
  16. 1469    Incr 0  567.75M    SBT_TAPE    00:01:58     2018-06-09:19:00:57
  17.         BP Key: 1503   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  18.         Handle: 3ht51krj_1_1   Media: station87-000008
  19.         Keep: BACKUP_LOGS        Until: 2018-08-08:18:58:59
  20.   List of Datafiles in backup set 1469
  21.   File LV Type Ckp SCN    Ckp Time            Name
  22.   ---- -- ---- ---------- ------------------- ----
  23.   2    0  Incr 1412533    2018-06-09:18:59:00 +DATA/orcl/datafile/sysaux.257.832197065
  24.   5    0  Incr 1412533    2018-06-09:18:59:00 +DATA/orcl/datafile/example.265.832197353
  25.   7    0  Incr 1412533    2018-06-09:18:59:00 +DATA/orcl/datafile/tbsfda.268.978236837

  26. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  27. ------- ---- -- ---------- ----------- ------------ -------------------
  28. 1470    Full    256.00K    SBT_TAPE    00:00:28     2018-06-09:19:01:33
  29.         BP Key: 1504   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  30.         Handle: 3it51kvh_1_1   Media: station87-000009
  31.         Keep: BACKUP_LOGS        Until: 2018-08-08:19:01:05
  32.   SPFILE Included: Modification time: 2018-06-09:18:44:01
  33.   SPFILE db_unique_name: ORCL

  34. BS Key  Size       Device Type Elapsed Time Completion Time   
  35. ------- ---------- ----------- ------------ -------------------
  36. 1471    1.75M      SBT_TAPE    00:00:41     2018-06-09:19:02:22
  37.         BP Key: 1505   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  38.         Handle: 3jt51l0l_1_1   Media: station87-000009
  39.         Keep: BACKUP_LOGS        Until: 2018-08-08:19:01:41

  40.   List of Archived Logs in backup set 1471
  41.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  42.   ---- ------- ---------- ------------------- ---------- ---------
  43.   1    86      1412524    2018-06-09:18:58:58 1412851    2018-06-09:19:01:40

  44. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  45. ------- ---- -- ---------- ----------- ------------ -------------------
  46. 1472    Full    10.00M     SBT_TAPE    00:00:26     2018-06-09:19:02:53
  47.         BP Key: 1506   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  48.         Handle: 3kt51l23_1_1   Media: station87-000009
  49.         Keep: BACKUP_LOGS        Until: 2018-08-08:19:02:26
  50.   Control File Included: Ckp SCN: 1412871      Ckp time: 2018-06-09:19:02:27

  51. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  52. ------- ---- -- ---------- ----------- ------------ -------------------
  53. 1567    Incr 0  568.50M    SBT_TAPE    00:01:27     2018-06-09:19:07:48
  54.         BP Key: 1571   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  55.         Handle: 3mt51l9d_1_1   Media: station87-000009
  56.         Keep: BACKUP_LOGS        Until: FOREVER        
  57.   List of Datafiles in backup set 1567
  58.   File LV Type Ckp SCN    Ckp Time            Name
  59.   ---- -- ---- ---------- ------------------- ----
  60.   2    0  Incr 1413253    2018-06-09:19:06:22 +DATA/orcl/datafile/sysaux.257.832197065
  61.   5    0  Incr 1413253    2018-06-09:19:06:22 +DATA/orcl/datafile/example.265.832197353
  62.   7    0  Incr 1413253    2018-06-09:19:06:22 +DATA/orcl/datafile/tbsfda.268.978236837

  63. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  64. ------- ---- -- ---------- ----------- ------------ -------------------
  65. 1568    Incr 0  653.75M    SBT_TAPE    00:01:54     2018-06-09:19:08:15
  66.         BP Key: 1572   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  67.         Handle: 3lt51l9d_1_1   Media: station87-000008
  68.         Keep: BACKUP_LOGS        Until: FOREVER        
  69.   List of Datafiles in backup set 1568
  70.   File LV Type Ckp SCN    Ckp Time            Name
  71.   ---- -- ---- ---------- ------------------- ----
  72.   1    0  Incr 1413249    2018-06-09:19:06:21 +DATA/orcl/datafile/system.256.832197063
  73.   3    0  Incr 1413249    2018-06-09:19:06:21 +DATA/orcl/datafile/undotbs1.258.832197065
  74.   4    0  Incr 1413249    2018-06-09:19:06:21 +DATA/orcl/datafile/users.259.978228669
  75.   6    0  Incr 1413249    2018-06-09:19:06:21 +DATA/orcl/datafile/tbsfda.267.978234227

  76. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  77. ------- ---- -- ---------- ----------- ------------ -------------------
  78. 1569    Full    256.00K    SBT_TAPE    00:00:41     2018-06-09:19:08:57
  79.         BP Key: 1573   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  80.         Handle: 3nt51ld0_1_1   Media: station87-000009
  81.         Keep: BACKUP_LOGS        Until: FOREVER        
  82.   SPFILE Included: Modification time: 2018-06-09:18:44:01
  83.   SPFILE db_unique_name: ORCL

  84. BS Key  Size       Device Type Elapsed Time Completion Time   
  85. ------- ---------- ----------- ------------ -------------------
  86. 1589    256.00K    SBT_TAPE    00:00:30     2018-06-09:19:09:33
  87.         BP Key: 1592   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  88.         Handle: 3ot51lef_1_1   Media: station87-000009
  89.         Keep: BACKUP_LOGS        Until: FOREVER        

  90.   List of Archived Logs in backup set 1589
  91.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  92.   ---- ------- ---------- ------------------- ---------- ---------
  93.   1    89      1413227    2018-06-09:19:06:08 1413402    2018-06-09:19:09:02

  94. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  95. ------- ---- -- ---------- ----------- ------------ -------------------
  96. 1590    Full    10.00M     SBT_TAPE    00:00:37     2018-06-09:19:10:15
  97.         BP Key: 1593   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  98.         Handle: 3pt51lfi_1_1   Media: station87-000009
  99.         Keep: BACKUP_LOGS        Until: FOREVER        
  100.   Control File Included: Ckp SCN: 1413438      Ckp time: 2018-06-09:19:09:38

  101. RMAN>
复制代码
  1. RMAN> change backupset 1589 keep forever;

  2. using channel ORA_DISK_1
  3. using channel ORA_DISK_2
  4. using channel ORA_DISK_3
  5. using channel ORA_DISK_4
  6. using channel ORA_DISK_5
  7. using channel ORA_DISK_6
  8. using channel ORA_DISK_7
  9. using channel ORA_DISK_8
  10. using channel ORA_SBT_TAPE_1
  11. using channel ORA_SBT_TAPE_2
  12. keep attributes for the backup are changed
  13. backup will never be obsolete
  14. backup set key=1589 RECID=98 STAMP=978376173

  15. RMAN> change backupset 1589 keep forever  nologs;

  16. using channel ORA_DISK_1
  17. using channel ORA_DISK_2
  18. using channel ORA_DISK_3
  19. using channel ORA_DISK_4
  20. using channel ORA_DISK_5
  21. using channel ORA_DISK_6
  22. using channel ORA_DISK_7
  23. using channel ORA_DISK_8
  24. using channel ORA_SBT_TAPE_1
  25. using channel ORA_SBT_TAPE_2
  26. keep attributes for the backup are changed
  27. backup will never be obsolete
  28. archived logs will not be kept or backed up
  29. backup set key=1589 RECID=98 STAMP=978376173

  30. RMAN> list backup;                        


  31. List of Backup Sets
  32. ===================


  33. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  34. ------- ---- -- ---------- ----------- ------------ -------------------
  35. 1444    Incr 0  436.25M    SBT_TAPE    00:01:00     2018-06-08:01:08:17
  36.         BP Key: 1473   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSAUX_INCR0
  37.         Handle: 2ct4t1m5_1_1   Media: station87-000008
  38.   List of Datafiles in backup set 1444
  39.   File LV Type Ckp SCN    Ckp Time            Name
  40.   ---- -- ---- ---------- ------------------- ----
  41.   2    0  Incr 1155660    2018-06-08:01:07:17 +DATA/orcl/datafile/sysaux.257.832197065

  42. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  43. ------- ---- -- ---------- ----------- ------------ -------------------
  44. 1445    Full    10.00M     SBT_TAPE    00:00:39     2018-06-08:01:09:01
  45.         BP Key: 1474   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T010822
  46.         Handle: c-1359978017-20180608-07   Media: station87-000008
  47.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  48.   SPFILE db_unique_name: ORCL
  49.   Control File Included: Ckp SCN: 1155709      Ckp time: 2018-06-08:01:08:22

  50. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  51. ------- ---- -- ---------- ----------- ------------ -------------------
  52. 1446    Incr 0  86.50M     SBT_TAPE    00:00:53     2018-06-08:01:13:00
  53.         BP Key: 1475   Status: AVAILABLE  Compressed: YES  Tag: 2TC_SYSAUX_INCR0
  54.         Handle: 2et4t1v7_1_1   Media: station87-000008
  55.   List of Datafiles in backup set 1446
  56.   File LV Type Ckp SCN    Ckp Time            Name
  57.   ---- -- ---- ---------- ------------------- ----
  58.   2    0  Incr 1155986    2018-06-08:01:12:07 +DATA/orcl/datafile/sysaux.257.832197065

  59. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  60. ------- ---- -- ---------- ----------- ------------ -------------------
  61. 1447    Full    10.00M     SBT_TAPE    00:00:41     2018-06-08:01:13:43
  62.         BP Key: 1476   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T011302
  63.         Handle: c-1359978017-20180608-08   Media: station87-000008
  64.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  65.   SPFILE db_unique_name: ORCL
  66.   Control File Included: Ckp SCN: 1156051      Ckp time: 2018-06-08:01:13:02

  67. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  68. ------- ---- -- ---------- ----------- ------------ -------------------
  69. 1448    Full    10.00M     SBT_TAPE    00:00:27     2018-06-08:01:42:19
  70.         BP Key: 1477   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T014152
  71.         Handle: c-1359978017-20180608-09   Media: station87-000008
  72.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  73.   SPFILE db_unique_name: ORCL
  74.   Control File Included: Ckp SCN: 1157970      Ckp time: 2018-06-08:01:41:52

  75. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  76. ------- ---- -- ---------- ----------- ------------ -------------------
  77. 1449    Incr 0  3.50M      SBT_TAPE    00:00:56     2018-06-08:02:04:36
  78.         BP Key: 1478   Status: AVAILABLE  Compressed: NO  Tag: 4TEDUAL_USERS_INCR0
  79.         Handle: 2kt4t4vs_1_1   Media: station87-000008
  80.   List of Datafiles in backup set 1449
  81.   File LV Type Ckp SCN    Ckp Time            Name
  82.   ---- -- ---- ---------- ------------------- ----
  83.   4    0  Incr 1160195    2018-06-08:02:03:40 +DATA/orcl/datafile/users.259.978228669

  84. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  85. ------- ---- -- ---------- ----------- ------------ -------------------
  86. 1450    Full    10.00M     SBT_TAPE    00:00:37     2018-06-08:02:05:22
  87.         BP Key: 1479   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T020445
  88.         Handle: c-1359978017-20180608-0a   Media: station87-000008
  89.   SPFILE Included: Modification time: 2018-06-08:02:04:15
  90.   SPFILE db_unique_name: ORCL
  91.   Control File Included: Ckp SCN: 1160247      Ckp time: 2018-06-08:02:04:45

  92. BS Key  Size       Device Type Elapsed Time Completion Time   
  93. ------- ---------- ----------- ------------ -------------------
  94. 1451    87.00M     SBT_TAPE    00:01:13     2018-06-09:17:37:21
  95.         BP Key: 1480   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  96.         Handle: 2st51g08_1_1   Media: station87-000008

  97.   List of Archived Logs in backup set 1451
  98.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  99.   ---- ------- ---------- ------------------- ---------- ---------
  100.   1    78      1323993    2018-06-08:04:33:46 1328678    2018-06-08:04:34:01
  101.   1    79      1328678    2018-06-08:04:34:01 1340398    2018-06-08:04:39:31

  102. BS Key  Size       Device Type Elapsed Time Completion Time   
  103. ------- ---------- ----------- ------------ -------------------
  104. 1452    46.00M     SBT_TAPE    00:01:20     2018-06-09:17:37:28
  105.         BP Key: 1481   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  106.         Handle: 2tt51g08_1_1   Media: station87-000009

  107.   List of Archived Logs in backup set 1452
  108.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  109.   ---- ------- ---------- ------------------- ---------- ---------
  110.   1    80      1340398    2018-06-08:04:39:31 1344895    2018-06-08:04:39:42

  111. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  112. ------- ---- -- ---------- ----------- ------------ -------------------
  113. 1453    Full    10.00M     SBT_TAPE    00:00:36     2018-06-09:17:38:09
  114.         BP Key: 1482   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T173733
  115.         Handle: c-1359978017-20180609-00   Media: station87-000008
  116.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  117.   SPFILE db_unique_name: ORCL
  118.   Control File Included: Ckp SCN: 1408511      Ckp time: 2018-06-09:17:37:33

  119. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  120. ------- ---- -- ---------- ----------- ------------ -------------------
  121. 1454    Incr 1  30.50M     SBT_TAPE    00:00:48     2018-06-09:17:43:32
  122.         BP Key: 1483   Status: AVAILABLE  Compressed: NO  Tag: 2T_USERS_INCR1
  123.         Handle: 2vt51gck_1_1   Media: station87-000009
  124.   List of Datafiles in backup set 1454
  125.   File LV Type Ckp SCN    Ckp Time            Name
  126.   ---- -- ---- ---------- ------------------- ----
  127.   4    1  Incr 1408699    2018-06-09:17:42:44 +DATA/orcl/datafile/users.259.978228669

  128. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  129. ------- ---- -- ---------- ----------- ------------ -------------------
  130. 1455    Full    10.00M     SBT_TAPE    00:00:42     2018-06-09:17:44:21
  131.         BP Key: 1484   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174339
  132.         Handle: c-1359978017-20180609-01   Media: station87-000009
  133.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  134.   SPFILE db_unique_name: ORCL
  135.   Control File Included: Ckp SCN: 1408731      Ckp time: 2018-06-09:17:43:39

  136. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  137. ------- ---- -- ---------- ----------- ------------ -------------------
  138. 1456    Incr 1  256.00K    SBT_TAPE    00:00:35     2018-06-09:17:47:05
  139.         BP Key: 1485   Status: AVAILABLE  Compressed: NO  Tag: 3T_USERS_INCR1
  140.         Handle: 31t51gjm_1_1   Media: station87-000009
  141.   List of Datafiles in backup set 1456
  142.   File LV Type Ckp SCN    Ckp Time            Name
  143.   ---- -- ---- ---------- ------------------- ----
  144.   4    1  Incr 1408937    2018-06-09:17:46:30 +DATA/orcl/datafile/users.259.978228669

  145. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  146. ------- ---- -- ---------- ----------- ------------ -------------------
  147. 1457    Full    10.00M     SBT_TAPE    00:00:37     2018-06-09:17:47:52
  148.         BP Key: 1486   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174715
  149.         Handle: c-1359978017-20180609-02   Media: station87-000009
  150.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  151.   SPFILE db_unique_name: ORCL
  152.   Control File Included: Ckp SCN: 1408966      Ckp time: 2018-06-09:17:47:15

  153. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  154. ------- ---- -- ---------- ----------- ------------ -------------------
  155. 1458    Incr 1  30.50M     SBT_TAPE    00:00:47     2018-06-09:17:55:25
  156.         BP Key: 1487   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1C
  157.         Handle: 33t51h2u_1_1   Media: station87-000009
  158.   List of Datafiles in backup set 1458
  159.   File LV Type Ckp SCN    Ckp Time            Name
  160.   ---- -- ---- ---------- ------------------- ----
  161.   4    1  Incr 1409298    2018-06-09:17:54:38 +DATA/orcl/datafile/users.259.978228669

  162. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  163. ------- ---- -- ---------- ----------- ------------ -------------------
  164. 1459    Full    10.00M     SBT_TAPE    00:00:28     2018-06-09:17:56:01
  165.         BP Key: 1488   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T175533
  166.         Handle: c-1359978017-20180609-03   Media: station87-000009
  167.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  168.   SPFILE db_unique_name: ORCL
  169.   Control File Included: Ckp SCN: 1409338      Ckp time: 2018-06-09:17:55:33

  170. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  171. ------- ---- -- ---------- ----------- ------------ -------------------
  172. 1460    Full    33.70M     SBT_TAPE    00:00:02     2018-06-09:18:14:10
  173.         BP Key: 1490   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181408
  174.         Handle: 35t51i7g_1_2   Media: station87-000009
  175.   List of Datafiles in backup set 1460
  176.   File LV Type Ckp SCN    Ckp Time            Name
  177.   ---- -- ---- ---------- ------------------- ----
  178.   4       Full 1410584    2018-06-09:18:14:08 +DATA/orcl/datafile/users.259.978228669

  179. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  180. ------- ---- -- ---------- ----------- ------------ -------------------
  181. 1461    Full    9.86M      DISK        00:00:01     2018-06-09:18:14:12
  182.         BP Key: 1489   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181411
  183.         Piece Name: +FRA/orcl/autobackup/2018_06_09/s_978372851.322.978372853
  184.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  185.   SPFILE db_unique_name: ORCL
  186.   Control File Included: Ckp SCN: 1410592      Ckp time: 2018-06-09:18:14:11

  187. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  188. ------- ---- -- ---------- ----------- ------------ -------------------
  189. 1462    Full    10.00M     SBT_TAPE    00:00:38     2018-06-09:18:16:59
  190.         BP Key: 1491   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181621
  191.         Handle: c-1359978017-20180609-05   Media: station87-000009
  192.   SPFILE Included: Modification time: 2018-06-09:18:15:20
  193.   SPFILE db_unique_name: ORCL
  194.   Control File Included: Ckp SCN: 1410754      Ckp time: 2018-06-09:18:16:21

  195. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  196. ------- ---- -- ---------- ----------- ------------ -------------------
  197. 1463    Incr 0  597.50M    SBT_TAPE    00:02:39     2018-06-09:18:40:28
  198.   List of Datafiles in backup set 1463
  199.   File LV Type Ckp SCN    Ckp Time            Name
  200.   ---- -- ---- ---------- ------------------- ----
  201.   1    0  Incr 1411610    2018-06-09:18:37:49 +DATA/orcl/datafile/system.256.832197063

  202.   Backup Set Copy #1 of backup set 1463
  203.   Device Type Elapsed Time Completion Time     Compressed Tag
  204.   ----------- ------------ ------------------- ---------- ---
  205.   SBT_TAPE    00:02:39     2018-06-09:18:40:28 NO         5T_SYSTEM_INCR0

  206.     List of Backup Pieces for backup set 1463 Copy #1
  207.     BP Key  Pc# Status      Media                   Piece Name
  208.     ------- --- ----------- ----------------------- ----------
  209.     1492    1   AVAILABLE   station87-000009        38t51jjt_1_1
  210.     1493    2   AVAILABLE   station87-000009        38t51jjt_2_1
  211.     1494    3   AVAILABLE   station87-000009        38t51jjt_3_1

  212. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  213. ------- ---- -- ---------- ----------- ------------ -------------------
  214. 1464    Incr 0  10.00M     SBT_TAPE    00:00:42     2018-06-09:18:41:14
  215.         BP Key: 1495   Status: AVAILABLE  Compressed: NO  Tag: 5T_SYSTEM_INCR0
  216.         Handle: 39t51jp0_1_1   Media: station87-000009
  217.   SPFILE Included: Modification time: 2018-06-09:18:38:42
  218.   SPFILE db_unique_name: ORCL
  219.   Control File Included: Ckp SCN: 1411697      Ckp time: 2018-06-09:18:40:32

  220. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  221. ------- ---- -- ---------- ----------- ------------ -------------------
  222. 1465    Incr 0  597.75M    SBT_TAPE    00:02:44     2018-06-09:18:47:14
  223.   List of Datafiles in backup set 1465
  224.   File LV Type Ckp SCN    Ckp Time            Name
  225.   ---- -- ---- ---------- ------------------- ----
  226.   1    0  Incr 1411863    2018-06-09:18:44:30 +DATA/orcl/datafile/system.256.832197063

  227.   Backup Set Copy #1 of backup set 1465
  228.   Device Type Elapsed Time Completion Time     Compressed Tag
  229.   ----------- ------------ ------------------- ---------- ---
  230.   SBT_TAPE    00:02:44     2018-06-09:18:47:14 NO         6T_SYSTEM_INCR0

  231.     List of Backup Pieces for backup set 1465 Copy #1
  232.     BP Key  Pc# Status      Media                   Piece Name
  233.     ------- --- ----------- ----------------------- ----------
  234.     1496    1   AVAILABLE   station87-000009        3at51k0e_1_1
  235.     1498    2   AVAILABLE   station87-000009        3at51k0e_2_1
  236.     1499    3   AVAILABLE   station87-000008        3at51k0e_3_1
  237.     1500    4   AVAILABLE   station87-000009        3at51k0e_4_1

  238. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  239. ------- ---- -- ---------- ----------- ------------ -------------------
  240. 1466    Incr 0  10.00M     SBT_TAPE    00:01:04     2018-06-09:18:45:34
  241.         BP Key: 1497   Status: AVAILABLE  Compressed: NO  Tag: 6T_SYSTEM_INCR0
  242.         Handle: 3bt51k0e_1_1   Media: station87-000008
  243.   Control File Included: Ckp SCN: 1411864      Ckp time: 2018-06-09:18:44:30

  244. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  245. ------- ---- -- ---------- ----------- ------------ -------------------
  246. 1467    Incr 0  256.00K    SBT_TAPE    00:00:49     2018-06-09:18:47:25
  247.         BP Key: 1501   Status: AVAILABLE  Compressed: NO  Tag: 6T_SYSTEM_INCR0
  248.         Handle: 3ft51k4c_1_1   Media: station87-000008
  249.   SPFILE Included: Modification time: 2018-06-09:18:44:01
  250.   SPFILE db_unique_name: ORCL

  251. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  252. ------- ---- -- ---------- ----------- ------------ -------------------
  253. 1468    Incr 0  654.00M    SBT_TAPE    00:01:55     2018-06-09:19:00:54
  254.         BP Key: 1502   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  255.         Handle: 3gt51krj_1_1   Media: station87-000009
  256.         Keep: BACKUP_LOGS        Until: 2018-08-08:18:58:59
  257.   List of Datafiles in backup set 1468
  258.   File LV Type Ckp SCN    Ckp Time            Name
  259.   ---- -- ---- ---------- ------------------- ----
  260.   1    0  Incr 1412529    2018-06-09:18:59:00 +DATA/orcl/datafile/system.256.832197063
  261.   3    0  Incr 1412529    2018-06-09:18:59:00 +DATA/orcl/datafile/undotbs1.258.832197065
  262.   4    0  Incr 1412529    2018-06-09:18:59:00 +DATA/orcl/datafile/users.259.978228669
  263.   6    0  Incr 1412529    2018-06-09:18:59:00 +DATA/orcl/datafile/tbsfda.267.978234227

  264. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  265. ------- ---- -- ---------- ----------- ------------ -------------------
  266. 1469    Incr 0  567.75M    SBT_TAPE    00:01:58     2018-06-09:19:00:57
  267.         BP Key: 1503   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  268.         Handle: 3ht51krj_1_1   Media: station87-000008
  269.         Keep: BACKUP_LOGS        Until: 2018-08-08:18:58:59
  270.   List of Datafiles in backup set 1469
  271.   File LV Type Ckp SCN    Ckp Time            Name
  272.   ---- -- ---- ---------- ------------------- ----
  273.   2    0  Incr 1412533    2018-06-09:18:59:00 +DATA/orcl/datafile/sysaux.257.832197065
  274.   5    0  Incr 1412533    2018-06-09:18:59:00 +DATA/orcl/datafile/example.265.832197353
  275.   7    0  Incr 1412533    2018-06-09:18:59:00 +DATA/orcl/datafile/tbsfda.268.978236837

  276. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  277. ------- ---- -- ---------- ----------- ------------ -------------------
  278. 1470    Full    256.00K    SBT_TAPE    00:00:28     2018-06-09:19:01:33
  279.         BP Key: 1504   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  280.         Handle: 3it51kvh_1_1   Media: station87-000009
  281.         Keep: BACKUP_LOGS        Until: 2018-08-08:19:01:05
  282.   SPFILE Included: Modification time: 2018-06-09:18:44:01
  283.   SPFILE db_unique_name: ORCL

  284. BS Key  Size       Device Type Elapsed Time Completion Time   
  285. ------- ---------- ----------- ------------ -------------------
  286. 1471    1.75M      SBT_TAPE    00:00:41     2018-06-09:19:02:22
  287.         BP Key: 1505   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  288.         Handle: 3jt51l0l_1_1   Media: station87-000009
  289.         Keep: BACKUP_LOGS        Until: 2018-08-08:19:01:41

  290.   List of Archived Logs in backup set 1471
  291.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  292.   ---- ------- ---------- ------------------- ---------- ---------
  293.   1    86      1412524    2018-06-09:18:58:58 1412851    2018-06-09:19:01:40

  294. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  295. ------- ---- -- ---------- ----------- ------------ -------------------
  296. 1472    Full    10.00M     SBT_TAPE    00:00:26     2018-06-09:19:02:53
  297.         BP Key: 1506   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  298.         Handle: 3kt51l23_1_1   Media: station87-000009
  299.         Keep: BACKUP_LOGS        Until: 2018-08-08:19:02:26
  300.   Control File Included: Ckp SCN: 1412871      Ckp time: 2018-06-09:19:02:27

  301. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  302. ------- ---- -- ---------- ----------- ------------ -------------------
  303. 1567    Incr 0  568.50M    SBT_TAPE    00:01:27     2018-06-09:19:07:48
  304.         BP Key: 1571   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  305.         Handle: 3mt51l9d_1_1   Media: station87-000009
  306.         Keep: BACKUP_LOGS        Until: FOREVER        
  307.   List of Datafiles in backup set 1567
  308.   File LV Type Ckp SCN    Ckp Time            Name
  309.   ---- -- ---- ---------- ------------------- ----
  310.   2    0  Incr 1413253    2018-06-09:19:06:22 +DATA/orcl/datafile/sysaux.257.832197065
  311.   5    0  Incr 1413253    2018-06-09:19:06:22 +DATA/orcl/datafile/example.265.832197353
  312.   7    0  Incr 1413253    2018-06-09:19:06:22 +DATA/orcl/datafile/tbsfda.268.978236837

  313. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  314. ------- ---- -- ---------- ----------- ------------ -------------------
  315. 1568    Incr 0  653.75M    SBT_TAPE    00:01:54     2018-06-09:19:08:15
  316.         BP Key: 1572   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  317.         Handle: 3lt51l9d_1_1   Media: station87-000008
  318.         Keep: BACKUP_LOGS        Until: FOREVER        
  319.   List of Datafiles in backup set 1568
  320.   File LV Type Ckp SCN    Ckp Time            Name
  321.   ---- -- ---- ---------- ------------------- ----
  322.   1    0  Incr 1413249    2018-06-09:19:06:21 +DATA/orcl/datafile/system.256.832197063
  323.   3    0  Incr 1413249    2018-06-09:19:06:21 +DATA/orcl/datafile/undotbs1.258.832197065
  324.   4    0  Incr 1413249    2018-06-09:19:06:21 +DATA/orcl/datafile/users.259.978228669
  325.   6    0  Incr 1413249    2018-06-09:19:06:21 +DATA/orcl/datafile/tbsfda.267.978234227

  326. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  327. ------- ---- -- ---------- ----------- ------------ -------------------
  328. 1569    Full    256.00K    SBT_TAPE    00:00:41     2018-06-09:19:08:57
  329.         BP Key: 1573   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  330.         Handle: 3nt51ld0_1_1   Media: station87-000009
  331.         Keep: BACKUP_LOGS        Until: FOREVER        
  332.   SPFILE Included: Modification time: 2018-06-09:18:44:01
  333.   SPFILE db_unique_name: ORCL

  334. BS Key  Size       Device Type Elapsed Time Completion Time   
  335. ------- ---------- ----------- ------------ -------------------
  336. 1589    256.00K    SBT_TAPE    00:00:30     2018-06-09:19:09:33
  337.         BP Key: 1592   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  338.         Handle: 3ot51lef_1_1   Media: station87-000009
  339.         Keep: NOLOGS             Until: FOREVER        

  340.   List of Archived Logs in backup set 1589
  341.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  342.   ---- ------- ---------- ------------------- ---------- ---------
  343.   1    89      1413227    2018-06-09:19:06:08 1413402    2018-06-09:19:09:02

  344. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  345. ------- ---- -- ---------- ----------- ------------ -------------------
  346. 1590    Full    10.00M     SBT_TAPE    00:00:37     2018-06-09:19:10:15
  347.         BP Key: 1593   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  348.         Handle: 3pt51lfi_1_1   Media: station87-000009
  349.         Keep: BACKUP_LOGS        Until: FOREVER        
  350.   Control File Included: Ckp SCN: 1413438      Ckp time: 2018-06-09:19:09:38
复制代码
备份介质检查:
  1. RMAN> crosscheck backup;                        

  2. using channel ORA_DISK_1
  3. using channel ORA_DISK_2
  4. using channel ORA_DISK_3
  5. using channel ORA_DISK_4
  6. using channel ORA_DISK_5
  7. using channel ORA_DISK_6
  8. using channel ORA_DISK_7
  9. using channel ORA_DISK_8
  10. using channel ORA_SBT_TAPE_1
  11. using channel ORA_SBT_TAPE_2
  12. crosschecked backup piece: found to be 'AVAILABLE'
  13. backup piece handle=2ct4t1m5_1_1 RECID=71 STAMP=978224837
  14. crosschecked backup piece: found to be 'AVAILABLE'
  15. backup piece handle=c-1359978017-20180608-07 RECID=72 STAMP=978224903
  16. crosschecked backup piece: found to be 'AVAILABLE'
  17. backup piece handle=2et4t1v7_1_1 RECID=73 STAMP=978225127
  18. crosschecked backup piece: found to be 'AVAILABLE'
  19. backup piece handle=c-1359978017-20180608-08 RECID=74 STAMP=978225183
  20. crosschecked backup piece: found to be 'AVAILABLE'
  21. backup piece handle=c-1359978017-20180608-09 RECID=76 STAMP=978226912
  22. crosschecked backup piece: found to be 'AVAILABLE'
  23. backup piece handle=2kt4t4vs_1_1 RECID=77 STAMP=978228220
  24. crosschecked backup piece: found to be 'AVAILABLE'
  25. backup piece handle=c-1359978017-20180608-0a RECID=78 STAMP=978228286
  26. crosschecked backup piece: found to be 'AVAILABLE'
  27. backup piece handle=2st51g08_1_1 RECID=79 STAMP=978370568
  28. crosschecked backup piece: found to be 'AVAILABLE'
  29. backup piece handle=2tt51g08_1_1 RECID=80 STAMP=978370568
  30. crosschecked backup piece: found to be 'AVAILABLE'
  31. backup piece handle=c-1359978017-20180609-00 RECID=81 STAMP=978370654
  32. crosschecked backup piece: found to be 'AVAILABLE'
  33. backup piece handle=2vt51gck_1_1 RECID=82 STAMP=978370964
  34. crosschecked backup piece: found to be 'AVAILABLE'
  35. backup piece handle=c-1359978017-20180609-01 RECID=83 STAMP=978371020
  36. crosschecked backup piece: found to be 'AVAILABLE'
  37. backup piece handle=31t51gjm_1_1 RECID=84 STAMP=978371190
  38. crosschecked backup piece: found to be 'AVAILABLE'
  39. backup piece handle=c-1359978017-20180609-02 RECID=85 STAMP=978371235
  40. crosschecked backup piece: found to be 'AVAILABLE'
  41. backup piece handle=33t51h2u_1_1 RECID=86 STAMP=978371678
  42. crosschecked backup piece: found to be 'AVAILABLE'
  43. backup piece handle=c-1359978017-20180609-03 RECID=87 STAMP=978371734
  44. crosschecked backup piece: found to be 'AVAILABLE'
  45. backup piece handle=35t51i7g_1_2 RECID=90 STAMP=978372926
  46. crosschecked backup piece: found to be 'AVAILABLE'
  47. backup piece handle=+FRA/orcl/autobackup/2018_06_09/s_978372851.322.978372853 RECID=89 STAMP=978372852
  48. crosschecked backup piece: found to be 'AVAILABLE'
  49. backup piece handle=c-1359978017-20180609-05 RECID=91 STAMP=978372982
  50. crosschecked backup piece: found to be 'AVAILABLE'
  51. backup piece handle=38t51jjt_1_1 RECID=92 STAMP=978374269
  52. crosschecked backup piece: found to be 'AVAILABLE'
  53. backup piece handle=38t51jjt_2_1 RECID=93 STAMP=978374332
  54. crosschecked backup piece: found to be 'AVAILABLE'
  55. backup piece handle=38t51jjt_3_1 RECID=94 STAMP=978374377
  56. crosschecked backup piece: found to be 'AVAILABLE'
  57. backup piece handle=39t51jp0_1_1 RECID=95 STAMP=978374433
  58. crosschecked backup piece: found to be 'AVAILABLE'
  59. backup piece handle=3at51k0e_1_1 RECID=96 STAMP=978374670
  60. crosschecked backup piece: found to be 'AVAILABLE'
  61. backup piece handle=3at51k0e_2_1 RECID=98 STAMP=978374737
  62. crosschecked backup piece: found to be 'AVAILABLE'
  63. backup piece handle=3at51k0e_3_1 RECID=99 STAMP=978374737
  64. crosschecked backup piece: found to be 'AVAILABLE'
  65. backup piece handle=3at51k0e_4_1 RECID=100 STAMP=978374793
  66. crosschecked backup piece: found to be 'AVAILABLE'
  67. backup piece handle=3bt51k0e_1_1 RECID=97 STAMP=978374671
  68. crosschecked backup piece: found to be 'AVAILABLE'
  69. backup piece handle=3ft51k4c_1_1 RECID=101 STAMP=978374796
  70. crosschecked backup piece: found to be 'AVAILABLE'
  71. backup piece handle=3gt51krj_1_1 RECID=102 STAMP=978375540
  72. crosschecked backup piece: found to be 'AVAILABLE'
  73. backup piece handle=3ht51krj_1_1 RECID=103 STAMP=978375540
  74. crosschecked backup piece: found to be 'AVAILABLE'
  75. backup piece handle=3it51kvh_1_1 RECID=104 STAMP=978375665
  76. crosschecked backup piece: found to be 'AVAILABLE'
  77. backup piece handle=3jt51l0l_1_1 RECID=105 STAMP=978375701
  78. crosschecked backup piece: found to be 'AVAILABLE'
  79. backup piece handle=3kt51l23_1_1 RECID=106 STAMP=978375748
  80. crosschecked backup piece: found to be 'AVAILABLE'
  81. backup piece handle=3mt51l9d_1_1 RECID=107 STAMP=978375982
  82. crosschecked backup piece: found to be 'AVAILABLE'
  83. backup piece handle=3lt51l9d_1_1 RECID=108 STAMP=978375982
  84. crosschecked backup piece: found to be 'AVAILABLE'
  85. backup piece handle=3nt51ld0_1_1 RECID=109 STAMP=978376096
  86. crosschecked backup piece: found to be 'AVAILABLE'
  87. backup piece handle=3ot51lef_1_1 RECID=110 STAMP=978376143
  88. crosschecked backup piece: found to be 'AVAILABLE'
  89. backup piece handle=3pt51lfi_1_1 RECID=111 STAMP=978376179
  90. Crosschecked 39 objects


  91. RMAN>
复制代码
  1. RMAN> list expired backup;

  2. specification does not match any backup in the repository

复制代码
模拟破坏:
  1. ob> lspiece
  2.     POID Database   Content    Copy Created      Host             Piece name
  3.      153 orcl       incremental    0 06/08.01:07  station87        2ct4t1m5_1_1
  4.      154 orcl       autobackup    0 06/08.01:08  station87        c-1359978017-20180608-07
  5.      155 orcl       incremental    0 06/08.01:12  station87        2et4t1v7_1_1
  6.      156 orcl       autobackup    0 06/08.01:13  station87        c-1359978017-20180608-08
  7.      158 orcl       autobackup    0 06/08.01:41  station87        c-1359978017-20180608-09
  8.      159 orcl       incremental    0 06/08.02:04  station87        2kt4t4vs_1_1
  9.      160 orcl       autobackup    0 06/08.02:04  station87        c-1359978017-20180608-0a
  10.      161 orcl       archivelog    0 06/09.17:36  station87        2st51g08_1_1
  11.      162 orcl       archivelog    0 06/09.17:37  station87        2tt51g08_1_1
  12.      163 orcl       autobackup    0 06/09.17:37  station87        c-1359978017-20180609-00
  13.      164 orcl       incremental    0 06/09.17:43  station87        2vt51gck_1_1
  14.      165 orcl       autobackup    0 06/09.17:43  station87        c-1359978017-20180609-01
  15.      166 orcl       incremental    0 06/09.17:46  station87        31t51gjm_1_1
  16.      167 orcl       autobackup    0 06/09.17:47  station87        c-1359978017-20180609-02
  17.      168 orcl       incremental    0 06/09.17:55  station87        33t51h2u_1_1
  18.      169 orcl       autobackup    0 06/09.17:55  station87        c-1359978017-20180609-03
  19.      170 orcl       full          0 06/09.18:15  station87        35t51i7g_1_2
  20.      171 orcl       autobackup    0 06/09.18:16  station87        c-1359978017-20180609-05
  21.      172 orcl       incremental    0 06/09.18:38  station87        38t51jjt_1_1
  22.      173 orcl       incremental    0 06/09.18:38  station87        38t51jjt_2_1
  23.      174 orcl       incremental    0 06/09.18:39  station87        38t51jjt_3_1
  24.      175 orcl       incremental    0 06/09.18:40  station87        39t51jp0_1_1
  25.      176 orcl       incremental    0 06/09.18:44  station87        3at51k0e_1_1
  26.      177 orcl       incremental    0 06/09.18:45  station87        3bt51k0e_1_1
  27.      178 orcl       incremental    0 06/09.18:45  station87        3at51k0e_2_1
  28.      179 orcl       incremental    0 06/09.18:45  station87        3at51k0e_3_1
  29.      180 orcl       incremental    0 06/09.18:46  station87        3at51k0e_4_1
  30.      181 orcl       incremental    0 06/09.18:46  station87        3ft51k4c_1_1
  31.      182 orcl       incremental    0 06/09.18:59  station87        3gt51krj_1_1
  32.      183 orcl       incremental    0 06/09.18:59  station87        3ht51krj_1_1
  33.      184 orcl       full          0 06/09.19:01  station87        3it51kvh_1_1
  34.      185 orcl       archivelog    0 06/09.19:01  station87        3jt51l0l_1_1
  35.      186 orcl       full          0 06/09.19:02  station87        3kt51l23_1_1
  36.      187 orcl       incremental    0 06/09.19:06  station87        3mt51l9d_1_1
  37.      188 orcl       incremental    0 06/09.19:06  station87        3lt51l9d_1_1
  38.      189 orcl       full          0 06/09.19:08  station87        3nt51ld0_1_1
  39.      190 orcl       archivelog    0 06/09.19:09  station87        3ot51lef_1_1
  40.      191 orcl       full          0 06/09.19:09  station87        3pt51lfi_1_1
  41. ob> rmpiece 3pt51lfi_1_1
  42. remove backup piece 3pt51lfi_1_1? (a, n, q, y, ?) [n]: y
  43. ob> lspiece
  44.     POID Database   Content    Copy Created      Host             Piece name
  45.      153 orcl       incremental    0 06/08.01:07  station87        2ct4t1m5_1_1
  46.      154 orcl       autobackup    0 06/08.01:08  station87        c-1359978017-20180608-07
  47.      155 orcl       incremental    0 06/08.01:12  station87        2et4t1v7_1_1
  48.      156 orcl       autobackup    0 06/08.01:13  station87        c-1359978017-20180608-08
  49.      158 orcl       autobackup    0 06/08.01:41  station87        c-1359978017-20180608-09
  50.      159 orcl       incremental    0 06/08.02:04  station87        2kt4t4vs_1_1
  51.      160 orcl       autobackup    0 06/08.02:04  station87        c-1359978017-20180608-0a
  52.      161 orcl       archivelog    0 06/09.17:36  station87        2st51g08_1_1
  53.      162 orcl       archivelog    0 06/09.17:37  station87        2tt51g08_1_1
  54.      163 orcl       autobackup    0 06/09.17:37  station87        c-1359978017-20180609-00
  55.      164 orcl       incremental    0 06/09.17:43  station87        2vt51gck_1_1
  56.      165 orcl       autobackup    0 06/09.17:43  station87        c-1359978017-20180609-01
  57.      166 orcl       incremental    0 06/09.17:46  station87        31t51gjm_1_1
  58.      167 orcl       autobackup    0 06/09.17:47  station87        c-1359978017-20180609-02
  59.      168 orcl       incremental    0 06/09.17:55  station87        33t51h2u_1_1
  60.      169 orcl       autobackup    0 06/09.17:55  station87        c-1359978017-20180609-03
  61.      170 orcl       full          0 06/09.18:15  station87        35t51i7g_1_2
  62.      171 orcl       autobackup    0 06/09.18:16  station87        c-1359978017-20180609-05
  63.      172 orcl       incremental    0 06/09.18:38  station87        38t51jjt_1_1
  64.      173 orcl       incremental    0 06/09.18:38  station87        38t51jjt_2_1
  65.      174 orcl       incremental    0 06/09.18:39  station87        38t51jjt_3_1
  66.      175 orcl       incremental    0 06/09.18:40  station87        39t51jp0_1_1
  67.      176 orcl       incremental    0 06/09.18:44  station87        3at51k0e_1_1
  68.      177 orcl       incremental    0 06/09.18:45  station87        3bt51k0e_1_1
  69.      178 orcl       incremental    0 06/09.18:45  station87        3at51k0e_2_1
  70.      179 orcl       incremental    0 06/09.18:45  station87        3at51k0e_3_1
  71.      180 orcl       incremental    0 06/09.18:46  station87        3at51k0e_4_1
  72.      181 orcl       incremental    0 06/09.18:46  station87        3ft51k4c_1_1
  73.      182 orcl       incremental    0 06/09.18:59  station87        3gt51krj_1_1
  74.      183 orcl       incremental    0 06/09.18:59  station87        3ht51krj_1_1
  75.      184 orcl       full          0 06/09.19:01  station87        3it51kvh_1_1
  76.      185 orcl       archivelog    0 06/09.19:01  station87        3jt51l0l_1_1
  77.      186 orcl       full          0 06/09.19:02  station87        3kt51l23_1_1
  78.      187 orcl       incremental    0 06/09.19:06  station87        3mt51l9d_1_1
  79.      188 orcl       incremental    0 06/09.19:06  station87        3lt51l9d_1_1
  80.      189 orcl       full          0 06/09.19:08  station87        3nt51ld0_1_1
  81.      190 orcl       archivelog    0 06/09.19:09  station87        3ot51lef_1_1
  82. ob>
复制代码
  1. RMAN> crosscheck backup;

  2. using channel ORA_DISK_1
  3. using channel ORA_DISK_2
  4. using channel ORA_DISK_3
  5. using channel ORA_DISK_4
  6. using channel ORA_DISK_5
  7. using channel ORA_DISK_6
  8. using channel ORA_DISK_7
  9. using channel ORA_DISK_8
  10. using channel ORA_SBT_TAPE_1
  11. using channel ORA_SBT_TAPE_2
  12. crosschecked backup piece: found to be 'AVAILABLE'
  13. backup piece handle=2ct4t1m5_1_1 RECID=71 STAMP=978224837
  14. crosschecked backup piece: found to be 'AVAILABLE'
  15. backup piece handle=c-1359978017-20180608-07 RECID=72 STAMP=978224903
  16. crosschecked backup piece: found to be 'AVAILABLE'
  17. backup piece handle=2et4t1v7_1_1 RECID=73 STAMP=978225127
  18. crosschecked backup piece: found to be 'AVAILABLE'
  19. backup piece handle=c-1359978017-20180608-08 RECID=74 STAMP=978225183
  20. crosschecked backup piece: found to be 'AVAILABLE'
  21. backup piece handle=c-1359978017-20180608-09 RECID=76 STAMP=978226912
  22. crosschecked backup piece: found to be 'AVAILABLE'
  23. backup piece handle=2kt4t4vs_1_1 RECID=77 STAMP=978228220
  24. crosschecked backup piece: found to be 'AVAILABLE'
  25. backup piece handle=c-1359978017-20180608-0a RECID=78 STAMP=978228286
  26. crosschecked backup piece: found to be 'AVAILABLE'
  27. backup piece handle=2st51g08_1_1 RECID=79 STAMP=978370568
  28. crosschecked backup piece: found to be 'AVAILABLE'
  29. backup piece handle=2tt51g08_1_1 RECID=80 STAMP=978370568
  30. crosschecked backup piece: found to be 'AVAILABLE'
  31. backup piece handle=c-1359978017-20180609-00 RECID=81 STAMP=978370654
  32. crosschecked backup piece: found to be 'AVAILABLE'
  33. backup piece handle=2vt51gck_1_1 RECID=82 STAMP=978370964
  34. crosschecked backup piece: found to be 'AVAILABLE'
  35. backup piece handle=c-1359978017-20180609-01 RECID=83 STAMP=978371020
  36. crosschecked backup piece: found to be 'AVAILABLE'
  37. backup piece handle=31t51gjm_1_1 RECID=84 STAMP=978371190
  38. crosschecked backup piece: found to be 'AVAILABLE'
  39. backup piece handle=c-1359978017-20180609-02 RECID=85 STAMP=978371235
  40. crosschecked backup piece: found to be 'AVAILABLE'
  41. backup piece handle=33t51h2u_1_1 RECID=86 STAMP=978371678
  42. crosschecked backup piece: found to be 'AVAILABLE'
  43. backup piece handle=c-1359978017-20180609-03 RECID=87 STAMP=978371734
  44. crosschecked backup piece: found to be 'AVAILABLE'
  45. backup piece handle=35t51i7g_1_2 RECID=90 STAMP=978372926
  46. crosschecked backup piece: found to be 'AVAILABLE'
  47. backup piece handle=+FRA/orcl/autobackup/2018_06_09/s_978372851.322.978372853 RECID=89 STAMP=978372852
  48. crosschecked backup piece: found to be 'AVAILABLE'
  49. backup piece handle=c-1359978017-20180609-05 RECID=91 STAMP=978372982
  50. crosschecked backup piece: found to be 'AVAILABLE'
  51. backup piece handle=38t51jjt_1_1 RECID=92 STAMP=978374269
  52. crosschecked backup piece: found to be 'AVAILABLE'
  53. backup piece handle=38t51jjt_2_1 RECID=93 STAMP=978374332
  54. crosschecked backup piece: found to be 'AVAILABLE'
  55. backup piece handle=38t51jjt_3_1 RECID=94 STAMP=978374377
  56. crosschecked backup piece: found to be 'AVAILABLE'
  57. backup piece handle=39t51jp0_1_1 RECID=95 STAMP=978374433
  58. crosschecked backup piece: found to be 'AVAILABLE'
复制代码

关于在线日志组的特殊恢复方法(不要人为地去关闭database,导致7a/7b的实验):

inactive日志组的问题:
  1. SQL> select  * from v$log;

  2.     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE          MEMBERS ARC STATUS               FIRST_CHANGE# FIRST_TIME          NEXT_CHANGE# NEXT_TIME               CON_ID
  3. ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- ------------ ------------------- ----------
  4.          1            1              28   52428800           512                1 NO  INACTIVE                     1997075 2018-06-02:20:09:15      2009327 2018-06-09:11:02:30           0
  5.          2            1              29   52428800           512                1 NO  INACTIVE                     2009327 2018-06-09:11:02:30      2013082 2018-06-09:11:12:41           0
  6.          3            1              30   52428800           512                1 NO  CURRENT                     2013082 2018-06-09:11:12:41   2.8147E+14   0

  7. SQL> select  member from v$logfile;

  8. MEMBER
  9. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  10. /u01/app/oracle/oradata/rcat/redo03.log
  11. /u01/app/oracle/oradata/rcat/redo02.log
  12. /u01/app/oracle/oradata/rcat/redo01.log

  13. SQL> select  open_mode from v$database;

  14. OPEN_MODE
  15. --------------------
  16. READ WRITE

  17. SQL> alter database clear logfile group 1;  

  18. Database altered.

  19. SQL>
复制代码

active日志组的问题:

  1. SQL> select  * from v$log;

  2.     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE          MEMBERS ARC STATUS               FIRST_CHANGE# FIRST_TIME          NEXT_CHANGE# NEXT_TIME               CON_ID
  3. ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- ------------ ------------------- ----------
  4.          1            1               0   52428800           512                1 NO  UNUSED                     1997075 2018-06-02:20:09:15      2009327 2018-06-09:11:02:30           0
  5.          2            1              29   52428800           512                1 NO  INACTIVE                     2009327 2018-06-09:11:02:30      2013082 2018-06-09:11:12:41           0
  6.          3            1              30   52428800           512                1 NO  CURRENT                     2013082 2018-06-09:11:12:41   2.8147E+14   0

  7. SQL> alter system switch logfile;

  8. System altered.

  9. SQL> select  * from v$log;

  10.     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE          MEMBERS ARC STATUS               FIRST_CHANGE# FIRST_TIME          NEXT_CHANGE# NEXT_TIME               CON_ID
  11. ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- ------------ ------------------- ----------
  12.          1            1              31   52428800           512                1 NO  CURRENT                     2015655 2018-06-09:11:41:25   2.8147E+14   0
  13.          2            1              29   52428800           512                1 NO  INACTIVE                     2009327 2018-06-09:11:02:30      2013082 2018-06-09:11:12:41           0
  14.          3            1              30   52428800           512                1 NO  ACTIVE                     2013082 2018-06-09:11:12:41      2015655 2018-06-09:11:41:25           0

  15. SQL> select  * from v$log;

  16.     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE          MEMBERS ARC STATUS               FIRST_CHANGE# FIRST_TIME          NEXT_CHANGE# NEXT_TIME               CON_ID
  17. ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- ------------ ------------------- ----------
  18.          1            1              31   52428800           512                1 NO  CURRENT                     2015655 2018-06-09:11:41:25   2.8147E+14   0
  19.          2            1              29   52428800           512                1 NO  INACTIVE                     2009327 2018-06-09:11:02:30      2013082 2018-06-09:11:12:41           0
  20.          3            1              30   52428800           512                1 NO  ACTIVE                     2013082 2018-06-09:11:12:41      2015655 2018-06-09:11:41:25           0

  21. SQL> alter database clear logfile group 3;  
  22. alter database clear logfile group 3
  23. *
  24. ERROR at line 1:
  25. ORA-01624: log 3 needed for crash recovery of instance rcat (thread 1)
  26. ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/rcat/redo03.log'


  27. SQL> alter system checkpoint;

  28. System altered.

  29. SQL> alter database clear logfile group 3;  

  30. Database altered.

  31. SQL>
复制代码

current的问题:






  1. SQL> select  * from v$log;

  2.     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE          MEMBERS ARC STATUS               FIRST_CHANGE# FIRST_TIME          NEXT_CHANGE# NEXT_TIME               CON_ID
  3. ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- ------------ ------------------- ----------
  4.          1            1              31   52428800           512                1 NO  CURRENT                     2015655 2018-06-09:11:41:25   2.8147E+14   0
  5.          2            1              29   52428800           512                1 NO  INACTIVE                     2009327 2018-06-09:11:02:30      2013082 2018-06-09:11:12:41           0
  6.          3            1               0   52428800           512                1 NO  UNUSED                     2013082 2018-06-09:11:12:41      2015655 2018-06-09:11:41:25           0

  7. SQL> alter database clear logfile group 1;  
  8. alter database clear logfile group 1
  9. *
  10. ERROR at line 1:
  11. ORA-01624: log 1 needed for crash recovery of instance rcat (thread 1)
  12. ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/rcat/redo01.log'


  13. SQL> alter system checkpoint;

  14. System altered.

  15. SQL> alter database clear logfile group 1;  
  16. alter database clear logfile group 1
  17. *
  18. ERROR at line 1:
  19. ORA-01624: log 1 needed for crash recovery of instance rcat (thread 1)
  20. ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/rcat/redo01.log'


  21. SQL> select  * from v$log;

  22.     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE          MEMBERS ARC STATUS               FIRST_CHANGE# FIRST_TIME          NEXT_CHANGE# NEXT_TIME               CON_ID
  23. ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- ------------ ------------------- ----------
  24.          1            1              31   52428800           512                1 NO  CURRENT                     2015655 2018-06-09:11:41:25   2.8147E+14   0
  25.          2            1              29   52428800           512                1 NO  INACTIVE                     2009327 2018-06-09:11:02:30      2013082 2018-06-09:11:12:41           0
  26.          3            1               0   52428800           512                1 NO  UNUSED                     2013082 2018-06-09:11:12:41      2015655 2018-06-09:11:41:25           0

  27. SQL> alter system switch logfile;

  28. System altered.

  29. SQL> select  * from v$log;

  30.     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE          MEMBERS ARC STATUS               FIRST_CHANGE# FIRST_TIME          NEXT_CHANGE# NEXT_TIME               CON_ID
  31. ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- ------------ ------------------- ----------
  32.          1            1              31   52428800           512                1 NO  ACTIVE                     2015655 2018-06-09:11:41:25      2015826 2018-06-09:11:46:28           0
  33.          2            1              29   52428800           512                1 NO  INACTIVE                     2009327 2018-06-09:11:02:30      2013082 2018-06-09:11:12:41           0
  34.          3            1              32   52428800           512                1 NO  CURRENT                     2015826 2018-06-09:11:46:28   2.8147E+14   0

  35. SQL> alter system checkpoint;

  36. System altered.

  37. SQL> alter database clear logfile group 1;  

  38. Database altered.

  39. SQL> alter database clear  unarchived  logfile group 1;  

  40. Database altered.

  41. SQL>
复制代码
在上1Z0-053第7章之前,综合以前的知识,做一个备份:
  1. RMAN> backup section size 500M tag '9T_WHOLE_INCR0' incremental level 0 database  keep until time 'sysdate+60'    plus archivelog delete all input   ;
复制代码

PPT上的这几句话,目的就是省掉restore的时间:

  1. Perform fast recovery by performing the following steps:
  2. 1.        Take data files offline.
  3. 2.        Use the SWITCH TO ...  COPY command to switch to image copies.
  4. 3.        Recover data files.
  5. 4.        Bring data files online.
复制代码

三部曲:1.set newname。 2.restore。3.switch datafile(or database):

  1. run{
  2. set newname for datafile 5 to '/home/oracle/examplettio.dbf';
  3. restore datafile 5;
  4. switch datafile 5 to  copy;
  5. }
复制代码
为了测试磁带机的还原速度:
  1. run{
  2. set newname for datafile 5 to '/home/oracle/examplettio.dbf';
  3. restore datafile 5;
  4. delete datafilecopy '/home/oracle/examplettio.dbf';
  5. }
复制代码

下面做11a的实验:
  1. [oracle@station87 ~]$ rman target /  catalog u87/oracle_4U@rcat

  2. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 9 20:14:28 2018

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

  4. connected to target database: ORCL (DBID=1359978017)
  5. connected to recovery catalog database

  6. RMAN> backup section size 500M tag '9T_WHOLE_INCR0' incremental level 0 database  keep until time 'sysdate+60'    plus archivelog delete all input   ;


  7. Starting backup at 2018-06-09:20:15:51
  8. current log archived
  9. allocated channel: ORA_SBT_TAPE_1
  10. channel ORA_SBT_TAPE_1: SID=142 device type=SBT_TAPE
  11. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  12. allocated channel: ORA_SBT_TAPE_2
  13. channel ORA_SBT_TAPE_2: SID=17 device type=SBT_TAPE
  14. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  15. skipping archived log file +FRA/orcl/archivelog/2018_06_08/thread_1_seq_78.290.978237241; already backed up 1 time(s)
  16. skipping archived log file +FRA/orcl/archivelog/2018_06_08/thread_1_seq_79.291.978237573; already backed up 1 time(s)
  17. skipping archived log file +FRA/orcl/archivelog/2018_06_08/thread_1_seq_80.292.978237583; already backed up 1 time(s)
  18. channel ORA_SBT_TAPE_1: starting archived log backup set
  19. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  20. input archived log thread=1 sequence=48 RECID=44 STAMP=978227072
  21. input archived log thread=1 sequence=49 RECID=45 STAMP=978227072
  22. input archived log thread=1 sequence=50 RECID=46 STAMP=978227076
  23. input archived log thread=1 sequence=51 RECID=47 STAMP=978227079
  24. input archived log thread=1 sequence=52 RECID=48 STAMP=978227082
  25. input archived log thread=1 sequence=53 RECID=49 STAMP=978227085
  26. input archived log thread=1 sequence=54 RECID=50 STAMP=978227785
  27. input archived log thread=1 sequence=55 RECID=51 STAMP=978227786
  28. input archived log thread=1 sequence=56 RECID=52 STAMP=978227786
  29. input archived log thread=1 sequence=57 RECID=53 STAMP=978227790
  30. input archived log thread=1 sequence=58 RECID=54 STAMP=978227793
  31. input archived log thread=1 sequence=59 RECID=55 STAMP=978227794
  32. input archived log thread=1 sequence=60 RECID=56 STAMP=978228469
  33. input archived log thread=1 sequence=61 RECID=57 STAMP=978228470
  34. input archived log thread=1 sequence=62 RECID=58 STAMP=978228470
  35. input archived log thread=1 sequence=63 RECID=59 STAMP=978228473
  36. input archived log thread=1 sequence=64 RECID=60 STAMP=978228476
  37. input archived log thread=1 sequence=65 RECID=61 STAMP=978228477
  38. input archived log thread=1 sequence=66 RECID=62 STAMP=978065947
  39. input archived log thread=1 sequence=67 RECID=63 STAMP=978120772
  40. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:20:16:08
  41. channel ORA_SBT_TAPE_2: starting archived log backup set
  42. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
  43. input archived log thread=1 sequence=68 RECID=64 STAMP=978195181
  44. input archived log thread=1 sequence=69 RECID=65 STAMP=978236524
  45. input archived log thread=1 sequence=70 RECID=66 STAMP=978236531
  46. input archived log thread=1 sequence=71 RECID=67 STAMP=978236625
  47. input archived log thread=1 sequence=72 RECID=68 STAMP=978236646
  48. input archived log thread=1 sequence=73 RECID=69 STAMP=978236658
  49. input archived log thread=1 sequence=74 RECID=70 STAMP=978236668
  50. input archived log thread=1 sequence=75 RECID=71 STAMP=978237207
  51. input archived log thread=1 sequence=76 RECID=72 STAMP=978237224
  52. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-06-09:20:16:08
  53. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:20:17:33
  54. piece handle=3qt51pc7_1_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  55. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:25
  56. channel ORA_SBT_TAPE_1: deleting archived log(s)
  57. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_48.278.978227071 RECID=44 STAMP=978227072
  58. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_49.275.978227073 RECID=45 STAMP=978227072
  59. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_50.277.978227077 RECID=46 STAMP=978227076
  60. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_51.276.978227079 RECID=47 STAMP=978227079
  61. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_52.274.978227083 RECID=48 STAMP=978227082
  62. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_53.273.978227085 RECID=49 STAMP=978227085
  63. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_54.272.978227785 RECID=50 STAMP=978227785
  64. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_55.271.978227787 RECID=51 STAMP=978227786
  65. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_56.270.978227787 RECID=52 STAMP=978227786
  66. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_57.267.978227789 RECID=53 STAMP=978227790
  67. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_58.260.978227793 RECID=54 STAMP=978227793
  68. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_59.269.978227793 RECID=55 STAMP=978227794
  69. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_60.287.978228469 RECID=56 STAMP=978228469
  70. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_61.286.978228471 RECID=57 STAMP=978228470
  71. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_62.285.978228471 RECID=58 STAMP=978228470
  72. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_63.284.978228473 RECID=59 STAMP=978228473
  73. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_64.283.978228477 RECID=60 STAMP=978228476
  74. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_65.282.978228477 RECID=61 STAMP=978228477
  75. archived log file name=+FRA/orcl/archivelog/2018_06_06/thread_1_seq_66.281.978065947 RECID=62 STAMP=978065947
  76. archived log file name=+FRA/orcl/archivelog/2018_06_06/thread_1_seq_67.280.978120771 RECID=63 STAMP=978120772
  77. channel ORA_SBT_TAPE_1: starting archived log backup set
  78. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  79. input archived log thread=1 sequence=77 RECID=73 STAMP=978237232
  80. input archived log thread=1 sequence=81 RECID=77 STAMP=978239427
  81. input archived log thread=1 sequence=82 RECID=78 STAMP=978315691
  82. input archived log thread=1 sequence=83 RECID=79 STAMP=978328977
  83. input archived log thread=1 sequence=84 RECID=80 STAMP=978369678
  84. input archived log thread=1 sequence=85 RECID=81 STAMP=978375538
  85. input archived log thread=1 sequence=86 RECID=82 STAMP=978375701
  86. input archived log thread=1 sequence=87 RECID=83 STAMP=978375907
  87. input archived log thread=1 sequence=88 RECID=84 STAMP=978375969
  88. input archived log thread=1 sequence=89 RECID=85 STAMP=978376142
  89. input archived log thread=1 sequence=90 RECID=86 STAMP=978380152
  90. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:20:17:37
  91. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-06-09:20:17:37
  92. piece handle=3rt51pc8_1_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  93. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:29
  94. channel ORA_SBT_TAPE_2: deleting archived log(s)
  95. archived log file name=+FRA/orcl/archivelog/2018_06_07/thread_1_seq_68.279.978195181 RECID=64 STAMP=978195181
  96. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_69.268.978236523 RECID=65 STAMP=978236524
  97. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_70.262.978236529 RECID=66 STAMP=978236531
  98. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_71.263.978236623 RECID=67 STAMP=978236625
  99. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_72.266.978236639 RECID=68 STAMP=978236646
  100. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_73.265.978236653 RECID=69 STAMP=978236658
  101. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_74.264.978236663 RECID=70 STAMP=978236668
  102. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_75.261.978237207 RECID=71 STAMP=978237207
  103. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_76.288.978237221 RECID=72 STAMP=978237224
  104. channel ORA_SBT_TAPE_2: deleting archived log(s)
  105. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_78.290.978237241 RECID=74 STAMP=978237243
  106. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_79.291.978237573 RECID=75 STAMP=978237574
  107. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_80.292.978237583 RECID=76 STAMP=978237586
  108. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:20:18:25
  109. piece handle=3st51pf1_1_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  110. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:48
  111. channel ORA_SBT_TAPE_1: deleting archived log(s)
  112. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_77.289.978237229 RECID=73 STAMP=978237232
  113. archived log file name=+FRA/orcl/archivelog/2018_06_08/thread_1_seq_81.293.978239425 RECID=77 STAMP=978239427
  114. archived log file name=+FRA/orcl/archivelog/2018_06_09/thread_1_seq_82.296.978315691 RECID=78 STAMP=978315691
  115. archived log file name=+FRA/orcl/archivelog/2018_06_09/thread_1_seq_83.312.978328975 RECID=79 STAMP=978328977
  116. archived log file name=+FRA/orcl/archivelog/2018_06_09/thread_1_seq_84.317.978369677 RECID=80 STAMP=978369678
  117. archived log file name=+FRA/orcl/archivelog/2018_06_09/thread_1_seq_85.323.978375539 RECID=81 STAMP=978375538
  118. archived log file name=+FRA/orcl/archivelog/2018_06_09/thread_1_seq_86.325.978375701 RECID=82 STAMP=978375701
  119. archived log file name=+FRA/orcl/archivelog/2018_06_09/thread_1_seq_87.326.978375907 RECID=83 STAMP=978375907
  120. archived log file name=+FRA/orcl/archivelog/2018_06_09/thread_1_seq_88.327.978375969 RECID=84 STAMP=978375969
  121. archived log file name=+FRA/orcl/archivelog/2018_06_09/thread_1_seq_89.328.978376143 RECID=85 STAMP=978376142
  122. archived log file name=+FRA/orcl/archivelog/2018_06_09/thread_1_seq_90.330.978380153 RECID=86 STAMP=978380152
  123. Finished backup at 2018-06-09:20:18:27

  124. Starting backup at 2018-06-09:20:18:27
  125. current log archived

  126. using channel ORA_SBT_TAPE_1
  127. using channel ORA_SBT_TAPE_2
  128. backup will be obsolete on date 2018-08-08:20:18:29
  129. archived logs required to recover from this backup will be backed up
  130. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  131. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  132. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  133. backing up blocks 1 through 64000
  134. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:20:18:30
  135. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  136. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  137. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.832197065
  138. backing up blocks 1 through 64000
  139. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-06-09:20:18:31
  140. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:20:19:36
  141. piece handle=3tt51pgm_1_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  142. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:06
  143. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  144. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  145. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  146. backing up blocks 64001 through 88320
  147. channel ORA_SBT_TAPE_1: starting piece 2 at 2018-06-09:20:19:36
  148. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-06-09:20:19:51
  149. piece handle=3ut51pgm_1_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  150. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:20
  151. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  152. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  153. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.832197065
  154. backing up blocks 64001 through 74240
  155. channel ORA_SBT_TAPE_2: starting piece 2 at 2018-06-09:20:19:51
  156. channel ORA_SBT_TAPE_1: finished piece 2 at 2018-06-09:20:20:16
  157. piece handle=3tt51pgm_2_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  158. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:40
  159. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  160. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  161. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.832197065
  162. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:20:20:16
  163. channel ORA_SBT_TAPE_2: finished piece 2 at 2018-06-09:20:20:41
  164. piece handle=3ut51pgm_2_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  165. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:50
  166. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  167. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  168. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.832197353
  169. input datafile file number=00007 name=+DATA/orcl/datafile/tbsfda.268.978236837
  170. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.978228669
  171. input datafile file number=00006 name=+DATA/orcl/datafile/tbsfda.267.978234227
  172. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-06-09:20:20:42
  173. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:20:20:57
  174. piece handle=41t51pk0_1_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  175. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:41
  176. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-06-09:20:21:17
  177. piece handle=42t51pkp_1_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  178. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:35

  179. using channel ORA_SBT_TAPE_1
  180. using channel ORA_SBT_TAPE_2
  181. backup will be obsolete on date 2018-08-08:20:21:17
  182. archived logs required to recover from this backup will be backed up
  183. channel ORA_SBT_TAPE_1: starting full datafile backup set
  184. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  185. including current SPFILE in backup set
  186. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:20:21:17
  187. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:20:21:52
  188. piece handle=43t51plt_1_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  189. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35

  190. current log archived
  191. using channel ORA_SBT_TAPE_1
  192. using channel ORA_SBT_TAPE_2
  193. backup will be obsolete on date 2018-08-08:20:21:53
  194. archived logs required to recover from this backup will be backed up
  195. channel ORA_SBT_TAPE_1: starting archived log backup set
  196. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  197. input archived log thread=1 sequence=92 RECID=88 STAMP=978380512
  198. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:20:21:53
  199. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:20:22:28
  200. piece handle=44t51pn1_1_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  201. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35

  202. using channel ORA_SBT_TAPE_1
  203. using channel ORA_SBT_TAPE_2
  204. backup will be obsolete on date 2018-08-08:20:22:29
  205. archived logs required to recover from this backup will be backed up
  206. channel ORA_SBT_TAPE_1: starting full datafile backup set
  207. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  208. including current control file in backup set
  209. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:20:22:30
  210. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:20:23:05
  211. piece handle=45t51po5_1_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  212. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
  213. Finished backup at 2018-06-09:20:23:05

  214. Starting backup at 2018-06-09:20:23:05
  215. current log archived
  216. using channel ORA_SBT_TAPE_1
  217. using channel ORA_SBT_TAPE_2
  218. channel ORA_SBT_TAPE_1: starting archived log backup set
  219. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  220. input archived log thread=1 sequence=93 RECID=89 STAMP=978380585
  221. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:20:23:06
  222. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:20:23:51
  223. piece handle=46t51ppa_1_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  224. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45
  225. channel ORA_SBT_TAPE_1: deleting archived log(s)
  226. archived log file name=+FRA/orcl/archivelog/2018_06_09/thread_1_seq_93.327.978380585 RECID=89 STAMP=978380585
  227. Finished backup at 2018-06-09:20:23:51

  228. RMAN> backup  tag '10T_WHOLE_INCR1' incremental level 1 database  keep until time 'sysdate+60'  ;
  229. Starting backup at 2018-06-09:23:44:16
  230. starting full resync of recovery catalog
  231. full resync complete
  232. current log archived

  233. using channel ORA_SBT_TAPE_1
  234. using channel ORA_SBT_TAPE_2
  235. backup will be obsolete on date 2018-08-08:23:44:20
  236. archived logs required to recover from this backup will be backed up
  237. no parent backup or copy of datafile 1 found
  238. no parent backup or copy of datafile 4 found
  239. no parent backup or copy of datafile 2 found
  240. no parent backup or copy of datafile 5 found
  241. no parent backup or copy of datafile 3 found
  242. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  243. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  244. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.832197065
  245. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.832197353
  246. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.832197065
  247. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:23:44:20
  248. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  249. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  250. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  251. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.978228669
  252. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-06-09:23:44:20
  253. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:23:46:12
  254. piece handle=47t525ik_1_1 tag=10T_WHOLE_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
  255. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:52
  256. channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set
  257. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  258. input datafile file number=00007 name=+DATA/orcl/datafile/tbsfda.268.978236837
  259. input datafile file number=00006 name=+DATA/orcl/datafile/tbsfda.267.978234227
  260. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:23:46:12
  261. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-06-09:23:46:27
  262. piece handle=48t525ik_1_1 tag=10T_WHOLE_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
  263. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:02:07
  264. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:23:46:57
  265. piece handle=49t525m4_1_1 tag=10T_WHOLE_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
  266. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45

  267. using channel ORA_SBT_TAPE_1
  268. using channel ORA_SBT_TAPE_2
  269. backup will be obsolete on date 2018-08-08:23:46:58
  270. archived logs required to recover from this backup will be backed up
  271. channel ORA_SBT_TAPE_1: starting full datafile backup set
  272. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  273. including current SPFILE in backup set
  274. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:23:46:58
  275. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:23:47:43
  276. piece handle=4at525ni_1_1 tag=10T_WHOLE_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
  277. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45

  278. current log archived
  279. using channel ORA_SBT_TAPE_1
  280. using channel ORA_SBT_TAPE_2
  281. backup will be obsolete on date 2018-08-08:23:47:44
  282. archived logs required to recover from this backup will be backed up
  283. channel ORA_SBT_TAPE_1: starting archived log backup set
  284. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  285. input archived log thread=1 sequence=95 RECID=91 STAMP=978392863
  286. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:23:47:44
  287. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:23:48:19
  288. piece handle=4bt525p0_1_1 tag=10T_WHOLE_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
  289. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35

  290. using channel ORA_SBT_TAPE_1
  291. using channel ORA_SBT_TAPE_2
  292. backup will be obsolete on date 2018-08-08:23:48:20
  293. archived logs required to recover from this backup will be backed up
  294. channel ORA_SBT_TAPE_1: starting full datafile backup set
  295. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  296. including current control file in backup set
  297. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:23:48:21
  298. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:23:48:56
  299. piece handle=4ct525q4_1_1 tag=10T_WHOLE_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
  300. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
  301. Finished backup at 2018-06-09:23:48:56

  302. RMAN> exit


  303. Recovery Manager complete.
  304. [oracle@station87 ~]$ rman target /  catalog u87/oracle_4U@rcat

  305. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 9 23:49:12 2018

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

  307. connected to target database: ORCL (DBID=1359978017)
  308. connected to recovery catalog database

  309. RMAN> resync catalog;

  310. starting full resync of recovery catalog
  311. full resync complete

  312. RMAN>
复制代码

db.png



回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2018-6-23 00:46 , Processed in 0.262322 second(s), 27 queries .

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