rman创建恢复目录

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 tablespace ts_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;