{"id":267,"date":"2011-11-06T18:40:42","date_gmt":"2011-11-06T10:40:42","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=267"},"modified":"2011-11-06T20:49:15","modified_gmt":"2011-11-06T12:49:15","slug":"ora-600kcrrupirfs-20%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=267","title":{"rendered":"ORA-600(kcrrupirfs.20)\u9519\u8bef"},"content":{"rendered":"<p>\u5728\u5ba2\u6237\u7684\u6570\u636e\u5e93\u544a\u8b66\u65e5\u5fd7\u4e2d\u53d1\u73b0\u8fd9\u4e2a\u9519\u8bef\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Thu Sep 29 14:29:26 2011\r\nalter database force logging\r\nThu Sep 29 14:29:26 2011\r\nALTER DATABASE FORCE LOGGING command is waiting for existingdirect writes to finish. This may take a long time.\r\nCompleted: alter database force logging\r\nLAST_CHECK\r\nThu Sep 29 14:32:54 2011\r\nALTER SYSTEM SET log_archive_dest_2='service=dbnamepri lgwr async valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=dbnamepri' SCOPE=BOTH;\r\nThu Sep 29 14:33:08 2011\r\nErrors in file \/oracle\/admin\/dbnamedb\/bdump\/dbnamedb_arc0_262532.trc:\r\nORA-16057: DGID from server not in Data Guard configuration\r\nThu Sep 29 14:33:08 2011\r\nPING[ARC0]: Heartbeat failed to connect to standby 'dbnamepri'. Error is 16057.\r\nThu Sep 29 14:34:01 2011\r\nALTER SYSTEM SET log_archive_config='DG_CONFIG=(dbnamedb,dbnamepri)' SCOPE=BOTH;\r\nThu Sep 29 14:34:11 2011\r\nALTER SYSTEM SET fal_client='dbnamedb' SCOPE=BOTH;\r\nThu Sep 29 14:34:12 2011\r\nALTER SYSTEM SET fal_server='dbnamepri' SCOPE=BOTH;\r\nThu Sep 29 14:34:23 2011\r\nALTER SYSTEM SET standby_file_management='auto' SCOPE=BOTH;\r\nThu Sep 29 14:34:33 2011\r\nARC0: STARTING ARCH PROCESSES\r\nThu Sep 29 14:34:33 2011\r\nALTER SYSTEM SET log_archive_max_processes=3 SCOPE=BOTH;\r\nThu Sep 29 14:34:33 2011\r\nALTER SYSTEM SET db_file_name_convert='\/dev\/','\/dev\/' SCOPE=SPFILE;\r\nARC2: Archival started\r\nARC0: STARTING ARCH PROCESSES COMPLETE\r\nARC2 started with pid=83, OS id=1020046\r\nThu Sep 29 14:34:34 2011\r\nALTER SYSTEM SET log_file_name_convert='\/dev\/','\/dev\/' SCOPE=SPFILE;\r\nThu Sep 29 14:37:28 2011\r\nALTER SYSTEM SET log_archive_dest_state_1='enable' SCOPE=BOTH;\r\nThu Sep 29 14:37:29 2011\r\nALTER SYSTEM SET log_archive_dest_state_2='enable' SCOPE=BOTH;\r\nThu Sep 29 14:38:16 2011\r\nARCH: Possible network disconnect with primary database\r\nLNS1 started with pid=133, OS id=745664\r\nThu Sep 29 15:12:11 2011\r\nThread 1 advanced to log sequence 58300\r\nCurrent log# 2 seq# 58300 mem# 0: \/dev\/ryredodbs02\r\nThu Sep 29 15:12:12 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 58300 for destination LOG_ARCHIVE_DEST_2\r\nThu Sep 29 15:15:02 2011\r\nThread 1 advanced to log sequence 58301\r\nCurrent log# 1 seq# 58301 mem# 0: \/dev\/ryredodbs01\r\nThu Sep 29 15:15:03 2011\r\nLNS: Standby redo logfile selected for thread 1 sequence 58301 for destination LOG_ARCHIVE_DEST_2\r\nThu Sep 29 15:15:51 2011\r\nErrors in file \/oracle\/admin\/dbnamedb\/bdump\/dbnamedb_arc0_262532.trc:\r\nORA-00600: internal error code, arguments: [kcrrupirfs.20], [3], [0], [], [], [], [], []\r\nThu Sep 29 15:15:53 2011\r\nErrors in file \/oracle\/admin\/dbnamedb\/bdump\/dbnamedb_arc0_262532.trc:\r\nORA-00600: internal error code, arguments: [kcrrupirfs.20], [3], [0], [], [], [], [], []\r\nThu Sep 29 15:15:53 2011\r\nErrors in file \/oracle\/admin\/dbnamedb\/bdump\/dbnamedb_arc0_262532.trc:\r\nORA-00600: internal error code, arguments: [kcrrupirfs.20], [3], [0], [], [], [], [], []\r\nThu Sep 29 15:15:53 2011\r\nErrors in file \/oracle\/admin\/dbnamedb\/bdump\/dbnamedb_arc0_262532.trc:\r\nORA-00600: internal error code, arguments: [kcrrupirfs.20], [3], [0], [], [], [], [], []\r\nThu Sep 29 15:15:53 2011\r\nErrors in file \/oracle\/admin\/dbnamedb\/bdump\/dbnamedb_arc0_262532.trc:\r\nORA-00600: internal error code, arguments: [kcrrupirfs.20], [3], [0], [], [], [], [], []\r\nThu Sep 29 15:15:53 2011\r\nErrors in file \/oracle\/admin\/dbnamedb\/bdump\/dbnamedb_arc0_262532.trc:\r\nORA-00600: internal error code, arguments: [kcrrupirfs.20], [3], [0], [], [], [], [], []\r\nThu Sep 29 15:15:55 2011\r\nARCH: Detected ARCH process failure\r\nARCH: STARTING ARCH PROCESSES\r\nARC0: Archival started\r\nARCH: STARTING ARCH PROCESSES COMPLETE\r\nARC0 started with pid=112, OS id=1052728\r\nARC0: Becoming the heartbeat ARCH<\/pre>\n<p>\u5ba2\u6237\u768410G DATA GUARD\u73af\u5883\uff0c\u5728\u65b0\u589e\u4e00\u4e2a\u7269\u7406DATA GUARD\u914d\u7f6e\u7684\u65f6\u5019\u51fa\u73b0\u4e86ORA-600\u9519\u8bef\u3002<br \/>\n\u8fd9\u4e2aORA-600[kcrrupirfs.20]\u7684\u9519\u8bef\u5728metalink\u4e0a\u7684\u8bb0\u5f55\u5e76\u4e0d\u591a\uff0c\u7edd\u5927\u90e8\u5206\u90fd\u662f\u548c\u5f52\u6863\u76f8\u5173\uff0c\u4e0d\u8fc7\u5177\u4f53\u5206\u6790\u5bf9\u4e8e\u5f53\u524d\u9519\u8bef\u7684\u501f\u9274\u5e76\u4e0d\u5927\u3002<br \/>\n\u4e0d\u8fc7\u4ed4\u7ec6\u770b\u4e86\u4e00\u4e0b\u9519\u8bef\u53d1\u751f\u4e4b\u524d\u6240\u8fdb\u884c\u7684\u4fee\u6539\uff0c\u5c31\u57fa\u672c\u6e05\u695a\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u4e86\u3002<br \/>\n\u5ba2\u6237\u5728\u914d\u7f6e\u65b0\u7684DATA GUARD\u7684\u65f6\u5019\uff0c\u5148\u8bbe\u7f6e\u4e86LOG_ARCHIVE_DEST_N\u53c2\u6570\uff0c\u7136\u540e\u624d\u8bbe\u7f6eLOG_ARCHIVE_CONFIG\u53c2\u6570\u3002\u800cOracle\u4f1a\u5728\u914d\u7f6eLOG_ARCHIVE_DEST_N\u53c2\u6570\u7684\u65f6\u5019\uff0c\u6839\u636eDB_UNIQUE_NAME\u7684\u503c\u5230LOG_ARCHIVE_CONFIG\u7684DG_CONFIG\u914d\u7f6e\u4e2d\u5bfb\u627e\u5bf9\u5e94\u7684\u503c\uff0c\u5982\u679c\u6ca1\u6709\u627e\u5230\uff0c\u5c31\u4f1a\u5f15\u53d1\u9519\u8bef\u3002\u800c\u968f\u540e\u8bbe\u7f6eLOG_ARCHIVE_CONFIG\u53c2\u6570\u7684\u65f6\u5019\u5e76\u4e0d\u4f1a\u5f15\u53d1LOG_ARCHIVE_DEST_N\u53c2\u6570\u91cd\u65b0\u89e3\u6790\uff0c\u6240\u4ee5\u8fd9\u4e2a\u95ee\u9898\u4e00\u76f4\u6ca1\u6709\u89e3\u51b3\u3002<br \/>\n\u4ee5\u524d\u8fd9\u79cd\u9519\u8bef\u78b0\u5230\u8fc7\u5f88\u591a\u6b21\u4e86\uff0c\u4f46\u662f\u51fa\u73b0ORA-600\u9519\u8bef\u7684\u8fd8\u662f\u7b2c\u4e00\u6b21\u3002\u89e3\u51b3\u65b9\u6cd5\u5f88\u7b80\u5355\uff0c\u53ea\u9700\u8981\u8bbe\u7f6eLOG_ARCHIVE_DEST_STATE_N\u53c2\u6570\u5c31\u53ef\u4ee5\u4f7f\u5f97LOG_ARCHIVE_DEST_N\u91cd\u65b0\u8fdb\u884c\u89e3\u6790\uff1a<\/p>\n<pre lang='SQL'>Thu Sep 29 15:44:24 2011\r\nErrors in file \/oracle\/admin\/dbnamedb\/bdump\/dbnamedb_arc0_803104.trc:\r\nORA-00600: internal error code, arguments: [kcrrupirfs.20], [3], [0], [], [], [], [], []\r\nThu Sep 29 15:44:24 2011\r\nErrors in file \/oracle\/admin\/dbnamedb\/bdump\/dbnamedb_arc0_803104.trc:\r\nORA-00600: internal error code, arguments: [kcrrupirfs.20], [3], [0], [], [], [], [], []\r\nThu Sep 29 15:44:25 2011\r\nARCH: Detected ARCH process failure\r\nARCH: STARTING ARCH PROCESSES\r\nARC0: Archival started\r\nARCH: STARTING ARCH PROCESSES COMPLETE\r\nARC0 started with pid=112, OS id=876882\r\nARC0: Becoming the heartbeat ARCH\r\nThu Sep 29 15:44:25 2011\r\nErrors in file \/oracle\/admin\/dbnamedb\/bdump\/dbnamedb_arc0_876882.trc:\r\nORA-00317: file type 0 in header is not log file\r\nORA-00334: archived log: '\/arch\/1_58212_665274343.dbf'\r\nThu Sep 29 15:44:25 2011\r\nErrors in file \/oracle\/admin\/dbnamedb\/bdump\/dbnamedb_arc0_876882.trc:\r\nORA-00317: file type 0 in header is not log file\r\nORA-00334: archived log: '\/arch\/1_58212_665274343.dbf'\r\nFAL[server, ARC0]: FAL archive failed, see trace file.\r\nThu Sep 29 15:44:25 2011\r\nErrors in file \/oracle\/admin\/dbnamedb\/bdump\/dbnamedb_arc0_876882.trc:\r\nORA-16055: FAL request rejected\r\nARCH: FAL archive failed. Archiver continuing\r\nThu Sep 29 15:44:25 2011\r\nORACLE Instance dbnamedb - Archival Error. Archiver continuing.\r\nThu Sep 29 15:44:39 2011\r\nALTER SYSTEM SET log_archive_dest_state_2='reset' SCOPE=BOTH;\r\nThu Sep 29 15:44:45 2011\r\nErrors in file \/oracle\/admin\/dbnamedb\/udump\/dbnamedb_fal_1024178.trc:\r\nORA-00317: file type 0 in header is not log file\r\nORA-00334: archived log: '\/arch\/1_58212_665274343.dbf'\r\nThu Sep 29 15:44:46 2011\r\nFAL[server]: Fail to queue the whole FAL gap\r\nGAP - thread 1 sequence 58212-58212\r\nDBID 381481151 branch 665274343\r\nThu Sep 29 15:55:49 2011\r\nALTER SYSTEM SET log_archive_dest_state_2='enable' SCOPE=BOTH;\r\nThu Sep 29 16:02:48 2011\r\nThread 1 advanced to log sequence 58302\r\nCurrent log# 3 seq# 58302 mem# 0: \/dev\/ryredodbs03\r\nThu Sep 29 16:02:49 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 58302 for destination LOG_ARCHIVE_DEST_2\r\nThu Sep 29 16:17:06 2011\r\nThread 1 advanced to log sequence 58303\r\nCurrent log# 2 seq# 58303 mem# 0: \/dev\/ryredodbs02\r\nThu Sep 29 16:17:07 2011\r\nLNS: Standby redo logfile selected for thread 1 sequence 58303 for destination LOG_ARCHIVE_DEST_2\r\nThu Sep 29 16:47:40 2011\r\nThread 1 advanced to log sequence 58304\r\nCurrent log# 1 seq# 58304 mem# 0: \/dev\/ryredodbs01\r\nThu Sep 29 16:47:41 2011\r\nLNS: Standby redo logfile selected for thread 1 sequence 58304 for destination LOG_ARCHIVE_DEST_2<\/pre>\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u8bbe\u7f6eLOG_ARCHIVE_DEST_STATE_2\u53c2\u6570\u540e\uff0c\u95ee\u9898\u89e3\u51b3\u3002<br \/>\n\u5bf9\u4e8e\u7269\u7406DATA GUARD\u5728\u8bbe\u7f6e\u53c2\u6570\u65f6\uff0c\u4e00\u5b9a\u8981\u6ce8\u610f\u987a\u5e8f\uff0cLOG_ARCHIVE_CONFIG\u53c2\u6570\u8981\u5728LOG_ARCHIVE_DEST_N\u4e4b\u524d\u8fdb\u884c\u8bbe\u7f6e\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u5ba2\u6237\u7684\u6570\u636e\u5e93\u544a\u8b66\u65e5\u5fd7\u4e2d\u53d1\u73b0\u8fd9\u4e2a\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a Thu Sep 29 14:29:26 2011 alter database force logging Thu Sep 29 14:29:26 2011 ALTER DATABASE FORCE LOGGING command is waiting for existingdirect writes to finish. This may take a long time. Completed: alter database force logging LAST_CHECK &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=267\">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":[168,196,167,169,197,8],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-4j","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/267"}],"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=267"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/267\/revisions"}],"predecessor-version":[{"id":268,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/267\/revisions\/268"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}