Re: Database performance during hot backup

From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Fri, 30 Mar 2012 10:16:01 -0500 (CDT)
Message-ID: <bca251d6841ceaa76df55efc12aff4e2.squirrel_at_society.servebeer.com>



Hi Amir,

> I am trying to understand if it is expected to see performance
> degradation of DML transactions that are active during a hot backup. It
> is my understanding that the only noticeable thing that happens during a
> hot backup for DML statement is an increase in the amount of redo
> generation and that is because Oracle starts to log full images of data
> blocks before a change is made to a data block. I am not aware of any
> impact on performance while in hot backup mode, unless the LGWR is being
> constrained for some reason.

My kneejerk is two things:

  1. The hot backup will certainly use system resources, especially IO. If your instance is heavy on IO or IO-bound, then the possibly significant IO load of the backup would likely impact Oracle transactions.
  2. You may want to consider using RMAN instead of the traditional hot backup.

Rich

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 30 2012 - 10:16:01 CDT

Original text of this message