4 Replies Latest reply: Feb 18, 2013 7:45 PM by Fabricio_Jorge RSS

    Performance on RMAN backups and LOBs

    Fabricio_Jorge
      Hi all,

      We have a 4-node database (11.2.0.3) running on a RHEL. The db has 2.5TBs, and we realized that the incremental level 1 backup is taking too long to complete. Doing some research, we found some blog posts saying that, during a backup of a segment, if that same segment has a lot of lob segments (and that is our case... a lot of lob segments) and the backup is being compressed (we are using CONFIGURE COMPRESSION ALGORITHM 'HIGH' OPTIMIZE FOR LOAD TRUE AS OF RELEASE 'DEFAULT') this same backup can take a lot longer than a uncompressed backup. What i would like to know is if you had an equal experience and if changing the compression algorithm to none, the backup will run faster.

      PS - The input and output of the backup is disk.

      Thanks in advance.