Path: utzoo!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!elroy.jpl.nasa.gov!ames!vsi1!daver!genco!rad
From: rad@genco.bungi.com (Bob Daniel)
Newsgroups: comp.databases
Subject: Re: ORACLE: Backup suggestions wanted
Message-ID: <559@genco.bungi.com>
Date: 13 Mar 91 15:47:08 GMT
References: <1991Mar12.134145.15364@maytag.waterloo.edu>
Reply-To: rad@genco.bungi.com (Bob Daniel)
Distribution: na
Organization: Gentry & Assoc. Excelsior Springs, MO
Lines: 14

In article <1991Mar12.134145.15364@maytag.waterloo.edu> psalvini@maytag.waterloo.edu (Paul Salvini) writes:
>We at Wilfird Laurier are looking for suggestions on how to backup
>our ORACLE databases efficiently and with as little interruptions as
>possible. 
>
>So... How do you do it? 
>  - we have done cpio and hdumps and would like suggestions to other
>alternatives or scripts that you might be using.

If the database is shutdown, the backup of $ORACLE_HOME directory is sufficient.
Also, an export of the entire database before a backup is a safety net.  We
do both.  I have a tape autobackup script setup to occur overnight.  First,
it exports the entire database, then shutdown the database, then backs up
the entire system (or it may be an incremental backup).