Re: Oracle 8i (8.1.7.0.1) + Redhat Linux 7.2 = Cannot create tablespace file > 2 gb

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 - 17:30:34 CDT