Re: A question on Block recovery

On 8/29/07, Anurag Verma <anuragdba@xxxxxxxxx> 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

Other related posts: