[原]配置RMAN恢復目錄應注意兼容性

      近日打算對災備的Oracle備份進行優化，其中一項就是引入恢復目錄（Recover Catalog）進行管理，但是在測試過程中遇到了一個問題，記錄如下：

      創建恢復目錄所需要的表空間、相應的用戶并賦予相應的權限：

create tablespace rman
datafile 
  '/u02/oradata/mydb/rman01.dbf' size 50M autoextend on
logging
segment space management auto
extent management local;

create user rman
identified by rman
default tablespace rman;
alter user rman quota unlimited on rman;

grant connect to rman;
grant resource to rman;
grant create any view to rman;
grant recovery_catalog_owner to rman;
revoke unlimited tablespace from rman;

      在注冊target為Oracle 11g（11.2.0.2）的數據庫時出現了錯誤。

[oracle@test01 admin]$ rman target / catalog rman/rman@catalog  

Recovery Manager: Release 11.2.0.2.0 - Production on Tue Jan 18 10:29:33 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1263384177)
connected to recovery catalog database

RMAN> create catalog ; 

recovery catalog created

RMAN> register database ; 


      
      
      
      


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of register command on default channel at 01/18/2011 10:36:40
RMAN-10015: error compiling PL/SQL program
RMAN-10033: error during compilation of job step 1: ORA-04023: Object RMAN.DBMS_RCVCAT could not be validated or authorized

      經查證是RMAN的各組件之間的兼容性所導致的問題，下表轉自：http://download.oracle.com/docs/cd/E11882_01/backup.112/e10643/compat003.htm#i634479

Table B-2 RMAN Compatibility Table

      作為catalog的數據庫版本是10.2.0.1，這就是問題所在。