开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 4075-12c管理类OCP认证班第三期 › 8a实验，控制文件恢复完，recover database 报错 求解 R ...
返回列表 发新帖
查看: 1981|回复: 1

8a实验，控制文件恢复完，recover database 报错 求解 RMAN-06004: ORACLE error from recovery catal

[复制链接]
hongguanglin

7

主题

20

帖子

117

积分

注册会员

Rank: 2

积分
117
发表于 2017-9-28 18:41:39 | 显示全部楼层 |阅读模式
  1. RMAN>

  3. RMAN> list backup of controlfile;


  6. List of Backup Sets
  7. ===================


  10. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  11. ------- ---- -- ---------- ----------- ------------ ---------------
  12. 139     Full    9.67M      DISK        00:00:03     26-JUL-17      
  13.         BP Key: 140   Status: AVAILABLE  Compressed: NO  Tag: TAG20170726T052247
  14.         Piece Name: +FRA/orcl/autobackup/2017_07_26/s_950332967.264.950332971
  15.   Control File Included: Ckp SCN: 1747327      Ckp time: 26-JUL-17

  17. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  18. ------- ---- -- ---------- ----------- ------------ ---------------
  19. 188     Full    9.36M      DISK        00:00:02     22-NOV-13      
  20.         BP Key: 196   Status: AVAILABLE  Compressed: NO  Tag: TAG20131122T222515
  21.         Piece Name: +FRA/orcl/autobackup/2013_11_22/s_832199115.269.832199117
  22.   Control File Included: Ckp SCN: 848078       Ckp time: 22-NOV-13

  24. RMAN> alter database mount;

  26. database mounted
  27. released channel: ORA_DISK_1
  28. released channel: ORA_DISK_2
  29. released channel: ORA_DISK_3
  30. released channel: ORA_DISK_4
  31. released channel: ORA_DISK_5
  32. released channel: ORA_DISK_6
  33. released channel: ORA_DISK_7
  34. released channel: ORA_DISK_8
  35. released channel: ORA_SBT_TAPE_1
  36. released channel: ORA_SBT_TAPE_2

  38. RMAN> alter database open;

  40. RMAN-00571: ===========================================================
  41. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  42. RMAN-00571: ===========================================================
  43. RMAN-03002: failure of alter db command at 09/28/2017 00:28:22
  44. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

  46. RMAN> alter database open resetlogs;

  48. RMAN-00571: ===========================================================
  49. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  50. RMAN-00571: ===========================================================
  51. RMAN-03002: failure of alter db command at 09/28/2017 00:28:35
  52. ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
  53. ORA-01110: data file 1: '+DATA/orcl/datafile/system.265.950292089'

  55. RMAN> recover database;

  57. Starting recover at 28-SEP-17
  58. Starting implicit crosscheck backup at 28-SEP-17
  59. allocated channel: ORA_DISK_1
  60. channel ORA_DISK_1: SID=147 device type=DISK
  61. allocated channel: ORA_DISK_2
  62. channel ORA_DISK_2: SID=23 device type=DISK
  63. allocated channel: ORA_DISK_3
  64. channel ORA_DISK_3: SID=146 device type=DISK
  65. allocated channel: ORA_DISK_4
  66. channel ORA_DISK_4: SID=22 device type=DISK
  67. allocated channel: ORA_DISK_5
  68. channel ORA_DISK_5: SID=148 device type=DISK
  69. allocated channel: ORA_DISK_6
  70. channel ORA_DISK_6: SID=21 device type=DISK
  71. allocated channel: ORA_DISK_7
  72. channel ORA_DISK_7: SID=145 device type=DISK
  73. allocated channel: ORA_DISK_8
  74. channel ORA_DISK_8: SID=20 device type=DISK
  75. Finished implicit crosscheck backup at 28-SEP-17

  77. Starting implicit crosscheck copy at 28-SEP-17
  78. using channel ORA_DISK_1
  79. using channel ORA_DISK_2
  80. using channel ORA_DISK_3
  81. using channel ORA_DISK_4
  82. using channel ORA_DISK_5
  83. using channel ORA_DISK_6
  84. using channel ORA_DISK_7
  85. using channel ORA_DISK_8
  86. Finished implicit crosscheck copy at 28-SEP-17

  88. searching for all files in the recovery area
  89. cataloging files...
  90. cataloging done

  92. List of Cataloged Files
  93. =======================
  94. File Name: +fra/ORCL/AUTOBACKUP/2010_07_29/s_725595150.271.949874531
  95. File Name: +fra/ORCL/AUTOBACKUP/2010_07_28/s_725502190.344.949962897
  96. File Name: +fra/ORCL/AUTOBACKUP/2010_07_28/s_725502877.338.949954755
  97. File Name: +fra/ORCL/AUTOBACKUP/2010_07_28/s_725573392.301.949936481
  98. File Name: +fra/ORCL/AUTOBACKUP/2010_07_28/s_725574181.291.949922427
  99. File Name: +fra/ORCL/AUTOBACKUP/2010_07_28/s_725583390.362.950043657
  100. File Name: +fra/ORCL/AUTOBACKUP/2010_07_27/s_725491391.320.949951267
  101. File Name: +fra/ORCL/AUTOBACKUP/2010_07_27/s_725498954.396.950282547
  102. File Name: +fra/ORCL/AUTOBACKUP/2010_07_27/s_725500675.376.950185481
  103. File Name: +fra/ORCL/AUTOBACKUP/2017_07_26/s_950332967.264.950332971
  104. File Name: +fra/ORCL/AUTOBACKUP/2017_07_25/s_950291994.294.950292275
  105. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_1.359.950012463
  106. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_2.358.950006881
  107. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_3.356.950002903
  108. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_4.355.950002809
  109. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_5.354.950002805
  110. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_6.353.950002803
  111. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_7.352.950002779
  112. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_8.351.950000223
  113. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_9.350.950000147
  114. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_10.349.950000123
  115. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_11.348.950000069
  116. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_12.347.950000047
  117. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_13.285.949878049
  118. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_14.284.949875561
  119. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_15.283.949875329
  120. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_16.282.949875263
  121. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_20.278.949875001
  122. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_18.280.949875151
  123. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_19.279.949875095
  124. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_21.277.949874937
  125. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_22.276.949874881
  126. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_25.345.950275305
  127. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_24.274.949874727
  128. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_25.273.949874673
  129. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_26.275.949874819
  130. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_24.272.949874609
  131. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_1.398.725595357
  132. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_2.399.725595361
  133. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_3.400.725595371
  134. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_4.401.725595371
  135. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_5.406.725607297
  136. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_6.407.725607301
  137. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_7.408.725607307
  138. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_8.409.725607309
  139. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_9.410.725607311
  140. File Name: +fra/ORCL/ARCHIVELOG/2010_07_29/thread_1_seq_10.411.725607315
  141. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_1.374.950159091
  142. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_2.373.950158987
  143. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_3.372.950157989
  144. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_4.371.950156313
  145. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_5.370.950137237
  146. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_6.367.950133777
  147. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_7.365.950112065
  148. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_5.364.950098743
  149. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_6.363.950076025
  150. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_1.339.949954759
  151. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_1.332.949953383
  152. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_2.323.949952295
  153. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_3.310.949950093
  154. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_4.309.949950091
  155. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_5.308.949950087
  156. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_6.267.949950085
  157. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_8.307.949950075
  158. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_7.306.949950071
  159. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_7.304.949936491
  160. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_8.303.949936487
  161. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_9.302.949936483
  162. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_1.299.949936473
  163. File Name: +fra/ORCL/ARCHIVELOG/2010_07_28/thread_1_seq_1.287.949919395
  164. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_110.261.832198955
  165. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_111.394.950278629
  166. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_112.393.950278475
  167. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_113.392.950278419
  168. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_114.391.950278269
  169. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_115.390.950278099
  170. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_116.389.950277753
  171. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_117.258.950275759
  172. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_118.387.950273657
  173. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_119.386.950261041
  174. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_120.384.950246023
  175. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_121.383.950243615
  176. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_122.381.950225583
  177. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_123.379.950220473
  178. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_124.369.950135293
  179. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_125.368.950134089
  180. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_126.357.950003297
  181. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_127.346.950000593
  182. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_128.343.949956289
  183. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_129.342.949955087
  184. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_130.329.949953225
  185. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_131.305.949949773
  186. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_132.260.949936853
  187. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_133.298.949935481
  188. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_134.296.949932945
  189. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_135.295.949931439
  190. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_136.293.949930643
  191. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_135.289.949920369
  192. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_136.269.832199119
  193. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_137.397.950282547
  194. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_2.257.950275299
  195. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_3.259.950275195
  196. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_4.388.950274059
  197. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_5.385.950256325
  198. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_6.382.950239583
  199. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_7.380.950223621
  200. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_5.378.950220159
  201. File Name: +fra/ORCL/ARCHIVELOG/2010_07_27/thread_1_seq_6.377.950207611
  202. File Name: +fra/ORCL/ARCHIVELOG/2017_07_26/thread_1_seq_108.263.950341471
  203. File Name: +fra/ORCL/ARCHIVELOG/2017_07_26/thread_1_seq_109.262.950356459
  204. File Name: +fra/ORCL/ARCHIVELOG/2017_07_25/thread_1_seq_104.311.950285255

  206. using channel ORA_DISK_1
  207. using channel ORA_DISK_2
  208. using channel ORA_DISK_3
  209. using channel ORA_DISK_4
  210. using channel ORA_DISK_5
  211. using channel ORA_DISK_6
  212. using channel ORA_DISK_7
  213. using channel ORA_DISK_8
  214. RMAN-00571: ===========================================================
  215. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  216. RMAN-00571: ===========================================================
  217. RMAN-03002: failure of recover command at 09/28/2017 00:29:28
  218. RMAN-06004: ORACLE error from recovery catalog database: RMAN-20011: target database incarnation is not current in recovery catalog

  220. RMAN> recover database;

  222. Starting recover at 28-SEP-17
  223. using channel ORA_DISK_1
  224. using channel ORA_DISK_2
  225. using channel ORA_DISK_3
  226. using channel ORA_DISK_4
  227. using channel ORA_DISK_5
  228. using channel ORA_DISK_6
  229. using channel ORA_DISK_7
  230. using channel ORA_DISK_8
  231. released channel: ORA_DISK_1
  232. released channel: ORA_DISK_2
  233. released channel: ORA_DISK_3
  234. released channel: ORA_DISK_4
  235. released channel: ORA_DISK_5
  236. released channel: ORA_DISK_6
  237. released channel: ORA_DISK_7
  238. released channel: ORA_DISK_8
  239. RMAN-00571: ===========================================================
  240. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  241. RMAN-00571: ===========================================================
  242. RMAN-03002: failure of recover command at 09/28/2017 00:29:58
  243. RMAN-06004: ORACLE error from recovery catalog database: RMAN-20011: target database incarnation is not current in recovery catalog
复制代码


回复

使用道具 举报

botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-10-11 11:08:17 | 显示全部楼层
环境做好后，再做一遍吧。环境有问题。
回复 支持 反对

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-4-26 03:56 , Processed in 0.037962 second(s), 24 queries .

快速回复 返回顶部 返回列表