{"id":1285,"date":"2012-10-21T23:59:00","date_gmt":"2012-10-21T15:59:00","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1285"},"modified":"2013-03-10T11:03:06","modified_gmt":"2013-03-10T03:03:06","slug":"ora-6002801%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1285","title":{"rendered":"ORA-600(2801)\u9519\u8bef"},"content":{"rendered":"<p>10.2.0.4 RAC\u73af\u5883\u5173\u95ed\u6570\u636e\u5e93\u65f6\u51fa\u73b0ORA-600[2801]\u9519\u8bef\u3002<br \/>\n\u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Mon Apr 11 22:44:24 2011\r\nalter database add supplemental log data\r\nTue Apr 12 00:11:42 2011\r\nThread 1 advanced to log sequence 3108 (LGWR switch)\r\n  Current log# 1 seq# 3108 mem# 0: +DATA\/orcl\/onlinelog\/group_1.307.727394923\r\n  Current log# 1 seq# 3108 mem# 1: +DATA\/orcl\/onlinelog\/group_1.306.727394925\r\nTue Apr 12 00:16:55 2011\r\nThread 1 advanced to log sequence 3109 (LGWR switch)\r\n  Current log# 2 seq# 3109 mem# 0: +DATA\/orcl\/onlinelog\/group_2.305.727394927\r\n  Current log# 2 seq# 3109 mem# 1: +DATA\/orcl\/onlinelog\/group_2.304.727394929\r\nTue Apr 12 00:17:09 2011\r\nALTER SYSTEM SET service_names='orcl' SCOPE=MEMORY SID='orcl1';\r\nTue Apr 12 00:17:16 2011\r\nShutting down instance: further logons disabled\r\nTue Apr 12 00:17:34 2011\r\nStopping background process QMNC\r\nTue Apr 12 00:17:35 2011\r\nStopping background process CJQ0\r\nTue Apr 12 00:17:36 2011\r\nStopping background process MMNL\r\nTue Apr 12 00:17:37 2011\r\nStopping background process MMON\r\nTue Apr 12 00:17:39 2011\r\nShutting down instance (immediate)\r\nLicense high water mark = 2047\r\nTue Apr 12 00:17:39 2011\r\nStopping Job queue slave processes, flags = 7\r\nTue Apr 12 00:17:39 2011\r\nSUPLOG: Supplemental log DDL failed at scn = 5550732597\r\nSUPLOG:  minimal = ON, primary key = ON\r\nSUPLOG:  unique = ON, foreign key = OFF, all column = OFF\r\nORA-1089 signalled during: alter database add supplemental log data...\r\nTue Apr 12 00:17:39 2011\r\nSUPLOG STATE OBJECT CLEANUP: Failed DDL needs rollback\r\nTue Apr 12 00:17:39 2011\r\nProcess OS id : 4151 alive after kill\r\nErrors in file \/opt\/app\/oracle\/admin\/orcl\/udump\/orcl1_ora_23074.trc\r\nTue Apr 12 00:17:39 2011\r\nJob queue slave processes stopped\r\nAll dispatchers and shared servers shutdown\r\nTue Apr 12 00:17:42 2011\r\nALTER DATABASE CLOSE NORMAL\r\nTue Apr 12 00:17:52 2011\r\nReconfiguration started (old inc 8, new inc 10)\r\nList of nodes:\r\n 0\r\n Global Resource Directory frozen\r\n * dead instance detected - domain 0 invalid = TRUE \r\n Communication channels reestablished\r\n Master broadcasted resource hash value bitmaps\r\n Non-local Process blocks cleaned out\r\nTue Apr 12 00:17:52 2011\r\n LMS 0: 0 GCS shadows cancelled, 0 closed\r\nTue Apr 12 00:17:52 2011\r\n LMS 3: 0 GCS shadows cancelled, 0 closed\r\nTue Apr 12 00:17:52 2011\r\n LMS 2: 0 GCS shadows cancelled, 0 closed\r\nTue Apr 12 00:17:52 2011\r\n LMS 1: 1 GCS shadows cancelled, 0 closed\r\n Set master node info \r\n Submitted all remote-enqueue requests\r\n Dwn-cvts replayed, VALBLKs dubious\r\n All grantable enqueues granted\r\n Post SMON to start 1st pass IR\r\nTue Apr 12 00:17:52 2011\r\n LMS 0: 19640 GCS shadows traversed, 0 replayed\r\nTue Apr 12 00:17:52 2011\r\n LMS 3: 20357 GCS shadows traversed, 0 replayed\r\nTue Apr 12 00:17:52 2011\r\n LMS 1: 20465 GCS shadows traversed, 0 replayed\r\nTue Apr 12 00:17:52 2011\r\n LMS 2: 20361 GCS shadows traversed, 0 replayed\r\nTue Apr 12 00:17:52 2011\r\n Submitted all GCS remote-cache requests\r\n Fix write in gcs resources\r\nReconfiguration complete\r\nTue Apr 12 00:17:52 2011\r\nTransaction recovery: lock conflict caught and ignored\r\nTransaction recovery: lock conflict caught and ignored\r\nTue Apr 12 00:17:52 2011\r\nSUPLOG SMON: Attempt to Rollback DDL\r\nTue Apr 12 00:17:52 2011\r\nSUPLOG: Waiting to get supplemental DDL enqueue\r\nTue Apr 12 00:17:52 2011\r\nSUPLOG: Commencing to rollback failed DDL at scn = 5550732880\r\nSUPLOG:  minimal = ON, primary key = ON\r\nSUPLOG:  unique = ON, foreign key = OFF, all column = OFF\r\nTue Apr 12 00:17:52 2011\r\nSUPLOG: Failed to rollback DDL at scn = 5550732880\r\nSUPLOG:  minimal = ON, primary key = ON\r\nSUPLOG:  unique = ON, foreign key = OFF, all column = OFF\r\nTue Apr 12 00:17:52 2011\r\nErrors in file \/opt\/app\/oracle\/admin\/orcl\/bdump\/orcl1_smon_4516.trc:\r\nORA-00600: internal error code, arguments: [2801], [], [], [], [], [], [], []\r\nORA-00601: cleanup lock conflict\r\nTue Apr 12 00:17:53 2011\r\nTrace dumping is performing id=[cdmp_20110412001753]\r\nTue Apr 12 00:17:53 2011\r\nNon-fatal internal error happenned while SMON was doing failed supplemental log DDL cleanup.\r\nSMON encountered 1 out of maximum 100 non-fatal internal errors.\r\nSMON: disabling tx recovery\r\nTue Apr 12 00:17:53 2011\r\nInstance recovery: looking for dead threads\r\nInstance recovery: lock domain invalid but no dead threads\r\nSMON: disabling cache recovery\r\nTue Apr 12 00:18:02 2011\r\nShutting down archive processes\r\nArchiving is disabled\r\nTue Apr 12 00:18:07 2011\r\nARCH shutting down\r\nARC1: Archival stopped\r\nTue Apr 12 00:18:12 2011\r\nARCH shutting down\r\nARC0: Archival stopped\r\nTue Apr 12 00:18:13 2011\r\nThread 1 closed at log sequence 3109\r\nSuccessful close of redo thread 1\r\nTue Apr 12 00:18:14 2011\r\nCompleted: ALTER DATABASE CLOSE NORMAL\r\nTue Apr 12 00:18:14 2011\r\nALTER DATABASE DISMOUNT\r\nTue Apr 12 00:18:15 2011\r\nSUCCESS: diskgroup DATA was dismounted\r\nTue Apr 12 00:18:15 2011\r\nCompleted: ALTER DATABASE DISMOUNT\r\nARCH: Archival disabled due to shutdown: 1089\r\nShutting down archive processes\r\nArchiving is disabled\r\nArchive process shutdown avoided: 0 active\r\nARCH: Archival disabled due to shutdown: 1089\r\nShutting down archive processes\r\nArchiving is disabled\r\nArchive process shutdown avoided: 0 active\r\nTue Apr 12 00:18:22 2011\r\nfreeing rdom 0<\/pre>\n<p>\u4ece\u544a\u8b66\u65e5\u5fd7\u4e2d\u8bb0\u5f55\u7684\u5185\u5bb9\u53ef\u4ee5\u770b\u51fa\u8fd9\u4e2aORA-600\u9519\u8bef\u4ea7\u751f\u7684\u59cb\u672b\u3002\u6700\u5f00\u59cb\u6267\u884c\u4e86\u4e00\u4e2aADD SUPPLEMENTAL LOG DATA\u7684\u64cd\u4f5c\uff0c\u800c\u8fd9\u4e2a\u64cd\u4f5c\u4e00\u76f4\u90fd\u6ca1\u6709\u5b8c\u6210\u3002\u663e\u7136\uff0c\u5b58\u5728\u4e8b\u52a1\u4e00\u76f4\u6ca1\u6709\u7ed3\u675f\uff0c\u5bfc\u81f4\u4e86\u8fd9\u4e2a\u64cd\u4f5c\u65e0\u6cd5\u5b8c\u6210\u3002<br \/>\n\u5927\u7ea6\u4e00\u4e2a\u534a\u5c0f\u65f6\u4e4b\u540e\uff0c\u624b\u5de5\u6267\u884c\u4e86\u6570\u636e\u5e93\u7684SHUTDOWN IMMEDIATE\u64cd\u4f5c\u3002\u4ece\u544a\u8b66\u65e5\u5fd7\u53ef\u4ee5\u770b\u5230\uff0c\u53e6\u4e00\u4e2a\u8282\u70b9\u5728\u4e4b\u524d\u4e5f\u6267\u884c\u4e86\u6570\u636e\u5e93\u7684\u5173\u95ed\u64cd\u4f5c\u3002\u800c\u5728\u6570\u636e\u5e93\u7684\u5173\u95ed\u8fc7\u7a0b\u4e2d\uff0cOracle\u5c1d\u8bd5\u56de\u5f52ALTER DATABASE ADD SUPPLEMENTAL LOG DATA\u7684DDL\u8bed\u53e5\u4e14\u5931\u8d25\u3002\u800cOracle\u5728\u5c1d\u8bd5\u6e05\u9664\u9501\u4fe1\u606f\u7684\u65f6\u5019\u51fa\u73b0\u4e86\u9519\u8bef\u5e76\u6700\u7ec8\u5bfc\u81f4\u4e86ORA-600[2801]\u9519\u8bef\u3002<br \/>\n\u663e\u7136\u8fd9\u4e2a\u9519\u8bef\u662f\u7279\u5b9a\u73af\u5883\u5f15\u53d1\u7684\uff0c\u4e14\u5bf9\u4e8e\u6570\u636e\u5e93\u672c\u8eab\u800c\u8a00\u5e76\u65e0\u5371\u5bb3\uff0c\u8fd9\u91cc\u505a\u4e3a\u4e00\u4e2a\u6848\u4f8b\u8bb0\u5f55\u4e00\u4e0b\u95ee\u9898\u4ea7\u751f\u7684\u59cb\u672b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>10.2.0.4 RAC\u73af\u5883\u5173\u95ed\u6570\u636e\u5e93\u65f6\u51fa\u73b0ORA-600[2801]\u9519\u8bef\u3002 \u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Mon Apr 11 22:44:24 2011 alter database add supplemental log data Tue Apr 12 00:11:42 2011 Thread 1 advanced to log sequence 3108 (LGWR switch) Current log# 1 seq# 3108 mem# 0: +DATA\/orcl\/onlinelog\/group_1.307.727394923 Current log# 1 seq# &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1285\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[1134,1135,8,760,770,1136],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-kJ","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1285"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1285"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1285\/revisions"}],"predecessor-version":[{"id":1287,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1285\/revisions\/1287"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}