Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 2 questions: data block corruption + good oracle troubleshoooting sites

Re: 2 questions: data block corruption + good oracle troubleshoooting sites

From: Jose Aragao <ubik_at_hotvoice.com>
Date: Thu, 29 Mar 2001 14:18:15 GMT
Message-ID: <HuHw6.89$qh3.1885@nreader2.kpnqwest.net>

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

--

jpa
Received on Thu Mar 29 2001 - 08:18:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US