登录  
 加关注
查看详情
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

飞哥的技术博客

世上无难事,只怕有心人!

 
 
 

日志

 
 
 
 

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

2009-06-23 20:08:30|  分类: Oracle |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

 配置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

这次注册成功!!

  评论这张
 
阅读(1037)| 评论(0)

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2018