-
Hi, guys
I tested tempfile for corrupted blocks and I have found that my tempfile contains lots of corrupted blocks, I could not find any links according to TEMPFILE and DBVERIFY.
Question: is this situation normal for tempfiles ?
Thanks a lot.
------------------------------------------------------
Total Pages Examined : 12800
Total Pages Processed (Data) : 0
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 4
Total Pages Empty : 0
Total Pages Marked Corrupt : 12796
Total Pages Influx : 0
-
You do not have any corruption on your temp file. AFAIK temp files are simply skipped by dbv. See in your report that actually 0 datablocks have been processed. 4 blocks that are reported as processed ("Others") probably belong to datafile header where dbv finds that this is actually a temp file and stops processing it. Unfortunatelly all other blocks are reported as corrupted, although they have not been checked at all. Simply ignore this report or even better, don't even check tempfiles with dbv utility - there is no point in doing it at all.
-