- 论坛徽章:
- 0
|
有一个oracle 9.2.0.4.0 的数据库,一直运行正常,昨天突然出现故障,连接成功后,不能查询;
手工重启了一下,报错如下:
[oracle@scxcioms1 oracle]$ sqlplus '/as sysdba'
SQL*Plus: Release 9.2.0.4.0 - Production on Wed Mar 8 13:30:59 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup ;
ORACLE instance started.
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [],
[], [], []
手工用recover database的方法恢复时,也是失败的,操作过程如下:
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [8390130], [1], [67], [275],
[16], [], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 1522)
ORA-10564: tablespace UNDOTBS1
ORA-01110: data file 2: '/home/oracle/oradata/tsioms/undotbs01.dbf'
ORA-10560: block type 'KTU UNDO BLOCK'
想请教各位高手,这个问题怎么解决啊,先感谢。 |
|