This content has been marked as final. Show 7 replies
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 ?
its giving error for all archivelog files "ORA-279 signalled during: "
rman had already applied cumulative backup.. That’s why it’s giving errors for all the archivelog files
"ORA-279 signalled during: "
alter database recover cancel
ORA-1547 signalled during: alter database recover cancel...
Mon Apr 08 17:29:59 2013
Signalling error 1152 for datafile 4!
Signalling error 1152 for datafile 5!
We can ignore the ORA-279s. They are not error messages but information messages.
However, the ORA-1152s are critical.
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.
Hemant K Chitale