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

From: Tanel Põder <tanel_at_altavista.kom>
Date: Mon, 21 May 2001 20:06:42 +0200
Message-ID: <3b09590b$0$250$ba624cac@news.uninet.ee>

Hi!

Use RMAN (oracle recovery manager) and incremental backups. The restore will be slower, though.

Another way is to buy EMC hardware which is able to make snapshots of your disks :)
Or use raid 1, 1+5, 5+1, 1+1+1 disk configurations, where you also can break the mirror and have an instant snapshot do deal with later. You should notice that you should close the database or take datafiles into backup mode before taking any snapshots.

Tanel Poder
a DBA

"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 Mon May 21 2001 - 13:06:42 CDT