在Oracle中,如何创建RMAN恢复目录?
A 答案如下所示:
首先,创建一个数据库用户,一般都是RMAN,并给予RECOVERY_CATALOG_OWNER角色权限:
sqlplus / as sysdba
SQL> CREATE USER RMAN IDENTIFIED BY RMAN;
SQL> ALTER USER RMAN DEFAULT TABLESPACE TOOLS TEMPORARY TABLESPACE TEMP;
SQL> ALTER USER RMAN QUOTA UNLIMITED ON TOOLS;
SQL> GRANT CONNECT, RESOURCE, RECOVERY_CATALOG_OWNER TO RMAN;
然后,用这个用户登录,创建恢复目录:
rman catalog rman/rman
RMAN> CREATE CATALOG TABLESPACE TOOLS;
最后就可以在恢复目录注册目标数据库了:
rman catalog rman/rman target backdba/backdba
RMAN> REGISTER DATABASE;