[Veritas-bu] Failed Oracle backups
2004-03-04 09:26:58
This is a multipart message in MIME format.
--=_alternative 004F5FBE85256E4D_=
Content-Type: text/plain; charset="us-ascii"
I think you need to re-register, or run an RMAN command to upgrade the
recovery catalog for
that database to the newer version of Oracle, I can't remember what the
command is off hand.
=============================
Carl Stehman
PHI Services Company
202-331-6619
Pager 301-765-2703
ckstehman AT pepco DOT com
Steven Jenner <steven.jenner AT psineteurope DOT com>
Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu
03/04/2004 08:45 AM
To: "'veritas-bu AT mailman.eng.auburn DOT edu'" <veritas-bu AT
mailman.eng.auburn DOT edu>
cc:
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
--=_alternative 004F5FBE85256E4D_=
Content-Type: text/html; charset="us-ascii"
<br><font size=2 face="sans-serif">I think you need to re-register, or run an
RMAN command to upgrade the recovery catalog for </font>
<br><font size=2 face="sans-serif">that database to the newer version of
Oracle, I can't remember what the command is off hand.</font>
<br>
<br><font size=2 face="sans-serif"><br>
=============================<br>
Carl Stehman<br>
PHI Services Company<br>
202-331-6619<br>
Pager 301-765-2703<br>
ckstehman AT pepco DOT com</font>
<br>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>Steven Jenner <steven.jenner AT
psineteurope DOT com></b></font>
<br><font size=1 face="sans-serif">Sent by: veritas-bu-admin AT
mailman.eng.auburn DOT edu</font>
<p><font size=1 face="sans-serif">03/04/2004 08:45 AM</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To:
"'veritas-bu AT mailman.eng.auburn DOT edu'"
<veritas-bu AT mailman.eng.auburn DOT edu></font>
<br><font size=1 face="sans-serif"> cc:
</font>
<br><font size=1 face="sans-serif"> Subject:
[Veritas-bu] Failed Oracle backups</font></table>
<br>
<br>
<br><font size=2 face="Courier New">Hi, we have been performing hot Oracle
backups on a customers server using<br>
RMAN and Veritas and all has been well. Recently however our customer<br>
upgraded their version of Oracle to 8.1.7.4 whereas the version of Oracle<br>
that is running on the Veritas Recovery Catalogue server is 8.1.7.0.<br>
<br>
Since the upgrade all hot backups have failed with the folowing entries<br>
being written to the bphdb log<br>
<br>
RMAN-06008: connected to recovery catalog database<br>
<br>
RMAN-03022: compiling command: allocate<br>
RMAN-03023: executing command: allocate<br>
RMAN-08030: allocated channel: t1<br>
RMAN-08500: channel t1: sid=10 devtype=SBT_TAPE<br>
RMAN-08526: channel t1: VERITAS NetBackup for Oracle8 - Release 3.4GA<br>
(030800)<br>
<br>
RMAN-03022: compiling command: allocate<br>
RMAN-03023: executing command: allocate<br>
RMAN-08030: allocated channel: t2<br>
RMAN-08500: channel t2: sid=38 devtype=SBT_TAPE<br>
RMAN-08526: channel t2: VERITAS NetBackup for Oracle8 - Release 3.4GA<br>
(030800)<br>
<br>
RMAN-03022: compiling command: backup<br>
RMAN-00571: ===========================================================<br>
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br>
RMAN-00571: ===========================================================<br>
RMAN-03002: failure during compilation of command<br>
RMAN-03013: command type: backup<br>
RMAN-03014: implicit resync of recovery catalog failed<br>
RMAN-06004: ORACLE error from recovery catalog database: ORA-06550: line 1,<br>
column 21:<br>
PLS-00302: component 'LOCKFORCKPT' must be declared<br>
ORA-06550: line 1, column 7:<br>
PL/SQL: Statement ignored<br>
RMAN-06097: text of failing SQL statement: begin dbms_rcvcat . lockForckpt ;<br>
end ;<br>
RMAN-06099: error occurred in source file: krmk.pc, line: 2121<br>
<br>
Recovery Manager complete.<br>
<br>
I believe that this all points to a compatibility issue with the two Oracle<br>
differing versions and am hoping that someone out there can confirm this??<br>
<br>
Hope you can help.<br>
<br>
<br>
<br>
_______________________________________________<br>
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu<br>
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu<br>
</font>
<br>
<br>
<br>
--=_alternative 004F5FBE85256E4D_=--
|
|
|