DBVERIFY error DBV-00102: File I/O error on FILE

September 29, 2010 | By

Hi Friends,

Today we are going to discuss about well known DBVERIFY error called DBV-00102.

Error Code: DBV-00102: File I/O error on FILE

Error itself indicates File I/O contention.

Root Cause of Error:

When we are executing dbv command for checking of corruption issue in datafile, that time if DBV read the contains of files and check file block validation. Means DBV performs READ operation on given datafile at OS level. If any problem occurs during read operation on operating system level that time we are getting above DBV-00102 error. It doesn’t indicate corruption of datafile but it due to problem found in disk io.

There are so many reason behind this error. May be disk space is full or CPU consumption is more. OR some mismatch found with size of datafile.

Solution:

Resize datafile with one block smaller. If this statement failed then resize datafile one block larger. After finishing successfully operation of resize again make it original size of database. Confused?!!!!!!!!!!!! Ok. No problem let we take one example.

Example:

If users01.dbf datafile size is 2147483648 and our database block size is 8K (8192 bytes) then issue following command. Calculation is 2147483648 (original size of datafile)-8192=2147475456

alter database datafile ‘/u01/oradata/test/users01.dbf’ resize 2147475456;

If command fail then resize one block larger. calculation is 2147483648 (original size of datafile)+8192=2147491840

alter database datafile ‘/u01/oradata/test/users01.dbf’ resize 2147491840;

After finishing above one of command make it datafile in original size as follows.

alter database datafile ‘/u01/oradata/test/users01.dbf’ resize 2147483648;

Wish you all the best,

Thanks and regards,

Dbametrix Solutions

About Company:

Dbametrix offers remote dba support,remote dba services,oracle database support services, remote assistance, database services with very low cost flexible remote dba plans.

Be Sociable, Share!

Tags: , , , , , , , ,

Category: blog, blogging, database, remote dba, remote dba service, remote dba support, software

Comments are closed.