Re: Usual meaning of "size" of a database

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<40284ad9$0$14898$afc38c87_at_news.optusnet.com.au>...
> Multiply the "logs between backups" by the number of backups you wish to
> retain in case of emergency. Makes the numbers even better! And the serious
> point is that you don't delete all your prior archives the second a new
> backup is taken.

And also, it can be handy to have redundancy with exports (or even flat files), for those times you need to grab just a few rows that were mistakenly changed.

I'm looking for advice on when to delete prior archives, having been bitten by RMAN bugs where it can't figure out it where some logs are when restoring to create a standby. Standby restore/resynchronize can take two days [8i hp-ux nocatalog].

>
> Regards
> HJR
> --
> --------------------------------------------
> Oracle Insights: www.dizwell.com
> --------------------------------------------
>
> "Brian Peasland" <oracle_dba_at_nospam.peasland.com> wrote in message
> news:102gghu4bcgo12e_at_corp.supernews.com...
> > But I think you forgot to add this to your database size and the backup
> > size. Db size+backup size+redo logs between backups = A really nice way to
> > pump up the numbers not even the DB2 guys figured out!!
> >
> > Cheers,
> > Brian
> >
> > "Noons" <wizofoz2k_at_yahoo.com.au> wrote in message
> > news:40237a45$0$29131$afc38c87_at_news.optusnet.com.au...
> > > Narh. That's volume of activity, not volume
> > > of database.
> > >
> > > --
> > > Cheers
> > > Nuno Souto
> > > wizofoz2k_at_yahoo.com.au.nospam
> > > "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in
> message
> > > news:40236e4d$0$10333$ed9e5944_at_reading.news.pipex.net...
> > > > volume of redo/day anyone?
> > > >
> > >
> > >
> >
> >

jg

--
@home.com is bogus.
http://www.cnn.com/2004/TECH/ptech/02/10/digital.evidence.ap/index.html