This post discuss about how to upgrade RMAN catalog in 11gR2 after applying a PSU Patch
Note: This is not the database upgrade, this post provides information on the RMAN Catalog upgrade for an database after a PSU patch has been applied in the database server.
“The recovery catalog schema version must be greater than or equal to the RMAN client version”.
For your 11.2 database, if you are running RMAN from the same ORACLE_HOME, your RMAN Client is 11.2. The catalog schema must be 11.2. Although it can be in an 11.1 database, it would have been preferable to have it in 11.2. The better course is to upgrade the RMAN Catalog database to the highest of all the target databases and the Catalog schema to the highest RMAN client.
-- Connect to the target database on the server
oracle > rman target /
Recovery Manager: Release 220.127.116.11.0 - Production on Thu Jan 12 15:03:42 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: BHUVAN (DBID=3982664177)
-- Connect to the Recover catalog database
RMAN> connect catalog rman/xxxxx@RMAN_CATALOG
connected to recovery catalog database
-- upgrade the catalog by connecting to the target database and catalog database.
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 11.02.00.02
DBMS_RCVMAN package upgraded to version 11.02.00.02
DBMS_RCVCAT package upgraded to version 11.02.00.02
TO DETERMINE THE CURRENT RELEASE OF THE CATALOG SCHEMA, YOU MUST RUN A SQL QUERY.
oracle> sqlplus rman/xxxx@RMAN_CATALOG
SQL*Plus: Release 18.104.22.168.0 Production on Thu Jan 12 15:19:51 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> SELECT * FROM rcver;
1) If multiple versions are listed, then the last row is the current version, and the rows before it are prior versions.
2) For releases 11.2 and later, the last two digits in the
rcveroutput indicate patch level. For earlier releases, they are always zeros.