Recovery Catalog setup-RMAN-Oracle Database

                  Setup Your Recovery Catalog Database

Step - 1: Create Recovery Catalog Schema:

SQL> create user RMAN identified by rman

           temporary tablespace temp

           default tablespace rman_tablespace

           quota unlimited on rman_tablespace

Default tablespace may be any existing one or we can create a new one before creating recovery catalog schema.

Step - 2: Grant necessary privileges to rman: 

SQL> grant RECOVERY_CATALOG_OWNER to RMAN;

Step - 3: Connect to RMAN:

$rman CATALOG rman/rman@catalogdbname target targetdbname

Step - 4: Create the Recovery Catalog:

RMAN> CREATE CATALOG;

Step - 5: Registering a Database:

RMAN> REGISTER DATABASE;

Remember to register a new database in the recovery catalog, first we need to connect to the target database. Repeat step 5 after connecting to the particular target database for each database you want to register.

RMAN> REPORT SCHEMA

To make sure all the datafiles of target database are showing up in the list.