<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>ORA-01207 after SAN maintenance</TITLE>
<META content="MSHTML 6.00.2800.1476" name=GENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><SPAN class=270435801-26112004><FONT face=Arial color=#0000ff size=2>Hi
Jeram,</FONT></SPAN></DIV>
<DIV><SPAN class=270435801-26112004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=270435801-26112004><FONT face=Arial color=#0000ff size=2>Thanks
for the reply. Yes, we read the note, especially this
part:</FONT></SPAN></DIV>
<DIV><SPAN class=270435801-26112004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=270435801-26112004>Bug# 3281882 See <A
href="http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=3281882.8&p_database_id=NOT"
target=corner><FONT color=#606420>[NOTE:3281882.8]</FONT></A>
<P> Block corruption / OERI[kcoapl_blkchk] in
multinode RAC after multiple reconfigurations
<P> Fixed: 9.2.0.5, 10.1.0.2 </P>
<P><SPAN class=270435801-26112004>Oracle Internals support, however, determined
that this bug didn't apply to our case since it occured specifically with a
4-node RAC instance, and ours is only 2 nodes.</SPAN></P>
<P><SPAN class=270435801-26112004>We're still trying to determine the cause for
this, as we lost our production instance and had to do point-in-time
recovery.</SPAN></P>
<P><SPAN class=270435801-26112004>Interestingly, one of our development
instances experienced the exact problem as well. Its datafiles were stored
on the san in a different ocfs partition, but in the same storage group.
Our other development instance using the same san storage group, but with
datafiles on an ext3 partition, wasn't affected and came up fine.</SPAN></P>
<P><SPAN class=270435801-26112004>Thanks again for the response!</SPAN></P>
<P><SPAN class=270435801-26112004>Matt</SPAN></P></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Jeram
[mailto:jeram@JISEDU.OR.ID]<BR><B>Sent:</B> Thursday, November 25, 2004 8:11
PM<BR><B>To:</B> Matt Daniels; ocfs-users@oss.oracle.com<BR><B>Subject:</B>
RE: [Ocfs-users] ORA-01207 after SAN maintenance<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Hi
Matt…<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Have you seen Note:76434.1 in
Metalink.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Rgds/Jeram</SPAN></FONT><FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> Matt
Daniels [mailto:Matt.Daniels@priorityhealthcare.com] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, November 24, 2004 9:30
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
ocfs-users@oss.oracle.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> [Ocfs-users] ORA-01207 after SAN
maintenance</SPAN></FONT><o:p></o:p></P></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">We had a situation over the
weekend with our production database that we can't figure out, hoping someone
can shed some light.</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Specifics:</SPAN></FONT> <BR><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Oracle
9.2.0.4</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">OS is Redhat AS2.1</SPAN></FONT>
<BR><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">ocfs-2.4.9-e-summit-1.0.12-1</SPAN></FONT>
<BR><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">ocfs-tools-1.0.10-1</SPAN></FONT>
<BR><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">ocfs-support-1.0.10-1</SPAN></FONT>
<BR><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">ocfs-2.4.9-e-enterprise-1.0.12-1</SPAN></FONT>
<o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">All database, redo, undo, and
control files are on ocfs, archived logs are on ext3.</SPAN></FONT>
<o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">We shut down the database for san
maintenance, but didn't shut down cluster</SPAN></FONT> <BR><FONT face=Arial
size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">manager. The
san was disconnected from the server, a tray was added and then</SPAN></FONT>
<BR><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">the san was reconnected. The
server and cluster manager remained up during the</SPAN></FONT> <BR><FONT
face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">maintenance.</SPAN></FONT>
<o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">When we tried to restart the
database, we got an ORA-01207, saying the control</SPAN></FONT> <BR><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">file was
older than the datafiles. Per Oracle support, we recreated the control
file</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">and attempted to bring the db up
with the new one. At this point we received the</SPAN></FONT> <BR><FONT
face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">following:</SPAN></FONT>
<o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Errors in file
/opt/oracle/product/9.2.0/admin/ENTPRD/udump/entprd2_ora_22596.trc:</SPAN></FONT>
<BR><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">ORA-00600: internal error code,
arguments: [kcoapl_blkchk], [5], [393], [6101], [], [], [], []</SPAN></FONT>
<o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">There's a RAC bug entry for
[kcoapl_blkchk], but it was for a 4-node RAC, ours is only</SPAN></FONT>
<BR><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">2 nodes, so Oracle internals
support said they didn't think it applied to our case. We</SPAN></FONT>
<BR><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">ended up doing a point-in-time
recovery to before the san maintenance, but moved the</SPAN></FONT> <BR><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">datafiles
to an ext3 partition for now.</SPAN></FONT> <o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Has anyone seen this before, or
have any input as to what happened? We're trying to</SPAN></FONT>
<BR><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">determine if this is a bug, and if
we should move back to RAC/ocfs.</SPAN></FONT> <o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks very much,</SPAN></FONT>
<BR><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Matt Daniels</SPAN></FONT>
<BR><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Apps DBA, Priority Healthcare
Corp</SPAN></FONT> <o:p></o:p></P></DIV></BLOCKQUOTE></BODY></HTML>