Rman and DBVerify notice many corrupted blocks in SYSAUX
Our backup failed due to the message ORA-19566: exceeded limit of 0 corrupt blocks for file
+DATA/hora/datafile/sysaux.261.811931827 ,When checking with dbverify it marked 3408 pages as corrupt. When I run rman backup validate datafile 3 it only showed one and another dbverify decreased the number of pages to 3407.
According to alertlog the corrupted blocks were repaired but another dbverify-run still shows 3407 pages marked as corrupt.
V$database_block_corruption shows only 1 row.
I can check what's in those blocks but that will take a while as SYSAUX is 1,4GB with autoextend on, so the 1,4GB is filled up. ;-)
Anyone some other clue?
According to alertlog the corrupted blocks were repaired but another dbverify-run still shows 3407 pages marked as corrupt.
V$database_block_corruption shows only 1 row.
I can check what's in those blocks but that will take a while as SYSAUX is 1,4GB with autoextend on, so the 1,4GB is filled up. ;-)
Anyone some other clue?
0