Prev Question
Next Question

Which option is best practice for creating a recovery catalog owner in the catalog database?

A.
Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner

B.
Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user

C.
Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this
tablespace to the user

D.
Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this
tablespace to the user

Explanation:
To create the recovery catalog schema in the recovery catalog database:
1. Start SQL*Plus and connect with administrator privileges to the database containing the recovery catalog. In
this example, the database is catdb.
2. Create a user and schema for the recovery catalog. For example, you could enter the following SQL
statement (replacing password with a user-defined password):
CREATE USER rman IDENTIFIED BY password
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE tools
QUOTA UNLIMITED ON tools;
3. Grant the RECOVERY_CATALOG_OWNER role to the schema owner. This role provides the user with all
privileges required to maintain and query the recovery catalog.
GRANT RECOVERY_CATALOG_OWNER TO rman;

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *