ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > 控制文件备份到跟踪文件

控制文件备份到跟踪文件

原创 Oracle 作者：zzh_ds 时间：2017-05-07 10:29:05 0 删除 编辑


  1. root@hu ~]# su - oracle
  2. [oracle@hu ~]$ sqlplus / as sysdba

  4. SQL*Plus: Release 11.2.0.4.0 Production on Sun May 7 10:08:36 2017

  6. Copyright (c) 1982, 2013, Oracle. All rights reserved.


  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

  13. SQL>
  14. SQL> alter database backup controlfile to trace;

  16. Database altered.

  18. SQL>
  19. SQL> show parameter user_dump

  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博客 ” ，链接：https://blog.itpub.net/31399171/viewspace-2138611/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： 备份控制文件到指定位置
下一篇： 自动tempfile恢复
请登录后发表评论 登录
全部评论
zzh_ds

注册时间：2016-09-29

  • 博文量
    61
  • 访问量
    47809

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593