控制文件备份到跟踪文件

1. root@hu ~]# su - oracle
   
2. [oracle@hu ~]$ sqlplus / as sysdba
   
3. 
   
4. SQL*Plus: Release 11.2.0.4.0 Production on Sun May 7 10:08:36 2017
   
5. 
   
6. Copyright (c) 1982, 2013, Oracle. All rights reserved.
   
7. 
   
8. 
   
9. Connected to:
   
10. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
    
11. With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
12. 
    
13. SQL>
    
14. SQL> alter database backup controlfile to trace;
    
15. 
    
16. Database altered.
    
17. 
    
18. SQL>
    
19. SQL> show parameter user_dump
    
20. 
    
21. NAME TYPE VALUE
    
22. ------------------------------------ ----------- ------------------------------
    
23. user_dump_dest string /u01/app/oracle/diag/rdbms/hu/
    
24.                                                  HU/trace
    
25. SQL> exit
    
26. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
    
27. With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
28. [oracle@hu ~]$ cd /u01/app/oracle/diag/rdbms/hu/HU/trace/
    
29. [oracle@hu trace]$ ls -lrt
    
30. total 832
    
31. -rw-r----- 1 oracle oinstall 78 Apr 22 18:13 HU_ora_9399.trm
    
32. -rw-r----- 1 oracle oinstall 827 Apr 22 18:13 HU_ora_9399.trc
    
33. -rw-r----- 1 oracle oinstall 67 Apr 22 18:13 HU_ora_9474.trm
    
34. -rw-r----- 1 oracle oinstall 1729 Apr 22 18:13 HU_ora_9474.trc
    
35. -rw-r----- 1 oracle oinstall 65 Apr 22 18:13 HU_mman_9435.trm
    
36. -rw-r----- 1 oracle oinstall 843 Apr 22 18:13 HU_mman_9435.trc
    
37. -rw-r----- 1 oracle oinstall 86 Apr 22 18:16 HU_vktm_9413.trm
    
38. -rw-r----- 1 oracle oinstall 1184 Apr 22 18:16 HU_vktm_9413.trc
    
39. -rw-r----- 1 oracle oinstall 105 Apr 22 18:16 HU_ora_9492.trm
    
40. -rw-r----- 1 oracle oinstall 1339 Apr 22 18:16 HU_ora_9492.trc
    
41. -rw-r----- 1 oracle oinstall 78 Apr 22 18:16 HU_ora_9496.trm
    
42. -rw-r----- 1 oracle oinstall 828 Apr 22 18:16 HU_ora_9496.trc
    
43. -rw-r----- 1 oracle oinstall 57 Apr 22 18:16 HU_mman_9532.trm
    
44. -rw-r----- 1 oracle oinstall 843 Apr 22 18:16 HU_mman_9532.trc
    
45. -rw-r----- 1 oracle oinstall 178 Apr 22 18:16 HU_m000_9583.trm
    
46. -rw-r----- 1 oracle oinstall 1068 Apr 22 18:16 HU_m000_9583.trc
    
47. -rw-r----- 1 oracle oinstall 58 Apr 22 18:16 HU_mmon_9575.trm
    
48. -rw-r----- 1 oracle oinstall 909 Apr 22 18:16 HU_mmon_9575.trc
    
49. -rw-r----- 1 oracle oinstall 764 Apr 22 18:16 HU_ora_9571.trm
    
50. -rw-r----- 1 oracle oinstall 8984 Apr 22 18:16 HU_ora_9571.trc
    
51. -rw-r----- 1 oracle oinstall 119 Apr 22 18:16 HU_cjq0_9599.trm
    
52. -rw-r----- 1 oracle oinstall 1249 Apr 22 18:16 HU_cjq0_9599.trc
    
53. -rw-r----- 1 oracle oinstall 82 Apr 22 18:16 HU_j005_9630.trm
    
54. -rw-r----- 1 oracle oinstall 959 Apr 22 18:16 HU_j005_9630.trc
    
55. -rw-r----- 1 oracle oinstall 58 Apr 22 18:16 HU_ora_9606.trm
    
56. -rw-r----- 1 oracle oinstall 997 Apr 22 18:16 HU_ora_9606.trc
    
57. -rw-r----- 1 oracle oinstall 65 Apr 22 18:17 HU_ora_9676.trm
    
58. -rw-r----- 1 oracle oinstall 892 Apr 22 18:17 HU_ora_9676.trc
    
59. -rw-r----- 1 oracle oinstall 66 Apr 22 18:17 HU_dm00_9684.trm
    
60. -rw-r----- 1 oracle oinstall 966 Apr 22 18:17 HU_dm00_9684.trc
    
61. -rw-r----- 1 oracle oinstall 86 Apr 22 18:17 HU_dbrm_9524.trm
    
62. -rw-r----- 1 oracle oinstall 1260 Apr 22 18:17 HU_dbrm_9524.trc
    
63. -rw-r----- 1 oracle oinstall 180 Apr 22 18:18 HU_dw00_9688.trm
    
64. -rw-r----- 1 oracle oinstall 1646 Apr 22 18:18 HU_dw00_9688.trc
    
65. -rw-r----- 1 oracle oinstall 57 Apr 22 18:19 HU_ora_9728.trm
    
66. -rw-r----- 1 oracle oinstall 942 Apr 22 18:19 HU_ora_9728.trc
    
67. -rw-r----- 1 oracle oinstall 109 Apr 22 18:20 HU_ora_9755.trm
    
68. -rw-r----- 1 oracle oinstall 1058 Apr 22 18:20 HU_ora_9755.trc
    
69. -rw-r----- 1 oracle oinstall 85 Apr 22 18:20 HU_vktm_9510.trm
    
70. -rw-r----- 1 oracle oinstall 1184 Apr 22 18:20 HU_vktm_9510.trc
    
71. -rw-r----- 1 oracle oinstall 117 Apr 22 18:20 HU_ora_9758.trm
    
72. -rw-r----- 1 oracle oinstall 1361 Apr 22 18:20 HU_ora_9758.trc
    
73. -rw-r----- 1 oracle oinstall 65 Apr 22 18:20 HU_ckpt_9544.trm
    
74. -rw-r----- 1 oracle oinstall 946 Apr 22 18:20 HU_ckpt_9544.trc
    
75. -rw-r----- 1 oracle oinstall 77 Apr 22 18:20 HU_ora_9762.trm
    
76. -rw-r----- 1 oracle oinstall 827 Apr 22 18:20 HU_ora_9762.trc
    
77. -rw-r----- 1 oracle oinstall 57 Apr 22 18:20 HU_mman_9798.trm
    
78. -rw-r----- 1 oracle oinstall 843 Apr 22 18:20 HU_mman_9798.trc
    
79. -rw-r----- 1 oracle oinstall 57 Apr 22 18:20 HU_ora_9837.trm
    
80. -rw-r----- 1 oracle oinstall 868 Apr 22 18:20 HU_ora_9837.trc
    
81. -rw-r----- 1 oracle oinstall 74 Apr 22 18:20 HU_ora_9848.trm
    
82. -rw-r----- 1 oracle oinstall 967 Apr 22 18:20 HU_ora_9848.trc
    
83. -rw-r----- 1 oracle oinstall 78 Apr 22 18:21 HU_dbrm_9790.trm
    
84. -rw-r----- 1 oracle oinstall 1260 Apr 22 18:21 HU_dbrm_9790.trc
    
85. -rw-r----- 1 oracle oinstall 70 Apr 22 18:25 HU_mmon_9822.trm
    
86. -rw-r----- 1 oracle oinstall 1040 Apr 22 18:25 HU_mmon_9822.trc
    
87. -rw-r----- 1 oracle oinstall 172 Apr 22 18:26 HU_m000_9931.trm
    
88. -rw-r----- 1 oracle oinstall 2982 Apr 22 18:26 HU_m000_9931.trc
    
89. -rw-r----- 1 oracle oinstall 85 Apr 22 18:26 HU_vktm_9776.trm
    
90. -rw-r----- 1 oracle oinstall 1184 Apr 22 18:26 HU_vktm_9776.trc
    
91. -rw-r----- 1 oracle oinstall 135 Apr 22 18:26 HU_ora_9945.trm
    
92. -rw-r----- 1 oracle oinstall 1361 Apr 22 18:26 HU_ora_9945.trc
    
93. -rw-r----- 1 oracle oinstall 78 Apr 22 18:26 HU_ora_9949.trm
    
94. -rw-r----- 1 oracle oinstall 856 Apr 22 18:26 HU_ora_9949.trc
    
95. -rw-r----- 1 oracle oinstall 66 Apr 22 18:26 HU_mman_9985.trm
    
96. -rw-r----- 1 oracle oinstall 843 Apr 22 18:26 HU_mman_9985.trc
    
97. -rw-r----- 1 oracle oinstall 67 Apr 22 18:26 HU_ora_10035.trm
    
98. -rw-r----- 1 oracle oinstall 969 Apr 22 18:26 HU_ora_10035.trc
    
99. -rw-r----- 1 oracle oinstall 87 Apr 22 18:27 HU_dbrm_9977.trm
    
100. -rw-r----- 1 oracle oinstall 1260 Apr 22 18:27 HU_dbrm_9977.trc
     
101. -rw-r----- 1 oracle oinstall 118 Apr 22 20:05 HU_lgwr_9993.trm
     
102. -rw-r----- 1 oracle oinstall 2011 Apr 22 20:05 HU_lgwr_9993.trc
     
103. -rw-r----- 1 oracle oinstall 76 Apr 22 22:35 HU_cjq0_10071.trm
     
104. -rw-r----- 1 oracle oinstall 978 Apr 22 22:35 HU_cjq0_10071.trc
     
105. -rw-r----- 1 oracle oinstall 112 Apr 22 22:37 HU_vktm_9963.trm
     
106. -rw-r----- 1 oracle oinstall 1507 Apr 22 22:37 HU_vktm_9963.trc
     
107. -rw-r----- 1 oracle oinstall 436 Apr 22 23:16 HU_mmon_10009.trm
     
108. -rw-r----- 1 oracle oinstall 4318 Apr 22 23:16 HU_mmon_10009.trc
     
109. -rw-r----- 1 oracle oinstall 79 Apr 22 23:45 HU_ora_4679.trm
     
110. -rw-r----- 1 oracle oinstall 856 Apr 22 23:45 HU_ora_4679.trc
     
111. -rw-r----- 1 oracle oinstall 57 Apr 22 23:45 HU_mman_4716.trm
     
112. -rw-r----- 1 oracle oinstall 843 Apr 22 23:45 HU_mman_4716.trc
     
113. -rw-r----- 1 oracle oinstall 209 Apr 22 23:45 HU_ora_4767.trm
     
114. -rw-r----- 1 oracle oinstall 2678 Apr 22 23:45 HU_ora_4767.trc
     
115. -rw-r----- 1 oracle oinstall 57 Apr 27 16:23 HU_lgwr_4724.trm
     
116. -rw-r----- 1 oracle oinstall 875 Apr 27 16:23 HU_lgwr_4724.trc
     
117. -rw-r----- 1 oracle oinstall 65 Apr 27 16:24 HU_w000_5970.trm
     
118. -rw-r----- 1 oracle oinstall 997 Apr 27 16:24 HU_w000_5970.trc
     
119. -rw-r----- 1 oracle oinstall 67 Apr 27 16:24 HU_j000_6136.trm
     
120. -rw-r----- 1 oracle oinstall 960 Apr 27 16:24 HU_j000_6136.trc
     
121. -rw-r----- 1 oracle oinstall 129 Apr 29 00:50 HU_vktm_4693.trm
     
122. -rw-r----- 1 oracle oinstall 1653 Apr 29 00:50 HU_vktm_4693.trc
     
123. -rw-r----- 1 oracle oinstall 57 Apr 29 00:50 HU_smon_4732.trm
     
124. -rw-r----- 1 oracle oinstall 929 Apr 29 00:50 HU_smon_4732.trc
     
125. -rw-r----- 1 oracle oinstall 57 Apr 29 00:50 HU_vkrm_6178.trm
     
126. -rw-r----- 1 oracle oinstall 966 Apr 29 00:50 HU_vkrm_6178.trc
     
127. -rw-r----- 1 oracle oinstall 298 Apr 29 00:50 HU_mmon_4740.trm
     
128. -rw-r----- 1 oracle oinstall 3195 Apr 29 00:50 HU_mmon_4740.trc
     
129. -rw-r----- 1 oracle oinstall 67 Apr 29 00:50 HU_cjq0_4795.trm
     
130. -rw-r----- 1 oracle oinstall 984 Apr 29 00:50 HU_cjq0_4795.trc
     
131. -rw-r----- 1 oracle oinstall 67 Apr 29 00:50 HU_j003_6154.trm
     
132. -rw-r----- 1 oracle oinstall 931 Apr 29 00:50 HU_j003_6154.trc
     
133. -rw-r----- 1 oracle oinstall 257 Apr 29 00:51 HU_j005_6162.trm
     
134. -rw-r----- 1 oracle oinstall 2990 Apr 29 00:51 HU_j005_6162.trc
     
135. -rw-r----- 1 oracle oinstall 163 Apr 29 00:52 HU_dbrm_4708.trm
     
136. -rw-r----- 1 oracle oinstall 12322 Apr 29 00:52 HU_dbrm_4708.trc
     
137. -rw-r----- 1 oracle oinstall 79 May 5 16:00 HU_ora_4810.trm
     
138. -rw-r----- 1 oracle oinstall 856 May 5 16:00 HU_ora_4810.trc
     
139. -rw-r----- 1 oracle oinstall 65 May 5 16:01 HU_mman_4852.trm
     
140. -rw-r----- 1 oracle oinstall 843 May 5 16:01 HU_mman_4852.trc
     
141. -rw-r----- 1 oracle oinstall 58 May 5 16:01 HU_mmon_4876.trm
     
142. -rw-r----- 1 oracle oinstall 909 May 5 16:01 HU_mmon_4876.trc
     
143. -rw-r----- 1 oracle oinstall 76 May 5 16:01 HU_j004_4981.trm
     
144. -rw-r----- 1 oracle oinstall 959 May 5 16:01 HU_j004_4981.trc
     
145. -rw-r----- 1 oracle oinstall 86 May 5 16:02 HU_dbrm_4844.trm
     
146. -rw-r----- 1 oracle oinstall 1260 May 5 16:02 HU_dbrm_4844.trc
     
147. -rw-r----- 1 oracle oinstall 86 May 5 16:02 HU_vktm_4830.trm
     
148. -rw-r----- 1 oracle oinstall 1184 May 5 16:02 HU_vktm_4830.trc
     
149. -rw-r----- 1 oracle oinstall 278 May 5 16:02 HU_ora_4914.trm
     
150. -rw-r----- 1 oracle oinstall 3289 May 5 16:02 HU_ora_4914.trc
     
151. -rw-r----- 1 oracle oinstall 76 May 5 16:02 HU_ora_4994.trm
     
152. -rw-r----- 1 oracle oinstall 827 May 5 16:02 HU_ora_4994.trc
     
153. -rw-r----- 1 oracle oinstall 65 May 5 16:03 HU_mman_5030.trm
     
154. -rw-r----- 1 oracle oinstall 843 May 5 16:03 HU_mman_5030.trc
     
155. -rw-r----- 1 oracle oinstall 66 May 5 16:04 HU_ora_5081.trm
     
156. -rw-r----- 1 oracle oinstall 967 May 5 16:04 HU_ora_5081.trc
     
157. -rw-r----- 1 oracle oinstall 85 May 5 16:23 HU_ora_5596.trm
     
158. -rw-r----- 1 oracle oinstall 1128 May 5 16:23 HU_ora_5596.trc
     
159. -rw-r----- 1 oracle oinstall 75 May 5 18:00 HU_j000_6721.trm
     
160. -rw-r----- 1 oracle oinstall 961 May 5 18:00 HU_j000_6721.trc
     
161. -rw-r----- 1 oracle oinstall 66 May 5 21:55 HU_w000_7215.trm
     
162. -rw-r----- 1 oracle oinstall 994 May 5 21:55 HU_w000_7215.trc
     
163. -rw-r----- 1 oracle oinstall 77 May 5 22:00 HU_lgwr_5038.trm
     
164. -rw-r----- 1 oracle oinstall 946 May 5 22:00 HU_lgwr_5038.trc
     
165. -rw-r----- 1 oracle oinstall 70 May 6 08:53 HU_vkrm_7267.trm
     
166. -rw-r----- 1 oracle oinstall 1028 May 6 08:53 HU_vkrm_7267.trc
     
167. -rw-r----- 1 oracle oinstall 78 May 6 09:15 HU_ckpt_5042.trm
     
168. -rw-r----- 1 oracle oinstall 1267 May 6 09:15 HU_ckpt_5042.trc
     
169. -rw-r----- 1 oracle oinstall 65 May 6 11:00 HU_arc0_5087.trm
     
170. -rw-r----- 1 oracle oinstall 940 May 6 11:00 HU_arc0_5087.trc
     
171. -rw-r----- 1 oracle oinstall 67 May 6 23:32 HU_j001_9083.trm
     
172. -rw-r----- 1 oracle oinstall 960 May 6 23:32 HU_j001_9083.trc
     
173. -rw-r----- 1 oracle oinstall 70 May 7 02:00 HU_vkrm_7354.trm
     
174. -rw-r----- 1 oracle oinstall 1042 May 7 02:00 HU_vkrm_7354.trc
     
175. -rw-r----- 1 oracle oinstall 278 May 7 09:55 HU_vktm_5008.trm
     
176. -rw-r----- 1 oracle oinstall 3877 May 7 09:55 HU_vktm_5008.trc
     
177. -rw-r----- 1 oracle oinstall 58 May 7 09:55 HU_vkrm_11025.trm
     
178. -rw-r----- 1 oracle oinstall 984 May 7 09:55 HU_vkrm_11025.trc
     
179. -rw-r----- 1 oracle oinstall 192 May 7 09:55 HU_cjq0_5132.trm
     
180. -rw-r----- 1 oracle oinstall 1907 May 7 09:55 HU_cjq0_5132.trc
     
181. -rw-r----- 1 oracle oinstall 184 May 7 09:56 HU_j001_11015.trm
     
182. -rw-r----- 1 oracle oinstall 1137 May 7 09:56 HU_j001_11015.trc
     
183. -rw-r----- 1 oracle oinstall 159 May 7 10:10 HU_ora_11275.trm
     
184. -rw-r----- 1 oracle oinstall 7074 May 7 10:10 HU_ora_11275.trc
     
185. -rw-r----- 1 oracle oinstall 57221 May 7 10:10 alert_HU.log
     
186. -rw-r----- 1 oracle oinstall 1421 May 7 10:10 HU_mmon_5054.trm
     
187. -rw-r----- 1 oracle oinstall 13447 May 7 10:10 HU_mmon_5054.trc
     
188. -rw-r----- 1 oracle oinstall 4485 May 7 10:13 HU_dbrm_5022.trm
     
189. -rw-r----- 1 oracle oinstall 94435 May 7 10:13 HU_dbrm_5022.trc
     
190. [oracle@hu trace]$
     
191. [oracle@hu trace]$ more HU_ora_11275.trc
     
192. ----
     
193. STARTUP NOMOUNT
     
194. CREATE CONTROLFILE REUSE DATABASE "HU" NORESETLOGS ARCHIVELOG
     
195.     MAXLOGFILES 16
     
196.     MAXLOGMEMBERS 3
     
197.     MAXDATAFILES 100
     
198.     MAXINSTANCES 8
     
199.     MAXLOGHISTORY 292
     
200. LOGFILE
     
201.   GROUP 1 '/u01/app/oracle/oradata/HU/redo01.log' SIZE 50M BLOCKSIZE 512,
     
202.   GROUP 2 '/u01/app/oracle/oradata/HU/redo02.log' SIZE 50M BLOCKSIZE 512,
     
203.   GROUP 3 '/u01/app/oracle/oradata/HU/redo03.log' SIZE 50M BLOCKSIZE 512
     
204. -- STANDBY LOGFILE
     
205. DATAFILE
     
206.   '/u01/app/oracle/oradata/HU/system01.dbf',
     
207.   '/u01/app/oracle/oradata/HU/sysaux01.dbf',
     
208.   '/u01/app/oracle/oradata/HU/undotbs01.dbf',
     
209.   '/u01/app/oracle/oradata/HU/users01.dbf',
     
210.   '/u01/app/oracle/oradata/HU/example01.dbf'
     
211. CHARACTER SET AL32UTF8
     
212. ;
     
213. -- Configure RMAN configuration record 1
     
214. VARIABLE RECNO NUMBER;
     
215. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','DEVICE TYPE DISK
     
216. FORMAT ''/u01/app/backup/db_%U.rum''');
     
217. -- Commands to re-create incarnation table
     
218. -- Below log names MUST be changed to existing filenames on
     
219. -- disk. Any one log file from each branch can be used to
     
220. -- re-create incarnation records.
     
221. -- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/
     
222. arch1_1_824297850.dbf';
     
223. -- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/
     
224. arch1_1_941998577.dbf';
     
225. -- Recovery is required if any of the datafiles are restored backups,
     
226. -- or if the last shutdown was not normal or immediate.
     
227. RECOVER DATABASE
     
228. -- All logs need archiving and a log switch is needed.
     
229. ALTER SYSTEM ARCHIVE LOG ALL;
     
230. -- Database can now be opened normally.
     
231. ALTER DATABASE OPEN;
     
232. -- Commands to add tempfiles to temporary tablespaces.
     
233. -- Online tempfiles have complete space information.
     
234. -- Other tempfiles may require adjustment.
     
235. ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/HU/temp01.dbf'
     
236.      SIZE 30408704 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;
     
237. -- End of tempfile additions.
     
238. --

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31399171/viewspace-2138611/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31399171/viewspace-2138611/