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_01C402B4.448E93E0
Content-Type: text/plain
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]
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]
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] 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
***********************************************************************
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
------_=_NextPart_001_01C402B4.448E93E0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.45">
<TITLE>RE: [Veritas-bu] Failed Oracle backups</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hi Steven,</FONT>
</P>
<P><FONT SIZE=3D2>So, where does the UPGRADE CATALOG command get it's =
packages from to perform</FONT>
<BR><FONT SIZE=3D2>the upgrade?</FONT>
<BR> <FONT SIZE=3D2>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=3D2>Do I have to install new packages so they upgraded =
versions are available?</FONT>
<BR> <FONT SIZE=3D2>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=3D2>you may be =
forced to upgrade your catalog database as well.</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>Isidro Rodriguez</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Steven Jenner [<A =
HREF=3D"mailto:steven.jenner AT psineteurope DOT com">mailto:steven.jenner@psin=
eteurope.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, March 05, 2004 5:18 AM</FONT>
<BR><FONT SIZE=3D2>To: 'Leary, Mike'</FONT>
<BR><FONT SIZE=3D2>Cc: 'veritas-bu AT mailman.eng.auburn DOT edu'</FONT>
<BR><FONT SIZE=3D2>Subject: RE: [Veritas-bu] Failed Oracle =
backups</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi Mike,</FONT>
</P>
<P><FONT SIZE=3D2>Thanks for your reply, as I have limited knowledge of =
Oracle I have another</FONT>
<BR><FONT SIZE=3D2>question. I have ran the UPGRADE CATALOG command as =
documented and</FONT>
<BR><FONT SIZE=3D2>everything appears to complete successfully (details =
below)</FONT>
</P>
<P><FONT SIZE=3D2>$ rman CATALOG rman/rman@RMANCAT</FONT>
</P>
<P><FONT SIZE=3D2>Recovery Manager: Release 8.1.7.0.0 - =
Production</FONT>
</P>
<P><FONT SIZE=3D2>RMAN-06008: connected to recovery catalog =
database</FONT>
</P>
<P><FONT SIZE=3D2>RMAN> UPGRADE CATALOG</FONT>
</P>
<P><FONT SIZE=3D2>RMAN-06435: recovery catalog owner is RMAN</FONT>
<BR><FONT SIZE=3D2>RMAN-06442: enter UPGRADE CATALOG command again to =
confirm catalog upgrade</FONT>
</P>
<P><FONT SIZE=3D2>RMAN> UPGRADE CATALOG</FONT>
</P>
<P><FONT SIZE=3D2>RMAN-06408: recovery catalog upgraded to version =
08.01.06</FONT>
<BR><FONT SIZE=3D2>RMAN-06452: DBMS_RCVMAN package upgraded to version =
08.01.07</FONT>
<BR><FONT SIZE=3D2>RMAN-06452: DBMS_RCVCAT package upgraded to version =
08.01.07</FONT>
</P>
<P><FONT SIZE=3D2>RMAN> </FONT>
</P>
<P><FONT SIZE=3D2>But the version is still 8.1.7.0 on the recovery =
catalogue server. </FONT>
</P>
<P><FONT SIZE=3D2>So, where does the UPGRADE CATALOG command get it's =
packages from to perform</FONT>
<BR><FONT SIZE=3D2>the upgrade?</FONT>
</P>
<P><FONT SIZE=3D2>Do I have to install new packages so they upograded =
versions are available?</FONT>
</P>
<P><FONT SIZE=3D2>Sorry if these are basic questions but searching the =
web just shows the</FONT>
<BR><FONT SIZE=3D2>command and it's output.</FONT>
</P>
<P><FONT SIZE=3D2>Regards,</FONT>
</P>
<P><FONT SIZE=3D2>Steve.</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Leary, Mike [<A =
HREF=3D"mailto:mleary AT trusecureonline DOT com">mailto:mleary@trusecureonline=
.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: 04 March 2004 15:09</FONT>
<BR><FONT SIZE=3D2>To: 'Steven Jenner'; =
'veritas-bu AT mailman.eng.auburn DOT edu'</FONT>
<BR><FONT SIZE=3D2>Subject: RE: [Veritas-bu] Failed Oracle =
backups</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Steve,</FONT>
</P>
<P><FONT SIZE=3D2>There is a step in upgrades that requires you upgrade =
the recovery catalog</FONT>
<BR><FONT SIZE=3D2>after applying some patchs (not all patches require =
it). It is always safe</FONT>
<BR><FONT SIZE=3D2>to run the upgrade just to be safe. :)</FONT>
</P>
<P><FONT SIZE=3D2>Connect to the target and catalog as normal via =
RMAN. Once connected issue</FONT>
<BR><FONT SIZE=3D2>"upgrade catalog;" twice (it is required =
to issue it twice to confirm the</FONT>
<BR><FONT SIZE=3D2>upgrade request).</FONT>
</P>
<P><FONT SIZE=3D2>This will reinstall the recovery catalog packages and =
upgrade the catalog to</FONT>
<BR><FONT SIZE=3D2>the correct version that supports the target. =
The catalog can still run on</FONT>
<BR><FONT SIZE=3D2>a lower level of oracle (for example: we have a 9.2 =
catalog in a 8.1.7.4</FONT>
<BR><FONT SIZE=3D2>instance) but must be at least the level of the =
target instance.</FONT>
</P>
<P><FONT SIZE=3D2>Hope this helps!! Good luck!</FONT>
</P>
<P><FONT SIZE=3D2>Mike Leary</FONT>
<BR><FONT SIZE=3D2>Oracle DBA / Data Architect</FONT>
<BR><FONT SIZE=3D2>Managed Security Services</FONT>
<BR><FONT SIZE=3D2>TruSecure Corporation</FONT>
<BR><FONT SIZE=3D2>678.728.1000</FONT>
<BR><FONT SIZE=3D2>mleary AT trusecureonline DOT com</FONT>
<BR><FONT SIZE=3D2>www.trusecure.com</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: veritas-bu-admin AT mailman.eng.auburn DOT edu</FONT>
<BR><FONT SIZE=3D2>[<A =
HREF=3D"mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu">mailto:veritas-b=
u-admin AT mailman.eng.auburn DOT edu</A>] On Behalf Of Steven Jenner</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, March 04, 2004 8:46 AM</FONT>
<BR><FONT SIZE=3D2>To: 'veritas-bu AT mailman.eng.auburn DOT edu'</FONT>
<BR><FONT SIZE=3D2>Subject: [Veritas-bu] Failed Oracle backups</FONT>
</P>
<P><FONT SIZE=3D2>Hi, we have been performing hot Oracle backups on a =
customers server using</FONT>
<BR><FONT SIZE=3D2>RMAN and Veritas and all has been well. Recently =
however our customer</FONT>
<BR><FONT SIZE=3D2>upgraded their version of Oracle to 8.1.7.4 whereas =
the version of Oracle</FONT>
<BR><FONT SIZE=3D2>that is running on the Veritas Recovery Catalogue =
server is 8.1.7.0.</FONT>
</P>
<P><FONT SIZE=3D2>Since the upgrade all hot backups have failed with =
the folowing entries</FONT>
<BR><FONT SIZE=3D2>being written to the bphdb log</FONT>
</P>
<P><FONT SIZE=3D2>RMAN-06008: connected to recovery catalog =
database</FONT>
</P>
<P><FONT SIZE=3D2>RMAN-03022: compiling command: allocate</FONT>
<BR><FONT SIZE=3D2>RMAN-03023: executing command: allocate</FONT>
<BR><FONT SIZE=3D2>RMAN-08030: allocated channel: t1</FONT>
<BR><FONT SIZE=3D2>RMAN-08500: channel t1: sid=3D10 =
devtype=3DSBT_TAPE</FONT>
<BR><FONT SIZE=3D2>RMAN-08526: channel t1: VERITAS NetBackup for =
Oracle8 - Release 3.4GA</FONT>
<BR><FONT SIZE=3D2>(030800)</FONT>
</P>
<P><FONT SIZE=3D2>RMAN-03022: compiling command: allocate</FONT>
<BR><FONT SIZE=3D2>RMAN-03023: executing command: allocate</FONT>
<BR><FONT SIZE=3D2>RMAN-08030: allocated channel: t2</FONT>
<BR><FONT SIZE=3D2>RMAN-08500: channel t2: sid=3D38 =
devtype=3DSBT_TAPE</FONT>
<BR><FONT SIZE=3D2>RMAN-08526: channel t2: VERITAS NetBackup for =
Oracle8 - Release 3.4GA</FONT>
<BR><FONT SIZE=3D2>(030800)</FONT>
</P>
<P><FONT SIZE=3D2>RMAN-03022: compiling command: backup</FONT>
<BR><FONT SIZE=3D2>RMAN-00571: =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2>RMAN-00569: =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE STACK =
FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2>RMAN-00571: =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2>RMAN-03002: failure during compilation of =
command</FONT>
<BR><FONT SIZE=3D2>RMAN-03013: command type: backup</FONT>
<BR><FONT SIZE=3D2>RMAN-03014: implicit resync of recovery catalog =
failed</FONT>
<BR><FONT SIZE=3D2>RMAN-06004: ORACLE error from recovery catalog =
database: ORA-06550: line 1,</FONT>
<BR><FONT SIZE=3D2>column 21:</FONT>
<BR><FONT SIZE=3D2>PLS-00302: component 'LOCKFORCKPT' must be =
declared</FONT>
<BR><FONT SIZE=3D2>ORA-06550: line 1, column 7:</FONT>
<BR><FONT SIZE=3D2>PL/SQL: Statement ignored</FONT>
<BR><FONT SIZE=3D2>RMAN-06097: text of failing SQL statement: begin =
dbms_rcvcat . lockForckpt ;</FONT>
<BR><FONT SIZE=3D2>end ;</FONT>
<BR><FONT SIZE=3D2>RMAN-06099: error occurred in source file: krmk.pc, =
line: 2121</FONT>
</P>
<P><FONT SIZE=3D2>Recovery Manager complete.</FONT>
</P>
<P><FONT SIZE=3D2>I believe that this all points to a compatibility =
issue with the two Oracle</FONT>
<BR><FONT SIZE=3D2>differing versions and am hoping that someone out =
there can confirm this??</FONT>
</P>
<P><FONT SIZE=3D2>Hope you can help.</FONT>
</P>
<P><FONT SIZE=3D2> </FONT>
</P>
<P><FONT =
SIZE=3D2>_______________________________________________</FONT>
<BR><FONT SIZE=3D2>Veritas-bu maillist - =
Veritas-bu AT mailman.eng.auburn DOT edu</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu"; =
TARGET=3D"_blank">http://mailman.eng.auburn.edu/mailman/listinfo/veritas=
-bu</A></FONT>
</P>
<P><FONT =
SIZE=3D2>***************************************************************=
********</FONT>
<BR><FONT SIZE=3D2>This message is intended only for the use of the =
intended recipient and</FONT>
<BR><FONT SIZE=3D2>may contain information that is PRIVILEGED and/or =
CONFIDENTIAL. If you</FONT>
<BR><FONT SIZE=3D2>are not the intended recipient, you are hereby =
notified that any use,</FONT>
<BR><FONT SIZE=3D2>dissemination, disclosure or copying of this =
communication is strictly</FONT>
<BR><FONT SIZE=3D2>prohibited. If you have received this =
communication in error, please</FONT>
<BR><FONT SIZE=3D2>destroy all copies of this message and its =
attachments and notify us</FONT>
<BR><FONT SIZE=3D2>immediately.</FONT>
<BR><FONT =
SIZE=3D2>***************************************************************=
********</FONT>
<BR><FONT =
SIZE=3D2>_______________________________________________</FONT>
<BR><FONT SIZE=3D2>Veritas-bu maillist - =
Veritas-bu AT mailman.eng.auburn DOT edu</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu"; =
TARGET=3D"_blank">http://mailman.eng.auburn.edu/mailman/listinfo/veritas=
-bu</A></FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C402B4.448E93E0--
|
