开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › SECOUG活动（活动结束图标变灰，但是欢迎继续发帖！） › SECOUG数据库管理SIG › 活动第25/26次（2018-06-09星期六上下午）
返回列表 发新帖
查看: 2167|回复: 0

活动第25/26次（2018-06-09星期六上下午）

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

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

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

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

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

  9. RMAN> list archivelog all;

  11. using target database control file instead of recovery catalog
  12. List of Archived Log Copies for database with db_unique_name ORCL
  13. =====================================================================

  15. Key     Thrd Seq     S Low Time           
  16. ------- ---- ------- - -------------------
  17. 44      1    48      A 2018-06-08:00:44:31
  18.         Name: +FRA/orcl/archivelog/2018_06_08/thread_1_seq_48.278.978227071

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

  131. Starting backup at 2018-06-09:17:35:40
  132. allocated channel: ORA_SBT_TAPE_1
  133. channel ORA_SBT_TAPE_1: SID=10 device type=SBT_TAPE
  134. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  135. allocated channel: ORA_SBT_TAPE_2
  136. channel ORA_SBT_TAPE_2: SID=12 device type=SBT_TAPE
  137. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  138. channel ORA_SBT_TAPE_1: starting archived log backup set
  139. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  140. input archived log thread=1 sequence=78 RECID=74 STAMP=978237243
  141. input archived log thread=1 sequence=79 RECID=75 STAMP=978237574
  142. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:17:35:50
  143. channel ORA_SBT_TAPE_2: starting archived log backup set
  144. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
  145. input archived log thread=1 sequence=80 RECID=76 STAMP=978237586
  146. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-06-09:17:35:50
  147. RMAN-00571: ===========================================================
  148. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  149. RMAN-00571: ===========================================================
  150. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 06/09/2018 17:35:50
  151. ORA-19914: unable to encrypt backup
  152. ORA-28365: wallet is not open

  154. RMAN> show all;

  156. RMAN configuration parameters for database with db_unique_name ORCL are:
  157. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  158. CONFIGURE BACKUP OPTIMIZATION ON;
  159. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  160. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  161. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  162. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  163. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  164. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  165. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  166. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  167. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  168. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  169. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
  170. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
  171. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  172. CONFIGURE ENCRYPTION FOR DATABASE ON;
  173. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  174. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  175. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  176. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  178. RMAN> CONFIGURE ENCRYPTION FOR DATABASE  off;

  180. old RMAN configuration parameters:
  181. CONFIGURE ENCRYPTION FOR DATABASE ON;
  182. new RMAN configuration parameters:
  183. CONFIGURE ENCRYPTION FOR DATABASE OFF;
  184. new RMAN configuration parameters are successfully stored

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

  188. Starting backup at 2018-06-09:17:36:08
  189. using channel ORA_SBT_TAPE_1
  190. using channel ORA_SBT_TAPE_2
  191. channel ORA_SBT_TAPE_1: starting archived log backup set
  192. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  193. input archived log thread=1 sequence=78 RECID=74 STAMP=978237243
  194. input archived log thread=1 sequence=79 RECID=75 STAMP=978237574
  195. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:17:36:08
  196. channel ORA_SBT_TAPE_2: starting archived log backup set
  197. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
  198. input archived log thread=1 sequence=80 RECID=76 STAMP=978237586
  199. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-06-09:17:36:08
  200. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:17:37:23
  201. piece handle=2st51g08_1_1 tag=1T_ARCH78-80 comment=API Version 2.0,MMS Version 10.3.0.2
  202. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:15
  203. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-06-09:17:37:33
  204. piece handle=2tt51g08_1_1 tag=1T_ARCH78-80 comment=API Version 2.0,MMS Version 10.3.0.2
  205. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:25
  206. Finished backup at 2018-06-09:17:37:33

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

  212. RMAN> list backup;


  215. List of Backup Sets
  216. ===================


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

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

  238. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  239. ------- ---- -- ---------- ----------- ------------ -------------------
  240. 67      Incr 0  86.50M     SBT_TAPE    00:00:53     2018-06-08:01:13:00
  241.         BP Key: 73   Status: AVAILABLE  Compressed: YES  Tag: 2TC_SYSAUX_INCR0
  242.         Handle: 2et4t1v7_1_1   Media: station87-000008
  243.   List of Datafiles in backup set 67
  244.   File LV Type Ckp SCN    Ckp Time            Name
  245.   ---- -- ---- ---------- ------------------- ----
  246.   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

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

  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

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

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

  291.   List of Archived Logs in backup set 73
  292.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  293.   ---- ------- ---------- ------------------- ---------- ---------
  294.   1    78      1323993    2018-06-08:04:33:46 1328678    2018-06-08:04:34:01
  295.   1    79      1328678    2018-06-08:04:34:01 1340398    2018-06-08:04:39:31

  297. BS Key  Size       Device Type Elapsed Time Completion Time   
  298. ------- ---------- ----------- ------------ -------------------
  299. 74      46.00M     SBT_TAPE    00:01:20     2018-06-09:17:37:28
  300.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  301.         Handle: 2tt51g08_1_1   Media: station87-000009

  303.   List of Archived Logs in backup set 74
  304.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  305.   ---- ------- ---------- ------------------- ---------- ---------
  306.   1    80      1340398    2018-06-08:04:39:31 1344895    2018-06-08:04:39:42

  308. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  309. ------- ---- -- ---------- ----------- ------------ -------------------
  310. 75      Full    10.00M     SBT_TAPE    00:00:36     2018-06-09:17:38:09
  311.         BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T173733
  312.         Handle: c-1359978017-20180609-00   Media: station87-000008
  313.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  314.   SPFILE db_unique_name: ORCL
  315.   Control File Included: Ckp SCN: 1408511      Ckp time: 2018-06-09:17:37:33

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

  319. Starting backup at 2018-06-09:17:42:44
  320. using channel ORA_SBT_TAPE_1
  321. using channel ORA_SBT_TAPE_2
  322. channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set
  323. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  324. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.978228669
  325. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:17:42:44
  326. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:17:43:39
  327. piece handle=2vt51gck_1_1 tag=2T_USERS_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
  328. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:55
  329. Finished backup at 2018-06-09:17:43:39

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

  335. RMAN> list backup of tablespace users;


  338. List of Backup Sets
  339. ===================


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

  352. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  353. ------- ---- -- ---------- ----------- ------------ -------------------
  354. 76      Incr 1  30.50M     SBT_TAPE    00:00:48     2018-06-09:17:43:32
  355.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: 2T_USERS_INCR1
  356.         Handle: 2vt51gck_1_1   Media: station87-000009
  357.   List of Datafiles in backup set 76
  358.   File LV Type Ckp SCN    Ckp Time            Name
  359.   ---- -- ---- ---------- ------------------- ----
  360.   4    1  Incr 1408699    2018-06-09:17:42:44 +DATA/orcl/datafile/users.259.978228669

  362. RMAN> report need backup  incremental  1;  

  364. Report of files that need more than 1 incrementals during recovery
  365. File Incrementals Name
  366. ---- ------------ ----------------------------------------------

  368. RMAN> report need backup  incremental  0;

  370. Report of files that need more than 0 incrementals during recovery
  371. File Incrementals Name
  372. ---- ------------ ----------------------------------------------
  373. 4    1            +DATA/orcl/datafile/users.259.978228669

  375. RMAN> report need backup  incremental  1;

  377. Report of files that need more than 1 incrementals during recovery
  378. File Incrementals Name
  379. ---- ------------ ----------------------------------------------

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

  383. Starting backup at 2018-06-09:17:46:30
  384. using channel ORA_SBT_TAPE_1
  385. using channel ORA_SBT_TAPE_2
  386. channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set
  387. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  388. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.978228669
  389. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:17:46:30
  390. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:17:47:15
  391. piece handle=31t51gjm_1_1 tag=3T_USERS_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
  392. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45
  393. Finished backup at 2018-06-09:17:47:15

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

  399. RMAN>
复制代码

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

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

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

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

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

  19. RMAN> report need backup  incremental  1;

  21. Report of files that need more than 1 incrementals during recovery
  22. File Incrementals Name
  23. ---- ------------ ----------------------------------------------

  25. RMAN> report need backup  incremental  0;

  27. Report of files that need more than 0 incrementals during recovery
  28. File Incrementals Name
  29. ---- ------------ ----------------------------------------------
  30. 4    1            +DATA/orcl/datafile/users.259.978228669

  32. RMAN>
复制代码

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

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

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

  19. RMAN> report need backup  incremental  1;

  21. Report of files that need more than 1 incrementals during recovery
  22. File Incrementals Name
  23. ---- ------------ ----------------------------------------------

  25. RMAN> report need backup  incremental  0;

  27. Report of files that need more than 0 incrementals during recovery
  28. File Incrementals Name
  29. ---- ------------ ----------------------------------------------
  30. 4    1            +DATA/orcl/datafile/users.259.978228669
复制代码

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

  3. Database altered.

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

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

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

  7. SQL> conn / as sysdba
  8. Connected.
  9. SQL> set linesize 1000
  10. SQL> select  * from v$block_change_tracking;

  12. STATUS           FILENAME                                                                                                                          BYTES
  13. ---------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------
  14. 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> }

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

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

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

  24. RMAN> list backup;


  27. List of Backup Sets
  28. ===================


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

  41. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  42. ------- ---- -- ---------- ----------- ------------ -------------------
  43. 66      Full    10.00M     SBT_TAPE    00:00:39     2018-06-08:01:09:01
  44.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T010822
  45.         Handle: c-1359978017-20180608-07   Media: station87-000008
  46.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  47.   SPFILE db_unique_name: ORCL
  48.   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. 67      Incr 0  86.50M     SBT_TAPE    00:00:53     2018-06-08:01:13:00
  53.         BP Key: 73   Status: AVAILABLE  Compressed: YES  Tag: 2TC_SYSAUX_INCR0
  54.         Handle: 2et4t1v7_1_1   Media: station87-000008
  55.   List of Datafiles in backup set 67
  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

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

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

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

  88. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  89. ------- ---- -- ---------- ----------- ------------ -------------------
  90. 72      Full    10.00M     SBT_TAPE    00:00:37     2018-06-08:02:05:22
  91.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T020445
  92.         Handle: c-1359978017-20180608-0a   Media: station87-000008
  93.   SPFILE Included: Modification time: 2018-06-08:02:04:15
  94.   SPFILE db_unique_name: ORCL
  95.   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

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

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

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

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

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

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

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

  158. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  159. ------- ---- -- ---------- ----------- ------------ -------------------
  160. 79      Full    10.00M     SBT_TAPE    00:00:37     2018-06-09:17:47:52
  161.         BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174715
  162.         Handle: c-1359978017-20180609-02   Media: station87-000009
  163.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  164.   SPFILE db_unique_name: ORCL
  165.   Control File Included: Ckp SCN: 1408966      Ckp time: 2018-06-09:17:47:15

  167. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  168. ------- ---- -- ---------- ----------- ------------ -------------------
  169. 80      Incr 1  30.50M     SBT_TAPE    00:00:47     2018-06-09:17:55:25
  170.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1C
  171.         Handle: 33t51h2u_1_1   Media: station87-000009
  172.   List of Datafiles in backup set 80
  173.   File LV Type Ckp SCN    Ckp Time            Name
  174.   ---- -- ---- ---------- ------------------- ----
  175.   4    1  Incr 1409298    2018-06-09:17:54:38 +DATA/orcl/datafile/users.259.978228669

  177. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  178. ------- ---- -- ---------- ----------- ------------ -------------------
  179. 81      Full    10.00M     SBT_TAPE    00:00:28     2018-06-09:17:56:01
  180.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T175533
  181.         Handle: c-1359978017-20180609-03   Media: station87-000009
  182.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  183.   SPFILE db_unique_name: ORCL
  184.   Control File Included: Ckp SCN: 1409338      Ckp time: 2018-06-09:17:55:33

  186. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  187. ------- ---- -- ---------- ----------- ------------ -------------------
  188. 82      Full    33.70M     DISK        00:00:02     2018-06-09:18:14:10
  189.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181408
  190.         Piece Name: +FRA/orcl/backupset/2018_06_09/nnndf0_tag20180609t181408_0.321.978372849
  191.   List of Datafiles in backup set 82
  192.   File LV Type Ckp SCN    Ckp Time            Name
  193.   ---- -- ---- ---------- ------------------- ----
  194.   4       Full 1410584    2018-06-09:18:14:08 +DATA/orcl/datafile/users.259.978228669

  196. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  197. ------- ---- -- ---------- ----------- ------------ -------------------
  198. 83      Full    9.86M      DISK        00:00:01     2018-06-09:18:14:12
  199.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181411
  200.         Piece Name: +FRA/orcl/autobackup/2018_06_09/s_978372851.322.978372853
  201.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  202.   SPFILE db_unique_name: ORCL
  203.   Control File Included: Ckp SCN: 1410592      Ckp time: 2018-06-09:18:14:11

  205. RMAN> backup backupset 82 force delete input;

  207. Starting backup at 2018-06-09:18:15:15
  208. allocated channel: ORA_SBT_TAPE_1
  209. channel ORA_SBT_TAPE_1: SID=72 device type=SBT_TAPE
  210. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  211. allocated channel: ORA_SBT_TAPE_2
  212. channel ORA_SBT_TAPE_2: SID=197 device type=SBT_TAPE
  213. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  214. channel ORA_SBT_TAPE_1: input backup set: count=101, stamp=978372848, piece=1
  215. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:18:15:26
  216. channel ORA_SBT_TAPE_1: backup piece +FRA/orcl/backupset/2018_06_09/nnndf0_tag20180609t181408_0.321.978372849
  217. piece handle=35t51i7g_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  218. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:18:16:21
  219. channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:00:55
  220. deleted backup piece
  221. backup piece handle=+FRA/orcl/backupset/2018_06_09/nnndf0_tag20180609t181408_0.321.978372849 RECID=88 STAMP=978372848
  222. Finished backup at 2018-06-09:18:16:21

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

  228. RMAN> show all;

  230. RMAN configuration parameters for database with db_unique_name ORCL are:
  231. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  232. CONFIGURE BACKUP OPTIMIZATION ON;
  233. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  234. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  235. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  236. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  237. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  238. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  239. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  240. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  241. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  242. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  243. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
  244. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
  245. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  246. CONFIGURE ENCRYPTION FOR DATABASE OFF;
  247. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  248. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  249. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  250. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  252. RMAN> list backup;


  255. List of Backup Sets
  256. ===================


  259. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  260. ------- ---- -- ---------- ----------- ------------ -------------------
  261. 65      Incr 0  436.25M    SBT_TAPE    00:01:00     2018-06-08:01:08:17
  262.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSAUX_INCR0
  263.         Handle: 2ct4t1m5_1_1   Media: station87-000008
  264.   List of Datafiles in backup set 65
  265.   File LV Type Ckp SCN    Ckp Time            Name
  266.   ---- -- ---- ---------- ------------------- ----
  267.   2    0  Incr 1155660    2018-06-08:01:07:17 +DATA/orcl/datafile/sysaux.257.832197065

  269. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  270. ------- ---- -- ---------- ----------- ------------ -------------------
  271. 66      Full    10.00M     SBT_TAPE    00:00:39     2018-06-08:01:09:01
  272.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T010822
  273.         Handle: c-1359978017-20180608-07   Media: station87-000008
  274.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  275.   SPFILE db_unique_name: ORCL
  276.   Control File Included: Ckp SCN: 1155709      Ckp time: 2018-06-08:01:08:22

  278. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  279. ------- ---- -- ---------- ----------- ------------ -------------------
  280. 67      Incr 0  86.50M     SBT_TAPE    00:00:53     2018-06-08:01:13:00
  281.         BP Key: 73   Status: AVAILABLE  Compressed: YES  Tag: 2TC_SYSAUX_INCR0
  282.         Handle: 2et4t1v7_1_1   Media: station87-000008
  283.   List of Datafiles in backup set 67
  284.   File LV Type Ckp SCN    Ckp Time            Name
  285.   ---- -- ---- ---------- ------------------- ----
  286.   2    0  Incr 1155986    2018-06-08:01:12:07 +DATA/orcl/datafile/sysaux.257.832197065

  288. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  289. ------- ---- -- ---------- ----------- ------------ -------------------
  290. 68      Full    10.00M     SBT_TAPE    00:00:41     2018-06-08:01:13:43
  291.         BP Key: 74   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T011302
  292.         Handle: c-1359978017-20180608-08   Media: station87-000008
  293.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  294.   SPFILE db_unique_name: ORCL
  295.   Control File Included: Ckp SCN: 1156051      Ckp time: 2018-06-08:01:13:02

  297. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  298. ------- ---- -- ---------- ----------- ------------ -------------------
  299. 70      Full    10.00M     SBT_TAPE    00:00:27     2018-06-08:01:42:19
  300.         BP Key: 76   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T014152
  301.         Handle: c-1359978017-20180608-09   Media: station87-000008
  302.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  303.   SPFILE db_unique_name: ORCL
  304.   Control File Included: Ckp SCN: 1157970      Ckp time: 2018-06-08:01:41:52

  306. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  307. ------- ---- -- ---------- ----------- ------------ -------------------
  308. 71      Incr 0  3.50M      SBT_TAPE    00:00:56     2018-06-08:02:04:36
  309.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: 4TEDUAL_USERS_INCR0
  310.         Handle: 2kt4t4vs_1_1   Media: station87-000008
  311.   List of Datafiles in backup set 71
  312.   File LV Type Ckp SCN    Ckp Time            Name
  313.   ---- -- ---- ---------- ------------------- ----
  314.   4    0  Incr 1160195    2018-06-08:02:03:40 +DATA/orcl/datafile/users.259.978228669

  316. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  317. ------- ---- -- ---------- ----------- ------------ -------------------
  318. 72      Full    10.00M     SBT_TAPE    00:00:37     2018-06-08:02:05:22
  319.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T020445
  320.         Handle: c-1359978017-20180608-0a   Media: station87-000008
  321.   SPFILE Included: Modification time: 2018-06-08:02:04:15
  322.   SPFILE db_unique_name: ORCL
  323.   Control File Included: Ckp SCN: 1160247      Ckp time: 2018-06-08:02:04:45

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

  331.   List of Archived Logs in backup set 73
  332.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  333.   ---- ------- ---------- ------------------- ---------- ---------
  334.   1    78      1323993    2018-06-08:04:33:46 1328678    2018-06-08:04:34:01
  335.   1    79      1328678    2018-06-08:04:34:01 1340398    2018-06-08:04:39:31

  337. BS Key  Size       Device Type Elapsed Time Completion Time   
  338. ------- ---------- ----------- ------------ -------------------
  339. 74      46.00M     SBT_TAPE    00:01:20     2018-06-09:17:37:28
  340.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  341.         Handle: 2tt51g08_1_1   Media: station87-000009

  343.   List of Archived Logs in backup set 74
  344.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  345.   ---- ------- ---------- ------------------- ---------- ---------
  346.   1    80      1340398    2018-06-08:04:39:31 1344895    2018-06-08:04:39:42

  348. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  349. ------- ---- -- ---------- ----------- ------------ -------------------
  350. 75      Full    10.00M     SBT_TAPE    00:00:36     2018-06-09:17:38:09
  351.         BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T173733
  352.         Handle: c-1359978017-20180609-00   Media: station87-000008
  353.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  354.   SPFILE db_unique_name: ORCL
  355.   Control File Included: Ckp SCN: 1408511      Ckp time: 2018-06-09:17:37:33

  357. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  358. ------- ---- -- ---------- ----------- ------------ -------------------
  359. 76      Incr 1  30.50M     SBT_TAPE    00:00:48     2018-06-09:17:43:32
  360.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: 2T_USERS_INCR1
  361.         Handle: 2vt51gck_1_1   Media: station87-000009
  362.   List of Datafiles in backup set 76
  363.   File LV Type Ckp SCN    Ckp Time            Name
  364.   ---- -- ---- ---------- ------------------- ----
  365.   4    1  Incr 1408699    2018-06-09:17:42:44 +DATA/orcl/datafile/users.259.978228669

  367. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  368. ------- ---- -- ---------- ----------- ------------ -------------------
  369. 77      Full    10.00M     SBT_TAPE    00:00:42     2018-06-09:17:44:21
  370.         BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174339
  371.         Handle: c-1359978017-20180609-01   Media: station87-000009
  372.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  373.   SPFILE db_unique_name: ORCL
  374.   Control File Included: Ckp SCN: 1408731      Ckp time: 2018-06-09:17:43:39

  376. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  377. ------- ---- -- ---------- ----------- ------------ -------------------
  378. 78      Incr 1  256.00K    SBT_TAPE    00:00:35     2018-06-09:17:47:05
  379.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: 3T_USERS_INCR1
  380.         Handle: 31t51gjm_1_1   Media: station87-000009
  381.   List of Datafiles in backup set 78
  382.   File LV Type Ckp SCN    Ckp Time            Name
  383.   ---- -- ---- ---------- ------------------- ----
  384.   4    1  Incr 1408937    2018-06-09:17:46:30 +DATA/orcl/datafile/users.259.978228669

  386. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  387. ------- ---- -- ---------- ----------- ------------ -------------------
  388. 79      Full    10.00M     SBT_TAPE    00:00:37     2018-06-09:17:47:52
  389.         BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174715
  390.         Handle: c-1359978017-20180609-02   Media: station87-000009
  391.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  392.   SPFILE db_unique_name: ORCL
  393.   Control File Included: Ckp SCN: 1408966      Ckp time: 2018-06-09:17:47:15

  395. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  396. ------- ---- -- ---------- ----------- ------------ -------------------
  397. 80      Incr 1  30.50M     SBT_TAPE    00:00:47     2018-06-09:17:55:25
  398.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1C
  399.         Handle: 33t51h2u_1_1   Media: station87-000009
  400.   List of Datafiles in backup set 80
  401.   File LV Type Ckp SCN    Ckp Time            Name
  402.   ---- -- ---- ---------- ------------------- ----
  403.   4    1  Incr 1409298    2018-06-09:17:54:38 +DATA/orcl/datafile/users.259.978228669

  405. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  406. ------- ---- -- ---------- ----------- ------------ -------------------
  407. 81      Full    10.00M     SBT_TAPE    00:00:28     2018-06-09:17:56:01
  408.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T175533
  409.         Handle: c-1359978017-20180609-03   Media: station87-000009
  410.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  411.   SPFILE db_unique_name: ORCL
  412.   Control File Included: Ckp SCN: 1409338      Ckp time: 2018-06-09:17:55:33

  414. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  415. ------- ---- -- ---------- ----------- ------------ -------------------
  416. 82      Full    33.70M     SBT_TAPE    00:00:02     2018-06-09:18:14:10
  417.         BP Key: 90   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181408
  418.         Handle: 35t51i7g_1_2   Media: station87-000009
  419.   List of Datafiles in backup set 82
  420.   File LV Type Ckp SCN    Ckp Time            Name
  421.   ---- -- ---- ---------- ------------------- ----
  422.   4       Full 1410584    2018-06-09:18:14:08 +DATA/orcl/datafile/users.259.978228669

  424. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  425. ------- ---- -- ---------- ----------- ------------ -------------------
  426. 83      Full    9.86M      DISK        00:00:01     2018-06-09:18:14:12
  427.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181411
  428.         Piece Name: +FRA/orcl/autobackup/2018_06_09/s_978372851.322.978372853
  429.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  430.   SPFILE db_unique_name: ORCL
  431.   Control File Included: Ckp SCN: 1410592      Ckp time: 2018-06-09:18:14:11

  433. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  434. ------- ---- -- ---------- ----------- ------------ -------------------
  435. 84      Full    10.00M     SBT_TAPE    00:00:38     2018-06-09:18:16:59
  436.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181621
  437.         Handle: c-1359978017-20180609-05   Media: station87-000009
  438.   SPFILE Included: Modification time: 2018-06-09:18:15:20
  439.   SPFILE db_unique_name: ORCL
  440.   Control File Included: Ckp SCN: 1410754      Ckp time: 2018-06-09:18:16:21

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

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

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

  37. released channel: c1

  39. RMAN> list backup;


  42. List of Backup Sets
  43. ===================


  46. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  47. ------- ---- -- ---------- ----------- ------------ -------------------
  48. 65      Incr 0  436.25M    SBT_TAPE    00:01:00     2018-06-08:01:08:17
  49.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSAUX_INCR0
  50.         Handle: 2ct4t1m5_1_1   Media: station87-000008
  51.   List of Datafiles in backup set 65
  52.   File LV Type Ckp SCN    Ckp Time            Name
  53.   ---- -- ---- ---------- ------------------- ----
  54.   2    0  Incr 1155660    2018-06-08:01:07:17 +DATA/orcl/datafile/sysaux.257.832197065

  56. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  57. ------- ---- -- ---------- ----------- ------------ -------------------
  58. 66      Full    10.00M     SBT_TAPE    00:00:39     2018-06-08:01:09:01
  59.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T010822
  60.         Handle: c-1359978017-20180608-07   Media: station87-000008
  61.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  62.   SPFILE db_unique_name: ORCL
  63.   Control File Included: Ckp SCN: 1155709      Ckp time: 2018-06-08:01:08:22

  65. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  66. ------- ---- -- ---------- ----------- ------------ -------------------
  67. 67      Incr 0  86.50M     SBT_TAPE    00:00:53     2018-06-08:01:13:00
  68.         BP Key: 73   Status: AVAILABLE  Compressed: YES  Tag: 2TC_SYSAUX_INCR0
  69.         Handle: 2et4t1v7_1_1   Media: station87-000008
  70.   List of Datafiles in backup set 67
  71.   File LV Type Ckp SCN    Ckp Time            Name
  72.   ---- -- ---- ---------- ------------------- ----
  73.   2    0  Incr 1155986    2018-06-08:01:12:07 +DATA/orcl/datafile/sysaux.257.832197065

  75. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  76. ------- ---- -- ---------- ----------- ------------ -------------------
  77. 68      Full    10.00M     SBT_TAPE    00:00:41     2018-06-08:01:13:43
  78.         BP Key: 74   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T011302
  79.         Handle: c-1359978017-20180608-08   Media: station87-000008
  80.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  81.   SPFILE db_unique_name: ORCL
  82.   Control File Included: Ckp SCN: 1156051      Ckp time: 2018-06-08:01:13:02

  84. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  85. ------- ---- -- ---------- ----------- ------------ -------------------
  86. 70      Full    10.00M     SBT_TAPE    00:00:27     2018-06-08:01:42:19
  87.         BP Key: 76   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T014152
  88.         Handle: c-1359978017-20180608-09   Media: station87-000008
  89.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  90.   SPFILE db_unique_name: ORCL
  91.   Control File Included: Ckp SCN: 1157970      Ckp time: 2018-06-08:01:41:52

  93. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  94. ------- ---- -- ---------- ----------- ------------ -------------------
  95. 71      Incr 0  3.50M      SBT_TAPE    00:00:56     2018-06-08:02:04:36
  96.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: 4TEDUAL_USERS_INCR0
  97.         Handle: 2kt4t4vs_1_1   Media: station87-000008
  98.   List of Datafiles in backup set 71
  99.   File LV Type Ckp SCN    Ckp Time            Name
  100.   ---- -- ---- ---------- ------------------- ----
  101.   4    0  Incr 1160195    2018-06-08:02:03:40 +DATA/orcl/datafile/users.259.978228669

  103. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  104. ------- ---- -- ---------- ----------- ------------ -------------------
  105. 72      Full    10.00M     SBT_TAPE    00:00:37     2018-06-08:02:05:22
  106.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T020445
  107.         Handle: c-1359978017-20180608-0a   Media: station87-000008
  108.   SPFILE Included: Modification time: 2018-06-08:02:04:15
  109.   SPFILE db_unique_name: ORCL
  110.   Control File Included: Ckp SCN: 1160247      Ckp time: 2018-06-08:02:04:45

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

  118.   List of Archived Logs in backup set 73
  119.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  120.   ---- ------- ---------- ------------------- ---------- ---------
  121.   1    78      1323993    2018-06-08:04:33:46 1328678    2018-06-08:04:34:01
  122.   1    79      1328678    2018-06-08:04:34:01 1340398    2018-06-08:04:39:31

  124. BS Key  Size       Device Type Elapsed Time Completion Time   
  125. ------- ---------- ----------- ------------ -------------------
  126. 74      46.00M     SBT_TAPE    00:01:20     2018-06-09:17:37:28
  127.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  128.         Handle: 2tt51g08_1_1   Media: station87-000009

  130.   List of Archived Logs in backup set 74
  131.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  132.   ---- ------- ---------- ------------------- ---------- ---------
  133.   1    80      1340398    2018-06-08:04:39:31 1344895    2018-06-08:04:39:42

  135. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  136. ------- ---- -- ---------- ----------- ------------ -------------------
  137. 75      Full    10.00M     SBT_TAPE    00:00:36     2018-06-09:17:38:09
  138.         BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T173733
  139.         Handle: c-1359978017-20180609-00   Media: station87-000008
  140.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  141.   SPFILE db_unique_name: ORCL
  142.   Control File Included: Ckp SCN: 1408511      Ckp time: 2018-06-09:17:37:33

  144. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  145. ------- ---- -- ---------- ----------- ------------ -------------------
  146. 76      Incr 1  30.50M     SBT_TAPE    00:00:48     2018-06-09:17:43:32
  147.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: 2T_USERS_INCR1
  148.         Handle: 2vt51gck_1_1   Media: station87-000009
  149.   List of Datafiles in backup set 76
  150.   File LV Type Ckp SCN    Ckp Time            Name
  151.   ---- -- ---- ---------- ------------------- ----
  152.   4    1  Incr 1408699    2018-06-09:17:42:44 +DATA/orcl/datafile/users.259.978228669

  154. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  155. ------- ---- -- ---------- ----------- ------------ -------------------
  156. 77      Full    10.00M     SBT_TAPE    00:00:42     2018-06-09:17:44:21
  157.         BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174339
  158.         Handle: c-1359978017-20180609-01   Media: station87-000009
  159.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  160.   SPFILE db_unique_name: ORCL
  161.   Control File Included: Ckp SCN: 1408731      Ckp time: 2018-06-09:17:43:39

  163. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  164. ------- ---- -- ---------- ----------- ------------ -------------------
  165. 78      Incr 1  256.00K    SBT_TAPE    00:00:35     2018-06-09:17:47:05
  166.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: 3T_USERS_INCR1
  167.         Handle: 31t51gjm_1_1   Media: station87-000009
  168.   List of Datafiles in backup set 78
  169.   File LV Type Ckp SCN    Ckp Time            Name
  170.   ---- -- ---- ---------- ------------------- ----
  171.   4    1  Incr 1408937    2018-06-09:17:46:30 +DATA/orcl/datafile/users.259.978228669

  173. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  174. ------- ---- -- ---------- ----------- ------------ -------------------
  175. 79      Full    10.00M     SBT_TAPE    00:00:37     2018-06-09:17:47:52
  176.         BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174715
  177.         Handle: c-1359978017-20180609-02   Media: station87-000009
  178.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  179.   SPFILE db_unique_name: ORCL
  180.   Control File Included: Ckp SCN: 1408966      Ckp time: 2018-06-09:17:47:15

  182. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  183. ------- ---- -- ---------- ----------- ------------ -------------------
  184. 80      Incr 1  30.50M     SBT_TAPE    00:00:47     2018-06-09:17:55:25
  185.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1C
  186.         Handle: 33t51h2u_1_1   Media: station87-000009
  187.   List of Datafiles in backup set 80
  188.   File LV Type Ckp SCN    Ckp Time            Name
  189.   ---- -- ---- ---------- ------------------- ----
  190.   4    1  Incr 1409298    2018-06-09:17:54:38 +DATA/orcl/datafile/users.259.978228669

  192. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  193. ------- ---- -- ---------- ----------- ------------ -------------------
  194. 81      Full    10.00M     SBT_TAPE    00:00:28     2018-06-09:17:56:01
  195.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T175533
  196.         Handle: c-1359978017-20180609-03   Media: station87-000009
  197.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  198.   SPFILE db_unique_name: ORCL
  199.   Control File Included: Ckp SCN: 1409338      Ckp time: 2018-06-09:17:55:33

  201. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  202. ------- ---- -- ---------- ----------- ------------ -------------------
  203. 82      Full    33.70M     SBT_TAPE    00:00:02     2018-06-09:18:14:10
  204.         BP Key: 90   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181408
  205.         Handle: 35t51i7g_1_2   Media: station87-000009
  206.   List of Datafiles in backup set 82
  207.   File LV Type Ckp SCN    Ckp Time            Name
  208.   ---- -- ---- ---------- ------------------- ----
  209.   4       Full 1410584    2018-06-09:18:14:08 +DATA/orcl/datafile/users.259.978228669

  211. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  212. ------- ---- -- ---------- ----------- ------------ -------------------
  213. 83      Full    9.86M      DISK        00:00:01     2018-06-09:18:14:12
  214.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181411
  215.         Piece Name: +FRA/orcl/autobackup/2018_06_09/s_978372851.322.978372853
  216.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  217.   SPFILE db_unique_name: ORCL
  218.   Control File Included: Ckp SCN: 1410592      Ckp time: 2018-06-09:18:14:11

  220. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  221. ------- ---- -- ---------- ----------- ------------ -------------------
  222. 84      Full    10.00M     SBT_TAPE    00:00:38     2018-06-09:18:16:59
  223.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181621
  224.         Handle: c-1359978017-20180609-05   Media: station87-000009
  225.   SPFILE Included: Modification time: 2018-06-09:18:15:20
  226.   SPFILE db_unique_name: ORCL
  227.   Control File Included: Ckp SCN: 1410754      Ckp time: 2018-06-09:18:16:21

  229. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  230. ------- ---- -- ---------- ----------- ------------ -------------------
  231. 85      Incr 0  597.50M    SBT_TAPE    00:02:39     2018-06-09:18:40:28
  232.   List of Datafiles in backup set 85
  233.   File LV Type Ckp SCN    Ckp Time            Name
  234.   ---- -- ---- ---------- ------------------- ----
  235.   1    0  Incr 1411610    2018-06-09:18:37:49 +DATA/orcl/datafile/system.256.832197063

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

  242.     List of Backup Pieces for backup set 85 Copy #1
  243.     BP Key  Pc# Status      Media                   Piece Name
  244.     ------- --- ----------- ----------------------- ----------
  245.     92      1   AVAILABLE   station87-000009        38t51jjt_1_1
  246.     93      2   AVAILABLE   station87-000009        38t51jjt_2_1
  247.     94      3   AVAILABLE   station87-000009        38t51jjt_3_1

  249. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  250. ------- ---- -- ---------- ----------- ------------ -------------------
  251. 86      Incr 0  10.00M     SBT_TAPE    00:00:42     2018-06-09:18:41:14
  252.         BP Key: 95   Status: AVAILABLE  Compressed: NO  Tag: 5T_SYSTEM_INCR0
  253.         Handle: 39t51jp0_1_1   Media: station87-000009
  254.   SPFILE Included: Modification time: 2018-06-09:18:38:42
  255.   SPFILE db_unique_name: ORCL
  256.   Control File Included: Ckp SCN: 1411697      Ckp time: 2018-06-09:18:40:32

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

  260. Starting backup at 2018-06-09:18:43:54
  261. allocated channel: ORA_SBT_TAPE_1
  262. channel ORA_SBT_TAPE_1: SID=72 device type=SBT_TAPE
  263. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  264. allocated channel: ORA_SBT_TAPE_2
  265. channel ORA_SBT_TAPE_2: SID=197 device type=SBT_TAPE
  266. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  267. RMAN-00571: ===========================================================
  268. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  269. RMAN-00571: ===========================================================
  270. RMAN-03002: failure of backup command at 06/09/2018 18:44:06
  271. RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect

  273. RMAN> exit


  276. Recovery Manager complete.
  277. [oracle@station87 ~]$ rman target /

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

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

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

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

  287. Starting backup at 2018-06-09:18:44:19
  288. using target database control file instead of recovery catalog
  289. allocated channel: ORA_SBT_TAPE_1
  290. channel ORA_SBT_TAPE_1: SID=70 device type=SBT_TAPE
  291. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  292. allocated channel: ORA_SBT_TAPE_2
  293. channel ORA_SBT_TAPE_2: SID=197 device type=SBT_TAPE
  294. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  295. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  296. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  297. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  298. backing up blocks 1 through 25600
  299. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:18:44:30
  300. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  301. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  302. including current control file in backup set
  303. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-06-09:18:44:31
  304. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:18:45:36
  305. piece handle=3at51k0e_1_1 tag=6T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  306. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:06
  307. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  308. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  309. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  310. backing up blocks 25601 through 51200
  311. channel ORA_SBT_TAPE_1: starting piece 2 at 2018-06-09:18:45:37
  312. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-06-09:18:45:37
  313. piece handle=3bt51k0e_1_1 tag=6T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  314. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:06
  315. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  316. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  317. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  318. backing up blocks 51201 through 76800
  319. channel ORA_SBT_TAPE_2: starting piece 3 at 2018-06-09:18:45:37
  320. channel ORA_SBT_TAPE_1: finished piece 2 at 2018-06-09:18:46:32
  321. piece handle=3at51k0e_2_1 tag=6T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  322. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:55
  323. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  324. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  325. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  326. backing up blocks 76801 through 88320
  327. channel ORA_SBT_TAPE_1: starting piece 4 at 2018-06-09:18:46:32
  328. channel ORA_SBT_TAPE_2: finished piece 3 at 2018-06-09:18:46:35
  329. piece handle=3at51k0e_3_1 tag=6T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  330. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:58
  331. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  332. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  333. including current SPFILE in backup set
  334. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-06-09:18:46:36
  335. channel ORA_SBT_TAPE_1: finished piece 4 at 2018-06-09:18:47:21
  336. piece handle=3at51k0e_4_1 tag=6T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  337. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:49
  338. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-06-09:18:47:31
  339. piece handle=3ft51k4c_1_1 tag=6T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  340. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:55
  341. Finished backup at 2018-06-09:18:47:31

  343. RMAN> list backup;


  346. List of Backup Sets
  347. ===================


  350. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  351. ------- ---- -- ---------- ----------- ------------ -------------------
  352. 65      Incr 0  436.25M    SBT_TAPE    00:01:00     2018-06-08:01:08:17
  353.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSAUX_INCR0
  354.         Handle: 2ct4t1m5_1_1   Media: station87-000008
  355.   List of Datafiles in backup set 65
  356.   File LV Type Ckp SCN    Ckp Time            Name
  357.   ---- -- ---- ---------- ------------------- ----
  358.   2    0  Incr 1155660    2018-06-08:01:07:17 +DATA/orcl/datafile/sysaux.257.832197065

  360. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  361. ------- ---- -- ---------- ----------- ------------ -------------------
  362. 66      Full    10.00M     SBT_TAPE    00:00:39     2018-06-08:01:09:01
  363.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T010822
  364.         Handle: c-1359978017-20180608-07   Media: station87-000008
  365.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  366.   SPFILE db_unique_name: ORCL
  367.   Control File Included: Ckp SCN: 1155709      Ckp time: 2018-06-08:01:08:22

  369. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  370. ------- ---- -- ---------- ----------- ------------ -------------------
  371. 67      Incr 0  86.50M     SBT_TAPE    00:00:53     2018-06-08:01:13:00
  372.         BP Key: 73   Status: AVAILABLE  Compressed: YES  Tag: 2TC_SYSAUX_INCR0
  373.         Handle: 2et4t1v7_1_1   Media: station87-000008
  374.   List of Datafiles in backup set 67
  375.   File LV Type Ckp SCN    Ckp Time            Name
  376.   ---- -- ---- ---------- ------------------- ----
  377.   2    0  Incr 1155986    2018-06-08:01:12:07 +DATA/orcl/datafile/sysaux.257.832197065

  379. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  380. ------- ---- -- ---------- ----------- ------------ -------------------
  381. 68      Full    10.00M     SBT_TAPE    00:00:41     2018-06-08:01:13:43
  382.         BP Key: 74   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T011302
  383.         Handle: c-1359978017-20180608-08   Media: station87-000008
  384.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  385.   SPFILE db_unique_name: ORCL
  386.   Control File Included: Ckp SCN: 1156051      Ckp time: 2018-06-08:01:13:02

  388. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  389. ------- ---- -- ---------- ----------- ------------ -------------------
  390. 70      Full    10.00M     SBT_TAPE    00:00:27     2018-06-08:01:42:19
  391.         BP Key: 76   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T014152
  392.         Handle: c-1359978017-20180608-09   Media: station87-000008
  393.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  394.   SPFILE db_unique_name: ORCL
  395.   Control File Included: Ckp SCN: 1157970      Ckp time: 2018-06-08:01:41:52

  397. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  398. ------- ---- -- ---------- ----------- ------------ -------------------
  399. 71      Incr 0  3.50M      SBT_TAPE    00:00:56     2018-06-08:02:04:36
  400.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: 4TEDUAL_USERS_INCR0
  401.         Handle: 2kt4t4vs_1_1   Media: station87-000008
  402.   List of Datafiles in backup set 71
  403.   File LV Type Ckp SCN    Ckp Time            Name
  404.   ---- -- ---- ---------- ------------------- ----
  405.   4    0  Incr 1160195    2018-06-08:02:03:40 +DATA/orcl/datafile/users.259.978228669

  407. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  408. ------- ---- -- ---------- ----------- ------------ -------------------
  409. 72      Full    10.00M     SBT_TAPE    00:00:37     2018-06-08:02:05:22
  410.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T020445
  411.         Handle: c-1359978017-20180608-0a   Media: station87-000008
  412.   SPFILE Included: Modification time: 2018-06-08:02:04:15
  413.   SPFILE db_unique_name: ORCL
  414.   Control File Included: Ckp SCN: 1160247      Ckp time: 2018-06-08:02:04:45

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

  422.   List of Archived Logs in backup set 73
  423.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  424.   ---- ------- ---------- ------------------- ---------- ---------
  425.   1    78      1323993    2018-06-08:04:33:46 1328678    2018-06-08:04:34:01
  426.   1    79      1328678    2018-06-08:04:34:01 1340398    2018-06-08:04:39:31

  428. BS Key  Size       Device Type Elapsed Time Completion Time   
  429. ------- ---------- ----------- ------------ -------------------
  430. 74      46.00M     SBT_TAPE    00:01:20     2018-06-09:17:37:28
  431.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: 1T_ARCH78-80
  432.         Handle: 2tt51g08_1_1   Media: station87-000009

  434.   List of Archived Logs in backup set 74
  435.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  436.   ---- ------- ---------- ------------------- ---------- ---------
  437.   1    80      1340398    2018-06-08:04:39:31 1344895    2018-06-08:04:39:42

  439. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  440. ------- ---- -- ---------- ----------- ------------ -------------------
  441. 75      Full    10.00M     SBT_TAPE    00:00:36     2018-06-09:17:38:09
  442.         BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T173733
  443.         Handle: c-1359978017-20180609-00   Media: station87-000008
  444.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  445.   SPFILE db_unique_name: ORCL
  446.   Control File Included: Ckp SCN: 1408511      Ckp time: 2018-06-09:17:37:33

  448. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  449. ------- ---- -- ---------- ----------- ------------ -------------------
  450. 76      Incr 1  30.50M     SBT_TAPE    00:00:48     2018-06-09:17:43:32
  451.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: 2T_USERS_INCR1
  452.         Handle: 2vt51gck_1_1   Media: station87-000009
  453.   List of Datafiles in backup set 76
  454.   File LV Type Ckp SCN    Ckp Time            Name
  455.   ---- -- ---- ---------- ------------------- ----
  456.   4    1  Incr 1408699    2018-06-09:17:42:44 +DATA/orcl/datafile/users.259.978228669

  458. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  459. ------- ---- -- ---------- ----------- ------------ -------------------
  460. 77      Full    10.00M     SBT_TAPE    00:00:42     2018-06-09:17:44:21
  461.         BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174339
  462.         Handle: c-1359978017-20180609-01   Media: station87-000009
  463.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  464.   SPFILE db_unique_name: ORCL
  465.   Control File Included: Ckp SCN: 1408731      Ckp time: 2018-06-09:17:43:39

  467. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  468. ------- ---- -- ---------- ----------- ------------ -------------------
  469. 78      Incr 1  256.00K    SBT_TAPE    00:00:35     2018-06-09:17:47:05
  470.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: 3T_USERS_INCR1
  471.         Handle: 31t51gjm_1_1   Media: station87-000009
  472.   List of Datafiles in backup set 78
  473.   File LV Type Ckp SCN    Ckp Time            Name
  474.   ---- -- ---- ---------- ------------------- ----
  475.   4    1  Incr 1408937    2018-06-09:17:46:30 +DATA/orcl/datafile/users.259.978228669

  477. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  478. ------- ---- -- ---------- ----------- ------------ -------------------
  479. 79      Full    10.00M     SBT_TAPE    00:00:37     2018-06-09:17:47:52
  480.         BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174715
  481.         Handle: c-1359978017-20180609-02   Media: station87-000009
  482.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  483.   SPFILE db_unique_name: ORCL
  484.   Control File Included: Ckp SCN: 1408966      Ckp time: 2018-06-09:17:47:15

  486. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  487. ------- ---- -- ---------- ----------- ------------ -------------------
  488. 80      Incr 1  30.50M     SBT_TAPE    00:00:47     2018-06-09:17:55:25
  489.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1C
  490.         Handle: 33t51h2u_1_1   Media: station87-000009
  491.   List of Datafiles in backup set 80
  492.   File LV Type Ckp SCN    Ckp Time            Name
  493.   ---- -- ---- ---------- ------------------- ----
  494.   4    1  Incr 1409298    2018-06-09:17:54:38 +DATA/orcl/datafile/users.259.978228669

  496. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  497. ------- ---- -- ---------- ----------- ------------ -------------------
  498. 81      Full    10.00M     SBT_TAPE    00:00:28     2018-06-09:17:56:01
  499.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T175533
  500.         Handle: c-1359978017-20180609-03   Media: station87-000009
  501.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  502.   SPFILE db_unique_name: ORCL
  503.   Control File Included: Ckp SCN: 1409338      Ckp time: 2018-06-09:17:55:33

  505. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  506. ------- ---- -- ---------- ----------- ------------ -------------------
  507. 82      Full    33.70M     SBT_TAPE    00:00:02     2018-06-09:18:14:10
  508.         BP Key: 90   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181408
  509.         Handle: 35t51i7g_1_2   Media: station87-000009
  510.   List of Datafiles in backup set 82
  511.   File LV Type Ckp SCN    Ckp Time            Name
  512.   ---- -- ---- ---------- ------------------- ----
  513.   4       Full 1410584    2018-06-09:18:14:08 +DATA/orcl/datafile/users.259.978228669

  515. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  516. ------- ---- -- ---------- ----------- ------------ -------------------
  517. 83      Full    9.86M      DISK        00:00:01     2018-06-09:18:14:12
  518.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181411
  519.         Piece Name: +FRA/orcl/autobackup/2018_06_09/s_978372851.322.978372853
  520.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  521.   SPFILE db_unique_name: ORCL
  522.   Control File Included: Ckp SCN: 1410592      Ckp time: 2018-06-09:18:14:11

  524. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  525. ------- ---- -- ---------- ----------- ------------ -------------------
  526. 84      Full    10.00M     SBT_TAPE    00:00:38     2018-06-09:18:16:59
  527.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181621
  528.         Handle: c-1359978017-20180609-05   Media: station87-000009
  529.   SPFILE Included: Modification time: 2018-06-09:18:15:20
  530.   SPFILE db_unique_name: ORCL
  531.   Control File Included: Ckp SCN: 1410754      Ckp time: 2018-06-09:18:16:21

  533. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  534. ------- ---- -- ---------- ----------- ------------ -------------------
  535. 85      Incr 0  597.50M    SBT_TAPE    00:02:39     2018-06-09:18:40:28
  536.   List of Datafiles in backup set 85
  537.   File LV Type Ckp SCN    Ckp Time            Name
  538.   ---- -- ---- ---------- ------------------- ----
  539.   1    0  Incr 1411610    2018-06-09:18:37:49 +DATA/orcl/datafile/system.256.832197063

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

  546.     List of Backup Pieces for backup set 85 Copy #1
  547.     BP Key  Pc# Status      Media                   Piece Name
  548.     ------- --- ----------- ----------------------- ----------
  549.     92      1   AVAILABLE   station87-000009        38t51jjt_1_1
  550.     93      2   AVAILABLE   station87-000009        38t51jjt_2_1
  551.     94      3   AVAILABLE   station87-000009        38t51jjt_3_1

  553. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  554. ------- ---- -- ---------- ----------- ------------ -------------------
  555. 86      Incr 0  10.00M     SBT_TAPE    00:00:42     2018-06-09:18:41:14
  556.         BP Key: 95   Status: AVAILABLE  Compressed: NO  Tag: 5T_SYSTEM_INCR0
  557.         Handle: 39t51jp0_1_1   Media: station87-000009
  558.   SPFILE Included: Modification time: 2018-06-09:18:38:42
  559.   SPFILE db_unique_name: ORCL
  560.   Control File Included: Ckp SCN: 1411697      Ckp time: 2018-06-09:18:40:32

  562. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  563. ------- ---- -- ---------- ----------- ------------ -------------------
  564. 87      Incr 0  597.75M    SBT_TAPE    00:02:44     2018-06-09:18:47:14
  565.   List of Datafiles in backup set 87
  566.   File LV Type Ckp SCN    Ckp Time            Name
  567.   ---- -- ---- ---------- ------------------- ----
  568.   1    0  Incr 1411863    2018-06-09:18:44:30 +DATA/orcl/datafile/system.256.832197063

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

  575.     List of Backup Pieces for backup set 87 Copy #1
  576.     BP Key  Pc# Status      Media                   Piece Name
  577.     ------- --- ----------- ----------------------- ----------
  578.     96      1   AVAILABLE   station87-000009        3at51k0e_1_1
  579.     98      2   AVAILABLE   station87-000009        3at51k0e_2_1
  580.     99      3   AVAILABLE   station87-000008        3at51k0e_3_1
  581.     100     4   AVAILABLE   station87-000009        3at51k0e_4_1

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

  590. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  591. ------- ---- -- ---------- ----------- ------------ -------------------
  592. 89      Incr 0  256.00K    SBT_TAPE    00:00:49     2018-06-09:18:47:25
  593.         BP Key: 101   Status: AVAILABLE  Compressed: NO  Tag: 6T_SYSTEM_INCR0
  594.         Handle: 3ft51k4c_1_1   Media: station87-000008
  595.   SPFILE Included: Modification time: 2018-06-09:18:44:01
  596.   SPFILE db_unique_name: ORCL

  598. RMAN> list backup of tablespace system ;


  601. List of Backup Sets
  602. ===================


  605. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  606. ------- ---- -- ---------- ----------- ------------ -------------------
  607. 85      Incr 0  597.50M    SBT_TAPE    00:02:39     2018-06-09:18:40:28
  608.   List of Datafiles in backup set 85
  609.   File LV Type Ckp SCN    Ckp Time            Name
  610.   ---- -- ---- ---------- ------------------- ----
  611.   1    0  Incr 1411610    2018-06-09:18:37:49 +DATA/orcl/datafile/system.256.832197063

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

  618.     List of Backup Pieces for backup set 85 Copy #1
  619.     BP Key  Pc# Status      Media                   Piece Name
  620.     ------- --- ----------- ----------------------- ----------
  621.     92      1   AVAILABLE   station87-000009        38t51jjt_1_1
  622.     93      2   AVAILABLE   station87-000009        38t51jjt_2_1
  623.     94      3   AVAILABLE   station87-000009        38t51jjt_3_1

  625. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  626. ------- ---- -- ---------- ----------- ------------ -------------------
  627. 87      Incr 0  597.75M    SBT_TAPE    00:02:44     2018-06-09:18:47:14
  628.   List of Datafiles in backup set 87
  629.   File LV Type Ckp SCN    Ckp Time            Name
  630.   ---- -- ---- ---------- ------------------- ----
  631.   1    0  Incr 1411863    2018-06-09:18:44:30 +DATA/orcl/datafile/system.256.832197063

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

  638.     List of Backup Pieces for backup set 87 Copy #1
  639.     BP Key  Pc# Status      Media                   Piece Name
  640.     ------- --- ----------- ----------------------- ----------
  641.     96      1   AVAILABLE   station87-000009        3at51k0e_1_1
  642.     98      2   AVAILABLE   station87-000009        3at51k0e_2_1
  643.     99      3   AVAILABLE   station87-000008        3at51k0e_3_1
  644.     100     4   AVAILABLE   station87-000009        3at51k0e_4_1

  646. RMAN>
复制代码

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

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

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

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


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

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

  69. RMAN>
复制代码

rsp1.png


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

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

  6. using channel ORA_SBT_TAPE_1
  7. using channel ORA_SBT_TAPE_2
  8. RMAN-00571: ===========================================================
  9. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  10. RMAN-00571: ===========================================================
  11. RMAN-03002: failure of backup command at 06/09/2018 19:05:07
  12. 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;

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

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

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

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

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

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

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

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

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

  84. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  85. ------- ---- -- ---------- ----------- ------------ -------------------
  86. 1569    Full    256.00K    SBT_TAPE    00:00:41     2018-06-09:19:08:57
  87.         BP Key: 1573   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  88.         Handle: 3nt51ld0_1_1   Media: station87-000009
  89.         Keep: BACKUP_LOGS        Until: FOREVER        
  90.   SPFILE Included: Modification time: 2018-06-09:18:44:01
  91.   SPFILE db_unique_name: ORCL

  93. BS Key  Size       Device Type Elapsed Time Completion Time   
  94. ------- ---------- ----------- ------------ -------------------
  95. 1589    256.00K    SBT_TAPE    00:00:30     2018-06-09:19:09:33
  96.         BP Key: 1592   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  97.         Handle: 3ot51lef_1_1   Media: station87-000009
  98.         Keep: BACKUP_LOGS        Until: FOREVER        

  100.   List of Archived Logs in backup set 1589
  101.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  102.   ---- ------- ---------- ------------------- ---------- ---------
  103.   1    89      1413227    2018-06-09:19:06:08 1413402    2018-06-09:19:09:02

  105. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  106. ------- ---- -- ---------- ----------- ------------ -------------------
  107. 1590    Full    10.00M     SBT_TAPE    00:00:37     2018-06-09:19:10:15
  108.         BP Key: 1593   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  109.         Handle: 3pt51lfi_1_1   Media: station87-000009
  110.         Keep: BACKUP_LOGS        Until: FOREVER        
  111.   Control File Included: Ckp SCN: 1413438      Ckp time: 2018-06-09:19:09:38

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

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

  17. RMAN> change backupset 1589 keep forever  nologs;

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

  34. RMAN> list backup;                        


  37. List of Backup Sets
  38. ===================


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

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

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

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

  79. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  80. ------- ---- -- ---------- ----------- ------------ -------------------
  81. 1448    Full    10.00M     SBT_TAPE    00:00:27     2018-06-08:01:42:19
  82.         BP Key: 1477   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T014152
  83.         Handle: c-1359978017-20180608-09   Media: station87-000008
  84.   SPFILE Included: Modification time: 2018-06-08:01:07:07
  85.   SPFILE db_unique_name: ORCL
  86.   Control File Included: Ckp SCN: 1157970      Ckp time: 2018-06-08:01:41:52

  88. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  89. ------- ---- -- ---------- ----------- ------------ -------------------
  90. 1449    Incr 0  3.50M      SBT_TAPE    00:00:56     2018-06-08:02:04:36
  91.         BP Key: 1478   Status: AVAILABLE  Compressed: NO  Tag: 4TEDUAL_USERS_INCR0
  92.         Handle: 2kt4t4vs_1_1   Media: station87-000008
  93.   List of Datafiles in backup set 1449
  94.   File LV Type Ckp SCN    Ckp Time            Name
  95.   ---- -- ---- ---------- ------------------- ----
  96.   4    0  Incr 1160195    2018-06-08:02:03:40 +DATA/orcl/datafile/users.259.978228669

  98. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  99. ------- ---- -- ---------- ----------- ------------ -------------------
  100. 1450    Full    10.00M     SBT_TAPE    00:00:37     2018-06-08:02:05:22
  101.         BP Key: 1479   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T020445
  102.         Handle: c-1359978017-20180608-0a   Media: station87-000008
  103.   SPFILE Included: Modification time: 2018-06-08:02:04:15
  104.   SPFILE db_unique_name: ORCL
  105.   Control File Included: Ckp SCN: 1160247      Ckp time: 2018-06-08:02:04:45

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

  113.   List of Archived Logs in backup set 1451
  114.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  115.   ---- ------- ---------- ------------------- ---------- ---------
  116.   1    78      1323993    2018-06-08:04:33:46 1328678    2018-06-08:04:34:01
  117.   1    79      1328678    2018-06-08:04:34:01 1340398    2018-06-08:04:39:31

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

  125.   List of Archived Logs in backup set 1452
  126.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  127.   ---- ------- ---------- ------------------- ---------- ---------
  128.   1    80      1340398    2018-06-08:04:39:31 1344895    2018-06-08:04:39:42

  130. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  131. ------- ---- -- ---------- ----------- ------------ -------------------
  132. 1453    Full    10.00M     SBT_TAPE    00:00:36     2018-06-09:17:38:09
  133.         BP Key: 1482   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T173733
  134.         Handle: c-1359978017-20180609-00   Media: station87-000008
  135.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  136.   SPFILE db_unique_name: ORCL
  137.   Control File Included: Ckp SCN: 1408511      Ckp time: 2018-06-09:17:37:33

  139. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  140. ------- ---- -- ---------- ----------- ------------ -------------------
  141. 1454    Incr 1  30.50M     SBT_TAPE    00:00:48     2018-06-09:17:43:32
  142.         BP Key: 1483   Status: AVAILABLE  Compressed: NO  Tag: 2T_USERS_INCR1
  143.         Handle: 2vt51gck_1_1   Media: station87-000009
  144.   List of Datafiles in backup set 1454
  145.   File LV Type Ckp SCN    Ckp Time            Name
  146.   ---- -- ---- ---------- ------------------- ----
  147.   4    1  Incr 1408699    2018-06-09:17:42:44 +DATA/orcl/datafile/users.259.978228669

  149. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  150. ------- ---- -- ---------- ----------- ------------ -------------------
  151. 1455    Full    10.00M     SBT_TAPE    00:00:42     2018-06-09:17:44:21
  152.         BP Key: 1484   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174339
  153.         Handle: c-1359978017-20180609-01   Media: station87-000009
  154.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  155.   SPFILE db_unique_name: ORCL
  156.   Control File Included: Ckp SCN: 1408731      Ckp time: 2018-06-09:17:43:39

  158. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  159. ------- ---- -- ---------- ----------- ------------ -------------------
  160. 1456    Incr 1  256.00K    SBT_TAPE    00:00:35     2018-06-09:17:47:05
  161.         BP Key: 1485   Status: AVAILABLE  Compressed: NO  Tag: 3T_USERS_INCR1
  162.         Handle: 31t51gjm_1_1   Media: station87-000009
  163.   List of Datafiles in backup set 1456
  164.   File LV Type Ckp SCN    Ckp Time            Name
  165.   ---- -- ---- ---------- ------------------- ----
  166.   4    1  Incr 1408937    2018-06-09:17:46:30 +DATA/orcl/datafile/users.259.978228669

  168. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  169. ------- ---- -- ---------- ----------- ------------ -------------------
  170. 1457    Full    10.00M     SBT_TAPE    00:00:37     2018-06-09:17:47:52
  171.         BP Key: 1486   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T174715
  172.         Handle: c-1359978017-20180609-02   Media: station87-000009
  173.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  174.   SPFILE db_unique_name: ORCL
  175.   Control File Included: Ckp SCN: 1408966      Ckp time: 2018-06-09:17:47:15

  177. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  178. ------- ---- -- ---------- ----------- ------------ -------------------
  179. 1458    Incr 1  30.50M     SBT_TAPE    00:00:47     2018-06-09:17:55:25
  180.         BP Key: 1487   Status: AVAILABLE  Compressed: NO  Tag: 4T_USERS_INCR1C
  181.         Handle: 33t51h2u_1_1   Media: station87-000009
  182.   List of Datafiles in backup set 1458
  183.   File LV Type Ckp SCN    Ckp Time            Name
  184.   ---- -- ---- ---------- ------------------- ----
  185.   4    1  Incr 1409298    2018-06-09:17:54:38 +DATA/orcl/datafile/users.259.978228669

  187. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  188. ------- ---- -- ---------- ----------- ------------ -------------------
  189. 1459    Full    10.00M     SBT_TAPE    00:00:28     2018-06-09:17:56:01
  190.         BP Key: 1488   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T175533
  191.         Handle: c-1359978017-20180609-03   Media: station87-000009
  192.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  193.   SPFILE db_unique_name: ORCL
  194.   Control File Included: Ckp SCN: 1409338      Ckp time: 2018-06-09:17:55:33

  196. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  197. ------- ---- -- ---------- ----------- ------------ -------------------
  198. 1460    Full    33.70M     SBT_TAPE    00:00:02     2018-06-09:18:14:10
  199.         BP Key: 1490   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181408
  200.         Handle: 35t51i7g_1_2   Media: station87-000009
  201.   List of Datafiles in backup set 1460
  202.   File LV Type Ckp SCN    Ckp Time            Name
  203.   ---- -- ---- ---------- ------------------- ----
  204.   4       Full 1410584    2018-06-09:18:14:08 +DATA/orcl/datafile/users.259.978228669

  206. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  207. ------- ---- -- ---------- ----------- ------------ -------------------
  208. 1461    Full    9.86M      DISK        00:00:01     2018-06-09:18:14:12
  209.         BP Key: 1489   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181411
  210.         Piece Name: +FRA/orcl/autobackup/2018_06_09/s_978372851.322.978372853
  211.   SPFILE Included: Modification time: 2018-06-09:17:35:40
  212.   SPFILE db_unique_name: ORCL
  213.   Control File Included: Ckp SCN: 1410592      Ckp time: 2018-06-09:18:14:11

  215. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  216. ------- ---- -- ---------- ----------- ------------ -------------------
  217. 1462    Full    10.00M     SBT_TAPE    00:00:38     2018-06-09:18:16:59
  218.         BP Key: 1491   Status: AVAILABLE  Compressed: NO  Tag: TAG20180609T181621
  219.         Handle: c-1359978017-20180609-05   Media: station87-000009
  220.   SPFILE Included: Modification time: 2018-06-09:18:15:20
  221.   SPFILE db_unique_name: ORCL
  222.   Control File Included: Ckp SCN: 1410754      Ckp time: 2018-06-09:18:16:21

  224. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  225. ------- ---- -- ---------- ----------- ------------ -------------------
  226. 1463    Incr 0  597.50M    SBT_TAPE    00:02:39     2018-06-09:18:40:28
  227.   List of Datafiles in backup set 1463
  228.   File LV Type Ckp SCN    Ckp Time            Name
  229.   ---- -- ---- ---------- ------------------- ----
  230.   1    0  Incr 1411610    2018-06-09:18:37:49 +DATA/orcl/datafile/system.256.832197063

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

  237.     List of Backup Pieces for backup set 1463 Copy #1
  238.     BP Key  Pc# Status      Media                   Piece Name
  239.     ------- --- ----------- ----------------------- ----------
  240.     1492    1   AVAILABLE   station87-000009        38t51jjt_1_1
  241.     1493    2   AVAILABLE   station87-000009        38t51jjt_2_1
  242.     1494    3   AVAILABLE   station87-000009        38t51jjt_3_1

  244. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  245. ------- ---- -- ---------- ----------- ------------ -------------------
  246. 1464    Incr 0  10.00M     SBT_TAPE    00:00:42     2018-06-09:18:41:14
  247.         BP Key: 1495   Status: AVAILABLE  Compressed: NO  Tag: 5T_SYSTEM_INCR0
  248.         Handle: 39t51jp0_1_1   Media: station87-000009
  249.   SPFILE Included: Modification time: 2018-06-09:18:38:42
  250.   SPFILE db_unique_name: ORCL
  251.   Control File Included: Ckp SCN: 1411697      Ckp time: 2018-06-09:18:40:32

  253. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  254. ------- ---- -- ---------- ----------- ------------ -------------------
  255. 1465    Incr 0  597.75M    SBT_TAPE    00:02:44     2018-06-09:18:47:14
  256.   List of Datafiles in backup set 1465
  257.   File LV Type Ckp SCN    Ckp Time            Name
  258.   ---- -- ---- ---------- ------------------- ----
  259.   1    0  Incr 1411863    2018-06-09:18:44:30 +DATA/orcl/datafile/system.256.832197063

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

  266.     List of Backup Pieces for backup set 1465 Copy #1
  267.     BP Key  Pc# Status      Media                   Piece Name
  268.     ------- --- ----------- ----------------------- ----------
  269.     1496    1   AVAILABLE   station87-000009        3at51k0e_1_1
  270.     1498    2   AVAILABLE   station87-000009        3at51k0e_2_1
  271.     1499    3   AVAILABLE   station87-000008        3at51k0e_3_1
  272.     1500    4   AVAILABLE   station87-000009        3at51k0e_4_1

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

  281. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  282. ------- ---- -- ---------- ----------- ------------ -------------------
  283. 1467    Incr 0  256.00K    SBT_TAPE    00:00:49     2018-06-09:18:47:25
  284.         BP Key: 1501   Status: AVAILABLE  Compressed: NO  Tag: 6T_SYSTEM_INCR0
  285.         Handle: 3ft51k4c_1_1   Media: station87-000008
  286.   SPFILE Included: Modification time: 2018-06-09:18:44:01
  287.   SPFILE db_unique_name: ORCL

  289. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  290. ------- ---- -- ---------- ----------- ------------ -------------------
  291. 1468    Incr 0  654.00M    SBT_TAPE    00:01:55     2018-06-09:19:00:54
  292.         BP Key: 1502   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  293.         Handle: 3gt51krj_1_1   Media: station87-000009
  294.         Keep: BACKUP_LOGS        Until: 2018-08-08:18:58:59
  295.   List of Datafiles in backup set 1468
  296.   File LV Type Ckp SCN    Ckp Time            Name
  297.   ---- -- ---- ---------- ------------------- ----
  298.   1    0  Incr 1412529    2018-06-09:18:59:00 +DATA/orcl/datafile/system.256.832197063
  299.   3    0  Incr 1412529    2018-06-09:18:59:00 +DATA/orcl/datafile/undotbs1.258.832197065
  300.   4    0  Incr 1412529    2018-06-09:18:59:00 +DATA/orcl/datafile/users.259.978228669
  301.   6    0  Incr 1412529    2018-06-09:18:59:00 +DATA/orcl/datafile/tbsfda.267.978234227

  303. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  304. ------- ---- -- ---------- ----------- ------------ -------------------
  305. 1469    Incr 0  567.75M    SBT_TAPE    00:01:58     2018-06-09:19:00:57
  306.         BP Key: 1503   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  307.         Handle: 3ht51krj_1_1   Media: station87-000008
  308.         Keep: BACKUP_LOGS        Until: 2018-08-08:18:58:59
  309.   List of Datafiles in backup set 1469
  310.   File LV Type Ckp SCN    Ckp Time            Name
  311.   ---- -- ---- ---------- ------------------- ----
  312.   2    0  Incr 1412533    2018-06-09:18:59:00 +DATA/orcl/datafile/sysaux.257.832197065
  313.   5    0  Incr 1412533    2018-06-09:18:59:00 +DATA/orcl/datafile/example.265.832197353
  314.   7    0  Incr 1412533    2018-06-09:18:59:00 +DATA/orcl/datafile/tbsfda.268.978236837

  316. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  317. ------- ---- -- ---------- ----------- ------------ -------------------
  318. 1470    Full    256.00K    SBT_TAPE    00:00:28     2018-06-09:19:01:33
  319.         BP Key: 1504   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  320.         Handle: 3it51kvh_1_1   Media: station87-000009
  321.         Keep: BACKUP_LOGS        Until: 2018-08-08:19:01:05
  322.   SPFILE Included: Modification time: 2018-06-09:18:44:01
  323.   SPFILE db_unique_name: ORCL

  325. BS Key  Size       Device Type Elapsed Time Completion Time   
  326. ------- ---------- ----------- ------------ -------------------
  327. 1471    1.75M      SBT_TAPE    00:00:41     2018-06-09:19:02:22
  328.         BP Key: 1505   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  329.         Handle: 3jt51l0l_1_1   Media: station87-000009
  330.         Keep: BACKUP_LOGS        Until: 2018-08-08:19:01:41

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

  337. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  338. ------- ---- -- ---------- ----------- ------------ -------------------
  339. 1472    Full    10.00M     SBT_TAPE    00:00:26     2018-06-09:19:02:53
  340.         BP Key: 1506   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  341.         Handle: 3kt51l23_1_1   Media: station87-000009
  342.         Keep: BACKUP_LOGS        Until: 2018-08-08:19:02:26
  343.   Control File Included: Ckp SCN: 1412871      Ckp time: 2018-06-09:19:02:27

  345. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  346. ------- ---- -- ---------- ----------- ------------ -------------------
  347. 1567    Incr 0  568.50M    SBT_TAPE    00:01:27     2018-06-09:19:07:48
  348.         BP Key: 1571   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  349.         Handle: 3mt51l9d_1_1   Media: station87-000009
  350.         Keep: BACKUP_LOGS        Until: FOREVER        
  351.   List of Datafiles in backup set 1567
  352.   File LV Type Ckp SCN    Ckp Time            Name
  353.   ---- -- ---- ---------- ------------------- ----
  354.   2    0  Incr 1413253    2018-06-09:19:06:22 +DATA/orcl/datafile/sysaux.257.832197065
  355.   5    0  Incr 1413253    2018-06-09:19:06:22 +DATA/orcl/datafile/example.265.832197353
  356.   7    0  Incr 1413253    2018-06-09:19:06:22 +DATA/orcl/datafile/tbsfda.268.978236837

  358. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  359. ------- ---- -- ---------- ----------- ------------ -------------------
  360. 1568    Incr 0  653.75M    SBT_TAPE    00:01:54     2018-06-09:19:08:15
  361.         BP Key: 1572   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  362.         Handle: 3lt51l9d_1_1   Media: station87-000008
  363.         Keep: BACKUP_LOGS        Until: FOREVER        
  364.   List of Datafiles in backup set 1568
  365.   File LV Type Ckp SCN    Ckp Time            Name
  366.   ---- -- ---- ---------- ------------------- ----
  367.   1    0  Incr 1413249    2018-06-09:19:06:21 +DATA/orcl/datafile/system.256.832197063
  368.   3    0  Incr 1413249    2018-06-09:19:06:21 +DATA/orcl/datafile/undotbs1.258.832197065
  369.   4    0  Incr 1413249    2018-06-09:19:06:21 +DATA/orcl/datafile/users.259.978228669
  370.   6    0  Incr 1413249    2018-06-09:19:06:21 +DATA/orcl/datafile/tbsfda.267.978234227

  372. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  373. ------- ---- -- ---------- ----------- ------------ -------------------
  374. 1569    Full    256.00K    SBT_TAPE    00:00:41     2018-06-09:19:08:57
  375.         BP Key: 1573   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  376.         Handle: 3nt51ld0_1_1   Media: station87-000009
  377.         Keep: BACKUP_LOGS        Until: FOREVER        
  378.   SPFILE Included: Modification time: 2018-06-09:18:44:01
  379.   SPFILE db_unique_name: ORCL

  381. BS Key  Size       Device Type Elapsed Time Completion Time   
  382. ------- ---------- ----------- ------------ -------------------
  383. 1589    256.00K    SBT_TAPE    00:00:30     2018-06-09:19:09:33
  384.         BP Key: 1592   Status: AVAILABLE  Compressed: NO  Tag: 7T_WHOLE_INCR0
  385.         Handle: 3ot51lef_1_1   Media: station87-000009
  386.         Keep: NOLOGS             Until: FOREVER        

  388.   List of Archived Logs in backup set 1589
  389.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  390.   ---- ------- ---------- ------------------- ---------- ---------
  391.   1    89      1413227    2018-06-09:19:06:08 1413402    2018-06-09:19:09:02

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

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


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

  3. 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;

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

关于在线日志组的特殊恢复方法（不要人为地去关闭database，导致7a/7b的实验）：

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

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

  9. SQL> select  member from v$logfile;

  11. MEMBER
  12. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  13. /u01/app/oracle/oradata/rcat/redo03.log
  14. /u01/app/oracle/oradata/rcat/redo02.log
  15. /u01/app/oracle/oradata/rcat/redo01.log

  17. SQL> select  open_mode from v$database;

  19. OPEN_MODE
  20. --------------------
  21. READ WRITE

  23. SQL> alter database clear logfile group 1;  

  25. Database altered.

  27. SQL>
复制代码

active日志组的问题：

  1. SQL> select  * from v$log;

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

  9. SQL> alter system switch logfile;

  11. System altered.

  13. SQL> select  * from v$log;

  15.     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE          MEMBERS ARC STATUS               FIRST_CHANGE# FIRST_TIME          NEXT_CHANGE# NEXT_TIME               CON_ID
  16. ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- ------------ ------------------- ----------
  17.          1            1              31   52428800           512                1 NO  CURRENT                     2015655 2018-06-09:11:41:25   2.8147E+14   0
  18.          2            1              29   52428800           512                1 NO  INACTIVE                     2009327 2018-06-09:11:02:30      2013082 2018-06-09:11:12:41           0
  19.          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> select  * from v$log;

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

  29. SQL> alter database clear logfile group 3;  
  30. alter database clear logfile group 3
  31. *
  32. ERROR at line 1:
  33. ORA-01624: log 3 needed for crash recovery of instance rcat (thread 1)
  34. ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/rcat/redo03.log'


  37. SQL> alter system checkpoint;

  39. System altered.

  41. SQL> alter database clear logfile group 3;  

  43. Database altered.

  45. SQL>
复制代码

current的问题：






  1. SQL> select  * from v$log;

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

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


  17. SQL> alter system checkpoint;

  19. System altered.

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


  29. SQL> select  * from v$log;

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

  37. SQL> alter system switch logfile;

  39. System altered.

  41. SQL> select  * from v$log;

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

  49. SQL> alter system checkpoint;

  51. System altered.

  53. SQL> alter database clear logfile group 1;  

  55. Database altered.

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

  59. Database altered.

  61. 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

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

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

  7. connected to target database: ORCL (DBID=1359978017)
  8. connected to recovery catalog database

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


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

  131. Starting backup at 2018-06-09:20:18:27
  132. current log archived

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

  188. using channel ORA_SBT_TAPE_1
  189. using channel ORA_SBT_TAPE_2
  190. backup will be obsolete on date 2018-08-08:20:21:17
  191. archived logs required to recover from this backup will be backed up
  192. channel ORA_SBT_TAPE_1: starting full datafile backup set
  193. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  194. including current SPFILE in backup set
  195. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:20:21:17
  196. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:20:21:52
  197. piece handle=43t51plt_1_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  198. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35

  200. current log archived
  201. using channel ORA_SBT_TAPE_1
  202. using channel ORA_SBT_TAPE_2
  203. backup will be obsolete on date 2018-08-08:20:21:53
  204. archived logs required to recover from this backup will be backed up
  205. channel ORA_SBT_TAPE_1: starting archived log backup set
  206. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  207. input archived log thread=1 sequence=92 RECID=88 STAMP=978380512
  208. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:20:21:53
  209. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:20:22:28
  210. piece handle=44t51pn1_1_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  211. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35

  213. using channel ORA_SBT_TAPE_1
  214. using channel ORA_SBT_TAPE_2
  215. backup will be obsolete on date 2018-08-08:20:22:29
  216. archived logs required to recover from this backup will be backed up
  217. channel ORA_SBT_TAPE_1: starting full datafile backup set
  218. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  219. including current control file in backup set
  220. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:20:22:30
  221. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:20:23:05
  222. piece handle=45t51po5_1_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  223. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
  224. Finished backup at 2018-06-09:20:23:05

  226. Starting backup at 2018-06-09:20:23:05
  227. current log archived
  228. using channel ORA_SBT_TAPE_1
  229. using channel ORA_SBT_TAPE_2
  230. channel ORA_SBT_TAPE_1: starting archived log backup set
  231. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  232. input archived log thread=1 sequence=93 RECID=89 STAMP=978380585
  233. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:20:23:06
  234. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:20:23:51
  235. piece handle=46t51ppa_1_1 tag=9T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
  236. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45
  237. channel ORA_SBT_TAPE_1: deleting archived log(s)
  238. archived log file name=+FRA/orcl/archivelog/2018_06_09/thread_1_seq_93.327.978380585 RECID=89 STAMP=978380585
  239. Finished backup at 2018-06-09:20:23:51

  241. RMAN> backup  tag '10T_WHOLE_INCR1' incremental level 1 database  keep until time 'sysdate+60'  ;
  242. Starting backup at 2018-06-09:23:44:16
  243. starting full resync of recovery catalog
  244. full resync complete
  245. current log archived

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

  282. using channel ORA_SBT_TAPE_1
  283. using channel ORA_SBT_TAPE_2
  284. backup will be obsolete on date 2018-08-08:23:46:58
  285. archived logs required to recover from this backup will be backed up
  286. channel ORA_SBT_TAPE_1: starting full datafile backup set
  287. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  288. including current SPFILE in backup set
  289. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:23:46:58
  290. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:23:47:43
  291. piece handle=4at525ni_1_1 tag=10T_WHOLE_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
  292. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45

  294. current log archived
  295. using channel ORA_SBT_TAPE_1
  296. using channel ORA_SBT_TAPE_2
  297. backup will be obsolete on date 2018-08-08:23:47:44
  298. archived logs required to recover from this backup will be backed up
  299. channel ORA_SBT_TAPE_1: starting archived log backup set
  300. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  301. input archived log thread=1 sequence=95 RECID=91 STAMP=978392863
  302. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:23:47:44
  303. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:23:48:19
  304. piece handle=4bt525p0_1_1 tag=10T_WHOLE_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
  305. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35

  307. using channel ORA_SBT_TAPE_1
  308. using channel ORA_SBT_TAPE_2
  309. backup will be obsolete on date 2018-08-08:23:48:20
  310. archived logs required to recover from this backup will be backed up
  311. channel ORA_SBT_TAPE_1: starting full datafile backup set
  312. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  313. including current control file in backup set
  314. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-09:23:48:21
  315. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-09:23:48:56
  316. piece handle=4ct525q4_1_1 tag=10T_WHOLE_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
  317. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
  318. Finished backup at 2018-06-09:23:48:56

  320. RMAN> exit


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

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

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

  330. connected to target database: ORCL (DBID=1359978017)
  331. connected to recovery catalog database

  333. RMAN> resync catalog;

  335. starting full resync of recovery catalog
  336. full resync complete

  338. RMAN>
复制代码

db.png



回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-11-22 01:17 , Processed in 0.044247 second(s), 27 queries .

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