RE: BackupExec & Oracle

we use backupexec 8.6 and it does not lock oracle files on NT4 or win2k.

if u use the purge options and create a archivelog purge job and u hv some antivirus s/w like norton, then the access times get messed up and backupexec is not able to pick up files properly.

netbackup uses rman/ebu. backupexec does not use rman/ebu. it has its own oracle agent which puts tablespaces in backup mode and takes them out.

pretty reliable and i hv tested out the recoveries. a scheduled windows

u just need to make sure that admins keep enough tapes in the dlt's. the only problems i face is that the backup job is waiting for more tapes.

the only drawback is commandline and reporting aspect. in netbackup on unix i could use available_media script and find out how much is the tape used. i hv yet to figure this out in backupexec.

-Mandar

> -----Original Message-----
> From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com]
> Sent: Monday, November 25, 2002 12:52 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: BackupExec & Oracle
>
>
> If you're using BackupExec to backup the server's filesystems
> as well as the
> Oracle DB, make sure it does NOT hit your database files
> directly. Some
> Winders admins don't understand that it'll lock the datafiles, redos,
> controlfiles, etc from the instance, causing all sorts of
> icky recovery
> scenarios.
>
> At least a few years ago, it locked them under NT 4.0. I
> don't know if this
> behavior has changed (or is possible to change under NuTFutS) in newer
> versions.
>
> Good luck! :)
>
> Rich
>
>
> Rich Jesse System/Database Administrator
> Rich.Jesse_at_qtiworld.com Quad/Tech International,
> Sussex, WI USA
>
>
> -----Original Message-----
> Sent: Monday, November 25, 2002 2:12 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hello Everyone!
> I found out on Friday that my backup strategy has been NULL
> AND VOID out in
> Las Vegas. (Read: Nothing has been written to tape lately.
> Thanks, Guys)
> I was also notified that "effective immediately" Veritas
> BackupExec is the
> software we are using.
> Any gotchas/experiences/comments from people who have used
> Backup Exec and
> the associated Oracle utility? Do you trust BackupExec to
> fire your rman
> backups, complete correct rman restores, etc.? I have shied away from
> writing directly to tape in the past but don't have the
> luxury of disk for
> rman backups anymore.
> I'm on Windows 2000 sp2, Oracle version 8.1.7.2
> Any comments are appreciated. Thanks
> Lisa Koivu
> Oracle Database Monkey and Terrible Perl Coder.
> Fairfield Resorts, Inc.
> 5259 Coconut Creek Parkway
> Ft. Lauderdale, FL, USA 33063
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.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).
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar A. Ghosalkar
  INET: mghosalk_at_byer.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).