Veritas-bu

[Veritas-bu] Status 5 from Oracle RMAN restores

2003-03-19 07:02:06
Subject: [Veritas-bu] Status 5 from Oracle RMAN restores
From: mhickey AT glasshousetech DOT com (Mark Hickey)
Date: Wed, 19 Mar 2003 07:02:06 -0500
This is a multi-part message in MIME format.

------_=_NextPart_001_01C2EE0F.5CC9AFA5
Content-Type: text/plain;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Folks,

   A quick post on this since I couldn't find an answer when I was
looking.

=20

   We got the "can't obtain exclusive enqueue for blah" error and a
status 5 when restoring an Oracle datafile. =20

=20

    The problem was that the datafile, though moved out of the way in
the filesystem, also needed to be offlined in the database ; i.e.:
connect to the database with sqlplus, and alter the datafile offline.

=20

    Mark Hickey

    Senior Technology Consultant

    Glasshouse Technologies

    www.glasshouse.com <http://www.glasshouse.com/>=20

=20


------_=_NextPart_001_01C2EE0F.5CC9AFA5
Content-Type: text/html;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">

<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {font-family:Arial;
        color:windowtext;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
        {page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Folks,</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;&nbsp; A quick post on this since I =
couldn&#8217;t
find an answer when I was looking.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;&nbsp; We got the &#8220;can&#8217;t obtain =
exclusive enqueue
for blah&#8221; error and a status 5 when restoring an Oracle =
datafile.&nbsp; </span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;&nbsp;&nbsp; The problem was that the datafile, =
though
moved out of the way in the filesystem, also needed to be offlined in =
the
database ; i.e.: connect to the database with sqlplus, and alter the =
datafile
offline.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;&nbsp;&nbsp; Mark Hickey</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;&nbsp;&nbsp; Senior Technology =
Consultant</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;&nbsp;&nbsp; Glasshouse =
Technologies</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;&nbsp;&nbsp; <a =
href=3D"http://www.glasshouse.com/";>www.glasshouse.com</a></span></font><=
/p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

</div>

</body>

</html>
=00
------_=_NextPart_001_01C2EE0F.5CC9AFA5--

<Prev in Thread] Current Thread [Next in Thread>
  • [Veritas-bu] Status 5 from Oracle RMAN restores, Mark Hickey <=