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:
Post a Comment