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資料庫

建立完成