Re: Corrupted empty blocks

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 22 Feb 2005 10:24:34 -0800
Message-ID: <1109096674.740625.47750@c13g2000cwb.googlegroups.com>

snip

> 2. During the rman backup a few blocks was signalled corrupted.
> dbv also signalled corrupted blocks on one file.
> I think that blocks are empty blocks and notes on Metalink suggest no
> problem.
> But - is that really no problem?

Sorry only you and oracle support can tell us what is really the problem.

You can use the RMAN "backup validate check logical database" command ... (doesn't take a backup).

Then you can query against v$database_block_corruption and/or v$backup_corruption views ... (identifying blocks).

RMAN at your release level can fix the corrupted blocks (probably ... test on a test system first). The command "blockrecover corruption list" may be what you want.

Research it and before doing anything unfamiliar/untested by you work with oracle support until you understand situation. Received on Tue Feb 22 2005 - 12:24:34 CST