ORACLE之RMAN恢复目录
创建恢复目录
登录恢复目录数据库:
sqlplus system/oracle@catadb
创建用户rman_cata:
SQL> create user rman_cata identified by rman_cata;
给rman_cata授权:
SQL> grant connect, resource, recovery_catalog_owner to rman_cata;
创建恢复目录:
rman catalog rman_cata/rman_cata@catadb
RMAN> create catalog;
登录到rman_cata下查看有哪些表:
sqlplus rman_cata/rman_cata@catadb
SQL> select * from tab;
在新创建的恢复目录中注册目标数据库:
rman target / catalog rman_cata/rman_cata@catadb
RMAN> register databse;