Re: recovery method

In article <z7D73.1550$CG.58953_at_typ31b.nn.bcandid.com>,   "Van Messner" <vmessner_at_netaxis.com> wrote:
> The customer doesn't care that much about this database and he's told
you he
> can lose a day's data. If you have a crash, just do a restore from
the
> previous night's tape. You are doing a cold backup every night,
right?

Thank you for your help. I can't do a cold backup every night. Although losing one day's data is acceptable, the database has to be on 7x24. So I do hot backup everyday. But in the case of disk crash, all I have is from previous day's tape, which are the tablespace datafile, control file, on-line redo logs and archived logs. I am wondering what is the proper recovery strategy provided I only have previous day's datafile, control file, on-line and archived logs (all these are from a hot backup). I read Oracle 7 documentation, but can't find a way that really fit into my case. Please help me!

Thanks a lot.

Brian

>
> 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
> >
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jun 10 1999 - 12:49:02 CDT