最近ORACLE RAC反复出现这个状况,正在找原因

简介:
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,如需转载请自行联系原作者
目录
相关文章
|
4月前
|
运维 Oracle 前端开发
Oracle 11g RAC集群日常运维命令总结
Oracle 11g RAC集群日常运维命令总结
107 2
|
4月前
|
Oracle 关系型数据库
分布式锁设计问题之Oracle RAC保证多个节点写入内存Page的一致性如何解决
分布式锁设计问题之Oracle RAC保证多个节点写入内存Page的一致性如何解决
|
5月前
|
存储 负载均衡 Oracle
|
5月前
|
存储 Oracle 关系型数据库
|
7月前
|
存储 Oracle 关系型数据库
Oracle RAC:数据库集群的舞动乐章
【4月更文挑战第19天】Oracle RAC是Oracle提供的高可用性数据库解决方案,允许多个实例共享同一数据库,确保业务连续性和数据完整性。通过集群件和全局缓存服务实现服务器间的协调和通信。RAC提供高可用性,通过故障转移应对故障,同时提升性能,多个实例并行处理请求。作为数据管理员,理解RAC的架构和管理至关重要,以发挥其在数据管理中的最大价值。
|
7月前
|
存储 运维 Oracle
Oracle系列十八:Oracle RAC
Oracle系列十八:Oracle RAC
|
7月前
|
Oracle 关系型数据库
oracle rac 手工安装补丁,不适用auto
oracle rac 手工安装补丁,不适用auto
84 3
|
7月前
|
Oracle 关系型数据库
oracle Hanganalyze no RAC
oracle Hanganalyze no RAC
49 0