Forum Discussion

sri_vani's avatar
sri_vani
Level 6
12 years ago

DB offline backup is running slowly whn compare to Online backup

Hi Experts,

I appreciate ur help/inputs on the below issue.

 

In our env we have one Oracle DB backup.

Daily we will take full backup -Online-which it will complete in 5 to 6 hours.

and we have scheduled a offline backup to it.

It is taking much time whn compare to online backup and it is completing in 13 to 14 hrs.

How to fix this

Master server:AIX 7.1

Client:win:6.5.4(we ll upgrade to 7)

500Gb

7.1.x and Earlier
Backing Up
Backup and Recovery
Basics
Best Practice
NetBackup
  • RamNagalla's avatar
    RamNagalla
    12 years ago

    Offline Backup is running on Weekend ..all other full backups also scheduled on Weekend..

    may be above statement would expline something..

    i would test.. 1) trun off all other backups while running weekend offline backups and start the other full backups manually  once the Offline backup is done and see how it goes.

                        or 

    2) try to run offline backup other time (may be deficult to get down time from DB)

  • rizwan84tx's avatar
    rizwan84tx
    Level 6
    12 years ago

    Online DB backup that you are referring is NBU RMAN backups? and how is the ofline DB backup is being configured in NBU master?

  • sri_vani's avatar
    sri_vani
    Level 6
    12 years ago

    Both online and offline backups will call off the scripts  whn evr schedule strats.

     

    We have provided the scrit path in the backup selection.

  • RamNagalla's avatar
    RamNagalla
    Moderator
    12 years ago

    hi,

    how many streams that are triggering the Online backup?

    and what about the offline backups streams ?

    what is the difference in Online and offilne backup in netbackups

    1) same storage unit and media server?

    2) same load on the media severs.. ( number of jobs, CPU utilization etc)

     

  • sri_vani's avatar
    sri_vani
    Level 6
    12 years ago

    Nag/All

    Whn verified offline backup completion time is varying time to time.

    Date Time   GB Appx
    07/20/13 13:23 Hrs 488
    07/13/13 16:24 Hrs 490
    07/06/13 08:15 Hrs 490
    06/01/13 06:21 Hrs 480
    06/08/13 08:49 Hrs 450
    06/15/13 08:01 Hrs 480

    Pls lemme know what to chk and how to fix this

  • RamNagalla's avatar
    RamNagalla
    Moderator
    12 years ago

    hi SriVani,

     

    first i would prefer to check the configuration difference between the online and offline in netbackup point of View.

    like :- storage units, Media servers, number of streams, load on the media server.

    1) how many jobs are triggering for Online backup and offline backup?

    2) are they going to same media server and storage unit?

    3) how may other jobs are running on the media server when running the online jobs,and when running the offline jobs?

  • sri_vani's avatar
    sri_vani
    Level 6
    12 years ago

    Nag

    Pls find my ans below

     

    1)Online triggering 3 child jobs where as offline triggering 5 jobs

    2)Same Media server and same STU

    3)Offline Backup is running on Weekend ..all other full backups also scheduled on Weekend.and dedicared drive is assigned to this backup.

     

    Now our biggest concern here is..as per customer this offline backup shd be complted in 7 to 8 hrs.

    It is a critical sys needs to come online ASAP.

  • RamNagalla's avatar
    RamNagalla
    Moderator
    12 years ago

    Offline Backup is running on Weekend ..all other full backups also scheduled on Weekend..

    may be above statement would expline something..

    i would test.. 1) trun off all other backups while running weekend offline backups and start the other full backups manually  once the Offline backup is done and see how it goes.

                        or 

    2) try to run offline backup other time (may be deficult to get down time from DB)

  • sri_vani's avatar
    sri_vani
    Level 6
    12 years ago

    Thx Nag..

    I will try first optiona and let you know the results