RMAN备份 创建catalog数据库

 

 

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

hostname :sap 192.168.221.201 数据库实例名sap

hostname:catalog 192.168.221.202 数据库实例名catalog

 

 

在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

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to recovery catalog database

 

 

RMAN> create catalog;

recovery catalog created

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

 

 

注册数据库

RMAN> register database

2> ;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

 

 

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

创建完成

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27771627/viewspace-1247187/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27771627/viewspace-1247187/