当前环境两台机器RHEL5.5 都安装了oracle 11g，创建好数据库实例

hostname :sap 192.168.221.201 数据库实例名sap

hostname:catalog 192.168.221.202 数据库实例名catalog

clip_image001

在catalog机器上

创建rman 表空间

SQL> create tablespace rman datafile '/home/oracle/app/oracle/oradata/catalog/rman.dbf'

2 size 100m autoextend on;

Tablespace created.

创建用户

SQL> create user rman

2 identified by rman

3 default tablespace rman

4 quota unlimited on rman;

User created.

授权

SQL> grant recovery_catalog_owner to rman;

Grant succeeded.

创建恢复目录

[oracle@catalog admin]$ rman catalog rman/rman@catalog

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Mar 2 22:41:32 2014

connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

使用sap数据库连接catalog数据库

clip_image002

注册数据库

RMAN> register database

2> ;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

同步控制文件里面的备份信息到 catalog数据库

clip_image002[1]

创建完成

ITPub博客

RMAN备份创建catalog数据库