Prev: Problems with a Trigger
Next: Easy Way To Get Google Adsense Account Approval.
From: zigzagdna on 22 May 2010 22:02
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?

THANKS A LOT.
From: zigzagdna on 22 May 2010 23:01
On May 22, 10:02 pm, zigzagdna <zigzag...(a)yahoo.com> wrote:
> 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?
>
> THANKS A LOT.

Oracle version 11.1 on HP u ix 1i
From: Michel Cadot on 23 May 2010 02:54

"zigzagdna" <zigzagdna(a)yahoo.com> a �crit dans le message de news:
87274fd2-8bd1-4131-99ee-9ba5075c6be3(a)w3g2000vbd.googlegroups.com...
|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?
|
| THANKS A LOT.

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.

Regards
Michel


 | 
Pages: 1
Prev: Problems with a Trigger
Next: Easy Way To Get Google Adsense Account Approval.