课程第28/29次（2017-05-13星期六上下午）

botang

上完1Z0-053第3/4章
进行1Z0-053第5章（已经上完块跟踪/上完单个文件Section Size并行分片/进行Archival Backup）
1Z0-052共19章（上完12章），1Z0-053共21章（上完8章）和1Z0-063多租户部分共9章（上完0章）
总共上完全部49章中的20章

1. [root@station90 桌面]# su - oracle
   
2. [oracle@station90 ~]$ . oraenv
   
3. ORACLE_SID = [orcl] ? rcat
   
4. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
   
5. [oracle@station90 ~]$ sqlplus /nolog
   
6. 
   
7. SQL*Plus: Release 11.2.0.1.0 Production on Sat May 13 09:15:52 2017
   
8. 
   
9. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
10. 
    
11. SQL> conn / as sysdba
    
12. Connected to an idle instance.
    
13. SQL> startup
    
14. ORACLE instance started.
    
15. 
    
16. Total System Global Area 1603411968 bytes
    
17. Fixed Size                    2213776 bytes
    
18. Variable Size                  469764208 bytes
    
19. Database Buffers         1124073472 bytes
    
20. Redo Buffers                    7360512 bytes
    
21. Database mounted.
    
22. Database opened.
    
23. SQL> select dbid from v$database;
    
24. 
    
25.       DBID
    
26. ----------
    
27. 590260915
    
28. 
    
29. SQL> exit
    
30. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
31. With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
32. [oracle@station90 ~]$ . oraenv
    
33. ORACLE_SID = [rcat] ? orcl
    
34. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
    
35. [oracle@station90 ~]$ sqlplus /nolog
    
36. 
    
37. SQL*Plus: Release 11.2.0.1.0 Production on Sat May 13 09:26:02 2017
    
38. 
    
39. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
40. 
    
41. SQL> conn / as sysdba
    
42. Connected.
    
43. SQL> select dbid from v$database;
    
44. 
    
45.       DBID
    
46. ----------
    
47. 1343950367
    
48. 
    
49. SQL> exit
    
50. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
51. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    
52. and Real Application Testing options
    
53. [oracle@station90 ~]$ rman  catalog u90/oracle_4U@rcat
    
54. 
    
55. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:30:19 2017
    
56. 
    
57. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
58. 
    
59. connected to recovery catalog database
    
60. 
    
61. RMAN> import catalog u90/oracle_4U@utforcl199
    
62. 2> ;
    
63. 
    
64. Starting import catalog at 13-MAY-17
    
65. RMAN-00571: ===========================================================
    
66. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
67. RMAN-00571: ===========================================================
    
68. RMAN-03002: failure of import catalog command at 05/13/2017 09:30:40
    
69. RMAN-04035: error from source recovery catalog database: ORA-12154: TNS:could not resolve the connect identifier specified
    
70. 
    
71. RMAN> import catalog u90/oracle_4U@utforcl199
    
72. 2> ;
    
73. 
    
74. Starting import catalog at 13-MAY-17
    
75. connected to source recovery catalog database
    
76. import validation complete
    
77. RMAN-00571: ===========================================================
    
78. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
79. RMAN-00571: ===========================================================
    
80. RMAN-03002: failure of import catalog command at 05/13/2017 09:31:46
    
81. RMAN-06004: ORACLE error from recovery catalog database: RMAN-20512: source database already registered in recovery catalog
    
82. 
    
83. RMAN> import catalog u90/oracle_4U@utforcl199 dbid=1347195613 no unregister;
    
84. 
    
85. Starting import catalog at 13-MAY-17
    
86. connected to source recovery catalog database
    
87. import validation complete
    
88. Finished import catalog at 13-MAY-17
    
89. 
    
90. RMAN> exit
    
91. 
    
92. 
    
93. Recovery Manager complete.
    
94. [oracle@station90 ~]$ . oraenv
    
95. ORACLE_SID = [orcl] ? rcat
    
96. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
    
97. [oracle@station90 ~]$ sqlplus /nolog
    
98. 
    
99. SQL*Plus: Release 11.2.0.1.0 Production on Sat May 13 09:45:33 2017
    
100. 
     
101. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
102. 
     
103. SQL> conn u90/oracle_4U
     
104. Connected.
     
105. SQL> select dbid from v$database;
     
106. select dbid from v$database
     
107.                  *
     
108. ERROR at line 1:
     
109. ORA-00942: table or view does not exist
     
110. 
     
111. 
     
112. SQL> select dbid from db;
     
113. select dbid from db
     
114.        *
     
115. ERROR at line 1:
     
116. ORA-00904: "DBID": invalid identifier
     
117. 
     
118. 
     
119. SQL> select * from db;
     
120. 
     
121.     DB_KEY        DB_ID CURR_DBINC_KEY
     
122. ---------- ---------- --------------
     
123.          2 1343950367                   4
     
124.       3002 1359978017                3003
     
125.       6127 1347195613                6128
     
126. 
     
127. SQL> select * from db;
     
128. 
     
129.     DB_KEY        DB_ID CURR_DBINC_KEY
     
130. ---------- ---------- --------------
     
131.          2 1343950367                   4
     
132.       3002 1359978017                3003
     
133.       6127 1347195613                6128
     
134. 
     
135. SQL> /
     
136. 
     
137.     DB_KEY        DB_ID CURR_DBINC_KEY
     
138. ---------- ---------- --------------
     
139.          2 1343950367                   4
     
140.       3002 1359978017                3003
     
141.       6127 1347195613                6128
     
142. 
     
143. SQL> /
     
144. 
     
145.     DB_KEY        DB_ID CURR_DBINC_KEY
     
146. ---------- ---------- --------------
     
147.          2 1343950367                   4
     
148.       3002 1359978017                3003
     
149.       8474  454057935                8475
     
150.       6127 1347195613                6128
     
151. 
     
152. SQL>
     
153. ----------------------------------------------------------------
     
154. 
     
155. 
     
156. 
     
157. 
     
158. create user v91 identified by oracle_4U ;
     
159. 
     
160. create user v92 identified by oracle_4U ;
     
161. 
     
162. create user v93 identified by oracle_4U ;
     
163. 
     
164. grant recovery_catalog_owner to v91;
     
165. 
     
166. grant recovery_catalog_owner to v92;
     
167. 
     
168. grant recovery_catalog_owner to v93;
     
169. 
     
170. create user v94 identified by oracle_4U ;
     
171. 
     
172. grant recovery_catalog_owner to v94;
     
173. ------------------------------------------------------
     
174. [root@station90 桌面]# su - oracle
     
175. [oracle@station90 ~]$ rman catalog  u90/oracle_4U@rcat
     
176. 
     
177. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:47:02 2017
     
178. 
     
179. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
180. 
     
181. connected to recovery catalog database
     
182. 
     
183. RMAN> grant catalog for database 1343950367 to v91;
     
184. 
     
185. Grant succeeded.
     
186. 
     
187. RMAN> grant catalog for database 1347195613 to v92;
     
188. 
     
189. Grant succeeded.
     
190. 
     
191. RMAN> grant catalog for database 1359978017 to v93 ;
     
192. 
     
193. Grant succeeded.
     
194. 
     
195. RMAN> connect v91/oracle_4U@rcat
     
196. 
     
197. RMAN-00571: ===========================================================
     
198. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
199. RMAN-00571: ===========================================================
     
200. RMAN-00558: error encountered while parsing input commands
     
201. RMAN-01009: syntax error: found "identifier": expecting one of: "auxiliary, catalog, target"
     
202. RMAN-01008: the bad identifier was: v91
     
203. RMAN-01007: at line 1 column 9 file: standard input
     
204. 
     
205. RMAN> connect catalog v91/oracle_4U@rcat
     
206. 
     
207. RMAN-00571: ===========================================================
     
208. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
209. RMAN-00571: ===========================================================
     
210. RMAN-06167: already connected
     
211. 
     
212. RMAN>  connect catalog v91/oracle_4U@rcat
     
213. 
     
214. RMAN-00571: ===========================================================
     
215. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
216. RMAN-00571: ===========================================================
     
217. RMAN-06167: already connected
     
218. 
     
219. RMAN> create virtual catalog;
     
220. 
     
221. recovery catalog already exists
     
222. 
     
223. RMAN> exit
     
224. 
     
225. 
     
226. Recovery Manager complete.
     
227. [oracle@station90 ~]$ rman catalog  v91/oracle_4U@rcat
     
228. 
     
229. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:50:11 2017
     
230. 
     
231. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
232. 
     
233. connected to recovery catalog database
     
234. 
     
235. RMAN> create virtual catalog;
     
236. 
     
237. found ineligible base catalog owned by U4
     
238. found ineligible base catalog owned by U26
     
239. found ineligible base catalog owned by U77
     
240. found eligible base catalog owned by U90
     
241. created virtual catalog against base catalog owned by U90
     
242. 
     
243. RMAN> exit
     
244. 
     
245. 
     
246. Recovery Manager complete.
     
247. [oracle@station90 ~]$ rman catalog  v92/oracle_4U@rcat
     
248. 
     
249. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:50:40 2017
     
250. 
     
251. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
252. 
     
253. connected to recovery catalog database
     
254. 
     
255. RMAN> create virual catalog;
     
256. 
     
257. RMAN-00571: ===========================================================
     
258. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
259. RMAN-00571: ===========================================================
     
260. RMAN-00558: error encountered while parsing input commands
     
261. RMAN-01009: syntax error: found "identifier": expecting one of: "catalog, global, restore, script, virtual"
     
262. RMAN-01008: the bad identifier was: virual
     
263. RMAN-01007: at line 1 column 8 file: standard input
     
264. 
     
265. create virtual catalog;talog;
     
266. 
     
267. 
     
268. found ineligible base catalog owned by U4
     
269. found ineligible base catalog owned by U26
     
270. found ineligible base catalog owned by U77
     
271. found eligible base catalog owned by U90
     
272. created virtual catalog against base catalog owned by U90
     
273. 
     
274. RMAN>
     
275. RMAN> exit
     
276. 
     
277. 
     
278. Recovery Manager complete.
     
279. [oracle@station90 ~]$ rman catalog  v93/oracle_4U@rcat
     
280. 
     
281. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:51:08 2017
     
282. 
     
283. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
284. 
     
285. connected to recovery catalog database
     
286. 
     
287. RMAN> create virtual catalog;
     
288. 
     
289. found ineligible base catalog owned by U4
     
290. found ineligible base catalog owned by U26
     
291. found ineligible base catalog owned by U77
     
292. found eligible base catalog owned by U90
     
293. created virtual catalog against base catalog owned by U90
     
294. 
     
295. RMAN>
     
296. --------------------------------------------
     
297. 
     
298. v91:
     
299. 
     
300. [root@station90 桌面]# su - oracle
     
301. [oracle@station90 ~]$ rman catalog  u90/oracle_4U@rcat
     
302. 
     
303. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:47:02 2017
     
304. 
     
305. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
306. 
     
307. connected to recovery catalog database
     
308. 
     
309. RMAN> grant catalog for database 1343950367 to v91;
     
310. 
     
311. Grant succeeded.
     
312. 
     
313. RMAN> grant catalog for database 1347195613 to v92;
     
314. 
     
315. Grant succeeded.
     
316. 
     
317. RMAN> grant catalog for database 1359978017 to v93 ;
     
318. 
     
319. Grant succeeded.
     
320. 
     
321. RMAN> connect v91/oracle_4U@rcat
     
322. 
     
323. RMAN-00571: ===========================================================
     
324. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
325. RMAN-00571: ===========================================================
     
326. RMAN-00558: error encountered while parsing input commands
     
327. RMAN-01009: syntax error: found "identifier": expecting one of: "auxiliary, catalog, target"
     
328. RMAN-01008: the bad identifier was: v91
     
329. RMAN-01007: at line 1 column 9 file: standard input
     
330. 
     
331. RMAN> connect catalog v91/oracle_4U@rcat
     
332. 
     
333. RMAN-00571: ===========================================================
     
334. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
335. RMAN-00571: ===========================================================
     
336. RMAN-06167: already connected
     
337. 
     
338. RMAN>  connect catalog v91/oracle_4U@rcat
     
339. 
     
340. RMAN-00571: ===========================================================
     
341. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
342. RMAN-00571: ===========================================================
     
343. RMAN-06167: already connected
     
344. 
     
345. RMAN> create virtual catalog;
     
346. 
     
347. recovery catalog already exists
     
348. 
     
349. RMAN> exit
     
350. 
     
351. 
     
352. Recovery Manager complete.
     
353. [oracle@station90 ~]$ rman catalog  v91/oracle_4U@rcat
     
354. 
     
355. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:50:11 2017
     
356. 
     
357. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
358. 
     
359. connected to recovery catalog database
     
360. 
     
361. RMAN> create virtual catalog;
     
362. 
     
363. found ineligible base catalog owned by U4
     
364. found ineligible base catalog owned by U26
     
365. found ineligible base catalog owned by U77
     
366. found eligible base catalog owned by U90
     
367. created virtual catalog against base catalog owned by U90
     
368. 
     
369. RMAN> exit
     
370. 
     
371. 
     
372. Recovery Manager complete.
     
373. [oracle@station90 ~]$ rman catalog  v92/oracle_4U@rcat
     
374. 
     
375. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:50:40 2017
     
376. 
     
377. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
378. 
     
379. connected to recovery catalog database
     
380. 
     
381. RMAN> create virual catalog;
     
382. 
     
383. RMAN-00571: ===========================================================
     
384. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
385. RMAN-00571: ===========================================================
     
386. RMAN-00558: error encountered while parsing input commands
     
387. RMAN-01009: syntax error: found "identifier": expecting one of: "catalog, global, restore, script, virtual"
     
388. RMAN-01008: the bad identifier was: virual
     
389. RMAN-01007: at line 1 column 8 file: standard input
     
390. 
     
391. create virtual catalog;talog;
     
392. 
     
393. 
     
394. found ineligible base catalog owned by U4
     
395. found ineligible base catalog owned by U26
     
396. found ineligible base catalog owned by U77
     
397. found eligible base catalog owned by U90
     
398. created virtual catalog against base catalog owned by U90
     
399. 
     
400. RMAN>
     
401. RMAN> exit
     
402. 
     
403. 
     
404. Recovery Manager complete.
     
405. [oracle@station90 ~]$ rman catalog  v93/oracle_4U@rcat
     
406. 
     
407. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:51:08 2017
     
408. 
     
409. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
410. 
     
411. connected to recovery catalog database
     
412. 
     
413. RMAN> create virtual catalog;
     
414. 
     
415. found ineligible base catalog owned by U4
     
416. found ineligible base catalog owned by U26
     
417. found ineligible base catalog owned by U77
     
418. found eligible base catalog owned by U90
     
419. created virtual catalog against base catalog owned by U90
     
420. 
     
421. RMAN>
     
422. 
     
423. 
     
424. --------------------------------------------
     
425. V93:
     
426. 
     
427. 
     
428. 
     
429. 
     
430. [root@station90 ~]# ssh station26
     
431. The authenticity of host 'station26 (192.168.0.26)' can't be established.
     
432. RSA key fingerprint is df:20:f7:84:94:66:b7:46:f5:2e:f8:2e:0c:4c:32:ac.
     
433. Are you sure you want to continue connecting (yes/no)? yes
     
434. Warning: Permanently added 'station26,192.168.0.26' (RSA) to the list of known hosts.
     
435. Last login: Sat May 13 09:28:10 2017 from station90.example.com
     
436. [root@station26 ~]# su - oracle
     
437. [oracle@station26 ~]$ rman target  / catalog v93/oracle_4U@rcat
     
438. 
     
439. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:53:56 2017
     
440. 
     
441. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
442. 
     
443. connected to target database: ORCL (DBID=1359978017)
     
444. connected to recovery catalog database
     
445. 
     
446. RMAN> report schema;
     
447. 
     
448. Report of database schema for database with db_unique_name ORCL
     
449. 
     
450. List of Permanent Datafiles
     
451. ===========================
     
452. File Size(MB) Tablespace           RB segs Datafile Name
     
453. ---- -------- -------------------- ------- ------------------------
     
454. 1    690      SYSTEM               YES     +DATA/orcl/datafile/system.256.943294517
     
455. 2    580      SYSAUX               NO      +DATA/orcl/datafile/sysaux.258.941388173
     
456. 3    100      UNDOTBS1             YES     +DATA/orcl/datafile/undotbs1.259.941388169
     
457. 4    7        USERS                NO      +DATA/orcl/datafile/users.265.943357169
     
458. 5    100      EXAMPLE              NO      +DATA/orcl/datafile/example.257.941388169
     
459. 
     
460. List of Temporary Files
     
461. =======================
     
462. File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
     
463. ---- -------- -------------------- ----------- --------------------
     
464. 1    29       TEMP                 32767       +DATA/orcl/tempfile/temp.264.832197335
     
465. 3    6144     TEMP                 6144        /u01/app/oracle/oradata/orcl/temp03.dbf
     
466. 
     
467. RMAN> exit
     
468. 
     
469. 
     
470. Recovery Manager complete.
     
471. [oracle@station26 ~]$ rman target  / catalog v91/oracle_4U@rcat
     
472. 
     
473. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:54:10 2017
     
474. 
     
475. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
476. 
     
477. connected to target database: ORCL (DBID=1359978017)
     
478. connected to recovery catalog database
     
479. 
     
480. RMAN> report schema;
     
481. 
     
482. RMAN-00571: ===========================================================
     
483. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
484. RMAN-00571: ===========================================================
     
485. RMAN-03002: failure of report command at 05/13/2017 09:54:15
     
486. RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog
     
487. 
     
488. RMAN> exit
     
489. 
     
490. 
     
491. Recovery Manager complete.
     
492. [oracle@station26 ~]$ rman target  / catalog u90/oracle_4U@rcat
     
493. 
     
494. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:54:20 2017
     
495. 
     
496. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
497. 
     
498. connected to target database: ORCL (DBID=1359978017)
     
499. connected to recovery catalog database
     
500. 
     
501. RMAN> report schema;
     
502. 
     
503. Report of database schema for database with db_unique_name ORCL
     
504. 
     
505. List of Permanent Datafiles
     
506. ===========================
     
507. File Size(MB) Tablespace           RB segs Datafile Name
     
508. ---- -------- -------------------- ------- ------------------------
     
509. 1    690      SYSTEM               YES     +DATA/orcl/datafile/system.256.943294517
     
510. 2    580      SYSAUX               NO      +DATA/orcl/datafile/sysaux.258.941388173
     
511. 3    100      UNDOTBS1             YES     +DATA/orcl/datafile/undotbs1.259.941388169
     
512. 4    7        USERS                NO      +DATA/orcl/datafile/users.265.943357169
     
513. 5    100      EXAMPLE              NO      +DATA/orcl/datafile/example.257.941388169
     
514. 
     
515. List of Temporary Files
     
516. =======================
     
517. File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
     
518. ---- -------- -------------------- ----------- --------------------
     
519. 1    29       TEMP                 32767       +DATA/orcl/tempfile/temp.264.832197335
     
520. 3    6144     TEMP                 6144        /u01/app/oracle/oradata/orcl/temp03.dbf
     
521. 
     
522. RMAN>
     
523. 
     
524. ------------------------------------
     
525. V94:
     
526. 
     
527. 
     
528. 
     
529. Microsoft Windows [版本 6.1.7600]
     
530. 版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
     
531. 
     
532. C:\Users\Administrator>sqlplus /nolog
     
533. 
     
534. SQL*Plus: Release 11.2.0.1.0 Production on 星期六 5月 13 10:00:41 2017
     
535. 
     
536. Copyright (c) 1982, 2010, Oracle.  All rights reserved.
     
537. 
     
538. SQL> conn / as sysdba
     
539. 已连接。
     
540. SQL> select   dbid from v$database;
     
541. 
     
542.       DBID
     
543. ----------
     
544. 454057935
     
545. 
     
546. SQL> exit
     
547. 从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
     
548. With the Partitioning, OLAP, Data Mining and Real Application Testing options 断
     
549. 开
     
550. 
     
551. C:\Users\Administrator>tnsping rcat
     
552. 
     
553. TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 13-5月 -
     
554. 2017 10:01:08
     
555. 
     
556. Copyright (c) 1997, 2010, Oracle.  All rights reserved.
     
557. 
     
558. 已使用的参数文件:
     
559. C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
     
560. 
     
561. 
     
562. 已使用 TNSNAMES 适配器来解析别名
     
563. 尝试连接 (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT =
     
564. 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rcat.example.com)))
     
565. OK (10 毫秒)
     
566. 
     
567. C:\Users\Administrator>rman target  /  catalog v94/oracle_4U@rcat
     
568. 
     
569. 恢复管理器: Release 11.2.0.1.0 - Production on 星期六 5月 13 10:01:25 2017
     
570. 
     
571. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
572. 
     
573. 连接到目标数据库: UTFORCL (DBID=454057935)
     
574. 连接到恢复目录数据库
     
575. 
     
576. RMAN> register database;
     
577. 
     
578. 注册在恢复目录中的数据库
     
579. 正在启动全部恢复目录的 resync
     
580. 完成全部 resync
     
581. 
     
582. RMAN> exit
     
583. 
     
584. 
     
585. 恢复管理器完成。
     
586. 
     
587. C:\Users\Administrator>rman target  /  catalog u90/oracle_4U@rcat
     
588. 
     
589. 恢复管理器: Release 11.2.0.1.0 - Production on 星期六 5月 13 10:02:07 2017
     
590. 
     
591. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
592. 
     
593. 连接到目标数据库: UTFORCL (DBID=454057935)
     
594. 连接到恢复目录数据库
     
595. 
     
596. RMAN> report schema;
     
597. 
     
598. db_unique_name 为 UTFORCL 的数据库的数据库方案报表
     
599. 
     
600. 永久数据文件列表
     
601. ===========================
     
602. 文件大小 (MB) 表空间           回退段数据文件名称
     
603. ---- -------- -------------------- ------- ------------------------
     
604. 1    700      SYSTEM               YES     C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\
     
605. SYSTEM01.DBF
     
606. 2    510      SYSAUX               NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\
     
607. SYSAUX01.DBF
     
608. 3    100      UNDOTBS1             YES     C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\
     
609. UNDOTBS01.DBF
     
610. 4    5        USERS                NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\
     
611. USERS01.DBF
     
612. 5    100      EXAMPLE              NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\
     
613. EXAMPLE01.DBF
     
614. 6    5        TBSUTF8_11G          NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\
     
615. TBSUTF8_11G01.DBF
     
616. 7    30       RCATTBS              NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\
     
617. RCATTBS.DBF
     
618. 
     
619. 临时文件列表
     
620. =======================
     
621. 文件大小 (MB) 表空间           最大大小 (MB) 临时文件名称
     
622. ---- -------- -------------------- ----------- --------------------
     
623. 1    29       TEMP                 32767       C:\APP\ADMINISTRATOR\ORADATA\UTFO
     
624. RCL\TEMP01.DBF
     
625. 
     
626. RMAN>
     

复制代码

1. [root@station90 桌面]# obtool
   
2. ob> exit
   
3. [root@station90 桌面]# obtool
   
4. ob> lspiece
   
5. ob> exit
   
6. [root@station90 桌面]# su - oracle
   
7. [oracle@station90 ~]$ rman target /  
   
8. 
   
9. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 11:18:09 2017
   
10. 
    
11. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
12. 
    
13. connected to target database: ORCL (DBID=1343950367)
    
14. 
    
15. RMAN> show all;
    
16. 
    
17. using target database control file instead of recovery catalog
    
18. RMAN configuration parameters for database with db_unique_name ORCL are:
    
19. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
    
20. CONFIGURE BACKUP OPTIMIZATION ON;
    
21. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
    
22. CONFIGURE CONTROLFILE AUTOBACKUP ON;
    
23. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    
24. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
    
25. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
    
26. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
    
27. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
28. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
29. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
30. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
31. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
    
32. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
    
33. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    
34. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    
35. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    
36. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
    
37. CONFIGURE EXCLUDE FOR TABLESPACE 'SYSAUX';
    
38. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    
39. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
    
40. 
    
41. RMAN> list backup;
    
42. 
    
43. 
    
44. List of Backup Sets
    
45. ===================
    
46. 
    
47. 
    
48. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
49. ------- ---- -- ---------- ----------- ------------ ---------------
    
50. 16      Full    9.38M      SBT_TAPE    00:00:15     20-OCT-13      
    
51.         BP Key: 16   Status: EXPIRED  Compressed: NO  Tag: TAG20131020T172458
    
52.         Handle: c-1343950367-20131020-01   Media: station90-000009
    
53.   SPFILE Included: Modification time: 20-OCT-13
    
54.   SPFILE db_unique_name: ORCL
    
55.   Control File Included: Ckp SCN: 1042551      Ckp time: 20-OCT-13
    
56. 
    
57. BS Key  Size       Device Type Elapsed Time Completion Time
    
58. ------- ---------- ----------- ------------ ---------------
    
59. 17      64.00K     SBT_TAPE    00:00:15     20-OCT-13      
    
60.         BP Key: 17   Status: EXPIRED  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
    
61.         Handle: 0homt4ha_1_1   Media: station90-000009
    
62. 
    
63.   List of Archived Logs in backup set 17
    
64.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
    
65.   ---- ------- ---------- --------- ---------- ---------
    
66.   1    13      1042532    20-OCT-13 1042606    20-OCT-13
    
67. 
    
68. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
69. ------- ---- -- ---------- ----------- ------------ ---------------
    
70. 18      Incr 1  128.00K    SBT_TAPE    00:00:15     20-OCT-13      
    
71.         BP Key: 18   Status: EXPIRED  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
    
72.         Handle: 0iomt4hq_1_1   Media: station90-000009
    
73.   List of Datafiles in backup set 18
    
74.   File LV Type Ckp SCN    Ckp Time  Name
    
75.   ---- -- ---- ---------- --------- ----
    
76.   1    1  Incr 1042619    20-OCT-13 +DATA/orcl/datafile/system.256.816169553
    
77. 
    
78. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
79. ------- ---- -- ---------- ----------- ------------ ---------------
    
80. 19      Incr 1  7.44M      SBT_TAPE    00:00:24     20-OCT-13      
    
81.         BP Key: 19   Status: EXPIRED  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
    
82.         Handle: 0jomt4hq_1_1   Media: station90-000010
    
83.   List of Datafiles in backup set 19
    
84.   File LV Type Ckp SCN    Ckp Time  Name
    
85.   ---- -- ---- ---------- --------- ----
    
86.   2    1  Incr 1042622    20-OCT-13 +DATA/orcl/datafile/sysaux.257.816169553
    
87. 
    
88. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
89. ------- ---- -- ---------- ----------- ------------ ---------------
    
90. 20      Incr 1  1.50M      SBT_TAPE    00:00:39     20-OCT-13      
    
91.         BP Key: 20   Status: EXPIRED  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
    
92.         Handle: 0komt4hq_1_1   Media: station90-000010
    
93.   List of Datafiles in backup set 20
    
94.   File LV Type Ckp SCN    Ckp Time  Name
    
95.   ---- -- ---- ---------- --------- ----
    
96.   3    1  Incr 1042625    20-OCT-13 +DATA/orcl/datafile/undotbs1.258.816169553
    
97. 
    
98. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
99. ------- ---- -- ---------- ----------- ------------ ---------------
    
100. 21      Incr 1  64.00K     SBT_TAPE    00:00:40     20-OCT-13      
     
101.         BP Key: 21   Status: EXPIRED  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
     
102.         Handle: 0lomt4hq_1_1   Media: station90-000009
     
103.   List of Datafiles in backup set 21
     
104.   File LV Type Ckp SCN    Ckp Time  Name
     
105.   ---- -- ---- ---------- --------- ----
     
106.   5    1  Incr 1042629    20-OCT-13 +DATA/orcl/datafile/example.265.816169651
     
107. 
     
108. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
109. ------- ---- -- ---------- ----------- ------------ ---------------
     
110. 22      Incr 1  64.00K     SBT_TAPE    00:00:53     20-OCT-13      
     
111.         BP Key: 22   Status: EXPIRED  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
     
112.         Handle: 0momt4hr_1_1   Media: station90-000010
     
113.   List of Datafiles in backup set 22
     
114.   File LV Type Ckp SCN    Ckp Time  Name
     
115.   ---- -- ---- ---------- --------- ----
     
116.   4    1  Incr 1042632    20-OCT-13 +DATA/orcl/datafile/users.259.816169553
     
117. 
     
118. BS Key  Size       Device Type Elapsed Time Completion Time
     
119. ------- ---------- ----------- ------------ ---------------
     
120. 23      640.00K    SBT_TAPE    00:00:15     20-OCT-13      
     
121.         BP Key: 23   Status: EXPIRED  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
     
122.         Handle: 0nomt4ji_1_1   Media: station90-000009
     
123. 
     
124.   List of Archived Logs in backup set 23
     
125.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
126.   ---- ------- ---------- --------- ---------- ---------
     
127.   1    14      1042606    20-OCT-13 1043204    20-OCT-13
     
128. 
     
129. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
130. ------- ---- -- ---------- ----------- ------------ ---------------
     
131. 24      Full    9.38M      SBT_TAPE    00:00:16     20-OCT-13      
     
132.         BP Key: 24   Status: EXPIRED  Compressed: NO  Tag: TAG20131020T172739
     
133.         Handle: c-1343950367-20131020-02   Media: station90-000009
     
134.   SPFILE Included: Modification time: 20-OCT-13
     
135.   SPFILE db_unique_name: ORCL
     
136.   Control File Included: Ckp SCN: 1043235      Ckp time: 20-OCT-13
     
137. 
     
138. BS Key  Size       Device Type Elapsed Time Completion Time
     
139. ------- ---------- ----------- ------------ ---------------
     
140. 25      16.00M     SBT_TAPE    00:00:25     12-DEC-16      
     
141.         BP Key: 25   Status: EXPIRED  Compressed: NO  Tag: 4T_WHOLE_INCR0
     
142.         Handle: 0prn9uun_1_1   Media: station90-000009
     
143. 
     
144.   List of Archived Logs in backup set 25
     
145.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
146.   ---- ------- ---------- --------- ---------- ---------
     
147.   1    15      1043204    20-OCT-13 1047404    11-DEC-13
     
148. 
     
149. BS Key  Size       Device Type Elapsed Time Completion Time
     
150. ------- ---------- ----------- ------------ ---------------
     
151. 26      15.50M     SBT_TAPE    00:00:25     12-DEC-16      
     
152.         BP Key: 26   Status: EXPIRED  Compressed: NO  Tag: 4T_WHOLE_INCR0
     
153.         Handle: 0qrn9uun_1_1   Media: station90-000010
     
154. 
     
155.   List of Archived Logs in backup set 26
     
156.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
157.   ---- ------- ---------- --------- ---------- ---------
     
158.   1    16      1047404    11-DEC-13 1049898    11-DEC-13
     
159. 
     
160. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
161. ------- ---- -- ---------- ----------- ------------ ---------------
     
162. 27      Full    3.50M      SBT_TAPE    00:00:24     12-DEC-16      
     
163.         BP Key: 27   Status: EXPIRED  Compressed: NO  Tag: 4T_WHOLE_INCR0
     
164.         Handle: 0vrn9uvi_1_1   Media: station90-000010
     
165.   List of Datafiles in backup set 27
     
166.   File LV Type Ckp SCN    Ckp Time  Name
     
167.   ---- -- ---- ---------- --------- ----
     
168.   4       Full 1051009    12-DEC-16 +DATA/orcl/datafile/users.259.816169553
     
169. 
     
170. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
171. ------- ---- -- ---------- ----------- ------------ ---------------
     
172. 28      Full    588.75M    SBT_TAPE    00:01:04     12-DEC-16      
     
173.         BP Key: 28   Status: EXPIRED  Compressed: NO  Tag: 4T_WHOLE_INCR0
     
174.         Handle: 0rrn9uvh_1_1   Media: station90-000009
     
175.   List of Datafiles in backup set 28
     
176.   File LV Type Ckp SCN    Ckp Time  Name
     
177.   ---- -- ---- ---------- --------- ----
     
178.   1       Full 1051009    12-DEC-16 +DATA/orcl/datafile/system.256.816169553
     
179. 
     
180. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
181. ------- ---- -- ---------- ----------- ------------ ---------------
     
182. 29      Full    98.25M     SBT_TAPE    00:01:23     12-DEC-16      
     
183.         BP Key: 29   Status: EXPIRED  Compressed: NO  Tag: 4T_WHOLE_INCR0
     
184.         Handle: 0trn9uvh_1_1   Media: station90-000009
     
185.   List of Datafiles in backup set 29
     
186.   File LV Type Ckp SCN    Ckp Time  Name
     
187.   ---- -- ---- ---------- --------- ----
     
188.   3       Full 1051009    12-DEC-16 +DATA/orcl/datafile/undotbs1.258.816169553
     
189. 
     
190. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
191. ------- ---- -- ---------- ----------- ------------ ---------------
     
192. 30      Full    393.00M    SBT_TAPE    00:01:40     12-DEC-16      
     
193.         BP Key: 30   Status: EXPIRED  Compressed: NO  Tag: 4T_WHOLE_INCR0
     
194.         Handle: 0srn9uvh_1_1   Media: station90-000010
     
195.   List of Datafiles in backup set 30
     
196.   File LV Type Ckp SCN    Ckp Time  Name
     
197.   ---- -- ---- ---------- --------- ----
     
198.   2       Full 1051009    12-DEC-16 +DATA/orcl/datafile/sysaux.257.816169553
     
199. 
     
200. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
201. ------- ---- -- ---------- ----------- ------------ ---------------
     
202. 31      Full    69.25M     SBT_TAPE    00:01:59     12-DEC-16      
     
203.         BP Key: 31   Status: EXPIRED  Compressed: NO  Tag: 4T_WHOLE_INCR0
     
204.         Handle: 0urn9uvi_1_1   Media: station90-000009
     
205.   List of Datafiles in backup set 31
     
206.   File LV Type Ckp SCN    Ckp Time  Name
     
207.   ---- -- ---- ---------- --------- ----
     
208.   5       Full 1051009    12-DEC-16 +DATA/orcl/datafile/example.265.816169651
     
209. 
     
210. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
211. ------- ---- -- ---------- ----------- ------------ ---------------
     
212. 32      Full    9.50M      SBT_TAPE    00:00:16     12-DEC-16      
     
213.         BP Key: 32   Status: EXPIRED  Compressed: NO  Tag: TAG20161212T161439
     
214.         Handle: c-1343950367-20161212-00   Media: station90-000009
     
215.   SPFILE Included: Modification time: 12-DEC-16
     
216.   SPFILE db_unique_name: ORCL
     
217.   Control File Included: Ckp SCN: 1051009      Ckp time: 12-DEC-16
     
218. 
     
219. RMAN> list copy;
     
220. 
     
221. specification does not match any datafile copy in the repository
     
222. specification does not match any control file copy in the repository
     
223. List of Archived Log Copies for database with db_unique_name ORCL
     
224. =====================================================================
     
225. 
     
226. Key     Thrd Seq     S Low Time
     
227. ------- ---- ------- - ---------
     
228. 9       1    17      A 11-DEC-13
     
229.         Name: +FRA/orcl/archivelog/2017_05_13/thread_1_seq_17.262.943874229
     
230. 
     
231. 
     
232. RMAN> list backup;
     
233. 
     
234. specification does not match any backup in the repository
     
235. 
     
236. RMAN> show exclude;
     
237. 
     
238. RMAN configuration parameters for database with db_unique_name ORCL are:
     
239. CONFIGURE EXCLUDE FOR TABLESPACE 'SYSAUX';
     
240. 
     
241. RMAN> backup database ;
     
242. 
     
243. Starting backup at 13-MAY-17
     
244. allocated channel: ORA_SBT_TAPE_1
     
245. channel ORA_SBT_TAPE_1: SID=15 device type=SBT_TAPE
     
246. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
247. allocated channel: ORA_SBT_TAPE_2
     
248. channel ORA_SBT_TAPE_2: SID=80 device type=SBT_TAPE
     
249. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
250. file 2 is excluded from whole database backup
     
251. channel ORA_SBT_TAPE_1: starting full datafile backup set
     
252. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
253. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
     
254. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
     
255. channel ORA_SBT_TAPE_1: starting piece 1 at 13-MAY-17
     
256. channel ORA_SBT_TAPE_2: starting full datafile backup set
     
257. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
258. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
     
259. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
     
260. channel ORA_SBT_TAPE_2: starting piece 1 at 13-MAY-17
     
261. channel ORA_SBT_TAPE_2: finished piece 1 at 13-MAY-17
     
262. piece handle=14s44oaj_1_1 tag=TAG20170513T111946 comment=API Version 2.0,MMS Version 10.4.0.4
     
263. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
     
264. channel ORA_SBT_TAPE_1: finished piece 1 at 13-MAY-17
     
265. piece handle=13s44oai_1_1 tag=TAG20170513T111946 comment=API Version 2.0,MMS Version 10.4.0.4
     
266. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:36
     
267. Finished backup at 13-MAY-17
     
268. 
     
269. Starting Control File and SPFILE Autobackup at 13-MAY-17
     
270. piece handle=c-1343950367-20170513-00 comment=API Version 2.0,MMS Version 10.4.0.4
     
271. Finished Control File and SPFILE Autobackup at 13-MAY-17
     
272. 
     
273. RMAN> show exclude;
     
274. 
     
275. RMAN configuration parameters for database with db_unique_name ORCL are:
     
276. CONFIGURE EXCLUDE FOR TABLESPACE 'SYSAUX';
     
277. 
     
278. RMAN> CONFIGURE EXCLUDE FOR TABLESPACE 'SYSAUX' clear;
     
279. 
     
280. Tablespace SYSAUX will be included in future whole database backups
     
281. old RMAN configuration parameters are successfully deleted
     
282. 
     
283. RMAN> show exclude;
     
284. 
     
285. RMAN configuration parameters for database with db_unique_name ORCL are:
     
286. RMAN configuration has no stored or default parameters
     
287. 
     
288. RMAN> backup database ;
     
289. 
     
290. Starting backup at 13-MAY-17
     
291. using channel ORA_SBT_TAPE_1
     
292. using channel ORA_SBT_TAPE_2
     
293. channel ORA_SBT_TAPE_1: starting full datafile backup set
     
294. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
295. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
     
296. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
     
297. channel ORA_SBT_TAPE_1: starting piece 1 at 13-MAY-17
     
298. channel ORA_SBT_TAPE_2: starting full datafile backup set
     
299. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
300. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
     
301. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
     
302. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
     
303. channel ORA_SBT_TAPE_2: starting piece 1 at 13-MAY-17
     
304. channel ORA_SBT_TAPE_1: finished piece 1 at 13-MAY-17
     
305. piece handle=16s44odp_1_1 tag=TAG20170513T112129 comment=API Version 2.0,MMS Version 10.4.0.4
     
306. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
     
307. channel ORA_SBT_TAPE_2: finished piece 1 at 13-MAY-17
     
308. piece handle=17s44odp_1_1 tag=TAG20170513T112129 comment=API Version 2.0,MMS Version 10.4.0.4
     
309. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
     
310. Finished backup at 13-MAY-17
     
311. 
     
312. Starting Control File and SPFILE Autobackup at 13-MAY-17
     
313. piece handle=c-1343950367-20170513-01 comment=API Version 2.0,MMS Version 10.4.0.4
     
314. Finished Control File and SPFILE Autobackup at 13-MAY-17
     
315. 
     
316. RMAN> list backup;
     
317. 
     
318. 
     
319. List of Backup Sets
     
320. ===================
     
321. 
     
322. 
     
323. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
324. ------- ---- -- ---------- ----------- ------------ ---------------
     
325. 33      Full    167.50M    SBT_TAPE    00:00:17     13-MAY-17      
     
326.         BP Key: 33   Status: AVAILABLE  Compressed: NO  Tag: TAG20170513T111946
     
327.         Handle: 14s44oaj_1_1   Media: station90-000010
     
328.   List of Datafiles in backup set 33
     
329.   File LV Type Ckp SCN    Ckp Time  Name
     
330.   ---- -- ---- ---------- --------- ----
     
331.   3       Full 1056529    13-MAY-17 +DATA/orcl/datafile/undotbs1.258.816169553
     
332.   5       Full 1056529    13-MAY-17 +DATA/orcl/datafile/example.265.816169651
     
333. 
     
334. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
335. ------- ---- -- ---------- ----------- ------------ ---------------
     
336. 34      Full    592.25M    SBT_TAPE    00:00:26     13-MAY-17      
     
337.         BP Key: 34   Status: AVAILABLE  Compressed: NO  Tag: TAG20170513T111946
     
338.         Handle: 13s44oai_1_1   Media: station90-000009
     
339.   List of Datafiles in backup set 34
     
340.   File LV Type Ckp SCN    Ckp Time  Name
     
341.   ---- -- ---- ---------- --------- ----
     
342.   1       Full 1056527    13-MAY-17 +DATA/orcl/datafile/system.256.816169553
     
343.   4       Full 1056527    13-MAY-17 +DATA/orcl/datafile/users.259.816169553
     
344. 
     
345. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
346. ------- ---- -- ---------- ----------- ------------ ---------------
     
347. 35      Full    9.50M      SBT_TAPE    00:00:16     13-MAY-17      
     
348.         BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: TAG20170513T112022
     
349.         Handle: c-1343950367-20170513-00   Media: station90-000009
     
350.   SPFILE Included: Modification time: 13-MAY-17
     
351.   SPFILE db_unique_name: ORCL
     
352.   Control File Included: Ckp SCN: 1056606      Ckp time: 13-MAY-17
     
353. 
     
354. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
355. ------- ---- -- ---------- ----------- ------------ ---------------
     
356. 36      Full    658.00M    SBT_TAPE    00:00:20     13-MAY-17      
     
357.         BP Key: 36   Status: AVAILABLE  Compressed: NO  Tag: TAG20170513T112129
     
358.         Handle: 16s44odp_1_1   Media: station90-000009
     
359.   List of Datafiles in backup set 36
     
360.   File LV Type Ckp SCN    Ckp Time  Name
     
361.   ---- -- ---- ---------- --------- ----
     
362.   1       Full 1056703    13-MAY-17 +DATA/orcl/datafile/system.256.816169553
     
363.   5       Full 1056703    13-MAY-17 +DATA/orcl/datafile/example.265.816169651
     
364. 
     
365. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
366. ------- ---- -- ---------- ----------- ------------ ---------------
     
367. 37      Full    495.25M    SBT_TAPE    00:00:25     13-MAY-17      
     
368.         BP Key: 37   Status: AVAILABLE  Compressed: NO  Tag: TAG20170513T112129
     
369.         Handle: 17s44odp_1_1   Media: station90-000010
     
370.   List of Datafiles in backup set 37
     
371.   File LV Type Ckp SCN    Ckp Time  Name
     
372.   ---- -- ---- ---------- --------- ----
     
373.   2       Full 1056705    13-MAY-17 +DATA/orcl/datafile/sysaux.257.816169553
     
374.   3       Full 1056705    13-MAY-17 +DATA/orcl/datafile/undotbs1.258.816169553
     
375.   4       Full 1056705    13-MAY-17 +DATA/orcl/datafile/users.259.816169553
     
376. 
     
377. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
378. ------- ---- -- ---------- ----------- ------------ ---------------
     
379. 38      Full    9.50M      SBT_TAPE    00:00:16     13-MAY-17      
     
380.         BP Key: 38   Status: AVAILABLE  Compressed: NO  Tag: TAG20170513T112154
     
381.         Handle: c-1343950367-20170513-01   Media: station90-000009
     
382.   SPFILE Included: Modification time: 13-MAY-17
     
383.   SPFILE db_unique_name: ORCL
     
384.   Control File Included: Ckp SCN: 1056735      Ckp time: 13-MAY-17
     
385. 
     
386. RMAN> show all;
     
387. 
     
388. RMAN configuration parameters for database with db_unique_name ORCL are:
     
389. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
     
390. CONFIGURE BACKUP OPTIMIZATION ON;
     
391. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
     
392. CONFIGURE CONTROLFILE AUTOBACKUP ON;
     
393. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
     
394. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
     
395. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
     
396. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
     
397. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
398. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
399. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
400. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
401. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
402. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
403. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
     
404. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
     
405. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
     
406. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
     
407. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
     
408. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
     
409. 
     
410. RMAN> CONFIGURE COMPRESSION ALGORITHM low AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ;
     
411. 
     
412. RMAN-00571: ===========================================================
     
413. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
414. RMAN-00571: ===========================================================
     
415. RMAN-00558: error encountered while parsing input commands
     
416. RMAN-01009: syntax error: found "low": expecting one of: "clear, double-quoted-string, single-quoted-string"
     
417. RMAN-01007: at line 1 column 33 file: standard input
     
418. 
     
419. RMAN>
     
420. 
     
421. RMAN> ONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ;
     
422. 
     
423. RMAN-00571: ===========================================================
     
424. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
425. RMAN-00571: ===========================================================
     
426. RMAN-00558: error encountered while parsing input commands
     
427. 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, {, "
     
428. RMAN-01008: the bad identifier was: ONFIGURE
     
429. RMAN-01007: at line 2 column 1 file: standard input
     
430. 
     
431. RMAN> CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ;
     
432. 
     
433. new RMAN configuration parameters:
     
434. CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
     
435. new RMAN configuration parameters are successfully stored
     
436. 
     
437. RMAN> show all;
     
438. 
     
439. RMAN configuration parameters for database with db_unique_name ORCL are:
     
440. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
     
441. CONFIGURE BACKUP OPTIMIZATION ON;
     
442. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
     
443. CONFIGURE CONTROLFILE AUTOBACKUP ON;
     
444. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
     
445. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
     
446. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
     
447. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
     
448. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
449. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
450. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
451. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
452. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
453. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
454. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
     
455. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
     
456. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
     
457. CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
     
458. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
     
459. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
     
460. 
     
461. RMAN> CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO compressed BACKUPSET;
     
462. 
     
463. old RMAN configuration parameters:
     
464. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
     
465. new RMAN configuration parameters:
     
466. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
     
467. new RMAN configuration parameters are successfully stored
     
468. released channel: ORA_SBT_TAPE_1
     
469. released channel: ORA_SBT_TAPE_2
     
470. 
     
471. RMAN> backup database ;
     
472. 
     
473. Starting backup at 13-MAY-17
     
474. allocated channel: ORA_SBT_TAPE_1
     
475. channel ORA_SBT_TAPE_1: SID=15 device type=SBT_TAPE
     
476. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
477. allocated channel: ORA_SBT_TAPE_2
     
478. channel ORA_SBT_TAPE_2: SID=80 device type=SBT_TAPE
     
479. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
480. channel ORA_SBT_TAPE_1: starting compressed full datafile backup set
     
481. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
482. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
     
483. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
     
484. channel ORA_SBT_TAPE_1: starting piece 1 at 13-MAY-17
     
485. channel ORA_SBT_TAPE_2: starting compressed full datafile backup set
     
486. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
487. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
     
488. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
     
489. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
     
490. channel ORA_SBT_TAPE_2: starting piece 1 at 13-MAY-17
     
491. channel ORA_SBT_TAPE_1: finished piece 1 at 13-MAY-17
     
492. piece handle=19s44op7_1_1 tag=TAG20170513T112735 comment=API Version 2.0,MMS Version 10.4.0.4
     
493. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
     
494. channel ORA_SBT_TAPE_2: finished piece 1 at 13-MAY-17
     
495. piece handle=1as44op7_1_1 tag=TAG20170513T112735 comment=API Version 2.0,MMS Version 10.4.0.4
     
496. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:35
     
497. Finished backup at 13-MAY-17
     
498. 
     
499. Starting Control File and SPFILE Autobackup at 13-MAY-17
     
500. piece handle=c-1343950367-20170513-02 comment=API Version 2.0,MMS Version 10.4.0.4
     
501. Finished Control File and SPFILE Autobackup at 13-MAY-17
     
502. 
     
503. RMAN> show all
     
504. 2> ;
     
505. 
     
506. RMAN configuration parameters for database with db_unique_name ORCL are:
     
507. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
     
508. CONFIGURE BACKUP OPTIMIZATION ON;
     
509. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
     
510. CONFIGURE CONTROLFILE AUTOBACKUP ON;
     
511. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
     
512. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
     
513. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
     
514. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
     
515. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
516. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
517. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
518. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
519. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
520. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
521. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
     
522. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
     
523. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
     
524. CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
     
525. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
     
526. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
     
527. 
     
528. RMAN> CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE clear;
     
529. 
     
530. RMAN-00571: ===========================================================
     
531. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
532. RMAN-00571: ===========================================================
     
533. RMAN-00558: error encountered while parsing input commands
     
534. RMAN-01009: syntax error: found "clear": expecting one of: "as, for, optimize, ;"
     
535. RMAN-01007: at line 1 column 86 file: standard input
     
536. 
     
537. RMAN> CONFIGURE COMPRESSION ALGORITHM  clear;
     
538. 
     
539. old RMAN configuration parameters:
     
540. CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
     
541. RMAN configuration parameters are successfully reset to default value
     
542. 
     
543. RMAN> show all;
     
544. 
     
545. RMAN configuration parameters for database with db_unique_name ORCL are:
     
546. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
     
547. CONFIGURE BACKUP OPTIMIZATION ON;
     
548. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
     
549. CONFIGURE CONTROLFILE AUTOBACKUP ON;
     
550. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
     
551. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
     
552. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
     
553. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
     
554. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
555. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
556. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
557. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
558. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
559. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
560. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
     
561. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
     
562. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
     
563. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
     
564. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
     
565. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
     
566. 
     
567. RMAN> CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
     
568. 
     
569. old RMAN configuration parameters:
     
570. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
     
571. new RMAN configuration parameters:
     
572. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
     
573. new RMAN configuration parameters are successfully stored
     
574. released channel: ORA_SBT_TAPE_1
     
575. released channel: ORA_SBT_TAPE_2
     
576. 
     
577. RMAN> run {
     
578. 2> set COMPRESSION ALGORITHM 'HIGH' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
     
579. 3> backup as compressed backupset  tablespace system ;
     
580. 4> }
     
581. 
     
582. RMAN-00571: ===========================================================
     
583. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
584. RMAN-00571: ===========================================================
     
585. RMAN-03032: this option of set command needs to be used outside of a run block
     
586. 
     
587. RMAN> run {
     
588. 2>   set COMPRESSION ALGORITHM 'HIGH';
     
589. 3> backup as compressed backupset  tablespace system ;
     
590. 4> }
     
591. 
     
592. RMAN-00571: ===========================================================
     
593. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
594. RMAN-00571: ===========================================================
     
595. RMAN-03032: this option of set command needs to be used outside of a run block
     
596. 
     
597. RMAN> run {
     
598. 2>  SET COMPRESSION ALGORITHM 'HIGH';
     
599. 3> backup as compressed backupset  tablespace system ;
     
600. 4> }
     
601. 
     
602. RMAN-00571: ===========================================================
     
603. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
604. RMAN-00571: ===========================================================
     
605. RMAN-03032: this option of set command needs to be used outside of a run block
     
606. 
     
607. RMAN> backup as compressed backupset  tablespace system ;
     
608. 
     
609. Starting backup at 13-MAY-17
     
610. allocated channel: ORA_SBT_TAPE_1
     
611. channel ORA_SBT_TAPE_1: SID=15 device type=SBT_TAPE
     
612. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
613. allocated channel: ORA_SBT_TAPE_2
     
614. channel ORA_SBT_TAPE_2: SID=80 device type=SBT_TAPE
     
615. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
616. channel ORA_SBT_TAPE_1: starting compressed full datafile backup set
     
617. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
618. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
     
619. channel ORA_SBT_TAPE_1: starting piece 1 at 13-MAY-17
     
620. channel ORA_SBT_TAPE_1: finished piece 1 at 13-MAY-17
     
621. piece handle=1cs44p3n_1_1 tag=TAG20170513T113311 comment=API Version 2.0,MMS Version 10.4.0.4
     
622. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45
     
623. Finished backup at 13-MAY-17
     
624. 
     
625. Starting Control File and SPFILE Autobackup at 13-MAY-17
     
626. piece handle=c-1343950367-20170513-03 comment=API Version 2.0,MMS Version 10.4.0.4
     
627. Finished Control File and SPFILE Autobackup at 13-MAY-17
     
628. 
     
629. RMAN> show all;
     
630. 
     
631. RMAN configuration parameters for database with db_unique_name ORCL are:
     
632. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
     
633. CONFIGURE BACKUP OPTIMIZATION ON;
     
634. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
     
635. CONFIGURE CONTROLFILE AUTOBACKUP ON;
     
636. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
     
637. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
     
638. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
     
639. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
     
640. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
641. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
642. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
643. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
644. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
645. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
646. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
     
647. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
     
648. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
     
649. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
     
650. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
     
651. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
     
652. 
     
653. RMAN> CONFIGURE ENCRYPTION FOR DATABASE on;
     
654. 
     
655. new RMAN configuration parameters:
     
656. CONFIGURE ENCRYPTION FOR DATABASE ON;
     
657. new RMAN configuration parameters are successfully stored
     
658. 
     
659. RMAN> backup tablespace users;
     
660. 
     
661. Starting backup at 13-MAY-17
     
662. using channel ORA_SBT_TAPE_1
     
663. using channel ORA_SBT_TAPE_2
     
664. channel ORA_SBT_TAPE_1: starting full datafile backup set
     
665. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
666. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
     
667. channel ORA_SBT_TAPE_1: starting piece 1 at 13-MAY-17
     
668. RMAN-00571: ===========================================================
     
669. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
670. RMAN-00571: ===========================================================
     
671. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 05/13/2017 12:01:13
     
672. ORA-19914: unable to encrypt backup
     
673. ORA-28365: wallet is not open
     
674. 
     
675. RMAN> set encrypt on identified by  oracle123;
     
676. 
     
677. RMAN-00571: ===========================================================
     
678. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
679. RMAN-00571: ===========================================================
     
680. RMAN-00558: error encountered while parsing input commands
     
681. RMAN-01009: syntax error: found "identifier": expecting one of: "archivelog, autobackup, auxiliary, auxname, backup, command, compression, controlfile, database, dbid, decryption, echo, encryption, high, incarnation, maxcorrupt, maxseq, newname, nocfau, restore, snapshot, to restore point, until restore point, until"
     
682. RMAN-01008: the bad identifier was: encrypt
     
683. RMAN-01007: at line 1 column 5 file: standard input
     
684. 
     
685. RMAN> set encryption on identified by  oracle123;
     
686. 
     
687. executing command: SET encryption
     
688. 
     
689. RMAN> set encryption on identified by  oracle123  only;
     
690. 
     
691. executing command: SET encryption
     
692. 
     
693. RMAN> backup tablespace users;
     
694. 
     
695. Starting backup at 13-MAY-17
     
696. using channel ORA_SBT_TAPE_1
     
697. using channel ORA_SBT_TAPE_2
     
698. channel ORA_SBT_TAPE_1: starting full datafile backup set
     
699. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
700. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
     
701. channel ORA_SBT_TAPE_1: starting piece 1 at 13-MAY-17
     
702. channel ORA_SBT_TAPE_1: finished piece 1 at 13-MAY-17
     
703. piece handle=1fs44qps_1_1 tag=TAG20170513T120204 comment=API Version 2.0,MMS Version 10.4.0.4
     
704. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
     
705. Finished backup at 13-MAY-17
     
706. 
     
707. Starting Control File and SPFILE Autobackup at 13-MAY-17
     
708. piece handle=c-1343950367-20170513-04 comment=API Version 2.0,MMS Version 10.4.0.4
     
709. Finished Control File and SPFILE Autobackup at 13-MAY-17
     
710. 
     
711. RMAN> set encryption on identified by  oracle123 ;
     
712. 
     
713. executing command: SET encryption
     
714. 
     
715. RMAN> backup tablespace users;
     
716. 
     
717. Starting backup at 13-MAY-17
     
718. using channel ORA_SBT_TAPE_1
     
719. using channel ORA_SBT_TAPE_2
     
720. channel ORA_SBT_TAPE_1: starting full datafile backup set
     
721. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
722. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
     
723. channel ORA_SBT_TAPE_1: starting piece 1 at 13-MAY-17
     
724. RMAN-00571: ===========================================================
     
725. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
726. RMAN-00571: ===========================================================
     
727. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 05/13/2017 12:03:05
     
728. ORA-19914: unable to encrypt backup
     
729. ORA-28365: wallet is not open
     
730. 
     
731. RMAN> exit
     
732. 
     
733. 
     
734. Recovery Manager complete.
     
735. [oracle@station90 ~]$ cd
     
736. [oracle@station90 ~]$ sqlplus /nolog
     
737. 
     
738. SQL*Plus: Release 11.2.0.1.0 Production on Sat May 13 12:04:22 2017
     
739. 
     
740. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
741. 
     
742. SQL> conn / as sysdba
     
743. Connected.
     
744. SQL> select  * from v$encryption_wallet;
     
745. 
     
746. WRL_TYPE
     
747. --------------------
     
748. WRL_PARAMETER
     
749. --------------------------------------------------------------------------------
     
750. STATUS
     
751. ------------------
     
752. file
     
753. /u01/app/oracle/admin/orcl/wallet
     
754. CLOSED
     
755. 
     
756. 
     
757. SQL> alter system set encryption key identified by oracle456;
     
758. 
     
759. System altered.
     
760. 
     
761. SQL> select  * from v$encryption_wallet;
     
762. 
     
763. WRL_TYPE
     
764. --------------------
     
765. WRL_PARAMETER
     
766. --------------------------------------------------------------------------------
     
767. STATUS
     
768. ------------------
     
769. file
     
770. /u01/app/oracle/admin/orcl/wallet
     
771. OPEN
     
772. 
     
773. 
     
774. SQL>
     

复制代码

1. SELECT filename, status, bytes
   
2.     FROM   v$block_change_tracking;
   
3. 
   
4. 
   
5. SELECT file#, avg(datafile_blocks),
   
6.            avg(blocks_read),
   
7.            avg(blocks_read/datafile_blocks)
   
8.                * 100 AS PCT_READ_FOR_BACKUP,
   
9.            avg(blocks)
   
10.    FROM   v$backup_datafile
    
11.    WHERE  used_change_tracking = 'YES'
    
12.    AND    incremental_level > 0
    
13.    and file#=4
    
14.     GROUP  BY file#;
    
15.    
    
16.     select   s.segment_name,s.bytes/1024/1024
    
17.       from dba_segments s
    
18.       where s.owner='HR' and s.segment_name='T_BIG';
    

复制代码