OCP考试第15题

15. You are in the process of creating a virtual private catalog in your Oracle Database 11g dcatabase.

11g 创建vpc

The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog.

P1,P2,P3 10g已经注册在base 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:

base owner CATOWNER ,赋权给vpc1.

RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 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?

执行命令EXEC catowner.dbms_rcvcat.create_virtual_catalog

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

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

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

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

 

 

知识点：

•     A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases.
  base 是一个schema 存放rman
      A virtual private catalog is a set of synonyms and views that enable user access to a subset of a base recovery catalog.
  vpc是同义词和视图 允许用户访问base

BASE：
GRANT recovery_catalog_owner TO catowner;
CONNECT CATALOG catowner@catdb
CREATE CATALOG;
REGISTER DATABASE;

VP：

GRANT recovery_catalog_owner TO vpc1;
CONNECT CATALOG catowner@catdb
GRANT CATALOG FOR DATABASE prod1 TO vpc1;
CONNECT CATALOG vpc1@catdb
CREATE VIRTUAL CATALOG;
CONNECT vpc1@catdb
BEGIN
catowner.DBMS_RCVCAT.CREATE_VIRTUAL_CATALOG;
END;
 /

 

答案：A