11g new Features-Virtual Private catalogs

In previous versions of Oracle 11g, if a user simply needed access to a database in recovery catalog, we could only authorize the entire recovery catalog to be restricted.

Now, virtual private Cataglog provides strict access control so that users can access only a subset of the databases in the catalog. Virtual Private Cataglog is also called virtual catalog. Virtual catalog can be created for one user or multiple users. At this point, the entire centralized catalog is called the base catalog.

Oracle recommends merging all of the catalog into a centralized base catalog, and then creating virtual catalog for different users. Virtual catalog does not exist as a separate entity, but rather as a set of column synonyms and views on the base catalog. The owner of the base catalog must authorize virtual catalog permissions to other users.

Create a virtual catalog

1. Create the owner of the virtual catalog

 as SYSDBA SQL default tablespace vp_users quota Unlimited on vp_users;

2. Authorization for new users

Sql> Grant Recovery_catalog_owner to virtual01;

3. Login to the Rman client with base recovery catalog user Authorization for virtual catalog user

$ rman Rman> Connect catalog rman11/[email protected]; RMAN> Grant Register database to VIRTUAL01; RMAN for database test1,test2 to virtual01;

Virtual catalog owner can only create local storage scripts and cannot create global scripts. But Vuirtual catalog owner is able to read global storage scripts only

4. Log in as virtual catalog owner to create Virtua Catalog

Rman> Connect Catalog virtual11/[email protected]rmanvirtual catalog;

11g new Features-Virtual Private catalogs