cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle RMAN incremental to MSDP very slow

D_Thomas
Level 4

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.

4 REPLIES 4

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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

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

D_Thomas
Level 4

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

DT

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
Moderator
Moderator
Partner    VIP    Accredited Certified

@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.