RMAN - ORA-01110: data file 1: 'E:\ORACLE\CLONE\PRODUCT\11.2.0.4\DBHOME_1\DATABASE\SYSTEM01.DBF'
Dear Collegues,
I used RMAN to backup my database as below,
RMAN>BACKUP INCREMENTAL LEVEL 0 DATABASE tag='LEVEL0-XXX';
RMAN>BACKUP INCREMENTAL LEVEL 1 DATABASE tag='LEVEL1-XXX';
RMAN>BACKUP INCREMENTAL LEVEL 1 DATABASE tag='LEVEL1-XXX';
these backups completed all with success.
now i would like to restore my Database
RMAN>restore controlfile from 'E:\Oracle\CLONE\product\11.2.0.4\dbhome_1\database\backup\CFC-XXXXXX';
RMAN>restore database;
RMAN>recover database;
RMAN> alter database open resetlogs; ==> faced the below issue
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 05/14/2015 13:42:52
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'E:\ORACLE\CLONE\PRODUCT\11.2.0.4\DBHOME_1\DATABASE\SYSTEM01.DBF'