RE: BIG database backup methods

From: Freeman Robert - IL <FREEMANR_at_tusc.com>
Date: Tue, 21 Sep 2004 13:28:34 -0500
Message-ID: <F5E885BEF9540D47A7BDC03CF16880870A7D50E0@tuscil_ex1>

There are a few options depending on your environemnt. Incremental backups with RMAN can certainly reduce the size of your backup sets. Still, the initial full backup is going to take some time to complete. How many tape drives do you currently have access to? How long will it take to backup your 1-2 TB database to these drives? RMAN can parallelize the backup to many drives, of course.

Also, compression can help as well. Early RMAN offers a quazi compression, but 10g offers full blown compression (ala ZIP) which is most useful unless the backup is getting compressed already (i.e. Your tape system does compression).

I'm not sure about the data you have, but if you make your tablespaces read only, then you only need to back them up once (and retain that backup of couse).

Make sure management understands that recovery times will be impacted by moving from disk to tape.

If you are new to RMAN check out my Oracle Press book, Oracle9i RMAN Backup and Recovery.

Cheers!

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
To: oracle-l_at_freelists.org
Sent: 9/21/2004 1:11 PM
Subject: BIG database backup methods

We have the "luxury?" of being able to do shadow copies for many of our data warehouses. These are only in the 1-2 TB range, but with shadow copy, we start at perhaps 2AM with the syncing, and then around 4PM we stop the database, wait about 5 minutes, break the volumes and we're back up.

Management is getting very hungry looking at all these disks that are for backup and thinking "If we used RMAN and went to tape it would be better...

I'm not so sure. 1-2 TB in 5 minutes is pretty good.

What are others doing?

Michael Kline
Database Administration
SunTrust Technology Center
1030 Wilmer Avenue
Richmond, Virginia 23227
Outside 804.261.9446
STNet 643.9446

Cell 804.744.1545
<mailto:michael.kline_at_suntrust.com> michael.kline_at_suntrust.com

The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 21 2004 - 13:25:32 CDT