Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Backup options (including Arcserve Agent for Oracle)?

Backup options (including Arcserve Agent for Oracle)?

From: Frank Burleigh <burleigh_at_indiana.edu>
Date: Sat, 09 Jun 2001 15:45:15 -0500
Message-ID: <3B228ADB.6000409@indiana.edu>

We are buying new server hardware and converting from Sybase to Oracle 8i/9i in the very near future. Our environment will be Intel servers with Win2000 Server, Arcserve 2000 for backup, and RAIDed drives. Our database consists mainly of our alumni and current students. My Sybase backup routine is an automated (nightly) DUMP of the database to a file on the file system which then goes to tape via the Arcserve NT agent. I had to restore once--because of drive failure (no RAID on that box).

My question is this: what are opinions on the best way to backup in a situation like ours? My initial inclination is to use the "hot" approach outlined in Loney's book: it is similar to what we do now and is fairly straightforward to implement. But without Oracle experience, I thought I should ask for other data points.

Also, Arcserve sells an Oracle agent, but it isn't quite clear to me what its advantage would be over this "hot" (archivelog) method. They claim to work at the logical level rather than with file objects, but I don't immediately see what that gets me other than--maybe?--not having to script the backup process.

-- 
Frank Burleigh
Indiana University School of Law
burleigh_at_indiana.edu
Received on Sat Jun 09 2001 - 15:45:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US