Create/Drop RMAN Catalog

Create a Catalog:

• Connect to the RMAN instance as sysdba
• SQL>Create user rcat identified by rcat;
• SQL>Grant connect,resource,recovery_catalog_owner to rcat;
• rman catalog rcat/rcat@rmanalias
• RMAN>create catalog;

Drop a Catalog:

• $ rman catalog rcat/rcat@rmanalias
• RMAN> drop catalog;
• Recovery catalog owner is RCAT
• Enter DROP CATALOG command again to confirm catalog removal
• RMAN> drop catalog;
• Recovery catalog dropped
• SQL>Drop user rcat cascade;