Tuesday 14 January 2014

DB Incarnation problem while doing rman restore

Hi guys,
   Here we will discuss the problem that basically comes due to database incarnation. Hope it will help you.
If any doubt please email me.



Symptoms
After restoring the controlfile, rman restore of database fails with :

RMAN-03002: failure of restore command at 09/14/2006 01:39:09
ORA-01180: cannot create datafile 1
ORA-01110: data file 1: '/<path>/system01.dbf'
Cause
The current incarnation only contains incremental level 1 backups of the database.
There are NO level 0 backups in this incarnation. 
As the physical datafiles do not exist RMAN attempts to create the physical files but this is NOT allowed if the file belongs to the SYSTEM tablespace.

Solution
Reset the database to the previous incarnation and run the restore and recovery again:
RMAN> reset database to incarnation n;  (n should be current or parent backup)
RMAN> restore database;
In my case I gave
RMAN> reset database to incarnation 1;
After applying this command it worked rman>list incarnation;Check the Current incarnation.