How to Create an RMAN Recovery Catalog Database

- Create a database with DBCA preferably named RMANCAT, CATDB ...;

- Create a user which will be owner of the recovery catalog;

$ sqlplus / as sysdba
SQL> create user rmanuser identified by rmanuser;

- Grant necessary roles, priviledges to user

SQL> grant recovery_catalog_owner to rmanuser;
SQL> grant connect, resource to rmanuser;

- Create Recovery Catalog

$rman catalog rmanuser/rmanuser
RMAN> create catalog;

- Register the databases which will use this database as recovery catalog

$rman target / catalog rmanuser/rmanuser@RMANCAT
RMAN> register database;

- Verify that the registration was successful by running REPORT SCHEMA

RMAN> report schema;