Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Recovery question
HI, You have to copy only DATAFILES FROM YOUR BACKUP.( DO NOT COPY CONTROL FILE ) . Once copied, then
svrmgrl
connect internal
startup mount
set autorecovery on
recover database... ( This will bring your database in sink as if on the
day it failed...
but please remember that you have to have all ARCHIVE_LOG FILES and
redo_log_files as well..other wise you have to do INCOMPLETE RECOVERY )
Hope this Helps
VIjay K Banda
Robin Bishop <rmb8_at_bton.ac.uk> wrote in article
<01bd9ad2$263ec720$4baa3ec1_at_regan.bton.ac.uk>...
> I imagine this happens because the control file is in sync with the data
> file headers when a 'consistent' offline backup is performed. My
> understanding is that you need to restore the data files (and redo logs)
> from the backup but keep the control file from the time of the crash.
That
> way Oracle knows the database is inconsistent and can roll forward to the
> point in time recorded in the control file.
>
> I'd be interested to know the outcome, since I am planning to run some
> tests of this nature myself when I have a backup machine I can crash
> without risk to my production database!
> --
> Robin Bishop
> University of Brighton Computer Centre
>
> Gilberto Casiraghi <edipi_at_candy.it> wrote in article
> <3584F996.41C0DC9B_at_candy.it>...
> <snip>
> >after I start (mount) the db and I give the 'recover database'
> > command the system return this error: ORA-00264: no recovery required.
> > (maybe becouse the weekly backup is consistent !)
> >
> > How is it possible to recover the database till the last saved redo
> > log ?
>
Received on Thu Jun 18 1998 - 14:42:14 CDT