详解ORA-00600[4097]错误

ORA-00600[4097]错误的一些案例如下:

Oracle内部错误:ORA-00600:[4097]一例

该ORA-00600[4097]错误从Oracle 7.3版本中被引入,遇到该错误一般说明Oracle在访问一个回滚段头rollback segment header时检查其事务是否已经被提交,但发现其相关的XID存在问题。这一般是因为回滚段存在损坏/讹误导致的。该错误属于内核Rollback回滚层。 其可能导致数据库无法打开或持续的报错,甚至于数据丢失。

ORA-00600[4097]错误的相关BUG如下:

 

13340388
11.2.0.3.3, 11.2.0.3.BP07, 12.1.0.0
ORA-600 [kzaxpopr14 -Error in decoding xml text] when querying V$XML_AUDIT_TRAIL

10249791 11.2.0.2.BP02,on DMLS referencing SECUREFILE plugged
11.2.0.2.7,
11.2.0.3, 12.1.0.0 11.1.0.7.4, 11.2.0.1.2, 11.2.0.2, 12.1.0.0 11.1.0.7.2, 11.2.0.1.1,
11.2.0.2, 12.1.0.0
7687856 11.2.0.1 5653641 11.2.0.1
ORA-600 [4097] / ORA-600 [4000] reported using transportable tablespaces
* 9145541
OERI[25027]/OERI[4097]/OERI[4000]/ORA- 1555 in plugged datafile after CREATE CONTROLFILE in 11g
OERI[4097] after using distributed 8565708 11.2.0.1.BP04,transactions in RAC
3613078
2628232
9.2.0.6,
ORA-600 [4000] from DML on transported ASSM tablespace
Corrupt dictionary from DROP TABLESPACE containing _offline_rollback_segments OERI[4097] from DML on TRANSPORTED tables with ASSM
Block corruption possible on temp files
ORA-600's from CR served block from a plugged in tablespace
OERI:4097 possible on objects in read only transported tablespace
Tru64: OERI:4097 possible on RAC / OPS
Drop of Rollback segments can cause OERI:4097 / missing data
10.1.0.3 3249755 9.2.0.5, 10.1.0.2 9.2.0.4,
10.1.0.2
8.1.7.4, 2165601 9.0.1.3, 9.2.0.1
P 1885251 * 427389
'*' against a bug indicates that an alert exists for that issue. '+' indicates a particularly notable bug.
'P' indicates a port specific bug.
'@' indicates UNPUBLISHED information
Fixed versions use "BPnn" to indicate Exadata bundle nn. "OERI:xxxx" may be used as shorthand for ORA-600 [xxxx].
9015PSE, 9.2.0.1 7.3.3.3, 7.3.4.0, 8.0.3.0

 

 

该问题可以通过patch或者重建rollback segment来起到修复的作用,如果该问题导致你的数据库无法打开了,可以联系诗檀软件Oracle Support帮忙解决。

 

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

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

服务热线 : 13764045638   QQ号:47079569    邮箱:service@parnassusdata.com

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号