Re: recovery method

[Quoted] The customer doesn't care that much about this database and he's told you he [Quoted] can lose a day's data. If you have a crash, just do a restore from the [Quoted] previous night's tape. You are doing a cold backup every night, right?

[Quoted] Brian Yan <by2_at_gpu.srv.ualberta.ca> wrote in message news:375DCC86.61FA_at_gpu.srv.ualberta.ca...
> 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
>
Received on Thu Jun 10 1999 - 01:46:25 CEST