Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!mips!cs.uoregon.edu!ogicse!milton!uw-beaver!zephyr.ens.tek.com!tektronix!sequent!mac
From: mac@sequent.UUCP (Cormac Burke)
Newsgroups: comp.databases
Subject: Re: ORACLE: Backup suggestions wanted
Message-ID: <55524@sequent.UUCP>
Date: 18 Mar 91 22:32:19 GMT
References: <1991Mar12.134145.15364@maytag.waterloo.edu> <559@genco.bungi.com>
Reply-To: mac@sequent.UUCP (Cormac Burke)
Distribution: na
Organization: Sequent Computer Systems, Inc
Lines: 17

In article <559@genco.bungi.com> rad@genco.bungi.com (Bob Daniel) writes:
>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? 
>
>If the database is shutdown, the backup of $ORACLE_HOME directory is sufficient.


I'd be careful of this. There's no guarantee that this will back up
all of your datafiles. I'd suggest querying the system catalogs first
to check what your data files are (select file_name from sys.dba_data_files;).
This can be particularly relevant if you're using raw disk partitions.
Cormac Burke
Sequent Computer Systems