Re: So, did I do good? (Did my first Oracle recovery, seems good... thoughts?)

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3f7d32dd$0$8766$ed9e5944_at_reading.news.pipex.net...
> "Thomas T" <T_at_T> wrote in message news:3f7c86ef$1_at_rutgers.edu...
> > (..snip..)
> > What would've happened if that file -was- corrupted due to a bad sector
on
> > the drive? Would Oracle tell me that it couldn't apply logs?
> >
> > My worry was that Oracle patched up a corrupt file, and would fail again
> > when it tried to read the bad area (example, hard drive sector).
>
> Oracle reports corrupt blocks (in the alert.log). There is also a tool
DBV,
> or DBVerify or something similar the name might vary on netware, that will
> check your datafiles for things such as bad blocks.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK

Thanks! There weren't any reports in the alrtorcl log. What's fun is there weren't any reports in the Novell abend.log either (as to the crash). Go figure. I'll look into the dbverify utility (yes, it's dbv.nlm on Netware).

-Thomas Received on Fri Oct 03 2003 - 10:58:17 CDT