Oracle10g配置RMANRECOVERYCATALOG

Oracle的RMAN配置信息默認存放在target數據庫的控制文件中，當然也可以配置一個recovery catalog服務器來存儲這些信息，下面是控

Oracle的RMAN配置信息默認存放在target數據庫的控制文件中，當然也可以配置一個recovery catalog服務器來存儲這些信息，下面是控制文件和恢復的特性比較，，一般來說維護10臺以下的oracle數據庫備份，可以不需要配置恢復目錄.

Control file:
– Simpler administration
– Default

Recovery catalog:
– Replicates control file data
– Has room for more data
– Can service many targets
– Can store RMAN scripts

RMAN repository data is always stored in the control file of the target database. But it can also be stored in a separate database, called a recovery catalog.

A recovery catalog preserves backup information in a separate database, which is useful in the event of a lost control file. This allows you to store a longer history of backups than what is possible with a control file–based repository. A single recovery catalog is able to store information for multiple target databases. The recovery catalog can also hold RMAN stored scripts, which are sequences of RMAN commands for common backup tasks. Centralized storage of scripts in the recovery catalog can be more convenient than working with command files.

Usage of a separate recovery catalog database is not recommended for small installations where administration of a separate recovery catalog database would be burdensome

下面來演示下恢復目錄的配置，其中ora10g為catalog數據庫，target數據庫為orac

1:創建用戶和表空間并授權

SQL> CREATE TABLESPACE rman DATAFILE '/u01/app/oradata/rman01.dbf'
2 SIZE 500M AUTOEXTEND ON NEXT 20M MAXSIZE 2G EXTENT MANAGEMENT LOCAL;

Tablespace created.

SQL> CREATE USER RMAN IDENTIFIED BY rman
2 TEMPORARY TABLESPACE temp
3 DEFAULT TABLESPACE rman
4 QUOTA UNLIMITED ON rman;

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@ora10g ~]$ rman catalog rman/rman@ora10g

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Mar 16 09:58:16 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to recovery catalog database

RMAN> CREATE CATALOG;

recovery catalog created

SQL> select count (*) from user_objects; //可以看出在rman表空間下的對象個數為195個

COUNT(*)
----------
195

3：連接,注冊目標數據庫，同步catalog和控制文件

[oracle@orac ~]$ rman target sys/123456@orac catalog rman/rman@ora10g

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Mar 16 10:14:10 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORAC (DBID=1010679485)
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 8 ORAC 1010679485 PARENT 1 22-OCT-05
1 2 ORAC 1010679485 CURRENT 525876 15-FEB-11

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com