upgradeCatalog

Syntax

Purpose

To upgrade the recovery catalog schema from an older version to the version required by the RMAN executable. For example, if you use an 8.0 recovery catalog with an 8.1 version of RMAN, then you must upgrade the catalog.

Requirements

• RMAN must be connected to the recovery catalog.

• You must enter the upgrade command twice in a row to confirm the upgrade.

• You will receive an error if the recovery catalog is already at a version greater than needed by the RMAN executable. RMAN permits the command to be run if the recovery catalog is already current, however, so that the packages can be re-created if necessary. RMAN displays all error messages generated during the upgrade in the message log.

Keywords and Parameters

tablespace tablespace_name

specifies the tablespace in which to store the recovery catalog. If not specified, then no tablespace parameter will be used in the CREATE TABLE statements used to upgrade the recovery catalog, which means that the catalog will be stored in the default tablespace.

Examples

Upgrading a Catalog

This example connects to recovery catalog database RECDB and then upgrades it to a more current version:

rman catalog rcat/rcat@recdb

RMAN-06008: connected to recovery catalog database 
RMAN-06186: PL/SQL package rcat.DBMS_RCVCAT version 08.00.04 in RCVCAT 
            database is too old

RMAN> upgrade catalog

RMAN-06435: recovery catalog owner is rcat 
RMAN-06442: enter UPGRADE CATALOG command again to confirm catalog upgrade 

RMAN> upgrade catalog

RMAN-06408: recovery catalog upgraded to version 08.01.03
RMAN-06452: DBMS_RCVMAN package upgraded to version 08.01.05
RMAN-06452: DBMS_RCVCAT package upgraded to version 08.01.03

Related Topics

"createCatalog"

"dropCatalog"