Veritas-bu

[Veritas-bu] Database backup scheduling with different retent ions

2006-01-19 15:53:42
Subject: [Veritas-bu] Database backup scheduling with different retent ions
From: Mark.Donaldson AT cexp DOT com (Mark.Donaldson AT cexp DOT com)
Date: Thu, 19 Jan 2006 13:53:42 -0700
Oops, wrong again.  There's three different "Automatic backup" choices in
the pulldown, full, diff & incr.  The NB_ORA_CINC & NB_ORA_INCR must be
changed in these choices.  Not future implementation, it's current
implemention.

-M

-----Original Message-----
From: Donaldson, Mark - Broomfield, CO 
Sent: Thursday, January 19, 2006 1:39 PM
To: 'Austin Murphy'; veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] Database backup scheduling with different
retent ions


Our DBA's determine in their RMAN script which type of backup they want,
incr, full, etc. This do this themselves based on day of week (fulls on
weekends, etc.).  They have a case statement & just set the NB_ORA_SCHED
variable appropriately.

If you want to do this via Netbackup's scheduling, then I think you could do
this with a single policy with three "trigger" (Automatic Full Backup)
schedules (these call the rman backup script).  Each trigger schedule gets a
unique schedule, frequency, etc., or course.

The trigger schedule name is passed into the RMAN script as the
NB_ORA_PC_SCHED variable, no need to mine logfiles to find it. 

So, your RMAN code would contain:

case $NB_ORA_PC_SCHED in
schedname1 ) NB_ORA_SCHED="Monthly" ;;
schedname2 ) NB_ORA_SCHED="Yearly" ;;
schedname3 ) NB_ORA_SCHED="Daily" ;;
esac

Of course, change the above to fit your environment but the logic is
probably useful.  The policy name is sent into the script using the
NB_ORA_POLICY variable, by the way, so there's no need to set this.  

The variable list from my test is:
NB_ORA_CINC=0
NB_ORA_CLASS=<policy name>
NB_ORA_CLIENT=<client name>
NB_ORA_FULL=1
NB_ORA_INCR=0
NB_ORA_MODE=B
NB_ORA_PC_SCHED=<trigger schedule name>
NB_ORA_POLICY=<policy name>
NB_ORA_SCHEDULED=1
NB_ORA_SERV=<master server name>

The NB_ORA_CINC & NB_ORA_INCR seems strange - there's no current
full/diff/cumu setting in the trigger schedule's setup.  Perhaps this is for
future use?

Just build a policy with three "Automatic Full Backup" schedules to call
your script and three different "Application Backup" schedules to receive
the data and you're set.

HTH - M


-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]On Behalf Of Austin
Murphy
Sent: Thursday, January 19, 2006 12:49 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] Database backup scheduling with different
retent ions


Thanks!  That Veritas article addressed half of my problem and it
opened up a new line of inquiry.  In the middle of it was this line:

  # Determine which schedule should receive the backup images.

Yes! exactly! but how?!

I saw "bphdb" somewhere and I remembered it had a log... on the
client.  In the log was this little gem:

NB_ORA_PC_SCHED

which gets set with the CALLING "Automatic Backup" schedule name. 
This should be sufficient to solve my problem!  I'll setup a little
logic in the RMAN script that chooses the correct "Application Backup"
schedule based on the above variable and submit it to RMAN as stated
in the Veritas article.

I'll post results once I have it working.

Austin


On 1/19/06, Mark.Donaldson AT cexp DOT com <Mark.Donaldson AT cexp DOT com> 
wrote:
> The RMAN script can specify two variables, NB_ORA_POLICY & NB_ORA_SCHED.
>
> To direct a rman backup to a specific schedule in a policy, just set the
> latter.
>
> Just found this from Veritas:
> http://seer.support.veritas.com/docs/261087.htm
>
> They're answering just this question.
>
> -M
>
> -----Original Message-----
> From: veritas-bu-admin AT mailman.eng.auburn DOT edu
> [mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]On Behalf Of Hampus 
> Lind
> Sent: Thursday, January 19, 2006 10:56 AM
> To: 'Whelan, Patrick'; Mark.Donaldson AT cexp DOT com; austin.murphy AT gmail 
> DOT com;
> veritas-bu AT mailman.eng.auburn DOT edu
> Subject: SV: [Veritas-bu] Database backup scheduling with different
> retentions
>
>
> Hi guys,
>
> Can you have several, different "application backup" scheds in the same
> policy? Dosen`t netbackup take the first listed and use it for all backups
> within that policy?
>
> If I write the policy and sched into the oracle backup script will it work
> with all the scheds? Do I need to make some kind of scripting (IF and ELSE
> and so on) into the script to make it work?
>
> Today we have one policy per retention, it`s a mess, but we haven`t got
this
> to work earlier.
>
> Many thanks,
>
> MVH / Hampus Lind

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu