Re: Oracle 21c / RMAN

Hi Scott,

The recovery catalog version should to be at least at the same version as the highest version of your target db.

Eg, if the highest version of all your target db is 21c, your catalog should also be 21c. The 21c catalog can backup all dbs from 11g to 21c. I’m not sure about target versions below 11g. You should be able to look up an oracle support note for the target vs catog matrix.

Cheers,
Leng

> On 26 May 2022, at 11:29 pm, Scott Canaan <srcdco_at_rit.edu> wrote:
>
> 
> I wasn’t as concerned with the 19c database as the 12.1 and 12.2 databases.
>
> Scott Canaan ‘88
> Sr Database Administrator
> Information & Technology Services
> Finance & Administration
> Rochester Institute of Technology
> o: (585) 475-7886 | f: (585) 475-7520
> srcdco_at_rit.edu | c: (585) 339-8659
>
> CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.
>
> From: Nenad Noveljic <nenad.noveljic_at_gmail.com>
> Sent: Thursday, May 26, 2022 9:27 AM
> To: Scott Canaan <srcdco_at_rit.edu>
> Cc: oracle-l_at_freelists.org
> Subject: Re: Oracle 21c / RMAN
>
> We backup both 19c and 21c in the same 21c catalog. But in case of doubt, you can have several catalogs in the same db.
>
> Von meinem iPhone gesendet
>
>
> Am 26.05.2022 um 15:16 schrieb Scott Canaan <srcdco_at_rit.edu>:
>
> 
> I have created an Oracle 21c database to play with. In doing so, I tried to register it with RMAN and that failed:
>
> oracle_at_vmora00a8:ORA21000>rman target / catalog rman_at_rmanprod
>
> Recovery Manager: Release 21.0.0.0.0 - Production on Thu May 26 09:02:53 2022
> Version 21.6.0.0.0
>
> Copyright (c) 1982, 2021, Oracle and/or its affiliates. All rights reserved.
>
> connected to target database: ORA21000 (DBID=1486141419)
> recovery catalog database Password:
> connected to recovery catalog database
> PL/SQL package RMAN.DBMS_RCVCAT version 19.15.00.00. in RCVCAT database is too old
>
> RMAN> register database;
>
> PL/SQL package RMAN.DBMS_RCVCAT version 19.15.00.00. in RCVCAT database is too old
> PL/SQL package RMAN.DBMS_RCVCAT version 19.15.00.00. in RCVCAT database is too old
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03002: failure of register command at 05/26/2022 09:03:40
> RMAN-06429: RCVCAT database is not compatible with this version of RMAN
>
> RMAN> exit
>
> Obviously, RMAN wants the catalog upgraded to 21c. Since we back up Oracle 12.1, 12.2, 18, and 19 databases, my question is: Will upgrading the catalog to 21c impact the existing backups?
>
> Thank you,
>
> Scott Canaan ‘88
> Sr Database Administrator
> Information & Technology Services
> Finance & Administration
> Rochester Institute of Technology
> o: (585) 475-7886 | f: (585) 475-7520
> srcdco_at_rit.edu | c: (585) 339-8659
>
>
> CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.
>

--
http://www.freelists.org/webpage/oracle-l