Veritas-bu

Re: [Veritas-bu] Another bpstart, oracle and streams question

2008-02-01 05:44:42
Subject: Re: [Veritas-bu] Another bpstart, oracle and streams question
From: Dave Markham <dave.markham AT fjserv DOT net>
To: Jeff Lightner <jlightner AT water DOT com>
Date: Fri, 01 Feb 2008 10:24:14 +0000
Im no rack expert but the DBA's have said they need that file backing 
up. As its a sym link to a raw slice im doing it via dd and the block 
size they recommend.

Im not sure if the rman job can actually do it as it may not be part of 
the DB that Rman hooks into.

Its only a 256mb file so i dont think it would harm to back it up if you 
are unsure.

Are the STREAMS issue, im actually thinking what i want may be a bit 
easier than running a hot oracle backup.

I just need this job to run once so coulndt if do an if statement 
something like below :-

if [ $STREAM = 1 ]
then
do the checks and dd etc
fi

This would then hold the first stream until the dd job had finished and 
then back it up.

Hmm one issue i guess is i need to make sure the stream im checking for 
is the same stream as the file system the voting disk will be backed up to.

Does anyone have confirmation of the STREAM variables passed to 
bpstart_notify ??

cheers


Jeff Lightner wrote:
>
> Curious about this thread – so far as I know we’re not doing anything 
> special for backing up voting disk and OCR for Oracle RAC (unless the 
> DBAs somehow set this up via RMAN to the policies we created in NBU). 
> Is this something we should be doing?
>
> ------------------------------------------------------------------------
>
> *From:* veritas-bu-bounces AT mailman.eng.auburn DOT edu 
> [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] *On Behalf Of *Ed 
> Wilts
> *Sent:* Thursday, January 31, 2008 10:50 AM
> *To:* dave.markham AT fjserv DOT net
> *Cc:* veritas-bu AT mailman.eng.auburn DOT edu
> *Subject:* Re: [Veritas-bu] Another bpstart, oracle and streams question
>
> The short answer is: don't even try if you have multiple disks. You 
> *may* be able to get away with it now using the parent/child job 
> functionality that got added in 6.0 but we haven't tested this, having 
> given up on a long time ago after a multi-year battle.
>
> Sure, you can get it work most of the time, and many people do. 
> However, there are many, many edge cases where this will break down, 
> and if you do go down this route, you'll find some them eventually. 
> You'll find cases where the bpstart didn't run or the bpend didn't 
> run, or they'll run twice.
>
> We definitely had a really, really bright guy working on the 
> bpstart/bpend scripts and he could not solve the problem so that it 
> was 100% reliable. We simply wanted to put Oracle into hotbackup mode, 
> do the backups, and take it out of hotbackup mode. Like you said, 
> you'll be writing some logic around it. However, you'll be writing and 
> writing and writing, tweaking it regularly as you run into all of the 
> edge conditions and you'll cuss and swear as you stumble over them. 
> Bottom line: it can't be done reliably.
>
> Use a different method of coordinating this.
>
> .../Ed
>
> On Jan 31, 2008 8:57 AM, Dave Markham <dave.markham AT fjserv DOT net 
> <mailto:dave.markham AT fjserv DOT net>> wrote:
>
> Guys im running Netbackup 6.0mp4 and a number of oracle SSO media
> servers backing themselves up. Solaris9/10
>
> This has been mentioned before many times im sure and i found a thread
> on it called 'Yet another bpstart/bpend questions' but i dont have a
> copy of it to reply to.
>
> Basically as im running a UNIX backup (forget oracle for the moment) and
> we have multistreams set and all_local_drives directive, a
> bpstart_notify script we have which does this (there are extra checks
> etc also):-
>
> dd if=/path/to/votedsk1 of=$STAGING/votingdisk bs=4k >/dev/null 2>&1
>
> ..is obviously running on each stream which is kicked off.
>
> I just need it to run once.
>
> There was talk about the bpstart script taking a STREAMS parameter but
> it doesnt say so within the /opt/openv/netbackup/bin/goodies version so
> can anyone confirm there are STREAMS variables passed to it?
>
> I was thinking ( perhaps like many people ) to create some lock file and
> then remove it. This leads to all sorts of issues regarding streams
> restarting, certain ones finishing before others etc and so i'd need to
> create some good logic around it.
>
> What are people doing in the wild?
>
> I just need the above command to run once per backup.
>
>
>
> -- 
> Ed Wilts, Mounds View, MN, USA
> mailto:ewilts AT ewilts DOT org <mailto:ewilts AT ewilts DOT org>
>

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

<Prev in Thread] Current Thread [Next in Thread>