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:[EMAIL PROTECTED]]
*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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
