第10/11次活动：2017-08-21（星期一晚上7:00-10:00）和2017-08-23（星期三晚上7:00-10:00）

botang

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

复制代码

1. RMAN> validate check logical    tablespace system  ;
   
2. 
   
3. Starting validate at 2017-08-21:20:21:49
   
4. using channel ORA_DISK_1
   
5. using channel ORA_DISK_2
   
6. using channel ORA_DISK_3
   
7. using channel ORA_DISK_4
   
8. using channel ORA_DISK_5
   
9. using channel ORA_DISK_6
   
10. using channel ORA_DISK_7
    
11. using channel ORA_DISK_8
    
12. channel ORA_DISK_1: starting validation of datafile
    
13. channel ORA_DISK_1: specifying datafile(s) for validation
    
14. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
    
15. channel ORA_DISK_2: starting validation of datafile
    
16. channel ORA_DISK_2: specifying datafile(s) for validation
    
17. including current SPFILE in backup set
    
18. channel ORA_DISK_3: starting validation of datafile
    
19. channel ORA_DISK_3: specifying datafile(s) for validation
    
20. including current control file for validation
    
21. channel ORA_DISK_2: validation complete, elapsed time: 00:00:00
    
22. List of Control File and SPFILE
    
23. ===============================
    
24. File Type    Status Blocks Failing Blocks Examined
    
25. ------------ ------ -------------- ---------------
    
26. SPFILE       OK     0              2               
    
27. channel ORA_DISK_3: validation complete, elapsed time: 00:00:01
    
28. List of Control File and SPFILE
    
29. ===============================
    
30. File Type    Status Blocks Failing Blocks Examined
    
31. ------------ ------ -------------- ---------------
    
32. Control File OK     0              594            
    
33. channel ORA_DISK_1: validation 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              12836        87050           1076920   
    
39.   File Name: +DATA/orcl/datafile/system.256.816169553
    
40.   Block Type Blocks Failing Blocks Processed
    
41.   ---------- -------------- ----------------
    
42.   Data       0              58512           
    
43.   Index      0              12172           
    
44.   Other      0              3520            
    
45. 
    
46. Finished validate at 2017-08-21:20:21:53
    
47. 
    
48. RMAN>
    

复制代码

1. RMAN> backup tag 'NEWPIECE3' tablespace system  section size 50M   keep  until time 'sysdate+60'  restore point rsp1;

复制代码

1. RMAN> report obsolete redundancy 1 ;
   
2. 
   
3. Report of obsolete backups and copies
   
4. Type                 Key    Completion Time    Filename/Handle
   
5. -------------------- ------ ------------------ --------------------
   
6. Backup Set           33     2017-05-18:16:42:49
   
7.   Backup Piece       33     2017-05-18:16:42:49 11s4ih3q_1_1
   
8. Backup Set           37     2017-05-18:16:44:16
   
9.   Backup Piece       37     2017-05-18:16:44:16 c-1343950367-20170518-00
   
10. Backup Set           39     2017-08-21:19:29:51
    
11.   Backup Piece       39     2017-08-21:19:29:51 c-1343950367-20170821-00
    
12. Backup Set           42     2017-08-21:19:34:33
    
13.   Backup Piece       42     2017-08-21:19:34:33 c-1343950367-20170821-01
    
14. Backup Set           45     2017-08-21:19:37:49
    
15.   Backup Piece       45     2017-08-21:19:37:49 c-1343950367-20170821-02
    
16. Backup Set           48     2017-08-21:19:44:02
    
17.   Backup Piece       48     2017-08-21:19:44:02 c-1343950367-20170821-03
    
18. Backup Set           51     2017-08-21:19:46:57
    
19.   Backup Piece       51     2017-08-21:19:46:57 c-1343950367-20170821-04
    
20. Backup Set           53     2017-08-21:20:15:01
    
21.   Backup Piece       66     2017-08-21:20:15:01 c-1343950367-20170821-05
    
22. 
    
23. RMAN> change backupset 52 nokeep ;
    
24. 
    
25. allocated channel: ORA_DISK_1
    
26. channel ORA_DISK_1: SID=14 device type=DISK
    
27. allocated channel: ORA_DISK_2
    
28. channel ORA_DISK_2: SID=142 device type=DISK
    
29. allocated channel: ORA_DISK_3
    
30. channel ORA_DISK_3: SID=17 device type=DISK
    
31. allocated channel: ORA_DISK_4
    
32. channel ORA_DISK_4: SID=78 device type=DISK
    
33. allocated channel: ORA_DISK_5
    
34. channel ORA_DISK_5: SID=146 device type=DISK
    
35. allocated channel: ORA_DISK_6
    
36. channel ORA_DISK_6: SID=200 device type=DISK
    
37. allocated channel: ORA_DISK_7
    
38. channel ORA_DISK_7: SID=16 device type=DISK
    
39. allocated channel: ORA_DISK_8
    
40. channel ORA_DISK_8: SID=71 device type=DISK
    
41. allocated channel: ORA_SBT_TAPE_1
    
42. channel ORA_SBT_TAPE_1: SID=201 device type=SBT_TAPE
    
43. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
44. allocated channel: ORA_SBT_TAPE_2
    
45. channel ORA_SBT_TAPE_2: SID=74 device type=SBT_TAPE
    
46. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
47. keep attributes for the backup are deleted
    
48. backup set key=52 RECID=52 STAMP=952632876
    
49. 
    
50. RMAN> report obsolete redundancy 1 ;
    
51. 
    
52. Report of obsolete backups and copies
    
53. Type                 Key    Completion Time    Filename/Handle
    
54. -------------------- ------ ------------------ --------------------
    
55. Backup Set           33     2017-05-18:16:42:49
    
56.   Backup Piece       33     2017-05-18:16:42:49 11s4ih3q_1_1
    
57. Backup Set           37     2017-05-18:16:44:16
    
58.   Backup Piece       37     2017-05-18:16:44:16 c-1343950367-20170518-00
    
59. Backup Set           39     2017-08-21:19:29:51
    
60.   Backup Piece       39     2017-08-21:19:29:51 c-1343950367-20170821-00
    
61. Backup Set           42     2017-08-21:19:34:33
    
62.   Backup Piece       42     2017-08-21:19:34:33 c-1343950367-20170821-01
    
63. Backup Set           45     2017-08-21:19:37:49
    
64.   Backup Piece       45     2017-08-21:19:37:49 c-1343950367-20170821-02
    
65. Backup Set           48     2017-08-21:19:44:02
    
66.   Backup Piece       48     2017-08-21:19:44:02 c-1343950367-20170821-03
    
67. Backup Set           51     2017-08-21:19:46:57
    
68.   Backup Piece       51     2017-08-21:19:46:57 c-1343950367-20170821-04
    
69. Backup Set           53     2017-08-21:20:15:01
    
70.   Backup Piece       66     2017-08-21:20:15:01 c-1343950367-20170821-05
    
71. 
    
72. RMAN> exit
    
73. 
    
74. 
    
75. Recovery Manager complete.
    
76. [oracle@station90 ~]$ rman target  /  catalog u90/oracle_4U@rcat
    
77. 
    
78. Recovery Manager: Release 11.2.0.1.0 - Production on Mon Aug 21 21:30:22 2017
    
79. 
    
80. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
81. 
    
82. connected to target database: ORCL (DBID=1343950367)
    
83. connected to recovery catalog database
    
84. 
    
85. RMAN> change backupset 52 nokeep ;
    
86. 
    
87. allocated channel: ORA_DISK_1
    
88. channel ORA_DISK_1: SID=15 device type=DISK
    
89. allocated channel: ORA_DISK_2
    
90. channel ORA_DISK_2: SID=142 device type=DISK
    
91. allocated channel: ORA_DISK_3
    
92. channel ORA_DISK_3: SID=14 device type=DISK
    
93. allocated channel: ORA_DISK_4
    
94. channel ORA_DISK_4: SID=78 device type=DISK
    
95. allocated channel: ORA_DISK_5
    
96. channel ORA_DISK_5: SID=146 device type=DISK
    
97. allocated channel: ORA_DISK_6
    
98. channel ORA_DISK_6: SID=201 device type=DISK
    
99. allocated channel: ORA_DISK_7
    
100. channel ORA_DISK_7: SID=17 device type=DISK
     
101. allocated channel: ORA_DISK_8
     
102. channel ORA_DISK_8: SID=71 device type=DISK
     
103. allocated channel: ORA_SBT_TAPE_1
     
104. channel ORA_SBT_TAPE_1: SID=200 device type=SBT_TAPE
     
105. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
106. allocated channel: ORA_SBT_TAPE_2
     
107. channel ORA_SBT_TAPE_2: SID=202 device type=SBT_TAPE
     
108. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
109. RMAN-00571: ===========================================================
     
110. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
111. RMAN-00571: ===========================================================
     
112. RMAN-03002: failure of KEEP command at 08/21/2017 21:30:38
     
113. RMAN-06004: ORACLE error from recovery catalog database: RMAN-20215: backup set not found
     
114. RMAN-06159: error while looking up backup set
     
115. 
     
116. RMAN> change backupset 168 nokeep ;
     
117. 
     
118. using channel ORA_DISK_1
     
119. using channel ORA_DISK_2
     
120. using channel ORA_DISK_3
     
121. using channel ORA_DISK_4
     
122. using channel ORA_DISK_5
     
123. using channel ORA_DISK_6
     
124. using channel ORA_DISK_7
     
125. using channel ORA_DISK_8
     
126. using channel ORA_SBT_TAPE_1
     
127. using channel ORA_SBT_TAPE_2
     
128. keep attributes for the backup are deleted
     
129. backup set key=168 RECID=54 STAMP=952635681
     
130. 
     
131. RMAN> exit
     
132. 
     
133. 
     
134. Recovery Manager complete.
     
135. [oracle@station90 ~]$ rman target  /  
     
136. 
     
137. Recovery Manager: Release 11.2.0.1.0 - Production on Mon Aug 21 21:31:00 2017
     
138. 
     
139. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
140. 
     
141. connected to target database: ORCL (DBID=1343950367)
     
142. 
     
143. RMAN> report obsolete redundancy 1 ;
     
144. 
     
145. using target database control file instead of recovery catalog
     
146. Report of obsolete backups and copies
     
147. Type                 Key    Completion Time    Filename/Handle
     
148. -------------------- ------ ------------------ --------------------
     
149. Backup Set           33     2017-05-18:16:42:49
     
150.   Backup Piece       33     2017-05-18:16:42:49 11s4ih3q_1_1
     
151. Backup Set           37     2017-05-18:16:44:16
     
152.   Backup Piece       37     2017-05-18:16:44:16 c-1343950367-20170518-00
     
153. Backup Set           39     2017-08-21:19:29:51
     
154.   Backup Piece       39     2017-08-21:19:29:51 c-1343950367-20170821-00
     
155. Backup Set           42     2017-08-21:19:34:33
     
156.   Backup Piece       42     2017-08-21:19:34:33 c-1343950367-20170821-01
     
157. Backup Set           45     2017-08-21:19:37:49
     
158.   Backup Piece       45     2017-08-21:19:37:49 c-1343950367-20170821-02
     
159. Backup Set           48     2017-08-21:19:44:02
     
160.   Backup Piece       48     2017-08-21:19:44:02 c-1343950367-20170821-03
     
161. Backup Set           51     2017-08-21:19:46:57
     
162.   Backup Piece       51     2017-08-21:19:46:57 c-1343950367-20170821-04
     
163. Backup Set           52     2017-08-21:20:14:36
     
164.   Backup Piece       65     2017-08-21:20:14:36 1kscg1c8_14_1
     
165. Backup Set           52     2017-08-21:20:14:36
     
166.   Backup Piece       64     2017-08-21:20:14:36 1kscg1c8_13_1
     
167. Backup Set           52     2017-08-21:20:14:11
     
168.   Backup Piece       63     2017-08-21:20:14:11 1kscg1c8_12_1
     
169. Backup Set           52     2017-08-21:20:14:11
     
170.   Backup Piece       62     2017-08-21:20:14:11 1kscg1c8_11_1
     
171. Backup Set           52     2017-08-21:20:13:47
     
172.   Backup Piece       60     2017-08-21:20:13:47 1kscg1c8_10_1
     
173. Backup Set           52     2017-08-21:20:13:47
     
174.   Backup Piece       61     2017-08-21:20:13:47 1kscg1c8_9_1
     
175. Backup Set           52     2017-08-21:20:13:21
     
176.   Backup Piece       58     2017-08-21:20:13:21 1kscg1c8_8_1
     
177. Backup Set           52     2017-08-21:20:13:22
     
178.   Backup Piece       59     2017-08-21:20:13:22 1kscg1c8_7_1
     
179. Backup Set           52     2017-08-21:20:12:56
     
180.   Backup Piece       56     2017-08-21:20:12:56 1kscg1c8_6_1
     
181. Backup Set           52     2017-08-21:20:12:57
     
182.   Backup Piece       57     2017-08-21:20:12:57 1kscg1c8_5_1
     
183. Backup Set           52     2017-08-21:20:12:32
     
184.   Backup Piece       55     2017-08-21:20:12:32 1kscg1c8_4_1
     
185. Backup Set           52     2017-08-21:20:12:31
     
186.   Backup Piece       54     2017-08-21:20:12:31 1kscg1c8_3_1
     
187. Backup Set           52     2017-08-21:20:12:09
     
188.   Backup Piece       52     2017-08-21:20:12:09 1kscg1c8_2_1
     
189. Backup Set           52     2017-08-21:20:12:18
     
190.   Backup Piece       53     2017-08-21:20:12:18 1kscg1c8_1_1
     
191. Backup Set           53     2017-08-21:20:15:01
     
192.   Backup Piece       66     2017-08-21:20:15:01 c-1343950367-20170821-05
     
193. 
     
194. RMAN>
     

复制代码