I want multiple Backup Policies in a single class - using only 1 input
script (i use RMAN to backup databases, these are regularly restore to
different machines).
I no that al lthe suggested workarounds are based around having multiple
input scripts, but as we restore very frequently, the danger of restoring to
wrong place is not worth the hassle.
I find multiple Netbackup classes/schedules easier to manage, but cannot see
ehy NetBackup is so bad at dealing with Backup Policies/params passed to it
from scripts...
This is why i want different policies within the same classes -
Monday thru Friday - weekly retention - stay onsite
Saturday - weekly retention to different pool - for offsiting
Sunday - monthly retention to different pool - for offsiting
------------------------------------------------------------
Well, i tested this over the weekend, and - it doesn't work properly. I
basically changed my backup class to include 3 backup policies, with
associated automatic schedules.
All i want to do is have the backup run monday thru friday - with a weekly
retention; then on a saturday - weekly retention, but different pool for
offsiting; on sunday - monthly retention, again for offsiting - Should be
easy with Netbackup - after all, scheduling should be a major feature for a
backup product.
------------------------------------------------------------
Here's the output from 'bpsched -predict', which i long ago found to be a
tad unreliable --->
# bpsched -predict 06/21/2002 03:00:00 | grep _e450 | grep PR
0 vtnthe450 CL_PRODDB_D_e450 DailyFull FULL Friday 03:00:00
# bpsched -predict 06/22/2002 03:00:00 | grep _e450 | grep PR
0 vtnthe450 CL_PRODDB_D_e450 WeeklyFull FULL Saturday 03:00:00
# bpsched -predict 06/23/2002 03:00:00 | grep _e450 | grep PR
3 vtnthe450 CL_PRODDB_D_e450 MonthlyFull FULL Sunday 03:00:00
# bpsched -predict 06/24/2002 03:00:00 | grep _e450 | grep PR
0 vtnthe450 CL_PRODDB_D_e450 DailyFull FULL Monday 03:00:00
------------------------------------------------------------
And the proof of the pudding is here -->
See that Saturday onwards keeps using the Weekly schedule.
MONDAY 06/24/2002 03:00:00
CL_PRODDB_D_e450 SCH_PRODDB_W 06/24/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/24/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/24/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/24/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/24/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/24/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/24/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/24/2002
CL_PRODDB_D_e450 DailyFull 06/24/2002
SUNDAY 06/23/2002 03:00:00
CL_PRODDB_D_e450 SCH_PRODDB_W 06/23/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/23/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/23/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/23/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/23/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/23/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/23/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/23/2002
CL_PRODDB_D_e450 MonthlyFull 06/23/2002
SATURDAY 06/22/2002 03:00:00
CL_PRODDB_D_e450 SCH_PRODDB_W 06/22/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/22/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/22/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/22/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/22/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/22/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/22/2002
CL_PRODDB_D_e450 SCH_PRODDB_W 06/22/2002
CL_PRODDB_D_e450 WeeklyFull 06/22/2002
FRIDAY 06/21/2002 03:00:00
CL_PRODDB_D_e450 SCH_PRODDB 06/21/2002
CL_PRODDB_D_e450 SCH_PRODDB 06/21/2002
CL_PRODDB_D_e450 SCH_PRODDB 06/21/2002
CL_PRODDB_D_e450 SCH_PRODDB 06/21/2002
CL_PRODDB_D_e450 SCH_PRODDB 06/21/2002
CL_PRODDB_D_e450 SCH_PRODDB 06/21/2002
CL_PRODDB_D_e450 SCH_PRODDB 06/21/2002
CL_PRODDB_D_e450 SCH_PRODDB 06/21/2002
CL_PRODDB_D_e450 DailyFull 06/21/2002
NOW - the only thing that 'MIGHT' be wrong here - maybe each backup policy
only NEEDS to specify the actual days that are required. I know that a
policy has to have 24 hours (00:00:00 thru 24:00:00 set, but am not sure
whether this should be for a whole week, or JUST the days in question)....
I've amended policies to omit the days not needed, but have to wait 'til the
weekend to try it out..
Regards
Richard Bannister
Unix Systems Administrator
Vartec Telecom Europe
|
