(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/