本文共 10629 字，大约阅读时间需要 35 分钟。
Sun Nov 22 14:08:15 2009 starting up 1 shared server(s) ... Sun Nov 22 14:08:15 2009 lmon registered with NM - instance id 1 (internal mem no 0) Sun Nov 22 14:08:19 2009 Reconfiguration started (old inc 0, new inc 72) pseudo shared rm latch used List of nodes: 0 1 Global Resource Directory frozen * allocate domain 0, invalid = TRUE Communication channels reestablished * domain 0 not valid according to instance 1 * domain 0 valid = 0 according to instance 1 Sun Nov 22 14:08:20 2009 Master broadcasted resource hash value bitmaps Non-local Process blocks cleaned out Sun Nov 22 14:08:20 2009 LMS 0: 0 GCS shadows cancelled, 0 closed Sun Nov 22 14:08:20 2009 LMS 1: 0 GCS shadows cancelled, 0 closed Set master node info Submitted all remote-enqueue requests Dwn-cvts replayed, VALBLKs dubious All grantable enqueues granted Post SMON to start 1st pass IR Sun Nov 22 14:08:20 2009 LMS 1: 0 GCS shadows traversed, 0 replayed Sun Nov 22 14:08:20 2009 LMS 0: 0 GCS shadows traversed, 0 replayed Sun Nov 22 14:08:20 2009 Submitted all GCS remote-cache requests Post SMON to start 1st pass IR Fix write in gcs resources Reconfiguration complete LCK0 started with pid=20, OS id=9093 Sun Nov 22 14:08:21 2009 ALTER DATABASE MOUNT Sun Nov 22 14:08:21 2009 Starting background process ASMB ASMB started with pid=22, OS id=9099 Starting background process RBAL RBAL started with pid=23, OS id=9104 Loaded ASM Library - Generic Linux, version 2.0.4 (KABI_V2) library for asmlib interface Sun Nov 22 14:08:30 2009 SUCCESS: diskgroup LLPWDB was mounted Sun Nov 22 14:08:34 2009 Setting recovery target incarnation to 2 Sun Nov 22 14:08:34 2009 Successful mount of redo thread 1, with mount id 409323218 Sun Nov 22 14:08:34 2009 Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE) Completed: ALTER DATABASE MOUNT Sun Nov 22 14:08:36 2009 ALTER DATABASE OPEN Picked broadcast on commit scheme to generate SCNs Sun Nov 22 14:08:42 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=29, OS id=9725 Sun Nov 22 14:08:43 2009 ARC0: Archival started ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE ARC1 started with pid=30, OS id=9728 Sun Nov 22 14:08:45 2009 Thread 1 opened at log sequence 140 Current log# 6 seq# 140 mem# 0: +LLPWDB/racdbidc/onlinelog/group_6.277.703330629 Current log# 6 seq# 140 mem# 1: +LLPWDB/racdbidc/onlinelog/loggroup6-2 Successful open of redo thread 1 Sun Nov 22 14:08:45 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sun Nov 22 14:08:45 2009 ARC0: STARTING ARCH PROCESSES Sun Nov 22 14:08:45 2009 ARC1: Becoming the 'no FAL' ARCH ARC1: Becoming the 'no SRL' ARCH Sun Nov 22 14:08:45 2009 SMON: enabling cache recovery Sun Nov 22 14:08:45 2009 ARC2: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE ARC0: Becoming the heartbeat ARCH ARC2 started with pid=31, OS id=9782 Sun Nov 22 14:08:45 2009 Successfully onlined Undo Tablespace 1. Sun Nov 22 14:08:45 2009 SMON: enabling tx recovery Sun Nov 22 14:08:45 2009 Database Characterset is AL32UTF8 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=32, OS id=9809 Sun Nov 22 14:08:48 2009 Completed: ALTER DATABASE OPEN Sun Nov 22 14:14:43 2009 Shutting down archive processes Sun Nov 22 14:14:48 2009 ARCH shutting down ARC2: Archival stopped [root@racdb3 bdump]# tail -200 alert_racdbidc1.log Sun Nov 22 12:43:26 2009 LMS 0: 0 GCS shadows cancelled, 0 closed Set master node info Submitted all remote-enqueue requests Dwn-cvts replayed, VALBLKs dubious All grantable enqueues granted Sun Nov 22 12:43:26 2009 LMS 1: 5482 GCS shadows traversed, 3040 replayed Sun Nov 22 12:43:26 2009 LMS 0: 5423 GCS shadows traversed, 2971 replayed Sun Nov 22 12:43:26 2009 Submitted all GCS remote-cache requests Post SMON to start 1st pass IR Fix write in gcs resources Reconfiguration complete Sun Nov 22 12:43:26 2009 Completed instance recovery at Thread 2: logseq 363, block 20704, scn 3102830 52 data blocks read, 68 data blocks written, 225 redo blocks read Switch log for thread 2 to sequence 364 Sun Nov 22 12:52:44 2009 db_recovery_file_dest_size of 204800 MB is 0.11% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Sun Nov 22 14:08:12 2009 Shutting down instance (abort) License high water mark = 19 Instance terminated by USER, pid = 8775 Sun Nov 22 14:08:15 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Interface type 1 eth1 172.16.1.0 configured from OCR for use as a cluster interconnect Interface type 1 eth0 192.168.1.0 configured from OCR for use as a public interface Picked latch-free SCN scheme 1 WARNING: db_recovery_file_dest is same as db_create_file_dest Autotune of undo retention is turned on. LICENSE_MAX_USERS = 0 SYS auditing is disabled ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.1.0. System parameters with non-default values: processes = 300 sessions = 335 __shared_pool_size = 754974720 __large_pool_size = 16777216 __java_pool_size = 16777216 __streams_pool_size = 0 spfile = +LLPWDB/racdbidc/spfileracdbidc.ora sga_target = 2483027968 control_files = +LLPWDB/racdbidc/controlfile/current.261.703277161, +LLPWDB/racdbidc/controlfile/current.260.703277163 db_block_size = 8192 __db_cache_size = 1677721600 compatible = 10.2.0.1.0 log_archive_dest_1 = location=/logstore/archlog db_file_multiblock_read_count= 16 cluster_database = TRUE cluster_database_instances= 2 db_create_file_dest = +LLPWDB db_recovery_file_dest = +LLPWDB db_recovery_file_dest_size= 214748364800 thread = 1 instance_number = 1 undo_management = AUTO undo_tablespace = UNDOTBS1 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=racdbidcXDB) remote_listener = LISTENERS_RACDBIDC job_queue_processes = 10 background_dump_dest = /u01/app/oracle/admin/racdbidc/bdump user_dump_dest = /u01/app/oracle/admin/racdbidc/udump core_dump_dest = /u01/app/oracle/admin/racdbidc/cdump audit_file_dest = /u01/app/oracle/admin/racdbidc/adump db_name = racdbidc open_cursors = 300 pga_aggregate_target = 824180736 Cluster communication is configured to use the following interface(s) for this instance 172.16.1.215 Sun Nov 22 14:08:15 2009 cluster interconnect IPC version:Oracle UDP/IP IPC Vendor 1 proto 2 PMON started with pid=2, OS id=8886 DIAG started with pid=3, OS id=8888 PSP0 started with pid=4, OS id=8890 LMON started with pid=5, OS id=8892 LMD0 started with pid=6, OS id=8894 LMS0 started with pid=7, OS id=8896 LMS1 started with pid=8, OS id=8900 MMAN started with pid=9, OS id=8904 DBW0 started with pid=10, OS id=8929 LGWR started with pid=11, OS id=8934 CKPT started with pid=12, OS id=8936 SMON started with pid=13, OS id=8938 RECO started with pid=14, OS id=8940 CJQ0 started with pid=15, OS id=8942 MMON started with pid=16, OS id=8944 Sun Nov 22 14:08:15 2009 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... MMNL started with pid=17, OS id=8946 Sun Nov 22 14:08:15 2009 starting up 1 shared server(s) ... Sun Nov 22 14:08:15 2009 lmon registered with NM - instance id 1 (internal mem no 0) Sun Nov 22 14:08:19 2009 Reconfiguration started (old inc 0, new inc 72) pseudo shared rm latch used List of nodes: 0 1 Global Resource Directory frozen * allocate domain 0, invalid = TRUE Communication channels reestablished * domain 0 not valid according to instance 1 * domain 0 valid = 0 according to instance 1 Sun Nov 22 14:08:20 2009 Master broadcasted resource hash value bitmaps Non-local Process blocks cleaned out Sun Nov 22 14:08:20 2009 LMS 0: 0 GCS shadows cancelled, 0 closed Sun Nov 22 14:08:20 2009 LMS 1: 0 GCS shadows cancelled, 0 closed Set master node info Submitted all remote-enqueue requests Dwn-cvts replayed, VALBLKs dubious All grantable enqueues granted Post SMON to start 1st pass IR Sun Nov 22 14:08:20 2009 LMS 1: 0 GCS shadows traversed, 0 replayed Sun Nov 22 14:08:20 2009 LMS 0: 0 GCS shadows traversed, 0 replayed Sun Nov 22 14:08:20 2009 Submitted all GCS remote-cache requests Post SMON to start 1st pass IR Fix write in gcs resources Reconfiguration complete LCK0 started with pid=20, OS id=9093 Sun Nov 22 14:08:21 2009 ALTER DATABASE MOUNT Sun Nov 22 14:08:21 2009 Starting background process ASMB ASMB started with pid=22, OS id=9099 Starting background process RBAL RBAL started with pid=23, OS id=9104 Loaded ASM Library - Generic Linux, version 2.0.4 (KABI_V2) library for asmlib interface Sun Nov 22 14:08:30 2009 SUCCESS: diskgroup LLPWDB was mounted Sun Nov 22 14:08:34 2009 Setting recovery target incarnation to 2 Sun Nov 22 14:08:34 2009 Successful mount of redo thread 1, with mount id 409323218 Sun Nov 22 14:08:34 2009 Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE) Completed: ALTER DATABASE MOUNT Sun Nov 22 14:08:36 2009 ALTER DATABASE OPEN Picked broadcast on commit scheme to generate SCNs Sun Nov 22 14:08:42 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=29, OS id=9725 Sun Nov 22 14:08:43 2009 ARC0: Archival started ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE ARC1 started with pid=30, OS id=9728 Sun Nov 22 14:08:45 2009 Thread 1 opened at log sequence 140 Current log# 6 seq# 140 mem# 0: +LLPWDB/racdbidc/onlinelog/group_6.277.703330629 Current log# 6 seq# 140 mem# 1: +LLPWDB/racdbidc/onlinelog/loggroup6-2 Successful open of redo thread 1 Sun Nov 22 14:08:45 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sun Nov 22 14:08:45 2009 ARC0: STARTING ARCH PROCESSES Sun Nov 22 14:08:45 2009 ARC1: Becoming the 'no FAL' ARCH ARC1: Becoming the 'no SRL' ARCH Sun Nov 22 14:08:45 2009 SMON: enabling cache recovery Sun Nov 22 14:08:45 2009 ARC2: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE ARC0: Becoming the heartbeat ARCH ARC2 started with pid=31, OS id=9782 Sun Nov 22 14:08:45 2009 Successfully onlined Undo Tablespace 1. Sun Nov 22 14:08:45 2009 SMON: enabling tx recovery Sun Nov 22 14:08:45 2009 Database Characterset is AL32UTF8 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=32, OS id=9809 Sun Nov 22 14:08:48 2009 Completed: ALTER DATABASE OPEN Sun Nov 22 14:14:43 2009 Shutting down archive processes Sun Nov 22 14:14:48 2009 ARCH shutting down ARC2: Archival stopped 本文转自 jxwpx 51CTO博客，原文链接：http://blog.51cto.com/jxwpx/231919，如需转载请自行联系原作者