What is the outcome of the above commands?

You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database 11g database. The Prod1, Prod2 and Prod3 Oracle Database 10g databases are registered in the recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:

RMAN> GRANT CATALOG FOR DATABASE prod 1 prod 2 TO vpc1;

Then you issue the following commands;

RMAN > CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL EXEC catowner.dbms_rcvcat.create virtual_catalog;

What is the outcome of the above commands?

You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database 11g database. The Prod1, Prod2 and Prod3 Oracle Database 10g databases are registered in the recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:

RMAN> GRANT CATALOG FOR DATABASE prod 1 prod 2 TO vpc1;

Then you issue the following commands;

RMAN > CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL EXEC catowner.dbms_rcvcat.create virtual_catalog;

What is the outcome of the above commands?

A.
They execute and a create a virtual private catalog for pre-Oracle 11g clients

B.
They produce an error because PROD1 and PROD 2 databases belong to the older version

C.
They produce an error because you must connect as CATOWNER to execute this packaged procedure

D.
They produce an error because you must connect to the target database to execute this packaged procedure

Explanation:
http://download.oracle.com/docs/cd/B28359_01/backup.111/b28273/rcmsynta013.htm

Before using the virtual private catalog, this user must connect to the recovery catalog database as the virtual catalog owner and execute the following PL/SQL procedure (where base_catalog_owner is the database user who owns the base recovery catalog):

base_catalog_owner.DBMS_RCVCAT.CREATE_VIRTUAL_CATALOG



Leave a Reply 0

Your email address will not be published. Required fields are marked *