Oracle-L: RE: BackupExec & Oracle

From: Gary Weber <gweber_at_charlesjones.com>
Date: Mon, 25 Nov 2002 11:56:10 -0800
Message-ID: <F001.0050B2CC.20021125115610@fatcity.com>

BackupExec & OracleLisa,

One of our database servers is identical to your setup - Win2K/8.1.7.2/Veritas BackupExec. You'll need to create an Oracle user in each database for Veritas to connect to instances and know what tablespaces/datafiles there. Only gotcha is the fact that this new user will need to have some low level privs in order to be effective. You would then setup Veritas Oracle Agent to backup your databases, one by one. Then within Veritas Backup Manager you could create Oracle jobs (backup AND restores) manually, or rely on wizard. Either way has proven to work well for our two Win2K boxes. Not using RMAN though.

Gary Weber
Senior DBA
Charles Jones, LLC||Superior Information Services, LLC 609-538-1000, ext 5529

-----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: Gary Weber
INET: gweber_at_charlesjones.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 Mon Nov 25 2002 - 13:56:10 CST