Veritas-bu

[Veritas-bu] Failed Oracle backups

2004-03-05 09:11:42
Subject: [Veritas-bu] Failed Oracle backups
From: mleary AT trusecureonline DOT com (Leary, Mike)
Date: Fri, 5 Mar 2004 09:11:42 -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_01C402BB.A59EFA17
Content-Type: text/plain

Isidro is correct, it looks like you ran your catalog upgrade command using
RMAN version 8.1.7.0.0 (from the Recovery Manager: Release 8.1.7.0.0 -
Production ).  Use RMAN on the system that was upgraded to 8.1.7.4 and
connect it to the catalog AND target databases.....
 
Always 'fun' applying a oracle patch....
 
Mike.

  _____  

From: Isidro Rodriguez [mailto:irodriguez AT arsenaldigital DOT com] 
Sent: Friday, March 05, 2004 8:18 AM
To: 'Steven Jenner'; 'Leary, Mike'
Cc: 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: RE: [Veritas-bu] Failed Oracle backups



Hi Steven, 

So, where does the UPGRADE CATALOG command get it's packages from to perform

the upgrade? 
        You must run the rman commands from the database that you upgraded
to 8.1.7.4, connecting to the rman catalog....the new binaries are coming
from there.

Do I have to install new packages so they upgraded versions are available? 
        It is up to you, but if you want to keep it simple, just upgrade the
catalog twice and keep on backing up. If you move to a new Oracle release
like 9i..10g..then

        you may be forced to upgrade your catalog database as well. 



Isidro Rodriguez 



-----Original Message----- 
From: Steven Jenner [mailto:steven.jenner AT psineteurope DOT com
<mailto:steven.jenner AT psineteurope DOT com> ] 
Sent: Friday, March 05, 2004 5:18 AM 
To: 'Leary, Mike' 
Cc: 'veritas-bu AT mailman.eng.auburn DOT edu' 
Subject: RE: [Veritas-bu] Failed Oracle backups 


Hi Mike, 

Thanks for your reply, as I have limited knowledge of Oracle I have another 
question. I have ran the UPGRADE CATALOG command as documented and 
everything appears to complete successfully (details below) 

$ rman CATALOG rman/rman@RMANCAT 

Recovery Manager: Release 8.1.7.0.0 - Production 

RMAN-06008: connected to recovery catalog database 

RMAN> UPGRADE CATALOG 

RMAN-06435: recovery catalog owner is RMAN 
RMAN-06442: enter UPGRADE CATALOG command again to confirm catalog upgrade 

RMAN> UPGRADE CATALOG 

RMAN-06408: recovery catalog upgraded to version 08.01.06 
RMAN-06452: DBMS_RCVMAN package upgraded to version 08.01.07 
RMAN-06452: DBMS_RCVCAT package upgraded to version 08.01.07 

RMAN> 

But the version is still 8.1.7.0 on the recovery catalogue server. 

So, where does the UPGRADE CATALOG command get it's packages from to perform

the upgrade? 

Do I have to install new packages so they upograded versions are available? 

Sorry if these are basic questions but searching the web just shows the 
command and it's output. 

Regards, 

Steve. 

-----Original Message----- 
From: Leary, Mike [mailto:mleary AT trusecureonline DOT com
<mailto:mleary AT trusecureonline DOT com> ] 
Sent: 04 March 2004 15:09 
To: 'Steven Jenner'; 'veritas-bu AT mailman.eng.auburn DOT edu' 
Subject: RE: [Veritas-bu] Failed Oracle backups 


Steve, 

There is a step in upgrades that requires you upgrade the recovery catalog 
after applying some patchs (not all patches require it).  It is always safe 
to run the upgrade just to be safe.  :) 

Connect to the target and catalog as normal via RMAN.  Once connected issue 
"upgrade catalog;" twice (it is required to issue it twice to confirm the 
upgrade request). 

This will reinstall the recovery catalog packages and upgrade the catalog to

the correct version that supports the target.  The catalog can still run on 
a lower level of oracle (for example: we have a 9.2 catalog in a 8.1.7.4 
instance) but must be at least the level of the target instance. 

Hope this helps!!  Good luck! 

Mike Leary 
Oracle DBA / Data Architect 
Managed Security Services 
TruSecure Corporation 
678.728.1000 
mleary AT trusecureonline DOT com 
www.trusecure.com 


-----Original Message----- 
From: veritas-bu-admin AT mailman.eng.auburn DOT edu 
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu
<mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu> ] On Behalf Of Steven
Jenner 
Sent: Thursday, March 04, 2004 8:46 AM 
To: 'veritas-bu AT mailman.eng.auburn DOT edu' 
Subject: [Veritas-bu] Failed Oracle backups 

Hi, we have been performing hot Oracle backups on a customers server using 
RMAN and Veritas and all has been well. Recently however our customer 
upgraded their version of Oracle to 8.1.7.4 whereas the version of Oracle 
that is running on the Veritas Recovery Catalogue server is 8.1.7.0. 

Since the upgrade all hot backups have failed with the folowing entries 
being written to the bphdb log 

RMAN-06008: connected to recovery catalog database 

RMAN-03022: compiling command: allocate 
RMAN-03023: executing command: allocate 
RMAN-08030: allocated channel: t1 
RMAN-08500: channel t1: sid=10 devtype=SBT_TAPE 
RMAN-08526: channel t1: VERITAS NetBackup for Oracle8 - Release 3.4GA 
(030800) 

RMAN-03022: compiling command: allocate 
RMAN-03023: executing command: allocate 
RMAN-08030: allocated channel: t2 
RMAN-08500: channel t2: sid=38 devtype=SBT_TAPE 
RMAN-08526: channel t2: VERITAS NetBackup for Oracle8 - Release 3.4GA 
(030800) 

RMAN-03022: compiling command: backup 
RMAN-00571: =========================================================== 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== 
RMAN-00571: =========================================================== 
RMAN-03002: failure during compilation of command 
RMAN-03013: command type: backup 
RMAN-03014: implicit resync of recovery catalog failed 
RMAN-06004: ORACLE error from recovery catalog database: ORA-06550: line 1, 
column 21: 
PLS-00302: component 'LOCKFORCKPT' must be declared 
ORA-06550: line 1, column 7: 
PL/SQL: Statement ignored 
RMAN-06097: text of failing SQL statement: begin dbms_rcvcat . lockForckpt ;

end ; 
RMAN-06099: error occurred in source file: krmk.pc, line: 2121 

Recovery Manager complete. 

I believe that this all points to a compatibility issue with the two Oracle 
differing versions and am hoping that someone out there can confirm this?? 

Hope you can help. 

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

*********************************************************************** 
This message is intended only for the use of the intended recipient and 
may contain information that is PRIVILEGED and/or CONFIDENTIAL.  If you 
are not the intended recipient, you are hereby notified that any use, 
dissemination, disclosure or copying of this communication is strictly 
prohibited.  If you have received this communication in error, please 
destroy all copies of this message and its attachments and notify us 
immediately. 
*********************************************************************** 
_______________________________________________ 
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu 
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
<http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu>  



***********************************************************************
This message is intended only for the use of the intended recipient and
may contain information that is PRIVILEGED and/or CONFIDENTIAL.  If you
are not the intended recipient, you are hereby notified that any use,
dissemination, disclosure or copying of this communication is strictly
prohibited.  If you have received this communication in error, please
destroy all copies of this message and its attachments and notify us
immediately.
***********************************************************************

------_=_NextPart_001_01C402BB.A59EFA17
Content-Type: text/html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>RE: [Veritas-bu] Failed Oracle backups</TITLE>

<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=159520914-05032004><FONT face=Arial 
color=#0000ff size=2>Isidro is correct, it looks like you ran your catalog 
upgrade command using RMAN version 8.1.7.0.0 (from the <FONT size=2>Recovery 
Manager: Release 8.1.7.0.0 - Production</FONT> ).&nbsp; Use RMAN on the system 
that was upgraded to 8.1.7.4 and connect it to the catalog AND target 
databases.....</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=159520914-05032004><FONT face=Arial 
color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=ltr align=left><SPAN class=159520914-05032004><FONT face=Arial 
color=#0000ff size=2>Always 'fun' applying a oracle 
patch....</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=159520914-05032004><FONT face=Arial 
color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=ltr align=left><SPAN class=159520914-05032004><FONT face=Arial 
color=#0000ff size=2>Mike.</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Isidro Rodriguez 
[mailto:irodriguez AT arsenaldigital DOT com] <BR><B>Sent:</B> Friday, March 
05, 2004 
8:18 AM<BR><B>To:</B> 'Steven Jenner'; 'Leary, Mike'<BR><B>Cc:</B> 
'veritas-bu AT mailman.eng.auburn DOT edu'<BR><B>Subject:</B> RE: [Veritas-bu] 
Failed 
Oracle backups<BR></FONT><BR></DIV>
<DIV></DIV>
<P><FONT size=2>Hi Steven,</FONT> </P>
<P><FONT size=2>So, where does the UPGRADE CATALOG command get it's packages 
from to perform</FONT> <BR><FONT size=2>the upgrade?</FONT> 
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT size=2>You must run the 
rman commands from the database that you upgraded to 8.1.7.4, connecting to the 
rman catalog....the new binaries are coming from there.</FONT></P>
<P><FONT size=2>Do I have to install new packages so they upgraded versions are 
available?</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT 
size=2>It 
is up to you, but if you want to keep it simple, just upgrade the catalog twice 
and keep on backing up. If you move to a new Oracle release like 
9i..10g..then</FONT></P>
<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT size=2>you may be forced to 
upgrade your catalog database as well.</FONT> </P><BR><BR>
<P><FONT size=2>Isidro Rodriguez</FONT> </P><BR><BR>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: Steven 
Jenner [<A 
href="mailto:steven.jenner AT psineteurope DOT com">mailto:steven.jenner AT 
psineteurope DOT com</A>]</FONT> 
<BR><FONT size=2>Sent: Friday, March 05, 2004 5:18 AM</FONT> <BR><FONT 
size=2>To: 'Leary, Mike'</FONT> <BR><FONT size=2>Cc: 
'veritas-bu AT mailman.eng.auburn DOT edu'</FONT> <BR><FONT size=2>Subject: RE: 
[Veritas-bu] Failed Oracle backups</FONT> </P><BR>
<P><FONT size=2>Hi Mike,</FONT> </P>
<P><FONT size=2>Thanks for your reply, as I have limited knowledge of Oracle I 
have another</FONT> <BR><FONT size=2>question. I have ran the UPGRADE CATALOG 
command as documented and</FONT> <BR><FONT size=2>everything appears to 
complete 
successfully (details below)</FONT> </P>
<P><FONT size=2>$ rman CATALOG rman/rman@RMANCAT</FONT> </P>
<P><FONT size=2>Recovery Manager: Release 8.1.7.0.0 - Production</FONT> </P>
<P><FONT size=2>RMAN-06008: connected to recovery catalog database</FONT> </P>
<P><FONT size=2>RMAN&gt; UPGRADE CATALOG</FONT> </P>
<P><FONT size=2>RMAN-06435: recovery catalog owner is RMAN</FONT> <BR><FONT 
size=2>RMAN-06442: enter UPGRADE CATALOG command again to confirm catalog 
upgrade</FONT> </P>
<P><FONT size=2>RMAN&gt; UPGRADE CATALOG</FONT> </P>
<P><FONT size=2>RMAN-06408: recovery catalog upgraded to version 
08.01.06</FONT> 
<BR><FONT size=2>RMAN-06452: DBMS_RCVMAN package upgraded to version 
08.01.07</FONT> <BR><FONT size=2>RMAN-06452: DBMS_RCVCAT package upgraded to 
version 08.01.07</FONT> </P>
<P><FONT size=2>RMAN&gt; </FONT></P>
<P><FONT size=2>But the version is still 8.1.7.0 on the recovery catalogue 
server. </FONT></P>
<P><FONT size=2>So, where does the UPGRADE CATALOG command get it's packages 
from to perform</FONT> <BR><FONT size=2>the upgrade?</FONT> </P>
<P><FONT size=2>Do I have to install new packages so they upograded versions 
are 
available?</FONT> </P>
<P><FONT size=2>Sorry if these are basic questions but searching the web just 
shows the</FONT> <BR><FONT size=2>command and it's output.</FONT> </P>
<P><FONT size=2>Regards,</FONT> </P>
<P><FONT size=2>Steve.</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: Leary, 
Mike [<A 
href="mailto:mleary AT trusecureonline DOT com">mailto:mleary AT 
trusecureonline DOT com</A>]</FONT> 
<BR><FONT size=2>Sent: 04 March 2004 15:09</FONT> <BR><FONT size=2>To: 'Steven 
Jenner'; 'veritas-bu AT mailman.eng.auburn DOT edu'</FONT> <BR><FONT 
size=2>Subject: 
RE: [Veritas-bu] Failed Oracle backups</FONT> </P><BR>
<P><FONT size=2>Steve,</FONT> </P>
<P><FONT size=2>There is a step in upgrades that requires you upgrade the 
recovery catalog</FONT> <BR><FONT size=2>after applying some patchs (not all 
patches require it).&nbsp; It is always safe</FONT> <BR><FONT size=2>to run the 
upgrade just to be safe.&nbsp; :)</FONT> </P>
<P><FONT size=2>Connect to the target and catalog as normal via RMAN.&nbsp; 
Once 
connected issue</FONT> <BR><FONT size=2>"upgrade catalog;" twice (it is 
required 
to issue it twice to confirm the</FONT> <BR><FONT size=2>upgrade 
request).</FONT> </P>
<P><FONT size=2>This will reinstall the recovery catalog packages and upgrade 
the catalog to</FONT> <BR><FONT size=2>the correct version that supports the 
target.&nbsp; The catalog can still run on</FONT> <BR><FONT size=2>a lower 
level 
of oracle (for example: we have a 9.2 catalog in a 8.1.7.4</FONT> <BR><FONT 
size=2>instance) but must be at least the level of the target instance.</FONT> 
</P>
<P><FONT size=2>Hope this helps!!&nbsp; Good luck!</FONT> </P>
<P><FONT size=2>Mike Leary</FONT> <BR><FONT size=2>Oracle DBA / Data 
Architect</FONT> <BR><FONT size=2>Managed Security Services</FONT> <BR><FONT 
size=2>TruSecure Corporation</FONT> <BR><FONT size=2>678.728.1000</FONT> 
<BR><FONT size=2>mleary AT trusecureonline DOT com</FONT> <BR><FONT 
size=2>www.trusecure.com</FONT> </P><BR>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: 
veritas-bu-admin AT mailman.eng.auburn DOT edu</FONT> <BR><FONT size=2>[<A 
href="mailto:veritas-bu-admin AT mailman.eng.auburn DOT 
edu">mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu</A>] 
On Behalf Of Steven Jenner</FONT> <BR><FONT size=2>Sent: Thursday, March 04, 
2004 8:46 AM</FONT> <BR><FONT size=2>To: 
'veritas-bu AT mailman.eng.auburn DOT edu'</FONT> <BR><FONT size=2>Subject: 
[Veritas-bu] Failed Oracle backups</FONT> </P>
<P><FONT size=2>Hi, we have been performing hot Oracle backups on a customers 
server using</FONT> <BR><FONT size=2>RMAN and Veritas and all has been well. 
Recently however our customer</FONT> <BR><FONT size=2>upgraded their version of 
Oracle to 8.1.7.4 whereas the version of Oracle</FONT> <BR><FONT size=2>that is 
running on the Veritas Recovery Catalogue server is 8.1.7.0.</FONT> </P>
<P><FONT size=2>Since the upgrade all hot backups have failed with the folowing 
entries</FONT> <BR><FONT size=2>being written to the bphdb log</FONT> </P>
<P><FONT size=2>RMAN-06008: connected to recovery catalog database</FONT> </P>
<P><FONT size=2>RMAN-03022: compiling command: allocate</FONT> <BR><FONT 
size=2>RMAN-03023: executing command: allocate</FONT> <BR><FONT 
size=2>RMAN-08030: allocated channel: t1</FONT> <BR><FONT size=2>RMAN-08500: 
channel t1: sid=10 devtype=SBT_TAPE</FONT> <BR><FONT size=2>RMAN-08526: channel 
t1: VERITAS NetBackup for Oracle8 - Release 3.4GA</FONT> <BR><FONT 
size=2>(030800)</FONT> </P>
<P><FONT size=2>RMAN-03022: compiling command: allocate</FONT> <BR><FONT 
size=2>RMAN-03023: executing command: allocate</FONT> <BR><FONT 
size=2>RMAN-08030: allocated channel: t2</FONT> <BR><FONT size=2>RMAN-08500: 
channel t2: sid=38 devtype=SBT_TAPE</FONT> <BR><FONT size=2>RMAN-08526: channel 
t2: VERITAS NetBackup for Oracle8 - Release 3.4GA</FONT> <BR><FONT 
size=2>(030800)</FONT> </P>
<P><FONT size=2>RMAN-03022: compiling command: backup</FONT> <BR><FONT 
size=2>RMAN-00571: 
===========================================================</FONT> <BR><FONT 
size=2>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS 
===============</FONT> <BR><FONT size=2>RMAN-00571: 
===========================================================</FONT> <BR><FONT 
size=2>RMAN-03002: failure during compilation of command</FONT> <BR><FONT 
size=2>RMAN-03013: command type: backup</FONT> <BR><FONT size=2>RMAN-03014: 
implicit resync of recovery catalog failed</FONT> <BR><FONT size=2>RMAN-06004: 
ORACLE error from recovery catalog database: ORA-06550: line 1,</FONT> 
<BR><FONT 
size=2>column 21:</FONT> <BR><FONT size=2>PLS-00302: component 'LOCKFORCKPT' 
must be declared</FONT> <BR><FONT size=2>ORA-06550: line 1, column 7:</FONT> 
<BR><FONT size=2>PL/SQL: Statement ignored</FONT> <BR><FONT size=2>RMAN-06097: 
text of failing SQL statement: begin dbms_rcvcat . lockForckpt ;</FONT> 
<BR><FONT size=2>end ;</FONT> <BR><FONT size=2>RMAN-06099: error occurred in 
source file: krmk.pc, line: 2121</FONT> </P>
<P><FONT size=2>Recovery Manager complete.</FONT> </P>
<P><FONT size=2>I believe that this all points to a compatibility issue with 
the 
two Oracle</FONT> <BR><FONT size=2>differing versions and am hoping that 
someone 
out there can confirm this??</FONT> </P>
<P><FONT size=2>Hope you can help.</FONT> </P>
<P><FONT size=2></FONT> </P>
<P><FONT size=2>_______________________________________________</FONT> 
<BR><FONT 
size=2>Veritas-bu maillist&nbsp; -&nbsp; 
Veritas-bu AT mailman.eng.auburn DOT edu</FONT> <BR><FONT size=2><A 
href="http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu"; 
target=_blank>http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu</A></FONT>
 
</P>
<P><FONT 
size=2>***********************************************************************</FONT>
 
<BR><FONT size=2>This message is intended only for the use of the intended 
recipient and</FONT> <BR><FONT size=2>may contain information that is 
PRIVILEGED 
and/or CONFIDENTIAL.&nbsp; If you</FONT> <BR><FONT size=2>are not the intended 
recipient, you are hereby notified that any use,</FONT> <BR><FONT 
size=2>dissemination, disclosure or copying of this communication is 
strictly</FONT> <BR><FONT size=2>prohibited.&nbsp; If you have received this 
communication in error, please</FONT> <BR><FONT size=2>destroy all copies of 
this message and its attachments and notify us</FONT> <BR><FONT 
size=2>immediately.</FONT> <BR><FONT 
size=2>***********************************************************************</FONT>
 
<BR><FONT size=2>_______________________________________________</FONT> 
<BR><FONT size=2>Veritas-bu maillist&nbsp; -&nbsp; 
Veritas-bu AT mailman.eng.auburn DOT edu</FONT> <BR><FONT size=2><A 
href="http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu"; 
target=_blank>http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu</A></FONT>
 
</P></BODY></HTML>

------_=_NextPart_001_01C402BB.A59EFA17--

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