Potential of “import catalog” command

Originally posted on “Databases at CERN” blog

Since version 11.1 of Oracle database, there is very useful command available, allowing DBAs to easily move RMAN recovery catalog schemas between databases. Its functionality is even broader, as it also allows one catalog schema to be merged into another – either the whole schema or just the metadata of chosen databases. Command I’m writing about is of course IMPORT CATALOG, which I had a chance to use recently, to move our recovery catalog to the new database. It was moved from Oracle 11.2.0.3 database to 11.2.0.4, with recovery catalog schema using below version:

Continue reading “Potential of “import catalog” command”

Advertisements