原創(chuàng)作品，允許轉(zhuǎn)載，轉(zhuǎn)載時請務(wù)必以超鏈接形式標明文章 原始出處 、作者信息和本聲明。否則將追究法律責任。http://407882.blog.51cto.com/397882/212142?

我想建立一個RMAN備份機制，本機為目標數(shù)據(jù)庫，sid為orcl10的數(shù)據(jù)庫為恢復目錄來做備份，但總不成功，以下是我的執(zhí)行步驟：

SQL> conn sys/e2000jl@orcl10 as sysdba
Connected.
SQL> create user rman
2 identified by rman123; User created. SQL> grant dba to rman; Grant succeeded. C:\Documents and Settings\zouyang>rman target sys/system catalog rman/rman123@orcl10 Recovery Manager: Release 10.1.0.2.0 - Production Copyright (c) 1995, 2004, Oracle. All rights reserved. connected to target database: ORCL (DBID=1227672490)
connected to recovery catalog database
recovery catalog is not installed RMAN> show channel for device type disk; recovery catalog is not installed
recovery catalog is not installed
RMAN-00571: ===============================================
RMAN-00569: =========ERROR MESSAGE STACK FOLLOWS ========
RMAN-00571: ===============================================
RMAN-03002: failure of show command at 10/14/2009 09:30:02
RMAN-06429: RCVCAT database is not compatible with this version of RMAN RMAN> 可以連接上恢復目錄數(shù)據(jù)庫，但是無法使用這個恢復目錄，Oracle報錯“recovery catalog is not installed”。 在網(wǎng)上搜了下，重新建立步驟如下： 第一步：Create Recovery Catalog First create a user to hold the recovery catalog: -- Create tablepsace to hold repository SQL> create tablespace rman_tools
2 datafile 3 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL10\rman01.dbf' 4 size 100m; Tablespace created -- Create rman schema owner SQL> create user rman
2 identified by rman123
3 default tablespace rman_tools
4 quota unlimited on rman_tools; User created C:\Documents and Settings\zouyang>rman catalog rman/rman123@orcl10 Recovery Manager: Release 10.1.0.2.0 - Production Copyright (c) 1995, 2004, Oracle. All rights reserved. RMAN-00571: ===============================================
RMAN-00569: ====== ERROR MESSAGE STACK FOLLOWS ==========
RMAN-00571: ===============================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-01045: user RMAN lacks CREATE SESSION privilege; logon denied -- 報錯！要給rman用戶分配一定的權(quán)限！ SQL> grant connect,resource,create session,recovery_catalog_owner
2 to rman; Grant succeeded C:\Documents and Settings\zouyang>rman catalog rman/rman123@orcl10 Recovery Manager: Release 10.1.0.2.0 - Production Copyright (c) 1995, 2004, Oracle. All rights reserved. connected to recovery catalog database
recovery catalog is not installed RMAN> create catalog tablespace rman_tools; recovery catalog created ——很好！！建立了！！ 可是，當我重新連接，顯示RMAN設(shè)置信息時又報錯了！！ C:\Documents and Settings\zouyang>rman target sys/system catalog rman/rman123@orcl10 Recovery Manager: Release 10.1.0.2.0 - Production Copyright (c) 1995, 2004, Oracle. All rights reserved. connected to target database: ORCL (DBID=1227672490)
connected to recovery catalog database RMAN> show channel for device type disk; RMAN configuration parameters are:
RMAN-00571: ===============================================
RMAN-00569: ========= ERROR MESSAGE STACK FOLLOWS =======
RMAN-00571: ===============================================
RMAN-03002: failure of show command at 10/14/2009 10:32:36
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog RMAN> 又在網(wǎng)上查找原因，原來還需要注冊數(shù)據(jù)庫！！ 第二步：Register Database Each database to be backed up by RMAN must be registered！
RMAN> register database; database registered in recovery catalog
starting full resync of recovery catalog
full resync complete RMAN> show channel for device type disk; RMAN configuration parameters are:CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'D:\BACKUP\RMAN\%d_%s.bak'; RMAN> 成功啦！！！

轉(zhuǎn)載于:https://www.cnblogs.com/weixun/archive/2013/06/13/3134731.html

總結(jié)

以上是生活随笔為你收集整理的（RMAN）使用恢复目录数据库执行RMAN步骤的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。