| DBVerify for 9i [message #59113] |
Tue, 28 October 2003 21:23  |
Alan
Messages: 68
Registered: October 1999
|
Member |
|
|
Hi,
I'm using Oracle 9.2.0.2 at AIX 5.1 unix environment. Did anybody come across that dbv reports failing pages however ANALYZE, EXPORT, SELECT, ... everything runs sucessfully and is fine?
Regards,
Alan
|
|
|
|
| Re: DBVerify for 9i [message #59117 is a reply to message #59113] |
Wed, 29 October 2003 08:11  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
|
I havent worked with AIX yet, but exports,Selects etc only reads blocks upto HWM(ie used blocks) and not beyond that, while DBV can read the whole file..so maybe ( am not sure) there are pages in the file beyond the HWM that has some errors ?
|
|
|
|
| Re: DBVerify for 9i [message #59121 is a reply to message #59117] |
Thu, 30 October 2003 00:27 |
Alan
Messages: 68
Registered: October 1999
|
Member |
|
|
|
Thanks for your reply. I have selected table dba_extents and found those pages belong to a table. So I can confirmed that they are within HWM. I have posted this issue to Oracle support, and no findings at the moment. So I suspected that somehow DBV reports wrong things under some situation. Do you rely on DBV to detect corruption? Or any other ways?
|
|
|
|
| Re: DBVerify for 9i [message #59130 is a reply to message #59121] |
Thu, 30 October 2003 10:30 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Did you cross check with RMAN (ie BACKUP VALIDATE DATABASE )?
If those pages are within HWM, then you should be able to use
exp full=y file=/dev/null
and confirm. There are other ways too , for checking block corruption such as DB_BLOCK_CHECKING,Db_block_checksum,Analyze..
You can turn on these parameter(s) and do a full table scan on that table ...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
