- 最后登录
- 2012-3-11
- 在线时间
- 3 小时
- 威望
- 8
- 金钱
- 65
- 注册时间
- 2012-1-31
- 阅读权限
- 10
- 帖子
- 6
- 精华
- 0
- 积分
- 8
- UID
- 194
|
1#
发表于 2012-2-27 20:14:53
|
查看: 10792 |
回复: 11
ORACLE 10.2.0.4 RAC 出现一个节点频繁重启问题,alert.log报
Mon Feb 27 19:38:55 2012
Errors in file /oracle/app/oracle/admin/sctestdb/bdump/sctestdb1_p002_8995.trc:
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Mon Feb 27 19:38:56 2012
Errors in file /oracle/app/oracle/admin/sctestdb/bdump/sctestdb1_p002_8995.trc:
ORA-07445: exception encountered: core dump [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Mon Feb 27 19:38:56 2012
Trace dumping is performing id=[cdmp_20120227193856]
Mon Feb 27 19:38:56 2012
SUCCESS: diskgroup ORA_ARCHIVELOG was mounted
SUCCESS: diskgroup ORA_ARCHIVELOG was dismounted
SUCCESS: diskgroup ORA_ARCHIVELOG was mounted
Mon Feb 27 19:38:57 2012
Thread 2 advanced to log sequence 171708 (archiver wakeup)
Mon Feb 27 19:38:57 2012
Database Characterset is ZHS16GBK
Mon Feb 27 19:38:57 2012
SUCCESS: diskgroup ORA_ARCHIVELOG was dismounted
Mon Feb 27 19:38:57 2012
Opening with Resource Manager plan: INTERNAL_PLAN
where NUMA PG = 2, CPUs = 8
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=142, OS id=9107
Mon Feb 27 19:38:58 2012
Errors in file /oracle/app/oracle/admin/sctestdb/bdump/sctestdb1_p002_8995.trc:
ORA-07445: exception encountered: core dump [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8] [] []
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Mon Feb 27 19:38:58 2012
Completed: ALTER DATABASE OPEN
Mon Feb 27 19:38:59 2012
Errors in file /oracle/app/oracle/admin/sctestdb/bdump/sctestdb1_p002_8995.trc:
ORA-07445: exception encountered: core dump [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8] [] []
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8] [] []
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Mon Feb 27 19:39:02 2012
Doing block recovery for file 64 block 925405
Block recovery from logseq 211705, block 333 to scn 71136015173
Mon Feb 27 19:39:02 2012
Recovery of Online Redo Log: Thread 1 Group 10 Seq 211705 Reading mem 0
Mem# 0: +ORA_DG_1/sctestdb/onlinelog/group_10.273.729222079
Block recovery completed at rba 211705.352.16, scn 16.2416538438
Mon Feb 27 19:39:02 2012
SMON: slave died unexpectedly, downgrading to serial recovery
Mon Feb 27 19:39:02 2012
Errors in file /oracle/app/oracle/admin/sctestdb/bdump/sctestdb1_smon_8881.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [kghstack_free2]
Mon Feb 27 19:39:04 2012
Errors in file /oracle/app/oracle/admin/sctestdb/bdump/sctestdb1_smon_8881.trc:
ORA-07445: Message 7445 not found; No message file for product=RDBMS, facility=ORA; arguments: [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8]
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [kghstack_free2]
Mon Feb 27 19:39:04 2012
Trace dumping is performing id=[cdmp_20120227193904]
Mon Feb 27 19:39:05 2012
Errors in file /oracle/app/oracle/admin/sctestdb/bdump/sctestdb1_smon_8881.trc:
ORA-07445: Message 7445 not found; No message file for product=RDBMS, facility=ORA; arguments: [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8]
ORA-00607: Message 607 not found; No message file for product=RDBMS, facility=ORA
手动重启CRS及服务器后,数据库两个节点都无法启动,日志:
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes = 2000
sga_max_size = 10737418240
SUCCESS: diskgroup ORA_DATA_01 was mounted
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=102, OS id=11509
Mon Feb 27 19:42:26 2012
Thread 1 advanced to log sequence 211706 (thread open)
Thread 1 opened at log sequence 211706
Current log# 2 seq# 211706 mem# 0: +ORA_DG_1/sctestdb/onlinelog/group_2.267.729214243
Successful open of redo thread 1
Mon Feb 27 19:42:26 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Feb 27 19:42:26 2012
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Mon Feb 27 19:42:26 2012
SMON: enabling cache recovery
Mon Feb 27 19:42:26 2012
ARC1: Becoming the heartbeat ARCH
Mon Feb 27 19:42:26 2012
Successfully onlined Undo Tablespace 1.
Mon Feb 27 19:42:26 2012
SMON: enabling tx recovery
Mon Feb 27 19:42:27 2012
Errors in file /oracle/app/oracle/admin/sctestdb/bdump/sctestdb1_p002_11472.trc:
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Mon Feb 27 19:42:29 2012
Errors in file /oracle/app/oracle/admin/sctestdb/bdump/sctestdb1_p002_11472.trc:
ORA-07445: exception encountered: core dump [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Mon Feb 27 19:42:29 2012
Trace dumping is performing id=[cdmp_20120227194229]
Mon Feb 27 19:42:29 2012
SUCCESS: diskgroup ORA_ARCHIVELOG was mounted
SUCCESS: diskgroup ORA_ARCHIVELOG was dismounted
SUCCESS: diskgroup ORA_ARCHIVELOG was mounted
Mon Feb 27 19:42:29 2012
Database Characterset is ZHS16GBK
Mon Feb 27 19:42:29 2012
SUCCESS: diskgroup ORA_ARCHIVELOG was dismounted
Mon Feb 27 19:42:29 2012
Opening with Resource Manager plan: INTERNAL_PLAN
where NUMA PG = 2, CPUs = 8
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=144, OS id=11620
Mon Feb 27 19:42:30 2012
Errors in file /oracle/app/oracle/admin/sctestdb/bdump/sctestdb1_p002_11472.trc:
ORA-07445: exception encountered: core dump [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8] [] []
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Mon Feb 27 19:42:30 2012
Completed: alter database open
Mon Feb 27 19:42:31 2012
Errors in file /oracle/app/oracle/admin/sctestdb/bdump/sctestdb1_p002_11472.trc:
ORA-07445: exception encountered: core dump [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8] [] []
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8] [] []
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Mon Feb 27 19:42:34 2012
Doing block recovery for file 64 block 925405
Block recovery from logseq 211706, block 332 to scn 71136035741
Mon Feb 27 19:42:34 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 211706 Reading mem 0
Mem# 0: +ORA_DG_1/sctestdb/onlinelog/group_2.267.729214243
Block recovery completed at rba 211706.351.16, scn 16.2416559006
Mon Feb 27 19:42:34 2012
SMON: slave died unexpectedly, downgrading to serial recovery
Mon Feb 27 19:42:34 2012
Errors in file /oracle/app/oracle/admin/sctestdb/bdump/sctestdb1_smon_9989.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [kghstack_free2]
Mon Feb 27 19:42:35 2012
Errors in file /oracle/app/oracle/admin/sctestdb/bdump/sctestdb1_smon_9989.trc:
ORA-07445: Message 7445 not found; No message file for product=RDBMS, facility=ORA; arguments: [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8]
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [kghstack_free2]
Mon Feb 27 19:42:35 2012
Trace dumping is performing id=[cdmp_20120227194235]
Mon Feb 27 19:42:37 2012
Errors in file /oracle/app/oracle/admin/sctestdb/bdump/sctestdb1_smon_9989.trc:
ORA-07445: Message 7445 not found; No message file for product=RDBMS, facility=ORA; arguments: [kghstack_err()+288] [SIGSEGV] [Address not mapped to object] [0xFF08C9CCD2B5D6D8] |
|