下面来演示下恢复目录的配置，其中jy为catalog数据库，test数据库为测试数据库
1.创建用户/表空间与授权（我这里使用users表空间没有新建表空间）
SQL> create user rman identified by "rman"
? 2? default tablespace users
? 3? temporary tablespace temp
? 4? quota unlimited on users;
User created.
SQL> grant recovery_catalog_owner to rman;
Grant succeeded.
SQL>? conn rman/rman
Connected.
SQL> select count (*) from user_objects;
? COUNT(*)
----------
? ? ? ? 0
2：创建恢复目录
[oracle@jingyong1 admin]$ rman catalog rman/rman@jy
Recovery Manager: Release 10.2.0.5.0 - Production on Sun Feb 1 21:22:31 2015
Copyright (c) 1982, 2007, Oracle.? All rights reserved.
connected to recovery catalog database
RMAN> create catalog;
recovery catalog created
SQL> conn rman/rman
Connected.
SQL> select count (*) from user_objects;
? COUNT(*)
----------
? ? ? 194
可以看出在rman用户下的对象个数为194个
3:增加tns服务名
[oracle@oracle11g admin]$ vi tnsnames.ora
jy =
? (DESCRIPTION =
? ? (ADDRESS_LIST =
? ? ? (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.56.11)(PORT = 1521))
? ? )
? ? (CONNECT_DATA =
? ? ? (SERVICE_NAME = jy)
? ? )
? )
?
4：注册目标数据库，同步catalog和控制文件
[oracle@oracle11g admin]$ rman target sys/zzh_2046@test catalog rman/rman@jy
Recovery Manager: Release 10.2.0.5.0 - Production on Sun Feb 1 21:25:25 2015
Copyright (c) 1982, 2007, Oracle.? All rights reserved.
connected to target database: TEST (DBID=2155613261)
connected to recovery catalog database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN> resync catalog;
starting full resync of recovery catalog
full resync complete
RMAN> list incarnation;
List of Database Incarnations
DB Key? Inc Key DB Name? DB ID? ? ? ? ? ? STATUS? Reset SCN? Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1? ? ? 10? ? ? TEST? ? 2155613261? ? ? PARENT? 1? ? ? ? ? 30-JUN-05
1? ? ? 11? ? ? TEST? ? 2155613261? ? ? PARENT? 446075? ? 05-SEP-14
1? ? ? 12? ? ? TEST? ? 2155613261? ? ? PARENT? 2849317? ? 27-JAN-15
1? ? ? 13? ? ? TEST? ? 2155613261? ? ? PARENT? 2880152? ? 27-JAN-15
1? ? ? 2? ? ? TEST? ? 2155613261? ? ? CURRENT 3017109? ? 01-FEB-15
--------------------------------------推荐阅读 --------------------------------------
--------------------------------------分割线 --------------------------------------