Re: Question on Incomplete Media Recovery

The hotbackup script does a log switch at the end of backing up all datafiles and the controlfile. When the logswitch occurs, Oracle will create an archived redolog, which gets backed up as well.

So when I restore, I will have only the datafiles, controlfile and one archived redolog past the point of backup.

Does that answer your question?

Regards...

tho_pic_at_yahoo.com (Tho Nguyen) wrote in message news:<d177c6d9.0410181541.29777624_at_posting.google.com>...
>
> Hi,
>
> Howard is completely right. But I just wonder how you can do the
> incomplete recovery without some archived logfiles. Let's say you have
> several tablespaces and it takes 1-2 hours to complete backup for the
> first one. During that time some logfiles are generated. And the same
> thing happens to the second tablespace and so on. How can you make
> your datafiles in the hot backup synchronized without logfiles?
Received on Tue Oct 19 2004 - 11:34:14 CDT