配置catalog数据库出现的错误:RMAN-06433

 今天在配置catalog数据库的时候,出现下面的问题:
Recovery Manager: Release 10.2.0.1.0 - Production on Sun Dec 7 19:24:57 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: GE (DBID=1385239465)
connected to recovery catalog database

RMAN> create catalog;
ORACLE error from recovery catalog database: ORA-00955: name is already used by an existing object

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06433: error installing recovery catalog

RMAN> register database;
ORACLE error from recovery catalog database: ORA-04067: not executed, package body "RMAN.DBMS_RCVCAT" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "RMAN.DBMS_RCVCAT"

ORACLE error from recovery catalog database: ORA-04067: not executed, package body "RMAN.DBMS_RCVCAT" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "RMAN.DBMS_RCVCAT"

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 12/07/2008 19:28:41
RMAN-06429: RCVCAT database is not compatible with this version of RMAN

解决过程:
1、在catalog数据库的rman用户,重新新建
   drop user rman  cascade;
    create user rman identified  by rman default tablespace ts_rman  TEMPORARY TABLESPACE temp;
2、重新注册:
--删除之前的注册信息
 RMAN> drop catalog;
recovery catalog owner is RMAN
enter DROP CATALOG command again to confirm catalog removal
--新建新的CATALOG用户的表
[oracle@localhost ~]$ rman target sys/test@GE catalog  rman/rman@CATA
Recovery Manager: Release 10.2.0.1.0 - Production on Sun Dec 7 20:15:50 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: GE (DBID=1385239465)
connected to recovery catalog database

RMAN> create catalog tablespace ts_rman;
recovery catalog created

--注册目标数据库
RMAN> register database;
database registered in recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03008: error while performing automatic resync of recovery catalog
ORA-06502: PL/SQL: numeric or value error

--尝试重新注册目标数据库
[oracle@localhost ~]$ rman  catalog  rman/rman@CATA
Recovery Manager: Release 10.2.0.1.0 - Production on Sun Dec 7 20:31:59 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to recovery catalog database
RMAN> drop catalog;
recovery catalog owner is RMAN
enter DROP CATALOG command again to confirm catalog removal

RMAN> create catalog;
recovery catalog already exists

RMAN> exit
Recovery Manager complete.
[oracle@localhost ~]$ rman target sys/test@GE catalog  rman/rman@CATA

Recovery Manager: Release 10.2.0.1.0 - Production on Sun Dec 7 20:32:41 2008

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

connected to target database: GE (DBID=1385239465)
connected to recovery catalog database
RMAN> register database;

starting full resync of recovery catalog
full resync complete
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of register command on default channel at 12/07/2008 20:32:59
RMAN-20002: target database already registered in recovery catalog

报RMAN-20002错误,说目标数据库已经注册到recovery catalog

 

下面继续重新注册:
[oracle@localhost ~]$ rman target sys/test@GE catalog  rman/rman@CATA
Recovery Manager: Release 10.2.0.1.0 - Production on Sun Dec 7 20:37:02 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved
connected to target database: GE (DBID=1385239465)
connected to recovery catalog database

RMAN> drop catalog;
recovery catalog owner is RMAN
enter DROP CATALOG command again to confirm catalog removal

RMAN> drop catalog;
recovery catalog dropped

RMAN> exit

Recovery Manager complete.
[oracle@localhost ~]$ rman target sys/test@GE catalog  rman/rman@CATA
Recovery Manager: Release 10.2.0.1.0 - Production on Sun Dec 7 20:37:58 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: GE (DBID=1385239465)
connected to recovery catalog database

RMAN> create catalog;
recovery catalog created

RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

这次注册成功!!

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值