课程第31次（2017-05-18星期四）

botang

进行恢复重要章节第IZ0-053的第7章：

脚本实验做了8a/8b、9a/9b、10a/10b
学完课程必需搞清楚只读下线前后哪个控制文件适合用于恢复。知道MISSING000004和UNAME000004的成因和差异:
以station90的出题脚本场景8a/8b：

1. 
   
2. ---------------------------------------------- LAB 8a ----------------------------------------------
   
3.              8a_当前控制文件损坏_不完全恢复_用控制文件二进制备份_数据不丢_不需备份
   
4. ---------------------------------------------- LAB 8a ----------------------------------------------
   
5. 
   
6. 
   
7. ******************
   
8. 你的主机信息如下：
   
9. ******************
   
10. 
    
11. 
    
12. station90.example.com
    
13. 
    
14. Linux station90.example.com 4.8.6-1.el6.elrepo.x86_64 #1 SMP Mon Oct 31 13:01:00 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux
    
15. 
    
16. 
    
17. Name           Type           Target    State     Host        
    
18. ------------------------------------------------------------
    
19. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station90   
    
20. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station90   
    
21. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station90   
    
22. ora.asm        ora.asm.type   ONLINE    ONLINE    station90   
    
23. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station90   
    
24. ora.diskmon    ora....on.type ONLINE    ONLINE    station90   
    
25. ora.orcl.db    ora....se.type ONLINE    ONLINE    station90   
    
26. 
    
27. SQL*Plus: Release 11.2.0.1.0 Production on Thu May 18 19:47:30 2017
    
28. 
    
29. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
30. 
    
31. SQL> Connected.
    
32. SQL> SQL> SQL>
    
33. A
    
34. --------------------
    
35. Botang
    
36. ****************************
    
37. The database open mode here:
    
38. ****************************
    
39. 
    
40. D
    
41. -
    
42. X
    
43. 
    
44. OPEN_MODE
    
45. --------------------
    
46. READ WRITE
    
47. **********************************
    
48. The database archivelog mode here:
    
49. **********************************
    
50. Database log mode               Archive Mode
    
51. Automatic archival               Enabled
    
52. Archive destination               USE_DB_RECOVERY_FILE_DEST
    
53. Oldest online log sequence     20
    
54. Next log sequence to archive   22
    
55. Current log sequence               22
    
56. ***************************
    
57. The database datafile here:
    
58. ***************************
    
59. 
    
60. TABLESPACE_NAME                STATUS
    
61. ------------------------------ ---------------
    
62. SYSTEM                               ONLINE
    
63. SYSAUX                               ONLINE
    
64. UNDOTBS1                       ONLINE
    
65. TEMP                               ONLINE
    
66. USERS                               ONLINE
    
67. EXAMPLE                        ONLINE
    
68. 
    
69. NAME                                                                  STATUS
    
70. ----------------------------------------------------------------- ---------------
    
71. +DATA/orcl/datafile/system.256.816169553                          SYSTEM
    
72. +DATA/orcl/datafile/sysaux.257.816169553                          ONLINE
    
73. +DATA/orcl/datafile/undotbs1.258.816169553                          ONLINE
    
74. +DATA/orcl/datafile/users.259.816169553                           ONLINE
    
75. +DATA/orcl/datafile/example.265.816169651                          ONLINE
    
76. ******************************
    
77. The database controlfile here:
    
78. ******************************
    
79. 
    
80. NAME
    
81. -----------------------------------------------------------------
    
82. +DATA/orcl/controlfile/current.260.816169631
    
83. +FRA/orcl/controlfile/current.256.816169633
    
84. **************************
    
85. The database logfile here:
    
86. **************************
    
87. 
    
88. MEMBER
    
89. --------------------------------------------------------------------------------
    
90. +DATA/orcl/onlinelog/group_3.263.816169641
    
91. +FRA/orcl/onlinelog/group_3.259.816169641
    
92. +DATA/orcl/onlinelog/group_2.262.816169639
    
93. +FRA/orcl/onlinelog/group_2.258.816169639
    
94. +DATA/orcl/onlinelog/group_1.261.816169635
    
95. +FRA/orcl/onlinelog/group_1.257.816169637
    
96. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
97. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    
98. and Real Application Testing options
    
99. 
    
100. 
     
101. SQL*Plus: Release 11.2.0.1.0 Production on Thu May 18 19:47:31 2017
     
102. 
     
103. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
104. 
     
105. SQL> Connected.
     
106. SQL> SQL> SQL>
     
107. A
     
108. --------------------
     
109. Botang
     
110. **************************
     
111. Table successfully created.
     
112. **************************
     
113. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
114. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
115. and Real Application Testing options
     
116. 
     
117. 
     
118. Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 18 19:47:41 2017
     
119. 
     
120. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
121. 
     
122. connected to target database: ORCL (DBID=1343950367)
     
123. 
     
124. RMAN>
     
125. Starting backup at 18-MAY-17
     
126. using target database control file instead of recovery catalog
     
127. RMAN-00571: ===========================================================
     
128. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
129. RMAN-00571: ===========================================================
     
130. RMAN-03002: failure of backup command at 05/18/2017 19:47:49
     
131. ORA-19554: error allocating device, device type: SBT_TAPE, device name:
     
132. ORA-27023: skgfqsbi: media manager protocol error
     
133. ORA-19511: Error received from media manager layer, error text:
     
134.    sbt__rpc_connect: Internal error - could not connect to obproxyd (Oracle Secure Backup error: 'Connection refused').
     
135. 
     
136. RMAN>
     
137. 
     
138. Recovery Manager complete.
     
139. 
     
140. /home/oracle/bclcustom-subprogram: line 295: /u01/app/oracle/product/11.2.0.3/grid/network/admin/tnsnames.ora: 没有那个文件或目录
     
141. /home/oracle/bclcustom-subprogram: line 296: /u01/app/oracle/product/11.2.0.3/grid/network/admin/tnsnames.ora: 没有那个文件或目录
     
142. /home/oracle/bclcustom-subprogram: line 297: /u01/app/oracle/product/11.2.0.3/grid/network/admin/tnsnames.ora: 没有那个文件或目录
     
143. /home/oracle/bclcustom-subprogram: line 298: /u01/app/oracle/product/11.2.0.3/grid/network/admin/tnsnames.ora: 没有那个文件或目录
     
144. /home/oracle/bclcustom-subprogram: line 299: /u01/app/oracle/product/11.2.0.3/grid/network/admin/tnsnames.ora: 没有那个文件或目录
     
145. /home/oracle/bclcustom-subprogram: line 300: /u01/app/oracle/product/11.2.0.3/grid/network/admin/tnsnames.ora: 没有那个文件或目录
     
146. /home/oracle/bclcustom-subprogram: line 301: /u01/app/oracle/product/11.2.0.3/grid/network/admin/tnsnames.ora: 没有那个文件或目录
     
147. /home/oracle/bclcustom-subprogram: line 302: /u01/app/oracle/product/11.2.0.3/grid/network/admin/tnsnames.ora: 没有那个文件或目录
     
148. /home/oracle/bclcustom-subprogram: line 303: /u01/app/oracle/product/11.2.0.3/grid/network/admin/tnsnames.ora: 没有那个文件或目录
     
149. /home/oracle/bclcustom-subprogram: line 304: /u01/app/oracle/product/11.2.0.3/grid/network/admin/tnsnames.ora: 没有那个文件或目录
     
150. /home/oracle/bclcustom-subprogram: line 305: /u01/app/oracle/product/11.2.0.3/grid/network/admin/tnsnames.ora: 没有那个文件或目录
     
151. ***Connecting Catalog***
     
152. 
     
153. Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 18 19:47:49 2017
     
154. 
     
155. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
156. 
     
157. connected to target database: ORCL (DBID=1343950367)
     
158. RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 7 days
     
159. 
     
160. connected to recovery catalog database
     
161. 
     
162. RMAN>
     
163. RMAN-00571: ===========================================================
     
164. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
165. RMAN-00571: ===========================================================
     
166. RMAN-03002: failure of resync command at 05/18/2017 19:47:50
     
167. RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog
     
168. 
     
169. RMAN>
     
170. 
     
171. Recovery Manager complete.
     
172. 
     
173. 
     
174. SQL*Plus: Release 11.2.0.1.0 Production on Thu May 18 19:47:50 2017
     
175. 
     
176. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
177. 
     
178. SQL> Connected.
     
179. SQL> SQL> SQL> ORACLE instance shut down.
     
180. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
181. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
182. and Real Application Testing options
     
183. CRS-2500: Cannot stop resource 'ora.orcl.db' as it is not running
     
184. CRS-4000: Command Stop failed, or completed with errors.
     
185. 
     
186. 
     
187. ASMCMD> ASMCMD> ASMCMD> ASMCMD>  
     
188. 
     
189. SQL*Plus: Release 11.2.0.1.0 Production on Thu May 18 19:48:07 2017
     
190. 
     
191. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
192. 
     
193. SQL> Connected to an idle instance.
     
194. SQL> SQL> SQL> select        * from sys.tname
     
195. *
     
196. ERROR at line 1:
     
197. ORA-01034: ORACLE not available
     
198. Process ID: 0
     
199. Session ID: 0 Serial number: 0
     
200. 
     
201. 
     
202. alter system flush buffer_cache
     
203. *
     
204. ERROR at line 1:
     
205. ORA-01034: ORACLE not available
     
206. Process ID: 0
     
207. Session ID: 0 Serial number: 0
     
208. 
     
209. 
     
210. BEGIN dbms_output.put_line(' '); END;
     
211. 
     
212. *
     
213. ERROR at line 1:
     
214. ORA-01034: ORACLE not available
     
215. Process ID: 0
     
216. Session ID: 0 Serial number: 0
     
217. 
     
218. 
     
219. BEGIN dbms_output.put_line('**************************** '); END;
     
220. 
     
221. *
     
222. ERROR at line 1:
     
223. ORA-01034: ORACLE not available
     
224. Process ID: 0
     
225. Session ID: 0 Serial number: 0
     
226. 
     
227. 
     
228. BEGIN dbms_output.put_line('The destory take place here: '); END;
     
229. 
     
230. *
     
231. ERROR at line 1:
     
232. ORA-01034: ORACLE not available
     
233. Process ID: 0
     
234. Session ID: 0 Serial number: 0
     
235. 
     
236. 
     
237. BEGIN dbms_output.put_line('**************************** '); END;
     
238. 
     
239. *
     
240. ERROR at line 1:
     
241. ORA-01034: ORACLE not available
     
242. Process ID: 0
     
243. Session ID: 0 Serial number: 0
     
244. 
     
245. 
     
246. BEGIN dbms_output.put_line(' '); END;
     
247. 
     
248. *
     
249. ERROR at line 1:
     
250. ORA-01034: ORACLE not available
     
251. Process ID: 0
     
252. Session ID: 0 Serial number: 0
     
253. 
     
254. 
     
255. create table ttestbotang_8a (a number) tablespace users
     
256. *
     
257. ERROR at line 1:
     
258. ORA-01034: ORACLE not available
     
259. Process ID: 0
     
260. Session ID: 0 Serial number: 0
     
261. 
     
262. 
     
263. SQL> Disconnected
     
264. 
     
265. 
     
266. THE END

复制代码

以station90的出题脚本场景9a/9b：

1. 
   
2. ---------------------------------------------- LAB 9a ----------------------------------------------
   
3.              9a_当前控制文件损坏_下线user表空间不完全恢复_用控制文件二进制备份_数据不丢_不需备份
   
4. ---------------------------------------------- LAB 9a ----------------------------------------------
   
5. 
   
6. 
   
7. ******************
   
8. 你的主机信息如下：
   
9. ******************
   
10. 
    
11. 
    
12. station90.example.com
    
13. 
    
14. Linux station90.example.com 4.8.6-1.el6.elrepo.x86_64 #1 SMP Mon Oct 31 13:01:00 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux
    
15. 
    
16. 
    
17. Name           Type           Target    State     Host        
    
18. ------------------------------------------------------------
    
19. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station90   
    
20. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station90   
    
21. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station90   
    
22. ora.asm        ora.asm.type   ONLINE    ONLINE    station90   
    
23. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station90   
    
24. ora.diskmon    ora....on.type ONLINE    ONLINE    station90   
    
25. ora.orcl.db    ora....se.type ONLINE    ONLINE    station90   
    
26. 
    
27. SQL*Plus: Release 11.2.0.1.0 Production on Thu May 18 20:54:04 2017
    
28. 
    
29. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
30. 
    
31. SQL> Connected.
    
32. SQL> SQL> SQL>
    
33. A
    
34. --------------------
    
35. Botang
    
36. ****************************
    
37. The database open mode here:
    
38. ****************************
    
39. 
    
40. D
    
41. -
    
42. X
    
43. 
    
44. OPEN_MODE
    
45. --------------------
    
46. READ WRITE
    
47. **********************************
    
48. The database archivelog mode here:
    
49. **********************************
    
50. Database log mode               Archive Mode
    
51. Automatic archival               Enabled
    
52. Archive destination               USE_DB_RECOVERY_FILE_DEST
    
53. Oldest online log sequence     27
    
54. Next log sequence to archive   29
    
55. Current log sequence               29
    
56. ***************************
    
57. The database datafile here:
    
58. ***************************
    
59. 
    
60. TABLESPACE_NAME                STATUS
    
61. ------------------------------ ---------------
    
62. SYSTEM                               ONLINE
    
63. SYSAUX                               ONLINE
    
64. UNDOTBS1                       ONLINE
    
65. TEMP                               ONLINE
    
66. USERS                               ONLINE
    
67. EXAMPLE                        ONLINE
    
68. 
    
69. NAME                                                                  STATUS
    
70. ----------------------------------------------------------------- ---------------
    
71. +DATA/orcl/datafile/system.256.816169553                          SYSTEM
    
72. +DATA/orcl/datafile/sysaux.257.816169553                          ONLINE
    
73. +DATA/orcl/datafile/undotbs1.258.816169553                          ONLINE
    
74. +DATA/orcl/datafile/users.259.816169553                           ONLINE
    
75. +DATA/orcl/datafile/example.265.816169651                          ONLINE
    
76. ******************************
    
77. The database controlfile here:
    
78. ******************************
    
79. 
    
80. NAME
    
81. -----------------------------------------------------------------
    
82. +DATA/orcl/controlfile/current.260.944339369
    
83. +FRA/orcl/controlfile/current.256.944339369
    
84. **************************
    
85. The database logfile here:
    
86. **************************
    
87. 
    
88. MEMBER
    
89. --------------------------------------------------------------------------------
    
90. +DATA/orcl/onlinelog/group_1.261.816169635
    
91. +FRA/orcl/onlinelog/group_1.257.816169637
    
92. +DATA/orcl/onlinelog/group_3.263.816169641
    
93. +FRA/orcl/onlinelog/group_3.259.816169641
    
94. +DATA/orcl/onlinelog/group_2.262.816169639
    
95. +FRA/orcl/onlinelog/group_2.258.816169639
    
96. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
97. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    
98. and Real Application Testing options
    
99. 
    
100. 
     
101. SQL*Plus: Release 11.2.0.1.0 Production on Thu May 18 20:54:04 2017
     
102. 
     
103. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
104. 
     
105. SQL> Connected.
     
106. SQL> SQL> SQL>
     
107. A
     
108. --------------------
     
109. Botang
     
110. **************************
     
111. Table successfully created.
     
112. **************************
     
113. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
114. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
115. and Real Application Testing options
     
116. 
     
117. 
     
118. Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 18 20:54:12 2017
     
119. 
     
120. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
121. 
     
122. connected to target database: ORCL (DBID=1343950367)
     
123. 
     
124. RMAN>
     
125. Starting backup at 18-MAY-17
     
126. using target database control file instead of recovery catalog
     
127. allocated channel: ORA_SBT_TAPE_1
     
128. channel ORA_SBT_TAPE_1: SID=68 device type=SBT_TAPE
     
129. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
130. allocated channel: ORA_SBT_TAPE_2
     
131. channel ORA_SBT_TAPE_2: SID=75 device type=SBT_TAPE
     
132. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
133. channel ORA_SBT_TAPE_1: starting full datafile backup set
     
134. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
135. including current control file in backup set
     
136. channel ORA_SBT_TAPE_1: starting piece 1 at 18-MAY-17
     
137. RMAN-00571: ===========================================================
     
138. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
139. RMAN-00571: ===========================================================
     
140. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 05/18/2017 20:54:26
     
141. ORA-19914: unable to encrypt backup
     
142. ORA-28365: wallet is not open
     
143. 
     
144. RMAN>
     
145. 
     
146. Recovery Manager complete.
     
147. 
     
148. 
     
149. SQL*Plus: Release 11.2.0.1.0 Production on Thu May 18 20:54:27 2017
     
150. 
     
151. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
152. 
     
153. SQL> Connected.
     
154. SQL>
     
155. Tablespace altered.
     
156. 
     
157. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
158. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
159. and Real Application Testing options
     
160. 
     
161. 
     
162. Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 18 20:54:27 2017
     
163. 
     
164. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
165. 
     
166. connected to target database: ORCL (DBID=1343950367)
     
167. 
     
168. RMAN>
     
169. Starting backup at 18-MAY-17
     
170. using target database control file instead of recovery catalog
     
171. allocated channel: ORA_SBT_TAPE_1
     
172. channel ORA_SBT_TAPE_1: SID=76 device type=SBT_TAPE
     
173. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
174. allocated channel: ORA_SBT_TAPE_2
     
175. channel ORA_SBT_TAPE_2: SID=75 device type=SBT_TAPE
     
176. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
177. channel ORA_SBT_TAPE_1: starting full datafile backup set
     
178. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
179. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
     
180. channel ORA_SBT_TAPE_1: starting piece 1 at 18-MAY-17
     
181. RMAN-00571: ===========================================================
     
182. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
183. RMAN-00571: ===========================================================
     
184. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 05/18/2017 20:54:40
     
185. ORA-19914: unable to encrypt backup
     
186. ORA-28365: wallet is not open
     
187. 
     
188. RMAN>
     
189. 
     
190. Recovery Manager complete.
     
191. 
     
192. 
     
193. Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 18 20:54:40 2017
     
194. 
     
195. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
196. 
     
197. connected to target database: ORCL (DBID=1343950367)
     
198. 
     
199. RMAN>
     
200. Starting backup at 18-MAY-17
     
201. using target database control file instead of recovery catalog
     
202. allocated channel: ORA_SBT_TAPE_1
     
203. channel ORA_SBT_TAPE_1: SID=68 device type=SBT_TAPE
     
204. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
205. allocated channel: ORA_SBT_TAPE_2
     
206. channel ORA_SBT_TAPE_2: SID=75 device type=SBT_TAPE
     
207. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
208. channel ORA_SBT_TAPE_1: starting full datafile backup set
     
209. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
210. including current control file in backup set
     
211. channel ORA_SBT_TAPE_1: starting piece 1 at 18-MAY-17
     
212. RMAN-00571: ===========================================================
     
213. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
214. RMAN-00571: ===========================================================
     
215. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 05/18/2017 20:54:54
     
216. ORA-19914: unable to encrypt backup
     
217. ORA-28365: wallet is not open
     
218. 
     
219. RMAN>
     
220. 
     
221. Recovery Manager complete.
     
222. 
     
223. #LABS ADD
     
224. ***Connecting Catalog***
     
225. 
     
226. Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 18 20:54:54 2017
     
227. 
     
228. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
229. 
     
230. connected to target database: ORCL (DBID=1343950367)
     
231. RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 7 days
     
232. 
     
233. connected to recovery catalog database
     
234. 
     
235. RMAN>
     
236. starting full resync of recovery catalog
     
237. full resync complete
     
238. 
     
239. RMAN>
     
240. 
     
241. Recovery Manager complete.
     
242. 
     
243. 
     
244. SQL*Plus: Release 11.2.0.1.0 Production on Thu May 18 20:54:57 2017
     
245. 
     
246. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
247. 
     
248. SQL> Connected.
     
249. SQL> SQL> SQL> ORACLE instance shut down.
     
250. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
251. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
252. and Real Application Testing options
     
253. CRS-2500: Cannot stop resource 'ora.orcl.db' as it is not running
     
254. CRS-4000: Command Stop failed, or completed with errors.
     
255. 
     
256. 
     
257. ASMCMD> ASMCMD> ASMCMD> ASMCMD>  
     
258. 
     
259. SQL*Plus: Release 11.2.0.1.0 Production on Thu May 18 20:55:14 2017
     
260. 
     
261. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
262. 
     
263. SQL> Connected to an idle instance.
     
264. SQL> SQL> SQL> select        * from sys.tname
     
265. *
     
266. ERROR at line 1:
     
267. ORA-01034: ORACLE not available
     
268. Process ID: 0
     
269. Session ID: 0 Serial number: 0
     
270. 
     
271. 
     
272. alter system flush buffer_cache
     
273. *
     
274. ERROR at line 1:
     
275. ORA-01034: ORACLE not available
     
276. Process ID: 0
     
277. Session ID: 0 Serial number: 0
     
278. 
     
279. 
     
280. BEGIN dbms_output.put_line(' '); END;
     
281. 
     
282. *
     
283. ERROR at line 1:
     
284. ORA-01034: ORACLE not available
     
285. Process ID: 0
     
286. Session ID: 0 Serial number: 0
     
287. 
     
288. 
     
289. BEGIN dbms_output.put_line('**************************** '); END;
     
290. 
     
291. *
     
292. ERROR at line 1:
     
293. ORA-01034: ORACLE not available
     
294. Process ID: 0
     
295. Session ID: 0 Serial number: 0
     
296. 
     
297. 
     
298. BEGIN dbms_output.put_line('The destory take place here: '); END;
     
299. 
     
300. *
     
301. ERROR at line 1:
     
302. ORA-01034: ORACLE not available
     
303. Process ID: 0
     
304. Session ID: 0 Serial number: 0
     
305. 
     
306. 
     
307. BEGIN dbms_output.put_line('**************************** '); END;
     
308. 
     
309. *
     
310. ERROR at line 1:
     
311. ORA-01034: ORACLE not available
     
312. Process ID: 0
     
313. Session ID: 0 Serial number: 0
     
314. 
     
315. 
     
316. BEGIN dbms_output.put_line(' '); END;
     
317. 
     
318. *
     
319. ERROR at line 1:
     
320. ORA-01034: ORACLE not available
     
321. Process ID: 0
     
322. Session ID: 0 Serial number: 0
     
323. 
     
324. 
     
325. create table ttestbotang_9a (a number) tablespace users
     
326. *
     
327. ERROR at line 1:
     
328. ORA-01034: ORACLE not available
     
329. Process ID: 0
     
330. Session ID: 0 Serial number: 0
     
331. 
     
332. SQL> Disconnected
     
333. 
     
334. 
     
335. THE END

复制代码

以station90的出题脚本场景10a/10b：

1. 
   
2. ---------------------------------------------- LAB 10a ----------------------------------------------
   
3.              10a_当前控制文件损坏_备份时下线user表空间不完全恢复_用控制文件二进制备份_数据不丢_不需备份
   
4. ---------------------------------------------- LAB 10a ----------------------------------------------
   
5. 
   
6. 
   
7. ******************
   
8. 你的主机信息如下：
   
9. ******************
   
10. 
    
11. 
    
12. station90.example.com
    
13. 
    
14. Linux station90.example.com 4.8.6-1.el6.elrepo.x86_64 #1 SMP Mon Oct 31 13:01:00 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux
    
15. 
    
16. 
    
17. Name           Type           Target    State     Host        
    
18. ------------------------------------------------------------
    
19. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station90   
    
20. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station90   
    
21. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station90   
    
22. ora.asm        ora.asm.type   ONLINE    ONLINE    station90   
    
23. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station90   
    
24. ora.diskmon    ora....on.type ONLINE    ONLINE    station90   
    
25. ora.orcl.db    ora....se.type ONLINE    ONLINE    station90   
    
26. 
    
27. SQL*Plus: Release 11.2.0.1.0 Production on Thu May 18 21:12:20 2017
    
28. 
    
29. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
30. 
    
31. SQL> Connected.
    
32. SQL> SQL> SQL>
    
33. A
    
34. --------------------
    
35. Botang
    
36. ****************************
    
37. The database open mode here:
    
38. ****************************
    
39. 
    
40. D
    
41. -
    
42. X
    
43. 
    
44. OPEN_MODE
    
45. --------------------
    
46. READ WRITE
    
47. **********************************
    
48. The database archivelog mode here:
    
49. **********************************
    
50. Database log mode               Archive Mode
    
51. Automatic archival               Enabled
    
52. Archive destination               USE_DB_RECOVERY_FILE_DEST
    
53. Oldest online log sequence     34
    
54. Next log sequence to archive   36
    
55. Current log sequence               36
    
56. ***************************
    
57. The database datafile here:
    
58. ***************************
    
59. 
    
60. TABLESPACE_NAME                STATUS
    
61. ------------------------------ ---------------
    
62. SYSTEM                               ONLINE
    
63. SYSAUX                               ONLINE
    
64. UNDOTBS1                       ONLINE
    
65. TEMP                               ONLINE
    
66. USERS                               ONLINE
    
67. EXAMPLE                        ONLINE
    
68. 
    
69. NAME                                                                  STATUS
    
70. ----------------------------------------------------------------- ---------------
    
71. +DATA/orcl/datafile/system.256.816169553                          SYSTEM
    
72. +DATA/orcl/datafile/sysaux.257.816169553                          ONLINE
    
73. +DATA/orcl/datafile/undotbs1.258.816169553                          ONLINE
    
74. +DATA/orcl/datafile/users.259.816169553                           ONLINE
    
75. +DATA/orcl/datafile/example.265.816169651                          ONLINE
    
76. ******************************
    
77. The database controlfile here:
    
78. ******************************
    
79. 
    
80. NAME
    
81. -----------------------------------------------------------------
    
82. +DATA/orcl/controlfile/current.260.944341449
    
83. +FRA/orcl/controlfile/current.256.944341449
    
84. **************************
    
85. The database logfile here:
    
86. **************************
    
87. 
    
88. MEMBER
    
89. --------------------------------------------------------------------------------
    
90. +DATA/orcl/onlinelog/group_2.262.816169639
    
91. +FRA/orcl/onlinelog/group_2.258.816169639
    
92. +DATA/orcl/onlinelog/group_1.261.816169635
    
93. +FRA/orcl/onlinelog/group_1.257.816169637
    
94. +DATA/orcl/onlinelog/group_3.263.816169641
    
95. +FRA/orcl/onlinelog/group_3.259.816169641
    
96. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
97. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    
98. and Real Application Testing options
    
99. 
    
100. ***DELETE THE EARLY ONLINE BACKUP OF USERS***
     
101. ***DELETE THE EARLY READ WRITE BACKUP OF USERS***
     
102. 
     
103. Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 18 21:12:20 2017
     
104. 
     
105. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
106. 
     
107. connected to target database: ORCL (DBID=1343950367)
     
108. 
     
109. RMAN>
     
110. using target database control file instead of recovery catalog
     
111. allocated channel: ORA_DISK_1
     
112. channel ORA_DISK_1: SID=138 device type=DISK
     
113. allocated channel: ORA_DISK_2
     
114. channel ORA_DISK_2: SID=196 device type=DISK
     
115. allocated channel: ORA_DISK_3
     
116. channel ORA_DISK_3: SID=139 device type=DISK
     
117. allocated channel: ORA_DISK_4
     
118. channel ORA_DISK_4: SID=76 device type=DISK
     
119. allocated channel: ORA_DISK_5
     
120. channel ORA_DISK_5: SID=140 device type=DISK
     
121. allocated channel: ORA_DISK_6
     
122. channel ORA_DISK_6: SID=198 device type=DISK
     
123. allocated channel: ORA_DISK_7
     
124. channel ORA_DISK_7: SID=16 device type=DISK
     
125. allocated channel: ORA_DISK_8
     
126. channel ORA_DISK_8: SID=77 device type=DISK
     
127. specification does not match any backup in the repository
     
128. 
     
129. RMAN>
     
130. released channel: ORA_DISK_1
     
131. released channel: ORA_DISK_2
     
132. released channel: ORA_DISK_3
     
133. released channel: ORA_DISK_4
     
134. released channel: ORA_DISK_5
     
135. released channel: ORA_DISK_6
     
136. released channel: ORA_DISK_7
     
137. released channel: ORA_DISK_8
     
138. allocated channel: ORA_DISK_1
     
139. channel ORA_DISK_1: SID=138 device type=DISK
     
140. allocated channel: ORA_DISK_2
     
141. channel ORA_DISK_2: SID=196 device type=DISK
     
142. allocated channel: ORA_DISK_3
     
143. channel ORA_DISK_3: SID=139 device type=DISK
     
144. allocated channel: ORA_DISK_4
     
145. channel ORA_DISK_4: SID=76 device type=DISK
     
146. allocated channel: ORA_DISK_5
     
147. channel ORA_DISK_5: SID=140 device type=DISK
     
148. allocated channel: ORA_DISK_6
     
149. channel ORA_DISK_6: SID=198 device type=DISK
     
150. allocated channel: ORA_DISK_7
     
151. channel ORA_DISK_7: SID=16 device type=DISK
     
152. allocated channel: ORA_DISK_8
     
153. channel ORA_DISK_8: SID=77 device type=DISK
     
154. specification does not match any datafile copy in the repository
     
155. 
     
156. RMAN>
     
157. 
     
158. Recovery Manager complete.
     
159. 
     
160. Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 18 21:12:24 2017
     
161. 
     
162. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
163. 
     
164. connected to target database: ORCL (DBID=1343950367)
     
165. 
     
166. RMAN>
     
167. using target database control file instead of recovery catalog
     
168. allocated channel: ORA_DISK_1
     
169. channel ORA_DISK_1: SID=138 device type=DISK
     
170. allocated channel: ORA_DISK_2
     
171. channel ORA_DISK_2: SID=196 device type=DISK
     
172. allocated channel: ORA_DISK_3
     
173. channel ORA_DISK_3: SID=139 device type=DISK
     
174. allocated channel: ORA_DISK_4
     
175. channel ORA_DISK_4: SID=77 device type=DISK
     
176. allocated channel: ORA_DISK_5
     
177. channel ORA_DISK_5: SID=140 device type=DISK
     
178. allocated channel: ORA_DISK_6
     
179. channel ORA_DISK_6: SID=198 device type=DISK
     
180. allocated channel: ORA_DISK_7
     
181. channel ORA_DISK_7: SID=15 device type=DISK
     
182. allocated channel: ORA_DISK_8
     
183. channel ORA_DISK_8: SID=75 device type=DISK
     
184. specification does not match any backup in the repository
     
185. 
     
186. RMAN>
     
187. released channel: ORA_DISK_1
     
188. released channel: ORA_DISK_2
     
189. released channel: ORA_DISK_3
     
190. released channel: ORA_DISK_4
     
191. released channel: ORA_DISK_5
     
192. released channel: ORA_DISK_6
     
193. released channel: ORA_DISK_7
     
194. released channel: ORA_DISK_8
     
195. allocated channel: ORA_DISK_1
     
196. channel ORA_DISK_1: SID=138 device type=DISK
     
197. allocated channel: ORA_DISK_2
     
198. channel ORA_DISK_2: SID=196 device type=DISK
     
199. allocated channel: ORA_DISK_3
     
200. channel ORA_DISK_3: SID=139 device type=DISK
     
201. allocated channel: ORA_DISK_4
     
202. channel ORA_DISK_4: SID=77 device type=DISK
     
203. allocated channel: ORA_DISK_5
     
204. channel ORA_DISK_5: SID=140 device type=DISK
     
205. allocated channel: ORA_DISK_6
     
206. channel ORA_DISK_6: SID=198 device type=DISK
     
207. allocated channel: ORA_DISK_7
     
208. channel ORA_DISK_7: SID=15 device type=DISK
     
209. allocated channel: ORA_DISK_8
     
210. channel ORA_DISK_8: SID=75 device type=DISK
     
211. specification does not match any control file copy in the repository
     
212. 
     
213. RMAN>
     
214. 
     
215. Recovery Manager complete.
     
216. 
     
217. 
     
218. ***LABS TOTALLY DIFFERENT BEGINS: TABLESPACE OFFLINE***
     
219. ***BEFORE TABLESPACE ONLINE***
     
220. ***BACKUP***
     
221. 
     
222. SQL*Plus: Release 11.2.0.1.0 Production on Thu May 18 21:12:28 2017
     
223. 
     
224. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
225. 
     
226. SQL> Connected.
     
227. SQL>
     
228. Tablespace altered.
     
229. 
     
230. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
231. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
232. and Real Application Testing options
     
233. 
     
234. 
     
235. Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 18 21:12:28 2017
     
236. 
     
237. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
238. 
     
239. connected to target database: ORCL (DBID=1343950367)
     
240. 
     
241. RMAN>
     
242. Starting backup at 18-MAY-17
     
243. using target database control file instead of recovery catalog
     
244. allocated channel: ORA_SBT_TAPE_1
     
245. channel ORA_SBT_TAPE_1: SID=196 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=140 device type=SBT_TAPE
     
249. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
250. channel ORA_SBT_TAPE_1: starting full datafile backup set
     
251. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
252. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
     
253. channel ORA_SBT_TAPE_1: starting piece 1 at 18-MAY-17
     
254. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 05/18/2017 21:12:43
     
255. ORA-19506: failed to create sequential file, name="01s4j0u8_1_1", parms=""
     
256. ORA-27028: skgfqcre: sbtbackup returned error
     
257. ORA-19511: Error received from media manager layer, error text:
     
258.    sbt__rpc_createjob: could not find media family 'station2'.
     
259. channel ORA_SBT_TAPE_1 disabled, job failed on it will be run on another channel
     
260. channel ORA_SBT_TAPE_2: starting full datafile backup set
     
261. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
262. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
     
263. channel ORA_SBT_TAPE_2: starting piece 1 at 18-MAY-17
     
264. RMAN-00571: ===========================================================
     
265. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
266. RMAN-00571: ===========================================================
     
267. RMAN-03009: failure of backup command on ORA_SBT_TAPE_2 channel at 05/18/2017 21:12:46
     
268. ORA-19506: failed to create sequential file, name="02s4j0ub_1_1", parms=""
     
269. ORA-27028: skgfqcre: sbtbackup returned error
     
270. ORA-19511: Error received from media manager layer, error text:
     
271.    sbt__rpc_createjob: could not find media family 'station2'.
     
272. 
     
273. RMAN>
     
274. 
     
275. Recovery Manager complete.
     
276. 
     
277. 
     
278. Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 18 21:12:46 2017
     
279. 
     
280. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
281. 
     
282. connected to target database: ORCL (DBID=1343950367)
     
283. 
     
284. RMAN>
     
285. Starting backup at 18-MAY-17
     
286. using target database control file instead of recovery catalog
     
287. allocated channel: ORA_SBT_TAPE_1
     
288. channel ORA_SBT_TAPE_1: SID=16 device type=SBT_TAPE
     
289. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
290. allocated channel: ORA_SBT_TAPE_2
     
291. channel ORA_SBT_TAPE_2: SID=196 device type=SBT_TAPE
     
292. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
293. channel ORA_SBT_TAPE_1: starting full datafile backup set
     
294. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
295. including current control file in backup set
     
296. channel ORA_SBT_TAPE_1: starting piece 1 at 18-MAY-17
     
297. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 05/18/2017 21:13:02
     
298. ORA-19506: failed to create sequential file, name="03s4j0uq_1_1", parms=""
     
299. ORA-27028: skgfqcre: sbtbackup returned error
     
300. ORA-19511: Error received from media manager layer, error text:
     
301.    sbt__rpc_createjob: could not find media family 'station2'.
     
302. channel ORA_SBT_TAPE_1 disabled, job failed on it will be run on another channel
     
303. channel ORA_SBT_TAPE_2: starting full datafile backup set
     
304. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
305. including current control file in backup set
     
306. channel ORA_SBT_TAPE_2: starting piece 1 at 18-MAY-17
     
307. RMAN-00571: ===========================================================
     
308. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
309. RMAN-00571: ===========================================================
     
310. RMAN-03009: failure of backup command on ORA_SBT_TAPE_2 channel at 05/18/2017 21:13:06
     
311. ORA-19506: failed to create sequential file, name="04s4j0uu_1_1", parms=""
     
312. ORA-27028: skgfqcre: sbtbackup returned error
     
313. ORA-19511: Error received from media manager layer, error text:
     
314.    sbt__rpc_createjob: could not find media family 'station2'.
     
315. 
     
316. RMAN>
     
317. 
     
318. Recovery Manager complete.
     
319. 
     
320. ***FROM THEN ON: ONLINE***
     
321. 
     
322. SQL*Plus: Release 11.2.0.1.0 Production on Thu May 18 21:13:06 2017
     
323. 
     
324. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
325. 
     
326. SQL> Connected.
     
327. SQL>
     
328. Tablespace altered.
     
329. 
     
330. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
331. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
332. and Real Application Testing options
     
333. 
     
334. ***AFTER TABLESPACE ONLINE***
     
335. ***BACKUP AGAIN***
     
336. 
     
337. Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 18 21:13:07 2017
     
338. 
     
339. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
340. 
     
341. connected to target database: ORCL (DBID=1343950367)
     
342. 
     
343. RMAN>
     
344. Starting backup at 18-MAY-17
     
345. using target database control file instead of recovery catalog
     
346. allocated channel: ORA_SBT_TAPE_1
     
347. channel ORA_SBT_TAPE_1: SID=140 device type=SBT_TAPE
     
348. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
349. allocated channel: ORA_SBT_TAPE_2
     
350. channel ORA_SBT_TAPE_2: SID=196 device type=SBT_TAPE
     
351. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
352. channel ORA_SBT_TAPE_1: starting full datafile backup set
     
353. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
354. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
     
355. channel ORA_SBT_TAPE_1: starting piece 1 at 18-MAY-17
     
356. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 05/18/2017 21:13:21
     
357. ORA-19506: failed to create sequential file, name="05s4j0ve_1_1", parms=""
     
358. ORA-27028: skgfqcre: sbtbackup returned error
     
359. ORA-19511: Error received from media manager layer, error text:
     
360.    sbt__rpc_createjob: could not find media family 'station2'.
     
361. channel ORA_SBT_TAPE_1 disabled, job failed on it will be run on another channel
     
362. channel ORA_SBT_TAPE_2: starting full datafile backup set
     
363. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
364. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
     
365. channel ORA_SBT_TAPE_2: starting piece 1 at 18-MAY-17
     
366. RMAN-00571: ===========================================================
     
367. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
368. RMAN-00571: ===========================================================
     
369. RMAN-03009: failure of backup command on ORA_SBT_TAPE_2 channel at 05/18/2017 21:13:25
     
370. ORA-19506: failed to create sequential file, name="06s4j0vi_1_1", parms=""
     
371. ORA-27028: skgfqcre: sbtbackup returned error
     
372. ORA-19511: Error received from media manager layer, error text:
     
373.    sbt__rpc_createjob: could not find media family 'station2'.
     
374. 
     
375. RMAN>
     
376. 
     
377. Recovery Manager complete.
     
378. 
     
379. 
     
380. Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 18 21:13:25 2017
     
381. 
     
382. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
383. 
     
384. connected to target database: ORCL (DBID=1343950367)
     
385. 
     
386. RMAN>
     
387. Starting backup at 18-MAY-17
     
388. using target database control file instead of recovery catalog
     
389. allocated channel: ORA_SBT_TAPE_1
     
390. channel ORA_SBT_TAPE_1: SID=130 device type=SBT_TAPE
     
391. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
392. allocated channel: ORA_SBT_TAPE_2
     
393. channel ORA_SBT_TAPE_2: SID=196 device type=SBT_TAPE
     
394. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
395. channel ORA_SBT_TAPE_1: starting full datafile backup set
     
396. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
397. including current control file in backup set
     
398. channel ORA_SBT_TAPE_1: starting piece 1 at 18-MAY-17
     
399. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 05/18/2017 21:13:41
     
400. ORA-19506: failed to create sequential file, name="07s4j101_1_1", parms=""
     
401. ORA-27028: skgfqcre: sbtbackup returned error
     
402. ORA-19511: Error received from media manager layer, error text:
     
403.    sbt__rpc_createjob: could not find media family 'station2'.
     
404. channel ORA_SBT_TAPE_1 disabled, job failed on it will be run on another channel
     
405. channel ORA_SBT_TAPE_2: starting full datafile backup set
     
406. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
407. including current control file in backup set
     
408. channel ORA_SBT_TAPE_2: starting piece 1 at 18-MAY-17
     
409. RMAN-00571: ===========================================================
     
410. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
411. RMAN-00571: ===========================================================
     
412. RMAN-03009: failure of backup command on ORA_SBT_TAPE_2 channel at 05/18/2017 21:13:45
     
413. ORA-19506: failed to create sequential file, name="08s4j105_1_1", parms=""
     
414. ORA-27028: skgfqcre: sbtbackup returned error
     
415. ORA-19511: Error received from media manager layer, error text:
     
416.    sbt__rpc_createjob: could not find media family 'station2'.
     
417. 
     
418. RMAN>
     
419. 
     
420. Recovery Manager complete.
     
421. 
     
422. #LABS ADD
     
423. ***Connecting Catalog***
     
424. 
     
425. Recovery Manager: Release 11.2.0.1.0 - Production on Thu May 18 21:13:45 2017
     
426. 
     
427. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
428. 
     
429. connected to target database: ORCL (DBID=1343950367)
     
430. RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 7 days
     
431. 
     
432. connected to recovery catalog database
     
433. 
     
434. RMAN>
     
435. starting full resync of recovery catalog
     
436. full resync complete
     
437. 
     
438. RMAN>
     
439. 
     
440. Recovery Manager complete.
     
441. 
     
442. 
     
443. SQL*Plus: Release 11.2.0.1.0 Production on Thu May 18 21:13:48 2017
     
444. 
     
445. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
446. 
     
447. SQL> Connected.
     
448. SQL> SQL> SQL>
     
449. A
     
450. --------------------
     
451. Botang
     
452. **************************
     
453. Table successfully created.
     
454. **************************
     
455. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
456. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
457. and Real Application Testing options
     
458. 
     
459. 
     
460. SQL*Plus: Release 11.2.0.1.0 Production on Thu May 18 21:13:56 2017
     
461. 
     
462. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
463. 
     
464. SQL> Connected.
     
465. SQL> SQL> SQL> ORACLE instance shut down.
     
466. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
467. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
468. and Real Application Testing options
     
469. CRS-2500: Cannot stop resource 'ora.orcl.db' as it is not running
     
470. CRS-4000: Command Stop failed, or completed with errors.
     
471. 
     
472. 
     
473. ASMCMD> ASMCMD> ASMCMD> ASMCMD>  
     
474. 
     
475. SQL*Plus: Release 11.2.0.1.0 Production on Thu May 18 21:14:13 2017
     
476. 
     
477. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
478. 
     
479. SQL> Connected to an idle instance.
     
480. SQL> SQL> SQL> select        * from sys.tname
     
481. *
     
482. ERROR at line 1:
     
483. ORA-01034: ORACLE not available
     
484. Process ID: 0
     
485. Session ID: 0 Serial number: 0
     
486. 
     
487. 
     
488. alter system flush buffer_cache
     
489. *
     
490. ERROR at line 1:
     
491. ORA-01034: ORACLE not available
     
492. Process ID: 0
     
493. Session ID: 0 Serial number: 0
     
494. 
     
495. 
     
496. BEGIN dbms_output.put_line(' '); END;
     
497. 
     
498. *
     
499. ERROR at line 1:
     
500. ORA-01034: ORACLE not available
     
501. Process ID: 0
     
502. Session ID: 0 Serial number: 0
     
503. 
     
504. 
     
505. BEGIN dbms_output.put_line('**************************** '); END;
     
506. 
     
507. *
     
508. ERROR at line 1:
     
509. ORA-01034: ORACLE not available
     
510. Process ID: 0
     
511. Session ID: 0 Serial number: 0
     
512. 
     
513. 
     
514. BEGIN dbms_output.put_line('The destory take place here: '); END;
     
515. 
     
516. *
     
517. ERROR at line 1:
     
518. ORA-01034: ORACLE not available
     
519. Process ID: 0
     
520. Session ID: 0 Serial number: 0
     
521. 
     
522. 
     
523. BEGIN dbms_output.put_line('**************************** '); END;
     
524. 
     
525. *
     
526. ERROR at line 1:
     
527. ORA-01034: ORACLE not available
     
528. Process ID: 0
     
529. Session ID: 0 Serial number: 0
     
530. 
     
531. 
     
532. BEGIN dbms_output.put_line(' '); END;
     
533. 
     
534. *
     
535. ERROR at line 1:
     
536. ORA-01034: ORACLE not available
     
537. Process ID: 0
     
538. Session ID: 0 Serial number: 0
     
539. 
     
540. 
     
541. create table ttestbotang_10a (a number) tablespace users
     
542. *
     
543. ERROR at line 1:
     
544. ORA-01034: ORACLE not available
     
545. Process ID: 0
     
546. Session ID: 0 Serial number: 0
     
547. 
     
548. 
     
549. SQL> Disconnected
     
550. 
     
551. 
     
552. THE END

复制代码