Re: Empty pages marked corrupt

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 23 May 2010 08:54:21 +0200
Message-ID: <4bf8d11e$0$26639$>

"zigzagdna" <> a écrit dans le message de news:
|I run rman and it shows some blocks as corrupted; when I run dbv all
| the blocks corrupt show under empty pages.
| When I do
| select * from dba_extents
| where file_id = 25 and
| corrupt_block_no between block_id and block_id+blocks-1
| all corrupted blocks are in a table which is empty (0 rows).
| I dropped the table , recreated it, but these blocks still come out as
| corrupt.
| Will these empty pages corruption create any problems for me in
| future?
| How can I get rid of them, rman recoverblock somehow is not working
| for me?
It does not matter if these now do not belong to any object as they will be reformatted when they will be allocated to an object.

Michel Received on Sun May 23 2010 - 01:54:21 CDT

Original text of this message