ITPub博客

首页 > 数据库 > Oracle > RMAN-20003错误

RMAN-20003错误

原创 Oracle 作者:wmlm 时间:2010-01-17 10:21:35 0 删除 编辑

起因:
trgt 开始在 catalog 注册使用过一段时间;
trgt 没有连接catalog,使用控制文件做了databse resetlog ; 控制文件中记录了两个incarnation;
再次使用catalog连接时,list incarnation; 只显示较早的incartion;
如果RMAN> resync catalog;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 01/17/2010 10:06:53
RMAN-20003: target database incarnation not found in recovery catalog

RMAN> register database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of register command on default channel at 01/17/2010 10:07:17
RMAN-20002: target database already registered in recovery catalog

解决方法:
RMAN> reset database;

[@more@]

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

RMAN> list incarnation;


List of Database Incarnations
DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 2 ORCL 1234192952 NO 1 24-DEC-09
1 62 ORCL 1234192952 YES 665802 13-JAN-10

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

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

注册时间:2008-04-08

  • 博文量
    398
  • 访问量
    3716780