Veritas-bu

[Veritas-bu] Oracle DR procedure!

2004-05-21 06:58:45
Subject: [Veritas-bu] Oracle DR procedure!
From: Dennis AT stortech.co DOT za (Dennis Naidoo)
Date: Fri, 21 May 2004 12:58:45 +0200
This is a multi-part message in MIME format.

------_=_NextPart_001_01C43F22.964A1C36
Content-Type: text/plain;
        charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

Hi All

=20

I am sure there are allot of users out there who are doing  online back
ups and restores of their Oracle databases.

I would like to know what the correct steps I should follow to do a full
Oracle DR restore of any of my databases.

I have no oracle knowledge, and I need to prove to a client that we can
restore their database in a DR situation.

=20

The procedure I follow is:

-          restore the rman catalog onto the DR server. (I do cold
backups of the rman catalog, as well as the pfile. Is this the best
way?)

-          Bring RMAN online reading the new controlfiles and datafiles.

-          Create the database instance of the database I want restored.

-          Take that database into nomount mode, and restore the
controlfiles through rman.

-          Mount the database and run the "restore database; recover
database" in rman.

-          Open database.

The problem is that I always have problems opening the database, even if
I do a "open with resetlogs" option. I noticed that it always looks for
the one archivelog file after the latest one backed up. I take it this
is the redolog file. So I normally do a restore until the last log file
on tape, but oracle still complains when I try to open it.=20

=20

Also, you have to have the exact same file structure for the oracle
files in order to restore, unless you redirect every stream....is this
the best way.

Can anyone please tell me if I am doing this the correct way.=20

I cannot find any documentation on the Veritas web site regarding this
procedure, and I find that you cannot restore any databases through the
Netbackup gui even though you have successfull backups. It just doesn't
show your database.  If you create a new database with teh same name, it
will show you current database under restore selections, and not any of
your backed up data.

=20

Should the entire restore procedure be done in RMAN? What can do you
through the Netbackup interface?

Thanks in advance.

=20

Dennis


------_=_NextPart_001_01C43F22.964A1C36
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>
<!--
 /* Font Definitions */
 @font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        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:612.0pt 792.0pt;
        margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
        {page:Section1;}
 /* List Definitions */
 ol
        {margin-bottom:0cm;}
ul
        {margin-bottom:0cm;}
-->
</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'>Hi All</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'>I am sure there are allot of users out there who are =
doing&nbsp;
online back ups and restores of their Oracle =
databases.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I would like to know what the correct steps I should =
follow
to do a full Oracle DR restore of any of my databases.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I have no oracle knowledge, and I need to prove to a =
client
that we can restore their database in a DR situation.</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'>The procedure I follow is:</span></font></p>

<p class=3DMsoNormal =
style=3D'margin-left:36.0pt;text-indent:-18.0pt'><font size=3D2
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>-<font =
size=3D1
face=3D"Times New Roman"><span style=3D'font:7.0pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></font></span></font><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>restore the rman catalog onto the DR server. =
(I do
cold backups of the rman catalog, as well as the pfile. Is this the best =
way?)</span></font></p>

<p class=3DMsoNormal =
style=3D'margin-left:36.0pt;text-indent:-18.0pt'><font size=3D2
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>-<font =
size=3D1
face=3D"Times New Roman"><span style=3D'font:7.0pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></font></span></font><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>Bring RMAN online reading the new controlfiles =
and datafiles.</span></font></p>

<p class=3DMsoNormal =
style=3D'margin-left:36.0pt;text-indent:-18.0pt'><font size=3D2
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>-<font =
size=3D1
face=3D"Times New Roman"><span style=3D'font:7.0pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></font></span></font><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>Create the database instance of the database I =
want
restored.</span></font></p>

<p class=3DMsoNormal =
style=3D'margin-left:36.0pt;text-indent:-18.0pt'><font size=3D2
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>-<font =
size=3D1
face=3D"Times New Roman"><span style=3D'font:7.0pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></font></span></font><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>Take that database into nomount mode, and =
restore the
controlfiles through rman.</span></font></p>

<p class=3DMsoNormal =
style=3D'margin-left:36.0pt;text-indent:-18.0pt'><font size=3D2
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>-<font =
size=3D1
face=3D"Times New Roman"><span style=3D'font:7.0pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></font></span></font><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>Mount the database and run the &#8220;restore
database; recover database&#8221; in rman.</span></font></p>

<p class=3DMsoNormal =
style=3D'margin-left:36.0pt;text-indent:-18.0pt'><font size=3D2
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>-<font =
size=3D1
face=3D"Times New Roman"><span style=3D'font:7.0pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></font></span></font><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>Open database.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>The problem is that I always have problems opening =
the
database, even if I do a &#8220;open with resetlogs&#8221; option. I =
noticed
that it always looks for the one archivelog file after the latest one =
backed
up. I take it this is the redolog file. So I normally do a restore until =
the
last log file on tape, but oracle still complains when I try to open it. =
</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'>Also, you have to have the exact same file structure =
for the
oracle files in order to restore, unless you redirect every stream....is =
this
the best way.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Can anyone please tell me if I am doing this the =
correct way.
</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I cannot find any documentation on the Veritas web =
site regarding
this procedure, and I find that you cannot restore any databases through =
the Netbackup
gui even though you have successfull backups. It just doesn&#8217;t show =
your
database.&nbsp; If you create a new database with teh same name, it will =
show
you current database under restore selections, and not any of your =
backed up
data.</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'>Should the entire restore procedure be done in RMAN? =
What
can do you through the Netbackup interface?</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Thanks in advance.</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'>Dennis</span></font></p>

</div>

</body>

</html>
=00
------_=_NextPart_001_01C43F22.964A1C36--

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