Pages

Friday, April 18, 2008

RMAN: UPGRADE CATALOG command

While registering a new two nodes Oracle RAC installation to my recovery catalog I encountered the following error:





[oracle@blade05 ~]$ rman target sys/my_pwd catalog rman/cat@CATDB

Recovery Manager: Release 10.2.0.4.0 - Production on Fri Apr 18 10:32:46 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: DWHDB (DBID=3585749232)
connected to recovery catalog database
PL/SQL package RMAN.DBMS_RCVCAT version 10.02.00.00 in RCVCAT database is not current
PL/SQL package RMAN.DBMS_RCVMAN version 10.02.00.00 in RCVCAT database is not current


It means I'm using a different version of rman between the RAC installation and the recovery catalog, indeed the RAC installation is at 10.2.0.4 while recovery catalog is at 10.2.01 version.
If you use a version of the recovery catalog that is older than that required by the RMAN client, then you must upgrade it using UPGRADE CATALOG command;
I'm upgrading from a client using 10.2.0.4 software version, while at the same time my recovery catalog is serving also other database using older or the same version. That's not a problem: it's important that recovery catalog is at least at the same version of your newest database client version.

So while I'm connected from RAC installation I need to issue the UPGRADE CATALOG command:
RMAN> upgrade catalog;

recovery catalog owner is RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade

RMAN> upgrade catalog;

recovery catalog upgraded to version 10.02.00.04
DBMS_RCVMAN package upgraded to version 10.02.00.00
DBMS_RCVCAT package upgraded to version 10.02.00.00

RMAN>

That's all.