topic Re: Help on resizing problem in Operating System - HP-UX

Help on resizing problem

Mohd Mohtar — Thu, 08 Aug 2002 00:19:01 GMT

Hi,

What does these errors means and how do I rectify them ?

ORA-01237: cannot extend datafile 30
ORA-01110: data file 30: '/d13/sp1/dat/680dat2.dbf'
ORA-19502: write error on file "/d13/sp1/dat/680dat2.dbf", blockno 177089 (blocksize=4096)
ORA-27072: skgfdisp: I/O error
Additional information: 177089

Posted this errors in Oracle Forum but was told that this combination of errors sometimes indicates a hardware problem and was redirected to the Unix
Installation/OS: RDBMS team.
So far, no reply yet and I urgently need to increase the datafiles sizes.

Thanks in Advance

Mohd

Re: Help on resizing problem

Bill Hassell — Thu, 08 Aug 2002 00:36:43 GMT

It is indeed an I/O error. There are only two possibilities: the disk is going bad and you are about to lose everything on that disk, or someone logged in as root may have used lvreduce on the running system (a BIG no-no) and made the physical disk (as it appears to the filesystem manager) smaller than when the filesystem was created.

The filesystem code issues a seek to a track beyond the end of the logical volume and the driver issues an I/O error, same as if the heads were positioned beyond the edge of the disk.

Look in /var/adm/syslog/syslog.log for disk errors. If there are a lot, make sure your backups are accurate and known to work.

Re: Help on resizing problem

MANOJ SRIVASTAVA — Thu, 08 Aug 2002 03:03:04 GMT

Hi Mohd

do a dd if=/d13/sp1/dat/680dat2.dbf of=/dev/null and check whter this gives an io error or not .

Most of the dbf files you can do a strings also to check that the file is good or not. It looks there is a bad block , I suggest run a dd on the disk and replace if it errors out.

Manoj Srivastava

Re: Help on resizing problem

Yogeeraj_1 — Thu, 08 Aug 2002 03:27:14 GMT

Re: Help on resizing problem

T G Manikandan — Thu, 08 Aug 2002 04:28:19 GMT

hello,

After noting the error ora-27020 I was looking at the amount of free space on your file system.

The message write error on a specific block is to check the /var/adm/syslog/syslog.log file to check any message related to a disk problem.

Post your syslog.log file messages indicating any bad disk failure.

Re: Help on resizing problem

T G Manikandan — Thu, 08 Aug 2002 04:29:29 GMT

Re: Help on resizing problem

T G Manikandan — Thu, 08 Aug 2002 04:36:04 GMT

If there are no messages in syslog about a bad disk,

Do you have this parameter in your initialization file.
init.ora of the database.

CONTROL_FILE_RECORD_KEEP_TIME

check this link for the description of the parameter.

http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/a90190/ch124.htm

Post your results

Thanks

Re: Help on resizing problem

Mohd Mohtar — Tue, 13 Aug 2002 01:20:33 GMT

Thanks to all for the replies.

The IO error is due to insufficient disk space and I have rectified the problem.

Thanks again.