oracle实例异常中断后重启动数据库遇到ora-00600[3705]错误,盼高手解决

Question

服务器掉电了，oracle实例启动不了。查看bdump下日志alert_gg.log 部分内容如下：
Fri Nov 22 15:23:06 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 209715200
sga_max_size = 421076188
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\gg\CONTROL01.CTL, D:\oracle\oradata\gg\CONTROL02.CTL, D:\oracle\oradata\gg\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 109051904
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = gg
dispatchers = (PROTOCOL=TCP) (SERVICE=ggXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\gg\bdump
user_dump_dest = D:\oracle\admin\gg\udump
core_dump_dest = D:\oracle\admin\gg\cdump
sort_area_size = 524288
db_name = gg
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 838860800
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Fri Nov 22 15:23:08 2013
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Nov 22 15:23:10 2013
ALTER DATABASE MOUNT
Fri Nov 22 15:23:14 2013
Successful mount of redo thread 1, with mount id 1446587550.
Fri Nov 22 15:23:14 2013
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Nov 22 15:23:15 2013
ALTER DATABASE OPEN
Fri Nov 22 15:23:15 2013
Errors in file d:\oracle\admin\gg\bdump\gg_lgwr_1212.trc:
ORA-00600: internal error code, arguments: [3705], [1], [1], [1], [0], [], [], []
Fri Nov 22 15:23:19 2013
Errors in file d:\oracle\admin\gg\bdump\gg_lgwr_1212.trc:
ORA-00600: internal error code, arguments: [3705], [1], [1], [1], [0], [], [], []
Fri Nov 22 15:23:19 2013
LGWR: terminating instance due to error 600
Instance terminated by LGWR, pid = 1212

望高手帮助解决

Answer 1

ORA-00600: internal error code, arguments: [3705], [1], [1], [1], [0], [], [], []

Database fails to start with ORA-00600: internal error code, arguments: [3705], [1], [1], [1], [1],

Trace file shows:

ksedmp: internal or fatal error
ORA-00345: redo log write error block 2798 count 2
ORA-00312: online log 2 thread 1: 'J:\MCS_REDO\REDO02.LOG'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 21) The device is not ready.

Call stack is:

ksedmp ksfdmp kgeriv kgesiv ksesic4 kctopn kcttha ksbabs ksbrdp
All files are at the same checkpoint scn and alert log shows database was previously closed tidily.
CAUSE
Bug 3397131
Abstract: CONTROL FILE / REDO FLAG MISMATCH ORA-600[3705]
The root cause of this error is an underlying OS issue.
Everytime a controlfile transaction that modifies anything in the controlfile ends, oracle writes a updated seq# in the controlfile which we also record in the current online redolog; when we next read the controlfile we validate that the seq# in the controlfile is as we expect it to be. This error indicates a stale read of the controlfile and should be investigated by the Os vendor.

这个错误是控制文件存在讹误了，需要修复控制文件

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

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

Answer 2

sqlplus / as sysdba
sql>startup mount
sql>recover database
sql>stutdown immediate
sql>startup

不行就找备份恢复吧追问

能mount，recover时 报00283、00264错误，有其他办法吗

追答

已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount
ORACLE 例程已经启动。
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
数据库装载完毕。
SQL> recover database;
完成介质恢复。
SQL> alter database open;
数据库已更改。
SQL>exit;

本回答被网友采纳

Answer 3

参考我的处理link ：网页链接 如果不能自行解决，可以联系我们进行分析

Answer 4

d:\oracle\admin\gg\bdump\gg_lgwr_1212.trc: 这个文件的内容呢？

Answer 5

startup force