Re: Block corruption on an index datafile

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: Lu.Jiang@xxxxxxxxxxxx
  • Date: Thu, 15 Dec 2011 08:10:46 -0800

On Mon, Dec 12, 2011 at 11:49 PM, Jiang, Lu <Lu.Jiang@xxxxxxxxxxxx> wrote:
> I have fixed this issue with blockrecover command ^_^
Nice save.

Did it take much time to apply this?

I used it once a few years ago - it worked fine, but IIRC it took
quite awhile. A lot of the time could have been overhead to locate
the file on tape, and then located the correct bit of the backup file
(20g pieces)

Seems like it took an hour or so.

Fortunately it was a rarely accessed block.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog:
Home Page:


Other related posts: