DBVERIFY & TEMPFILE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: DBVERIFY & TEMPFILE

  1. #1
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684

    Angry

    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
    Best wishes!
    Dmitri

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Thank you very much!
    Best wishes!
    Dmitri

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width