Sep 17, 2009

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;

No comments:

Post a Comment

Search This Blog