{"id":1172,"date":"2012-09-10T23:22:05","date_gmt":"2012-09-10T15:22:05","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1172"},"modified":"2012-10-26T23:55:40","modified_gmt":"2012-10-26T15:55:40","slug":"standby%e6%95%b0%e6%8d%ae%e5%ba%93%e5%87%baora-1009%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1172","title":{"rendered":"STANDBY\u6570\u636e\u5e93\u51faORA-1009\u9519\u8bef"},"content":{"rendered":"<p>\u572810.2.0.4 DATA GUARD\u7684STANDBY\u6570\u636e\u5e93\u4e2d\uff0c\u51fa\u73b0\u4e86\u5927\u91cf\u7684ORA-1009\u9519\u8bef\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Thu May 31 14:11:16 2012\r\nFAL[client, MRP0]: Error 1009 fetching archived redo log from orcl\r\nThu May 31 14:11:16 2012\r\nErrors in file \/opt\/app\/oradir\/admin\/orcl_st\/bdump\/orcl_st_mrp0_23866.trc:\r\nORA-01009: missing mandatory parameter\r\nThu May 31 14:11:46 2012\r\nFAL[client, MRP0]: Error 1009 fetching archived redo log from orcl\r\nThu May 31 14:11:46 2012\r\nErrors in file \/opt\/app\/oradir\/admin\/orcl_st\/bdump\/orcl_st_mrp0_23866.trc:\r\nORA-01009: missing mandatory parameter\r\nThu May 31 14:12:16 2012\r\nFAL[client, MRP0]: Error 1009 fetching archived redo log from orcl\r\nThu May 31 14:12:16 2012\r\nErrors in file \/opt\/app\/oradir\/admin\/orcl_st\/bdump\/orcl_st_mrp0_23866.trc:\r\nORA-01009: missing mandatory parameter\r\nThu May 31 14:12:46 2012\r\nFAL[client]: Failed to request gap sequence \r\nGAP - thread 1 sequence 17433-17449\r\nDBID 1280669543 branch 752888810\r\nFAL[client]: All defined FAL servers have been attempted.<\/pre>\n<p>\u5bf9\u5e94\u7684\u8be6\u7ec6TRACE\u6587\u4ef6\u4e3a\uff1a<\/p>\n<pre lang='SQL'>*** 2012-05-31 14:11:16.139\r\nRedo shipping client performing standby login\r\n*** 2012-05-31 14:11:16.203 66535 kcrr.c\r\nLogged on to standby successfully\r\nClient logon and security negotiation successful!\r\n*** 2012-05-31 14:11:16.208 62692 kcrr.c\r\nFAL[client, MRP0]: Error 1009 fetching archived redo log from orcl\r\nORA-01009: missing mandatory parameter\r\n*** 2012-05-31 14:11:46.233\r\nRedo shipping client performing standby login\r\n*** 2012-05-31 14:11:46.316 66535 kcrr.c\r\nLogged on to standby successfully\r\nClient logon and security negotiation successful!\r\n*** 2012-05-31 14:11:46.321 62692 kcrr.c\r\nFAL[client, MRP0]: Error 1009 fetching archived redo log from orcl\r\nORA-01009: missing mandatory parameter\r\n*** 2012-05-31 14:12:16.335\r\nRedo shipping client performing standby login\r\n*** 2012-05-31 14:12:16.398 66535 kcrr.c\r\nLogged on to standby successfully\r\nClient logon and security negotiation successful!\r\n*** 2012-05-31 14:12:16.402 62692 kcrr.c\r\nFAL[client, MRP0]: Error 1009 fetching archived redo log from orcl\r\nORA-01009: missing mandatory parameter\r\n*** 2012-05-31 14:12:46.428<\/pre>\n<p>\u663e\u7136\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u548cFAL\u7684\u8bbe\u7f6e\u6709\u5173\uff0c\u67e5\u8be2STANDBY\u6570\u636e\u5e93\u7684\u542f\u52a8\u521d\u59cb\u5316\u53c2\u6570\uff0c\u53d1\u73b0\u53ea\u8bbe\u7f6e\u4e86FAL_SERVER\u800c\u6ca1\u6709\u8bbe\u7f6eFAL_CLIENT\uff1a<\/p>\n<pre lang='SQL'>Starting up ORACLE RDBMS Version: 10.2.0.4.0.\r\nSystem parameters with non-default values:\r\nprocesses = 5000\r\nsessions = 5505\r\nstreams_pool_size = 1073741824\r\nnls_date_format = YYYY-MM-DD HH24:MI:SS\r\nsga_target = 16290676736\r\ncontrol_files = \/home\/oracle\/setupFiles\/stdby.ctl\r\ndb_block_size = 8192\r\ncompatible = 10.2.0.3.0\r\nlog_archive_dest_1 = LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl_st\r\nlog_archive_dest_state_1 = ENABLE\r\nlog_archive_dest_state_2 = ENABLE\r\nlog_archive_max_processes= 4\r\nlog_archive_format = %t_%s_%r.ARC\r\nfal_server = orcl\r\ndb_file_multiblock_read_count= 16\r\ndb_create_file_dest = +DATADG\r\ndb_recovery_file_dest = +FRADG\r\ndb_recovery_file_dest_size= 1279157862400\r\nundo_management = AUTO\r\nundo_tablespace = UNDOTBS1\r\nundo_retention = 3600\r\nremote_login_passwordfile= EXCLUSIVE\r\ndb_domain = \r\nglobal_names = TRUE\r\ndispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)\r\nutl_file_dir = *\r\njob_queue_processes = 0\r\nbackground_dump_dest = \/opt\/app\/oradir\/admin\/orcl_st\/bdump\r\nuser_dump_dest = \/opt\/app\/oradir\/admin\/orcl_st\/udump\r\ncore_dump_dest = \/opt\/app\/oradir\/admin\/orcl_st\/cdump\r\naudit_file_dest = \/opt\/app\/oradir\/admin\/orcl_st\/adump\r\nopen_links = 12\r\ndb_name = orcl\r\ndb_unique_name = orcl_st\r\nopen_cursors = 5000\r\npga_aggregate_target = 6509559808\r\naq_tm_processes = 4\r\nPMON started with pid=2, OS id=28406\r\nPSP0 started with pid=3, OS id=28408\r\nMMAN started with pid=4, OS id=28410\r\nDBW0 started with pid=5, OS id=28412\r\nDBW1 started with pid=6, OS id=28414\r\nDBW2 started with pid=7, OS id=28416\r\nDBW3 started with pid=8, OS id=28418\r\nDBW4 started with pid=9, OS id=28420\r\nDBW5 started with pid=10, OS id=28422\r\nDBW6 started with pid=11, OS id=28424\r\nDBW7 started with pid=12, OS id=28426\r\nLGWR started with pid=13, OS id=28428\r\nCKPT started with pid=14, OS id=28430\r\nSMON started with pid=15, OS id=28432\r\nRECO started with pid=16, OS id=28434\r\nMMON started with pid=17, OS id=28436\r\nThu May 31 13:00:46 2012\r\nstarting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...<\/pre>\n<p>\u5728\u5370\u8c61\u4e2dFAL_CLIENT\u7684\u4f5c\u7528\u4f3c\u4e4e\u5e76\u4e0d\u5927\uff0c\u4e3b\u8981\u662f\u901a\u8fc7FAL_SERVER\u6765\u786e\u5b9a\u83b7\u53d6GAP\u7684PRIMARY\u6570\u636e\u5e93\uff0c\u83ab\u975e\u7f3a\u5c11CLIENT\u7684\u8bbe\u7f6e\u4e5f\u4f1a\u5bfc\u81f4\u5f02\u5e38\u3002\u67e5\u8be2\u4e86MOS\uff0c\u53d1\u73b0\u679c\u7136\u5982\u6b64\u3002\u5728FAL request Failed with ORA-01009 on Standby MRP trace. [ID 1329119.1]\u6587\u7ae0\u4e2d\u5bf9\u8fd9\u4e2a\u95ee\u9898\u8fdb\u884c\u4e86\u8bf4\u660e\uff0c\u4ece11.2\u4ee5\u540e\uff0cFAL_CLIENT\u4e0d\u518d\u9700\u8981\u8bbe\u7f6e\uff0c\u4f46\u662f\u5bf9\u5e9411.2\u4e4b\u524d\u7684\u7248\u672c\uff0c\u7f3a\u5c11FAL_CLIENT\u7684\u8bbe\u7f6e\u5c31\u4f1a\u5bfc\u81f4ORA-1009\u7684\u9519\u8bef\u3002<br \/>\n\u8bbe\u7f6eFAL_CLIENT\u53c2\u6570\u8bbe\u7f6e\u540e\uff0c\u9519\u8bef\u6d88\u5931\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u572810.2.0.4 DATA GUARD\u7684STANDBY\u6570\u636e\u5e93\u4e2d\uff0c\u51fa\u73b0\u4e86\u5927\u91cf\u7684ORA-1009\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Thu May 31 14:11:16 2012 FAL[client, MRP0]: Error 1009 fetching archived redo log from orcl Thu May 31 14:11:16 2012 Errors in file \/opt\/app\/oradir\/admin\/orcl_st\/bdump\/orcl_st_mrp0_23866.trc: ORA-01009: missing mandatory parameter Thu May 31 14:11:46 2012 FAL[client, MRP0]: Error &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1172\">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":[35,1027,1025,171,1026,1024],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-iU","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1172"}],"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=1172"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1172\/revisions"}],"predecessor-version":[{"id":1173,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1172\/revisions\/1173"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}