Oracle Database Discussions

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!

OFFLINE datafile and Recovery

DanielDJan 5 2007 — edited Jan 5 2007

Gurus,

on 10Gr2, db is in archivelog mode, when I take empty datafile OFFLINE,
then at some point in the future(full backups were performed regurarly) I need to perform
recovery from last full backup, but archive log from the datafile OFFLINE operation way back is not available, I am not able to perform restore and recovery from full backup because of that OFFLINE datafile which needs to be recovered(why? it is offline). Is there any way to restore from the full backup and open the instance? Seems like the SET UNTIL scn/seq doesn't work either.

Thank you
D.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2007

Added on Jan 5 2007

#general-database-discussions

16 comments

2,158 views