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
SQL > ! rman target /
Recovery
Manager: Release 11.2.0.2.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: MYDB (DBID=5490950350)
-- Connect
to the Recover catalog database
RMAN>
connect catalog rman/rman@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
RMAN>
TO
DETERMINE THE CURRENT RELEASE OF THE CATALOG SCHEMA, YOU MUST RUN A SQL QUERY.
$ sqlplus rman/rman@RMAN_CATALOG
SQL*Plus:
Release 11.2.0.2.0 Production on Thu Jan 12 15:19:51 2012
Copyright
(c) 1982, 2010, Oracle. All rights
reserved.
Connected
to:
Oracle
Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning,
Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining
and Real Application Testing options
SQL>
SELECT * FROM rcver;
VERSION
------------
11.02.00.02
Note:
1) For
releases 11.2 and later, the last two digits in the ‘rcver’ output indicate
patch level. For earlier releases, they are always zeros.
2) In above Query, If multiple versions are
listed, then the last row is the current version, and the rows before it are
prior versions.
No comments:
Post a Comment