Home » RDBMS Server » Backup & Recovery » RMAN-20003: target database incarnation not found in recovery catalog (Oracle Enterprise Linux)
RMAN-20003: target database incarnation not found in recovery catalog [message #296988] Tue, 29 January 2008 18:50 Go to next message
basirana
Messages: 25
Registered: July 2006
Junior Member
Hi

I am using RMAN to restore and recover database and I am getting below error

$ rman catalog rman/rman@tnsrman target sys/sys@tnstest

RMAN> restore controlfile;

Finished restore at 29-JAN-08

RMAN> restore database;
...
Finished restore at 29-JAN-08

RMAN> sql 'alter database mount';
...
sql statement: alter database mount

RMAN> recover database;
...
Starting recover at 29-JAN-08
Starting implicit crosscheck backup at 29-JAN-08
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK
Crosschecked 27 objects
Finished implicit crosscheck backup at 29-JAN-08

Starting implicit crosscheck copy at 29-JAN-08
using channel ORA_DISK_1
Finished implicit crosscheck copy at 29-JAN-08

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /d06/app/testdb/flash_recovery_area/TEST/archivelog/2008_01_29/o1_mf_1_1_3szcdrnl_.arc
File Name: /d06/app/testdb/flash_recovery_area/TEST/archivelog/2008_01_29/o1_mf_1_2_3szchjpp_.arc
File Name: /d06/app/testdb/flash_recovery_area/TEST/archivelog/2008_01_29/o1_mf_1_3_3szcmcdz_.arc
File Name: /d06/app/testdb/flash_recovery_area/TEST/archivelog/2008_01_29/o1_mf_1_4_3szcmorl_.arc

using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/29/2008 16:05:48
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog

Thanks
Re: RMAN-20003: target database incarnation not found in recovery catalog [message #296991 is a reply to message #296988] Tue, 29 January 2008 19:30 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have you tried to issue:

RMAN> reset database;
Re: RMAN-20003: target database incarnation not found in recovery catalog [message #296994 is a reply to message #296991] Tue, 29 January 2008 20:08 Go to previous message
basirana
Messages: 25
Registered: July 2006
Junior Member
RMAN> reset database;

database incarnation already registered
Previous Topic: rman original files to new host
Next Topic: RMAN-06004: ORACLE error from recovery catalog database
Goto Forum:
  


Current Time: Wed May 15 04:52:21 CDT 2024