遇到ORA600 [4000] 的错误,急死人了
一个库3T 数据库,一次突然断电导致数据库起不来了,很不幸运备份没有了.ALERT 出现了如下错误,
但是在如何用BBED处理错误的过程比较简略,我查看了edw_ora_676102.trc 里面有有FLAG=-----的标志,跟盖国强描述的一致.
但是我看不明白文献里BBED如何处理的,也没用过BBED....现在要起这个库,我恳求ITPUB的兄弟帮帮我
-----ALERT--------------------------
Thread 1 advanced to log sequence 2
Thread 1 opened at log sequence 2
Current log# 4 seq# 2 mem# 0: /oradata/pdb01/redo0401.log
Current log# 4 seq# 2 mem# 1: /oradata/pdb02/redo0402.log
Successful open of redo thread 1
Fri Dec 12 17:49:07 2008
SMON: enabling cache recovery
Fri Dec 12 17:49:08 2008
Errors in file /u01/oracle/admin/db/udump/edw_ora_676102.trc:
ORA-00600: internal error code, arguments: , , [], [], [], [], [], []
Fri Dec 12 17:49:11 2008
Errors in file /u01/oracle/admin/dbudump/edw_ora_676102.trc:
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00600: internal error code, arguments: , , [], [], [], [], [], []
Fri Dec 12 17:49:11 2008
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 676102
ORA-1092 signalled during: alter database open...
-------------edw_ora_676102.trc部分内容--------------
*** 2008-12-12 17:49:08.293
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: , , [], [], [], [], [], []
Current SQL statement for this session:
select ctime, mtime, stime from obj$ where obj# = :1
----- Call Stack Trace -----
`````
...skipping...
0x02 0x0004.03e.00000d68 0x0280004a.16b9.73 --U- 1 fsc 0x0000.5864d104
data_block_dump,data header at 0x70000016f7d005c
===============
tsiz: 0x7fa0
hsiz: 0x340
pbl: 0x70000016f7d005c
bdba: 0x0040005e
76543210
flag=--------
ntab=1
nrow=407
frre=-1
fsbo=0x340
fseo=0xa05
avsp=0xc83
tosp=0xc83
0xeti nrow=407 offs=0 之前用过_allow_resetlogs_corruption=TRUE,恢复过,希望能强拉起DB
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
我想问下,如何确定这个未提交的信息,在那个数据文件上啊.BBED是对数据文件的操作
页:
[1]