Re: recovery method

Actually, based on the later posting of needing hot backup, Brian can't stop archive logging.

HTH. Pete

Heidi & Ron wrote:

> Hi Brian,
>
> If it's OK to lose one day and you backup every night you can stop archive
> logging.
> To make a good backup you have to shutdown the database in normal mode and
> then backup the datafiles online redologfiles and controlfiles.
>
> Good luck Ron.
>
> 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

--

Regards

Pete

Received on Fri Jun 11 1999 - 11:57:29 CDT