Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Recovering LVL0 without archivelog after

EtopsFeb 10 2012 — edited Feb 15 2012
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2012
Added on Feb 10 2012
59 comments
2,474 views