variables in backup selection

[Bruce_Clegg]

On our oracle servers my policies are set to backup the entire hard drive toTAPE.

I would like to set a second backup to backup certain files to DISK.  I don't have enough disk (yet) to backup everything.  I would like to set the backup selection to something like:  /oraLB/ts/backupset/2018_06_03/*

/oraLB/ts/backupset on it's own is too large.  I need to get a smaller chunk.  Does netbackup support this?

[Marianne]

Yes. Combined with Allow multiple data streams, one job will be initiated for each item in the folder.

Wild cards in Backup Selection is covered in NBU Admin Guide I.

[Bruce_Clegg]

Wildcards are useful - but I don't see how they are going to help in this case.

what I'd like to do is populate variables in the backup list from the operating system so that my backup selection would look something like:

/oraLB/ts/backupset/<YEAR>'_'<Month>'_'<Day>'/*

[Genericus]

If you script it, you should be able to run a command that matches that, but the output to the OS is the actual data, so NetBsackup would then work like a charm.

YEAR=date.year

MONTH=date.month

DAY=date.day

backup "/oraLB/ts/backupset/$YEAR_$MONTH_$DAY/\*"

outputs command like backup "/oraLB/ts/backupset/2018_06_04/*"

[Bruce_Clegg]

I can do this from the gui?

[Michal_Mikulik1]

Hello,

with variables defined, you can either run user-launched backups from client side:

bpbackup <parms> "/oraLB/ts/backupset/$YEAR_$MONTH_$DAY/\*" (you must have policy with User Schedule defined)

or, you can directly update a policy before you run a scheduled backup:

bpplinclude <policy> -modify <path> (client must be in Master Srv "Servers" to achieve this)

Well, dont you have Oracle Agent license to backup Oracle dbs directly to Netbackup? This way of backup is error-prone and overcomplicated.

Regards

Michal