Forum Discussion

GeoPlaceTom's avatar
GeoPlaceTom
Level 2
9 years ago
Solved

Initiating a script-based Oracle backup from Netbackup

Hello,

I'm trying to back up an Oracle database using a script-based policy, but I'm a little fuzzy on how to schedule the thing.

If I want to fire off a backup using a schedule, then I create a shcedule using 'Full', and the script dutifully begins at the moment requested, but when it starts to come back it's using the Default-Application-Backup schedule, and so it just writes wherever it wants with the retention period it wants.

If I want a backup to be initiated by the netbackup, do I need to create an Application Policy schedule for each of my other schedules so I can aplly the right SLP?

Thanks,

Tom

7.7
Linux
Oracle
script-based
  • Genericus's avatar
    Genericus
    9 years ago

    The basic scripts come with netbackup.

    My unix scripts are two pieces, a *.sh and a *.rcv

    The policy backup selection is the path to the .sh script, it calls the appropriate .rcv script.

    For schedules, yes there should be two:

    I name the Full backup "Parent.Job" and the Application backup "Child.Job"

    The child should be set to run 24/7, the parent should have the actual schedule.

    Using standard naming allows filtering for parents, or using the backup_exit_notify to ignore child jobs and alert on parents only.

     

6 Replies

Sort By
  • Genericus's avatar
    Genericus
    Moderator
    9 years ago

    The basic scripts come with netbackup.

    My unix scripts are two pieces, a *.sh and a *.rcv

    The policy backup selection is the path to the .sh script, it calls the appropriate .rcv script.

    For schedules, yes there should be two:

    I name the Full backup "Parent.Job" and the Application backup "Child.Job"

    The child should be set to run 24/7, the parent should have the actual schedule.

    Using standard naming allows filtering for parents, or using the backup_exit_notify to ignore child jobs and alert on parents only.

     

    • Genericus's avatar
      Genericus
      Moderator
      9 years ago

      I use SLP - so I set the SLP at the policy level, it sets the retention.

       

      • GeoPlaceTom's avatar
        GeoPlaceTom
        Level 2
        9 years ago

        Thanks Genericus for the fast response, the parent-child thing seems to be the way forward. I'll try to get that set up soon. We use different SLPs based off what sort of backup it is, so I need to keep it at the schedule level...daily gets replicated to another appliance, but weekly goes to a tape for rotation too, that sort of thing.

        What's an .rcv file? Is it something to control an RMAN process?

  • Nicolai's avatar
    Nicolai
    Moderator
    9 years ago

    Why not using Netbackup Intelligent policies for Oracle ?

    • GeoPlaceTom's avatar
      GeoPlaceTom
      Level 2
      9 years ago

      My DBAs have a very strong views on tagging etc and want to keep 100% oversight of everything relating to their databases. The Intelligent Policy was tried and worked quite well, but didn't meet with their approval.