课程第32次（2016-06-07星期二）：【上完1Z0-052的第16章】：恢复，并做完实验1a和实验3

botang

【上完1Z0-052的第16章】：恢复，并做完实验1a和实验3
【1Z0-051】：共10章（0 1 2 3 4 5 6 7 8 9）
【1Z0-052】：共12章（0 1 2 3 4 5 6 9 10 14 15 16）
【1Z0-053】：共5章（0 1 10 11 12）

1. [root@station90 桌面]# su - oracle
   
2. [oracle@station90 ~]$ sqlplus /nolog
   
3. 
   
4. SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 9 20:58:03 2016
   
5. 
   
6. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
7. 
   
8. SQL> conn / as sysdba
   
9. Connected.
   
10. SQL> alter database datafile 4 offline ;
    
11. 
    
12. Database altered.
    
13. 
    
14. SQL> exit
    
15. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
16. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    
17. and Real Application Testing options
    
18. [oracle@station90 ~]$ rman target /
    
19. 
    
20. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 9 20:58:51 2016
    
21. 
    
22. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
23. 
    
24. connected to target database: ORCL (DBID=1343950367)
    
25. 
    
26. RMAN> list backup of datafile 4 ;
    
27. 
    
28. using target database control file instead of recovery catalog
    
29. 
    
30. List of Backup Sets
    
31. ===================
    
32. 
    
33. 
    
34. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
35. ------- ---- -- ---------- ----------- ------------ ---------------
    
36. 88      Full    1.06M      SBT_TAPE    00:00:15     09-JUN-16      
    
37.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202130
    
38.         Handle: 33r7o2ma_1_1   Media: station90-000013
    
39.   List of Datafiles in backup set 88
    
40.   File LV Type Ckp SCN    Ckp Time  Name
    
41.   ---- -- ---- ---------- --------- ----
    
42.   4       Full 1577931    09-JUN-16 +DATA/orcl/datafile/users.259.914098875
    
43. 
    
44. RMAN> crosscheck backupset 88;
    
45. 
    
46. allocated channel: ORA_DISK_1
    
47. channel ORA_DISK_1: SID=143 device type=DISK
    
48. allocated channel: ORA_DISK_2
    
49. channel ORA_DISK_2: SID=199 device type=DISK
    
50. allocated channel: ORA_DISK_3
    
51. channel ORA_DISK_3: SID=76 device type=DISK
    
52. allocated channel: ORA_DISK_4
    
53. channel ORA_DISK_4: SID=142 device type=DISK
    
54. allocated channel: ORA_DISK_5
    
55. channel ORA_DISK_5: SID=195 device type=DISK
    
56. allocated channel: ORA_DISK_6
    
57. channel ORA_DISK_6: SID=14 device type=DISK
    
58. allocated channel: ORA_DISK_7
    
59. channel ORA_DISK_7: SID=81 device type=DISK
    
60. allocated channel: ORA_DISK_8
    
61. channel ORA_DISK_8: SID=130 device type=DISK
    
62. allocated channel: ORA_SBT_TAPE_1
    
63. channel ORA_SBT_TAPE_1: SID=194 device type=SBT_TAPE
    
64. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
65. allocated channel: ORA_SBT_TAPE_2
    
66. channel ORA_SBT_TAPE_2: SID=13 device type=SBT_TAPE
    
67. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
68. allocated channel: ORA_SBT_TAPE_3
    
69. channel ORA_SBT_TAPE_3: SID=75 device type=SBT_TAPE
    
70. channel ORA_SBT_TAPE_3: Oracle Secure Backup
    
71. allocated channel: ORA_SBT_TAPE_4
    
72. channel ORA_SBT_TAPE_4: SID=139 device type=SBT_TAPE
    
73. channel ORA_SBT_TAPE_4: Oracle Secure Backup
    
74. allocated channel: ORA_SBT_TAPE_5
    
75. channel ORA_SBT_TAPE_5: SID=198 device type=SBT_TAPE
    
76. channel ORA_SBT_TAPE_5: Oracle Secure Backup
    
77. allocated channel: ORA_SBT_TAPE_6
    
78. channel ORA_SBT_TAPE_6: SID=137 device type=SBT_TAPE
    
79. channel ORA_SBT_TAPE_6: Oracle Secure Backup
    
80. allocated channel: ORA_SBT_TAPE_7
    
81. channel ORA_SBT_TAPE_7: SID=191 device type=SBT_TAPE
    
82. channel ORA_SBT_TAPE_7: Oracle Secure Backup
    
83. allocated channel: ORA_SBT_TAPE_8
    
84. channel ORA_SBT_TAPE_8: SID=12 device type=SBT_TAPE
    
85. channel ORA_SBT_TAPE_8: Oracle Secure Backup
    
86. crosschecked backup piece: found to be 'AVAILABLE'
    
87. backup piece handle=33r7o2ma_1_1 RECID=88 STAMP=914098890
    
88. Crosschecked 1 objects
    
89. 
    
90. 
    
91. RMAN> list backup of datafile 4;
    
92. 
    
93. 
    
94. List of Backup Sets
    
95. ===================
    
96. 
    
97. 
    
98. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
99. ------- ---- -- ---------- ----------- ------------ ---------------
    
100. 88      Full    1.06M      SBT_TAPE    00:00:15     09-JUN-16      
     
101.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202130
     
102.         Handle: 33r7o2ma_1_1   Media: station90-000013
     
103.   List of Datafiles in backup set 88
     
104.   File LV Type Ckp SCN    Ckp Time  Name
     
105.   ---- -- ---- ---------- --------- ----
     
106.   4       Full 1577931    09-JUN-16 +DATA/orcl/datafile/users.259.914098875
     
107. 
     
108. RMAN> restore datafile 4;
     
109. 
     
110. Starting restore at 09-JUN-16
     
111. using channel ORA_DISK_1
     
112. using channel ORA_DISK_2
     
113. using channel ORA_DISK_3
     
114. using channel ORA_DISK_4
     
115. using channel ORA_DISK_5
     
116. using channel ORA_DISK_6
     
117. using channel ORA_DISK_7
     
118. using channel ORA_DISK_8
     
119. using channel ORA_SBT_TAPE_1
     
120. using channel ORA_SBT_TAPE_2
     
121. using channel ORA_SBT_TAPE_3
     
122. using channel ORA_SBT_TAPE_4
     
123. using channel ORA_SBT_TAPE_5
     
124. using channel ORA_SBT_TAPE_6
     
125. using channel ORA_SBT_TAPE_7
     
126. using channel ORA_SBT_TAPE_8
     
127. 
     
128. channel ORA_SBT_TAPE_1: starting datafile backup set restore
     
129. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
     
130. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.259.914098875
     
131. channel ORA_SBT_TAPE_1: reading from backup piece 33r7o2ma_1_1
     
132. channel ORA_SBT_TAPE_1: piece handle=33r7o2ma_1_1 tag=TAG20160609T202130
     
133. channel ORA_SBT_TAPE_1: restored backup piece 1
     
134. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
     
135. Finished restore at 09-JUN-16
     
136. 
     
137. RMAN> recover datafile 4 ;
     
138. 
     
139. Starting recover at 09-JUN-16
     
140. using channel ORA_DISK_1
     
141. using channel ORA_DISK_2
     
142. using channel ORA_DISK_3
     
143. using channel ORA_DISK_4
     
144. using channel ORA_DISK_5
     
145. using channel ORA_DISK_6
     
146. using channel ORA_DISK_7
     
147. using channel ORA_DISK_8
     
148. using channel ORA_SBT_TAPE_1
     
149. using channel ORA_SBT_TAPE_2
     
150. using channel ORA_SBT_TAPE_3
     
151. using channel ORA_SBT_TAPE_4
     
152. using channel ORA_SBT_TAPE_5
     
153. using channel ORA_SBT_TAPE_6
     
154. using channel ORA_SBT_TAPE_7
     
155. using channel ORA_SBT_TAPE_8
     
156. 
     
157. starting media recovery
     
158. 
     
159. archived log for thread 1 with sequence 36 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_36.292.914100303
     
160. archived log for thread 1 with sequence 37 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_37.289.914100303
     
161. archived log for thread 1 with sequence 38 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_38.293.914100305
     
162. archived log for thread 1 with sequence 39 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_39.290.914100305
     
163. archived log for thread 1 with sequence 40 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_40.291.914100309
     
164. archived log for thread 1 with sequence 41 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_41.295.914100311
     
165. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_36.292.914100303 thread=1 sequence=36
     
166. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_37.289.914100303 thread=1 sequence=37
     
167. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_38.293.914100305 thread=1 sequence=38
     
168. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_39.290.914100305 thread=1 sequence=39
     
169. media recovery complete, elapsed time: 00:00:00
     
170. Finished recover at 09-JUN-16
     
171. 
     
172. RMAN> list failure ;
     
173. 
     
174. RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
     
175. RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
     
176. ORACLE error from target database:
     
177. ORA-03135: connection lost contact
     
178. Process ID: 17539
     
179. Session ID: 196 Serial number: 825
     
180. 
     
181. RMAN-00571: ===========================================================
     
182. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
183. RMAN-00571: ===========================================================
     
184. 
     
185. RMAN> exit
     
186. 
     
187. 
     
188. Recovery Manager complete.
     
189. [oracle@station90 ~]$ rman target /
     
190. 
     
191. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 9 21:25:02 2016
     
192. 
     
193. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
194. 
     
195. connected to target database: ORCL (DBID=1343950367, not open)
     
196. 
     
197. RMAN> list failure ;
     
198. 
     
199. using target database control file instead of recovery catalog
     
200. List of Database Failures
     
201. =========================
     
202. 
     
203. Failure ID Priority Status    Time Detected Summary
     
204. ---------- -------- --------- ------------- -------
     
205. 2122       CRITICAL OPEN      09-JUN-16     System datafile 1: '+DATA/orcl/datafile/system.256.816169553' is missing
     
206. 2008       HIGH     OPEN      09-JUN-16     Tablespace 4: 'USERS' is offline
     
207. 
     
208. RMAN> advise failure 2122;
     
209. 
     
210. List of Database Failures
     
211. =========================
     
212. 
     
213. Failure ID Priority Status    Time Detected Summary
     
214. ---------- -------- --------- ------------- -------
     
215. 2122       CRITICAL OPEN      09-JUN-16     System datafile 1: '+DATA/orcl/datafile/system.256.816169553' is missing
     
216. 
     
217. analyzing automatic repair options; this may take some time
     
218. allocated channel: ORA_DISK_1
     
219. channel ORA_DISK_1: SID=135 device type=DISK
     
220. allocated channel: ORA_DISK_2
     
221. channel ORA_DISK_2: SID=195 device type=DISK
     
222. allocated channel: ORA_DISK_3
     
223. channel ORA_DISK_3: SID=11 device type=DISK
     
224. allocated channel: ORA_DISK_4
     
225. channel ORA_DISK_4: SID=71 device type=DISK
     
226. allocated channel: ORA_DISK_5
     
227. channel ORA_DISK_5: SID=134 device type=DISK
     
228. allocated channel: ORA_DISK_6
     
229. channel ORA_DISK_6: SID=194 device type=DISK
     
230. allocated channel: ORA_DISK_7
     
231. channel ORA_DISK_7: SID=10 device type=DISK
     
232. allocated channel: ORA_DISK_8
     
233. channel ORA_DISK_8: SID=69 device type=DISK
     
234. allocated channel: ORA_SBT_TAPE_1
     
235. channel ORA_SBT_TAPE_1: SID=133 device type=SBT_TAPE
     
236. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
237. allocated channel: ORA_SBT_TAPE_2
     
238. channel ORA_SBT_TAPE_2: SID=8 device type=SBT_TAPE
     
239. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
240. allocated channel: ORA_SBT_TAPE_3
     
241. channel ORA_SBT_TAPE_3: SID=193 device type=SBT_TAPE
     
242. channel ORA_SBT_TAPE_3: Oracle Secure Backup
     
243. allocated channel: ORA_SBT_TAPE_4
     
244. channel ORA_SBT_TAPE_4: SID=68 device type=SBT_TAPE
     
245. channel ORA_SBT_TAPE_4: Oracle Secure Backup
     
246. allocated channel: ORA_SBT_TAPE_5
     
247. channel ORA_SBT_TAPE_5: SID=132 device type=SBT_TAPE
     
248. channel ORA_SBT_TAPE_5: Oracle Secure Backup
     
249. allocated channel: ORA_SBT_TAPE_6
     
250. channel ORA_SBT_TAPE_6: SID=192 device type=SBT_TAPE
     
251. channel ORA_SBT_TAPE_6: Oracle Secure Backup
     
252. allocated channel: ORA_SBT_TAPE_7
     
253. channel ORA_SBT_TAPE_7: SID=7 device type=SBT_TAPE
     
254. channel ORA_SBT_TAPE_7: Oracle Secure Backup
     
255. allocated channel: ORA_SBT_TAPE_8
     
256. channel ORA_SBT_TAPE_8: SID=72 device type=SBT_TAPE
     
257. channel ORA_SBT_TAPE_8: Oracle Secure Backup
     
258. analyzing automatic repair options complete
     
259. 
     
260. Mandatory Manual Actions
     
261. ========================
     
262. no manual actions available
     
263. 
     
264. Optional Manual Actions
     
265. =======================
     
266. 1. If file +DATA/orcl/datafile/system.256.816169553 was unintentionally renamed or moved, restore it
     
267. 
     
268. Automated Repair Options
     
269. ========================
     
270. Option Repair Description
     
271. ------ ------------------
     
272. 1      Restore and recover datafile 1  
     
273.   Strategy: The repair includes complete media recovery with no data loss
     
274.   Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_1742424864.hm
     
275. 
     
276. RMAN> repair failure preview;
     
277. 
     
278. Strategy: The repair includes complete media recovery with no data loss
     
279. Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_1742424864.hm
     
280. 
     
281. contents of repair script:
     
282.    # restore and recover datafile
     
283.    restore datafile 1;
     
284.    recover datafile 1;
     
285. 
     
286. RMAN> repair failure ;
     
287. 
     
288. Strategy: The repair includes complete media recovery with no data loss
     
289. Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_1742424864.hm
     
290. 
     
291. contents of repair script:
     
292.    # restore and recover datafile
     
293.    restore datafile 1;
     
294.    recover datafile 1;
     
295. 
     
296. Do you really want to execute the above repair (enter YES or NO)? YES
     
297. executing repair script
     
298. 
     
299. Starting restore at 09-JUN-16
     
300. using channel ORA_DISK_1
     
301. using channel ORA_DISK_2
     
302. using channel ORA_DISK_3
     
303. using channel ORA_DISK_4
     
304. using channel ORA_DISK_5
     
305. using channel ORA_DISK_6
     
306. using channel ORA_DISK_7
     
307. using channel ORA_DISK_8
     
308. using channel ORA_SBT_TAPE_1
     
309. using channel ORA_SBT_TAPE_2
     
310. using channel ORA_SBT_TAPE_3
     
311. using channel ORA_SBT_TAPE_4
     
312. using channel ORA_SBT_TAPE_5
     
313. using channel ORA_SBT_TAPE_6
     
314. using channel ORA_SBT_TAPE_7
     
315. using channel ORA_SBT_TAPE_8
     
316. 
     
317. channel ORA_SBT_TAPE_1: starting datafile backup set restore
     
318. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
     
319. channel ORA_SBT_TAPE_1: restoring datafile 00001 to +DATA/orcl/datafile/system.256.816169553
     
320. channel ORA_SBT_TAPE_1: reading from backup piece 31r7o2en_1_1
     
321. channel ORA_SBT_TAPE_1: piece handle=31r7o2en_1_1 tag=TAG20160609T201727
     
322. channel ORA_SBT_TAPE_1: restored backup piece 1
     
323. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
     
324. Finished restore at 09-JUN-16
     
325. 
     
326. Starting recover at 09-JUN-16
     
327. using channel ORA_DISK_1
     
328. using channel ORA_DISK_2
     
329. using channel ORA_DISK_3
     
330. using channel ORA_DISK_4
     
331. using channel ORA_DISK_5
     
332. using channel ORA_DISK_6
     
333. using channel ORA_DISK_7
     
334. using channel ORA_DISK_8
     
335. using channel ORA_SBT_TAPE_1
     
336. using channel ORA_SBT_TAPE_2
     
337. using channel ORA_SBT_TAPE_3
     
338. using channel ORA_SBT_TAPE_4
     
339. using channel ORA_SBT_TAPE_5
     
340. using channel ORA_SBT_TAPE_6
     
341. using channel ORA_SBT_TAPE_7
     
342. using channel ORA_SBT_TAPE_8
     
343. 
     
344. starting media recovery
     
345. 
     
346. archived log for thread 1 with sequence 36 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_36.292.914100303
     
347. archived log for thread 1 with sequence 37 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_37.289.914100303
     
348. archived log for thread 1 with sequence 38 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_38.293.914100305
     
349. archived log for thread 1 with sequence 39 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_39.290.914100305
     
350. archived log for thread 1 with sequence 40 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_40.291.914100309
     
351. archived log for thread 1 with sequence 41 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_41.295.914100311
     
352. archived log for thread 1 with sequence 42 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_42.301.914102245
     
353. archived log for thread 1 with sequence 43 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_43.300.914102245
     
354. archived log for thread 1 with sequence 44 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_44.303.914102245
     
355. archived log for thread 1 with sequence 45 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_45.305.914102249
     
356. archived log for thread 1 with sequence 46 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_46.306.914102249
     
357. archived log for thread 1 with sequence 47 is already on disk as file +FRA/orcl/archivelog/2016_06_09/thread_1_seq_47.316.914102253
     
358. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_36.292.914100303 thread=1 sequence=36
     
359. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_37.289.914100303 thread=1 sequence=37
     
360. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_38.293.914100305 thread=1 sequence=38
     
361. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_39.290.914100305 thread=1 sequence=39
     
362. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_40.291.914100309 thread=1 sequence=40
     
363. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_41.295.914100311 thread=1 sequence=41
     
364. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_42.301.914102245 thread=1 sequence=42
     
365. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_43.300.914102245 thread=1 sequence=43
     
366. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_44.303.914102245 thread=1 sequence=44
     
367. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_45.305.914102249 thread=1 sequence=45
     
368. media recovery complete, elapsed time: 00:00:01
     
369. Finished recover at 09-JUN-16
     
370. repair failure complete
     
371. 
     
372. RMAN> exit
     
373. 
     
374. 
     
375. Recovery Manager complete.
     
376. [oracle@station90 ~]$ sqlplus /nolog
     
377. 
     
378. SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 9 21:29:11 2016
     
379. 
     
380. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
381. 
     
382. SQL> conn / as sysdba
     
383. Connected.
     
384. SQL> select  open_mode from v$database;
     
385. 
     
386. OPEN_MODE
     
387. --------------------
     
388. MOUNTED
     
389. 
     
390. SQL> alter database open ;
     
391. 
     
392. Database altered.
     
393. 
     
394. SQL>

复制代码