1、在目录数据库中创建恢复目录所用表空间
SQL> create tablespace ts_rman datafile '/u01/app/oracle/oradata/ORCL/datafile/ts_rman.dbf' size 150M;
2、在目录数据库中创建RMAN用户并授权
SQL>create user rman identified by rman default tablespacets_rman temporary tablespace temp quota unlimited on ts_rman;
SQL> grant recovery_catalog_owner to rman_user ;
SQL> grant connect, resource to rman_user ;
3、在目录数据库中创建恢复目录
SQL>rman catalog rman/rman@orcl
SQL>create catalog tablespace rmantbs
4、注册目标数据库到恢复目录
SQL>rman target / catalog rman/rman@orcl
RMAN>register database;
联系客服