Mos找到一篇文档,可以参考,但是不建议直接参照建议做,最好确定完整情况,再进行处理:
ORA-00600: [2702] during startup of one node (Doc ID 565940.1)
APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.2.0.2 to 11.2.0.3 [Release 10.2 to 11.2]
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.4 [Release 9.2 to 10.2]
Information in this document applies to any platform.
SYMPTOMS
The database fails to startup with ORA-00600:[2702] from one node.
The remaining nodes from the cluster start up just fine.
Tue Apr 29 12:27:33 2008
alter database open
Tue Apr 29 12:27:33 2008
This instance was first to open
Picked broadcast on commit scheme to generate SCNs
Tue Apr 29 12:27:33 2008
Errors in file /PATH/udump/FILE_NAME.trc:
ORA-00600: internal error code, arguments: [2702], [1], [9], [8], [], [], [], []
ORA-600 signalled during: alter database open…
CAUSE
Instance failed to startup as there was a ONLINE REDOLOG with status CURRENT and
ARCHIVED set to NO in v$log for thread that fails.
The same ONLINE REDOLOG has the lowest sequence within that thread.
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
9 1 8673 52428800 2 NO CURRENT
10 1 8686 52428800 2 YES ACTIVE
11 1 8684 52428800 2 YES INACTIVE
12 1 8685 52428800 2 YES INACTIVE
SOLUTION
During startup, we look for to reuse the ONLINE REDOLOG with lowest sequence#.
That ONLINE REDOLOG Log must have be archived.
The V$LOG view shows that sequence# 8673 was not archived.
In order to fix it, you need to clear the REDOLOG with lower sequence#
shutdown all nodes
startup mount only one node
disable archivelog
open the database
disable the thread that has fails to startup
drop the group that contains the lowest sequence
recreate the REDOLOG group
renable the thread
shutdown the database
startup mount one node
re-enable archivelog
open the database