Welcome to the wonderful world of RMAN block level recovery in 9i: the data
block is now the smallest unit of recovery (try doing that with an O/S
backup!). One of the compelling reasons for a 9i upgrade, I think.
Regards
HJR
--
------------------------------------------
Resources for Oracle : www.hjrdba.com
============================
"Roxl" <nospam_Roxl_at_ozemail.com.au> wrote in message
news:FDQo8.222$Id2.24849_at_ozemail.com.au...
>
> My memory is that 4GB is the limit - and that this relates to NTFS.
> Personally I'd never use files > 2GB, but that's my own choice. I can't
> see any reason for using larger files.
>
> I'd also be worried about recovery times - if you corrupt a block in a
10GB
> file this will take longer to recover than a corruption in a 1000MB file.
> Usually the smallest recovery unit is the datafile.... (ie you load an old
> data file then roll it forward using redo logs).
>
>
> Cheers,
>
> Richard Gowan
>
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:3ca2f85e$0$225$ed9e5944_at_reading.news.pipex.net...
> > "Randi Wølner" <randiwolner_at_hotmail.com> wrote in message
> > news:a7uq4a$fes$1_at_oslo-nntp.eunet.no...
> > > Thanks for your advices, everyone!
> > >
> > > It is true that I can just recreate the database if something goes
wrong
> > > (the data in this development environment are not important, as they
are
> > > backup of "the real" data). BUT - as 7 developers are depending on
this
> > > database to be running to do their work, I am concerned about it not
to
> > "die
> > > a horrible death"..
> >
> > I'm sure 7 halfway decent developers can easily kill a db if they try
hard
> > enough. ;-) Seriously I think backups are just as important for
> development
> > systems as for production systems. If nothing else they let you prove
your
> > backup strategy before going live.
> >
> > > And the 5 * 2G datafile is something I would like to avoid, as there
are
> > > very large extents in the database that we copy from (so even though
> > > compress is set to NO there has been some problems related to this
> > earlier).
> > > I have come to the conclusion that I will try using a 10G datafile,
and
> if
> > > it does not work I will just be angry with Oracle software and rather
> use
> > > another database in my next project..
> >
> > I don't see the problem though. As I said before you should be using
> locally
> > manged tablespaces in 8i with a UNIFORM extent size, and moreover one of
a
> > darn sight less than 2gb per extent. I can see that if you had a TB
> > datawarehouse you wouldn't be hugely pleased to be restricted to 2gb
files
> > but for 10gb who cares?
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
> >
> >
>
>
Received on Fri Mar 29 2002 - 01:26:39 CST
