Re: A question on Block recovery

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 29 Aug 2007 12:04:48 -0700
Message-ID: <bf46380708291204ve605c83o4e0e53f2e18f4b8b@mail.gmail.com>

On 8/29/07, Anurag Verma <anuragdba_at_gmail.com> wrote:
>
>
> When we do the block recovery to fix block corruption, do the affected
> datafile need to be taken OFFLINE?
>
> Or will the datafile be unavailable to the users during the block
> recovery?
>
>

I've done this a few times on 9.2.0.7.

The database files do not have to be taken offline.

A very cool feature. It slows the db down a bit, but the only users that may see
a problem are those that hit the bad block(s).

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 29 2007 - 14:04:48 CDT