Thanks for the explaination. I have pulled out the B&R guide because you
are correct it has been quite a while.
"Sean M" <smckeownNO_at_BACKSIESearthlink.net> wrote in message
news:3D1CE38A.1C9BEC4_at_BACKSIESearthlink.net...
> Joe Salmeri wrote:
> >
> > > You're talking about needing point in time recovery, which must apply
to
> > > the ENTIRE database. Even if you had taken backups of datafile_1 and
> > > datafile_2 at the same time, you can't simply restore them and move
on.
> > > They would have to be make consistent with the rest of the files in
the
> > > tablespace. You can't roll only a portion of a database back in time.
> > > It's all or nothing.
> >
> > I understand that I would not be able to put both datafiles back and
just
> > move on, I was trying to simplify my example.
> >
> > How would you ever use a backup of an individual datafile? How would
you
> > ever use backups of individual datafiles that were not taken at the same
> > time?
> >
> > Since it's all or nothing as you put it (and I AGREE) I can not see a
single
> > situation where your individual datafile backups could be used.
> >
> > > As I said already, a good datafile backup is a good datafile backup.
> > > There is no dependency between individual datafile backpus within a
> > > tablespace.
> >
> > It's a good backup, but how would it ever be used???
>
> I usually try to steer clear of RTFM-type posts, but I think you really
> ought to revisit Oracle's Backup and Recovery Guide. B&R is a huge
> topic, and asking questions like the ones you've posed above tells me
> you're probably due for a refresher course. But, you asked for an
> example, so I'll give you one:
>
> You have a disk that contains one and only one datafile, though that
> datafile is but one of many in a particular tablespace. You backup
> certain disks each day of the week (in this example). So on Monday you
> get a backup of this one lone datafile, but none of the other datafiles
> in that tablespace. On Tuesday you lose that disk. Disk is trashed,
> that one datafile is lost. So you replace that disk with a spare, and
> restore that datafile from Monday's backup. You recover that datafile
> with all the archives generated since the backup, bring it online, and
> you're back in business. You didn't need to restore any of the other
> datafiles from that tablespace since they weren't affected by the media
> failure.
>
> Regards,
> Sean M
Received on Fri Jun 28 2002 - 22:14:09 CDT
