06-04-2018 08:23 AM
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?
06-04-2018 08:56 AM
06-04-2018 10:51 AM
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>'/*
06-04-2018 11:29 AM
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/*"
06-04-2018 02:57 PM
I can do this from the gui?
06-05-2018 04:44 AM
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