Home > Database > Mysql Tutorial > body text

RMAN-20003: target database incarnation not found in recover

WBOY
Release: 2016-06-07 17:29:13
Original
957 people have browsed it

RMAN-20003: target database incarnation not found in recovery catalog错误解决

MAN> list backup;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 05/25/2013 15:00:53
RMAN-06004: Oracle error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog

今天在进行了resetlogs测试后,rman报出了这样一个错误。

后来通过查阅资料,可以尝试使用以下命令解决:

RMAN> reset database;
在恢复目录中注册的数据库的新实体化
正在启动全部恢复目录的 resync
完成全部 resync

如果还是不行,,不妨把这数据库从catalog中删除后再register了。9i和10g不一样,删除方法是:

10g只需要通过RMAN连接后运行:unregiester database即可。

而9i需要按以下步骤执行:

1、获得本数据库的标识码DB_ID,这个在rman登陆时就可以看到;

2、获得catalog恢复目录数据库中本数据库的键值DB_KEY;

$sqlplus /nolog
SQL>conn rman/rman@catalog
SQL>select db_key,rpad(to_char(db_id),12) "DB_ID_NUMBER" from db where db_id='2599493095';
SQL> select db_key,rpad(to_char(db_id),12)"DB_ID_NUMBER" from db where db_id='2599493095';
DB_KEY DB_ID_NUMBER
---------- ------------------------
27483 2599493095

3、注销数据库(紧接着上面做);

SQL>executedbms_rcvcat.unregisterdatabase(1,4106156671);

然后再进入RMAN注册即可。

linux

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!