\u544a\u8b66\u65e5\u5fd7\u4e2d\u51fa\u73b0ORA-7445[krslvna]\u9519\u8bef\uff0c\u968f\u540e\u5bfc\u81f4\u6570\u636e\u5e93\u7684\u5d29\u6e83\u3002
\n\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n
Thu Sep 8 04:12:07 2011\r\nStarting ORACLE instance (normal)\r\nLICENSE_MAX_SESSION = 0\r\nLICENSE_SESSIONS_WARNING = 0\r\nInterface type 1 lan900 192.168.11.0 configured from OCR for use as a cluster interconnect\r\nInterface type 1 lan901 10.142.132.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 = 800\r\nsessions = 885\r\nsga_max_size = 77309411328\r\n__shared_pool_size = 4194304000\r\n__large_pool_size = 16777216\r\n__java_pool_size = 16777216\r\n__streams_pool_size = 0\r\nspfile = \/dev\/vg1\/spfile\r\nsga_target = 68719476736\r\ncontrol_files = \/dev\/vg1\/control_01, \/dev\/vg2\/control_02, \/dev\/vg3\/control_03\r\ndb_block_size = 8192\r\n__db_cache_size = 64474841088\r\ncompatible = 10.2.0.3.0\r\nlog_archive_config = DG_CONFIG=(ORCLS,ORCLP)\r\nlog_archive_dest_1 = LOCATION=\/arch1\/archive_log\r\nlog_archive_dest_2 = service=ORCLP LGWR ASYNC valid_for=(online_logfiles,primary_role) db_unique_name=ORCLP\r\nlog_archive_trace = 12\r\nfal_client = ORCLS\r\nfal_server = orclp\r\ndb_file_multiblock_read_count= 16\r\ncluster_database = TRUE\r\ncluster_database_instances= 2\r\nstandby_file_management = auto\r\nthread = 1\r\ninstance_number = 1\r\nundo_management = AUTO\r\nundo_tablespace = UNDOTBS1\r\nremote_login_passwordfile= EXCLUSIVE\r\ndb_domain =\r\nservice_names = ORCLS\r\ndispatchers = (PROTOCOL=TCP) (SERVICE=ORCLSXDB)\r\nlocal_listener =\r\nremote_listener = LISTENERS_ORCLS\r\njob_queue_processes = 10\r\nbackground_dump_dest = \/oracle\/admin\/orcls\/bdump\r\nuser_dump_dest = \/oracle\/admin\/orcls\/udump\r\ncore_dump_dest = \/oracle\/admin\/orcls\/cdump\r\naudit_file_dest = \/oracle\/admin\/orcls\/adump\r\ndb_name = orclp\r\ndb_unique_name = orcls\r\nopen_cursors = 300\r\npga_aggregate_target = 15032385536\r\nCluster communication is configured to use the following interface(s) for this instance\r\n192.168.11.3\r\nThu Sep 8 04:12:11 2011\r\ncluster interconnect IPC version:Oracle UDP\/IP (generic)\r\nIPC Vendor 1 proto 2\r\nPMON started with pid=2, OS id=4960\r\nDIAG started with pid=6, OS id=5290\r\nPSP0 started with pid=10, OS id=5292\r\nLMON started with pid=14, OS id=5294\r\nLMD0 started with pid=18, OS id=5296\r\nLMS0 started with pid=22, OS id=5298\r\nLMS1 started with pid=26, OS id=5300\r\nLMS2 started with pid=30, OS id=5307\r\nLMS3 started with pid=34, OS id=5309\r\nLMS4 started with pid=38, OS id=5311\r\nMMAN started with pid=42, OS id=5313\r\nDBW0 started with pid=46, OS id=5320\r\nDBW1 started with pid=50, OS id=5322\r\nDBW2 started with pid=54, OS id=5327\r\nDBW3 started with pid=58, OS id=5334\r\nLGWR started with pid=62, OS id=5336\r\nCKPT started with pid=66, OS id=5338\r\nSMON started with pid=70, OS id=5345\r\nRECO started with pid=74, OS id=5347\r\nCJQ0 started with pid=78, OS id=5349\r\nMMON started with pid=82, OS id=5356\r\nMMNL started with pid=86, OS id=5359\r\nThu Sep 8 04:13:12 2011\r\nstarting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...\r\nstarting up 1 shared server(s) ...\r\nThu Sep 8 04:13:22 2011\r\nlmon registered with NM - instance id 1 (internal mem no 0)\r\nThu Sep 8 04:13:22 2011\r\nReconfiguration started (old inc 0, new inc 2)\r\nList of nodes:\r\n0\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\nThu Sep 8 04:13:23 2011\r\nLMS 0: 0 GCS shadows cancelled, 0 closed\r\nThu Sep 8 04:13:23 2011\r\nLMS 4: 0 GCS shadows cancelled, 0 closed\r\nThu Sep 8 04:13:23 2011\r\nLMS 2: 0 GCS shadows cancelled, 0 closed\r\nThu Sep 8 04:13:23 2011\r\nLMS 1: 0 GCS shadows cancelled, 0 closed\r\nThu Sep 8 04:13:23 2011\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\nPost SMON to start 1st pass IR\r\nThu Sep 8 04:13:23 2011\r\nLMS 0: 0 GCS shadows traversed, 0 replayed\r\nThu Sep 8 04:13:23 2011\r\nLMS 4: 0 GCS shadows traversed, 0 replayed\r\nThu Sep 8 04:13:23 2011\r\nLMS 2: 0 GCS shadows traversed, 0 replayed\r\nThu Sep 8 04:13:23 2011\r\nLMS 1: 0 GCS shadows traversed, 0 replayed\r\nThu Sep 8 04:13:23 2011\r\nLMS 3: 0 GCS shadows traversed, 0 replayed\r\nThu Sep 8 04:13:23 2011\r\nSubmitted all GCS remote-cache requests\r\nFix write in gcs resources\r\nReconfiguration complete\r\nLCK0 started with pid=98, OS id=5462\r\nThu Sep 8 04:13:23 2011\r\nALTER DATABASE MOUNT\r\nThu Sep 8 04:13:23 2011\r\nThis instance was first to mount\r\nSetting recovery target incarnation to 2\r\nThu Sep 8 04:13:28 2011\r\nSuccessful mount of redo thread 1, with mount id 422802531\r\nThu Sep 8 04:13:28 2011\r\nDatabase mounted in Shared Mode (CLUSTER_DATABASE=TRUE)\r\nCompleted: ALTER DATABASE MOUNT\r\nThu Sep 8 04:13:28 2011\r\nALTER DATABASE OPEN\r\nThu Sep 8 04:13:28 2011\r\nThis instance was first to open\r\nPicked broadcast on commit scheme to generate SCNs\r\nThu Sep 8 04:13:28 2011\r\nLGWR: STARTING ARCH PROCESSES\r\nARC0 started with pid=102, OS id=5496\r\nThu Sep 8 04:13:28 2011\r\nARC0: Archival started\r\nARC1: Archival started\r\nLGWR: STARTING ARCH PROCESSES COMPLETE\r\n(orcls1)\r\nThu Sep 8 03:24:29 2011\r\nARC0: Closing local archive destination LOG_ARCHIVE_DEST_1: '\/arch1\/archive_log\/1_15995_684332778.dbf'\r\n(orcls1)\r\nThu Sep 8 03:24:32 2011\r\nMedia Recovery Log \/arch1\/archive_log\/1_15995_684332778.dbf\r\nMedia Recovery Waiting for thread 1 sequence 15996\r\nThu Sep 8 03:25:00 2011\r\nRedo Shipping Client Connected as PUBLIC\r\n-- Connected User is Valid\r\nRFS[31]: Assigned to RFS process 15517\r\nRFS[31]: Identified database type as 'physical standby'\r\nRFS[31]: Successfully opened standby log 7: '\/dev\/vg_3GeSales_01\/rlv_186_sdlog1_1_01'\r\nThu Sep 8 03:25:03 2011\r\nARC1: Creating local archive destination LOG_ARCHIVE_DEST_1: '\/arch1\/archive_log\/1_15996_684332778.dbf' (thread 1 sequence 15996)\r\n(orcls1)\r\nThu Sep 8 03:25:04 2011\r\nARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '\/arch1\/archive_log\/1_15996_684332778.dbf'\r\n(orcls1)\r\nThu Sep 8 03:25:09 2011\r\nMedia Recovery Log \/arch1\/archive_log\/1_15996_684332778.dbf\r\nMedia Recovery Waiting for thread 1 sequence 15997\r\nThu Sep 8 03:32:59 2011\r\nRedo Shipping Client Connected as PUBLIC\r\n-- Connected User is Valid\r\nRFS[32]: Assigned to RFS process 18698\r\nRFS[32]: Identified database type as 'physical standby'\r\nRFS[32]: Successfully opened standby log 7: '\/dev\/vg_3GeSales_01\/rlv_186_sdlog1_1_01'\r\nThu Sep 8 03:33:10 2011\r\nARC0: Creating local archive destination LOG_ARCHIVE_DEST_1: '\/arch1\/archive_log\/1_15997_684332778.dbf' (thread 1 sequence 15997)\r\n(orcls1)\r\nThu Sep 8 03:33:12 2011\r\nARC0: Closing local archive destination LOG_ARCHIVE_DEST_1: '\/arch1\/archive_log\/1_15997_684332778.dbf'\r\n(orcls1)\r\nThu Sep 8 03:33:16 2011\r\nMedia Recovery Log \/arch1\/archive_log\/1_15997_684332778.dbf\r\nMedia Recovery Waiting for thread 1 sequence 15998\r\nThu Sep 8 03:43:16 2011\r\nRedo Shipping Client Connected as PUBLIC\r\n-- Connected User is Valid\r\nRFS[33]: Assigned to RFS process 22783\r\nRFS[33]: Identified database type as 'physical standby'\r\nRFS[33]: Successfully opened standby log 7: '\/dev\/vg_3GeSales_01\/rlv_186_sdlog1_1_01'\r\nThu Sep 8 03:43:16 2011\r\nARC1: Creating local archive destination LOG_ARCHIVE_DEST_1: '\/arch1\/archive_log\/1_15998_684332778.dbf' (thread 1 sequence 15998)\r\n(orcls1)\r\nThu Sep 8 03:43:16 2011\r\nARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '\/arch1\/archive_log\/1_15998_684332778.dbf'\r\n(orcls1)\r\nThu Sep 8 03:43:18 2011\r\nMedia Recovery Log \/arch1\/archive_log\/1_15998_684332778.dbf\r\nMedia Recovery Waiting for thread 1 sequence 15999\r\nThu Sep 8 03:43:45 2011\r\nALTER SYSTEM ARCHIVE LOG\r\nThu Sep 8 03:52:03 2011\r\nRedo Shipping Client Connected as PUBLIC\r\n-- Connected User is Valid\r\nRFS[34]: Assigned to RFS process 26342\r\nRFS[34]: Identified database type as 'physical standby'\r\nRFS[34]: Successfully opened standby log 7: '\/dev\/vg_3GeSales_01\/rlv_186_sdlog1_1_01'\r\nThu Sep 8 03:52:03 2011\r\nARC0: Creating local archive destination LOG_ARCHIVE_DEST_1: '\/arch1\/archive_log\/1_15999_684332778.dbf' (thread 1 sequence 15999)\r\n(orcls1)\r\nThu Sep 8 03:52:03 2011\r\nARC0: Closing local archive destination LOG_ARCHIVE_DEST_1: '\/arch1\/archive_log\/1_15999_684332778.dbf'\r\n(orcls1)\r\nThu Sep 8 03:52:03 2011\r\nMedia Recovery Log \/arch1\/archive_log\/1_15999_684332778.dbf\r\nMedia Recovery Waiting for thread 1 sequence 16000\r\nThu Sep 8 03:58:22 2011\r\nRedo Shipping Client Connected as PUBLIC\r\n-- Connected User is Valid\r\nRFS[35]: Assigned to RFS process 28916\r\nRFS[35]: Identified database type as 'physical standby'\r\nRFS[35]: Successfully opened standby log 7: '\/dev\/vg_3GeSales_01\/rlv_186_sdlog1_1_01'\r\nThu Sep 8 03:58:29 2011\r\nARC1: Creating local archive destination LOG_ARCHIVE_DEST_1: '\/arch1\/archive_log\/1_16000_684332778.dbf' (thread 1 sequence 16000)\r\n(orcls1)\r\nThu Sep 8 03:58:30 2011\r\nARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '\/arch1\/archive_log\/1_16000_684332778.dbf'\r\n(orcls1)\r\nThu Sep 8 03:58:34 2011\r\nMedia Recovery Log \/arch1\/archive_log\/1_16000_684332778.dbf\r\nMedia Recovery Waiting for thread 1 sequence 16001\r\nThu Sep 8 04:04:52 2011\r\nRedo Shipping Client Connected as PUBLIC\r\n-- Connected User is Valid\r\nRFS[36]: Assigned to RFS process 1725\r\nRFS[36]: Identified database type as 'physical standby'\r\nRFS[36]: Archived Log: '\/arch1\/archive_log\/1_16001_684332778.dbf'\r\nThu Sep 8 04:05:00 2011\r\nMedia Recovery Log \/arch1\/archive_log\/1_16001_684332778.dbf\r\nIdentified End-Of-Redo for thread 1 sequence 16001\r\nThu Sep 8 04:05:07 2011\r\nMedia Recovery End-Of-Redo indicator encountered\r\nThu Sep 8 04:05:08 2011\r\nMedia Recovery Applied until change 10988424928720\r\nThu Sep 8 04:05:08 2011\r\nMRP0: Media Recovery Complete: End-Of-REDO (orcls1)\r\nResetting standby activation ID 418471684 (0x18f15f04)\r\nThu Sep 8 04:05:13 2011\r\nMRP0: Background Media Recovery process shutdown (orcls1)\r\nThu Sep 8 04:07:17 2011\r\nalter database commit to switchover to primary with session shutdown\r\nThu Sep 8 04:07:17 2011\r\nALTER DATABASE SWITCHOVER TO PRIMARY (orcls1)\r\nThu Sep 8 04:07:17 2011\r\nIf media recovery active, switchover will wait 900 seconds\r\nThu Sep 8 04:10:17 2011\r\nSwitchOver after complete recovery through change 10988424928720\r\nThu Sep 8 04:10:40 2011\r\nStandby became primary SCN: 10988424928718\r\nConverting standby mount to primary mount.\r\nThu Sep 8 04:10:40 2011\r\nSwitchover: Complete - Database mounted as primary (orcls1)\r\nCompleted: alter database commit to switchover to primary with session shutdown\r\nThu Sep 8 04:10:40 2011\r\nARC0: STARTING ARCH PROCESSES\r\nARC2 started with pid=110, OS id=4267\r\nThu Sep 8 04:10:40 2011\r\nARC2: Archival started\r\nARC0: STARTING ARCH PROCESSES COMPLETE\r\nThu Sep 8 04:11:02 2011\r\nalter database open\r\nThu Sep 8 04:11:02 2011\r\nThis instance was first to open\r\nPicked broadcast on commit scheme to generate SCNs\r\nThu Sep 8 04:11:02 2011\r\nAssigning activation ID 422708933 (0x193206c5)\r\nLNSb started with pid=114, OS id=4419\r\nError 12541 received logging on to the standby\r\nCheck whether the listener is up and running.\r\nThu Sep 8 04:11:09 2011\r\nErrors in file \/oracle\/admin\/orcls\/bdump\/orcls1_lgwr_10865.trc:\r\nORA-12541: TNS:no listener\r\nThu Sep 8 04:11:09 2011\r\nLGWR: Error 12541 verifying archivelog destination LOG_ARCHIVE_DEST_2\r\nLGWR: Continuing...\r\nThu Sep 8 04:11:09 2011\r\nErrors in file \/oracle\/admin\/orcls\/bdump\/orcls1_lgwr_10865.trc:\r\nORA-07445: exception encountered: core dump [krslvna()+5073] [SIGSEGV] [Invalid permissions for mapped object] [0x000000254] [] []\r\nThu Sep 8 04:11:10 2011\r\nTrace dumping is performing id=[cdmp_20110908041110]\r\nThu Sep 8 04:11:13 2011\r\nErrors in file \/oracle\/admin\/orcls\/bdump\/orcls1_pmon_10481.trc:\r\nORA-00470: LGWR process terminated with error\r\nThu Sep 8 04:11:13 2011\r\nPMON: terminating instance due to error 470\r\nThu Sep 8 04:11:15 2011\r\nShutting down instance (abort)\r\nLicense high water mark = 49\r\nThu Sep 8 04:11:23 2011\r\nTermination issued to instance processes. Waiting for the processes to exit\r\nThu Sep 8 04:11:29 2011\r\nInstance termination failed to kill one or more processes\r\nInstance terminated by PMON, pid = 10481\r\nThu Sep 8 04:11:39 2011\r\nTermination issued to instance processes. Waiting for the processes to exit\r\nThu Sep 8 04:11:45 2011\r\nInstance termination failed to kill one or more processes\r\nInstance terminated by USER, pid = 4542<\/pre>\n\u5176\u5b9e\u8ddf\u9519\u8bef\u76f8\u5173\u7684\u4fe1\u606f\u53ea\u6709\u5176\u4e2d\u4e00\u4e24\u884c\uff0c\u4e4b\u6240\u4ee5\u5217\u51fa\u8fd9\u4e48\u591a\u7684\u4fe1\u606f\uff0c\u65e0\u975e\u662f\u8981\u8bf4\u660e\u9519\u8bef\u53d1\u751f\u7684\u5177\u4f53\u73af\u5883\uff0c\u5728\u9519\u8bef\u53d1\u751f\u4e4b\u524d\u505a\u8fc7DATA GUARD\u7684SWITCHOVER\uff0c\u770b\u6765\u8fd9\u4e2a\u9519\u8bef\u5f88\u53ef\u80fd\u4e0eDATA GUARD\u6709\u5173\u3002
\n\u67e5\u8be2\u7ed3\u679c\u4e5f\u786e\u5b9e\u5982\u6b64\uff0c\u5728\u6587\u6863Bug 6490140 – LGWR may crash the instance [ID 6490140.8]\u63cf\u8ff0\u4e86\u8fd9\u4e2a\u95ee\u9898\u3002\u5f53\u524d\u6570\u636e\u5e93\u4e3a\u4e3b\u5b9e\u4f8b\uff0c\u4e14\u901a\u8fc7LGWR\u8fdb\u7a0b\u5411\u8fdc\u7aef\u5199\u5f52\u6863\u65f6\u53ef\u80fd\u78b0\u5230\u8fd9\u4e2a\u9519\u8bef\uff0c\u800c\u8fd9\u4e2a\u9519\u8bef\u660e\u663e\u4e0eDATA GUARD\u914d\u7f6e\u6709\u5173\u3002\u786e\u8ba4\u5f71\u54cd\u7684\u7248\u672c\u5c31\u662f\u5f53\u524d\u768410.2.0.4\u7248\u672c\uff0cOracle\u572810.2.0.4 Data Guard Physical Recommended Patch Bundle #1\u300110.2.0.4.1\u300110.2.0.5\u548c11.1.0.6\u4e2d\u89e3\u51b3\u4e86\u8fd9\u4e2a\u95ee\u9898\u3002
\n\u4ece\u9519\u8bef\u4fe1\u606f\u770b\uff0c\u5728\u8fd9\u4e2aORA-7445\u9519\u8bef\u51fa\u73b0\u4e4b\u524d\uff0cOracle\u62a5\u4e86\u4e00\u4e2aORA-12541\uff1ano listener\u7684\u9519\u8bef\uff0c\u90a3\u4e48\u4e0d\u96be\u63a8\u6d4b\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u5728\u4e8eLGWR\u5199\u8fdc\u7aef\u5f52\u6863\u65e5\u5fd7\u5374\u53d1\u73b0\u8fdc\u7aef\u6ca1\u6709\u914d\u7f6e\u76d1\u542c\uff0c\u4ece\u800c\u5bfc\u81f4LGWR\u8fdb\u7a0b\u51fa\u73b0ORA-7445\u5f02\u5e38\u5e76\u9000\u51fa\uff0c\u800cLGWR\u8fdb\u7a0b\u7684\u9000\u51fa\u5219\u610f\u5473\u7740\u6570\u636e\u5e93\u7684CRASH\u3002
\n\u5bf9\u4e8e\u975eDATA GUARD\u73af\u5883\u4e00\u822c\u4e0d\u4f1a\u51fa\u73b0LGWR\u5199\u8fdc\u7aef\u5f52\u6863\u7684\u60c5\u51b5\uff0c\u800c\u5bf9\u4e8eDATA GUARD\u73af\u5883\uff0c\u5219\u8981\u5c0f\u5fc3\u8fd9\u4e2abug\u7684\u4ea7\u751f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u544a\u8b66\u65e5\u5fd7\u4e2d\u51fa\u73b0ORA-7445[krslvna]\u9519\u8bef\uff0c\u968f\u540e\u5bfc\u81f4\u6570\u636e\u5e93\u7684\u5d29\u6e83\u3002 \u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Thu Sep 8 04:12:07 2011 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Interface type 1 lan900 192.168.11.0 configured from OCR for use as a cluster interconnect Interface type 1 lan901 10.142.132.0 configured from OCR for … Continue reading