Re: Oracle Backup for Large Databases (800,000,000 rows) in one table

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Tue, 22 May 2001 13:29:08 -0500
Message-ID: <9eeb1o$m8b$1@news.gte.com>

I use a set of two Sony AIT ( second generation ) tape drives that write data at aroud 7MB/second native. With compression, they are quite a bit faster. Using both drives in parallel for a single tablespace, my throughput approaches 20-30MB/second, which will knock out a large tablespace quickly. These drives use a 25GB tape. Restore times are slightly slower.

Sony has larger/faster media available these days, as does a number of other manufactures.

Good Luck.

-Kevin

"Marwan Samara" <samara.marwan_at_epa.gov> wrote in message news:12992fb9.0105210950.309a4a66_at_posting.google.com...
> Hi All,
> I'm new to the list and to ORACLE DBA (came from Mainframe). I've been
> asked/tasked to come up with a procedure to backup and restore one of our
> databases in the fastest waypossible !.
> The largest table is partitioned by year, and contains
> about 800,000,000 rows with average length of 100 bytes.
> Now, a hot backup is taking about 7 hours, and never tried the restore.
> Please, any Ideas, or references are welcome.
>
> Thanks,
>
> Marwan Samara.
Received on Tue May 22 2001 - 13:29:08 CDT