Veritas-bu

[Veritas-bu] Restore database (if backup using hot_database_b ackup.sh)

2002-11-15 09:47:00
Subject: [Veritas-bu] Restore database (if backup using hot_database_b ackup.sh)
From: LH130221 AT exchange.DAYTONOH.NCR DOT com (Hampshire, Lindbergh Jr)
Date: Fri, 15 Nov 2002 09:47:00 -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_01C28CB5.DAF0F970
Content-Type: text/plain

The script I wrote doesn't use the oracle agent.  Its based from some oracle
backup scripts that were created for our UNIX/Solaris environment and ported
to NT/Win2k.  We use a third-party package called MKS-ToolKit to execute the
scripts.  It gave us more control and ability to trap error messages than
the standard DOS environment.
 
We've done restores of hot backups on on the UNIX side, and there hasn't
been any problems.  I can give some general guidelines, but can't go into
any great detail since the scripts are considered company property.
-----Original Message-----
From: Norman Mochamad (MIS-JKT) [mailto:Norman AT gt-tires DOT com]
Sent: Thursday, November 14, 2002 8:03 PM
To: Hampshire, Lindbergh Jr; 'veritas support'
Subject: RE: [Veritas-bu] Restore database (if backup using hot_database_b
ackup.sh)
Importance: High


Hello all 
 
 
Thanks Hampshire.....
Now the oracle agent for NB already installed on my server
And I have success backup using standard template script
"hot_database_backup.sh" 
 
My problem is how to restore it or can't you tell us about your script.
 
Thanks so much
Norman
 
 
 
 
 
-----Original Message-----
From: Hampshire, Lindbergh Jr [mailto:LH130221 AT exchange.DAYTONOH.NCR DOT 
com] 
Sent: Thursday, November 14, 2002 7:46 PM
To: Norman Mochamad (MIS-JKT)
Subject: RE: [Veritas-bu] Restore database (if backup using hot_database_b
ackup.sh)
 
Hello,
We ended up creating our own backup scripts for oracle.  The RMAN utility
doesn't necessary work correctly all the time.  It also kept us from buying
the Oracle agent for NB.
-----Original Message-----
From: Norman Mochamad (MIS-JKT) [mailto:Norman AT gt-tires DOT com]
Sent: Thursday, November 14, 2002 4:23 AM
To: 'veritas support'
Subject: [Veritas-bu] Restore database (if backup using
hot_database_backup.sh)
Importance: High
Hi all
 
I'am using veritas netbackup 4.5
I try to run oracle database backup using template script
"hot_database_backup.sh"  (ended successfully)
 
I already to try restore using  template script  "database_restore.sh", but
still error
 
Here the error :
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: ch00
RMAN-08031: released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-10035: exception raised in RPC: O
RMAN-10031: ORA-19583 occurred during call to
DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
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 ch00
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 161
RMAN-10031: ORA-19583 occurred during call to
DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
 
 
I also using the recovery catalog.
My question how to restore it (if I backup using template script
"hot_database_backup.sh")
 
 
 
Regards
Norman
 

------_=_NextPart_001_01C28CB5.DAF0F970
Content-Type: text/html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40"; xmlns:o = 
"urn:schemas-microsoft-com:office:office" xmlns:w = 
"urn:schemas-microsoft-com:office:word" xmlns:st1 = 
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">


<META content=Word.Document name=ProgId>
<META content="MSHTML 5.50.4807.2300" name=GENERATOR>
<META content="Microsoft Word 10" name=Originator><LINK 
href="cid:[email protected]" rel=File-List><o:SmartTagType 
name="date" 
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
 
name="time" 
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
 
name="place" 
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
 
name="City" 
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if
 gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:GrammarState>Clean</w:GrammarState>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:Compatibility>
   <w:BreakWrappedTables/>
   <w:SnapToGridInCell/>
   <w:WrapTextWithPunct/>
   <w:UseAsianBreakRules/>
   <w:UseFELayout/>
  </w:Compatibility>
  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>
</xml><![endif]--><!--[if !mso]>
<STYLE>
st1\:*{behavior:url(#default#ieooui) }
</STYLE>
<![endif]-->
<STYLE>
<!--
 /* Font Definitions */
 @font-face
        {font-family:SimSun;
        panose-1:2 1 6 0 3 1 1 1 1 1;
        mso-font-alt:\5B8B\4F53;
        mso-font-charset:134;
        mso-generic-font-family:auto;
        mso-font-pitch:variable;
        mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;
        mso-font-charset:0;
        mso-generic-font-family:swiss;
        mso-font-pitch:variable;
        mso-font-signature:553679495 -2147483648 8 0 66047 0;}
@font-face
        {font-family:"Comic Sans MS";
        panose-1:3 15 7 2 3 3 2 2 2 4;
        mso-font-charset:0;
        mso-generic-font-family:script;
        mso-font-pitch:variable;
        mso-font-signature:647 0 0 0 159 0;}
@font-face
        {font-family:"\@SimSun";
        panose-1:2 1 6 0 3 1 1 1 1 1;
        mso-font-charset:134;
        mso-generic-font-family:auto;
        mso-font-pitch:variable;
        mso-font-signature:3 135135232 16 0 262145 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
        {mso-style-parent:"";
        margin:0in;
        margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:12.0pt;
        font-family:"Times New Roman";
        mso-fareast-font-family:SimSun;}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;
        text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;
        text-underline:single;}
span.EmailStyle17
        {mso-style-type:personal;
        mso-style-noshow:yes;
        mso-ansi-font-size:10.0pt;
        mso-bidi-font-size:10.0pt;
        font-family:Arial;
        mso-ascii-font-family:Arial;
        mso-hansi-font-family:Arial;
        mso-bidi-font-family:Arial;
        color:windowtext;}
span.EmailStyle18
        {mso-style-type:personal-reply;
        mso-style-noshow:yes;
        mso-ansi-font-size:10.0pt;
        mso-bidi-font-size:10.0pt;
        font-family:Arial;
        mso-ascii-font-family:Arial;
        mso-hansi-font-family:Arial;
        mso-bidi-font-family:Arial;
        color:navy;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.25in 1.0in 1.25in;
        mso-header-margin:.5in;
        mso-footer-margin:.5in;
        mso-paper-source:0;}
div.Section1
        {page:Section1;}
-->
</STYLE>
<!--[if gte mso 10]>
<style>
 /* Style Definitions */ 
 table.MsoNormalTable
        {mso-style-name:"Table Normal";
        mso-tstyle-rowband-size:0;
        mso-tstyle-colband-size:0;
        mso-style-noshow:yes;
        mso-style-parent:"";
        mso-padding-alt:0in 5.4pt 0in 5.4pt;
        mso-para-margin:0in;
        mso-para-margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:10.0pt;
        font-family:"Times New Roman";}
</style>
<![endif]--></HEAD>
<BODY lang=EN-US style="tab-interval: .5in" vLink=purple link=blue>
<DIV><SPAN class=608544214-15112002><FONT face="Comic Sans MS" color=#0000ff 
size=2>The script I wrote doesn't use the oracle agent.&nbsp; Its based from 
some oracle backup scripts that were created for our UNIX/Solaris environment 
and ported to NT/Win2k.&nbsp; We use a third-party package called MKS-ToolKit 
to 
execute the scripts.&nbsp; It gave us more control and ability to trap error 
messages than the standard DOS environment.</FONT></SPAN></DIV>
<DIV><SPAN class=608544214-15112002><FONT face="Comic Sans MS" color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=608544214-15112002><FONT face="Comic Sans MS" color=#0000ff 
size=2>We've done restores of hot backups on on the UNIX side, and there hasn't 
been any problems.&nbsp; I can give some general guidelines, but can't go into 
any great detail since the scripts are considered company 
property.</FONT></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> Norman Mochamad (MIS-JKT) 
  [mailto:Norman AT gt-tires DOT com]<BR><B>Sent:</B> Thursday, November 14, 
2002 8:03 
  PM<BR><B>To:</B> Hampshire, Lindbergh Jr; 'veritas 
support'<BR><B>Subject:</B> 
  RE: [Veritas-bu] Restore database (if backup using hot_database_b 
  ackup.sh)<BR><B>Importance:</B> High<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">Hello all 
  <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>&nbsp;</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>&nbsp;</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">Thanks 
  Hampshire.....<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">Now the oracle agent 
  for NB already installed on my server<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">And I have success 
  backup using standard template script "</SPAN></FONT><FONT face=Tahoma 
  size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">hot_database_backup.sh" 
  <o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Tahoma size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: 
Tahoma"><o:p>&nbsp;</o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Tahoma size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">My problem is how to restore it 
  or can't you tell us about your script.<o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Tahoma size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: 
Tahoma"><o:p>&nbsp;</o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Tahoma size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Thanks so 
  much<o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Tahoma size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Norman</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>
  <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 
Arial"><o:p>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Tahoma size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original 
  Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> 
Hampshire, 
  Lindbergh Jr [mailto:LH130221 AT exchange.DAYTONOH.NCR DOT com] <BR><B><SPAN 
  style="FONT-WEIGHT: bold">Sent:</SPAN></B> </SPAN></FONT><st1:date 
Year="2002" 
  Day="14" Month="11"><FONT face=Tahoma size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Thursday, November 14, 
  2002</SPAN></FONT></st1:date><FONT face=Tahoma size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> </SPAN></FONT><st1:time 
  Minute="46" Hour="19"><FONT face=Tahoma size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">7:46 
  PM</SPAN></FONT></st1:time><FONT face=Tahoma size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"><BR><B><SPAN 
  style="FONT-WEIGHT: bold">To:</SPAN></B> Norman Mochamad 
(MIS-JKT)<BR><B><SPAN 
  style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [Veritas-bu] Restore 
  database (if backup using hot_database_b ackup.sh)</SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" 
  size=3><SPAN style="FONT-SIZE: 12pt"><o:p>&nbsp;</o:p></SPAN></FONT></P>
  <DIV>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Comic Sans MS" 
  color=blue size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Comic Sans 
MS'">Hello,</SPAN></FONT><o:p></o:p></P></DIV>
  <DIV>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Comic Sans MS" 
  color=blue size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">We ended 
up 
  creating our own backup scripts for oracle.&nbsp; The RMAN utility doesn't 
  necessary work correctly all the time.&nbsp; It also kept us from buying the 
  Oracle agent for NB.</SPAN></FONT><o:p></o:p></P></DIV>
  <BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in">
    <P class=MsoNormal 
    style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in; 
mso-margin-top-alt: 0in"><FONT 
    face=Tahoma size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original 
    Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Norman 
    Mochamad (MIS-JKT) [mailto:Norman AT gt-tires DOT com]<BR><B><SPAN 
    style="FONT-WEIGHT: bold">Sent:</SPAN></B> </SPAN></FONT><st1:date 
    Year="2002" Day="14" Month="11"><FONT face=Tahoma size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Thursday, November 14, 
    2002</SPAN></FONT></st1:date><FONT face=Tahoma size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> </SPAN></FONT><st1:time 
    Minute="23" Hour="4"><FONT face=Tahoma size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">4:23 
    AM</SPAN></FONT></st1:time><FONT face=Tahoma size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"><BR><B><SPAN 
    style="FONT-WEIGHT: bold">To:</SPAN></B> 'veritas support'<BR><B><SPAN 
    style="FONT-WEIGHT: bold">Subject:</SPAN></B> [Veritas-bu] Restore database 
    (if backup using hot_database_backup.sh)<BR><B><SPAN 
    style="FONT-WEIGHT: bold">Importance:</SPAN></B> 
    High</SPAN></FONT><o:p></o:p></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi 
    all<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: 
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I'am using veritas netbackup 
    4.5<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I try to run oracle database 
    backup using template script<SPAN style="mso-spacerun: yes">&nbsp; 
    </SPAN>"hot_database_backup.sh"<SPAN style="mso-spacerun: yes">&nbsp; 
    </SPAN>(ended successfully)<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: 
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I already to try restore 
    using<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>template script<SPAN 
    style="mso-spacerun: yes">&nbsp; </SPAN>"database_restore.sh", but still 
    error<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: 
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Here the error 
    :<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">RMAN-03026: error recovery 
    releasing channel resources<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">RMAN-08031: released channel: 
    ch00<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">RMAN-08031: released channel: 
    ch01<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">RMAN-00571: 
    
===========================================================<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">RMAN-00569: =============== 
    ERROR MESSAGE STACK FOLLOWS ===============<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">RMAN-00571: 
    
===========================================================<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">RMAN-10035: exception raised in 
    RPC: O<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">RMAN-10031: ORA-19583 occurred 
    during call to 
    DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">RMAN-03002: failure during 
    compilation of command<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">RMAN-03013: command type: 
    restore<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">RMAN-03006: non-retryable error 
    occurred during execution of command: IRESTORE<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">RMAN-07004: unhandled exception 
    during command execution on channel ch00<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">RMAN-10035: exception raised in 
    RPC: ORA-27192: skgfcls: sbtclose2 returned error - failed to close 
    file<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">ORA-19511: sbtclose2: Failed to 
    process backup file.<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">ORA-19573: cannot obtain 
    exclusive enqueue for datafile 161<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">RMAN-10031: ORA-19583 occurred 
    during call to 
    DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: 
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: 
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I also using the recovery 
    catalog.<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">My question how to restore it 
    (if I backup using template script<SPAN style="mso-spacerun: yes">&nbsp; 
    </SPAN>"hot_database_backup.sh")<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: 
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: 
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: 
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: 
Arial">Regards<o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><st1:City><st1:place><FONT 
    face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: 
Arial">Norman</SPAN></FONT></st1:place></st1:City><FONT 
    face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></P>
    <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: 
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P></BLOCKQUOTE></DIV></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C28CB5.DAF0F970--

<Prev in Thread] Current Thread [Next in Thread>
  • [Veritas-bu] Restore database (if backup using hot_database_b ackup.sh), Hampshire, Lindbergh Jr <=