Re: A question on Block recovery

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: anuragdba@xxxxxxxxx
  • Date: Wed, 29 Aug 2007 12:04:48 -0700

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: