{"id":235,"date":"2011-10-24T23:17:25","date_gmt":"2011-10-24T15:17:25","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=235"},"modified":"2011-11-18T10:12:46","modified_gmt":"2011-11-18T02:12:46","slug":"data-guard%e5%87%ba%e7%8e%b0ora-16032%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=235","title":{"rendered":"DATA GUARD\u51fa\u73b0ORA-16032\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237\u5728\u914d\u7f6eDATA GUARD\u8fc7\u7a0b\u4e2d\u78b0\u5230ORA-1031\u548cORA-16032\u9519\u8bef\u3002<br \/>\n\u5176\u4e2dORA-1031\u9519\u8bef\u5f88\u76f4\u89c2\uff0c\u76f4\u63a5\u62a5\u9519\u5728\u5f52\u6863\u65f6\u6ca1\u6709\u6743\u9650\uff1a<\/p>\n<pre lang='SQL'>Wed Sep 28 15:43:26 2011\r\nALTER SYSTEM SET log_archive_dest_2='service=db1st lgwr async valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=db1st' SCOPE=BOTH;\r\nWed Sep 28 15:43:26 2011\r\nALTER SYSTEM SET log_archive_dest_state_1='enable' SCOPE=BOTH;\r\nWed Sep 28 15:43:26 2011\r\nALTER SYSTEM SET log_archive_dest_state_2='enable' SCOPE=BOTH;\r\nWed Sep 28 15:43:26 2011\r\nALTER SYSTEM SET log_archive_config='DG_CONFIG=(db1,db1st)' SCOPE=BOTH;\r\nWed Sep 28 15:43:26 2011\r\nALTER SYSTEM SET fal_client='db1' SCOPE=BOTH;\r\nWed Sep 28 15:43:26 2011\r\nALTER SYSTEM SET fal_server='db1st' SCOPE=BOTH;\r\nWed Sep 28 15:43:26 2011\r\nALTER SYSTEM SET standby_file_management='auto' SCOPE=BOTH;\r\nWed Sep 28 15:43:26 2011\r\nARC0: STARTING ARCH PROCESSES\r\nWed Sep 28 15:43:26 2011\r\nALTER SYSTEM SET log_archive_max_processes=3 SCOPE=BOTH;\r\nARC2: Archival started\r\nARC0: STARTING ARCH PROCESSES COMPLETE\r\nARC2 started with pid=242, OS id=925904\r\nWed Sep 28 15:43:26 2011\r\nALTER SYSTEM SET db_file_name_convert='\/dev\/','\/dev\/' SCOPE=SPFILE;\r\nWed Sep 28 15:43:26 2011\r\nALTER SYSTEM SET log_file_name_convert='\/dev\/','\/dev\/' SCOPE=SPFILE;\r\nWed Sep 28 15:44:02 2011\r\nError 1031 received logging on to the standby\r\nWed Sep 28 15:44:02 2011\r\nErrors in file \/oracle\/admin\/db1\/bdump\/db1_arc0_90394.trc:\r\nORA-01031: insufficient privileges\r\nPING[ARC0]: Heartbeat failed to connect to standby 'db1st'. Error is 1031.\r\nWed Sep 28 15:49:03 2011\r\nError 1031 received logging on to the standby\r\nWed Sep 28 15:49:03 2011\r\nErrors in file \/oracle\/admin\/db1\/bdump\/db1_arc0_90394.trc:\r\nORA-01031: insufficient privileges\r\nPING[ARC0]: Heartbeat failed to connect to standby 'db1st'. Error is 1031.\r\nWed Sep 28 15:54:03 2011\r\nError 1031 received logging on to the standby\r\nWed Sep 28 15:54:03 2011\r\nErrors in file \/oracle\/admin\/db1\/bdump\/db1_arc0_90394.trc:\r\nORA-01031: insufficient privileges\r\nPING[ARC0]: Heartbeat failed to connect to standby 'db1st'. Error is 1031.\r\nWed Sep 28 15:57:29 2011\r\nArchivelog restore complete. Elapsed time: 0:00:00 \r\nWed Sep 28 15:59:03 2011\r\nError 1031 received logging on to the standby\r\nWed Sep 28 15:59:03 2011\r\nErrors in file \/oracle\/admin\/db1\/bdump\/db1_arc0_90394.trc:\r\nORA-01031: insufficient privileges\r\nPING[ARC0]: Heartbeat failed to connect to standby 'db1st'. Error is 1031.<\/pre>\n<p>\u5728\u5f52\u6863\u7684\u8be6\u7ec6\u65e5\u5fd7\u4e2d\uff0c\u9519\u8bef\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>\/oracle\/admin\/db1\/bdump\/db1_arc0_90394.trc\r\nOracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP and Data Mining options\r\nORACLE_HOME = \/oracle\/product\/db10gr2\r\nSystem name: AIX\r\nNode name: ser1\r\nRelease: 3\r\nVersion: 5\r\nMachine: 00C23C4F4C00\r\nInstance name: db1\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 14\r\nUnix process pid: 90394, image: oracle@ser1 (ARC0)\r\n*** 2011-09-28 15:42:05.012\r\n*** SERVICE NAME:(SYS$BACKGROUND) 2011-09-28 15:42:05.006\r\n*** SESSION ID:(541.1) 2011-09-28 15:42:05.006\r\nRedo shipping client performing standby login\r\nOCISessionBegin failed -1\r\n.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges\r\n'\r\n*** 2011-09-28 15:42:05.101 61287 kcrr.c\r\nError 1031 received logging on to the standby\r\nError 1031 connecting to destination LOG_ARCHIVE_DEST_1 standby host 'db1st'\r\nkcrrwupirfs KCRROCIS Handle 0xfffffffffffb608 has NULL OCI servicehandle - Returning success\r\nError 1031 attaching to destination LOG_ARCHIVE_DEST_1 standby host 'db1st'\r\nORA-01031: insufficient privileges\r\n*** 2011-09-28 15:42:05.101 59530 kcrr.c\r\nkcrrfail: dest:1 err:1031 force:0 blast:1\r\nkcrrwupirfs KCRROCIS Handle 0xfffffffffffb608 has NULL OCI servicehandle - Returning success\r\nkcrrwkx: unknown error:1031\r\nORA-16055: FAL request rejected\r\nARCH: Connecting to console port...\r\nARCH: Connecting to console port...\r\nRedo shipping client performing standby login\r\nOCISessionBegin failed -1\r\n.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges\r\n'\r\n*** 2011-09-28 15:42:05.565 61287 kcrr.c\r\nError 1031 received logging on to the standby\r\nError 1031 connecting to destination LOG_ARCHIVE_DEST_1 standby host 'db1st'\r\nkcrrwupirfs KCRROCIS Handle 0xfffffffffffb608 has NULL OCI servicehandle - Returning success\r\nError 1031 attaching to destination LOG_ARCHIVE_DEST_1 standby host 'db1st'\r\nORA-01031: insufficient privileges\r\n*** 2011-09-28 15:42:05.565 59530 kcrr.c\r\nkcrrfail: dest:1 err:1031 force:0 blast:1\r\nkcrrwupirfs KCRROCIS Handle 0xfffffffffffb608 has NULL OCI servicehandle - Returning success\r\nkcrrwkx: unknown error:1031\r\nORA-16055: FAL request rejected\r\nARCH: Connecting to console port...\r\nARCH: Connecting to console port...\r\nRedo shipping client performing standby login\r\nOCISessionBegin failed -1\r\n.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges\r\n'\r\n*** 2011-09-28 15:42:05.679 61287 kcrr.c\r\nError 1031 received logging on to the standby\r\nError 1031 connecting to destination LOG_ARCHIVE_DEST_1 standby host 'db1st'\r\nkcrrwupirfs KCRROCIS Handle 0xfffffffffffb608 has NULL OCI servicehandle - Returning success\r\nError 1031 attaching to destination LOG_ARCHIVE_DEST_1 standby host 'db1st'\r\nORA-01031: insufficient privileges<\/pre>\n<p>\u5bfc\u81f4ORA-1031\u9519\u8bef\u7684\u95ee\u9898\u5f88\u7b80\u5355\uff0c\u5f52\u6863\u8fdb\u7a0b\u6ca1\u6709\u6743\u9650\u5c06\u5f52\u6863\u65e5\u5fd7\u5199\u5230\u8fdc\u7aef\uff0c\u53ea\u9700\u8981\u5c06\u4e3b\u5e93\u7684\u5bc6\u7801\u6587\u4ef6\u62f7\u8d1d\u5230\u8fdc\u7aef\u7684\u5bf9\u5e94\u4f4d\u7f6e\u4e0a\u65e2\u53ef\u3002<br \/>\n\u4e0d\u8fc7\u6743\u9650\u95ee\u9898\u89e3\u51b3\u540e\uff0c\u5f52\u6863\u53c8\u51fa\u73b0\u65b0\u7684\u9519\u8bef\uff1a<\/p>\n<pre lang='SQL'>Thu Sep 29 00:06:19 2011\r\nARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (16032)\r\nARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned\r\nThu Sep 29 00:06:19 2011\r\nErrors in file \/oracle\/admin\/db1\/bdump\/db1_arc0_90394.trc:\r\nORA-16032: parameter destination string cannot be translated\r\nFAL[server, ARC0]: Error 16032 creating remote archivelog file 'db1st'\r\nThu Sep 29 00:06:19 2011\r\nARC2: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (16032)\r\nARC2: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned\r\nThu Sep 29 00:06:19 2011\r\nErrors in file \/oracle\/admin\/db1\/bdump\/db1_arc2_925904.trc:\r\nORA-16032: parameter destination string cannot be translated\r\nFAL[server, ARC2]: Error 16032 creating remote archivelog file 'db1st'\r\nFAL[server, ARC2]: FAL archive failed, see trace file.\r\nThu Sep 29 00:06:19 2011\r\nErrors in file \/oracle\/admin\/db1\/bdump\/db1_arc2_925904.trc:\r\nORA-16055: FAL request rejected\r\nARCH: FAL archive failed. Archiver continuing\r\nThu Sep 29 00:06:19 2011\r\nORACLE Instance db1 - Archival Error. Archiver continuing.<\/pre>\n<p>\u5bf9\u5e94\u7684\u5f52\u6863\u8fdb\u7a0b\u7684\u8be6\u7ec6\u9519\u8bef\uff1a<\/p>\n<pre lang='SQL'>*** 2011-09-29 00:06:19.480\r\nRedo shipping client performing standby login\r\n*** 2011-09-29 00:06:19.583 65194 kcrr.c\r\nLogged on to standby successfully\r\nClient logon and security negotiation successful!\r\ntkcrrsarc: (WARN) Failed to find ARCH for message (message:0xa)\r\ntkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0xa)\r\ntkcrrsarc: (WARN) Failed to find ARCH for message (message:0xa)\r\ntkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0xa)\r\ntkcrrsarc: (WARN) Failed to find ARCH for message (message:0xa)\r\ntkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0xa)\r\ntkcrrsarc: (WARN) Failed to find ARCH for message (message:0x2)\r\ntkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x2)\r\nError 16032 creating standby archive log file at host 'db1st'\r\n*** 2011-09-29 00:06:19.843 61287 kcrr.c\r\nARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (16032)\r\n*** 2011-09-29 00:06:19.843 61287 kcrr.c\r\nARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned\r\nORA-16032: parameter destination string cannot be translated\r\n*** 2011-09-29 00:06:19.852 59530 kcrr.c\r\nkcrrfail: dest:2 err:16032 force:0 blast:1\r\nkcrrwkx: unknown error:16032\r\nORA-16055: FAL request rejected\r\nARCH: Connecting to console port...\r\nARCH: Connecting to console port...\r\nFAL[server]: Selected inactive destination; resetting temporarily\r\nRedo shipping client performing standby login\r\n*** 2011-09-29 00:06:22.106 65194 kcrr.c\r\nLogged on to standby successfully\r\nClient logon and security negotiation successful!\r\nError 16032 creating standby archive log file at host 'db1st'\r\n*** 2011-09-29 00:06:22.157 61287 kcrr.c\r\nARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (16032)\r\n*** 2011-09-29 00:06:22.157 61287 kcrr.c\r\nARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned\r\nORA-16032: parameter destination string cannot be translated\r\n*** 2011-09-29 00:06:22.157 59530 kcrr.c\r\nkcrrfail: dest:2 err:16032 force:0 blast:1\r\nkcrrwkx: unknown error:16032\r\nORA-16055: FAL request rejected\r\nARCH: Connecting to console port...\r\nARCH: Connecting to console port...\r\nFAL[server]: Selected inactive destination; resetting temporarily\r\nRedo shipping client performing standby login<\/pre>\n<p>\u5176\u5b9e\u5bfc\u81f4\u8fd9\u4e2aORA-16032\u9519\u8bef\u7684\u539f\u56e0\u4e5f\u5f88\u7b80\u5355\uff0c\u4ece\u6700\u524d\u9762\u7684\u4ee3\u7801\u53ef\u4ee5\u770b\u51fa\uff0c\u5728\u914d\u7f6e\u521d\u59cb\u5316\u53c2\u6570\u7684\u65f6\u5019\u5148\u914d\u7f6e\u4e86LOG_ARCHIVE_DEST_N\uff0c\u7136\u540e\u624d\u914d\u7f6eLOG_ARCHIVE_CONFIG\u53c2\u6570\uff0c\u8fd9\u5c31\u4f7f\u5f97LOG_ARCHIVE_DEST_N\u53c2\u6570\u751f\u6548\u7684\u65f6\u5019\u65e0\u6cd5\u4eceDG_CONFIG\u4e2d\u83b7\u53d6\u5230\u54cd\u5e94\u7684\u914d\u7f6e\uff0c\u5bfc\u81f4\u4e86ORA-16032\u7684\u9519\u8bef\u3002<br \/>\n\u8981\u907f\u514d\u8fd9\u4e2a\u9519\u8bef\u5f88\u7b80\u5355\uff0c\u53ea\u9700\u8981\u5148\u914d\u7f6eLOG_ARCHIVE_CONFIG\uff0c\u7136\u540e\u518d\u914d\u7f6eLOG_ARCHIVE_DEST_N\u53c2\u6570\u65e2\u53ef\u3002\u5bf9\u4e8e\u5df2\u7ecf\u51fa\u73b0\u7684\u8fd9\u4e2a\u9519\u8bef\uff0c\u53ea\u9700\u8981\u901a\u8fc7\u53c2\u6570LOG_ARCHIVE_DEST_STATE_N\u6682\u505c\u65e5\u5fd7\uff0c\u968f\u540e\u5728\u542f\u7528\uff0cOracle\u5c31\u4f1a\u91cd\u65b0\u5206\u6790LOG_ARCHIVE_DEST_N\u4e2d\u7684\u914d\u7f6e\uff1a<\/p>\n<pre lang='SQL'>Thu Sep 29 12:40:42 2011\r\nErrors in file \/oracle\/admin\/db1\/bdump\/db1_arc0_90394.trc:\r\nORA-16032: parameter destination string cannot be translated\r\nThu Sep 29 12:40:42 2011\r\nFAL[server, ARC0]: FAL archive failed, see trace file.\r\nThu Sep 29 12:40:42 2011\r\nErrors in file \/oracle\/admin\/db1\/bdump\/db1_arc0_90394.trc:\r\nORA-16055: FAL request rejected\r\nARCH: FAL archive failed. Archiver continuing\r\nThu Sep 29 12:40:42 2011\r\nORACLE Instance db1 - Archival Error. Archiver continuing.\r\nThu Sep 29 12:46:24 2011\r\nALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH;\r\nThu Sep 29 13:57:56 2011\r\nFAL[server, ARC2]: FAL archive failed, see trace file.\r\nThu Sep 29 13:57:56 2011\r\nErrors in file \/oracle\/admin\/db1\/bdump\/db1_arc2_925904.trc:\r\nORA-16055: FAL request rejected\r\nARCH: FAL archive failed. Archiver continuing\r\nThu Sep 29 13:57:56 2011\r\nORACLE Instance db1 - Archival Error. Archiver continuing.\r\nThu Sep 29 13:57:56 2011\r\nARCH: Possible network disconnect with primary database\r\nThu Sep 29 13:57:56 2011\r\nORACLE Instance db1 - Archival Error. Archiver continuing.\r\nThu Sep 29 13:58:26 2011\r\nFAL[server]: Fail to queue the whole FAL gap\r\nGAP - thread 1 sequence 3357-3363\r\nDBID 1488093310 branch 682019072\r\nThu Sep 29 14:09:42 2011\r\nFAL[server, ARC0]: FAL archive failed, see trace file.\r\nThu Sep 29 14:09:42 2011\r\nErrors in file \/oracle\/admin\/db1\/bdump\/db1_arc0_90394.trc:\r\nORA-16055: FAL request rejected\r\nARCH: FAL archive failed. Archiver continuing\r\nThu Sep 29 14:09:42 2011\r\nORACLE Instance db1 - Archival Error. Archiver continuing.\r\nThu Sep 29 14:09:42 2011\r\nFAL[server, ARC2]: FAL archive failed, see trace file.\r\nThu Sep 29 14:09:42 2011\r\nErrors in file \/oracle\/admin\/db1\/bdump\/db1_arc2_925904.trc:\r\nORA-16055: FAL request rejected\r\nARCH: FAL archive failed. Archiver continuing\r\nThu Sep 29 14:09:57 2011\r\nALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;\r\nFAL[server]: Fail to queue the whole FAL gap\r\nGAP - thread 1 sequence 3361-3363\r\nDBID 1488093310 branch 682019072\r\nLNS1 started with pid=128, OS id=667772\r\nThu Sep 29 16:14:17 2011\r\nThread 1 advanced to log sequence 3366\r\nCurrent log# 2 seq# 3366 mem# 0: \/dev\/rredo02\r\nThu Sep 29 16:14:18 2011\r\n******************************************************************\r\nLGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2\r\n******************************************************************\r\nLNS: Standby redo logfile selected for thread 1 sequence 3366 for destination LOG_ARCHIVE_DEST_2\r\nThu Sep 29 16:14:23 2011\r\nFAL[server]: Fail to queue the whole FAL gap\r\nGAP - thread 1 sequence 3365-3365\r\nDBID 1488093310 branch 682019072\r\nThu Sep 29 16:14:25 2011\r\nARC2: Standby redo logfile selected for thread 1 sequence 3365 for destination LOG_ARCHIVE_DEST_2<\/pre>\n<p>\u5c06\u53c2\u6570\u91cd\u7f6e\u540e\uff0c\u9519\u8bef\u6d88\u5931\uff0c\u8fdc\u7aef\u5f52\u6863\u987a\u5229\u5f00\u59cb\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u5728\u914d\u7f6eDATA GUARD\u8fc7\u7a0b\u4e2d\u78b0\u5230ORA-1031\u548cORA-16032\u9519\u8bef\u3002 \u5176\u4e2dORA-1031\u9519\u8bef\u5f88\u76f4\u89c2\uff0c\u76f4\u63a5\u62a5\u9519\u5728\u5f52\u6863\u65f6\u6ca1\u6709\u6743\u9650\uff1a Wed Sep 28 15:43:26 2011 ALTER SYSTEM SET log_archive_dest_2=&#8217;service=db1st lgwr async valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=db1st&#8217; SCOPE=BOTH; Wed Sep 28 15:43:26 2011 ALTER SYSTEM SET log_archive_dest_state_1=&#8217;enable&#8217; SCOPE=BOTH; Wed Sep 28 15:43:26 2011 ALTER SYSTEM SET log_archive_dest_state_2=&#8217;enable&#8217; SCOPE=BOTH; Wed Sep 28 &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=235\">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":[3],"tags":[35,168,167,169,165,166],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-3N","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/235"}],"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=235"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/235\/revisions"}],"predecessor-version":[{"id":303,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/235\/revisions\/303"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}