Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What is the basic backup/reco strategy for db>500gb

Re: What is the basic backup/reco strategy for db>500gb

From: duraisingh <duraisingh_at_yahoo.com>
Date: Wed, 20 Oct 1999 15:22:02 -0400
Message-ID: <380E165A.D4864F3B@yahoo.com>


Thank You so much Connor
john

Connor McDonald wrote:

> duraisingh wrote:
> >
> > Hellow Gurus:
> > We have planned to do a backup plan for D/W olap database of size >500gb
> > in Hp 10.20.
> > I want to know , if any one already had the exposure about this subject.
> >
> > What is the backup method?,
> > which tool you are using ?,
> > What is the duration of the cold bakup?.
> > I know normally datawarehousing databases will be considered for cold
> > backup only. What about exports?
> > Have you ever taken export ? what is the size of the compressed export
> > for a 500gb DB.
> > Since our database is hooked up with internet reporting applications.
> > So we can not give a very big downtime for cold backups.
> >
> > If you gurus can enlighten me in this matter, I will be greatful.
> >
> > John B Durai
>
> Some options:
>
> a. read-only tablespaces - put the data that doesn't even change into
> read-only tablespaces ( you back these up once and you never have to do
> it again)
>
> b. source data backup - rather than backup the db, take backups of the
> data that is used to load the warehouse (once you've taken an initial
> backup)
>
> c. incremental backup (Oracle 8+) - less to backup but you still have
> to pass over every block in the database
>
> HTH
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."
Received on Wed Oct 20 1999 - 14:22:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US