register database---ORA-04062


(1):bug:

RMAN> register  database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of register command on default channel at 07/21/2010 10:15:50
ORA-04062: timestamp of package "RMAN.DBMS_RCVCAT" has been changed

(2):出现原因

在创建catalog用户前忘记了查看系统中是否有rman 这个用户的:
SQL> select username from  dba_users;-----没有执行(疏忽的)
就直接又建立了次,然后在使用rman用户的时候

[oracle@oracle-bak ~]$ rman   target   'vtdb'  catalog  rman/rman

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jul 21 10:11:44 2010

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

target database Password: 
connected to target database: VTDB (DBID=1059666644)
connected to recovery catalog database

RMAN> create  catalog  tablespace  rman_bak;

recovery catalog already exists

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 07/21/2010 10:13:11
RMAN-20002: target database already registered in recovery catalog

RMAN> drop  catalog;    

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

RMAN> drop  catalog;

recovery catalog dropped

RMAN> create  catalog   tablespace  rman_bak;

recovery catalog created

RMAN> register  database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of register command on default channel at 07/21/2010 10:15:50
ORA-04062: timestamp of package "RMAN.DBMS_RCVCAT" has been changed----问题出现咯,是不是刚才drop掉后,没有退出session的问题,故
RMAN> quit


Recovery Manager complete.
[oracle@oracle-bak ~]$ rman   target   'vtdb'  catalog  rman/rman

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jul 21 10:22:11 2010

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

target database Password: 
connected to target database: VTDB (DBID=1059666644)
connected to recovery catalog database

RMAN> register  database;    ---OK了

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN> 


(3):原因--应该是那个session 占有了某些资源没有释放,有时候退出session,再进入,可以问题就解决了。





来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15713890/viewspace-668567/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/15713890/viewspace-668567/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值