How to Create RMAN Catalog

To create the recovery catalog schema in the recovery catalog database:

Start SQL*Plus and then connect with administrator privileges to the database containing the recovery catalog. For example, enter:

1) sql> CONNECT SYS/oracle@catdb AS SYSDBA

Create a user and schema for the recovery catalog. For example, enter:

sql > CREATE USER rman IDENTIFIED BY cat
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE tools
QUOTA UNLIMITED ON tools;
*************************************
Grant the Permission as mention below.
**************************************
sql> GRANT RECOVERY_CATALOG_OWNER TO rman;
sql> grant connect , resource to rman;
**************************************
Now Create Catalog
**************************************
RMAN> CONNECT CATALOG rman/cat@catdb
RMAN> CREATE CATALOG TABLESPACE cat_ts;
**************************************
SQL> SELECT TABLE_NAME FROM USER_TABLES;