Re: recovery method

From: Heidi & Ron <herobe_at_gelrevision.nl>
Date: Fri, 11 Jun 1999 11:20:41 +0200
Message-ID: <7jqkec$2pbl$1@thor.wirehub.nl>

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
Received on Fri Jun 11 1999 - 04:20:41 CDT