{"id":98,"date":"2011-09-16T23:58:56","date_gmt":"2011-09-16T15:58:56","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=98"},"modified":"2011-09-22T17:44:19","modified_gmt":"2011-09-22T09:44:19","slug":"ora-6004415%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=98","title":{"rendered":"ORA-600(4415)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237\u768411.2\u7684DATA GUARD\u6570\u636e\u5e93\u51fa\u73b0\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002<br \/>\n\u4e00\u822cDATA GUARD\u6570\u636e\u5e93\u51fa\u73b0\u9519\u8bef\u7684\u53ef\u80fd\u6027\u4e0d\u5927\uff0c\u800cORA-600\u9519\u8bef\u7684\u53ef\u80fd\u6027\u5c31\u66f4\u5c0f\u4e86\uff0c\u800c\u4e14\u4e00\u65e6\u51fa\u73b0\uff0c\u591a\u534a\u610f\u5473\u7740DATA GUARD\u73af\u5883\u635f\u574f\uff0c\u8f7b\u5219\u9700\u8981\u6062\u590d\uff0c\u91cd\u5219\u9700\u8981\u91cd\u5efa\u3002<br \/>\n\u4e0d\u8fc7\u8fd9\u4e2a\u9519\u8bef\u5e76\u6ca1\u6709\u90a3\u4e48\u5927\u5371\u5bb3\uff1a<\/p>\n<pre lang='SQL'>Fri Sep 16 17:57:13 2011\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/ora190\/ora190\/trace\/ora190_ora_18743334.trc (incident=288185):\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [4415], [], [], [], [], [], [], [], [], [], [], []\r\nIncident details in: \/u01\/app\/oracle\/diag\/rdbms\/ora190\/ora190\/incident\/incdir_288185\/ora190_ora_18743334_i288185.trc\r\nUse ADRCI or Support Workbench to package the incident.\r\nSee Note 411.1 at My Oracle Support for error and packaging details.\r\nSystem State dumped to trace file \/u01\/app\/oracle\/diag\/rdbms\/ora190\/ora190\/incident\/incdir_288185\/ora190_ora_18743334_i288185.trc\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/ora190\/ora190\/trace\/ora190_ora_18743334.trc (incident=288186):\r\nORA-00603: ORACLE \u670d\u52a1\u5668\u4f1a\u8bdd\u56e0\u81f4\u547d\u9519\u8bef\u800c\u7ec8\u6b62\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [4415], [], [], [], [], [], [], [], [], [], [], []\r\nIncident details in: \/u01\/app\/oracle\/diag\/rdbms\/ora190\/ora190\/incident\/incdir_288186\/ora190_ora_18743334_i288186.trc\r\nFri Sep 16 17:57:20 2011\r\nDumping diagnostic data in directory=[cdmp_20110916175720], requested by (instance=1, osid=18743334), summary=[incident=288185].\r\nFri Sep 16 17:57:21 2011\r\nSweep [inc][288186]: completed\r\nSweep [inc][288185]: completed\r\nSweep [inc2][288185]: completed\r\nopiodr aborting process unknown ospid (18743334) as a result of ORA-603<\/pre>\n<p>\u67e5\u8be2metalink\uff0c\u53d1\u73b0\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u662f\u5bf9\u53ea\u8bfb\u6253\u5f00\u7684STANDBY\u6570\u636e\u5e93\u6267\u884c\u4e86COMMIT\u64cd\u4f5c\uff0c\u8be6\u7ec6\u5185\u5bb9\u53ef\u4ee5\u53c2\u8003ID 9531380.8\uff0c\u8fd9\u4e2aBug 9531380\u572811.2.0.3\u4e2d\u5c06\u88ab\u89e3\u51b3\u3002<br \/>\n\u67e5\u8be2\u8be6\u7ec6\u4fe1\u606f\uff0c\u9a8c\u8bc1\u662f\u5426\u7531\u4e8e\u8fd9\u4e2a\u95ee\u9898\u6240\u81f4\uff1a<\/p>\n<pre lang='SQL'>bash-3.2$ more incident\/incdir_288186\/ora1_ora_18743334_i288186.trc\r\nDump file \/u01\/app\/oracle\/diag\/rdbms\/ora1\/ora1\/incident\/incdir_288186\/ora1_ora_18743334_i288186.trc\r\nOracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production\r\nWith the Partitioning, Automatic Storage Management, OLAP, Data Mining\r\nand Real Application Testing options\r\nORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\r\nSystem name:    AIX\r\nNode name:      node1\r\nRelease:        1\r\nVersion:        6\r\nMachine:        00F6D0DF4C00\r\nInstance name: ora1\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 23\r\nUnix process pid: 18743334, image: oracle@node1\r\n*** 2011-09-16 17:57:20.043\r\n*** SESSION ID:(1634.93) 2011-09-16 17:57:20.043\r\n*** CLIENT ID:() 2011-09-16 17:57:20.043\r\n*** SERVICE NAME:() 2011-09-16 17:57:20.043\r\n*** MODULE NAME:(TOAD 9.7.2.5) 2011-09-16 17:57:20.043\r\n*** ACTION NAME:() 2011-09-16 17:57:20.043\r\nDump continued from file: \/u01\/app\/oracle\/diag\/rdbms\/ora1\/ora1\/trace\/ora1_ora_18743334.trc\r\nORA-00603: ORACLE \u670d\u52a1\u5668\u4f1a\u8bdd\u56e0\u81f4\u547d\u9519\u8bef\u800c\u7ec8\u6b62\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [4415], [], [], [], [], [], [], [], [], [], [], []\r\n========= Dump for incident 288186 (ORA 603) ========\r\n*** 2011-09-16 17:57:20.051\r\ndbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)\r\n----- SQL Statement (None) -----\r\nCurrent SQL information unavailable - no cursor.\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nskdstdst()+40        bl       107c8d960            FFFFFFFFFFF1DF8 ? 000002004 ?\r\n                                                   000000001 ? 000000003 ?\r\n                                                   000000000 ? 000000002 ?\r\n                                                   000000001 ? 000000000 ?\r\nksedst1()+104        call     skdstdst()           FFFFFFFFFFF0E00 ? 000002004 ?\r\n                                                   110A45A80 ? 109FD7514 ?\r\n                                                   110A45A80 ? 000000000 ?\r\n                                                   FFFFFFFFFFF0F30 ? 700000007 ?\r\nksedst()+40          call     ksedst1()            3030000000000 ? 002050033 ?\r\n                                                   109FD7508 ? 700000000025C ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   109FD6B68 ? 000000000 ?\r\ndbkedDefDump()+2828  call     ksedst()             FFFFFFFFFFF0FE0 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ? 300000003 ?\r\nksedmp()+76          call     dbkedDefDump()       310A45A80 ? 110001050 ?\r\n                                                   FFFFFFFFFFF15E0 ?\r\n                                                   28404040FFFF17BC ?\r\n                                                   100148408 ? 109651628 ?\r\n                                                   FFFFFFFFFFF1630 ? 11064B0D8 ?\r\nksfdmp()+88          call     ksedmp()             000000000 ? 000000000 ?\r\n                                                   009651643 ? 10A7D6B10 ?\r\n                                                   200000000000000 ? 000000000 ?\r\n                                                   110C0C3D8 ? 110A45A80 ?\r\ndbgexPhaseII()+1212  call     ksfdmp()             000002004 ? 110A45A80 ?\r\n                                                   000000000 ? FFFFFFFFFFF17A8 ?\r\n                                                   FFFFFFFFFFF16D0 ?\r\n                                                   FFFFFFFFFFF1DF8 ? 1001D0358 ?\r\n                                                   110C0C3D8 ?\r\ndbgexProcessError()  call     dbgexPhaseII()       110A45A80 ? 110C0A5E8 ?\r\n+3604                                              0000465BA ? 200000000 ?\r\n                                                   FFFFFFFFFFF23A8 ? 00000007F ?\r\n                                                   FFFFFFFFFFF4FB0 ?\r\n                                                   2480442200000000 ?\r\ndbgeExecuteForError  call     dbgexProcessError()  110A45A80 ? 110C0C3D8 ?\r\n()+72                                              14FB82240 ? 02EDA2378 ?\r\n                                                   70000054FB820D0 ?\r\n                                                   7000005232EA080 ? 000000000 ?\r\n                                                   110C0E120 ?\r\ndbgePostErrorKGE()+  call     dbgeExecuteForError  FFFFFFFFFFF5830 ? 000000000 ?\r\n1152                          ()                   100135724 ? 000000000 ?\r\n                                                   000000000 ? 11064B0D8 ?\r\n                                                   FFFFFFFFFFF5840 ? 000000000 ?\r\ndbkePostKGE_kgsf()+  call     dbgePostErrorKGE()   FFFFFFFFFFF63D0 ? 1100010F8 ?\r\n64                                                 25BFFFF6450 ?\r\n                                                   2820402800000000 ?\r\n                                                   1000CC71C ? 000000002 ?\r\n                                                   02424A228 ? 02424A228 ?\r\nkgeade()+812         call     dbkePostKGE_kgsf()   100047FA0 ? FFFFFFFFFFFA634 ?\r\n                                                   10980D050 ? 000000048 ?\r\n                                                   FFFFFFFFFFFA230 ? 10969BAE8 ?\r\n                                                   FFFFFFFFFFF6698 ? 10A0626E8 ?\r\nkgefec()+208         call     kgeade()             FFFFFFFFFFF65A0 ? 11067C838 ?\r\n                                                   000000001 ? 11064B0D8 ?\r\n                                                   FFFFFFFFFFF65A0 ? 11064B0D8 ?\r\n                                                   70000054FB820D0 ?\r\n                                                   7000005232EA080 ?\r\nktc_die()+168        call     kgefec()             1100010F8 ? 110CA2518 ?\r\n                                                   0FFFF6BA0 ? 10A0626E8 ?\r\n                                                   70000054C772AD0 ? 10A0626E8 ?\r\n                                                   10A06274C ? 000000000 ?\r\nk2send()+9004        call     ktc_die()            218B2B4B0 ? 100000000 ?\r\n                                                   1103870F8 ? 110CB8608 ?\r\n                                                   110CB8008 ? 110CB8648 ?\r\n                                                   FFFFFFFFFFF6AE0 ? 11010AD68 ?\r\nxctRollbackTxn()+11  call     k2send()             300000001 ? 10975AC10 ?\r\n48                                                 000000000 ? 000000000 ?\r\n                                                   FFFFFFFFFFF7768 ?\r\n                                                   FFFFFFFFFFF773C ?\r\n                                                   700000000003660 ? 000000080 ?\r\nkpoltxen()+228       call     xctRollbackTxn()     000000000 ? FFFFFFFFFFF87D0 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000001 ? 000000000 ?\r\n                                                   000000006 ? 07FFFFFFF ?\r\nkpotxen()+2016       call     kpoltxen()           FFFFFFFFFFF8770 ? 000000048 ?\r\n                                                   FFFFFFFFFFF8800 ? 1100F88B8 ?\r\n                                                   0000003CF ? 000000000 ?\r\n                                                   700000518B2B4B0 ? 000000000 ?\r\nopiodr()+3608        call     kpotxen()            100000000 ? 1103757E8 ?\r\n                                                   FFFFFFFFFFF89D0 ?\r\n                                                   4820402000000000 ?\r\n                                                   100D7C570 ? 9001000A0082608 ?\r\n                                                   9001000A000D4C8 ? 11064B0D8 ?\r\nttcpip()+4628        call     opiodr()             68FFFF9F30 ? C00000438 ?\r\n                                                   FFFFFFFFFFFA480 ? 000200048 ?\r\n                                                   FFFFFFFFFFF9F00 ? 000000000 ?\r\n                                                   FFFFFFFFFFF9E50 ? 1101042F8 ?\r\nopitsk()+6956        call     ttcpip()             1101041A8 ? 110A49138 ?\r\n                                                   FFFFFFFFFFFA400 ?\r\n                                                   4224244400000000 ?\r\n                                                   100113A34 ? 000000000 ?\r\n                                                   FFFFFFFFFFFA460 ? 1100056F8 ?\r\nopiino()+3000        call     opitsk()             110043D10 ? 000000000 ?\r\n                                                   110A45A80 ? FFFFFFFFFFFC560 ?\r\n                                                   FFFFFFFFFFFE5AC ? 000000101 ?\r\n                                                   FFFFFFFFFFFDF30 ?\r\n                                                   FFFFFFFFFFFE5AC ?\r\nopiodr()+3608        call     opiino()             3C00000000 ?\r\n                                                   FFFFFFFFFFFD065 ?\r\n                                                   FFFFFFFFFFFE9D0 ? 110AC738D ?\r\n                                                   FFFFFFFFFFFD0C0 ? 000000000 ?\r\n                                                   90000000001094C ? 0E0DDF00D ?\r\nopidrv()+1200        call     opiodr()             3C08456C78 ? 47530312F ?\r\n                                                   FFFFFFFFFFFE9D0 ? 01064B0D8 ?\r\n                                                   7264626D732F6F72 ?\r\n                                                   11064B0D8 ?\r\n                                                   3139302F74726163 ?\r\n                                                   652F6F7261313930 ?\r\nsou2o()+192          call     opidrv()             3C06401934 ? 400000000 ?\r\n                                                   FFFFFFFFFFFE9D0 ?\r\n                                                   2B00CF0000 ? 0001A9F48 ?\r\n                                                   000000000 ? 9001000A0071F98 ?\r\n                                                   11064B0D8 ?\r\nopimai_real()+428    call     sou2o()              FFFFFFFFFFFEA40 ?\r\n                                                   BADC0FFEE0DDF00D ?\r\n                                                   90000000004D38C ?\r\n                                                   BADC0FFEE0DDF00D ?\r\n                                                   000000002 ? 9001000A0082608 ?\r\n                                                   A0000000A000000 ? 10ACFAA60 ?\r\nssthrdmain()+340     call     opimai_real()        FFFFFFFFFFFFFFFF ?\r\n                                                   9001000A0399148 ?\r\n                                                   FFFFFFFFFFFEB30 ?\r\n                                                   9001000A0082608 ?\r\n                                                   900000000001368 ?\r\n                                                   9001000A00091C0 ?\r\n                                                   FFFFFFFFFFFEB50 ?\r\n                                                   9001000A0082608 ?\r\nmain()+216           call     ssthrdmain()         2F00035C0 ? FFFFFFFFFFFEE88 ?\r\n                                                   FFFFFFFFFFFEEF0 ?\r\n                                                   9FFFFFFF000C4C0 ?\r\n                                                   9FFFFFFF0000A30 ? 000000000 ?\r\n                                                   000000000 ? 9FFFFFFF000C4C0 ?\r\n__start()+112        call     main()               000000000 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u4ece\u8fde\u63a5\u4fe1\u606f\u53ef\u4ee5\u770b\u51fa\uff0c\u662f\u901a\u8fc7TOAD\u8fde\u63a5\u5230\u6570\u636e\u5e93\u5b9e\u4f8b\u7684\uff0c\u8fd9\u8bf4\u660e\u4e8b\u52a1\u53ef\u80fd\u662f\u4eba\u4e3a\u64cd\u4f5c\u6240\u81f4\uff0c\u867d\u7136\u5728SQL\u8bed\u53e5\u5904\u6ca1\u6709\u4efb\u4f55\u4fe1\u606f\uff0c\u4f46\u662f\u4eceStack\u7684dump\u4e2d\u53ef\u4ee5\u770b\u5230xctRollbackTxn\u51fd\u6570\uff0c\u867d\u7136Oracle\u5e76\u6ca1\u6709\u6267\u884cCOMMIT\uff0c\u4f46\u662f\u8fd0\u884c\u4e86ROLLBACK\u3002\u5728\u53ea\u8bfb\u6570\u636e\u5e93\u4e2d\uff0cCOMMIT\u4f1a\u5bfc\u81f4\u9519\u8bef\u7684\u4ea7\u751f\uff0c\u90a3\u4e48\u56de\u6eda\u5f88\u53ef\u80fd\u5bfc\u81f4\u76f8\u540c\u7684\u95ee\u9898\uff0c\u5728\u52a0\u4e0a\u7248\u672c\u5df2\u7ecfDATA GUARD\u4e2d\u5907\u5e93\u7b49\u73af\u5883\uff0c\u57fa\u672c\u4e0a\u53ef\u4ee5\u786e\u8ba4\u95ee\u9898\u4e86\u3002<br \/>\n\u8fd9\u4e2a\u95ee\u9898\u672c\u8eab\u6ca1\u6709\u5fc5\u8981\u8fc7\u591a\u5173\u6ce8\uff0c\u56e0\u4e3a\u5728\u53ea\u8bfb\u5e93\u4e0a\u8fdb\u884c\u4e8b\u52a1\u672c\u8eab\u5c31\u5b58\u5728\u95ee\u9898\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u768411.2\u7684DATA GUARD\u6570\u636e\u5e93\u51fa\u73b0\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002 \u4e00\u822cDATA GUARD\u6570\u636e\u5e93\u51fa\u73b0\u9519\u8bef\u7684\u53ef\u80fd\u6027\u4e0d\u5927\uff0c\u800cORA-600\u9519\u8bef\u7684\u53ef\u80fd\u6027\u5c31\u66f4\u5c0f\u4e86\uff0c\u800c\u4e14\u4e00\u65e6\u51fa\u73b0\uff0c\u591a\u534a\u610f\u5473\u7740DATA GUARD\u73af\u5883\u635f\u574f\uff0c\u8f7b\u5219\u9700\u8981\u6062\u590d\uff0c\u91cd\u5219\u9700\u8981\u91cd\u5efa\u3002 \u4e0d\u8fc7\u8fd9\u4e2a\u9519\u8bef\u5e76\u6ca1\u6709\u90a3\u4e48\u5927\u5371\u5bb3\uff1a Fri Sep 16 17:57:13 2011 Errors in file \/u01\/app\/oracle\/diag\/rdbms\/ora190\/ora190\/trace\/ora190_ora_18743334.trc (incident=288185): ORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [4415], [], [], [], [], [], [], [], [], [], [], [] Incident details in: \/u01\/app\/oracle\/diag\/rdbms\/ora190\/ora190\/incident\/incdir_288185\/ora190_ora_18743334_i288185.trc Use ADRCI or Support Workbench &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=98\">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":[34,37,35,8,36,38],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-1A","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/98"}],"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=98"}],"version-history":[{"count":3,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/98\/revisions"}],"predecessor-version":[{"id":100,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/98\/revisions\/100"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=98"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=98"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=98"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}