博客

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

创建 catalog 所有者用户必须给予必要的权限，使用另外的表空间来存放 catalog 恢复目录。

例如：

使用 sys 用户登录恢复目录数据库

CREATE USER rman IDENTIFIED BY password

TEMPORARY TABLESPACE temp

DEFAULT TABLESPACE tools

QUOTA UNLIMITED ON tools;

然后赋予必要的权限：

GRANT RECOVERY_CATALOG_OWNER TO rman;