{"id":791,"date":"2012-04-25T23:21:45","date_gmt":"2012-04-25T15:21:45","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=791"},"modified":"2012-04-29T23:30:42","modified_gmt":"2012-04-29T15:30:42","slug":"ora-8103%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=791","title":{"rendered":"ORA-8103\u9519\u8bef"},"content":{"rendered":"<p>\u6700\u8fd1\u78b0\u5230\u4e24\u6b21ORA-8103\u9519\u8bef\uff0c\u7b80\u5355\u603b\u7ed3\u4e00\u4e0b\u3002<br \/>\n\u4e00\u6b21\u662f\u5ba2\u6237\u768410.2\u6570\u636e\u5e93\u51fa\u73b0\u4e86ORA-600[6002]\u9519\u8bef\uff0c\u5bfc\u81f4\u7684\u95ee\u9898\u662f\u7d22\u5f15\u51fa\u73b0\u4e86\u903b\u8f91\u635f\u574f\uff0c\u672c\u6765\u95ee\u9898\u5f88\u7b80\u5355\uff0c\u53ea\u9700\u8981\u5220\u9664\u7d22\u5f15\u5e76\u91cd\u5efa\uff0c\u6216\u8005\u901a\u8fc7ONLINE REBUILD\u65b9\u5f0f\u5c31\u53ef\u4ee5\u4e86\u3002\u4f46\u662f\u7d22\u5f15\u5220\u9664\u540e\uff0c\u626b\u63cf\u8fd9\u5f20\u8868\u51fa\u73b0\u4e86ORA-8103\u9519\u8bef\uff0c\u8fd9\u8bf4\u660e\u9519\u8bef\u4e0d\u4ec5\u51fa\u73b0\u5728\u7d22\u5f15\u4e0a\uff0c\u5728\u6570\u636e\u5757\u4e0a\u540c\u6837\u5b58\u5728\u903b\u8f91\u9519\u8bef\uff0c\u4ece\u800c\u5bfc\u81f4\u4e86\u524d\u9762\u7684ORA-600[6002]\u9519\u8bef\u3002<br \/>\n\u7b2c\u4e8c\u4e2a\u95ee\u9898\u662f11.2.0.2\u73af\u5883\u4e2d\u51fa\u73b0\u7684ORA-8103\u9519\u8bef\uff0c\u9519\u8bef\u53d1\u751f\u5728\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u8fc7\u7a0b\u4e2d\uff1a<\/p>\n<pre lang='SQL'>Fri Mar 30 02:00:00 2012\r\nDBMS_STATS: GATHER_STATS_JOB encountered errors.  Check the trace file.\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_j000_25932.trc:\r\nORA-20011: Approximate NDV failed: ORA-08103: object no longer exists<\/pre>\n<p>TRACE\u6587\u4ef6\u7684\u8be6\u7ec6\u4fe1\u606f\u5185\u5bb9\u4e3a\uff1a<\/p>\n<pre lang='SQL'>*** 2012-03-31 14:08:25.269\r\n*** SESSION ID:(485.61983) 2012-03-31 14:08:25.269\r\n*** CLIENT ID:() 2012-03-31 14:08:25.269\r\n*** SERVICE NAME:(SYS$USERS) 2012-03-31 14:08:25.269\r\n*** MODULE NAME:(DBMS_SCHEDULER) 2012-03-31 14:08:25.269\r\n*** ACTION NAME:(ORA$AT_OS_OPT_SY_1501) 2012-03-31 14:08:25.269\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nskdstdst()+36        call     kgdsdst()            000000000 ? 000000000 ?\r\n                                                   7FFF88CE8488 ? 000000001 ?\r\n                                                   000000001 ? 000000002 ?\r\nksedst1()+98         call     skdstdst()           000000000 ? 000000000 ?\r\n                                                   7FFF88CE8488 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nksedst()+34          call     ksedst1()            000000000 ? 000000001 ?\r\n                                                   7FFF88CE8488 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nkteinmap1()+4287     call     ksedst()             000000000 ? 000000001 ?\r\n                                                   7FFF88CE8488 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nkteinmap()+6         call     kteinmap1()          2B55FE027010 ? 000000014 ?\r\n                                                   7FFF88CE8488 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nkdselget()+13        call     kteinmap()           2B55FE027010 ? 000000014 ?\r\n                                                   7FFF88CE8488 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nkdstsnb()+644        call     kdselget()           2B55FE027010 ? 000000014 ?\r\n                                                   7FFF88CE8488 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nkdst_fetch()+234     call     kdstsnb()            2B55FE026E08 ? 000000014 ?\r\n                                                   7FFF88CE8488 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nkdstf00001010000km(  call     kdst_fetch()         000000001 ? 2B55FE026E08 ?\r\n)+3681                                             7FFF88CED870 ? 000000000 ?\r\n                                                   000000000 ? 000000002 ?\r\nkdsttgr()+110246     call     kdstf00001010000km(  000000032 ? 000000000 ?\r\n                              )                    7FFF88CED870 ? 2B55FE026CF0 ?\r\n                                                   008FD6CF8 ? 000000002 ?\r\nqertbFetch()+2023    call     kdsttgr()            2B55FE026E08 ? 000000000 ?\r\n                                                   96C2800B8 ? 2B55FE026CF0 ?\r\n                                                   96C280128 ? 008FD6CF8 ?\r\nqerandvFetch()+153   call     qertbFetch()         96C2800B8 ? 2B55FE026CF0 ?\r\n                                                   008FD6CF8 ? 7FFF88CEE0D0 ?\r\n                                                   100007FFF ? 2B55FE026D38 ?\r\nqergsFetch()+821     call     qerandvFetch()       96B765418 ? 2B55FE027630 ?\r\n                                                   008E6EDAE ? 7FFF88CEE1E0 ?\r\n                                                   000007FFF ? 2B55FE026D38 ?\r\n.\r\n.\r\n.\r\n******************* End of process map dump ************\r\n*** 2012-03-31 14:08:29.159\r\nORA-20011: Approximate NDV failed: ORA-08103: object no longer exists\r\n*** 2012-03-31 14:08:29.159\r\nDBMS_STATS: GATHER_STATS_JOB: GATHER_TABLE_STATS('\"MMS\"','\"DBMS_TABCOMP_TEMP_UNCMP\"','\"\"', ...)\r\nDBMS_STATS: ORA-20011: Approximate NDV failed: ORA-08103: object no longer exists<\/pre>\n<p>\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u5728\u4e8e\u6536\u96c6\u4e00\u5f20\u8868\u7684\u7edf\u8ba1\u4fe1\u606f\u3002<br \/>\n\u5176\u5b9e\u8fd9\u4e24\u6b21\u78b0\u5230\u7684ORA-8103\u95ee\u9898\u76f8\u5dee\u4e0d\u591a\uff0c\u57fa\u672c\u4e0a\u90fd\u662f\u8868\u4e2d\u5b58\u5728\u903b\u8f91\u574f\u5757\u5bfc\u81f4\u95ee\u9898\u7684\u4ea7\u751f\u3002\u5bfc\u81f4\u8fd9\u4e2a\u9519\u8bef\u51fa\u73b0\u7684\u539f\u56e0\u662f\uff0cOracle\u6839\u636e\u5757\u5934\u7684\u5b9a\u4f4d\u5230\u4e00\u4e2a\u6570\u636e\u5757\uff0c\u4f46\u662f\u53d1\u73b0\u8fd9\u4e2a\u6570\u636e\u5757\u51fa\u73b0\u903b\u8f91\u9519\u8bef\uff0c\u53ef\u80fd\u662f\u5f53\u524d\u5757\u7684\u7c7b\u578b\u6ca1\u6709\u88ab\u6807\u8bb0\u4e3a\u6570\u636e\u5757\uff0c\u4e5f\u6709\u53ef\u80fd\u662f\u5f53\u524d\u5757\u7684DATA_OBJECT_ID\u5b58\u5728\u9519\u8bef\u3002<br \/>\n\u5982\u679c\u8fd9\u4e2a\u62a5\u9519\u53d1\u751f\u5728\u7d22\u5f15\u4e0a\uff0c\u90a3\u4e48\u975e\u5e38\u7b80\u5355\uff0c\u53ea\u9700\u8981ONLINE REBUILD\u7d22\u5f15\uff0c\u6216\u8005\u5c06\u7d22\u5f15\u5220\u9664\u540e\u91cd\u5efa\u5373\u53ef\u3002<br \/>\n\u5f53\u524d\u78b0\u5230\u7684\u4e24\u6b21\u9519\u8bef\uff0c\u95ee\u9898\u90fd\u53d1\u751f\u5728\u8868\u4e0a\u3002\u90a3\u4e48\u5728\u5c1d\u8bd5\u89e3\u51b3\u95ee\u9898\u4e4b\u524d\uff0c\u5e94\u8be5\u9996\u5148\u6e05\u9664DB_CACHE\uff0c\u9632\u6b62\u662f\u5185\u5b58\u4e2d\u7684\u9519\u8bef\u5bfc\u81f4\u95ee\u9898\u7684\u4ea7\u751f\u3002<br \/>\n\u5982\u679c\u95ee\u9898\u4f9d\u65e7\uff0c\u5982\u679c\u5b58\u5728\u5408\u9002\u7684\u5907\u4efd\u53ef\u4ee5\u8fdb\u884c\u6062\u590d\u3002\u6bd4\u5982\u901a\u8fc7RMAN\u7684BLOCKRECOVER\u6216\u8005\u901a\u8fc7\u4e00\u4e2a\u6700\u65b0\u7684\u903b\u8f91\u5907\u4efd\u8fdb\u884c\u6062\u590d\u3002<br \/>\n\u5982\u679c\u6ca1\u6709\u5907\u4efd\uff0c\u5219\u53ef\u4ee5\u8003\u8651\u5229\u7528DBMS_REPAIR\u5305\uff0c\u5c06\u9519\u8bef\u7684BLOCK\u8bbe\u7f6e\u6807\u8bc6\uff0c\u9632\u6b62\u968f\u540e\u7684\u67e5\u8be2\u8bfb\u53d6\u8be5BLOCK\u3002\u5982\u679c\u60f3\u8981\u76f4\u63a5\u8bfb\u53d6\uff0c\u4e5f\u53ef\u4ee5\u8003\u8651\u5229\u7528PL\/SQL\u7684\u65b9\u5f0f\u5c06\u9519\u8bef\u5757\u4ee5\u5916\u7684\u8bb0\u5f55\u8bfb\u51fa\u6765\u3002<br \/>\n\u5173\u4e8eORA-8103\u9519\u8bef\uff0c\u5728MOS\u6587\u6863\u4e0aORA-8103 &#8220;object no longer exists&#8221; \/ Troubleshooting, Diagnostic and Solution [ID 8103.1]\u6709\u975e\u5e38\u8be6\u7ec6\u7684\u95ee\u9898\u8bca\u65ad\u548c\u89e3\u51b3\u7684\u9519\u8bef\uff0c\u53ef\u4ee5\u8fdb\u884c\u53c2\u8003\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6700\u8fd1\u78b0\u5230\u4e24\u6b21ORA-8103\u9519\u8bef\uff0c\u7b80\u5355\u603b\u7ed3\u4e00\u4e0b\u3002 \u4e00\u6b21\u662f\u5ba2\u6237\u768410.2\u6570\u636e\u5e93\u51fa\u73b0\u4e86ORA-600[6002]\u9519\u8bef\uff0c\u5bfc\u81f4\u7684\u95ee\u9898\u662f\u7d22\u5f15\u51fa\u73b0\u4e86\u903b\u8f91\u635f\u574f\uff0c\u672c\u6765\u95ee\u9898\u5f88\u7b80\u5355\uff0c\u53ea\u9700\u8981\u5220\u9664\u7d22\u5f15\u5e76\u91cd\u5efa\uff0c\u6216\u8005\u901a\u8fc7ONLINE REBUILD\u65b9\u5f0f\u5c31\u53ef\u4ee5\u4e86\u3002\u4f46\u662f\u7d22\u5f15\u5220\u9664\u540e\uff0c\u626b\u63cf\u8fd9\u5f20\u8868\u51fa\u73b0\u4e86ORA-8103\u9519\u8bef\uff0c\u8fd9\u8bf4\u660e\u9519\u8bef\u4e0d\u4ec5\u51fa\u73b0\u5728\u7d22\u5f15\u4e0a\uff0c\u5728\u6570\u636e\u5757\u4e0a\u540c\u6837\u5b58\u5728\u903b\u8f91\u9519\u8bef\uff0c\u4ece\u800c\u5bfc\u81f4\u4e86\u524d\u9762\u7684ORA-600[6002]\u9519\u8bef\u3002 \u7b2c\u4e8c\u4e2a\u95ee\u9898\u662f11.2.0.2\u73af\u5883\u4e2d\u51fa\u73b0\u7684ORA-8103\u9519\u8bef\uff0c\u9519\u8bef\u53d1\u751f\u5728\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u8fc7\u7a0b\u4e2d\uff1a Fri Mar 30 02:00:00 2012 DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file. Errors in file \/u01\/app\/oracle\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_j000_25932.trc: ORA-20011: Approximate NDV failed: ORA-08103: object no longer exists TRACE\u6587\u4ef6\u7684\u8be6\u7ec6\u4fe1\u606f\u5185\u5bb9\u4e3a\uff1a *** 2012-03-31 14:08:25.269 *** SESSION ID:(485.61983) 2012-03-31 14:08:25.269 *** &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=791\">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":[20,651,255,652,494],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-cL","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/791"}],"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=791"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/791\/revisions"}],"predecessor-version":[{"id":792,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/791\/revisions\/792"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=791"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=791"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}