Re: recovery method

Brian Yan wrote:

> Hi there, I just took over a very bad designed oracle database (7.1) on
> SCO unix box. There is only one physical disk. Everything (datafile,
> log, archived log, control file) is in one directory. Customer has no
> plan to upgrade the hard disk. The database is run under archivelog
> mode. It is O.K. to lose one day data. Currenly, we have all on-line
> datafile backup and archived log backed to tape every night. I am
> wondering in the case of disk failure, can I just copy all the datafile
> plus the archived logs to the same directory as before (assumed server
> directories have been restored to the image before crash)? then startup
> database, run the recover command? I am very new on oracle recovery. Any
> suggestion would be very much appreciated. Thank you in advance.
>
> Brian Yan

if you want to recover, such that you don't lose an entire day's worth of changes, you can backup the archive log files (to tape) periodically during the day (say, every hour or so). Received on Thu Jun 10 1999 - 11:11:48 CDT