1.在catalog数据库上创建cat用户的表空间 sql create tablespace cat datafile 'datadg/orcl/datafile/cat.dbf' size 512m; 2.创建cat用户 sql create user cat identified by cat temporary tablespace temp default tablespace cat quota unlimited on cat
1.在catalog数据库上创建cat用户的表空间
sql> create tablespace cat datafile '+datadg/orcl/datafile/cat.dbf' size 512m;
2.创建cat用户
sql> create user cat identified by cat temporary tablespace temp default tablespace cat quota unlimited on cat;
3.授权给cat用户
sql> grant connect,resource to cat;
sql> grant recovery_catalog_owner to cat;
4. 连接到catalog数据库
[oracle@orcl admin]$ rman catalog cat/cat@orcl
5.创建恢复目录
rman> create catalog;
6. 在catalog中注册target数据库
[oracle@orcl admin]$ rman catalog cat/cat@orcl target sys/oracle@python;
rman> register database;
------------------------------------------------------------------------------------------------
7.注销target数据库
[oracle@orcl admin]$ rman catalog cat/cat@orcl target sys/oracle@python;
rman> unregister database;
或
为了能注销数据库，需要获得数据库的标识码（db_id）和数据库键值（db_key）。其中连接目标数据库时将会获得db_id
连接到目标数据库，查询db表：
sql> select * from db;
db_key db_id curr_dbinc_key
---------- ---------- --------------
1 3021445076 2
sql> execute dbms_rcvcat.unregisterdatabase(1,3021445076);
from:http://www.linuxidc.com/linux/2013-02/79856.htm