Oracle 10g使用RMAN恢復目錄筆記

Oracle 10g使用RMAN恢復目錄筆記

因是測試環境，RMAN Catalog資料庫與主資料庫使用的是同一個資料庫，正式生產環境建議分開。

建立恢復目錄表空間

SQL> create tablespace catalog

  2  datafile '.../catalog_01.dbf'

  3      size 100M autoextend on next 10M maxsize 1000M

  4  extent management local segment space management auto;

建立恢復目錄使用者

SQL> create user rman identified by rman default tablespace catalog;

為恢復目錄使用者授權

SQL> grant connect,resource,recovery_catalog_owner to rman;

建立恢復目錄模式物件

[oracle@RHEL5 ~]$ rman catalog rman/rman

Recovery Manager: Release 10.2.0.4.0 - Production on Thu Aug 18 15:06:53 2011

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

connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

在恢復目錄中註冊資料庫

[oracle@RHEL5 ~]$ rman target / catalog rman/rman

Recovery Manager: Release 10.2.0.4.0 - Production on Thu Aug 18 15:09:08 2011

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

connected to target database: ORCL (DBID=1275712672)

connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

RMAN> report schema;

Report of database schema

List of Permanent Datafiles

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

File Size(MB) Tablespace     RB segs Datafile Name

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

1    520      SYSTEM         YES     .../system01.dbf

2    470      UNDOTBS1       YES     .../undotbs01.dbf

3    460      SYSAUX         NO      .../sysaux01.dbf

4    2000     USERS          NO      .../users_01.dbf

5    100      FDA_DATA       NO      .../fda_data_01.dbf

6    200      ORATEXT        NO      .../oratext01.dbf

7    100      FDA_DATA       NO      .../fda_data_02.dbf

8    100      FDA_IDX        NO      .../fda_idx_01.dbf

9    100      FDA_IDX        NO      .../fda_idx_02.dbf

10   1373     USERS          NO      .../users_02.dbf

11   1393     USERS          NO      .../users_03.dbf

12   1394     USERS          NO      .../users_04.dbf

13   1052     USERS          NO      .../users_05.dbf

14   1033     USERS          NO      .../users_06.dbf

15   100      CATALOG        NO      .../catalog_01.dbf

List of Temporary Files

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

File Size(MB) Tablespace     Maxsize(MB) Tempfile Name

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

1    20       TEMP           32767       .../temp01.dbf

在恢復目錄中取消資料庫註冊

Unregister database;  連線到目標資料庫和恢復目錄

Unregister database ;  目標資料庫已經刪除

如果在恢復目錄中有多個以相同名稱註冊的目標資料庫：

Run

{

    Set dbid <要取消資料庫的DBID>

    Unregister database noprompt;

}