Re: Performance Impact Online Database Backup

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 20 Nov 1999 00:29:08 +0800
Message-ID: <38357AD4.5F24@yahoo.com>

Sjimmie wrote:
>
> Hi,
>
> Does anyone have any benchmarks/references to the performance impact of an
> online database backup ? (i.e. on a 24/7 system)
>
> Thanks,
>
> Simon

The impact is "not large" - the main one being on the redo logs. During a backup, typically blocks (as opposed to rows) are written to the logs (this is a simplification) thus the logs will be hit harder...

Other than that, there will the additional impact of whatever backup software you are using actually copying the file to tape/disk etc...

HTH
--

---

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 Fri Nov 19 1999 - 10:29:08 CST