Forum Discussion

D_Thomas's avatar
D_Thomas
Level 4
12 years ago

Oracle RMAN incremental to MSDP very slow

We are running RMAN backups to MSDP. The fulls and archive backups are very fast and dedupicate pretty well using filesperset 1.

When the incremental backups run, it can take as much as 9 minutes to back up a 288k file, which makes no sense.

It looks like bptm is waiting on something, but I cannot understand what it could be.

Oracle is 10G, changed block tracking is enabled.

The DBAs set filesperst to a higher number, and its faster, but it hardly deduplicates, so that's not gong to work.

Anyone else see anything like this? I don't think its due to deduplication - it seems to be something on the oracle side. All the other jobs that run against the MSDP run very well. The behavior is the same using client side dedupe and server side dedupe.

Master and Media are on 7.5.0.4

Oracle boxes are on 7.1.0.4 due to an old kernel they run.

  • Ask your dba's to  Enable RMAN's Debug Output for incremental backups.

    This should confirm if it's 'something on the oracle side'.

  • OK. I have a ticket open with Symantec as well. Thanks for the input.

    DT

    • nasahasha's avatar
      nasahasha
      Level 5

      Hello,

      I see this is a old post, but I am also seing same issue. Were you able to figure out why incrementals running slow?

      • Marianne's avatar
        Marianne
        Level 6

        nasahasha , the original poster D_Thomas  last visited here  on 07-19-2016.

        Best to start a new discussion with details of your NBU and Oracle environment, and what you have done thus far to troubleshoot.