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

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
a problem are those that hit the bad block(s).

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: