课程第31次（2018-04-16星期一）

botang

1Z0-053
3-28：

创建三个用户：

1. SQL> create user u100 identified by oracle_4U default tablespace RCAT quota unlimited on RCAT   ;
   
2. 
   
3. User created.
   
4. 
   
5. SQL> grant recovery_catalog_owner to u100;
   
6. 
   
7. Grant succeeded.
   
8. 
   
9. SQL> exit
   
10. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
11. With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
12. [oracle@station90 ~]$ exit
    
13. logout
    
14. [root@station90 ~]# su - oracle
    
15. [oracle@station90 ~]$ rman  catalog u100/oracle_4U@rcat
    
16. 
    
17. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 20:51:10 2018
    
18. 
    
19. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
20. 
    
21. connected to recovery catalog database
    
22. 
    
23. RMAN> create catalog;
    
24. 
    
25. recovery catalog created
    
26. 
    
27. RMAN> exit
    
28. 
    
29. 
    
30. Recovery Manager complete.
    
31. [oracle@station90 ~]$ . oraenv
    
32. ORACLE_SID = [orcl] ? rcat
    
33. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
    
34. [oracle@station90 ~]$ sqlplus  /nolog
    
35. 
    
36. SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 18 20:54:05 2018
    
37. 
    
38. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
39. 
    
40. SQL> conn / as sysdba
    
41. Connected.
    
42. SQL> create user v101  identified by oracle_4U default tablespace RCAT quota unlimited on RCAT   ;
    
43. 
    
44. User created.
    
45. 
    
46. SQL> grant recovery_catalog_owner to v101;
    
47. 
    
48. Grant succeeded.
    
49. 
    
50. SQL> create user v102 identified by oracle_4U default tablespace RCAT quota unlimited on RCAT   ;
    
51. 
    
52. User created.
    
53. 
    
54. SQL> grant recovery_catalog_owner to v102;
    
55. 
    
56. Grant succeeded.
    
57. 
    
58. SQL>
    

复制代码

u100去注册两个库：

1. [oracle@station90 ~]$ rman target /  catalog u100/oracle_4U@rcat
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 20:58:30 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1343950367)
   
8. connected to recovery catalog database
   
9. 
   
10. RMAN> register database;
    
11. 
    
12. database registered in recovery catalog
    
13. starting full resync of recovery catalog
    
14. full resync complete
    
15. 
    
16. RMAN> exit
    
17. 
    
18. 
    
19. Recovery Manager complete.
    
20. [oracle@station90 ~]$ rman target sys/oracle_4U@winorcl  catalog u100/oracle_4U@rcat
    
21. 
    
22. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:00:02 2018
    
23. 
    
24. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
25. 
    
26. connected to target database: ORCL (DBID=1347195613)
    
27. connected to recovery catalog database
    
28. 
    
29. RMAN> register database;
    
30. 
    
31. database registered in recovery catalog
    
32. starting full resync of recovery catalog
    
33. RMAN-00571: ===========================================================
    
34. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
35. RMAN-00571: ===========================================================
    
36. RMAN-03008: error while performing automatic resync of recovery catalog
    
37. ORA-06502: PL/SQL: numeric or value error
    
38. 
    
39. RMAN> register database;
    
40. 
    
41. starting full resync of recovery catalog
    
42. RMAN-00571: ===========================================================
    
43. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
44. RMAN-00571: ===========================================================
    
45. RMAN-03002: failure of register command at 04/18/2018 21:00:25
    
46. RMAN-03014: implicit resync of recovery catalog failed
    
47. RMAN-03009: failure of full resync command on default channel at 04/18/2018 21:00:25
    
48. ORA-06502: PL/SQL: numeric or value error
    
49. 
    
50. RMAN> resync catalog;
    
51. 
    
52. starting full resync of recovery catalog
    
53. RMAN-00571: ===========================================================
    
54. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
55. RMAN-00571: ===========================================================
    
56. RMAN-03009: failure of resync command on default channel at 04/18/2018 21:00:37
    
57. ORA-06502: PL/SQL: numeric or value error
    
58. 
    
59. RMAN> exit
    
60. 
    
61. 
    
62. Recovery Manager complete.
    
63. [oracle@station90 ~]$ rman target sys/oracle_4U@utforcl  catalog u100/oracle_4U@rcat
    
64. 
    
65. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:00:57 2018
    
66. 
    
67. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
68. 
    
69. connected to target database: UTFORCL (DBID=454057935)
    
70. connected to recovery catalog database
    
71. 
    
72. RMAN> register database;
    
73. 
    
74. database registered in recovery catalog
    
75. starting full resync of recovery catalog
    
76. full resync complete
    
77. 
    
78. RMAN> exit
    
79. 
    
80. 
    
81. Recovery Manager complete.
    
82. [oracle@station90 ~]$ rman target sys/oracle_4U@winorcl  catalog u100/oracle_4U@rcat
    
83. 
    
84. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:03:11 2018
    
85. 
    
86. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
87. 
    
88. connected to target database: ORCL (DBID=1347195613)
    
89. connected to recovery catalog database
    
90. 
    
91. RMAN> register database;
    
92. 
    
93. starting full resync of recovery catalog
    
94. full resync complete
    
95. RMAN-00571: ===========================================================
    
96. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
97. RMAN-00571: ===========================================================
    
98. RMAN-03009: failure of register command on default channel at 04/18/2018 21:03:20
    
99. RMAN-20002: target database already registered in recovery catalog
    
100. 
     
101. RMAN> exit
     
102. 
     
103. 
     
104. Recovery Manager complete.
     
105. [oracle@station90 ~]$ . oraenv
     
106. ORACLE_SID = [orcl] ? rcat
     
107. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
     
108. [oracle@station90 ~]$ sqlplus /nolog
     
109. 
     
110. SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 18 21:03:37 2018
     
111. 
     
112. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
113. 
     
114. SQL> conn u100/oracle_4U
     
115. Connected.
     
116. SQL> select  * from db;
     
117. 
     
118.     DB_KEY        DB_ID CURR_DBINC_KEY
     
119. ---------- ---------- --------------
     
120.          2 1343950367                   4
     
121.        146 1347195613                 147
     
122.        238  454057935                 239
     
123. 
     
124. SQL> exit
     
125. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
126. With the Partitioning, OLAP, Data Mining and Real Application Testing options
     
127. [oracle@station90 ~]$ rman catalog u100/oracle_4U@rcat
     
128. 
     
129. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:05:12 2018
     
130. 
     
131. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
132. 
     
133. connected to recovery catalog database
     
134. 
     
135. RMAN> grant catalog for database 1343950367 to v101;
     
136. 
     
137. Grant succeeded.
     
138. 
     
139. RMAN> grant catalog for database 1347195613 to v101;
     
140. 
     
141. Grant succeeded.
     
142. 
     
143. RMAN> grant catalog for database 454057935 to v102;
     
144. 
     
145. Grant succeeded.
     
146. 
     
147. RMAN> exit
     
148. 
     
149. 
     
150. Recovery Manager complete.
     
151. [oracle@station90 ~]$ rman catalog v101/oracle_4U@rcat
     
152. 
     
153. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:06:33 2018
     
154. 
     
155. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
156. 
     
157. connected to recovery catalog database
     
158. 
     
159. RMAN> create virtual  catalog;
     
160. 
     
161. found ineligible base catalog owned by U3
     
162. found ineligible base catalog owned by U4
     
163. found ineligible base catalog owned by U6
     
164. found ineligible base catalog owned by U8
     
165. found ineligible base catalog owned by U11
     
166. found ineligible base catalog owned by U13
     
167. found ineligible base catalog owned by U90
     
168. found eligible base catalog owned by U100
     
169. created virtual catalog against base catalog owned by U100
     
170. 
     
171. RMAN> exit
     
172. 
     
173. 
     
174. Recovery Manager complete.
     
175. [oracle@station90 ~]$ rman catalog v102/oracle_4U@rcat
     
176. 
     
177. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:08:22 2018
     
178. 
     
179. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
180. 
     
181. connected to recovery catalog database
     
182. 
     
183. RMAN> create virtual  catalog;
     
184. 
     
185. found ineligible base catalog owned by U3
     
186. found ineligible base catalog owned by U4
     
187. found ineligible base catalog owned by U6
     
188. found ineligible base catalog owned by U8
     
189. found ineligible base catalog owned by U11
     
190. found ineligible base catalog owned by U13
     
191. found ineligible base catalog owned by U90
     
192. found eligible base catalog owned by U100
     
193. created virtual catalog against base catalog owned by U100
     
194. 
     
195. RMAN> exit
     
196. 
     
197. 
     
198. Recovery Manager complete.
     
199. [oracle@station90 ~]$ rman catalog ^C02/oracle_4U@rcat
     
200. [oracle@station90 ~]$
     
201. [oracle@station90 ~]$
     
202. [oracle@station90 ~]$
     
203. [oracle@station90 ~]$ . oraenv
     
204. ORACLE_SID = [rcat] ? orcl
     
205. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
     
206. [oracle@station90 ~]$ rman target /  catalog v101/oracle_4U@rcat
     
207. 
     
208. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:09:36 2018
     
209. 
     
210. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
211. 
     
212. connected to target database: ORCL (DBID=1343950367)
     
213. connected to recovery catalog database
     
214. 
     
215. RMAN> report schema;
     
216. 
     
217. Report of database schema for database with db_unique_name ORCL
     
218. 
     
219. List of Permanent Datafiles
     
220. ===========================
     
221. File Size(MB) Tablespace           RB segs Datafile Name
     
222. ---- -------- -------------------- ------- ------------------------
     
223. 1    700      SYSTEM               YES     +DATA/orcl/datafile/system.256.973682053
     
224. 2    730      SYSAUX               NO      +DATA/orcl/datafile/sysaux.257.973682053
     
225. 3    160      UNDOTBS1             YES     +DATA/orcl/datafile/undotbs1.263.973682055
     
226. 4    7        USERS                NO      +DATA/orcl/datafile/users.261.973682055
     
227. 5    100      EXAMPLE              NO      +DATA/orcl/datafile/example.262.973682055
     
228. 6    5        TBSOCP05_TEST        NO      +DATA/orcl/datafile/tbsocp05_test.268.973703145
     
229. 
     
230. List of Temporary Files
     
231. =======================
     
232. File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
     
233. ---- -------- -------------------- ----------- --------------------
     
234. 1    30       TEMP                 30          +DATA/orcl/tempfile/temp.270.973682389
     
235. 
     
236. RMAN> exit
     
237. 
     
238. 
     
239. Recovery Manager complete.
     
240. [oracle@station90 ~]$ rman target sys/oracle_4U@winorcl  catalog v101/oracle_4U@rcat
     
241. 
     
242. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:10:47 2018
     
243. 
     
244. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
245. 
     
246. connected to target database: ORCL (DBID=1347195613)
     
247. connected to recovery catalog database
     
248. 
     
249. RMAN> list copy;
     
250. 
     
251. specification does not match any control file copy in the repository
     
252. List of Datafile Copies
     
253. =======================
     
254. 
     
255. Key     File S Completion Time Ckp SCN    Ckp Time      
     
256. ------- ---- - --------------- ---------- ---------------
     
257. 327     4    A 18-APR-18       1158425    18-APR-18      
     
258.         Name: C:\DATA\USERS01.DBF
     
259. 
     
260. List of Archived Log Copies for database with db_unique_name ORCL
     
261. =====================================================================
     
262. 
     
263. Key     Thrd Seq     S Low Time
     
264. ------- ---- ------- - ---------
     
265. 321     1    13      A 18-APR-18
     
266.         Name: C:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2018_04_18\O1_MF_1_13_FFGJGVPL_.ARC
     
267. 
     
268. 
     
269. RMAN> exit
     
270. 
     
271. 
     
272. Recovery Manager complete.
     
273. [oracle@station90 ~]$ rman target sys/oracle_4U@utforcl  catalog v101/oracle_4U@rcat
     
274. 
     
275. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:11:20 2018
     
276. 
     
277. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
278. 
     
279. connected to target database: UTFORCL (DBID=454057935)
     
280. connected to recovery catalog database
     
281. 
     
282. RMAN> report schema;
     
283. 
     
284. RMAN-00571: ===========================================================
     
285. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
286. RMAN-00571: ===========================================================
     
287. RMAN-03002: failure of report command at 04/18/2018 21:11:30
     
288. RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog
     
289. 
     
290. RMAN> exit
     
291. 
     
292. 
     
293. Recovery Manager complete.
     
294. [oracle@station90 ~]$ rman target sys/oracle_4U@utforcl  catalog v102/oracle_4U@rcat
     
295. 
     
296. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:11:38 2018
     
297. 
     
298. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
299. 
     
300. connected to target database: UTFORCL (DBID=454057935)
     
301. connected to recovery catalog database
     
302. 
     
303. RMAN> report schema;
     
304. 
     
305. Report of database schema for database with db_unique_name UTFORCL
     
306. 
     
307. List of Permanent Datafiles
     
308. ===========================
     
309. File Size(MB) Tablespace           RB segs Datafile Name
     
310. ---- -------- -------------------- ------- ------------------------
     
311. 1    700      SYSTEM               YES     C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\SYSTEM01.DBF
     
312. 2    540      SYSAUX               NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\SYSAUX01.DBF
     
313. 3    100      UNDOTBS1             YES     C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\UNDOTBS01.DBF
     
314. 4    60       USERS                NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\USERS01.DBF
     
315. 5    100      EXAMPLE              NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\EXAMPLE01.DBF
     
316. 6    5        TBSUTF8_11G          NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\TBSUTF8_11G01.DBF
     
317. 7    40       TBSCAT               NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\TBSCAT.DBF
     
318. 
     
319. List of Temporary Files
     
320. =======================
     
321. File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
     
322. ---- -------- -------------------- ----------- --------------------
     
323. 1    29       TEMP                 32767       C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\TEMP01.DBF
     
324. 
     
325. RMAN>
     
326. 
     
327. 
     
328. 
     
329. 
     
330. 
     

复制代码

另外一种做法：

1. RMAN> exit
   
2. 
   
3. 
   
4. Recovery Manager complete.
   
5. [oracle@station90 ~]$ . oraenv
   
6. ORACLE_SID = [orcl] ? rcat
   
7. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
   
8. [oracle@station90 ~]$ sqlplus /nolog
   
9. 
   
10. SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 18 21:03:37 2018
    
11. 
    
12. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
13. 
    
14. SQL> conn u100/oracle_4U
    
15. Connected.
    
16. SQL> select  * from db;
    
17. 
    
18.     DB_KEY        DB_ID CURR_DBINC_KEY
    
19. ---------- ---------- --------------
    
20.          2 1343950367                   4
    
21.        146 1347195613                 147
    
22.        238  454057935                 239
    
23. 
    
24. SQL> exit
    
25. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
26. With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
27. [oracle@station90 ~]$ rman catalog u100/oracle_4U@rcat
    
28. 
    
29. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:05:12 2018
    
30. 
    
31. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
32. 
    
33. connected to recovery catalog database
    
34. 
    
35. RMAN> grant catalog for database 1343950367 to v101;
    
36. 
    
37. Grant succeeded.
    
38. 
    
39. RMAN> grant catalog for database 1347195613 to v101;
    
40. 
    
41. Grant succeeded.
    
42. 
    
43. RMAN> grant catalog for database 454057935 to v102;
    
44. 
    
45. Grant succeeded.
    
46. 
    
47. RMAN> exit
    
48. 
    
49. 
    
50. Recovery Manager complete.
    
51. [oracle@station90 ~]$ rman catalog v101/oracle_4U@rcat
    
52. 
    
53. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:06:33 2018
    
54. 
    
55. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
56. 
    
57. connected to recovery catalog database
    
58. 
    
59. RMAN> create virtual  catalog;
    
60. 
    
61. found ineligible base catalog owned by U3
    
62. found ineligible base catalog owned by U4
    
63. found ineligible base catalog owned by U6
    
64. found ineligible base catalog owned by U8
    
65. found ineligible base catalog owned by U11
    
66. found ineligible base catalog owned by U13
    
67. found ineligible base catalog owned by U90
    
68. found eligible base catalog owned by U100
    
69. created virtual catalog against base catalog owned by U100
    
70. 
    
71. RMAN> exit
    
72. 
    
73. 
    
74. Recovery Manager complete.
    
75. [oracle@station90 ~]$ rman catalog v102/oracle_4U@rcat
    
76. 
    
77. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:08:22 2018
    
78. 
    
79. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
80. 
    
81. connected to recovery catalog database
    
82. 
    
83. RMAN> create virtual  catalog;
    
84. 
    
85. found ineligible base catalog owned by U3
    
86. found ineligible base catalog owned by U4
    
87. found ineligible base catalog owned by U6
    
88. found ineligible base catalog owned by U8
    
89. found ineligible base catalog owned by U11
    
90. found ineligible base catalog owned by U13
    
91. found ineligible base catalog owned by U90
    
92. found eligible base catalog owned by U100
    
93. created virtual catalog against base catalog owned by U100
    
94. 
    
95. RMAN> exit
    
96. 
    
97. 
    
98. Recovery Manager complete.
    
99. [oracle@station90 ~]$ rman catalog ^C02/oracle_4U@rcat
    
100. [oracle@station90 ~]$
     
101. [oracle@station90 ~]$
     
102. [oracle@station90 ~]$
     
103. [oracle@station90 ~]$ . oraenv
     
104. ORACLE_SID = [rcat] ? orcl
     
105. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
     
106. [oracle@station90 ~]$ rman target /  catalog v101/oracle_4U@rcat
     
107. 
     
108. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:09:36 2018
     
109. 
     
110. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
111. 
     
112. connected to target database: ORCL (DBID=1343950367)
     
113. connected to recovery catalog database
     
114. 
     
115. RMAN> report schema;
     
116. 
     
117. Report of database schema for database with db_unique_name ORCL
     
118. 
     
119. List of Permanent Datafiles
     
120. ===========================
     
121. File Size(MB) Tablespace           RB segs Datafile Name
     
122. ---- -------- -------------------- ------- ------------------------
     
123. 1    700      SYSTEM               YES     +DATA/orcl/datafile/system.256.973682053
     
124. 2    730      SYSAUX               NO      +DATA/orcl/datafile/sysaux.257.973682053
     
125. 3    160      UNDOTBS1             YES     +DATA/orcl/datafile/undotbs1.263.973682055
     
126. 4    7        USERS                NO      +DATA/orcl/datafile/users.261.973682055
     
127. 5    100      EXAMPLE              NO      +DATA/orcl/datafile/example.262.973682055
     
128. 6    5        TBSOCP05_TEST        NO      +DATA/orcl/datafile/tbsocp05_test.268.973703145
     
129. 
     
130. List of Temporary Files
     
131. =======================
     
132. File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
     
133. ---- -------- -------------------- ----------- --------------------
     
134. 1    30       TEMP                 30          +DATA/orcl/tempfile/temp.270.973682389
     
135. 
     
136. RMAN> exit
     
137. 
     
138. 
     
139. Recovery Manager complete.
     
140. [oracle@station90 ~]$ rman target sys/oracle_4U@winorcl  catalog v101/oracle_4U@rcat
     
141. 
     
142. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:10:47 2018
     
143. 
     
144. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
145. 
     
146. connected to target database: ORCL (DBID=1347195613)
     
147. connected to recovery catalog database
     
148. 
     
149. RMAN> list copy;
     
150. 
     
151. specification does not match any control file copy in the repository
     
152. List of Datafile Copies
     
153. =======================
     
154. 
     
155. Key     File S Completion Time Ckp SCN    Ckp Time      
     
156. ------- ---- - --------------- ---------- ---------------
     
157. 327     4    A 18-APR-18       1158425    18-APR-18      
     
158.         Name: C:\DATA\USERS01.DBF
     
159. 
     
160. List of Archived Log Copies for database with db_unique_name ORCL
     
161. =====================================================================
     
162. 
     
163. Key     Thrd Seq     S Low Time
     
164. ------- ---- ------- - ---------
     
165. 321     1    13      A 18-APR-18
     
166.         Name: C:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2018_04_18\O1_MF_1_13_FFGJGVPL_.ARC
     
167. 
     
168. 
     
169. RMAN> exit
     
170. 
     
171. 
     
172. Recovery Manager complete.
     
173. [oracle@station90 ~]$ rman target sys/oracle_4U@utforcl  catalog v101/oracle_4U@rcat
     
174. 
     
175. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:11:20 2018
     
176. 
     
177. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
178. 
     
179. connected to target database: UTFORCL (DBID=454057935)
     
180. connected to recovery catalog database
     
181. 
     
182. RMAN> report schema;
     
183. 
     
184. RMAN-00571: ===========================================================
     
185. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
186. RMAN-00571: ===========================================================
     
187. RMAN-03002: failure of report command at 04/18/2018 21:11:30
     
188. RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog
     
189. 
     
190. RMAN> exit
     
191. 
     
192. 
     
193. Recovery Manager complete.
     
194. [oracle@station90 ~]$ rman target sys/oracle_4U@utforcl  catalog v102/oracle_4U@rcat
     
195. 
     
196. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:11:38 2018
     
197. 
     
198. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
199. 
     
200. connected to target database: UTFORCL (DBID=454057935)
     
201. connected to recovery catalog database
     
202. 
     
203. RMAN> report schema;
     
204. 
     
205. Report of database schema for database with db_unique_name UTFORCL
     
206. 
     
207. List of Permanent Datafiles
     
208. ===========================
     
209. File Size(MB) Tablespace           RB segs Datafile Name
     
210. ---- -------- -------------------- ------- ------------------------
     
211. 1    700      SYSTEM               YES     C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\SYSTEM01.DBF
     
212. 2    540      SYSAUX               NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\SYSAUX01.DBF
     
213. 3    100      UNDOTBS1             YES     C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\UNDOTBS01.DBF
     
214. 4    60       USERS                NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\USERS01.DBF
     
215. 5    100      EXAMPLE              NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\EXAMPLE01.DBF
     
216. 6    5        TBSUTF8_11G          NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\TBSUTF8_11G01.DBF
     
217. 7    40       TBSCAT               NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\TBSCAT.DBF
     
218. 
     
219. List of Temporary Files
     
220. =======================
     
221. File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
     
222. ---- -------- -------------------- ----------- --------------------
     
223. 1    29       TEMP                 32767       C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\TEMP01.DBF
     
224. 
     
225. RMAN> exit
     
226. 
     
227. 
     
228. Recovery Manager complete.
     
229. [oracle@station90 ~]$ . oraenv
     
230. ORACLE_SID = [orcl] ? rcat
     
231. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
     
232. [oracle@station90 ~]$ sqlplus /nolog
     
233. 
     
234. SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 18 21:13:58 2018
     
235. 
     
236. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
237. 
     
238. SQL> conn / as sysdba
     
239. Connected.
     
240. SQL>  create user u200 identified by oracle_4U default tablespace RCAT quota unlimited on RCAT ;
     
241. 
     
242. User created.
     
243. 
     
244. SQL> grant recovery_catalog_owner to u200;
     
245. 
     
246. Grant succeeded.
     
247. 
     
248. SQL> create user v201 identified by oracle_4U default tablespace RCAT quota unlimited on RCAT ;  
     
249. User created.
     
250. 
     
251. SQL> grant recovery_catalog_owner to v201;
     
252. 
     
253. Grant succeeded.
     
254. 
     
255. SQL> create user v202 identified by oracle_4U default tablespace RCAT quota unlimited on RCAT ;
     
256. 
     
257. User created.
     
258. 
     
259. SQL> grant recovery_catalog_owner to v202;
     
260. 
     
261. Grant succeeded.
     
262. 
     
263. SQL> exit
     
264. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
265. With the Partitioning, OLAP, Data Mining and Real Application Testing options
     
266. [oracle@station90 ~]$ rman  caralog u200/oracle_4U@rcat
     
267. 
     
268. Argument     Value          Description
     
269. -----------------------------------------------------------------------------
     
270. target       quoted-string  connect-string for target database
     
271. catalog      quoted-string  connect-string for recovery catalog
     
272. nocatalog    none           if specified, then no recovery catalog
     
273. cmdfile      quoted-string  name of input command file
     
274. log          quoted-string  name of output message log file
     
275. trace        quoted-string  name of output debugging message log file
     
276. append       none           if specified, log is opened in append mode
     
277. debug        optional-args  activate debugging
     
278. msgno        none           show RMAN-nnnn prefix for all messages
     
279. send         quoted-string  send a command to the media manager
     
280. pipe         string         building block for pipe names
     
281. timeout      integer        number of seconds to wait for pipe input
     
282. checksyntax  none           check the command file for syntax errors
     
283. -----------------------------------------------------------------------------
     
284. Both single and double quotes (' or ") are accepted for a quoted-string.
     
285. Quotes are not required unless the string contains embedded white-space.
     
286. 
     
287. RMAN-00571: ===========================================================
     
288. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
289. RMAN-00571: ===========================================================
     
290. RMAN-00552: syntax error in command line arguments
     
291. RMAN-01009: syntax error: found "identifier": expecting one of: "append, auxiliary, catalog, checksyntax, cmdfile, log, msgno, nocatalog, pipe, script, send, target, timeout, using, @, ;"
     
292. RMAN-01008: the bad identifier was: caralog
     
293. RMAN-01007: at line 2 column 1 file: command line arguments
     
294. [oracle@station90 ~]$ rman  catalog u200/oracle_4U@rcat
     
295. 
     
296. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:15:53 2018
     
297. 
     
298. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
299. 
     
300. connected to recovery catalog database
     
301. 
     
302. RMAN> create catalog;
     
303. 
     
304. recovery catalog created
     
305. 
     
306. RMAN> grant register database to v201;
     
307. 
     
308. Grant succeeded.
     
309. 
     
310. RMAN> grant register database to v202;
     
311. 
     
312. Grant succeeded.
     
313. 
     
314. RMAN> exit
     
315. 
     
316. 
     
317. Recovery Manager complete.
     
318. [oracle@station90 ~]$ rman  catalog v201/oracle_4U@rcat
     
319. 
     
320. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:16:57 2018
     
321. 
     
322. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
323. 
     
324. connected to recovery catalog database
     
325. 
     
326. RMAN> create virtual catalog;
     
327. 
     
328. found ineligible base catalog owned by U3
     
329. found ineligible base catalog owned by U4
     
330. found ineligible base catalog owned by U6
     
331. found ineligible base catalog owned by U8
     
332. found ineligible base catalog owned by U11
     
333. found ineligible base catalog owned by U13
     
334. found ineligible base catalog owned by U90
     
335. found ineligible base catalog owned by U100
     
336. found eligible base catalog owned by U200
     
337. created virtual catalog against base catalog owned by U200
     
338. 
     
339. RMAN> exit
     
340. 
     
341. 
     
342. Recovery Manager complete.
     
343. [oracle@station90 ~]$ rman  catalog v202/oracle_4U@rcat
     
344. 
     
345. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:17:10 2018
     
346. 
     
347. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
348. 
     
349. connected to recovery catalog database
     
350. 
     
351. RMAN> create virtual catalog;
     
352. 
     
353. found ineligible base catalog owned by U3
     
354. found ineligible base catalog owned by U4
     
355. found ineligible base catalog owned by U6
     
356. found ineligible base catalog owned by U8
     
357. found ineligible base catalog owned by U11
     
358. found ineligible base catalog owned by U13
     
359. found ineligible base catalog owned by U90
     
360. found ineligible base catalog owned by U100
     
361. found eligible base catalog owned by U200
     
362. created virtual catalog against base catalog owned by U200
     
363. 
     
364. RMAN> exit
     
365. 
     
366. 
     
367. Recovery Manager complete.
     
368. [oracle@station90 ~]$ rman target  sys/oracle_4U@orcl  catalog v201/oracle_4U@rcat
     
369. 
     
370. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:17:55 2018
     
371. 
     
372. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
373. 
     
374. connected to target database: ORCL (DBID=1343950367)
     
375. connected to recovery catalog database
     
376. 
     
377. RMAN> register database;
     
378. 
     
379. database registered in recovery catalog
     
380. starting full resync of recovery catalog
     
381. full resync complete
     
382. 
     
383. RMAN> eixt
     
384. 
     
385. RMAN-00571: ===========================================================
     
386. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
387. RMAN-00571: ===========================================================
     
388. RMAN-00558: error encountered while parsing input commands
     
389. 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, {, "
     
390. RMAN-01008: the bad identifier was: eixt
     
391. RMAN-01007: at line 1 column 1 file: standard input
     
392. 
     
393. RMAN> exit
     
394. 
     
395. 
     
396. Recovery Manager complete.
     
397. [oracle@station90 ~]$ rman target  sys/oracle_4U@winorcl  catalog v201/oracle_4U@rcat
     
398. 
     
399. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:19:07 2018
     
400. 
     
401. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
402. 
     
403. connected to target database: ORCL (DBID=1347195613)
     
404. connected to recovery catalog database
     
405. 
     
406. RMAN> register database;
     
407. 
     
408. database registered in recovery catalog
     
409. starting full resync of recovery catalog
     
410. full resync complete
     
411. 
     
412. RMAN> exit
     
413. 
     
414. 
     
415. Recovery Manager complete.
     
416. [oracle@station90 ~]$ rman target  sys/oracle_4U@utforcl  catalog v202/oracle_4U@rcat
     
417. 
     
418. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:19:25 2018
     
419. 
     
420. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
421. 
     
422. connected to target database: UTFORCL (DBID=454057935)
     
423. connected to recovery catalog database
     
424. 
     
425. RMAN> exit
     
426. 
     
427. 
     
428. Recovery Manager complete.
     
429. [oracle@station90 ~]$ . oraenv
     
430. ORACLE_SID = [rcat] ?
     
431. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
     
432. [oracle@station90 ~]$ sqlplus /nolog
     
433. 
     
434. SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 18 21:19:47 2018
     
435. 
     
436. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
437. 
     
438. SQL> conn u200/oracle_4U@rcat
     
439. Connected.
     
440. SQL> select  * from db;
     
441. 
     
442.     DB_KEY        DB_ID CURR_DBINC_KEY
     
443. ---------- ---------- --------------
     
444.          2 1343950367                   4
     
445.        181 1347195613                 182
     
446. 
     
447. SQL> exit
     
448. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
449. With the Partitioning, OLAP, Data Mining and Real Application Testing options
     
450. [oracle@station90 ~]$ rman target  sys/oracle_4U@utforcl  catalog v202/oracle_4U@rcat
     
451. 
     
452. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 18 21:20:21 2018
     
453. 
     
454. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
455. 
     
456. connected to target database: UTFORCL (DBID=454057935)
     
457. connected to recovery catalog database
     
458. 
     
459. RMAN> register database;
     
460. 
     
461. database registered in recovery catalog
     
462. starting full resync of recovery catalog
     
463. full resync complete
     
464. 
     
465. RMAN> exitg
     
466. 
     
467. RMAN-00571: ===========================================================
     
468. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
469. RMAN-00571: ===========================================================
     
470. RMAN-00558: error encountered while parsing input commands
     
471. 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, {, "
     
472. RMAN-01008: the bad identifier was: exitg
     
473. RMAN-01007: at line 1 column 1 file: standard input
     
474. 
     
475. RMAN> exit
     
476. 
     
477. 
     
478. Recovery Manager complete.
     
479. [oracle@station90 ~]$ sqlplus /nolog
     
480. 
     
481. SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 18 21:20:36 2018
     
482. 
     
483. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
484. 
     
485. SQL> conn u200/oracle_4U@rcat
     
486. Connected.
     
487. SQL> select  * from db;
     
488. 
     
489.     DB_KEY        DB_ID CURR_DBINC_KEY
     
490. ---------- ---------- --------------
     
491.          2 1343950367                   4
     
492.        181 1347195613                 182
     
493.        236  454057935                 237
     
494. 
     
495. SQL>
     
496. 
     

复制代码