What privileges must be granted to allow an account to create the recovery catalog?
(Choose all that apply.)
A.
RECOVERY_CATALOG_OWNER
B.
DBA
C.
RESOURCE
D.
SELECT ANY DICTIONARY
E.
CONNECT
What privileges must be granted to allow an account to create the recovery catalog?
(Choose all that apply.)
What privileges must be granted to allow an account to create the recovery catalog?
(Choose all that apply.)
A.
RECOVERY_CATALOG_OWNER
B.
DBA
C.
RESOURCE
D.
SELECT ANY DICTIONARY
E.
CONNECT
Answer is A (only)
Dont believe me, take a look at the documentation yourself…
https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcatdb.htm#BRADV89651
Here is another reliable source
http://www.dba-oracle.com/real_application_clusters_rac_grid/recovery_catalog.html
I agree.
The answer here is correct. A and C are both required.
If you only grant recovery_catalog_owner you will get an error message when creating the catalog in RMAN.
Try it by creating a user called rmanown and just grant the recovery_catalog_owner privilege.
SQL> create user rmanown identified by rmanown default tablespace rmancat;
SQL> grant recovery_catalog_owner to rmanown;
rman catalog rmanown/rmanown@catdb
RMAN> create catalog;
ORACLE error from recovery catalog database: ORA-01950: no privileges on tablespace ‘RMANCAT’
ORACLE error from recovery catalog database: ORA-00942: table or view does not exist
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06433: error installing recovery catalog
So the resource privilege is also required to create the catalog.