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