Forum Discussion

manatee's avatar
manatee
Level 6
9 years ago
Solved

using crontab to do 15-minute backups

i already have a backup policy for SQL Server transaction logs that runs every hour. DBA requires every 15-minutes which the management console cannot provide.

can i, instead, trigger the existing backup policy using crontab? if yes,

  1. what is the NBU command to do that?
  2. where is the location of the backup policy?

so basically the plan is i'll have shell script with all the NBU commands to initiate the existing backup policy and the cronjob will be set to run every 15 minutes.

7.6
Linux
  • J_MCCOLL's avatar
    J_MCCOLL
    9 years ago

    What version of NetBackup are you using? If it is less than NBU 7.7 can you upgrade to benefit from SQL Intelligent backup policies? If yes then you will have the ability to 15 minute backups for your t-logs.

    Transaction-Log backup type has the following frequency options:

    • minutes
    • hours
    • days
    • weeks

    Be careful to ensure that each backup cycle has time to complete before the next starts.

    This link will provide further information on SQL IP - http://www.veritas.com/docs/000078811

    This will remove the need for a cronjob and keep everything in NBU.

    Cheers,

    J

  • Marianne's avatar
    Marianne
    Level 6
    9 years ago

    Your previous post to change the schedule via cmd is perfectly feasable - we have quite a number of customers and forum members doing this.

    To use crontab, the best option will be for Oracle dba's to add the rman script to the relevant crontab on the Oracle server. 
    You will see default-application jobs appearing in Activity Monitor without a parent job.

    The other option is crontab on the master.
    The command is 'bpbackup -i -p <policy> -s <schedule>'.
    Use absolute path in crontab. 

    You can find detailed info on bpbackup command usage in NetBackup Commands Reference Guide 

     

    • manatee's avatar
      manatee
      Level 6
      9 years ago

      i tried that with "bpplschedrep" and got:

      the specified policy does not exist in the configuration database

      "bppllist" gives:

      the specified policy does not exist in the configuration database (230)

      although the policy is very much there in the GUI console. that's why i ventured into doing it via unix' crontab.

      btw, this is not an Oracle backup policy. it's a SQL Server transaction log backup policy.

      i will try from the master server that "bpbackup" command. but where are policies stored in a unix master server?