ITPub博客

首页 > Linux操作系统 > Linux操作系统 > register database---ORA-04062

register database---ORA-04062

原创 Linux操作系统 作者:wait360 时间:2010-07-21 10:36:04 0 删除 编辑

(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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-02-11

  • 博文量
    25
  • 访问量
    59165