Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
Showing results for 
Search instead for 
Did you mean: 

RMAN error on recovery database

Occasional Visitor

RMAN error on recovery database

I'm having a problem trying to perform recover database.
I've been trying to test incremental updated backups using a flash recovery area. Oracle 10.2.0
The backups have been performed (4 backups) and 2 restores and recovers have been successful however when attempting the 3rd recovery i'm getting the following error when i enter recover database;

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog

What i find odd about this is i don't get this error when i perform restore database;

When i look at list incarnation the reset SCN of the current incarnation is a lower number to the SCN i'm using for the recovery.

When i connect to the target and catalog and issue a reset database; (after the first 2 recoveries open reset logs was performed both times) i get the following message

database incarnation already registered

The rman script i was using is below.

run {
set until scn 7708549371263;
restore controlfile;
alter database mount;
restore database;
recover database;

controlfile is restored database goes into mount state and restore database copies the datafiles from the flash recovery area to the correct paths.

I'm not sure what i've done wrong or what to try next. Any idea's?

Occasional Advisor

Re: RMAN error on recovery database

Can you post all the incarnation of your database?
Honored Contributor

Re: RMAN error on recovery database

hi Adrian,

this is related to your database incarnations.

Maybe to fix this, you will have to reset the current incarnation to the desired incarnation

RMAN> list incarnation of database;

RMAN> reset database to incarnation ;

hope this helps!

kind regards
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)