背景说明:
rman环境下创建catalog库。
出现问题:
在目标机上注册到catalog库时,出现如下错误信息:
RMAN> register database;
PL/SQL package RMAN.DBMS_RCVCAT version 10.02.00.00 in RCVCAT database is not current
PL/SQL package RMAN.DBMS_RCVMAN version 10.02.00.00 in RCVCAT database is not current
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 01/05/2013 15:50:52
RMAN-06004: Oracle error from recovery catalog database: ORA-06550: ? 1 ?, ? 2273 ?:
PLS-00302: ???? 'GETRANGEALBACKUP' ??
ORA-06550: ? 1 ?, ? 2238 ?:
PL/SQL: Statement ignored
ORA-06550: ? 1 ?, ? 2453 ?:
PLS-00302: ???? 'RESTORECMD_T' ??
ORA-06550: ? 1 ?, ? 2424 ?:
PL/SQL: Statement ignored
问题分析:
期初以为是我把之前的catalog库删除掉了,导致后续注销时需要的相关信息没有而导致报错。
于是寻求这方面的帮助。
但是搜索baidu令我很失望,搜索相应的关键字无法返回我想要的结果。于是我将同样的关键字用google来搜索。
结果出来了我想要的信息,不是我崇洋媚外,国外的技术真的要比我们先进太多了。
原来很简单,问题的关键不在于下面的提示上,而在于上面的提示:
PL/SQL package RMAN.DBMS_RCVCAT version 10.02.00.00 in RCVCAT database is not current
PL/SQL package RMAN.DBMS_RCVMAN version 10.02.00.00 in RCVCAT database is not current
原来是因为两边包版本不同的原因,导致在执行命令时报错了。解决的办法很简单,只要对catalog库升级即可:
[oracle@vmlinux ~]$ rman target / catalogrman/cat@catalog
Recovery Manager: Release 10.2.0.4.0 - Production on Sat Jan 5 15:59:47 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ORA10G (DBID=3976420220, not open)
connected to recovery catalog database
PL/SQL package RMAN.DBMS_RCVCAT version 10.02.00.00 in RCVCAT database is not current
PL/SQL package RMAN.DBMS_RCVMAN version 10.02.00.00 in RCVCAT database is not current
RMAN> upgrade catalog;
recovery catalog owner is RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade
对第一次执行的升级命令系统要做一次confirm,再执行一次后,方才有效(可从升级信息中看到版本的变化情况):
RMAN> upgrade catalog;
recovery catalog upgraded to version 10.02.00.04
DBMS_RCVMAN package upgraded to version 10.02.00.00
DBMS_RCVCAT package upgraded to version 10.02.00.00
再次注册catalog,成功:
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete