Path: utzoo!news-server.csri.toronto.edu!cs.utexas.edu!usc!apple!uokmax!occrsh!fang!att!drutx!druco!mdeltoro From: mdeltoro@druco.ATT.COM (DeltoroMA) Newsgroups: comp.databases Subject: Re: ORACLE: Backup suggestions wanted Message-ID: <7832@drutx.ATT.COM> Date: 13 Mar 91 21:42:21 GMT References: <1991Mar12.134145.15364@maytag.waterloo.edu> Sender: news@drutx.ATT.COM Distribution: na Lines: 22 in article <1991Mar12.134145.15364@maytag.waterloo.edu>, psalvini@maytag.waterloo.edu (Paul Salvini) says: > > 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 you just want to backup the database use Oracle's Import/Export facilities. I would run a job (via cron - if you are using unix) that will export the appropriate data from the database. If you ever need to restore it then use import. -- ********************************************************************** Michael 'DT' Del Toro 303-538-1764 AT&T Bell Labs, Denver, CO mdeltoro@druco.COM.ATT