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> ). 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> </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> </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> <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> <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> <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> 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> 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> </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). It is always safe</FONT> <BR><FONT size=2>to run the
upgrade just to be safe. :)</FONT> </P>
<P><FONT size=2>Connect to the target and catalog as normal via RMAN.
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. 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!! 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 -
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. 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. 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 -
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--
|