Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: 2 questions: data block corruption + good oracle troubleshoooting sites
Howard J. Rogers <howardjr_at_www.com> wrote in message
news:3ac25038_at_news.iprimus.com.au...
> If you are in archivelog mode, shutdown, restore the system data file,
mount
> the database, and tell it to 'recover database'. Complete recovery will
> then take place, and not a record will have been lost (except anything
that
> was uncommitted, of course). If you don't have archives, shutdown, blow
> everything away, and restore the entire set of datafiles, redo logs and
> control files from backup. And yes, at that point you've lost potentially
> lots of data.
>
> HJR
>
Thank you very much...
-- jpaReceived on Thu Mar 29 2001 - 08:18:15 CST
![]() |
![]() |