课程第31次

botang

块跟踪开启于新的0级备份之后：

1. select  * from v$block_change_tracking;
   
2. 
   
3. SELECT file#, avg(datafile_blocks),     
   
4.         avg(blocks_read),
   
5.         avg(blocks_read/datafile_blocks)
   
6.             * 100 AS PCT_READ_FOR_BACKUP,
   
7.        avg(blocks)
   
8.      FROM   v$backup_datafile
   
9.      WHERE  used_change_tracking = 'YES'
   
10.      AND    incremental_level > 0
    
11.      GROUP  BY file#;
    
12. 
    
13. alter database enable block change tracking using file '+fra';
    
14. 
    
15. select   file#,  used_change_tracking from v$backup_datafile;

复制代码

	FILE#	AVG(DATAFILE_BLOCKS)	AVG(BLOCKS_READ)	PCT_READ_FOR_BACKUP	AVG(BLOCKS)
1	1	97280	85	0.0873766447368421	14
2	2	72960	57	0.078125	8
3	5	44320	1	0.00225631768953069	1
4	4	1280	1	0.078125	1
5	3	13440	193	1.4360119047619	24

不开片：

1. RMAN>  backup tag '6T-SYSTEM-incr0'  incremental level 0  datafile 1;
   
2. 
   
3. Starting backup at 2019-07-24:20:57:11
   
4. using channel ORA_SBT_TAPE_1
   
5. using channel ORA_SBT_TAPE_2
   
6. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
   
7. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
   
8. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1013960881
   
9. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:20:57:12
   
10. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:20:57:57
    
11. piece handle=3tu7g0h8_1_1 tag=6T-SYSTEM-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
12. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45
    
13. Finished backup at 2019-07-24:20:57:57
    
14. 
    
15. Starting Control File and SPFILE Autobackup at 2019-07-24:20:57:57
    
16. piece handle=c-1541741703-20190724-06 comment=API Version 2.0,MMS Version 10.4.0.4
    
17. Finished Control File and SPFILE Autobackup at 2019-07-24:20:58:22
    

复制代码

新的开片：

1. RMAN>  backup section size 400M tag '7T-SYSTEM-INCR0' incremental level 0 datafile 1;
   
2. 
   
3. Starting backup at 2019-07-24:21:00:52
   
4. using target database control file instead of recovery catalog
   
5. allocated channel: ORA_SBT_TAPE_1
   
6. channel ORA_SBT_TAPE_1: SID=46 device type=SBT_TAPE
   
7. channel ORA_SBT_TAPE_1: Oracle Secure Backup
   
8. allocated channel: ORA_SBT_TAPE_2
   
9. channel ORA_SBT_TAPE_2: SID=58 device type=SBT_TAPE
   
10. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
11. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
    
12. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
13. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1013960881
    
14. backing up blocks 1 through 51200
    
15. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:21:01:05
    
16. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
    
17. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
18. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1013960881
    
19. backing up blocks 51201 through 97280
    
20. channel ORA_SBT_TAPE_2: starting piece 2 at 2019-07-24:21:01:05
    
21. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:21:01:30
    
22. piece handle=3vu7g0oh_1_1 tag=7T-SYSTEM-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
23. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
24. channel ORA_SBT_TAPE_2: finished piece 2 at 2019-07-24:21:01:50
    
25. piece handle=3vu7g0oh_2_1 tag=7T-SYSTEM-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
26. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:45
    
27. Finished backup at 2019-07-24:21:01:50
    
28. 
    
29. Starting Control File and SPFILE Autobackup at 2019-07-24:21:01:50
    
30. piece handle=c-1541741703-20190724-07 comment=API Version 2.0,MMS Version 10.4.0.4
    
31. Finished Control File and SPFILE Autobackup at 2019-07-24:21:02:15
    

复制代码

RMAN的“干”运行命令，也接受section size:

1. RMAN> backup validate   section size 400M    datafile 1;
   
2. 
   
3. Starting backup at 2019-07-24:21:04:28
   
4. using channel ORA_SBT_TAPE_1
   
5. using channel ORA_SBT_TAPE_2
   
6. channel ORA_SBT_TAPE_1: starting full datafile backup set
   
7. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
   
8. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1013960881
   
9. backing up blocks 1 through 51200
   
10. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
11. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
12. including current control file in backup set
    
13. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:01
    
14. List of Control File and SPFILE
    
15. ===============================
    
16. File Type    Status Blocks Failing Blocks Examined
    
17. ------------ ------ -------------- ---------------
    
18. Control File OK     0              616
    
19. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
20. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
21. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1013960881
    
22. backing up blocks 51201 through 97280
    
23. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:02
    
24. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
25. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
26. including current SPFILE in backup set
    
27. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01
    
28. List of Control File and SPFILE
    
29. ===============================
    
30. File Type    Status Blocks Failing Blocks Examined
    
31. ------------ ------ -------------- ---------------
    
32. SPFILE       OK     0              2
    
33. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:03
    
34. List of Datafiles
    
35. =================
    
36. File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
    
37. ---- ------ -------------- ------------ --------------- ----------
    
38. 1    OK     0              15730        97350           1304961
    
39.   File Name: +DATA/orcl/datafile/system.256.1013960881
    
40.   Block Type Blocks Failing Blocks Processed
    
41.   ---------- -------------- ----------------
    
42.   Data       0              64286
    
43.   Index      0              13303
    
44.   Other      0              3960
    
45. 
    
46. Finished backup at 2019-07-24:21:04:33
    
47. 
    
48. RMAN>
    

复制代码

事后change的弊端（要么所有日志都keep，要么所有都不keep）:

1. RMAN> change backupset 119 keep until time 'sysdate+100';
   
2. 
   
3. using channel ORA_SBT_TAPE_1
   
4. using channel ORA_SBT_TAPE_2
   
5. allocated channel: ORA_DISK_1
   
6. channel ORA_DISK_1: SID=69 device type=DISK
   
7. allocated channel: ORA_DISK_2
   
8. channel ORA_DISK_2: SID=25 device type=DISK
   
9. allocated channel: ORA_DISK_3
   
10. channel ORA_DISK_3: SID=56 device type=DISK
    
11. allocated channel: ORA_DISK_4
    
12. channel ORA_DISK_4: SID=55 device type=DISK
    
13. allocated channel: ORA_DISK_5
    
14. channel ORA_DISK_5: SID=54 device type=DISK
    
15. allocated channel: ORA_DISK_6
    
16. channel ORA_DISK_6: SID=53 device type=DISK
    
17. allocated channel: ORA_DISK_7
    
18. channel ORA_DISK_7: SID=52 device type=DISK
    
19. allocated channel: ORA_DISK_8
    
20. channel ORA_DISK_8: SID=51 device type=DISK
    
21. keep attributes for the backup are changed
    
22. backup will be obsolete on date 2019-11-01:21:20:31
    
23. backup set key=119 RECID=119 STAMP=1014498108
    
24. 
    
25. RMAN> list backupset 119;
    
26. 
    
27. 
    
28. List of Backup Sets
    
29. ===================
    
30. 
    
31. 
    
32. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
33. ------- ---- -- ---------- ----------- ------------ -------------------
    
34. 119     Incr 0  646.25M    SBT_TAPE    00:00:43     2019-07-24:21:01:48
    
35.         Keep: BACKUP_LOGS        Until: 2019-11-01:21:20:31
    
36.   List of Datafiles in backup set 119
    
37.   File LV Type Ckp SCN    Ckp Time            Name
    
38.   ---- -- ---- ---------- ------------------- ----
    
39.   1    0  Incr 1304874    2019-07-24:21:01:05 +DATA/orcl/datafile/system.256.1013960881
    
40. 
    
41.   Backup Set Copy #1 of backup set 119
    
42.   Device Type Elapsed Time Completion Time     Compressed Tag
    
43.   ----------- ------------ ------------------- ---------- ---
    
44.   SBT_TAPE    00:00:43     2019-07-24:21:01:48 NO         7T-SYSTEM-INCR0
    
45. 
    
46.     List of Backup Pieces for backup set 119 Copy #1
    
47.     BP Key  Pc# Status      Media                   Piece Name
    
48.     ------- --- ----------- ----------------------- ----------
    
49.     147     1   AVAILABLE   station76-000020        3vu7g0oh_1_1
    
50.     148     2   AVAILABLE   station76-000019,station76-000021 3vu7g0oh_2_1
    
51. 
    
52. RMAN> change backupset 119 nokeep;
    
53. 
    
54. using channel ORA_SBT_TAPE_1
    
55. using channel ORA_SBT_TAPE_2
    
56. using channel ORA_DISK_1
    
57. using channel ORA_DISK_2
    
58. using channel ORA_DISK_3
    
59. using channel ORA_DISK_4
    
60. using channel ORA_DISK_5
    
61. using channel ORA_DISK_6
    
62. using channel ORA_DISK_7
    
63. using channel ORA_DISK_8
    
64. keep attributes for the backup are deleted
    
65. backup set key=119 RECID=119 STAMP=1014498108
    
66. 
    
67. RMAN> list backupset 119;
    
68. 
    
69. 
    
70. List of Backup Sets
    
71. ===================
    
72. 
    
73. 
    
74. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
75. ------- ---- -- ---------- ----------- ------------ -------------------
    
76. 119     Incr 0  646.25M    SBT_TAPE    00:00:43     2019-07-24:21:01:48
    
77.   List of Datafiles in backup set 119
    
78.   File LV Type Ckp SCN    Ckp Time            Name
    
79.   ---- -- ---- ---------- ------------------- ----
    
80.   1    0  Incr 1304874    2019-07-24:21:01:05 +DATA/orcl/datafile/system.256.1013960881
    
81. 
    
82.   Backup Set Copy #1 of backup set 119
    
83.   Device Type Elapsed Time Completion Time     Compressed Tag
    
84.   ----------- ------------ ------------------- ---------- ---
    
85.   SBT_TAPE    00:00:43     2019-07-24:21:01:48 NO         7T-SYSTEM-INCR0
    
86. 
    
87.     List of Backup Pieces for backup set 119 Copy #1
    
88.     BP Key  Pc# Status      Media                   Piece Name
    
89.     ------- --- ----------- ----------------------- ----------
    
90.     147     1   AVAILABLE   station76-000020        3vu7g0oh_1_1
    
91.     148     2   AVAILABLE   station76-000019,station76-000021 3vu7g0oh_2_1
    
92. 
    
93. RMAN>  change backupset 119 keep  until time 'sysdate+100'  nologs;
    
94. 
    
95. using channel ORA_SBT_TAPE_1
    
96. using channel ORA_SBT_TAPE_2
    
97. using channel ORA_DISK_1
    
98. using channel ORA_DISK_2
    
99. using channel ORA_DISK_3
    
100. using channel ORA_DISK_4
     
101. using channel ORA_DISK_5
     
102. using channel ORA_DISK_6
     
103. using channel ORA_DISK_7
     
104. using channel ORA_DISK_8
     
105. keep attributes for the backup are changed
     
106. backup will be obsolete on date 2019-11-01:21:21:50
     
107. archived logs will not be kept or backed up
     
108. backup set key=119 RECID=119 STAMP=1014498108
     
109. 
     
110. RMAN> list backupset 119;
     
111. 
     
112. 
     
113. List of Backup Sets
     
114. ===================
     
115. 
     
116. 
     
117. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
118. ------- ---- -- ---------- ----------- ------------ -------------------
     
119. 119     Incr 0  646.25M    SBT_TAPE    00:00:43     2019-07-24:21:01:48
     
120.         Keep: NOLOGS             Until: 2019-11-01:21:21:50
     
121.   List of Datafiles in backup set 119
     
122.   File LV Type Ckp SCN    Ckp Time            Name
     
123.   ---- -- ---- ---------- ------------------- ----
     
124.   1    0  Incr 1304874    2019-07-24:21:01:05 +DATA/orcl/datafile/system.256.1013960881
     
125. 
     
126.   Backup Set Copy #1 of backup set 119
     
127.   Device Type Elapsed Time Completion Time     Compressed Tag
     
128.   ----------- ------------ ------------------- ---------- ---
     
129.   SBT_TAPE    00:00:43     2019-07-24:21:01:48 NO         7T-SYSTEM-INCR0
     
130. 
     
131.     List of Backup Pieces for backup set 119 Copy #1
     
132.     BP Key  Pc# Status      Media                   Piece Name
     
133.     ------- --- ----------- ----------------------- ----------
     
134.     147     1   AVAILABLE   station76-000020        3vu7g0oh_1_1
     
135.     148     2   AVAILABLE   station76-000019,station76-000021 3vu7g0oh_2_1
     
136. 
     
137. RMAN>
     

复制代码

关于keep forever：

1. RMAN> change backupset 119 keep forever;
   
2. 
   
3. using channel ORA_SBT_TAPE_1
   
4. using channel ORA_SBT_TAPE_2
   
5. using channel ORA_DISK_1
   
6. using channel ORA_DISK_2
   
7. using channel ORA_DISK_3
   
8. using channel ORA_DISK_4
   
9. using channel ORA_DISK_5
   
10. using channel ORA_DISK_6
    
11. using channel ORA_DISK_7
    
12. using channel ORA_DISK_8
    
13. RMAN-00571: ===========================================================
    
14. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
15. RMAN-00571: ===========================================================
    
16. RMAN-03002: failure of KEEP command at 07/24/2019 21:26:02
    
17. RMAN-06522: KEEP FOREVER option is not supported without the recovery catalog
    
18. 
    
19. RMAN> exit
    
20. 
    
21. 
    
22. Recovery Manager complete.
    
23. [oracle@station76 ~]$ rman target /  catalog u76/oracle_4U@rcat
    
24. 
    
25. Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jul 24 21:26:32 2019
    
26. 
    
27. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
    
28. 
    
29. connected to target database: ORCL (DBID=1541741703)
    
30. connected to recovery catalog database
    
31. 
    
32. RMAN> list backup;
    
33. 
    
34. starting full resync of recovery catalog
    
35. full resync complete
    
36. 
    
37. List of Backup Sets
    
38. ===================
    
39. 
    
40. 
    
41. BS Key  Size       Device Type Elapsed Time Completion Time
    
42. ------- ---------- ----------- ------------ -------------------
    
43. 1258    512.00K    SBT_TAPE    00:00:24     2019-07-24:20:18:46
    
44.         BP Key: 1288   Status: AVAILABLE  Compressed: NO  Tag: 1T-WHOLE-INCR0
    
45.         Handle: 33u7fu8e_1_1   Media: station76-000019
    
46. 
    
47.   List of Archived Logs in backup set 1258
    
48.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
    
49.   ---- ------- ---------- ------------------- ---------- ---------
    
50.   1    80      1301856    2019-07-24:19:56:41 1303036    2019-07-24:20:17:44
    
51. 
    
52. BS Key  Size       Device Type Elapsed Time Completion Time
    
53. ------- ---------- ----------- ------------ -------------------
    
54. 1259    256.00K    SBT_TAPE    00:00:25     2019-07-24:20:18:47
    
55.         BP Key: 1289   Status: AVAILABLE  Compressed: NO  Tag: 1T-WHOLE-INCR0
    
56.         Handle: 34u7fu8e_1_1   Media: station76-000018
    
57. 
    
58.   List of Archived Logs in backup set 1259
    
59.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
    
60.   ---- ------- ---------- ------------------- ---------- ---------
    
61.   1    81      1303036    2019-07-24:20:17:44 1303085    2019-07-24:20:18:20
    
62. 
    
63. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
64. ------- ---- -- ---------- ----------- ------------ -------------------
    
65. 1260    Incr 0  434.25M    SBT_TAPE    00:00:42     2019-07-24:20:19:31
    
66.         BP Key: 1290   Status: AVAILABLE  Compressed: NO  Tag: 1T-WHOLE-INCR0
    
67.         Handle: 36u7fu99_1_1   Media: station76-000018
    
68.   List of Datafiles in backup set 1260
    
69.   File LV Type Ckp SCN    Ckp Time            Name
    
70.   ---- -- ---- ---------- ------------------- ----
    
71.   2    0  Incr 1303104    2019-07-24:20:18:49 +DATA/orcl/datafile/sysaux.257.1013960883
    
72.   3    0  Incr 1303104    2019-07-24:20:18:49 +DATA/orcl/datafile/undotbs1.258.1013960883
    
73.   4    0  Incr 1303104    2019-07-24:20:18:49 +DATA/orcl/datafile/users.259.1014330935
    
74. 
    
75. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
76. ------- ---- -- ---------- ----------- ------------ -------------------
    
77. 1261    Incr 0  715.00M    SBT_TAPE    00:00:56     2019-07-24:20:19:44
    
78.         BP Key: 1291   Status: AVAILABLE  Compressed: NO  Tag: 1T-WHOLE-INCR0
    
79.         Handle: 35u7fu98_1_1   Media: station76-000019
    
80.   List of Datafiles in backup set 1261
    
81.   File LV Type Ckp SCN    Ckp Time            Name
    
82.   ---- -- ---- ---------- ------------------- ----
    
83.   1    0  Incr 1303103    2019-07-24:20:18:49 +DATA/orcl/datafile/system.256.1013960881
    
84.   5    0  Incr 1303103    2019-07-24:20:18:49 +DATA/orcl/datafile/example.265.1013960987
    
85. 
    
86. BS Key  Size       Device Type Elapsed Time Completion Time
    
87. ------- ---------- ----------- ------------ -------------------
    
88. 1262    256.00K    SBT_TAPE    00:00:15     2019-07-24:20:20:11
    
89.         BP Key: 1292   Status: AVAILABLE  Compressed: NO  Tag: 1T-WHOLE-INCR0
    
90.         Handle: 37u7fubc_1_1   Media: station76-000019
    
91. 
    
92.   List of Archived Logs in backup set 1262
    
93.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
    
94.   ---- ------- ---------- ------------------- ---------- ---------
    
95.   1    82      1303085    2019-07-24:20:18:20 1303137    2019-07-24:20:19:54
    
96. 
    
97. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
98. ------- ---- -- ---------- ----------- ------------ -------------------
    
99. 1263    Full    9.75M      SBT_TAPE    00:00:21     2019-07-24:20:20:42
    
100.         BP Key: 1293   Status: AVAILABLE  Compressed: NO  Tag: TAG20190724T202021
     
101.         Handle: c-1541741703-20190724-01   Media: station76-000019
     
102.   SPFILE Included: Modification time: 2019-07-24:19:57:18
     
103.   SPFILE db_unique_name: ORCL
     
104.   Control File Included: Ckp SCN: 1303156      Ckp time: 2019-07-24:20:20:21
     
105. 
     
106. BS Key  Size       Device Type Elapsed Time Completion Time
     
107. ------- ---------- ----------- ------------ -------------------
     
108. 1264    25.75M     SBT_TAPE    00:00:15     2019-07-24:20:32:36
     
109.         BP Key: 1294   Status: AVAILABLE  Compressed: NO  Tag: 2T-WHOLE-INCR1
     
110.         Handle: 39u7fv2l_1_1   Media: station76-000018
     
111. 
     
112.   List of Archived Logs in backup set 1264
     
113.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
     
114.   ---- ------- ---------- ------------------- ---------- ---------
     
115.   1    83      1303137    2019-07-24:20:19:54 1303884    2019-07-24:20:32:21
     
116. 
     
117. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
118. ------- ---- -- ---------- ----------- ------------ -------------------
     
119. 1265    Incr 1  9.25M      SBT_TAPE    00:00:19     2019-07-24:20:32:58
     
120.         BP Key: 1295   Status: AVAILABLE  Compressed: NO  Tag: 2T-WHOLE-INCR1
     
121.         Handle: 3bu7fv37_1_1   Media: station76-000018
     
122.   List of Datafiles in backup set 1265
     
123.   File LV Type Ckp SCN    Ckp Time            Name
     
124.   ---- -- ---- ---------- ------------------- ----
     
125.   2    1  Incr 1303898    2019-07-24:20:32:39 +DATA/orcl/datafile/sysaux.257.1013960883
     
126.   3    1  Incr 1303898    2019-07-24:20:32:39 +DATA/orcl/datafile/undotbs1.258.1013960883
     
127.   4    1  Incr 1303898    2019-07-24:20:32:39 +DATA/orcl/datafile/users.259.1014330935
     
128. 
     
129. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
130. ------- ---- -- ---------- ----------- ------------ -------------------
     
131. 1266    Incr 1  512.00K    SBT_TAPE    00:00:32     2019-07-24:20:33:11
     
132.         BP Key: 1296   Status: AVAILABLE  Compressed: NO  Tag: 2T-WHOLE-INCR1
     
133.         Handle: 3au7fv37_1_1   Media: station76-000019
     
134.   List of Datafiles in backup set 1266
     
135.   File LV Type Ckp SCN    Ckp Time            Name
     
136.   ---- -- ---- ---------- ------------------- ----
     
137.   1    1  Incr 1303897    2019-07-24:20:32:39 +DATA/orcl/datafile/system.256.1013960881
     
138.   5    1  Incr 1303897    2019-07-24:20:32:39 +DATA/orcl/datafile/example.265.1013960987
     
139. 
     
140. BS Key  Size       Device Type Elapsed Time Completion Time
     
141. ------- ---------- ----------- ------------ -------------------
     
142. 1267    256.00K    SBT_TAPE    00:00:16     2019-07-24:20:33:33
     
143.         BP Key: 1297   Status: AVAILABLE  Compressed: NO  Tag: 2T-WHOLE-INCR1
     
144.         Handle: 3cu7fv4d_1_1   Media: station76-000018
     
145. 
     
146.   List of Archived Logs in backup set 1267
     
147.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
     
148.   ---- ------- ---------- ------------------- ---------- ---------
     
149.   1    84      1303884    2019-07-24:20:32:21 1303918    2019-07-24:20:33:14
     
150. 
     
151. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
152. ------- ---- -- ---------- ----------- ------------ -------------------
     
153. 1268    Full    9.75M      SBT_TAPE    00:00:20     2019-07-24:20:34:03
     
154.         BP Key: 1298   Status: AVAILABLE  Compressed: NO  Tag: TAG20190724T203343
     
155.         Handle: c-1541741703-20190724-02   Media: station76-000018
     
156.   SPFILE Included: Modification time: 2019-07-24:20:27:55
     
157.   SPFILE db_unique_name: ORCL
     
158.   Control File Included: Ckp SCN: 1303938      Ckp time: 2019-07-24:20:33:43
     
159. 
     
160. BS Key  Size       Device Type Elapsed Time Completion Time
     
161. ------- ---------- ----------- ------------ -------------------
     
162. 1269    2.50M      SBT_TAPE    00:00:26     2019-07-24:20:39:46
     
163.         BP Key: 1299   Status: AVAILABLE  Compressed: NO  Tag: 3T-WHOLE-INCR1
     
164.         Handle: 3eu7fvfo_1_1   Media: station76-000018
     
165. 
     
166.   List of Archived Logs in backup set 1269
     
167.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
     
168.   ---- ------- ---------- ------------------- ---------- ---------
     
169.   1    85      1303918    2019-07-24:20:33:14 1304132    2019-07-24:20:39:18
     
170. 
     
171. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
172. ------- ---- -- ---------- ----------- ------------ -------------------
     
173. 1270    Incr 1  2.75M      SBT_TAPE    00:00:37     2019-07-24:20:40:34
     
174.         BP Key: 1300   Status: AVAILABLE  Compressed: NO  Tag: 3T-WHOLE-INCR1
     
175.         Handle: 3gu7fvgt_1_1   Media: station76-000018
     
176.   List of Datafiles in backup set 1270
     
177.   File LV Type Ckp SCN    Ckp Time            Name
     
178.   ---- -- ---- ---------- ------------------- ----
     
179.   2    1  Incr 1304157    2019-07-24:20:39:57 +DATA/orcl/datafile/sysaux.257.1013960883
     
180.   3    1  Incr 1304157    2019-07-24:20:39:57 +DATA/orcl/datafile/undotbs1.258.1013960883
     
181.   4    1  Incr 1304157    2019-07-24:20:39:57 +DATA/orcl/datafile/users.259.1014330935
     
182. 
     
183. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
184. ------- ---- -- ---------- ----------- ------------ -------------------
     
185. 1271    Incr 1  256.00K    SBT_TAPE    00:00:38     2019-07-24:20:40:35
     
186.         BP Key: 1301   Status: AVAILABLE  Compressed: NO  Tag: 3T-WHOLE-INCR1
     
187.         Handle: 3fu7fvgt_1_1   Media: station76-000019
     
188.   List of Datafiles in backup set 1271
     
189.   File LV Type Ckp SCN    Ckp Time            Name
     
190.   ---- -- ---- ---------- ------------------- ----
     
191.   1    1  Incr 1304154    2019-07-24:20:39:57 +DATA/orcl/datafile/system.256.1013960881
     
192.   5    1  Incr 1304154    2019-07-24:20:39:57 +DATA/orcl/datafile/example.265.1013960987
     
193. 
     
194. BS Key  Size       Device Type Elapsed Time Completion Time
     
195. ------- ---------- ----------- ------------ -------------------
     
196. 1272    256.00K    SBT_TAPE    00:00:24     2019-07-24:20:41:07
     
197.         BP Key: 1302   Status: AVAILABLE  Compressed: NO  Tag: 3T-WHOLE-INCR1
     
198.         Handle: 3hu7fvib_1_1   Media: station76-000018
     
199. 
     
200.   List of Archived Logs in backup set 1272
     
201.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
     
202.   ---- ------- ---------- ------------------- ---------- ---------
     
203.   1    86      1304132    2019-07-24:20:39:18 1304178    2019-07-24:20:40:42
     
204. 
     
205. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
206. ------- ---- -- ---------- ----------- ------------ -------------------
     
207. 1273    Full    9.75M      SBT_TAPE    00:00:16     2019-07-24:20:41:25
     
208.         BP Key: 1303   Status: AVAILABLE  Compressed: NO  Tag: TAG20190724T204109
     
209.         Handle: c-1541741703-20190724-03   Media: station76-000018
     
210.   SPFILE Included: Modification time: 2019-07-24:20:27:55
     
211.   SPFILE db_unique_name: ORCL
     
212.   Control File Included: Ckp SCN: 1304197      Ckp time: 2019-07-24:20:41:09
     
213. 
     
214. BS Key  Size       Device Type Elapsed Time Completion Time
     
215. ------- ---------- ----------- ------------ -------------------
     
216. 1274    256.00K    SBT_TAPE    00:00:21     2019-07-24:20:45:18
     
217.         BP Key: 1304   Status: AVAILABLE  Compressed: NO  Tag: 4T-WHOLE-INCR0
     
218.         Handle: 3ju7fvq9_1_1   Media: station76-000018
     
219. 
     
220.   List of Archived Logs in backup set 1274
     
221.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
     
222.   ---- ------- ---------- ------------------- ---------- ---------
     
223.   1    87      1304178    2019-07-24:20:40:42 1304319    2019-07-24:20:44:56
     
224. 
     
225. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
226. ------- ---- -- ---------- ----------- ------------ -------------------
     
227. 1275    Incr 0  445.50M    SBT_TAPE    00:00:34     2019-07-24:20:45:58
     
228.         BP Key: 1305   Status: AVAILABLE  Compressed: NO  Tag: 4T-WHOLE-INCR0
     
229.         Handle: 3lu7fvr4_1_1   Media: station76-000019
     
230.   List of Datafiles in backup set 1275
     
231.   File LV Type Ckp SCN    Ckp Time            Name
     
232.   ---- -- ---- ---------- ------------------- ----
     
233.   2    0  Incr 1304340    2019-07-24:20:45:24 +DATA/orcl/datafile/sysaux.257.1013960883
     
234.   3    0  Incr 1304340    2019-07-24:20:45:24 +DATA/orcl/datafile/undotbs1.258.1013960883
     
235.   4    0  Incr 1304340    2019-07-24:20:45:24 +DATA/orcl/datafile/users.259.1014330935
     
236. 
     
237. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
238. ------- ---- -- ---------- ----------- ------------ -------------------
     
239. 1276    Incr 0  715.00M    SBT_TAPE    00:00:34     2019-07-24:20:45:58
     
240.         BP Key: 1306   Status: AVAILABLE  Compressed: NO  Tag: 4T-WHOLE-INCR0
     
241.         Handle: 3ku7fvr4_1_1   Media: station76-000018
     
242.   List of Datafiles in backup set 1276
     
243.   File LV Type Ckp SCN    Ckp Time            Name
     
244.   ---- -- ---- ---------- ------------------- ----
     
245.   1    0  Incr 1304336    2019-07-24:20:45:24 +DATA/orcl/datafile/system.256.1013960881
     
246.   5    0  Incr 1304336    2019-07-24:20:45:24 +DATA/orcl/datafile/example.265.1013960987
     
247. 
     
248. BS Key  Size       Device Type Elapsed Time Completion Time
     
249. ------- ---------- ----------- ------------ -------------------
     
250. 1277    256.00K    SBT_TAPE    00:00:25     2019-07-24:20:46:26
     
251.         BP Key: 1307   Status: AVAILABLE  Compressed: NO  Tag: 4T-WHOLE-INCR0
     
252.         Handle: 3mu7fvs9_1_1   Media: station76-000018
     
253. 
     
254.   List of Archived Logs in backup set 1277
     
255.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
     
256.   ---- ------- ---------- ------------------- ---------- ---------
     
257.   1    88      1304319    2019-07-24:20:44:56 1304357    2019-07-24:20:46:00
     
258. 
     
259. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
260. ------- ---- -- ---------- ----------- ------------ -------------------
     
261. 1278    Full    9.75M      SBT_TAPE    00:00:15     2019-07-24:20:46:52
     
262.         BP Key: 1308   Status: AVAILABLE  Compressed: NO  Tag: TAG20190724T204637
     
263.         Handle: c-1541741703-20190724-04   Media: station76-000018
     
264.   SPFILE Included: Modification time: 2019-07-24:20:27:55
     
265.   SPFILE db_unique_name: ORCL
     
266.   Control File Included: Ckp SCN: 1304381      Ckp time: 2019-07-24:20:46:37
     
267. 
     
268. BS Key  Size       Device Type Elapsed Time Completion Time
     
269. ------- ---------- ----------- ------------ -------------------
     
270. 1279    256.00K    SBT_TAPE    00:00:17     2019-07-24:20:50:38
     
271.         BP Key: 1309   Status: AVAILABLE  Compressed: NO  Tag: 5TT-WHOLE-INCR1
     
272.         Handle: 3ou7g04d_1_1   Media: station76-000018
     
273. 
     
274.   List of Archived Logs in backup set 1279
     
275.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
     
276.   ---- ------- ---------- ------------------- ---------- ---------
     
277.   1    89      1304357    2019-07-24:20:46:00 1304547    2019-07-24:20:50:21
     
278. 
     
279. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
280. ------- ---- -- ---------- ----------- ------------ -------------------
     
281. 1280    Incr 1  256.00K    SBT_TAPE    00:00:32     2019-07-24:20:51:22
     
282.         BP Key: 1310   Status: AVAILABLE  Compressed: NO  Tag: 5TT-WHOLE-INCR1
     
283.         Handle: 3pu7g05a_1_1   Media: station76-000019
     
284.   List of Datafiles in backup set 1280
     
285.   File LV Type Ckp SCN    Ckp Time            Name
     
286.   ---- -- ---- ---------- ------------------- ----
     
287.   1    1  Incr 1304567    2019-07-24:20:50:50 +DATA/orcl/datafile/system.256.1013960881
     
288.   5    1  Incr 1304567    2019-07-24:20:50:50 +DATA/orcl/datafile/example.265.1013960987
     
289. 
     
290. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
291. ------- ---- -- ---------- ----------- ------------ -------------------
     
292. 1281    Incr 1  512.00K    SBT_TAPE    00:00:33     2019-07-24:20:51:23
     
293.         BP Key: 1311   Status: AVAILABLE  Compressed: NO  Tag: 5TT-WHOLE-INCR1
     
294.         Handle: 3qu7g05a_1_1   Media: station76-000018
     
295.   List of Datafiles in backup set 1281
     
296.   File LV Type Ckp SCN    Ckp Time            Name
     
297.   ---- -- ---- ---------- ------------------- ----
     
298.   2    1  Incr 1304570    2019-07-24:20:50:51 +DATA/orcl/datafile/sysaux.257.1013960883
     
299.   3    1  Incr 1304570    2019-07-24:20:50:51 +DATA/orcl/datafile/undotbs1.258.1013960883
     
300.   4    1  Incr 1304570    2019-07-24:20:50:51 +DATA/orcl/datafile/users.259.1014330935
     
301. 
     
302. BS Key  Size       Device Type Elapsed Time Completion Time
     
303. ------- ---------- ----------- ------------ -------------------
     
304. 1282    256.00K    SBT_TAPE    00:00:22     2019-07-24:20:51:49
     
305.         BP Key: 1312   Status: AVAILABLE  Compressed: NO  Tag: 5TT-WHOLE-INCR1
     
306.         Handle: 3ru7g06f_1_1   Media: station76-000018
     
307. 
     
308.   List of Archived Logs in backup set 1282
     
309.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
     
310.   ---- ------- ---------- ------------------- ---------- ---------
     
311.   1    90      1304547    2019-07-24:20:50:21 1304588    2019-07-24:20:51:26
     
312. 
     
313. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
314. ------- ---- -- ---------- ----------- ------------ -------------------
     
315. 1283    Full    9.75M      SBT_TAPE    00:00:16     2019-07-24:20:52:08
     
316.         BP Key: 1313   Status: AVAILABLE  Compressed: NO  Tag: TAG20190724T205152
     
317.         Handle: c-1541741703-20190724-05   Media: station76-000018
     
318.   SPFILE Included: Modification time: 2019-07-24:20:27:55
     
319.   SPFILE db_unique_name: ORCL
     
320.   Control File Included: Ckp SCN: 1304608      Ckp time: 2019-07-24:20:51:52
     
321. 
     
322. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
323. ------- ---- -- ---------- ----------- ------------ -------------------
     
324. 1284    Incr 0  646.00M    SBT_TAPE    00:00:35     2019-07-24:20:57:47
     
325.         BP Key: 1314   Status: AVAILABLE  Compressed: NO  Tag: 6T-SYSTEM-INCR0
     
326.         Handle: 3tu7g0h8_1_1   Media: station76-000018,station76-000020
     
327.   List of Datafiles in backup set 1284
     
328.   File LV Type Ckp SCN    Ckp Time            Name
     
329.   ---- -- ---- ---------- ------------------- ----
     
330.   1    0  Incr 1304745    2019-07-24:20:57:12 +DATA/orcl/datafile/system.256.1013960881
     
331. 
     
332. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
333. ------- ---- -- ---------- ----------- ------------ -------------------
     
334. 1285    Full    9.75M      SBT_TAPE    00:00:24     2019-07-24:20:58:21
     
335.         BP Key: 1315   Status: AVAILABLE  Compressed: NO  Tag: TAG20190724T205757
     
336.         Handle: c-1541741703-20190724-06   Media: station76-000020
     
337.   SPFILE Included: Modification time: 2019-07-24:20:27:55
     
338.   SPFILE db_unique_name: ORCL
     
339.   Control File Included: Ckp SCN: 1304767      Ckp time: 2019-07-24:20:57:57
     
340. 
     
341. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
342. ------- ---- -- ---------- ----------- ------------ -------------------
     
343. 1286    Incr 0  646.25M    SBT_TAPE    00:00:43     2019-07-24:21:01:48
     
344.   List of Datafiles in backup set 1286
     
345.   File LV Type Ckp SCN    Ckp Time            Name
     
346.   ---- -- ---- ---------- ------------------- ----
     
347.   1    0  Incr 1304874    2019-07-24:21:01:05 +DATA/orcl/datafile/system.256.1013960881
     
348. 
     
349.   Backup Set Copy #1 of backup set 1286
     
350.   Device Type Elapsed Time Completion Time     Compressed Tag
     
351.   ----------- ------------ ------------------- ---------- ---
     
352.   SBT_TAPE    00:00:43     2019-07-24:21:01:48 NO         7T-SYSTEM-INCR0
     
353. 
     
354.     List of Backup Pieces for backup set 1286 Copy #1
     
355.     BP Key  Pc# Status      Media                   Piece Name
     
356.     ------- --- ----------- ----------------------- ----------
     
357.     1316    1   AVAILABLE   station76-000020        3vu7g0oh_1_1
     
358.     1317    2   AVAILABLE   station76-000019,station76-000021 3vu7g0oh_2_1
     
359. 
     
360. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
361. ------- ---- -- ---------- ----------- ------------ -------------------
     
362. 1287    Full    9.75M      SBT_TAPE    00:00:21     2019-07-24:21:02:11
     
363.         BP Key: 1318   Status: AVAILABLE  Compressed: NO  Tag: TAG20190724T210150
     
364.         Handle: c-1541741703-20190724-07   Media: station76-000020
     
365.   SPFILE Included: Modification time: 2019-07-24:20:27:55
     
366.   SPFILE db_unique_name: ORCL
     
367.   Control File Included: Ckp SCN: 1304969      Ckp time: 2019-07-24:21:01:50
     
368. 
     
369. RMAN> change backupset 1286  keep forever logs;
     
370. 
     
371. allocated channel: ORA_SBT_TAPE_1
     
372. channel ORA_SBT_TAPE_1: SID=47 device type=SBT_TAPE
     
373. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
374. allocated channel: ORA_SBT_TAPE_2
     
375. channel ORA_SBT_TAPE_2: SID=53 device type=SBT_TAPE
     
376. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
377. allocated channel: ORA_DISK_1
     
378. channel ORA_DISK_1: SID=52 device type=DISK
     
379. allocated channel: ORA_DISK_2
     
380. channel ORA_DISK_2: SID=54 device type=DISK
     
381. allocated channel: ORA_DISK_3
     
382. channel ORA_DISK_3: SID=55 device type=DISK
     
383. allocated channel: ORA_DISK_4
     
384. channel ORA_DISK_4: SID=56 device type=DISK
     
385. allocated channel: ORA_DISK_5
     
386. channel ORA_DISK_5: SID=25 device type=DISK
     
387. allocated channel: ORA_DISK_6
     
388. channel ORA_DISK_6: SID=69 device type=DISK
     
389. allocated channel: ORA_DISK_7
     
390. channel ORA_DISK_7: SID=50 device type=DISK
     
391. allocated channel: ORA_DISK_8
     
392. channel ORA_DISK_8: SID=49 device type=DISK
     
393. keep attributes for the backup are changed
     
394. backup will never be obsolete
     
395. archived logs required to recover from this backup will expire when this backup expires
     
396. backup set key=1286 RECID=119 STAMP=1014498108
     
397. 
     

复制代码

这就是新特性：

1. RMAN>  backup keep until  time 'sysdate+100' tag '8T-SYSTEM-INCR0' incremental level 0 tablespace system;
   
2. 
   
3. Starting backup at 2019-07-24:21:31:35
   
4. current log archived
   
5. 
   
6. released channel: ORA_DISK_1
   
7. released channel: ORA_DISK_2
   
8. released channel: ORA_DISK_3
   
9. released channel: ORA_DISK_4
   
10. released channel: ORA_DISK_5
    
11. released channel: ORA_DISK_6
    
12. released channel: ORA_DISK_7
    
13. released channel: ORA_DISK_8
    
14. using channel ORA_SBT_TAPE_1
    
15. using channel ORA_SBT_TAPE_2
    
16. backup will be obsolete on date 2019-11-01:21:31:38
    
17. archived logs required to recover from this backup will be backed up
    
18. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
    
19. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
20. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1013960881
    
21. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:21:31:39
    
22. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:21:32:24
    
23. piece handle=46u7g2hr_1_1 tag=8T-SYSTEM-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
24. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45
    
25. 
    
26. using channel ORA_SBT_TAPE_1
    
27. using channel ORA_SBT_TAPE_2
    
28. backup will be obsolete on date 2019-11-01:21:32:24
    
29. archived logs required to recover from this backup will be backed up
    
30. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
31. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
32. including current SPFILE in backup set
    
33. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:21:32:26
    
34. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:21:32:51
    
35. piece handle=47u7g2ja_1_1 tag=8T-SYSTEM-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
36. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
37. 
    
38. current log archived
    
39. using channel ORA_SBT_TAPE_1
    
40. using channel ORA_SBT_TAPE_2
    
41. backup will be obsolete on date 2019-11-01:21:32:55
    
42. archived logs required to recover from this backup will be backed up
    
43. channel ORA_SBT_TAPE_1: starting archived log backup set
    
44. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
    
45. input archived log thread=1 sequence=92 RECID=87 STAMP=1014499972
    
46. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:21:32:55
    
47. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:21:33:20
    
48. piece handle=48u7g2k7_1_1 tag=8T-SYSTEM-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
49. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
50. 
    
51. using channel ORA_SBT_TAPE_1
    
52. using channel ORA_SBT_TAPE_2
    
53. backup will be obsolete on date 2019-11-01:21:33:20
    
54. archived logs required to recover from this backup will be backed up
    
55. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
56. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
57. including current control file in backup set
    
58. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:21:33:25
    
59. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:21:33:50
    
60. piece handle=49u7g2l4_1_1 tag=8T-SYSTEM-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
61. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
62. Finished backup at 2019-07-24:21:33:50
    
63. 
    
64. RMAN>
    

复制代码

restore point：

1. RMAN>   backup keep forever  restore point very_important  tag '9T-WHOLE-INCR0' incremental level 0 database   plus archivelog delete all inp

复制代码

1. select * from v$restore_point;

复制代码

1. 
   

复制代码

	SCN	DATABASE_INCARNATION#	GUARANTEE_FLASHBACK_DATABASE	STORAGE_SIZE	TIME	RESTORE_POINT_TIME	PRESERVED	NAME
1	1306323	2	NO	0	24-7月 -19 09.42.20.000000000 下午		NO	VERY_IMPORTANT

补充：
关于需要多少段增量备份来进行恢复：

1. [oracle@station76 ~]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jul 24 22:01:19 2019
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1541741703)
   
8. 
   
9. RMAN> list backup;
   
10. 
    
11. using target database control file instead of recovery catalog
    
12. specification does not match any backup in the repository
    
13. 
    
14. RMAN> list copy;
    
15. 
    
16. specification does not match any datafile copy in the repository
    
17. specification does not match any control file copy in the repository
    
18. specification does not match any archived log in the repository
    
19. 
    
20. RMAN> backup tag '1T-WHOLE-INCR0' incremental level 0 database plus archivelog delete all input;
    
21. 
    
22. 
    
23. Starting backup at 2019-07-24:22:02:50
    
24. current log archived
    
25. allocated channel: ORA_SBT_TAPE_1
    
26. channel ORA_SBT_TAPE_1: SID=47 device type=SBT_TAPE
    
27. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
28. allocated channel: ORA_SBT_TAPE_2
    
29. channel ORA_SBT_TAPE_2: SID=49 device type=SBT_TAPE
    
30. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
31. channel ORA_SBT_TAPE_1: starting archived log backup set
    
32. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
    
33. input archived log thread=1 sequence=97 RECID=92 STAMP=1014501770
    
34. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:22:03:04
    
35. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:22:03:29
    
36. piece handle=4ju7g4co_1_1 tag=1T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
37. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
38. channel ORA_SBT_TAPE_1: deleting archived log(s)
    
39. archived log file name=+FRA/orcl/archivelog/2019_07_24/thread_1_seq_97.303.1014501771 RECID=92 STA                                                           MP=1014501770
    
40. Finished backup at 2019-07-24:22:03:30
    
41. 
    
42. Starting backup at 2019-07-24:22:03:30
    
43. using channel ORA_SBT_TAPE_1
    
44. using channel ORA_SBT_TAPE_2
    
45. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
    
46. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
47. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1013960881
    
48. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.1013960987
    
49. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:22:03:31
    
50. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
    
51. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
52. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.1013960883
    
53. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.1013960883
    
54. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1014330935
    
55. channel ORA_SBT_TAPE_2: starting piece 1 at 2019-07-24:22:03:31
    
56. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:22:04:06
    
57. piece handle=4ku7g4dj_1_1 tag=1T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
58. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
    
59. channel ORA_SBT_TAPE_2: finished piece 1 at 2019-07-24:22:04:16
    
60. piece handle=4lu7g4dj_1_1 tag=1T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
61. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:45
    
62. Finished backup at 2019-07-24:22:04:17
    
63. 
    
64. Starting backup at 2019-07-24:22:04:17
    
65. current log archived
    
66. using channel ORA_SBT_TAPE_1
    
67. using channel ORA_SBT_TAPE_2
    
68. channel ORA_SBT_TAPE_1: starting archived log backup set
    
69. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
    
70. input archived log thread=1 sequence=98 RECID=93 STAMP=1014501858
    
71. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:22:04:19
    
72. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:22:04:44
    
73. piece handle=4mu7g4f3_1_1 tag=1T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
    
74. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
75. channel ORA_SBT_TAPE_1: deleting archived log(s)
    
76. archived log file name=+FRA/orcl/archivelog/2019_07_24/thread_1_seq_98.303.1014501859 RECID=93 STA                                                           MP=1014501858
    
77. Finished backup at 2019-07-24:22:04:44
    
78. 
    
79. Starting Control File and SPFILE Autobackup at 2019-07-24:22:04:45
    
80. piece handle=c-1541741703-20190724-09 comment=API Version 2.0,MMS Version 10.4.0.4
    
81. Finished Control File and SPFILE Autobackup at 2019-07-24:22:05:10
    
82. 
    
83. RMAN> backup tag '2T-WHOLE-INCR1' incremental level 1 database ;
    
84. 
    
85. Starting backup at 2019-07-24:22:06:28
    
86. using channel ORA_SBT_TAPE_1
    
87. using channel ORA_SBT_TAPE_2
    
88. channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set
    
89. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
90. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1013960881
    
91. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.1013960987
    
92. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:22:06:28
    
93. channel ORA_SBT_TAPE_2: starting incremental level 1 datafile backup set
    
94. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
95. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.1013960883
    
96. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.1013960883
    
97. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1014330935
    
98. channel ORA_SBT_TAPE_2: starting piece 1 at 2019-07-24:22:06:29
    
99. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:22:06:54
    
100. piece handle=4ou7g4j4_1_1 tag=2T-WHOLE-INCR1 comment=API Version 2.0,MMS Version 10.4.0.4
     
101. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
     
102. channel ORA_SBT_TAPE_2: finished piece 1 at 2019-07-24:22:07:04
     
103. piece handle=4pu7g4j4_1_1 tag=2T-WHOLE-INCR1 comment=API Version 2.0,MMS Version 10.4.0.4
     
104. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:35
     
105. Finished backup at 2019-07-24:22:07:04
     
106. 
     
107. Starting Control File and SPFILE Autobackup at 2019-07-24:22:07:04
     
108. piece handle=c-1541741703-20190724-0a comment=API Version 2.0,MMS Version 10.4.0.4
     
109. Finished Control File and SPFILE Autobackup at 2019-07-24:22:07:29
     
110. 
     
111. RMAN> report need backup incremental 0;
     
112. 
     
113. Report of files that need more than 0 incrementals during recovery
     
114. File Incrementals Name
     
115. ---- ------------ ----------------------------------------------
     
116. 1    1            +DATA/orcl/datafile/system.256.1013960881
     
117. 2    1            +DATA/orcl/datafile/sysaux.257.1013960883
     
118. 3    1            +DATA/orcl/datafile/undotbs1.258.1013960883
     
119. 4    1            +DATA/orcl/datafile/users.259.1014330935
     
120. 5    1            +DATA/orcl/datafile/example.265.1013960987
     
121. 
     
122. RMAN>  report need backup incremental 1;
     
123. 
     
124. Report of files that need more than 1 incrementals during recovery
     
125. File Incrementals Name
     
126. ---- ------------ ----------------------------------------------
     
127. 
     
128. 
     
129. RMAN> backup tag '3T-WHOLE-INCR1' incremental level 1 database ;
     
130. 
     
131. Starting backup at 2019-07-24:22:09:06
     
132. using channel ORA_SBT_TAPE_1
     
133. using channel ORA_SBT_TAPE_2
     
134. channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set
     
135. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
136. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1013960881
     
137. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.1013960987
     
138. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:22:09:07
     
139. channel ORA_SBT_TAPE_2: starting incremental level 1 datafile backup set
     
140. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
141. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.1013960883
     
142. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.1013960883
     
143. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1014330935
     
144. channel ORA_SBT_TAPE_2: starting piece 1 at 2019-07-24:22:09:07
     
145. channel ORA_SBT_TAPE_2: finished piece 1 at 2019-07-24:22:09:32
     
146. piece handle=4su7g4o3_1_1 tag=3T-WHOLE-INCR1 comment=API Version 2.0,MMS Version 10.4.0.4
     
147. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
     
148. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:22:09:42
     
149. piece handle=4ru7g4o3_1_1 tag=3T-WHOLE-INCR1 comment=API Version 2.0,MMS Version 10.4.0.4
     
150. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
     
151. Finished backup at 2019-07-24:22:09:42
     
152. 
     
153. Starting Control File and SPFILE Autobackup at 2019-07-24:22:09:42
     
154. 
     

复制代码

图形界面的ADR：

	Recovery Results
	Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jul 24 22:42:31 2019 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. RMAN> connected to target database: ORCL (DBID=1541741703, not open) using target database control file instead of recovery catalog RMAN> echo set on RMAN> REPAIR FAILURE USING REPAIRID 3347 NO OPEN DATABASE NOPROMPT; Strategy: The repair includes complete media recovery with no data loss Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_1718221962.hm contents of repair script: # restore and recover datafile restore datafile 1; recover datafile 1; sql 'alter database datafile 1 online'; executing repair script Starting restore at 2019-07-24:22:42:35 allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: SID=43 device type=SBT_TAPE channel ORA_SBT_TAPE_1: Oracle Secure Backup allocated channel: ORA_SBT_TAPE_2 channel ORA_SBT_TAPE_2: SID=52 device type=SBT_TAPE channel ORA_SBT_TAPE_2: Oracle Secure Backup allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=50 device type=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: SID=49 device type=DISK allocated channel: ORA_DISK_3 channel ORA_DISK_3: SID=48 device type=DISK allocated channel: ORA_DISK_4 channel ORA_DISK_4: SID=47 device type=DISK allocated channel: ORA_DISK_5 channel ORA_DISK_5: SID=46 device type=DISK allocated channel: ORA_DISK_6 channel ORA_DISK_6: SID=45 device type=DISK allocated channel: ORA_DISK_7 channel ORA_DISK_7: SID=38 device type=DISK allocated channel: ORA_DISK_8 channel ORA_DISK_8: SID=40 device type=DISK channel ORA_SBT_TAPE_1: starting datafile backup set restore channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set channel ORA_SBT_TAPE_1: restoring datafile 00001 to +DATA/orcl/datafile/system.256.1013960881 channel ORA_SBT_TAPE_1: reading from backup piece 4ku7g4dj_1_1 channel ORA_SBT_TAPE_1: piece handle=4ku7g4dj_1_1 tag=1T-WHOLE-INCR0 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:55 Finished restore at 2019-07-24:22:44:06 Starting recover at 2019-07-24:22:44:06 using channel ORA_SBT_TAPE_1 using channel ORA_SBT_TAPE_2 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 using channel ORA_DISK_4 using channel ORA_DISK_5 using channel ORA_DISK_6 using channel ORA_DISK_7 using channel ORA_DISK_8 channel ORA_SBT_TAPE_1: starting incremental datafile backup set restore channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set destination for restore of datafile 00001: +DATA/orcl/datafile/system.256.1014504215 channel ORA_SBT_TAPE_1: reading from backup piece 4ou7g4j4_1_1 channel ORA_SBT_TAPE_1: piece handle=4ou7g4j4_1_1 tag=2T-WHOLE-INCR1 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35 channel ORA_SBT_TAPE_1: starting incremental datafile backup set restore channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set destination for restore of datafile 00001: +DATA/orcl/datafile/system.256.1014504215 channel ORA_SBT_TAPE_1: reading from backup piece 4ru7g4o3_1_1 channel ORA_SBT_TAPE_1: piece handle=4ru7g4o3_1_1 tag=3T-WHOLE-INCR1 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35 starting media recovery archived log for thread 1 with sequence 99 is already on disk as file +FRA/orcl/archivelog/2019_07_24/thread_1_seq_99.303.1014503299 archived log for thread 1 with sequence 100 is already on disk as file +FRA/orcl/archivelog/2019_07_24/thread_1_seq_100.301.1014503301 archived log for thread 1 with sequence 101 is already on disk as file +FRA/orcl/archivelog/2019_07_24/thread_1_seq_101.293.1014503301 archived log for thread 1 with sequence 102 is already on disk as file +FRA/orcl/archivelog/2019_07_24/thread_1_seq_102.298.1014508989 archived log for thread 1 with sequence 103 is already on disk as file +FRA/orcl/archivelog/2019_07_24/thread_1_seq_103.295.1014503303 archived log for thread 1 with sequence 104 is already on disk as file +FRA/orcl/archivelog/2019_07_24/thread_1_seq_104.300.1014503303 archived log file name=+FRA/orcl/archivelog/2019_07_24/thread_1_seq_99.303.1014503299 thread=1 sequence=99 archived log file name=+FRA/orcl/archivelog/2019_07_24/thread_1_seq_100.301.1014503301 thread=1 sequence=100 archived log file name=+FRA/orcl/archivelog/2019_07_24/thread_1_seq_101.293.1014503301 thread=1 sequence=101 archived log file name=+FRA/orcl/archivelog/2019_07_24/thread_1_seq_102.298.1014508989 thread=1 sequence=102 media recovery complete, elapsed time: 00:00:00 Finished recover at 2019-07-24:22:45:19 sql statement: alter database datafile 1 online repair failure complete RMAN> exit; Recovery Manager complete.