創(chuàng)建恢復(fù)目錄
1、在目錄數(shù)據(jù)庫中創(chuàng)建恢復(fù)目錄所用表空間
SQL> create tablespace rman_ts datafile 'c:\oracle\oradata\cc\rmants.ora' size 20M ;
表空間已創(chuàng)建。

2、在目錄數(shù)據(jù)庫中創(chuàng)建RMAN 用戶并授權(quán)
SQL> create user rman identified by rman default tablespace rman_ts temporary tablespace temp
quota unlimited on rmants;
用戶已創(chuàng)建

SQL> grant recovery_catalog_owner,resource to rman;

Grant succeeded.

3、在目錄數(shù)據(jù)庫中創(chuàng)建恢復(fù)目錄
[oracle@node1 ~]$ rman catalog  rman/rman@ping

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jan 7 09:52:13 2009

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

connected to recovery catalog database

RMAN> create catalog tablespace rman_ts;

recovery catalog created

4、注冊目標(biāo)數(shù)據(jù)庫到恢復(fù)目錄
目標(biāo)數(shù)據(jù)庫:racdb
恢復(fù)目錄：ping

[oracle@node1 ~]$ rman target  sys/1@racdb

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jan 7 10:05:50 2009

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

connected to target database: RACDB (DBID=672464192)

RMAN> connect catalog  rman/rman@ping

connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

二、取消數(shù)據(jù)庫的注冊
1．在SQLPLUS使用RMAN用戶登錄恢復(fù)目錄

[oracle@node1 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 7 10:50:06 2009

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

SQL> conn  rman/rman@ping 
Connected.

2．查找表DB 中的注冊記錄
[oracle@node1 ~]$ rman target  sys/1@racdb

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jan 7 10:49:03 2009

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

connected to target database: RACDB (DBID=672464192)

RMAN>

SQL> select db_key,db_id from db;

    DB_KEY      DB_ID
---------- ----------
         1  672464192

DBID=DB.DB_ID
## 切記一定要使用RMAN的用戶登陸，不然將出現(xiàn)如下錯誤提示

SQL> conn  sys/sys@ping as sysdba
Connected.
SQL> select db_key,db_id from db;
select db_key,db_id from db
                         *
ERROR at line 1:
ORA-00942: table or view does not exist

3．注銷數(shù)據(jù)庫
SQL> execute dbms_rcvcat.unregisterdatabase(1,672464192);

PL/SQL procedure successfully completed.

4．驗證注銷動作
[oracle@node1 ~]$ rman

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jan 7 11:02:16 2009

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

RMAN> list backup;

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 01/07/2009 11:02:21
RMAN-06171: not connected to target database

RMAN>

我們注重客戶提出的每個要求，我們充分考慮每一個細(xì)節(jié)，我們積極的做好網(wǎng)站建設(shè)、成都網(wǎng)站設(shè)計服務(wù)，我們努力開拓更好的視野，通過不懈的努力，創(chuàng)新互聯(lián)公司贏得了業(yè)內(nèi)的良好聲譽，這一切，也不斷的激勵著我們更好的服務(wù)客戶。 主要業(yè)務(wù)：網(wǎng)站建設(shè),網(wǎng)站制作,網(wǎng)站設(shè)計,小程序開發(fā),網(wǎng)站開發(fā),技術(shù)開發(fā)實力，DIV+CSS，PHP及ASP，ASP.Net，SQL數(shù)據(jù)庫的技術(shù)開發(fā)工程師。