课程第29/30次（2016-12-25星期日上下午）

admin

12c CLOUDCONTROL和12c OCP的配置
(昨天课堂真实录屏，剪掉了几句无关紧要的话。上午教室隔壁公司装修，录屏中可以想像当时全班遭受了什么样的噪音折磨。幸好下午就不再装修了。)

上完1Z0-052第15章（图形界面配置备份）
上完1Z0-052第16章（简单恢复）
（052共19章，053共21章，063多租户共9章，49-17）

1. [root@station90 桌面]# su - oracle
   
2. [oracle@station90 ~]$ sqlplus /nolog
   
3. 
   
4. SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 27 16:12:25 2016
   
5. 
   
6. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
7. 
   
8. SQL> conn / as sysdba
   
9. Connected.
   
10. SQL> alter database backup controlfile to trace ;
    
11. 
    
12. Database altered.
    
13. 
    
14. SQL> !ps
    
15.   PID TTY          TIME CMD
    
16. 15878 pts/28   00:00:00 sqlplus
    
17. 17469 pts/28   00:00:00 ps
    
18. 
    
19. SQL> select  spid  from v$session  s , v$process p
    
20.   2   where s.paddr=p.addr
    
21.   3   and s.terminal='pts/28';
    
22. 
    
23. SPID
    
24. ------------------------
    
25. 15917
    
26. 
    
27. SQL> exit
    
28. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
29. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    
30. and Real Application Testing options
    
31. [oracle@station90 ~]$ rman target /
    
32. 
    
33. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Dec 27 17:56:04 2016
    
34. 
    
35. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
36. 
    
37. connected to target database: ORCL (DBID=1343950367)
    
38. 
    
39. RMAN> list failure;
    
40. 
    
41. using target database control file instead of recovery catalog
    
42. List of Database Failures
    
43. =========================
    
44. 
    
45. Failure ID Priority Status    Time Detected Summary
    
46. ---------- -------- --------- ------------- -------
    
47. 2808       HIGH     OPEN      27-DEC-16     Tablespace 4: 'USERS' is offline
    
48. 788        HIGH     OPEN      27-DEC-16     One or more non-system datafiles are missing
    
49. 
    
50. RMAN> advise failure all;
    
51. 
    
52. List of Database Failures
    
53. =========================
    
54. 
    
55. Failure ID Priority Status    Time Detected Summary
    
56. ---------- -------- --------- ------------- -------
    
57. 2808       HIGH     OPEN      27-DEC-16     Tablespace 4: 'USERS' is offline
    
58. 788        HIGH     OPEN      27-DEC-16     One or more non-system datafiles are missing
    
59. 
    
60. analyzing automatic repair options; this may take some time
    
61. allocated channel: ORA_DISK_1
    
62. channel ORA_DISK_1: SID=145 device type=DISK
    
63. allocated channel: ORA_DISK_2
    
64. channel ORA_DISK_2: SID=81 device type=DISK
    
65. allocated channel: ORA_DISK_3
    
66. channel ORA_DISK_3: SID=79 device type=DISK
    
67. allocated channel: ORA_DISK_4
    
68. channel ORA_DISK_4: SID=138 device type=DISK
    
69. allocated channel: ORA_DISK_5
    
70. channel ORA_DISK_5: SID=206 device type=DISK
    
71. allocated channel: ORA_DISK_6
    
72. channel ORA_DISK_6: SID=21 device type=DISK
    
73. allocated channel: ORA_DISK_7
    
74. channel ORA_DISK_7: SID=82 device type=DISK
    
75. allocated channel: ORA_DISK_8
    
76. channel ORA_DISK_8: SID=143 device type=DISK
    
77. allocated channel: ORA_SBT_TAPE_1
    
78. channel ORA_SBT_TAPE_1: SID=205 device type=SBT_TAPE
    
79. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
80. allocated channel: ORA_SBT_TAPE_2
    
81. channel ORA_SBT_TAPE_2: SID=80 device type=SBT_TAPE
    
82. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
83. analyzing automatic repair options complete
    
84. 
    
85. Not all specified failures can currently be repaired.
    
86. The following failures must be repaired before advise for others can be given.
    
87. 
    
88. Failure ID Priority Status    Time Detected Summary
    
89. ---------- -------- --------- ------------- -------
    
90. 788        HIGH     OPEN      27-DEC-16     One or more non-system datafiles are missing
    
91. 
    
92. Mandatory Manual Actions
    
93. ========================
    
94. 1. If file +DATA/orcl/datafile/users.259.930909037 was unintentionally renamed or moved, restore it
    
95. 2. If you have an export of tablespace USERS, then drop and re-create the tablespace and import the data.
    
96. 3. Contact Oracle Support Services if the preceding recommendations cannot be used, or if they do not fix the failures selected for repair
    
97. 
    
98. Optional Manual Actions
    
99. =======================
    
100. no manual actions available
     
101. 
     
102. Automated Repair Options
     
103. ========================
     
104. no automatic repair options available
     
105. 
     
106. RMAN> repaire failure preview;
     
107. 
     
108. RMAN-00571: ===========================================================
     
109. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
110. RMAN-00571: ===========================================================
     
111. RMAN-00558: error encountered while parsing input commands
     
112. RMAN-01009: syntax error: found "identifier": expecting one of: "advise, allocate, alter, backup, @, catalog, change, configure, connect, convert, copy, create, crosscheck, delete, drop, duplicate, exit, flashback, grant, host, import, list, mount, open, print, quit, recover, register, release, repair, replace, report, reset, restore, resync, revoke, run, send, set, show, shutdown, spool, sql, startup, switch, transport, unregister, upgrade, validate, {, "
     
113. RMAN-01008: the bad identifier was: repaire
     
114. RMAN-01007: at line 1 column 1 file: standard input
     
115. 
     
116. RMAN> repair failure preview;
     
117. 
     
118. RMAN-00571: ===========================================================
     
119. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
120. RMAN-00571: ===========================================================
     
121. RMAN-03002: failure of repair command at 12/27/2016 17:58:32
     
122. RMAN-06953: no automatic repairs were listed by ADVISE FAILURE
     
123. 
     
124. RMAN> list backup of  datafile '+DATA/orcl/datafile/users.259.930909037';
     
125. 
     
126. 
     
127. List of Backup Sets
     
128. ===================
     
129. 
     
130. 
     
131. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
132. ------- ---- -- ---------- ----------- ------------ ---------------
     
133. 63      Full    675.75M    SBT_TAPE    00:00:46     25-DEC-16      
     
134.         BP Key: 69   Status: AVAILABLE  Compressed: NO  Tag: TAG20161225T152607
     
135.         Handle: 34roc54f_1_1   Media: station90-000011
     
136.   List of Datafiles in backup set 63
     
137.   File LV Type Ckp SCN    Ckp Time  Name
     
138.   ---- -- ---- ---------- --------- ----
     
139.   4       Full 1639605    25-DEC-16 +DATA/orcl/datafile/users.259.930909037
     
140. 
     
141. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
142. ------- ---- -- ---------- ----------- ------------ ---------------
     
143. 65      Incr 1  18.48M     DISK        00:00:02     26-DEC-16      
     
144.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
     
145.         Piece Name: +FRA/orcl/backupset/2016_12_26/nnndn1_ora_oem_level_0_0.392.931620325
     
146.   List of Datafiles in backup set 65
     
147.   File LV Type Ckp SCN    Ckp Time  Name
     
148.   ---- -- ---- ---------- --------- ----
     
149.   4    1  Incr 1643178    26-DEC-16 +DATA/orcl/datafile/users.259.930909037
     
150. 
     
151. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
152. ------- ---- -- ---------- ----------- ------------ ---------------
     
153. 70      Incr 1  20.14M     DISK        00:00:01     27-DEC-16      
     
154.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
     
155.         Piece Name: +FRA/orcl/backupset/2016_12_27/nnndn1_ora_oem_level_0_0.382.931706737
     
156.   List of Datafiles in backup set 70
     
157.   File LV Type Ckp SCN    Ckp Time  Name
     
158.   ---- -- ---- ---------- --------- ----
     
159.   4    1  Incr 1647548    27-DEC-16 +DATA/orcl/datafile/users.259.930909037
     
160. 
     
161. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
162. ------- ---- -- ---------- ----------- ------------ ---------------
     
163. 75      Incr 1  94.16M     DISK        00:00:02     27-DEC-16      
     
164.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
     
165.         Piece Name: +FRA/orcl/backupset/2016_12_27/nnndn1_ora_oem_level_0_0.376.931707425
     
166.   List of Datafiles in backup set 75
     
167.   File LV Type Ckp SCN    Ckp Time  Name
     
168.   ---- -- ---- ---------- --------- ----
     
169.   4    1  Incr 1649995    27-DEC-16 +DATA/orcl/datafile/users.259.930909037
     
170. 
     
171. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
172. ------- ---- -- ---------- ----------- ------------ ---------------
     
173. 80      Incr 1  6.10M      DISK        00:00:01     27-DEC-16      
     
174.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
     
175.         Piece Name: +FRA/orcl/backupset/2016_12_27/nnndn1_ora_oem_level_0_0.373.931708447
     
176.   List of Datafiles in backup set 80
     
177.   File LV Type Ckp SCN    Ckp Time  Name
     
178.   ---- -- ---- ---------- --------- ----
     
179.   4    1  Incr 1652048    27-DEC-16 +DATA/orcl/datafile/users.259.930909037
     
180. 
     
181. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
182. ------- ---- -- ---------- ----------- ------------ ---------------
     
183. 85      Incr 1  13.18M     DISK        00:00:01     27-DEC-16      
     
184.         BP Key: 92   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
     
185.         Piece Name: +FRA/orcl/backupset/2016_12_27/nnndn1_ora_oem_level_0_0.369.931708565
     
186.   List of Datafiles in backup set 85
     
187.   File LV Type Ckp SCN    Ckp Time  Name
     
188.   ---- -- ---- ---------- --------- ----
     
189.   4    1  Incr 1654105    27-DEC-16 +DATA/orcl/datafile/users.259.930909037
     
190. 
     
191. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
192. ------- ---- -- ---------- ----------- ------------ ---------------
     
193. 89      Incr 1  904.00K    DISK        00:00:00     27-DEC-16      
     
194.         BP Key: 96   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
     
195.         Piece Name: +FRA/orcl/backupset/2016_12_27/nnndn1_ora_oem_level_0_0.366.931708685
     
196.   List of Datafiles in backup set 89
     
197.   File LV Type Ckp SCN    Ckp Time  Name
     
198.   ---- -- ---- ---------- --------- ----
     
199.   4    1  Incr 1654400    27-DEC-16 +DATA/orcl/datafile/users.259.930909037
     
200. 
     
201. RMAN> list copy of  datafile '+DATA/orcl/datafile/users.259.930909037';
     
202. 
     
203. List of Datafile Copies
     
204. =======================
     
205. 
     
206. Key     File S Completion Time Ckp SCN    Ckp Time      
     
207. ------- ---- - --------------- ---------- ---------------
     
208. 32      4    A 27-DEC-16       1654105    27-DEC-16      
     
209.         Name: +FRA/orcl/datafile/users.390.931533947
     
210.         Tag: ORA_OEM_LEVEL_0
     
211. 
     
212. 
     
213. RMAN> restore datafile '+DATA/orcl/datafile/users.259.930909037';
     
214. 
     
215. Starting restore at 27-DEC-16
     
216. using channel ORA_DISK_1
     
217. using channel ORA_DISK_2
     
218. using channel ORA_DISK_3
     
219. using channel ORA_DISK_4
     
220. using channel ORA_DISK_5
     
221. using channel ORA_DISK_6
     
222. using channel ORA_DISK_7
     
223. using channel ORA_DISK_8
     
224. using channel ORA_SBT_TAPE_1
     
225. using channel ORA_SBT_TAPE_2
     
226. 
     
227. channel ORA_DISK_1: restoring datafile 00004
     
228. input datafile copy RECID=32 STAMP=931708682 file name=+FRA/orcl/datafile/users.390.931533947
     
229. destination for restore of datafile 00004: +DATA/orcl/datafile/users.259.930909037
     
230. ORA-19505: failed to identify file "+FRA/orcl/datafile/users.390.931533947"
     
231. ORA-17503: ksfdopn:2 Failed to open file +FRA/orcl/datafile/users.390.931533947
     
232. ORA-15012: ASM file '+FRA/orcl/datafile/users.390.931533947' does not exist
     
233. ORA-19600: input file is datafile-copy 32 (+FRA/orcl/datafile/users.390.931533947)
     
234. ORA-19601: output file is datafile 4 (+DATA)
     
235. 
     
236. failover to previous backup
     
237. 
     
238. channel ORA_SBT_TAPE_1: starting datafile backup set restore
     
239. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
     
240. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.259.930909037
     
241. channel ORA_SBT_TAPE_1: reading from backup piece 34roc54f_1_1
     
242. channel ORA_SBT_TAPE_1: piece handle=34roc54f_1_1 tag=TAG20161225T152607
     
243. channel ORA_SBT_TAPE_1: restored backup piece 1
     
244. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:55
     
245. Finished restore at 27-DEC-16
     
246. 
     
247. RMAN> list failure;
     
248. 
     
249. List of Database Failures
     
250. =========================
     
251. 
     
252. Failure ID Priority Status    Time Detected Summary
     
253. ---------- -------- --------- ------------- -------
     
254. 2808       HIGH     OPEN      27-DEC-16     Tablespace 4: 'USERS' is offline
     
255. 
     
256. RMAN> advise failure all;
     
257. 
     
258. List of Database Failures
     
259. =========================
     
260. 
     
261. Failure ID Priority Status    Time Detected Summary
     
262. ---------- -------- --------- ------------- -------
     
263. 2808       HIGH     OPEN      27-DEC-16     Tablespace 4: 'USERS' is offline
     
264. 
     
265. analyzing automatic repair options; this may take some time
     
266. using channel ORA_DISK_1
     
267. using channel ORA_DISK_2
     
268. using channel ORA_DISK_3
     
269. using channel ORA_DISK_4
     
270. using channel ORA_DISK_5
     
271. using channel ORA_DISK_6
     
272. using channel ORA_DISK_7
     
273. using channel ORA_DISK_8
     
274. using channel ORA_SBT_TAPE_1
     
275. using channel ORA_SBT_TAPE_2
     
276. analyzing automatic repair options complete
     
277. 
     
278. Mandatory Manual Actions
     
279. ========================
     
280. 1. Please contact Oracle Support Services to resolve failure 2808: Tablespace 4: 'USERS' is offline
     
281. 
     
282. Optional Manual Actions
     
283. =======================
     
284. no manual actions available
     
285. 
     
286. Automated Repair Options
     
287. ========================
     
288. no automatic repair options available
     
289. 
     
290. RMAN> repair failure preview;
     
291. 
     
292. RMAN-00571: ===========================================================
     
293. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
294. RMAN-00571: ===========================================================
     
295. RMAN-03002: failure of repair command at 12/27/2016 18:01:31
     
296. RMAN-06953: no automatic repairs were listed by ADVISE FAILURE
     
297. 
     
298. RMAN> sql "alter tablespace users online";
     
299. 
     
300. sql statement: alter tablespace users online
     
301. RMAN-00571: ===========================================================
     
302. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
303. RMAN-00571: ===========================================================
     
304. RMAN-03009: failure of sql command on default channel at 12/27/2016 18:01:48
     
305. RMAN-11003: failure during parse/execution of SQL statement: alter tablespace users online
     
306. ORA-01113: file 4 needs media recovery
     
307. ORA-01110: data file 4: '+DATA/orcl/datafile/users.259.931716043'
     
308. 
     
309. RMAN> list failure;
     
310. 
     
311. List of Database Failures
     
312. =========================
     
313. 
     
314. Failure ID Priority Status    Time Detected Summary
     
315. ---------- -------- --------- ------------- -------
     
316. 8          HIGH     OPEN      27-DEC-16     One or more non-system datafiles need media recovery
     
317. 2808       HIGH     OPEN      27-DEC-16     Tablespace 4: 'USERS' is offline
     
318. 
     
319. RMAN> advise failure all;
     
320. 
     
321. List of Database Failures
     
322. =========================
     
323. 
     
324. Failure ID Priority Status    Time Detected Summary
     
325. ---------- -------- --------- ------------- -------
     
326. 8          HIGH     OPEN      27-DEC-16     One or more non-system datafiles need media recovery
     
327. 2808       HIGH     OPEN      27-DEC-16     Tablespace 4: 'USERS' is offline
     
328. 
     
329. analyzing automatic repair options; this may take some time
     
330. using channel ORA_DISK_1
     
331. using channel ORA_DISK_2
     
332. using channel ORA_DISK_3
     
333. using channel ORA_DISK_4
     
334. using channel ORA_DISK_5
     
335. using channel ORA_DISK_6
     
336. using channel ORA_DISK_7
     
337. using channel ORA_DISK_8
     
338. using channel ORA_SBT_TAPE_1
     
339. using channel ORA_SBT_TAPE_2
     
340. analyzing automatic repair options complete
     
341. 
     
342. Not all specified failures can currently be repaired.
     
343. The following failures must be repaired before advise for others can be given.
     
344. 
     
345. Failure ID Priority Status    Time Detected Summary
     
346. ---------- -------- --------- ------------- -------
     
347. 8          HIGH     OPEN      27-DEC-16     One or more non-system datafiles need media recovery
     
348. 
     
349. Mandatory Manual Actions
     
350. ========================
     
351. no manual actions available
     
352. 
     
353. Optional Manual Actions
     
354. =======================
     
355. 1. If you restored the wrong version of data file +DATA/orcl/datafile/users.259.931716043, then replace it with the correct one
     
356. 
     
357. Automated Repair Options
     
358. ========================
     
359. Option Repair Description
     
360. ------ ------------------
     
361. 1      Recover datafile 4  
     
362.   Strategy: The repair includes complete media recovery with no data loss
     
363.   Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_2101988646.hm
     
364. 
     
365. RMAN> repair failure preview;
     
366. 
     
367. Strategy: The repair includes complete media recovery with no data loss
     
368. Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_2101988646.hm
     
369. 
     
370. contents of repair script:
     
371.    # recover datafile
     
372.    sql 'alter database datafile 4 offline';
     
373.    recover datafile 4;
     
374.    sql 'alter database datafile 4 online';
     
375. 
     
376. RMAN> repair failure;
     
377. 
     
378. Strategy: The repair includes complete media recovery with no data loss
     
379. Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_2101988646.hm
     
380. 
     
381. contents of repair script:
     
382.    # recover datafile
     
383.    sql 'alter database datafile 4 offline';
     
384.    recover datafile 4;
     
385.    sql 'alter database datafile 4 online';
     
386. 
     
387. Do you really want to execute the above repair (enter YES or NO)? YES
     
388. executing repair script
     
389. 
     
390. sql statement: alter database datafile 4 offline
     
391. 
     
392. Starting recover at 27-DEC-16
     
393. using channel ORA_DISK_1
     
394. using channel ORA_DISK_2
     
395. using channel ORA_DISK_3
     
396. using channel ORA_DISK_4
     
397. using channel ORA_DISK_5
     
398. using channel ORA_DISK_6
     
399. using channel ORA_DISK_7
     
400. using channel ORA_DISK_8
     
401. using channel ORA_SBT_TAPE_1
     
402. using channel ORA_SBT_TAPE_2
     
403. channel ORA_DISK_1: starting incremental datafile backup set restore
     
404. channel ORA_DISK_1: specifying datafile(s) to restore from backup set
     
405. destination for restore of datafile 00004: +DATA/orcl/datafile/users.259.931716043
     
406. channel ORA_DISK_1: reading from backup piece +FRA/orcl/backupset/2016_12_26/nnndn1_ora_oem_level_0_0.392.931620325
     
407. channel ORA_DISK_1: piece handle=+FRA/orcl/backupset/2016_12_26/nnndn1_ora_oem_level_0_0.392.931620325 tag=ORA_OEM_LEVEL_0
     
408. channel ORA_DISK_1: restored backup piece 1
     
409. channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
     
410. channel ORA_DISK_1: starting incremental datafile backup set restore
     
411. channel ORA_DISK_1: specifying datafile(s) to restore from backup set
     
412. destination for restore of datafile 00004: +DATA/orcl/datafile/users.259.931716043
     
413. channel ORA_DISK_1: reading from backup piece +FRA/orcl/backupset/2016_12_27/nnndn1_ora_oem_level_0_0.382.931706737
     
414. channel ORA_DISK_1: piece handle=+FRA/orcl/backupset/2016_12_27/nnndn1_ora_oem_level_0_0.382.931706737 tag=ORA_OEM_LEVEL_0
     
415. channel ORA_DISK_1: restored backup piece 1
     
416. channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
     
417. channel ORA_DISK_1: starting incremental datafile backup set restore
     
418. channel ORA_DISK_1: specifying datafile(s) to restore from backup set
     
419. destination for restore of datafile 00004: +DATA/orcl/datafile/users.259.931716043
     
420. channel ORA_DISK_1: reading from backup piece +FRA/orcl/backupset/2016_12_27/nnndn1_ora_oem_level_0_0.376.931707425
     
421. channel ORA_DISK_1: piece handle=+FRA/orcl/backupset/2016_12_27/nnndn1_ora_oem_level_0_0.376.931707425 tag=ORA_OEM_LEVEL_0
     
422. channel ORA_DISK_1: restored backup piece 1
     
423. channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
     
424. channel ORA_DISK_1: starting incremental datafile backup set restore
     
425. channel ORA_DISK_1: specifying datafile(s) to restore from backup set
     
426. destination for restore of datafile 00004: +DATA/orcl/datafile/users.259.931716043
     
427. channel ORA_DISK_1: reading from backup piece +FRA/orcl/backupset/2016_12_27/nnndn1_ora_oem_level_0_0.373.931708447
     
428. channel ORA_DISK_1: piece handle=+FRA/orcl/backupset/2016_12_27/nnndn1_ora_oem_level_0_0.373.931708447 tag=ORA_OEM_LEVEL_0
     
429. channel ORA_DISK_1: restored backup piece 1
     
430. channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
     
431. channel ORA_DISK_1: starting incremental datafile backup set restore
     
432. channel ORA_DISK_1: specifying datafile(s) to restore from backup set
     
433. destination for restore of datafile 00004: +DATA/orcl/datafile/users.259.931716043
     
434. channel ORA_DISK_1: reading from backup piece +FRA/orcl/backupset/2016_12_27/nnndn1_ora_oem_level_0_0.369.931708565
     
435. channel ORA_DISK_1: piece handle=+FRA/orcl/backupset/2016_12_27/nnndn1_ora_oem_level_0_0.369.931708565 tag=ORA_OEM_LEVEL_0
     
436. channel ORA_DISK_1: restored backup piece 1
     
437. channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
     
438. channel ORA_DISK_1: starting incremental datafile backup set restore
     
439. channel ORA_DISK_1: specifying datafile(s) to restore from backup set
     
440. destination for restore of datafile 00004: +DATA/orcl/datafile/users.259.931716043
     
441. channel ORA_DISK_1: reading from backup piece +FRA/orcl/backupset/2016_12_27/nnndn1_ora_oem_level_0_0.366.931708685
     
442. channel ORA_DISK_1: piece handle=+FRA/orcl/backupset/2016_12_27/nnndn1_ora_oem_level_0_0.366.931708685 tag=ORA_OEM_LEVEL_0
     
443. channel ORA_DISK_1: restored backup piece 1
     
444. channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
     
445. 
     
446. starting media recovery
     
447. 
     
448. archived log for thread 1 with sequence 73 is already on disk as file +FRA/orcl/archivelog/2016_12_27/thread_1_seq_73.364.931708705
     
449. archived log for thread 1 with sequence 74 is already on disk as file +FRA/orcl/archivelog/2016_12_27/thread_1_seq_74.363.931708817
     
450. archived log for thread 1 with sequence 75 is already on disk as file +FRA/orcl/archivelog/2016_12_27/thread_1_seq_75.362.931715235
     
451. archived log for thread 1 with sequence 76 is already on disk as file +FRA/orcl/archivelog/2016_12_27/thread_1_seq_76.361.931715235
     
452. archived log for thread 1 with sequence 77 is already on disk as file +FRA/orcl/archivelog/2016_12_27/thread_1_seq_77.360.931715239
     
453. archived log for thread 1 with sequence 78 is already on disk as file +FRA/orcl/archivelog/2016_12_27/thread_1_seq_78.359.931715239
     
454. archived log for thread 1 with sequence 79 is already on disk as file +FRA/orcl/archivelog/2016_12_27/thread_1_seq_79.358.931715241
     
455. archived log for thread 1 with sequence 80 is already on disk as file +FRA/orcl/archivelog/2016_12_27/thread_1_seq_80.357.931715243
     
456. archived log file name=+FRA/orcl/archivelog/2016_12_27/thread_1_seq_73.364.931708705 thread=1 sequence=73
     
457. archived log file name=+FRA/orcl/archivelog/2016_12_27/thread_1_seq_74.363.931708817 thread=1 sequence=74
     
458. archived log file name=+FRA/orcl/archivelog/2016_12_27/thread_1_seq_75.362.931715235 thread=1 sequence=75
     
459. archived log file name=+FRA/orcl/archivelog/2016_12_27/thread_1_seq_76.361.931715235 thread=1 sequence=76
     
460. archived log file name=+FRA/orcl/archivelog/2016_12_27/thread_1_seq_77.360.931715239 thread=1 sequence=77
     
461. archived log file name=+FRA/orcl/archivelog/2016_12_27/thread_1_seq_78.359.931715239 thread=1 sequence=78
     
462. media recovery complete, elapsed time: 00:00:01
     
463. Finished recover at 27-DEC-16
     
464. 
     
465. sql statement: alter database datafile 4 online
     
466. repair failure complete
     
467. 
     
468. RMAN> list failure;
     
469. 
     
470. List of Database Failures
     
471. =========================
     
472. 
     
473. Failure ID Priority Status    Time Detected Summary
     
474. ---------- -------- --------- ------------- -------
     
475. 2808       HIGH     OPEN      27-DEC-16     Tablespace 4: 'USERS' is offline
     
476. 
     
477. RMAN> sql "alter tablespace users online";
     
478. 
     
479. sql statement: alter tablespace users online
     
480. 
     
481. RMAN> list failure;
     
482. 
     
483. no failures found that match specification
     
484. 
     
485. RMAN> exit
     
486. 
     
487. 
     
488. Recovery Manager complete.
     
489. [oracle@station90 ~]$
     

复制代码

DRA: