Oracle Clear data block (logical) corrupt from dbverify

** Myself

dbverify report  (dbv) detect corrupt blocks but no physical corrupt.
for 10g

Verify after dbv
check  v$database_block_corruption or v$backup_corruption (from rman verfity)
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
backup check logical validate database;
release channel c1;
release channel c2;
}



Fix
1) run analyze object  for check  integrity and run dbv again
analyze <xxx> validate structure [ONLINE]
2) or flush db buffer cache and run dbv again
   alter system flush buffer_cache

0 comments:

Loading