Re: [Networker] sybase and oracle backups

At 06:06 PM 10/11/02 , Byron Servies wrote:

On October 11, 2002 at 17:01, Chad R. Larson wrote:
> At 01:05 AM 10/11/02 , VERHAEGHE Koen (BMB) wrote:
> >You might want to take a look at BMC's SQL-Backtrack. Does sybase and
> >oracle backups, UNIX or NT, full and incrementals, on-line or off-line,
> >and to disk or to tape. We just bought an enterprise license and are
> >moving away from RMAN and exports to disks.
>
> For what it's worth, we're using PostgreSQL.  It supports hot backups
> without any external help.

So do oracle and sybase (and informix for that matter), and with
much greater flexibility than postgres (which is an all or nothing
SQL dump of the database or table).  What they are discussing
here is a different kind of networker integration with a product
that provides a plethora of options, not basic functionality.

Byron


I think your information might be a bit old.  He listed "full and
incrementals, on-line or off-line, and to disk or to tape".  All of which
PostgreSQL can do without external help.  In my last job, we used Informix
for some very large databases (like the Hilton Hotels reservations system)
and couldn't do hot backups without helper software.  We used the Veritas
NetBackup XBSA module with Informix ONBAR.

I understand Oracle recently adopted the PostgreSQL approach of a
Multi-Version Concurrency Control (MVCC) to avoid read lock collisions,
which is what makes the hot backups possible.

The only fancy trick we could do with Informix that PostgreSQL can't is
point-in-time recovery, which is supposed to be in the next release.

Plus, dumps aren't limited to SQL (check the COPY FROM statement), and you
can dump and load schema's or rows or tables independently if you like.



        -crl
--
Chad R. Larson (CRL22)    chad AT eldocomp DOT com
  Eldorado Computing, Inc.   602-604-3100
     5353 North 16th Street, Suite 400
       Phoenix, Arizona   85016-3228

--
Note: To sign off this list, send a "signoff" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=