[Ocfs-users] ORA-01207 after SAN maintenance

[Jeram]

Hi Matt...

 

Have you seen Note:76434.1 in Metalink.

 

Rgds/Jeram

  _____  

From: Matt Daniels [mailto:Matt.Daniels at priorityhealthcare.com] 
Sent: Wednesday, November 24, 2004 9:30 PM
To: ocfs-users at oss.oracle.com
Subject: [Ocfs-users] ORA-01207 after SAN maintenance

 

We had a situation over the weekend with our production database that we
can't figure out, hoping someone can shed some light.

Specifics: 
Oracle 9.2.0.4 
OS is Redhat AS2.1 
ocfs-2.4.9-e-summit-1.0.12-1 
ocfs-tools-1.0.10-1 
ocfs-support-1.0.10-1 
ocfs-2.4.9-e-enterprise-1.0.12-1 

All database, redo, undo, and control files are on ocfs, archived logs are
on ext3. 

We shut down the database for san maintenance, but didn't shut down cluster 
manager.  The san was disconnected from the server, a tray was added and
then 
the san was reconnected.  The server and cluster manager remained up during
the 
maintenance. 

When we tried to restart the database, we got an ORA-01207, saying the
control 
file was older than the datafiles.  Per Oracle support, we recreated the
control file 
and attempted to bring the db up with the new one.  At this point we
received the 
following: 

Errors in file
/opt/oracle/product/9.2.0/admin/ENTPRD/udump/entprd2_ora_22596.trc: 
ORA-00600: internal error code, arguments: [kcoapl_blkchk], [5], [393],
[6101], [], [], [], [] 

There's a RAC bug entry for [kcoapl_blkchk], but it was for a 4-node RAC,
ours is only 
2 nodes, so Oracle internals support said they didn't think it applied to
our case.  We 
ended up doing a point-in-time recovery to before the san maintenance, but
moved the 
datafiles to an ext3 partition for now. 

Has anyone seen this before, or have any input as to what happened?  We're
trying to 
determine if this is a bug, and if we should move back to RAC/ocfs. 

Thanks very much, 
Matt Daniels 
Apps DBA, Priority Healthcare Corp 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://oss.oracle.com/pipermail/ocfs-users/attachments/20041126/62122e8c/attachment.html