Oracle OCP 1Z0-050（171-180题）解析

Oracle OCP 1Z0-050（171-180题）解析

QUESTION 171:

You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base 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 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?

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

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

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

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

Answer: B

解析：

以下是使用rman虚拟专用目录步骤：

1. 创建RMAN 基本目录：

RMAN> CONNECT CATALOG catowner/oracle@catdb

RMAN> CREATE CATALOG;

2. 将RECOVERY_CATALOG_OWNER授予给VPC 所有者：

SQL> CONNECT SYS/oracle@catdb AS SYSDBA

SQL> GRANT RECOVERY_CATALOG_OWNER to vpcowner;

3a.将REGISTER授予给VPC 所有者：

RMAN> CONNECT CATALOG catowner/oracle@catdb

RMAN> GRANT REGISTER DATABASE TO vpcowner;

3b.或将CATALOG FOR DATABASE授予给VPC 所有者：

RMAN>GRANT CATALOG FOR DATABASE db10g TO vpcowner;

4a.为11g客户机创建虚拟目录：

RMAN> CONNECT CATALOGvpcowner/oracle@catdb

RMAN> CREATE VIRTUAL CATALOG;

4b.或者为11g之前的客户机创建虚拟目录：

SQL> CONNECT vpcowner/oracle@catdb

SQL> exec catowner.dbms_rcvcat.create_virtual_catalog;

5. 在目录中注册新数据库：

RMAN> CONNECT TARGET / CATALOG vpcowner/oracle@catdb

RMAN> REGISTER DATABASE;

6. 使用虚拟目录：

RMAN> CONNECT TARGET / CATALOG vpcowner/oracle@catdb;

RMAN> BACKUP DATABASE;

可以为数据库组和用户组创建虚拟专用RMAN 目录。

1. 目录所有者将创建基本目录。

2. 目录数据库的DBA 可以创建拥有虚拟专用目录(VPC) 的用户，并授予其RECOVERY_CATALOG_OWNER权限。

3. 基本目录的所有者可为VPC 所有者授予访问先前注册的数据库的权限或授予REGISTER权限。GRANT&nbs