\u5ba2\u6237\u76844\u8282\u70b9RAC\u73af\u5883\uff0c\u5176\u4e2d\u4e00\u4e2a\u8282\u70b9\u5b9e\u4f8b\u51fa\u73b0\u6545\u969c\uff0c\u53d1\u73b0\u65e0\u6cd5\u6b63\u5e38\u542f\u52a8\u3002
\n\u68c0\u67e5CLUSTER\u548c\u544a\u8b66\u65e5\u5fd7\u4fe1\u606f\uff0c\u53d1\u73b0\u8282\u70b91\u5fc3\u8df3\u8d85\u65f6\uff0c\u88ab\u8e22\u51fa\u96c6\u7fa4\u3002\u670d\u52a1\u5668\u91cd\u65b0\u542f\u52a8\u540e\uff0c\u6570\u636e\u5e93\u5b9e\u4f8b\u6ca1\u6709\u81ea\u52a8\u542f\u52a8\u3002
\n\u544a\u8b66\u65e5\u5fd7\u4fe1\u606f\u4e3a\uff1a<\/p>\n
Mon Apr 16 03:42:39 2012\r\nThread 1 advanced to log sequence 22348 (LGWR switch)\r\nCurrent log# 16 seq# 22348 mem# 0: +DATA\/orcl\/onlinelog\/group_16.291.766326571\r\nCurrent log# 16 seq# 22348 mem# 1: +DATA\/orcl\/onlinelog\/group_16.293.766330969\r\nMon Apr 16 15:02:58 2012\r\nStarting ORACLE instance (normal)\r\nLICENSE_MAX_SESSION = 0\r\nLICENSE_SESSIONS_WARNING = 0\r\nInterface type 1 eth1 10.0.0.0 configured from OCR for use as a cluster interconnect\r\nInterface type 1 eth0 192.168.1.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 = 1500\r\nsessions = 1655\r\nsga_max_size = 19830669312\r\npre_page_sga = FALSE\r\nlock_sga = FALSE\r\n__shared_pool_size = 3674210304\r\n__large_pool_size = 16777216\r\n__java_pool_size = 16777216\r\n__streams_pool_size = 33554432\r\nspfile = +DATA\/orcl\/spfileorcl.ora\r\nsga_target = 19830669312\r\ncontrol_files = +DATA\/orcl\/controlfile\/current.274.720740395\r\ndb_block_size = 8192\r\n__db_cache_size = 16072572928\r\ncompatible = 10.2.0.3.0\r\nlog_archive_dest_1 = LOCATION=+DATA\/\r\nlog_archive_format = %t_%s_%r.dbf\r\ndb_file_multiblock_read_count= 16\r\ncluster_database = TRUE\r\ncluster_database_instances= 4\r\ndb_create_file_dest = +DATA\r\n_gc_affinity_time = 0\r\n_gc_affinity_limit = 10000000\r\n_gc_affinity_minimum = 10000000\r\nthread = 1\r\ninstance_number = 1\r\nundo_management = AUTO\r\nundo_tablespace = UNDOTBS1\r\nremote_login_passwordfile= EXCLUSIVE\r\ndb_domain =\r\ndispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)\r\nlocal_listener = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.21)(PORT = 1521))\r\nremote_listener = LISTENERS_ORCL\r\njob_queue_processes = 20\r\ncursor_sharing = FORCE\r\nbackground_dump_dest = \/u01\/app\/oracle\/admin\/orcl\/bdump\r\nuser_dump_dest = \/u01\/app\/oracle\/admin\/orcl\/udump\r\ncore_dump_dest = \/u01\/app\/oracle\/admin\/orcl\/cdump\r\naudit_file_dest = \/u01\/app\/oracle\/admin\/orcl\/adump\r\ndb_name = orcl\r\nopen_cursors = 1000\r\npga_aggregate_target = 5872025600\r\nCluster communication is configured to use the following interface(s) for this instance\r\n10.0.0.11\r\nMon Apr 16 15:02:59 2012\r\ncluster interconnect IPC version:Oracle UDP\/IP (generic)\r\nIPC Vendor 1 proto 2\r\nPMON started with pid=2, OS id=20588\r\nDIAG started with pid=3, OS id=20590\r\nPSP0 started with pid=4, OS id=20592\r\nLMON started with pid=5, OS id=20594\r\nLMD0 started with pid=6, OS id=20596\r\nLMS0 started with pid=7, OS id=20603\r\nLMS1 started with pid=8, OS id=20607\r\nLMS2 started with pid=9, OS id=20611\r\nLMS3 started with pid=10, OS id=20615\r\nMMAN started with pid=11, OS id=20619\r\nDBW0 started with pid=12, OS id=20621\r\nDBW1 started with pid=13, OS id=20623\r\nLGWR started with pid=14, OS id=20625\r\nCKPT started with pid=15, OS id=20627\r\nSMON started with pid=16, OS id=20629\r\nRECO started with pid=17, OS id=20631\r\nCJQ0 started with pid=18, OS id=20633\r\nMMON started with pid=19, OS id=20635\r\nMon Apr 16 15:03:00 2012\r\nstarting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...\r\nMMNL started with pid=20, OS id=20637\r\nMon Apr 16 15:03:00 2012\r\nstarting up 1 shared server(s) ...\r\nMon Apr 16 15:03:02 2012\r\nlmon registered with NM - instance id 1 (internal mem no 0)\r\nMon Apr 16 15:03:05 2012\r\nReconfiguration started (old inc 0, new inc 30)\r\nList of nodes:\r\n0 1 2 3\r\nGlobal Resource Directory frozen\r\n* allocate domain 0, invalid = TRUE\r\nCommunication channels reestablished\r\n* domain 0 valid according to instance 3\r\n* domain 0 valid = 1 according to instance 1\r\nMon Apr 16 15:03:05 2012\r\nMaster broadcasted resource hash value bitmaps\r\nNon-local Process blocks cleaned out\r\nMon Apr 16 15:03:05 2012\r\nLMS 0: 0 GCS shadows cancelled, 0 closed\r\nMon Apr 16 15:03:05 2012\r\nLMS 1: 0 GCS shadows cancelled, 0 closed\r\nMon Apr 16 15:03:05 2012\r\nLMS 2: 0 GCS shadows cancelled, 0 closed\r\nMon Apr 16 15:03:05 2012\r\nLMS 3: 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\nMon Apr 16 15:03:07 2012\r\nLMS 2: 0 GCS shadows traversed, 0 replayed\r\nMon Apr 16 15:03:07 2012\r\nLMS 1: 0 GCS shadows traversed, 0 replayed\r\nMon Apr 16 15:03:07 2012\r\nLMS 3: 0 GCS shadows traversed, 0 replayed\r\nMon Apr 16 15:03:07 2012\r\nLMS 0: 0 GCS shadows traversed, 0 replayed\r\nMon Apr 16 15:03:07 2012\r\nSubmitted all GCS remote-cache requests\r\nPost SMON to start 1st pass IR\r\nFix write in gcs resources\r\nReconfiguration complete\r\nLCK0 started with pid=23, OS id=20699\r\nMon Apr 16 15:03:12 2012\r\nALTER DATABASE MOUNT\r\nMon Apr 16 15:03:12 2012\r\nStarting background process ASMB\r\nASMB started with pid=25, OS id=20710\r\nStarting background process RBAL\r\nRBAL started with pid=26, OS id=20714\r\nMon Apr 16 15:03:17 2012\r\nSUCCESS: diskgroup DATA was mounted\r\nMon Apr 16 15:03:21 2012\r\nSetting recovery target incarnation to 2\r\nMon Apr 16 15:03:21 2012\r\nSUCCESS: diskgroup DATA was dismounted\r\nMon Apr 16 15:03:21 2012\r\nORA-1105 signalled during: ALTER DATABASE MOUNT...<\/pre>\n\u8fd9\u4e2aORA-1105\u9519\u8bef\u53ea\u662f\u8bf4\u660e\u5f53\u524d\u5b9e\u4f8b\u7684\u67d0\u4e9b\u53c2\u6570\u8bbe\u7f6e\u548cRAC\u5176\u4ed6\u5b9e\u4f8b\u8bbe\u7f6e\u7684\u4e0d\u7b26\uff0c\u5e76\u4e0d\u80fd\u8bf4\u660e\u5bfc\u81f4\u9519\u8bef\u7684\u771f\u6b63\u539f\u56e0\u3002
\n\u4e3a\u4e86\u627e\u5230\u95ee\u9898\u53ea\u6709\u624b\u5de5\u542f\u52a8\u5b9e\u4f8b\uff1a<\/p>\n
[oracle@rac1 ~]$ sqlplus \/ as sysdba\r\nSQL*Plus: Release 10.2.0.4.0 - Production on \u661f\u671f\u4e00 4\u6708 16 17:04:54 2012\r\nCopyright (c) 1982, 2007, Oracle. All Rights Reserved.\r\nConnected to an idle instance.\r\nSQL> STARTUP MOUNT\r\nORACLE instance started.\r\nTotal System Global Area 1.9831E+10 bytes\r\nFixed Size 2119216 bytes\r\nVariable Size 3741321680 bytes\r\nDatabase Buffers 1.6073E+10 bytes\r\nRedo Buffers 14655488 bytes\r\nORA-01105: mount is incompatible with mounts by other instances\r\nORA-01606: gc_files_to_locks not identical to that of another mounted instance<\/pre>\n\u901a\u8fc7\u624b\u5de5\u6267\u884c\uff0c\u53ef\u4ee5\u4e86\u89e3\u5177\u4f53\u5bfc\u81f4\u9519\u8bef\u4ea7\u751f\u7684\u539f\u56e0\u3002\u4e0d\u8fc7gc_files_to_locks\u5e76\u6ca1\u6709\u8bbe\u7f6e\u4e3a\u4e0d\u540c\u7684\u503c\uff1a<\/p>\n
SQL> show parameter gc_files_to_locks\r\nNAME TYPE VALUE\r\n------------------- ------------------- -----------------\r\ngc_files_to_locks string\r\nSQL> select sid, name, value from v$spparameter where name = 'gc_files_to_locks'; \r\nSID NAME VALUE\r\n---------- ------------------------------ --------------------------------\r\n* gc_files_to_locks<\/pre>\n\u4e0d\u8fc7\u5bfc\u81f4\u95ee\u9898\u4ea7\u751f\u7684\u786e\u5b9e\u4e0eGC\u8bbe\u7f6e\u6709\u5173\uff0c\u95ee\u9898\u5e76\u975e\u662fgc_files_to_locks\u53c2\u6570\u5bfc\u81f4\uff0c\u800c\u662fSPFILE\u4e2d\u8bbe\u7f6e\u7684_gc_affinity_time\u53c2\u6570\u3002\u8fd9\u4e2a\u53c2\u6570\u662f\u9759\u6001\u53c2\u6570\uff0c\u53ea\u6709\u91cd\u542f\u540e\u624d\u80fd\u751f\u6548\uff0c\u800c\u5728SPFILE\u4e2d\u8bbe\u7f6e\u540e\uff0c\u4f1a\u5bfc\u81f4\u91cd\u542f\u7684\u5b9e\u4f8b1\u751f\u6548\u4e86\u8be5\u53c2\u6570\uff0c\u56e0\u6b64\u548c\u6ca1\u6709\u91cd\u542f\u8fc7\u7684\u5176\u4ed6\u5b9e\u4f8b\u4ea7\u751f\u4e86\u4e0d\u517c\u5bb9\u3002
\n\u89e3\u51b3\u65b9\u6cd5\u6709\u4e24\u4e2a\uff0c\u4e00\u4e2a\u662f\u91cd\u542f\u6240\u6709\u7684\u8282\u70b9\uff0c\u53e6\u5916\u4e00\u4e2a\u662f\u53bb\u6389SPFILE\u4e2d\u8fd9\u4e2a\u53c2\u6570\u7684\u8bbe\u7f6e\uff1a<\/p>\n
SQL> alter system reset \"_gc_affinity_time\" scope = spfile sid = '*';\r\nSystem altered.\r\nSQL> shutdown immediate\r\nORA-01507: database not mounted\r\n\r\nORACLE instance shut down.\r\nSQL> startup mount\r\nORACLE instance started.\r\nTotal System Global Area 1.9831E+10 bytes\r\nFixed Size 2119216 bytes\r\nVariable Size 3741321680 bytes\r\nDatabase Buffers 1.6073E+10 bytes\r\nRedo Buffers 14655488 bytes\r\nDatabase mounted.\r\nSQL> alter database open;\r\nDatabase altered.<\/pre>\n","protected":false},"excerpt":{"rendered":"\u5ba2\u6237\u76844\u8282\u70b9RAC\u73af\u5883\uff0c\u5176\u4e2d\u4e00\u4e2a\u8282\u70b9\u5b9e\u4f8b\u51fa\u73b0\u6545\u969c\uff0c\u53d1\u73b0\u65e0\u6cd5\u6b63\u5e38\u542f\u52a8\u3002 \u68c0\u67e5CLUSTER\u548c\u544a\u8b66\u65e5\u5fd7\u4fe1\u606f\uff0c\u53d1\u73b0\u8282\u70b91\u5fc3\u8df3\u8d85\u65f6\uff0c\u88ab\u8e22\u51fa\u96c6\u7fa4\u3002\u670d\u52a1\u5668\u91cd\u65b0\u542f\u52a8\u540e\uff0c\u6570\u636e\u5e93\u5b9e\u4f8b\u6ca1\u6709\u81ea\u52a8\u542f\u52a8\u3002 \u544a\u8b66\u65e5\u5fd7\u4fe1\u606f\u4e3a\uff1a Mon Apr 16 03:42:39 2012 Thread 1 advanced to log sequence 22348 (LGWR switch) Current log# 16 seq# 22348 mem# 0: +DATA\/orcl\/onlinelog\/group_16.291.766326571 Current log# 16 seq# 22348 mem# 1: +DATA\/orcl\/onlinelog\/group_16.293.766330969 Mon Apr 16 15:02:58 2012 Starting ORACLE … Continue reading