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.
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'
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'
The current incarnation only contains incremental level 1 backups
of the database.
There are NO level 0 backups in this incarnation.
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;
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.