Re: Why not bigfile ?

Andrea wrote:
> Brian Peasland wrote:
> > Andrea wrote:
> > > hi,
> > > ive read a tip of oracle that says:
> > > "If you are not using a logical volume manager that supports dynamic
> > > volume resizing as well striping and/or mirroring, do not use bigfile
> > > tablespaces."
> > >
> > > but someone can explain me why not use bigfile on NO LVM system?
> > >
> > > thanks
> > >
> >
> > Because a bigfile tablespace can have one and only one datafile. If that
> > disk volume runs out of space, you cannot add another datafile to the
> > bigfile tablespace on another disk volume. You'll need to be able to add
> > more physical disks to the logical disk volume without destroying the
> > volume's contents (hence "dynamic volume resizing") before the bigfile
> > tablespace can grow.
> >
>
> it's true..
> thanks!

AFAIK, you still can't parallelize an RMAN backup of a bigfile. We have one database that has, among several other "normal" tablespaces, a one terabyte bigfile tablespace. Try doing a full backup of that thing in serial...

HTH, Steve Received on Tue Oct 03 2006 - 12:54:20 CDT