Re: recovery method

Brian

Even though you may be new to Oracle recovery, at least you've recognized the bad design!

This database is simply not recoverable except to the last backup in the case of media failure. If you lose the disk, you lose the archived log files and so can't roll forward. Two options:

1. Archive to tape
2. Archive to floppy (crazy, but I've had to do it once).

Otherwise, all the archiving is protecting is against user error, where you want to recover to a point in time prior to users dropping tables or deleting information by mistake.

HTH. Pete

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

--

Regards

Pete

Received on Wed Jun 09 1999 - 11:04:48 CDT