Upgrade rman catalog – no need to upgrade oracle database version

Rman catalog can be upgraded to a higher version than its hosting database oracle version. This is useful if you want to back up new versions of oracle without changing the oracle version on the database used to host the rman catalog.

To do this, run the following commands from the higher version oracle database:

connect target /   #< can be a higher version of oracle
connect catalog username/password@connect_string   #< can be a lower version of oracle
upgrade catalog ;

Tested on v11.2.0.2 - v11.2.0.3 on linux RHEL5 64 bit.

March 2, 2013

  • Good man – Never seen catalog version higher than the rdbms version before today, and now i know hows its done – Seriously thanks!

  • Leave a Reply

    Your email address will not be published. Required fields are marked *