Oracle say that the rman recovery catalog database cannot be lower than the
database being backed up.

It can be at a different version but not lower. We have an Oracle 9 rman
database with a collection of different database versions backing up
through it.

Cheers
Ed





Steven Jenner <steven.jenner AT psineteurope DOT com>@mailman.eng.auburn.edu on
04/03/2004 13:45:58

Sent by:    veritas-bu-admin AT mailman.eng.auburn DOT edu


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


 ===============================================================
 National Australia Group Europe Limited (Company Number 02108635,
 Registered Office 88 Wood Street, London EC2V 7QQ) ( &NAGE 8) is a
 subsidiary of National Australia Bank Limited (an Australian registered
 company). The following UK subsidiaries of NAGE are authorised and
 regulated by the Financial Services Authority: Clydesdale Bank PLC,
 Yorkshire Bank PLC, Northern Bank Limited, Northern Bank Executor and
 Trustee Company Limited, MLC Savings Limited, MLC Trust Management Company
 Limited, Clydesdale Bank Insurance Brokers Limited, Yorkshire Bank
 Financial Services Limited, Northern Bank Insurance Services Limited,
 National Australia Bank Limited. In Ireland National Irish Bank Limited
 and National Irish Investment Bank Limited are regulated by the Irish
 Financial Services Regulatory Authority.

 The views and opinions expressed in this email may not reflect the views
 and opinions of any member of the group of which NAGE forms part. The
 information contained in this message is confidential and may also be
 privileged. It is intended only for the addressee named above. The
 unauthorised use, disclosure, copying or alteration of this message is
 strictly prohibited. If you are not the addressee (or responsible for
 delivery of the message to the addressee), please notify the originator
 immediately by return message and destroy the original message. This
 message and any attachments have been scanned for viruses prior to leaving
 NAGE ,s network. However, NAGE does not guarantee the security of this
 message and will not be responsible for any damages arising as a result of
 any virus being passed on or arising from any alteration of this message
 by a third party. NAGE may monitor emails sent to and from NAGE ,s
 network.