Chinaunix首页 | 论坛 | 博客
  • 博客访问: 396637
  • 博文数量: 88
  • 博客积分: 10
  • 博客等级: 民兵
  • 技术积分: 1054
  • 用 户 组: 普通用户
  • 注册时间: 2012-11-07 12:23
文章分类
文章存档

2014年(88)

我的朋友

分类: Oracle

2014-06-17 14:31:10

今天把主库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
显示正常了。
阅读(1281) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~