Oracle OCP 1Z0-053 Q300(Create Virtual Catalog)
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
创建Virtual Catalog步骤：
1. 在catalog DB创建用户并授权
2. 使用virtual catalog用户在rman下连接，create virtual catalog
参考：http://blog.csdn.net/rlhua/article/details/13274825
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
创建Virtual Catalog步骤：
1. 在catalog DB创建用户并授权
2. 使用virtual catalog用户在rman下连接，create virtual catalog
参考：http://blog.csdn.net/rlhua/article/details/13274825
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2072382/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
