Oracle-L: RE: RMAN: One Catalog DB .. different target db releases

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 17 Feb 2003 05:33:41 -0800
Message-ID: <F001.0054F384.20030217053341@fatcity.com>

Sujatha

Look at your step 4. It should read:

On the CATALOG database server, I invoked RMAN and connected to the TARGET database and catalog database.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Sunday, February 16, 2003 9:54 PM
To: Multiple recipients of list ORACLE-L

Hi Everyone,

I have a recovery catalog database in version 9.2.0 (Solaris). I now need to backup a 8.1.5 target database (Solaris) using the 9.2.0 catalog db, however I am running into some problems which I can't solve nor find a solution to. These are the steps I have followed:

In the 9.2 catalog database I created a new user (rman8i) and a new tablespace. I know I didn't have to create a new tablespace, but the database is not mine and I wanted to keep everything seperate.
I granted resource, connect and recovery_catalog_owner to the rman8i user.
On the target (8.1.7) database server, I created the SQLNet link successfully
On the target (8.1.7) database server, I invoked rman and connected to the catalog as follows:

Recovery Manager: Release 8.1.5.0.0 - Production

RMAN> connect catalog rman8i/rman8i_at_rcat9

RMAN-06008: connected to recovery catalog database RMAN-06428: recovery catalog is not installed

RMAN>

5) I then tried to create the catalog. It doesn't give a very descriptive error reason, but it failed:

RMAN-06444: dbms_rcvcat package body created with compilation errors
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06433: error installing recovery catalog

RMAN>

6) I then log out and log back in and try to connect to the catalog. This produces the following error:

RMAN> connect catalog rman8i/rman8i_at_rcat9

RMAN-06008: connected to recovery catalog database
RMAN-06099: error occurred in source file: krmk.pc, line: 20686
RMAN-06097: text of failing SQL statement: declare vsn varchar2 ( 20 ) ;

begin vsn := dbms_rcvcat . getPackageVersion ; :pkg_vsn:pkg_vsn_i := vsn ; if vsn is not null then :pkg_vsnub4 := to_number ( substr ( vsn , 1 , 2 ) || substr ( vsn , 4 , 2 ) || substr ( vsn , 7 , 2 ) ) ; end if ; end ; RMAN-06004: ORACLE error from recovery catalog database: ORA-04068: existing state of packages has been discarded

ORA-04063: package body "RMAN8I.DBMS_RCVCAT" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

RMAN>

Am I doing anything wrong in the above process??? ... Has anyone been through this before - or know of any bug????

I did try and drop/delete everything I did and redo it all, but it didn't work either.

Sorry for the lengthy mail and thanks in advance for your help

Cheers
Sujatha

Sujatha Madan
Database Administrator
Custom Management Centre
Optus Business Operations
'yes' OPTUS
PH # +61 2 9775 9868
Mobile # +61 402 354 347
FAX # +61 2 9775 9510
Email Sujatha.Madan_at_cmc.optus.net.au
WEB http://www.optusbusiness.com.au/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sujatha Madan
  INET: Sujatha.Madan_at_cmc.optus.net.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Feb 17 2003 - 07:33:41 CST