{"id":884,"date":"2012-05-29T23:39:59","date_gmt":"2012-05-29T15:39:59","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=884"},"modified":"2012-06-02T00:42:14","modified_gmt":"2012-06-01T16:42:14","slug":"ora-600kccsbck_first%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=884","title":{"rendered":"ORA-600(kccsbck_first)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237Oracle10.2.0.4 RAC\u6570\u636e\u5e93\u51fa\u73b0ORA-600(kccsbck_first)\u9519\u8bef\u3002<br \/>\n\u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Wed Oct 14 17:43:34 2009\r\nALTER DATABASE FORCE LOGGING\r\nWed Oct 14 17:43:34 2009\r\nORA-12920 signalled during: ALTER DATABASE FORCE LOGGING...\r\nWed Oct 14 17:43:42 2009\r\nALTER SYSTEM SET db_unique_name='PRIMARY' SCOPE=SPFILE;\r\nWed Oct 14 17:44:01 2009\r\nALTER SYSTEM SET log_archive_config='DG_CONFIG=(primary,standby)' SCOPE=SPFILE;\r\nWed Oct 14 17:44:11 2009\r\nALTER SYSTEM SET log_archive_dest_state_1='ENABLE' SCOPE=SPFILE;\r\nWed Oct 14 17:44:20 2009\r\nALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=SPFILE;\r\nWed Oct 14 17:44:27 2009\r\nALTER SYSTEM SET remote_login_passwordfile='EXCLUSIVE' SCOPE=SPFILE;\r\nWed Oct 14 17:44:39 2009\r\nALTER SYSTEM SET log_archive_format='%t_%s_%r.arc' SCOPE=SPFILE;\r\nWed Oct 14 17:44:47 2009\r\nALTER SYSTEM SET log_archive_max_processes=4 SCOPE=SPFILE;\r\nWed Oct 14 17:44:57 2009\r\nALTER SYSTEM SET fal_client='PRIMARY' SCOPE=SPFILE;\r\nWed Oct 14 17:45:03 2009\r\nALTER SYSTEM SET fal_server='STANDBY' SCOPE=SPFILE;\r\nWed Oct 14 17:45:20 2009\r\nALTER SYSTEM SET standby_file_management='MANUAL' SCOPE=SPFILE;\r\nWed Oct 14 17:45:34 2009\r\nShutting down instance: further logons disabled\r\nWed Oct 14 17:45:35 2009\r\nStopping background process CJQ0\r\nWed Oct 14 17:45:35 2009\r\nStopping background process MMNL\r\nWed Oct 14 17:45:36 2009\r\nStopping background process MMON\r\nWed Oct 14 17:45:37 2009\r\nShutting down instance (immediate)\r\nLicense high water mark = 7\r\nWed Oct 14 17:45:37 2009\r\nStopping Job queue slave processes, flags = 7\r\nWed Oct 14 17:45:37 2009\r\nJob queue slave processes stopped\r\nWed Oct 14 17:45:39 2009\r\nALTER DATABASE CLOSE NORMAL\r\nWed Oct 14 17:45:39 2009\r\nSMON: disabling tx recovery\r\nSMON: disabling cache recovery\r\nWed Oct 14 17:45:41 2009\r\nShutting down archive processes\r\nArchiving is disabled\r\nWed Oct 14 17:45:46 2009\r\nARCH shutting down\r\nARC1: Archival stopped\r\nWed Oct 14 17:45:51 2009\r\nARCH shutting down\r\nARC0: Archival stopped\r\nWed Oct 14 17:45:52 2009\r\nThread 2 closed at log sequence 1\r\nSuccessful close of redo thread 2\r\nWed Oct 14 17:45:52 2009\r\nCompleted: ALTER DATABASE CLOSE NORMAL\r\nWed Oct 14 17:45:52 2009\r\nALTER DATABASE DISMOUNT\r\nCompleted: ALTER DATABASE DISMOUNT\r\nARCH: Archival disabled due to shutdown: 1089\r\nShutting down archive processes\r\nArchiving is disabled\r\nArchive process shutdown avoided: 0 active\r\nARCH: Archival disabled due to shutdown: 1089\r\nShutting down archive processes\r\nArchiving is disabled\r\nArchive process shutdown avoided: 0 active\r\nWed Oct 14 17:45:57 2009\r\nfreeing rdom 0\r\nWed Oct 14 17:47:03 2009\r\nStarting ORACLE instance (normal)\r\nLICENSE_MAX_SESSION = 0\r\nLICENSE_SESSIONS_WARNING = 0\r\nInterface type 1 lan906 192.168.0.0 configured from OCR for use as a cluster interconnect\r\nInterface type 1 lan905 10.200.32.0 configured from OCR for use as a public interface\r\nPicked latch-free SCN scheme 3\r\nAutotune of undo retention is turned on. \r\nLICENSE_MAX_USERS = 0\r\nSYS auditing is disabled\r\nksdpec: called for event 13740 prior to event group initialization\r\nStarting up ORACLE RDBMS Version: 10.2.0.4.0.\r\nSystem parameters with non-default values:\r\nprocesses = 600\r\nsessions = 665\r\ntimed_statistics = TRUE\r\nsga_max_size = 17179869184\r\nlock_sga = TRUE\r\n__shared_pool_size = 1644167168\r\n__large_pool_size = 16777216\r\n__java_pool_size = 16777216\r\n__streams_pool_size = 0\r\nspfile = \/dev\/data\/ORCL1_spfile\r\nsga_target = 12029263872\r\ncontrol_files = \/dev\/data\/ORCL1_control01, \/dev\/data\/ORCL1_control02, \/dev\/data\/ORCL1_control03\r\ncontrol_file_record_keep_time= 15\r\ndb_block_size = 8192\r\n__db_cache_size = 10284433408\r\ndb_writer_processes = 4\r\ncompatible = 10.2.0.3.0\r\nlog_archive_config = DG_CONFIG=(primary,standby)\r\nlog_archive_dest_1 = LOCATION=\/orabak\/arch\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_client = PRIMARY\r\nfal_server = STANDBY\r\nlog_buffer = 52428800\r\ndb_file_multiblock_read_count= 32\r\ncluster_database = TRUE\r\ncluster_database_instances= 2\r\nstandby_file_management = MANUAL\r\nthread = 2\r\nfast_start_mttr_target = 600\r\ninstance_number = 2\r\nundo_management = AUTO\r\nundo_tablespace = UNDOTBS2\r\nundo_retention = 43200\r\nremote_login_passwordfile= EXCLUSIVE\r\ndb_domain = \r\nremote_listener = LISTENERS_ORCL1\r\njob_queue_processes = 10\r\nbitmap_merge_area_size = 1048576\r\nparallel_max_servers = 80\r\nbackground_dump_dest = \/u01\/app\/oracle\/admin\/orcl1\/bdump\r\nuser_dump_dest = \/u01\/app\/oracle\/admin\/orcl1\/udump\r\nmax_dump_file_size = 20971520\r\ncore_dump_dest = \/u01\/app\/oracle\/admin\/orcl1\/cdump\r\naudit_file_dest = \/u01\/app\/oracle\/admin\/orcl1\/adump\r\nhpux_sched_noage = 178\r\ndb_name = orcl1\r\ndb_unique_name = PRIMARY\r\nopen_cursors = 1500\r\npga_aggregate_target = 2147483648\r\nworkarea_size_policy = Auto\r\nCluster communication is configured to use the following interface(s) for this instance\r\n192.168.0.102\r\nWed Oct 14 17:47:10 2009\r\ncluster interconnect IPC version:Oracle UDP\/IP (generic)\r\nIPC Vendor 1 proto 2\r\nPMON started with pid=2, OS id=22684\r\nDIAG started with pid=4, OS id=22706\r\nPSP0 started with pid=6, OS id=22708\r\nLMON started with pid=8, OS id=22710\r\nLMD0 started with pid=10, OS id=22712\r\nLMS0 started with pid=12, OS id=22714\r\nLMS1 started with pid=14, OS id=22716\r\nLMS2 started with pid=16, OS id=22723\r\nLMS3 started with pid=18, OS id=22725\r\nMMAN started with pid=20, OS id=22727\r\nDBW0 started with pid=22, OS id=22729\r\nDBW1 started with pid=24, OS id=22731\r\nDBW2 started with pid=26, OS id=22733\r\nDBW3 started with pid=28, OS id=22735\r\nLGWR started with pid=30, OS id=22737\r\nCKPT started with pid=32, OS id=22739\r\nSMON started with pid=34, OS id=22741\r\nRECO started with pid=36, OS id=22743\r\nCJQ0 started with pid=38, OS id=22745\r\nMMON started with pid=40, OS id=22747\r\nMMNL started with pid=42, OS id=22749\r\nWed Oct 14 17:47:17 2009\r\nlmon registered with NM - instance id 2 (internal mem no 1)\r\nWed Oct 14 17:47:17 2009\r\nReconfiguration started (old inc 0, new inc 2)\r\nList of nodes:\r\n1\r\nGlobal Resource Directory frozen\r\n* allocate domain 0, invalid = TRUE \r\nCommunication channels reestablished\r\nMaster broadcasted resource hash value bitmaps\r\nNon-local Process blocks cleaned out\r\nWed Oct 14 17:47:17 2009\r\nLMS 1: 0 GCS shadows cancelled, 0 closed\r\nWed Oct 14 17:47:17 2009\r\nLMS 3: 0 GCS shadows cancelled, 0 closed\r\nWed Oct 14 17:47:17 2009\r\nLMS 0: 0 GCS shadows cancelled, 0 closed\r\nWed Oct 14 17:47:17 2009\r\nLMS 2: 0 GCS shadows cancelled, 0 closed\r\nSet master node info \r\nSubmitted all remote-enqueue requests\r\nDwn-cvts replayed, VALBLKs dubious\r\nAll grantable enqueues granted\r\nPost SMON to start 1st pass IR\r\nWed Oct 14 17:47:17 2009\r\nLMS 1: 0 GCS shadows traversed, 0 replayed\r\nWed Oct 14 17:47:17 2009\r\nLMS 2: 0 GCS shadows traversed, 0 replayed\r\nWed Oct 14 17:47:17 2009\r\nLMS 3: 0 GCS shadows traversed, 0 replayed\r\nWed Oct 14 17:47:17 2009\r\nLMS 0: 0 GCS shadows traversed, 0 replayed\r\nWed Oct 14 17:47:17 2009\r\nSubmitted all GCS remote-cache requests\r\nFix write in gcs resources\r\nReconfiguration complete\r\nLCK0 started with pid=44, OS id=22761\r\nWed Oct 14 17:47:18 2009\r\nALTER DATABASE MOUNT\r\nWed Oct 14 17:47:18 2009\r\nThis instance was first to mount\r\nWed Oct 14 17:47:22 2009\r\nErrors in file \/u01\/app\/oracle\/admin\/orcl1\/udump\/orcl12_ora_22762.trc:\r\nORA-00600: internal error code, arguments: [kccsbck_first], [1], [559446173], [], [], [], [], []\r\nWed Oct 14 17:47:23 2009\r\nTrace dumping is performing id=[cdmp_20091014174723]\r\nWed Oct 14 17:47:24 2009\r\nORA-600 signalled during: ALTER DATABASE MOUNT...\r\nWed Oct 14 17:47:58 2009\r\nShutting down instance (abort)\r\nLicense high water mark = 1\r\nInstance terminated by USER, pid = 23014<\/pre>\n<p>\u867d\u7136ORA-600\u9519\u8bef\u53ea\u662f\u5728\u4e0a\u9762\u4fe1\u606f\u7684\u6700\u540e\u51e0\u884c\uff0c\u4f46\u662f\u524d\u9762\u7684\u521d\u59cb\u5316\u53c2\u6570\u4fee\u6539\u548c\u5b9e\u4f8b\u91cd\u542f\u548c\u8fd9\u4e2a\u9519\u8bef\u6709\u76f4\u63a5\u7684\u5173\u7cfb\u3002<br \/>\n\u5f88\u660e\u663e\uff0c\u8fd9\u662f\u4e00\u4e2a\u914d\u7f6eDATA GUARD\u7684\u8fc7\u7a0b\uff0c\u4e0d\u8fc7\u5f53\u524d\u5b9e\u4f8b\u5728\u914d\u7f6eDATA GUARD\u540e\u8fdb\u884c\u4e86\u91cd\u542f\uff0c\u800c\u8fd9\u4e2a\u9519\u8bef\u6070\u597d\u548c\u5b9e\u4f8b\u7684\u91cd\u542f\u6709\u5173\u3002<br \/>\n\u8ddf\u8fdbMOS\u6587\u6863Startup (mount) of 2nd RAC instance fails with ORA-00600 [kccsbck_first] [ID 395156.1]\uff0c\u5bfc\u81f4\u8fd9\u4e2a\u9519\u8bef\u7684\u539f\u56e0\u662f\u4e24\u4e2aRAC\u5b9e\u4f8b\u8bbe\u7f6e\u7684DB_UNIQUE_NAME\u53c2\u6570\u4e0d\u540c\u6240\u81f4\u3002\u524d\u9762\u901a\u8fc7ALTER SYSTEM\u8bbe\u7f6e\u4e86DB_UNIQUE_NAME\uff0c\u5e76\u91cd\u542f\u4f7f\u4e4b\u751f\u6548\uff0c\u800c\u5bf9\u4e8e\u53e6\u5916\u7684\u8282\u70b9\uff0c\u7531\u4e8e\u6ca1\u6709\u91cd\u542f\u7cfb\u7edf\uff0cDB_UNIQUE_NAME\u7684\u8bbe\u7f6e\u6ca1\u6709\u6539\u53d8\uff0c\u56e0\u6b64\u9020\u6210\u4e86\u5f53\u524d\u542f\u52a8\u7684\u5b9e\u4f8b\u4e0e\u53e6\u4e00\u4e2a\u8282\u70b9\u4e0a\u4e00\u76f4\u8fd0\u884c\u7684\u5b9e\u4f8b\u51fa\u73b0\u4e86\u51b2\u7a81\u3002<br \/>\n\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u5f88\u7b80\u5355\uff0c\u5c06\u53e6\u5916\u4e00\u4e2a\u5b9e\u4f8b\u4e5f\u8fdb\u884c\u91cd\u542f\uff0c\u5c31\u53ef\u4ee5\u89e3\u51b3\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237Oracle10.2.0.4 RAC\u6570\u636e\u5e93\u51fa\u73b0ORA-600(kccsbck_first)\u9519\u8bef\u3002 \u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Wed Oct 14 17:43:34 2009 ALTER DATABASE FORCE LOGGING Wed Oct 14 17:43:34 2009 ORA-12920 signalled during: ALTER DATABASE FORCE LOGGING&#8230; Wed Oct 14 17:43:42 2009 ALTER SYSTEM SET db_unique_name=&#8217;PRIMARY&#8217; SCOPE=SPFILE; Wed Oct 14 17:44:01 2009 ALTER &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=884\">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":[756,757,758,8,180],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-eg","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/884"}],"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=884"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/884\/revisions"}],"predecessor-version":[{"id":885,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/884\/revisions\/885"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}