Oracle Database 11g: New Features for Administrators
Question No. 1
The following databases are registered in the base recovery catalog: PROD1 „ PROD2, and PROD3. The database user CAT OWNER 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?
Choose the correct option from the given list.
01 / 182