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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-16 00:04:11 | 查看: 1762| 回复: 0

ORA-00600: internal error code, arguments: [4194] 数据库恢复
记录下当时数据库诊断和恢复大致步骤 oracle 10g rac
大致情况如下:
半夜3点钟,驻地工程师电话打给我说是RAC数据库服务器突然重启了,起来后oracle进程占用CPU 99%-100%。我SSH远程登录上查看了下,原来是oracle系统进程想smon、dbwn等一些进程很不正常。
这个时候,第一要去查看的是alert文件,发现有以下错误:
Sat Apr  7 03:42:54 2012
alter database open
Sat Apr  7 03:42:54 2012
This instance was first to open
Sat Apr  7 03:42:58 2012
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Sat Apr  7 03:42:59 2012
Started redo scan
Sat Apr  7 03:42:59 2012
Completed redo scan
142 redo blocks read, 99 data blocks need recovery
Sat Apr  7 03:42:59 2012
Started redo application at
Thread 2: logseq 78462, block 332
Sat Apr  7 03:42:59 2012
Recovery of Online Redo Log: Thread 2 Group 14 Seq 78462 Reading mem 0
  Mem# 0: +ASM_VAS_STORAGE/ora9i/onlinelog/redo1401
Sat Apr  7 03:42:59 2012
Completed redo application
Sat Apr  7 03:42:59 2012
Completed crash recovery at
Thread 2: logseq 78462, block 474, scn 12417856572307
99 data blocks read, 99 data blocks written, 142 redo blocks read
Picked broadcast on commit scheme to generate SCNs
Sat Apr  7 03:43:00 2012
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=33, OS id=13815
ARC1 started with pid=34, OS id=13817
ARC2 started with pid=35, OS id=13844
ARC3 started with pid=36, OS id=13846
Sat Apr  7 03:43:00 2012
ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC4: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC4 started with pid=37, OS id=13848
Sat Apr  7 03:43:00 2012
Thread 2 advanced to log sequence 78463 (thread open)
Thread 2 opened at log sequence 78463
  Current log# 15 seq# 78463 mem# 0: +ASM_VAS_STORAGE/ora9i/onlinelog/redo1501
Successful open of redo thread 2
Sat Apr  7 03:43:00 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Apr  7 03:43:00 2012
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Sat Apr  7 03:43:00 2012
ARC2: Becoming the heartbeat ARCH
Sat Apr  7 03:43:00 2012
SMON: enabling cache recovery
Sat Apr  7 03:43:01 2012
Successfully onlined Undo Tablespace 5.
Sat Apr  7 03:43:01 2012
SMON: enabling tx recovery
Sat Apr  7 03:43:04 2012
Thread 1 advanced to log sequence 30000 (archiver wakeup)
Sat Apr  7 03:43:04 2012
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 4
replication_dependency_tracking turned off (no async multimaster replication found)
Sat Apr  7 03:43:05 2012
Errors in file /opt/oracle/admin/ora9i/bdump/ora9i2_smon_12689.trc:
ORA-00600: internal error code, arguments: [4194], [51], [47], [], [], [], [], []
Starting background process QMNC
QMNC started with pid=41, OS id=14000
Sat Apr  7 03:43:08 2012
Completed: alter database open
Sat Apr  7 03:43:09 2012
Errors in file /opt/oracle/admin/ora9i/bdump/ora9i2_mmon_12695.trc:
ORA-00600: internal error code, arguments: [4194], [28], [27], [], [], [], [], []

一看到到 600 4194 错误,就推断数据库服务器在重启的时候,undo在处理事务的时候 oracle异常关闭才出现的问题。
(幸好2节点只有B节点出现问题)
找到问题根源就容易解决问题了
上下翻看了log,找到以下一段:
Errors in file /opt/oracle/admin/ora9i/bdump/ora9i2_smon_25366.trc:
ORA-01595: error freeing extent (48) of rollback segment (12))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [51], [47], [], [], [], [], []

回滚段异常,数据库是不能正常关闭的,不然会出现以下错误:
SQL> shutdown immediate;
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [26], [22], [], [], [], [],
[]

解决方法如下:
SQL> create pfile='/home/oracle/pfile.ora' from spfile;
SQL> shutdown abort;
/home/oracle/pfile.ora 文件添加以下两行
ora9i2.undo_management='MANUAL'
ora9i2._corrupted_rollback_segments='_SYSSMU12$'
SQL> startup pfile=/home/oracle/pfile.ora --到这一步,是能正常启动的
--重建undo表空间
SQL> drop tablespace undotbs2 including contents and datafiles;
SQL> create undo tablespace undotbs2 datafile '+ASM_VAS_STORAGE/ora9i/datafile/undotbs2.dbf' size 4096m autoextend on next 50m maxsize 10240m;
SQL> shutdown immediate; --能正常关闭
SQL> startup   --启动正常
恢复完毕
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

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

GMT+8, 2024-12-23 16:01 , Processed in 0.060592 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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