Veritas-bu

[Veritas-bu] oracle offline backups

2005-01-14 12:54:12
Subject: [Veritas-bu] oracle offline backups
From: Imran.a.Khan AT uk.fujitsu DOT com (Khan Imran A)
Date: Fri, 14 Jan 2005 17:54:12 -0000
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_01C4FA62.0E486120
Content-Type: text/plain

In this situation Oracle online is not a requirement and so the Oracle agent
licence has not been purchased. 

 

The backup is a straight forward backup of the entire E: & D: partition
using a WINDOW-NT type policy. Oracle is shutdown prior to the backup and
still the backup of the E:\ is partially successful, not being able to
backup any of the *DBF files. 

 

I have a call with VERITAS in the UK but no resolution has been supplied
just yet

 

Regards

 

Imran 

 

-----Original Message-----
From: Penelope Carr [mailto:Penelope.Carr AT veritas DOT com] 
Sent: 14 January 2005 15:39
To: Khan Imran A
Subject: RE: [Veritas-bu] oracle offline backups

 

Have you tried using the RMAN scripts provided by Veritas that comes on the
RMAN for Oracle Agent CD??  These scripts are tested and are used in the
field at various customers with no issues.

 

You have to set the policy as Oracle and use RMAN to do the backup to really
do a true oracle backup.

 

If you are doing a file system backup after you shut down the database prior
to the backup, you should be sure no other files are in the file list.  You
will always get a partial backup if not using Open File Backup or using VSP.


 

Penelope

 

  _____  

From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of Khan Imran 
A
Sent: Friday, January 14, 2005 9:49 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] oracle offline backups

 

Hi, 

 

We have a 4.5MP6 backup server backing up a number of clients some win2K and
some windows 2003 over gigabit LAN. One of the clients is oracle db server
hosting 9i

 

It is being backed up offline, and so we have written some scripts to stop
all oracle services prior backup and then backup the D:\ & E:\ every night
in FULL. Each night the backup is partially successful and fails to backup
all *.dbf files 

 

We have tried everything including stopping VSP from running during the
backup any ideas would be appreciated 

 

Kind Regards,

 

Imran 

 


------_=_NextPart_001_01C4FA62.0E486120
Content-Type: text/html

<html>

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">


<meta name=Generator content="Microsoft Word 10 (filtered)">

<style>
<!--
 /* Font Definitions */
 @font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* 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;}
p
        {margin-right:0cm;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman";}
span.emailstyle17
        {font-family:Arial;
        color:windowtext;}
span.EmailStyle19
        {font-family:Arial;
        color:navy;}
span.EmailStyle20
        {font-family:Arial;
        color:navy;}
@page Section1
        {size:595.3pt 841.9pt;
        margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
        {page:Section1;}
-->
</style>

</head>

<body lang=EN-GB link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>In this situation Oracle online is not a 
requirement
and so the Oracle agent licence has not been purchased. </span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The backup is a straight forward backup of
the entire E: &amp; D: partition using a WINDOW-NT type policy. Oracle is
shutdown prior to the backup and still the backup of the E:\ is partially 
successful,
not being able to backup any of the *DBF files. </span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I have a call with VERITAS in the 
</span></font><font
  size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
  color:navy'>UK</span></font><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> but no resolution has
been supplied just yet</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Regards</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Imran </span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Tahoma><span
lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>-----Original 
Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Penelope Carr
[mailto:Penelope.Carr AT veritas DOT com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> 14 January 2005 15:39<br>
<b><span style='font-weight:bold'>To:</span></b> Khan Imran A<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [Veritas-bu] oracle
offline backups</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=navy
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:navy'>Have you tried using the RMAN scripts provided by Veritas that
comes on the RMAN for Oracle Agent CD??&nbsp; These scripts are tested and are
used in the field at various customers with no issues.</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=navy
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=navy
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:navy'>You have to set the policy as Oracle and use RMAN to do the backup
to really do a true oracle backup.</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=navy
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=navy
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:navy'>If you are doing a file system backup after you shut down the
database prior to the backup, you should be sure no other files are in the file
list.&nbsp; You will always get a partial backup if not using Open File Backup
or using VSP.&nbsp; </span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=navy
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:navy'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=navy
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:navy'>Penelope</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=navy
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:navy'>&nbsp;</span></font></p>

<div>

<div class=MsoNormal align=center 
style='margin-left:36.0pt;text-align:center'><font
size=3 face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>

<hr size=3 width="100%" align=center>

</span></font></div>

<p class=MsoNormal style='margin-left:36.0pt'><b><font size=2 face=Tahoma><span
lang=EN-US 
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
veritas-bu-admin AT mailman.eng.auburn DOT edu [mailto:veritas-bu-admin AT 
mailman.eng.auburn DOT edu]
<b><span style='font-weight:bold'>On Behalf Of </span></b>Khan Imran A<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, January 14, 2005
9:49 AM<br>
<b><span style='font-weight:bold'>To:</span></b>
veritas-bu AT mailman.eng.auburn DOT edu<br>
<b><span style='font-weight:bold'>Subject:</span></b> [Veritas-bu] oracle
offline backups</span></font></p>

</div>

<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span lang=EN-US 
style='font-size:12.0pt'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Hi, </span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>We have a 4.5MP6 backup server
backing up a number of clients some win2K and some windows 2003 over gigabit
LAN. One of the clients is oracle db server hosting 9i</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>It is being backed up offline, and
so we have written some scripts to stop all oracle services prior backup and
then backup the D:\ &amp; E:\ every night in FULL. Each night the backup is
partially successful and fails to backup all *.dbf files </span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>We have tried everything including
stopping VSP from running during the backup any ideas would be appreciated 
</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Kind Regards,</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>&nbsp;</span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Imran </span></font></p>

<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>&nbsp;</span></font></p>

</div>

</body>

</html>

------_=_NextPart_001_01C4FA62.0E486120--

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