How would you grant the RVPC user access to specific RMAN database records in the
RMAN virtual private catalog?
A.
Issue the grant command from the SYS user (or equivalent) of the target database.
B.
Issue the grant command from the SYS user (or equivalent) of the recovery-catalog
database.
C.
Issue the grant command from the recovery catalog-owning schema user account in the
recovery catalog.
D.
Issue the grant command from RMAN when connected to the recovery catalog-owning
schema.
E.
Issue the grant command from RMAN when connected to the target database.
Correct Answer B.
Resource: http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta013.htm#RCMRF117
Example 2-57 Creating a Virtual Private Catalog
Assume that you created the recovery catalog and registered a database as shown in Example 2-56. Now you want to create a virtual private catalog for database user vpc1. You start SQL*Plus and connect to recovery catalog database catdb with administrator privileges. You create the vpc1 user and grant recovery catalog ownership as follows, replacing password with a user-specified password (see Oracle Database Security Guide for information on creating secure passwords):
SQL> CREATE USER vpc1 IDENTIFIED BY password
2 DEFAULT TABLESPACE vpcusers
3 QUOTA UNLIMITED ON vpcusers;
SQL> GRANT recovery_catalog_owner TO vpc1;
SQL> EXIT
You are using the wrong set of oracle documentation. See …
https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-053&p_org_id=&lang=
Better to use …
https://docs.oracle.com/cd/E11882_01/index.htm
even though this is for version 11.2.0.4 and not 11.2.0.1
I take that back. D is correct. Disregard previous comment.