Re: How long to backup 5GB DB?

Richard L. Rhodes (rhodesr_at_watt.oedison.com) wrote:
: We are in the pilot phase of installing an application
: that uses an oracle database. The current estimate of
: the full database size is about 5GB. The pilot DB indexes
: are currently running at about 50% of the data size
: giving a full database guestimate (data+index) of
: 7 to 8 GBs.
 

: Can someone please give me some idea (however rough) of:
 

: 1) How long it might take to backup this size of DB up to tape.

One of our clients has an 8GB database (data + index + rollback) and it takes about 3.5 hours to back up to DAT tape using HP-UX fbackup (running on a 755 with fast/wide SCSI) NOTE: your hardware will greatly impact this performance!!!

: 2) How long it might take to restore a DB of this size from
: tape back to disk.

About the same.

: Thanks for the help!
 

: rick
 

: --------------------------------------------------------
: Richard L. Rhodes Email: rhodesr_at_watt.oedison.com
: Ohio Edison Co. Phone: 216-384-2598

One final note, if you plan on having to restore from tape, don't forget to backup/archive raw data from the time of the last full backup. The strategy we typically use is a full backup once weekly, nightly incrementals of system (sans database). ALL raw data is kept on line until the full backup is completed (and verfied).

Hope this helps.

--
----------------------------------------------------------------------

		    Michael Leblanc, Support Engineer
                    Derby Associates, International
                    E-Mail: derby_at_teal.csn.org