Re: Data Warehouse Backups

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 23 Sep 1999 18:44:10 +0800
Message-ID: <37EA047A.9B5@yahoo.com>

Mike Vergara wrote:
>
> Mike Vergara wrote in message <7sbqaj$2p1_at_dfw-ixnews12.ix.netcom.com>...
> >Hey DBAs:
> >
> >We're working on our first data warehouse project. The software
> >vendor is MicroStrategy. They're telling us that our data warehouse
> >(mainly retail shopping data) will grow to about 700MB in the next
> >year.
> Hey everyone...I meant *700GB*. Oops.
>
> >
> >My question to any other data warehouse DBAs is "How do you
> >back up that much stuff?" We're using Legato Networker as our
> >recording system, but what do YOU do? What are your experiences?
> >
> >Respond to the group or to my e-mail and I will summarize back to
> >the list.
> >
> >Thanks,
> >Mike
> >
> >
> >
> >

Some options

• read-only tablespaces
• parallel backup devices taking care not to saturate your SCSI (or equivalent) controller(s)
• third mirror to disk to allow offline backup whilst the database is still up

--

---

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 Thu Sep 23 1999 - 05:44:10 CDT