欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

rman创建catalog过程及问题处理

程序员文章站 2022-05-22 15:54:28
...

rman环境下创建catalog库。在目标机上注册到catalog库时,出现如下错误信息:

背景说明:
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

rman创建catalog过程及问题处理