windows32位平台数据库宕机不能open怎么办(二)
RESETLOGS
MAXLOGFILES 16
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 (
'/opt/oracle/oradata/tjserver/REDO01.LOG'
) SIZE 50M,
GROUP 2 '/opt/oracle/oradata/tjserver/REDO02.LOG' SIZE 50M,
GROUP 3 '/opt/oracle/oradata/tjserver/REDO03.LOG' SIZE 50M
DATAFILE
'/opt/oracle/oradata/tjserver/SYSTEM01.DBF.NEW',
'/opt/oracle/oradata/tjserver/UNDOTBS01.DBF.NEW',
'/opt/oracle/oradata/tjserver/SYSAUX01.DBF.NEW',
'/opt/oracle/oradata/tjserver/USERS01.DBF.NEW',
'/opt/oracle/oradata/tjserver/INDEX01.DBF.NEW'
CHARACTER SET US7ASCII;
5、使用BBED工具修改数据块
这里就涉及到，要修改哪个文件？哪个数据块？多少偏移量？修改成多少？
我咋知道它是对的错的呢？
我咋知道它是对的错的呢？
这些都需要详细看日志。
打开alerttjserver.log中提示的trace文件：
d:\oracle\admin\tjserver\udump\tjserver_ora_1614.trc
在跟踪文件中，可以发现以下信息：
[plain]
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [4000], [7], [], [], [], [], [], []
Current SQL statement for this session:
select ctime, mtime, stime from obj$ where obj# = :1
----- Call Stack Trace -----
calling call entry argument values in hex
location type point ( means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+23 0000000000000000 00142A73C
000000000 0FFDF5830
000000000 0FFDF5830
0FFFFFD7F
ksedmp()+796 0000000000000000 001429231
000000000 005E1BF08
000000000
ksfdmp()+16 0000000000000000 00146ACA5
000000000 0FFDF5870
000000000 0FFDF5870
0FFFFFD7F
可看到，在查询obj$表时，报出这个错误了。
[plain]
SO: 3892c9e48, type: 24, owner: 389f96618, flag: INIT/-/-/0x00
(buffer) (CR) PR: 389e5acc0 FLG: 0x500000
class bit: 0
kcbbfbp: [BH: 384bfb7e0, LINK: 3892c9e88]
where: kdswh02: kdsgrp, why: 0
BH (384bfb7e0) file#: 1 rdba: 0x0040007a (1/122) class: 1 ba: 384bce000
set: 3 blksize: 8192 bsi: 0 set-flg: 2 pwbcnt: 0
dbwrid: 0 obj: 18 objn: 18 tsn: 0 afn: 1
hash: [38922bf00,38922bf00] lru: [384bfb958,3892cbb68]
ckptq: [NULL] fileq: [NULL] objq: [386f2dcb0,386f2dcb0]
use: [3892c9e88,3892c9e88] wait: [NULL]
st: XCURRENT md: SHR tch: 0
flags:
LRBA: [0x0.0.0] HSCN: [0xffff.ffffffff] HSUB: [65535]
Using State Objects
----------------------------------------
SO: 3892c9e48, type: 24, owner: 389f96618, flag: INIT/-/-/0x00
(buffer) (CR) PR: 389e5acc0 FLG: 0x500000
class bit: 0
kcbbfbp: [BH: 384bfb7e0, LINK: 3892c9e88]
where: kdswh02: kdsgrp, why: 0
buffer tsn: 0 rdba: 0x0040007a (1/122)
scn: 0x0000.03b1926f seq: 0x01 flg: 0x06 tail: 0x926f0601
frmt: 0x02 chkval: 0xa8ac type: 0x06=trans data
可以看到，出错位置在第一个数据文件的122个block上。
[plain]
Block header dump: 0x0040007a
Object id on Block Y
seg/obj: 0x12 csc: 0x00.3b1926e itc: 1 flg: - typ: 1 - DATA
fsl: 0 fnx: 0x0 ver: 0x01
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0007.00c.00007ec1 0x00800031.451f.01 --U- 1 fsc 0x0