300.The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3.
The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have
access to only the PROD1 database and create a virtual private catalog.
Given below are some of the commands required to achieve this:
1.SQL> GRANT recovery_catalog_owner TO vpc1;
2.RMAN> CONNECT CATALOG vpc1/password@catdb;
3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1;
4.RMAN> CONNECT CATALOG catowner/password@catdb;
5.RMAN> CREATE VIRTUAL CATALOG;
What is the correct sequence in which the commands have to be executed?
A. 1, 4, 5, 2, 3
B. 1, 4, 3, 2, 5
C. 4, 5, 2, 3, 1
D. 2, 3, 4, 5, 1
E. 1, 4, 2, 3, 5
Answer: B
答案解析:
参考:http://blog.iyunv.com/rlhua/article/details/13169205
这道题考创建虚拟专用目录以及授权限制VPC1用户只能访问PROD1
步骤如下:
以下是使用rman虚拟专用目录步骤:1. 创建RMAN 基本目录:RMAN> CONNECT CATALOG catowner/oracle@catdbRMAN> CREATE CATALOG;2. 将RECOVERY_CATALOG_OWNER授予给VPC 所有者:SQL> CONNECT SYS/oracle@catdb AS SYSDBASQL> GRANT RECOVERY_CATALOG_OWNER to vpcowner;3a.将REGISTER授予给VPC 所有者:RMAN> CONNECT CATALOG catowner/oracle@catdbRMAN> GRANT REGISTER DATABASE TO vpcowner;3b.或将CATALOG FOR DATABASE授予给VPC 所有者:RMAN>GRANT CATALOG FOR DATABASE db10g TO vpcowner;