Veritas-bu

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

2006-01-19 14:49:09
Subject: [Veritas-bu] Database backup scheduling with different retent ions
From: austin.murphy AT gmail DOT com (Austin Murphy)
Date: Thu, 19 Jan 2006 14:49:09 -0500
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