I have below backups:-Most likely that controlfile from backup 1 does not have info about last archivelogs. You can check this with 'list archivelog all' command. If some logs are missing, register them with 'catalog archivelog ...'.
1)L0+controlfile ('backup incremental level 0 database' and controlfile autobackup)
2)cumulative L1 + controlfile ('backup incremental level 1 cumulative database' and controlfile autobackup)
3)cumulative L1 + controlfile
last archive logseq is 10.
i have deleted all the datafiles,redolog and controlfile after 3rd backup (not executed "alter system archive log current")
and i am trying to restore and recover from below commands
restore controlfile from '<controlfile backup>;
set until logseq 11;
case1) when restoring controlfile from backup 3 then run block completing successfully.
case2) when restoring controlfile from backup 1 then it's giving error after recovery
"ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below"
As per my understanding its failing because i do not have redologs or last archivelog.
Can i recover this with any other approach ?
Apparently there is a mismatch in the backups. Did you run BACKUP and/or RESTORE for the two datafiles separately ?
ORA-01152: file string was not restored from a sufficiently old backup Cause: An incomplete recovery session was started, but an insufficient number of logs were applied to make the database consistent. This file is still in the future of the last log applied. The most likely cause of this error is forgetting to restore the file from a backup before doing incomplete recovery. Action: Either apply more logs until the database is consistent or restore the database file from an older backup and repeat recovery.