Sat Mar 20 11:35:51 2010 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Interface type 1 eth0 192.168.3.0 configured from OCR for use as a cluster interconnect WARNING 192.168.3.0 could not be translated to a network address error 1 Interface type 1 eth2 192.168.3.0 configured from OCR for use as a cluster interconnect Interface type 1 eth0 192.168.0.0 configured from OCR for use as a public interface Picked latch-free SCN scheme 2 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_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 = 150 __shared_pool_size = 113246208 __large_pool_size = 4194304 __java_pool_size = 4194304 __streams_pool_size = 0 spfile = +RACDB_DATA1/racdb/spfileracdb.ora sga_target = 285212672 control_files = +RACDB_DATA1/racdb/controlfile/current.256.707585805, +FLASH_RECOVERY_AREA/racdb/controlfile/current.256.7075 85807 db_block_size = 8192 __db_cache_size = 159383552 compatible = 10.2.0.1.0 db_file_multiblock_read_count= 16 cluster_database = TRUE cluster_database_instances= 2 db_create_file_dest = +RACDB_DATA1 db_recovery_file_dest = +FLASH_RECOVERY_AREA db_recovery_file_dest_size= 8589934592 thread = 1 instance_number = 1 undo_management = AUTO undo_tablespace = UNDOTBS1 remote_login_passwordfile= EXCLUSIVE db_domain = idevelopment.info service_names = racdb.idevelopment.info, racdb_taf dispatchers = (PROTOCOL=TCP) (SERVICE=racdbXDB) remote_listener = LISTENERS_RACDB job_queue_processes = 10 background_dump_dest = /u01/app/oracle/admin/racdb/bdump user_dump_dest = /u01/app/oracle/admin/racdb/udump core_dump_dest = /u01/app/oracle/admin/racdb/cdump audit_file_dest = /u01/app/oracle/admin/racdb/adump db_name = racdb open_cursors = 300 pga_aggregate_target = 94371840 Cluster communication is configured to use the following interface(s) for this instance 192.168.3.60 Sat Mar 20 11:35:51 2010 cluster interconnect IPC version:Oracle UDP/IP IPC Vendor 1 proto 2 PMON started with pid=2, OS id=2367 DIAG started with pid=3, OS id=2376 PSP0 started with pid=4, OS id=2380 LMON started with pid=5, OS id=2382 LMD0 started with pid=6, OS id=2395 LMS0 started with pid=7, OS id=2404 MMAN started with pid=8, OS id=2414 DBW0 started with pid=9, OS id=2417 LGWR started with pid=10, OS id=2419 CKPT started with pid=11, OS id=2421 SMON started with pid=12, OS id=2423 RECO started with pid=13, OS id=2425 CJQ0 started with pid=14, OS id=2427 MMON started with pid=15, OS id=2429 Sat Mar 20 11:35:52 2010 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... MMNL started with pid=16, OS id=2431 Sat Mar 20 11:35:52 2010 starting up 1 shared server(s) ... Sat Mar 20 11:35:52 2010 lmon registered with NM - instance id 1 (internal mem no 0) Sat Mar 20 11:35:53 2010 Reconfiguration started (old inc 0, new inc 2) List of nodes: 0 Global Resource Directory frozen * allocate domain 0, invalid = TRUE Communication channels reestablished Master broadcasted resource hash value bitmaps Non-local Process blocks cleaned out Sat Mar 20 11:35:53 2010 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 Post SMON to start 1st pass IR Sat Mar 20 11:35:53 2010 LMS 0: 0 GCS shadows traversed, 0 replayed Sat Mar 20 11:35:53 2010 Submitted all GCS remote-cache requests Post SMON to start 1st pass IR Fix write in gcs resources Reconfiguration complete LCK0 started with pid=19, OS id=2463 Sat Mar 20 11:35:53 2010 ALTER DATABASE MOUNT Sat Mar 20 11:35:53 2010 This instance was first to mount Sat Mar 20 11:35:53 2010 Starting background process ASMB ASMB started with pid=21, OS id=2468 Starting background process RBAL RBAL started with pid=22, OS id=2472 Loaded ASM Library - Generic Linux, version 2.0.4 (KABI_V2) library for asmlib interface Sat Mar 20 11:35:57 2010 SUCCESS: diskgroup RACDB_DATA1 was mounted SUCCESS: diskgroup FLASH_RECOVERY_AREA was mounted Sat Mar 20 11:36:01 2010 Setting recovery target incarnation to 1 Sat Mar 20 11:36:02 2010 Successful mount of redo thread 1, with mount id 711703833 Sat Mar 20 11:36:02 2010 Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE) Completed: ALTER DATABASE MOUNT Sat Mar 20 11:36:02 2010 ALTER DATABASE OPEN This instance was first to open Picked broadcast on commit scheme to generate SCNs Sat Mar 20 11:36:03 2010 LGWR: STARTING ARCH PROCESSES ARC0: Archival started ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE ARC1 started with pid=26, OS id=2737 ARC0 started with pid=25, OS id=2735 Sat Mar 20 11:36:04 2010 Thread 1 opened at log sequence 31 Current log# 1 seq# 31 mem# 0: +RACDB_DATA1/racdb/onlinelog/group_1.257.707585811 Current log# 1 seq# 31 mem# 1: +FLASH_RECOVERY_AREA/racdb/onlinelog/group_1.257.707585815 Successful open of redo thread 1 Sat Mar 20 11:36:04 2010 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sat Mar 20 11:36:04 2010 ARC1: STARTING ARCH PROCESSES ARC2: Archival started ARC1: STARTING ARCH PROCESSES COMPLETE ARC1: Becoming the 'no FAL' ARCH ARC1: Becoming the 'no SRL' ARCH ARC2 started with pid=27, OS id=2764 Sat Mar 20 11:36:04 2010 ARC0: Becoming the heartbeat ARCH Sat Mar 20 11:36:05 2010 SMON: enabling cache recovery Sat Mar 20 11:36:07 2010 Successfully onlined Undo Tablespace 1. Sat Mar 20 11:36:07 2010 SMON: enabling tx recovery Sat Mar 20 11:36:07 2010 Instance recovery: looking for dead threads Instance recovery: lock domain invalid but no dead threads Sat Mar 20 11:36:07 2010 Database Characterset is WE8ISO8859P1 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=28, OS id=2966 Sat Mar 20 11:36:17 2010 db_recovery_file_dest_size of 8192 MB is 4.37% 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. Sat Mar 20 11:36:19 2010 Completed: ALTER DATABASE OPEN Sat Mar 20 11:37:03 2010 Reconfiguration started (old inc 2, new inc 4) List of nodes: 0 1 Global Resource Directory frozen Communication channels reestablished Master broadcasted resource hash value bitmaps Non-local Process blocks cleaned out Sat Mar 20 11:37:04 2010 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 Sat Mar 20 11:37:04 2010 LMS 0: 6430 GCS shadows traversed, 3291 replayed Sat Mar 20 11:37:04 2010 Submitted all GCS remote-cache requests Post SMON to start 1st pass IR Fix write in gcs resources Reconfiguration complete Sat Mar 20 11:42:04 2010 Shutting down archive processes Sat Mar 20 11:42:09 2010 ARCH shutting down ARC2: Archival stopped