Tuesday, August 25, 2009

Upgrade rman catalog for databases


Recovery Manager: Release - Production on Tue Aug 25 08:25:59 2009

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

RMAN> connect target /

connected to target database: P01REF (DBID=3918657745)

RMAN> connect catalog rcowner/password@rman

connected to recovery catalog database
PL/SQL package RCOWNER.DBMS_RCVCAT version in RCVCAT database is too old

RMAN> upgrade catalog;

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

RMAN> upgrade catalog;

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