Re: kinda OT: veritas netbackup

Kevin, i think thats exactly what we're going to end up doing.

thanks for the verification.

joe

Kevin Lange wrote:

> How about running a script just before the backup that
> 1) Reads the current log number.
> 2) Forces a log switch.
> 3) Copies the logs to a seperate directory.
> 4) Backups up that seperate directory
>
> Leave the archive directory alone. Do not back it up.
>
> -----Original Message-----
> *From:* JOE TESTA [mailto:JTESTA_at_longaberger.com]
> *Sent:* Thursday, December 19, 2002 9:50 AM
> *To:* Multiple recipients of list ORACLE-L
> *Subject:* kinda OT: veritas netbackup
>
> RESEND: never saw it get posted:
>
> Can we force veritas netbackup (HPUX) to NOT backup open files?
>
> Here is the problem: while arch process is writing out archive
> logs, the netbackup script that backs up the arch directory will
> write a partially written log to tape, we're trying to avoid that.
>
> is our only alternative determine(out of data dictionary) how many
> log groups we have and assuming 3, that if we take the max log
> seq# minus the numebr of groups we have, gives us the oldest log
> that we can be sure is complete?
>
> ie: current log is 543, we have 3 log groups, 543-3 = 540, since
> oracle wouldnt start overwriting # 540 until it was successfully
> archived, that we can back up, up thru log seq# 540 and can be
> sure # 540 is complete?
>
> thanks, joe
>
>

-- 
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).