Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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:
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
![]() |
![]() |