Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

0

好友

3

主题
1#
发表于 2015-4-27 15:37:34 | 查看: 3334| 回复: 1
本帖最后由 linxs 于 2015-5-3 13:37 编辑

双节点1,节点1报ORA-00600: internal error code, arguments: [kjblpkeydrmqscchk:pkey], [999306], [12], [2476912], [0], [7], [0], [], [], [], [], []
数据库实例自动重启。详细信息请查看附件日志,麻烦大神们看看,谢谢!

数据库版本:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for Solaris: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

节点1:alert日志
Mon Apr 27 01:31:46 2015
Archived Log entry 61132 added for thread 1 sequence 41381 ID 0x39c8f03e dest 1:
Mon Apr 27 01:37:52 2015
Index RMS.IF_TRAN_DATA_I3 or some [sub]partitions of the index have been marked unusable
Index RMS.IF_TRAN_DATA_I1 or some [sub]partitions of the index have been marked unusable
Index RMS.IF_TRAN_DATA_I4 or some [sub]partitions of the index have been marked unusable
Index RMS.DEAL_PERF_TRAN_DATA_I1 or some [sub]partitions of the index have been marked unusable
Mon Apr 27 01:38:19 2015
Thread 1 advanced to log sequence 41383 (LGWR switch)
  Current log# 3 seq# 41383 mem# 0: +DATA1DG/rmsdb/onlinelog/group_3.256.844074027
Mon Apr 27 01:38:23 2015
Archived Log entry 61133 added for thread 1 sequence 41382 ID 0x39c8f03e dest 1:
Mon Apr 27 01:38:43 2015
Thread 1 advanced to log sequence 41384 (LGWR switch)
  Current log# 4 seq# 41384 mem# 0: +DATA1DG/rmsdb/onlinelog/group_4.259.844074019
Mon Apr 27 01:38:47 2015
Archived Log entry 61135 added for thread 1 sequence 41383 ID 0x39c8f03e dest 1:
Mon Apr 27 01:38:55 2015
Index RMS.REPL_ITEM_LOC_UPDATES_I1 or some [sub]partitions of the index have been marked unusable
Index RMS.REPL_ITEM_LOC_UPDATES_I2 or some [sub]partitions of the index have been marked unusable
Mon Apr 27 01:39:01 2015
Thread 1 advanced to log sequence 41385 (LGWR switch)
  Current log# 5 seq# 41385 mem# 0: +DATA1DG/rmsdb/onlinelog/group_5.258.844074011
Mon Apr 27 01:39:05 2015
Archived Log entry 61136 added for thread 1 sequence 41384 ID 0x39c8f03e dest 1:
Mon Apr 27 01:39:19 2015
Thread 1 advanced to log sequence 41386 (LGWR switch)
  Current log# 1 seq# 41386 mem# 0: +DATA1DG/rmsdb/onlinelog/group_1.261.844074041
Mon Apr 27 01:39:23 2015
Archived Log entry 61137 added for thread 1 sequence 41385 ID 0x39c8f03e dest 1:
Mon Apr 27 01:39:43 2015
Thread 1 advanced to log sequence 41387 (LGWR switch)
  Current log# 2 seq# 41387 mem# 0: +DATA1DG/rmsdb/onlinelog/group_2.260.844074035
Mon Apr 27 01:39:48 2015
Archived Log entry 61139 added for thread 1 sequence 41386 ID 0x39c8f03e dest 1:
Mon Apr 27 01:40:07 2015
Thread 1 advanced to log sequence 41388 (LGWR switch)
  Current log# 3 seq# 41388 mem# 0: +DATA1DG/rmsdb/onlinelog/group_3.256.844074027
Mon Apr 27 01:40:11 2015
Archived Log entry 61140 added for thread 1 sequence 41387 ID 0x39c8f03e dest 1:
Mon Apr 27 01:40:53 2015
Index RMS.HIST_REBUILD_MASK_I1 or some [sub]partitions of the index have been marked unusable
Mon Apr 27 01:40:54 2015
Errors in file /u01/app/oracle/diag/rdbms/rmsdb/rmsdb1/trace/rmsdb1_lms4_19133.trc  (incident=1536630):
ORA-00600: internal error code, arguments: [kjblpkeydrmqscchk:pkey], [999306], [12], [2476912], [0], [7], [0], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/rmsdb/rmsdb1/incident/incdir_1536630/rmsdb1_lms4_19133_i1536630.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Apr 27 01:40:56 2015
Dumping diagnostic data in directory=[cdmp_20150427014056], requested by (instance=1, osid=19133 (LMS4)), summary=[incident=1536630].
Mon Apr 27 01:40:59 2015
Sweep [inc][1536630]: completed
Sweep [inc2][1536630]: completed
Errors in file /u01/app/oracle/diag/rdbms/rmsdb/rmsdb1/trace/rmsdb1_lms4_19133.trc:
ORA-00600: internal error code, arguments: [kjblpkeydrmqscchk:pkey], [999306], [12], [2476912], [0], [7], [0], [], [], [], [], []
LMS4 (ospid: 19133): terminating the instance due to error 484
Mon Apr 27 01:41:08 2015
Instance terminated by LMS4, pid = 19133
Mon Apr 27 01:41:30 2015
Adjusting the default value of parameter parallel_max_servers
from 7680 to 2985 due to the value of parameter processes (3000)
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Mon Apr 27 01:41:41 2015
Private Interface 'igb2:1' configured from GPnP for use as a private interconnect.
  [name='igb2:1', type=1, ip=169.254.26.113, mac=a0-36-9f-2e-21-42-00-00-00-00-00-00-00-00-00-00-00-2f-ff-ff, net=169.254.0.0/17, mask=255.255.128.0, use=haip:cluster_interconnect/62]
Private Interface 'igb3:1' configured from GPnP for use as a private interconnect.
  [name='igb3:1', type=1, ip=169.254.193.63, mac=a0-36-9f-2e-21-43-00-00-00-00-00-00-00-00-00-00-00-2f-ff-ff, net=169.254.128.0/17, mask=255.255.128.0, use=haip:cluster_interconnect/62]
Public Interface 'ixgbe0' configured from GPnP for use as a public interface.
  [name='ixgbe0', type=1, ip=192.168.0.103, mac=00-10-e0-3f-46-de-00-00-00-00-00-00-00-00-00-00-00-2f-ff-ff, net=192.168.0.0/24, mask=255.255.255.0, use=public/1]
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name:        SunOS
Node name:        sfmomdb1
Release:        5.10
Version:        Generic_150400-07
Machine:        sun4v
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/db_1/dbs/spfilermsdb1.ora
System parameters with non-default values:
  processes                = 3000
  sessions                 = 4608
  sga_max_size             = 90G
  shared_pool_size         = 5G
  large_pool_size          = 3G

2#
发表于 2016-4-27 10:02:15
set _gc_read_mostly_locking=false

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 20:24 , Processed in 0.047858 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569