Here's an idea.
First of all, I assume you are using plain vanilla netbackup, no RMAN.
That's
what it sounds like.
Add the arch directory to the list of directories to exclude.
Create a SQL script to create a list of files in the arch directory to
backup. I won't
supply details, cuz I know you're perfectly capable of doing it yourself.
:)
Modify or create the bpend_notify script for the correct backup policy,
then use
the bpbackup command with the generated list of files to backup the
archive logs.
Use bparchive if you want the files deleted following a successful backup.
HTH
Jared
"JOE TESTA" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/19/2002 07:50 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
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).
