使用catalog database存储rman备份的元数据在生产环境中十分常见，且安全性高。可以将grid control的reponsitory database与cata
1. 场景描述；
catalog database 192.168.1.206:1521 grid
target database 192.168.1.201:1521 ql
2. 在catalog database上创建rman表空间
sql> create tablespace rman datafile '/u01/app/oracle/oradata/gird/rman.dbf' size 500m autoextend on next 100m maxsize unlimited;
tablespace created.
3. 在catalog database上创建rman用户
sql> create user rman identified by rman default tablespace rman quota 500m on rman;
user created.
4. 在catalog database上对rman用户赋予权限
sql> grant connect,resource to rman;
grant succeeded.
sql> grant recovery_catalog_owner to rman;
grant succeeded.
5. 在target database上修改tnsname.ora
[oracle@test admin]$ more tnsnames.ora
rman =
  (description =
    (address_list =
    (address = (protocol = tcp)(host = 192.168.1.206)(port = 1521))
  )
  (connect_data =
    (server = dedicated)
    (service_name = gird.57ql.com)
  )
)
6. 注册数据库
[oracle@test /]$ rman target / catalogrman/rman@rman;
recovery manager: release 11.2.0.3.0 - production on mon sep 3 16:12:41 2012
copyright (c) 1982, 2011, oracle and/or its affiliates.  all rights reserved.
connected to target database: ql (dbid=2286587371)
connected to recovery catalog database
rman> create catalog tablespace rman;
recovery catalog created
rman> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
7. 备份数据库
rman> backup database;
finished control file and spfile autobackup at 03-sep-12
rman> exit
8. 小结
使用catalog database存储rman备份的元数据在生产环境中十分常见，，且安全性高。可以将grid control的reponsitory database与catalog database整合在一起。