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

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: