Oracle-L: Re: kinda OT: veritas netbackup

From: <Jared.Still_at_radisys.com>
Date: Thu, 19 Dec 2002 10:04:38 -0800
Message-ID: <F001.0051E99B.20021219100438@fatcity.com>

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" <JTESTA_at_longaberger.com>
Sent by: root_at_fatcity.com
12/19/2002 07:50 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        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: Jared.Still_at_radisys.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). Received on Thu Dec 19 2002 - 12:04:38 CST