RE: BackupExec & Oracle

[Gary Weber]

Title: BackupExec & Oracle

Lisa,

 

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-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, Lisa
Sent: Monday, November 25, 2002 2:12 PM
To: Multiple recipients of list ORACLE-L
Subject: BackupExec & Oracle

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