Veritas-bu

[Veritas-bu] Oracle restore

2004-04-02 07:51:09
Subject: [Veritas-bu] Oracle restore
From: irodriguez AT arsenaldigital DOT com (Isidro Rodriguez)
Date: Fri, 2 Apr 2004 07:51:09 -0500
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C418B1.2BA2E3F0
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I am guessing you have fixed this by now, but did you start oracle =
using
"startup mount"???=20



-----Original Message-----
From: Pedro Jos=E9 Bello Vali=F1as [mailto:pbello AT tcpsi DOT es]
Sent: Friday, April 02, 2004 1:41 AM
To: Veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Oracle restore


Hello, we=B4re having problems during the restore of an Oracle =
database.
We backup the database with the hot_database_backup.sh. Everything is =
OK
till here.
When we want to restore it, we found this error:

RMAN-08523: restoring datafile 00001 to
/export/home/sistemas/oracle/system01.dbf
RMAN-08523: restoring datafile 00005 to
/export/home/sistemas/oracle/NBP_indices.dbf
RMAN-00571: =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RMAN-00569: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE =
STACK FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RMAN-00571: =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03006: non-retryable error occurred during execution of command:
IRESTORE
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-27192: skgfcls: sbtclose2 =
returned
error - failed to close file
ORA-19511: sbtclose2: Failed to process backup file.
ORA-19573: cannot obtain exclusive enqueue for datafile 4
RMAN-10031: ORA-19583 occurred during call to
DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
Recovery Manager complete.

What can be happening??
Thanks in advanced!!

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

------_=_NextPart_001_01C418B1.2BA2E3F0
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.45">
<TITLE>RE: [Veritas-bu] Oracle restore</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>I am guessing you have fixed this by now, but did you =
start oracle using &quot;startup mount&quot;??? </FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Pedro Jos=E9 Bello Vali=F1as [<A =
HREF=3D"mailto:pbello AT tcpsi DOT es">mailto:pbello AT tcpsi DOT es</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, April 02, 2004 1:41 AM</FONT>
<BR><FONT SIZE=3D2>To: Veritas-bu AT mailman.eng.auburn DOT edu</FONT>
<BR><FONT SIZE=3D2>Subject: [Veritas-bu] Oracle restore</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Hello, we=B4re having problems during the restore of =
an Oracle database.</FONT>
<BR><FONT SIZE=3D2>We backup the database with the =
hot_database_backup.sh. Everything is OK</FONT>
<BR><FONT SIZE=3D2>till here.</FONT>
<BR><FONT SIZE=3D2>When we want to restore it, we found this =
error:</FONT>
</P>

<P><FONT SIZE=3D2>RMAN-08523: restoring datafile 00001 to</FONT>
<BR><FONT SIZE=3D2>/export/home/sistemas/oracle/system01.dbf</FONT>
<BR><FONT SIZE=3D2>RMAN-08523: restoring datafile 00005 to</FONT>
<BR><FONT SIZE=3D2>/export/home/sistemas/oracle/NBP_indices.dbf</FONT>
<BR><FONT SIZE=3D2>RMAN-00571: =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2>RMAN-00569: =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE STACK =
FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2>RMAN-00571: =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2>RMAN-03002: failure during compilation of =
command</FONT>
<BR><FONT SIZE=3D2>RMAN-03013: command type: restore</FONT>
<BR><FONT SIZE=3D2>RMAN-03006: non-retryable error occurred during =
execution of command:</FONT>
<BR><FONT SIZE=3D2>IRESTORE</FONT>
<BR><FONT SIZE=3D2>RMAN-07004: unhandled exception during command =
execution on channel t1</FONT>
<BR><FONT SIZE=3D2>RMAN-10035: exception raised in RPC: ORA-27192: =
skgfcls: sbtclose2 returned</FONT>
<BR><FONT SIZE=3D2>error - failed to close file</FONT>
<BR><FONT SIZE=3D2>ORA-19511: sbtclose2: Failed to process backup =
file.</FONT>
<BR><FONT SIZE=3D2>ORA-19573: cannot obtain exclusive enqueue for =
datafile 4</FONT>
<BR><FONT SIZE=3D2>RMAN-10031: ORA-19583 occurred during call to</FONT>
<BR><FONT SIZE=3D2>DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE</FONT>
<BR><FONT SIZE=3D2>Recovery Manager complete.</FONT>
</P>

<P><FONT SIZE=3D2>What can be happening??</FONT>
<BR><FONT SIZE=3D2>Thanks in advanced!!</FONT>
</P>

<P><FONT =
SIZE=3D2>_______________________________________________</FONT>
<BR><FONT SIZE=3D2>Veritas-bu maillist&nbsp; -&nbsp; =
Veritas-bu AT mailman.eng.auburn DOT edu</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu"; =
TARGET=3D"_blank">http://mailman.eng.auburn.edu/mailman/listinfo/veritas=
-bu</A></FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C418B1.2BA2E3F0--

<Prev in Thread] Current Thread [Next in Thread>