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

From: BanarasiBabu Tippa <btippa_at_ORsoftware-india.com>
Date: Mon, 17 Feb 2003 02:48:39 -0800
Message-ID: <F001.0054F29D.20030217024839@fatcity.com>

Hi sujatha

I am not sure But I guess your target database is 9i and you are trying to connect from 8i rman exe, this may be causing problem otherwise it may be bug in 8i. Try to work from catalog server.

Hope this may help you

thanks
Banarasi Babu
OCP, DBA -----Original Message-----
Sent: Monday, February 17, 2003 9:24 AM
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: BanarasiBabu Tippa
  INET: btippa_at_ORsoftware-india.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 - 04:48:39 CST