Step By Step - RMAN Virtual Private Catalog ( VPC ) Oracle Database 11g New Feature

Follow these steps to create virtual private catalog on RMAN.

1. Create a Recovery Catalog at RCDB database. [DB Server 3].

•     SQL> create tablespace vpc_ts datafile 'C:\vpc_ts01.dbf' size 100m ;   
      SQL> create user vpc_owner identified by vpc default tablespace vpc_ts quota unlimited  on vpc_ts;  
      SQL> grant recovery_catalog_owner to vpc_owner; C:\rman catalog vpc_owner/vpc   
      RMAN> create catalog; RMAN> exit;  

2. Now we need to create two more database user on [DB Server 3] which will act as virtual user for [DB Server 2] and [DB Server 1]

•     SQL> create user vpc_orcl identified by orcl default tablespace vpc_ts quota unlimited on vpc_ts;   
      SQL> create user vpc_NewDB identified by NewDB default tablespace vpc_ts quota unlimited on vpc_ts;  
      SQL> grant recovery_catalog_owner to vpc_NewDB, vpc_orcl;  

3. Now register both NewDB and orcl to the recovery catalog using user vpc_owner.[DB Server 3] Make sure you have net service name configure on [DB Server 3] to connect to [DB Server 2] and [DB Server 1]

•    C:\ rman catalog vpc_owner/vpc target sys/admin@orcl   
     RMAN> register database;   
     RMAN> exit;  
     C:\ rman catalog vpc_owner/vpc target sys/admin@ NewDB   
     RMAN> register database;   
     RMAN> exit;  

4. Now we need to grant privileges to vpc_orcl and vpc_NewDB to accesss RMAN metadata stores on RCDB from vpc_owner [DB Server 3].

•     C:\ rman catalog vpc_owner/vpc 
      RMAN> grant catalog for database orcl to vpc_orcl; 
      RMAN> exit;
      C:\ rman catalog vpc_owner/vpc target sys/admin@ NewDB 
      RMAN> register database; 
      RMAN> exit;  

5. Now we need to connect our target database with the newly created users and create virtual catalog so that they can only access RMAN metadata stored on RCDB for there respective databases only. E.g vpc_orcl cannot view matadata of NewDB database and vice-versa.[DB Server 3]

•     C:\ rman catalog vpc_orcl/orcl@orcl <--- orcl is net service name.   
      RMAN> create virual catalog;  
      RMAN> exit;  
      C:\ rman catalog vpc_NewDB/newdb@ newdb <--- NewDB is net service name.  
      RMAN> create virual catalog;   
      RMAN> exit;