Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN: One Catalog DB .. different target db releases

RE: RMAN: One Catalog DB .. different target db releases

From: Sujatha Madan <Sujatha.Madan_at_cmc.optus.net.au>
Date: Mon, 17 Feb 2003 15:14:20 -0800
Message-ID: <F001.0054FA45.20030217151420@fatcity.com>


Thanks Dennis! ... didn't pick that one up.

BTW: If anyone is using a catalog database of 9.2.x with a target database of 8.1.5.0.x you will run across Bug: 981711. You can't resync the catalog or in effect do anything without getting a ORA-600 [17003], [7021268] [xxx] [xxxx]. If you get this you will have to upgrade your target database to 8.1.5.1 or on some platforms 8.1.5.2.

Regards,

Sujatha

-----Original Message-----

Sent: Tuesday, 18 February 2003 12:34 AM To: Multiple recipients of list ORACLE-L

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:

  1. 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.
  2. I granted resource, connect and recovery_catalog_owner to the rman8i user.
  3. On the target (8.1.7) database server, I created the SQLNet link successfully
  4. 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). -- 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).
Received on Mon Feb 17 2003 - 17:14:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US