ITPub博客

首页 > 数据库 > Oracle > rman catalog 问题:DBMS_RCVCAT version导致注册catalog失败

rman catalog 问题:DBMS_RCVCAT version导致注册catalog失败

Oracle 作者:jianghaifuyun1987 时间:2014-03-21 14:50:49 0 删除 编辑
今天把主库PROD升级到了10.2.0.3.0,catalog的库还是保持10.2.0.1.0不变
然后在注册的时候报了如下错误。
export ORACLE_SID=PROD
[oracle@oel1 PROD]$ rman target / catalog rcuser/oracle@EMREP
Recovery Manager: Release 10.2.0.3.0 - Production on Wed Oct 31 17:47:51 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: PROD (DBID=209955415)
connected to recovery catalog database
PL/SQL package RCUSER.DBMS_RCVCAT version 10.02.00.00 in RCVCAT database is not current
PL/SQL package RCUSER.DBMS_RCVMAN version 10.02.00.00 in RCVCAT database is not current
RMAN> show all;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 10/31/2012 17:47:42
RMAN-06004: ORACLE error from recovery catalog database: ORA-06550: line 1, column 2273:
PLS-00302: component 'GETRANGEALBACKUP' must be declared
ORA-06550: line 1, column 2238:
PL/SQL: Statement ignored
ORA-06550: line 1, column 2453:
PLS-00302: component 'RESTORECMD_T' must be declared
ORA-06550: line 1, column 2424:
PL/SQL: Statement ignored
需要来升级catalog
RMAN> upgrade catalog;
recovery catalog owner is RCUSER
enter UPGRADE CATALOG command again to confirm catalog upgrade
RMAN> upgrade catalog;
recovery catalog upgraded to version 10.02.00.03
DBMS_RCVMAN package upgraded to version 10.02.00.00
DBMS_RCVCAT package upgraded to version 10.02.00.00

[oracle@oel1 PROD]$ rman target / catalog rcuser/oracle@EMREP
Recovery Manager: Release 10.2.0.3.0 - Production on Wed Oct 31 17:52:10 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: PROD (DBID=209955415)
connected to recovery catalog database
RMAN> show all;
starting full resync of recovery catalog
full resync complete
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default
显示正常了。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14300593/viewspace-1126703/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-03-07

  • 博文量
    75
  • 访问量
    74637