Forum Discussion

Nayab_Rasool's avatar
Nayab_Rasool
Level 6
12 years ago

Oracle DB performance hit during Daily Full Backups

Hi All,

 

My Oracle admin says there was huge performance issue on one of my ORACLE DB LINUX server while the daily full backup happening.

Can anyone suggest how i will be able to fine tune this so that the backups will run smooth.

 

Thanks,

Nayab

7.1.x and Earlier
Backing Up
Backup and Recovery
Best Practice
Linux
Monitoring
NetBackup
Troubleshooting
  • Marianne's avatar
    Marianne
    Level 6
    12 years ago

    Online RMAN backups give us exactly that - online backups. 
    How performance is affected on the Oracle server is determined by physical resources on the server, like memory, cpu and disk layout.

    Some good links that should make sense to an Oracle dba:

     

    http://www.nyoug.org/Presentations/2010/December/Chien_RMAN.pdf

    http://www.oracle.com/technetwork/database/features/availability/s316928-2-175929.pdf

    http://levipereira.files.wordpress.com/2011/01/tuning_rman_buffer.pdf

    http://www.oracle.com/technetwork/database/focus-areas/availability/rman-perf-tuning-bp-452204.pdf

     

    The secret will be to ensure sufficient resources for 'normal' Oracle processing as well as rman performance.

    I cannot see that much can be done from NBU point of view.
    Maybe reduce 'filesperset' parameter in the script... (actually rman setting, not NBU)
    Or schedule backups during quiet time.

    *** EDIT ***

    Another link that may be useful:

    http://www.freelists.org/post/oracle-l/RMAN-backup-slows-database-performance-to-a-crawl,2

     

  • Nayab_Rasool's avatar
    Nayab_Rasool
    Level 6
    12 years ago

    Hi Maria,

     

    These links seems to be some interesting stuff :) i will go through and will get back to you.

     

    Thanks,

    Nayab

  • Nayab_Rasool's avatar
    Nayab_Rasool
    Level 6
    12 years ago

    Hi Maria,

     

    I have gone through these docs will ask my ORACLE_DB to check all these parameters , Are these the best recommendations to get a better throughput from ORACLE  ??

     

    Thanks,

    Nayab

  • huanglao2002's avatar
    huanglao2002
    Level 6
    12 years ago

    1.You can ask the DBA, backup windows avoid the business peak time.
    2.Please reference the rman manual,you can try to control backup speed. such as  "configure channel device type disk rate 20480k"

  • Marianne's avatar
    Marianne
    Level 6
    12 years ago

    You need to hand this over to the Oracle team... 

    I have posted the links so that we all (Oracle dba's included) can understand that they need to troubleshoot and tune from within Oracle. Nothing we can do from NBU side.
    As a backup admin, I cannot make Oracle recommendations.

    Best if dba's ask the same questions on an Oracle forum.

  • Nayab_Rasool's avatar
    Nayab_Rasool
    Level 6
    12 years ago

    It seems he tried these already but not much performance , Is something do i need to change from the Policy or change some values or parameters in Netbackup so that it will help the backup to boost as Archive Log backup is fine with the server , When Full backup triggers it will be a huge performance hit.

     

    Thanks,

    Nayab

  • Nayab_Rasool's avatar
    Nayab_Rasool
    Level 6
    12 years ago

    Will you people able to say something by seeing logs ?? any chance ???

     

    Thanks,

    Nayab

  • Nayab_Rasool's avatar
    Nayab_Rasool
    Level 6
    12 years ago

    As my DB admin says the performance of the Oracle server is very slow during the DAILY FULL BACKUPS :( . Please help me if i can change any parameters that will help.

     

    Thanks,

    Nayab

  • huanglao2002's avatar
    huanglao2002
    Level 6
    12 years ago

    2.Please reference the rman manual,you can try to control backup speed. such as "configure channel device type disk rate 20480k"

  • Nayabsk's avatar
    Nayabsk
    Level 6
    12 years ago

    Hi Huanglao,

     

    Thank you verymuch for your reply , I have checked the rman backup and recovery guide and i have found the option what u have mentioned , I would like to know what will be the maximum value to get better performance.

     

     

    CONFIGURE CHANNEL DEVICE TYPE sbt PARMS='ENV=(NSR_SERVER=bksvr1)';
    CONFIGURE CHANNEL DEVICE TYPE DISK RATE 5M FORMAT="?/oradata/%U";
     
    Because you do not specify channel numbers for these channels, the channel settings 
    are generic to all automatic channels of the specified type. The configuration acts as a 
    template. For example, if you set PARALLELISM for DISK to 10, and the default device 
    type is DISK, then RMAN allocates ten disk channels using the settings in the 
    CONFIGURE CHANNEL DEVICE TYPE DISK command
     
     
    Thanks,
    Nayab