Recovering LVL0 without archivelog after
EtopsFeb 10 2012 — edited Feb 15 2012Hi,
Here is my problem : I have a valid "backup incremental level 0 plus archivelog" backup which is 10 days old, but not the archivelogs generated by the database after that backup.
I tried different restore strategies but it seems impossible to bring this backup online and consistent.
This is critical as I need the data that are in a table of that database.
A few details :
- it is a 11GR2 RAC database
- LVL 0 plus archivelog backup
- the last sequence of thread 1 in the backup is 25245
- the last sequence of thread 2 in the backup is 25127
The next sequences of archivelog are no longer available.
I've tried restoring using until time, scn or until sequence with no result.
Restore is ok, but recover is not, so opening with resetlogs is impossible.
How can I restore this backup without having the archivelog generated after ?
I can post the log of that backup if needed.
Thanks a lot !
Regards,
Guillaume