RMAN配置示例

1. 建立catalog資料庫：

在dbca中使用new database資料庫進行建立，不使用現有模板，不需任何SQL附加產品選項。設定了較大的large pool。

2. 作業系統的設定：

建立作業系統使用者rman，將其primary goup設為DBA。並對其.profile檔案做如下修改：

ORACLE_SID=catalog

ORACLE_HOME=/oracle/app/oracle/product/9.2.0.1.0

ORACLE_BASE=/oracle/app/oracle

PATH=$PATH:/oracle/bin:$ORACLE_HOME/bin

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

#DISPLAY=local:0

DISPLAY=10.250.4.87:0.0

export ORACLE_SID ORACLE_HOME ORACLE_BASE PATH LD_LIBRARY_PATH DISPLAY

NLS_LANG=AMERICAN

NLS_DATE_FORMAT="MON DD YYYY HH24:MI:SS"

export NLS_LANG NLS_DATE_FORMAT

3. 在新建立的資料庫上的操作：

1) 建立表空間ts_rman；

2) 建立使用者rman，指定其預設表空間為ts_rman；

3) 為使用者授權：grant connect,resource,RECOVERY_CATALOG_OWNER to rman;

4. 在catalog資料庫中建立恢復目錄catalog：

$ rman catalog rman/rman

Recovery Manager: Release 9.2.0.1.0 - Production

connected to recovery catalog database

recovery catalog is not installed

RMAN> create catalog tablespace ts_rman;

recovery catalog created

RMAN> exit

Recovery Manager complete.

5. 在catalog中註冊需要備份恢復的資料庫(ora)：

$ rman target sys/sys@ora

Recovery Manager: Release 9.2.0.1.0 - Production

connected to target database: ORA (DBID=1147939807)

RMAN> connect catalog rman/rman@catalog

connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

RMAN> exit

Recovery Manager complete.

至此，RMAN的配置就完全結束了，可以對目標資料庫進行利用RMAN的備份以及恢復了。

6. 進行RMAN的測試：

$ rman target sys/sys@ora

Recovery Manager: Release 9.2.0.1.0 - Production

connected to target database: ORA (DBID=1147939807)

RMAN> connect catalog rman/rman@catalog

connected to recovery catalog database

RMAN> run {

allocate channel c1 type disk;

backup current controlfile;

}

allocated channel: c1

channel c1: sid=15 devtype=DISK

Starting backup at 25-JUN-04

channel c1: starting full datafile backupset

channel c1: specifying datafile(s) in backupset

including current controlfile in backupset

channel c1: starting piece 1 at 25-JUN-04

channel c1: finished piece 1 at 25-JUN-04

piece handle=/oracle/app/oracle/product/9.2.0.1.0/dbs/01fp7orm_1_1 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:01

Finished backup at 25-JUN-04

released channel: c1

RMAN> list backup;

List of Backup Sets

===================

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

21 Full 1M DISK 00:00:00 25-JUN-04

BP Key: 22 Status: AVAILABLE Tag: TAG20040625T184158

Piece Name: /oracle/app/oracle/product/9.2.0.1.0/dbs/01fp7orm_1_1

Controlfile Included: Ckp SCN: 623816 Ckp time: 25-JUN-04

RMAN>

測試成功，可以進行進一步的rman的備份恢復了。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/241379/viewspace-564949/，如需轉載，請註明出處，否則將追究法律責任。

RMAN配置示例

相關文章