敗家貓

在做RMAN的練習時發生了以前沒遇過的問題，小記一下

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options                 
[oracle@c102 admin]$ rman target / catalog rman102/rman102@rman105                            

Recovery Manager: Release 11.1.0.6.0 - Production on Thu Jan 8 06:18:18 2009

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

connected to target database: O102 (DBID=1059897109)
connected to recovery catalog database              

RMAN> register database;

  LIBRARY HANDLE:0xb28ee90 bid=470 hid=c00a89d6 lmd=S pmd=S sta=VALD
  name=RMAN102.DBMS_RCVCAT                                          
  hash=58cc66d8884bcf19d62297bbc00a89d6 idn=0                       
  tim=01-07-2009 22:09:29  kkkk-dddd-llll=0000-0005-0005            
  exc=0 ivc=0 ldc=1 cbb=11 rpr=1 kdp=0 slc=1 dbg=0                  
  dmtx=0xb28ef28(0, 0, 0) mtx=0xb28ef60(0, 127, 0)                  
  nsp=TABL(01) typ=PCKG(09) flg=REM/KGHP/TIM/SML/[02020800]         
  lwt=0xb28ef08[0xb28ef08,0xb28ef08]                                
  pwt=0xb28eee8[0xb28eee8,0xb28eee8]                                
  ref=0xb28ef18[0xb28ef18,0xb28ef18]                                
    LOCK OWNERS:                                                    
        lock     user  session count mode       flags               
    -------- -------- -------- ----- ---- ------------------------  
     b290d68  b376290  b376290     1 S    CNB/PNC/[4003]            
    PIN OWNERS:                                                     
         pin     user  session     lock count mode mask             
    -------- -------- -------- -------- ----- ---- ----             
     b290c70  b376290  b376290  b290d68     1 S    0005             
    LIBRARY OBJECT: 0xb2907c0                                       
    flg=EXS/LOC[0005] pfl=/IVR[0200] ssta=VALD load=0               
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of register command on default channel at 01/08/2009 06:18:26
RMAN-10015: error compiling PL/SQL program                                       
RMAN-10033: error during compilation of job step 1: ORA-04023: Object RMAN102.DBMS_RCVCAT could not be validated or authorized

RMAN>  upgrade catalog;

recovery catalog owner is RMAN102
enter UPGRADE CATALOG command again to confirm catalog upgrade

RMAN>  upgrade catalog;

recovery catalog upgraded to version 11.01.00.06
DBMS_RCVMAN package upgraded to version 11.01.00.06
DBMS_RCVCAT package upgraded to version 11.01.00.06

RMAN> register database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of register command on default channel at 01/08/2009 06:20:08
RMAN-10015: error compiling PL/SQL program
RMAN-10033: error during compilation of job step 1: ORA-04028: cannot generate diana for object RMAN102.DBMS_RCVCAT

RMAN> reset database
2> ;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of reset command on default channel at 01/08/2009 06:21:43
RMAN-10015: error compiling PL/SQL program
RMAN-10033: error during compilation of job step 1: ORA-04028: cannot generate diana for object RMAN102.DBMS_RCVCAT

RMAN> exit


--------------------------------------------------------------------------------------------------------------
經查在做catalog時有一個要求，那就是catalog的版本要高於target的版本。而我剛catalog db是10G，而target 是11G。所以就遇到這個問題了