053-242

You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a
separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?
A. A base catalog exists
B. The recovery catalog is empty
C. The base recovery catalog must be dropped
D. A target database is registered in the recovery catalog

此题考点是 VPC 的创建。 VPC 可以让用户在一个基础恢复目录上对权限进行控制，只分配某些视图和同义词给虚拟恢复目录。
A 正确，在创建虚拟恢复目录之前必须有一个基础的恢复目录。
BC.D 错误，目录中可以有记录也可以没有，注册数据库并不是必须的，可以使用虚拟恢复之后再注册数据库。
创建 VPC 的步骤：
CREATE USER vpc1 IDENTIFIED BY password
DEFAULT TABLESPACE vpcusers
QUOTA UNLIMITED ON vpcusers;
GRANT recovery_catalog_owner TO vpc1;
RMAN> CONNECT CATALOG catowner@catdb
RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1;
RMAN> EXIT;
RMAN> CONNECT CATALOG vpc1@catdb
RMAN> CREATE VIRTUAL CATALOG;
如果是 10g 还需要运行下列过程：
SQL> CONNECT vpc1@catdb
SQL> BEGIN
catowner.DBMS_RCVCAT.CREATE_VIRTUAL_CATALOG;
END;
/