\u63a5\u5230\u5ba2\u6237\u544a\u8b66\uff0c\u6570\u636e\u5e93\u6302\u4e86\uff0c\u67e5\u770balert\u65e5\u5fd7\uff0c\u5982\u4e0b\uff1a<\/p>\n
*** 2017-08-28 10:31:18.159\nMedia Recovery of Online Log [Thread=1, Seq=75574]\n\n*** 2017-08-28 10:31:18.160\nRecovery of Online Redo Log: Thread 1 Group 12 Seq 75574 Reading mem 0\nLog read is SYNCHRONOUS though disk_asynch_io is enabled!\n\n*** 2017-08-28 10:34:46.694\n*** 2017-08-28 10:34:46.694 4338 krsh.c\nMRP0: Background Media Recovery terminated with error 449\nORA-00449: background process 'LGWR' unexpectedly terminated with error 4021\n*** 2017-08-28 10:34:46.698 4338 krsh.c\nManaged Standby Recovery not using Real Time Apply\n--------------------------------------------------------------------------\nDDE Action 'DB_STRUCTURE_INTEGRITY_CHECK' was flood controlled\n----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (FLOOD CONTROLLED, -457834491 csec) -----\nExecuting ASYNC actions\n----- END DDE Actions Dump (total 0 csec) -----\nORA-00313: open failed for members of log group 2 of thread 1\nORA-00312: online log 2 thread 1: '\/xxxxx\/oracle\/xxxxx\/redo02.log'\nORA-27037: unable to obtain file status\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 3\nORA-00313: open failed for members of log group 2 of thread 1\nORA-00312: online log 2 thread 1: '\/xxxxx\/oracle\/xxxxxx\/redo02.log'\nORA-27037: unable to obtain file status\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 3\nerror 4021 detected in background process\n\n*** 2017-08-28 10:34:46.689\nORA-04021: timeout occurred while waiting to lock object \nkjzduptcctx: Notifying DIAG for crash event\n----- Abridged Call Stack Trace -----\nksedsts()+465<-kjzdssdmp()+267<-kjzduptcctx()+232<-kjzdicrshnfy()+63<-ksuitm()+5594<-ksbrdp()+3507<-opirip()+623<-opidrv()+603<-sou2o()+103<-opimai_real()+250<-ssthrdmain()+265<-main()+201<-__libc_start_main()+253 \n----- End of Abridged Call Stack Trace -----\n\n*** 2017-08-28 10:34:46.713\nLGWR (ospid: 120716): terminating the instance due to error 4021\nksuitm: waiting up to [5] seconds before killing DIAG(120677)<\/code><\/pre>\n\u8fd9\u4e2a\u95ee\u9898\u662f11.2 ADG\u4e0a\u4e00\u4e2a\u6bd4\u8f83\u77e5\u540d\u7684bug\uff1a
\nBug 17824201 - PHYSICAL STANDBY DATABASE CRASHES WITH ORA-4021
\n\u662f\u7531LGWR\u8ddf\u5176\u4ed6\u8fdb\u7a0b\u4e4b\u95f4\u5728instance load lock\u4e0a\u53d1\u751f\u6b7b\u9501\u5f15\u8d77\u7684\u3002\u867d\u713611.2.0.4 \u5df2\u7ecffix\u4e86\u8fd9\u4e2aBUG\uff0c\u4f46\u9700\u8981\u8bbe\u7f6e\u4ee5\u4e0b\u9690\u542b\u53c2\u6570\u542f\u7528\uff1a <\/p>\n
SQL> alter system set "_adg_parselock_timeout"=500; \n\nSystem altered. <\/code><\/pre>\n\u8fd9\u4e2a\u53c2\u6570\u4e3aLGWR\u8bbe\u7f6e\u4e86\u9501\u7684\u8d85\u65f6\u65f6\u95f4\uff0c\u5f53\u5c1d\u8bd5\u83b7\u5f97\u6392\u5b83\u9501\u8d85\u65f6\u540e\uff0cLGWR\u4f1asleep\u4e00\u9635\uff0c\u7136\u540e\u91cd\u8bd5\u7533\u8bf7\uff0c\u8fd9\u6837\u5c31\u4e0d\u4f1a\u4ea7\u751f\u6b7b\u9501\u5bfc\u81f4\u5b9e\u4f8b\u6302\u6389\u4e86\u3002
\n\u4fee\u6539\u540e\u6570\u636e\u5e93\u6b63\u5e38\u8fd0\u884c\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u63a5\u5230\u5ba2\u6237\u544a\u8b66\uff0c\u6570\u636e\u5e93\u6302\u4e86\uff0c\u67e5\u770balert\u65e5\u5fd7\uff0c\u5982\u4e0b<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,41],"tags":[],"class_list":["post-1112","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category-41"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1112"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1112\/revisions"}],"predecessor-version":[{"id":1114,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1112\/revisions\/1114"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1112"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}