topic Re: Error while extending table space in Operating System - HP-UX

Error while extending table space

Otong Sunaryo — Tue, 21 Jun 2005 02:14:04 GMT

Dear all,

When I was extending tablespace, i got an error :

ALTER DATABASE DATAFILE '/u01/oradata/rman/cat1rman.dbf' RESIZE 500m
*
ERROR at line 1:
ORA-01237: cannot extend datafile 8
ORA-01110: data file 8: '/u01/oradata/rman/cat1rman.dbf'
ORA-19502: write error on file "/u01/oradata/rman/cat1rman.dbf", blockno
53395
(blocksize=6144)
ORA-27072: skgfdisp: I/O error
Additional information: 53395

Please help me to resolve problem. I need to solve asap.

Thanks for your help

Best regards,

Otong

Re: Error while extending table space

Joseph Loo — Tue, 21 Jun 2005 02:24:34 GMT

hi,

do u want to check if there is enough space in the file system, /u01?

it looks like there is not enough space to extend that tablespace to 500MB.

regards.

Re: Error while extending table space

Adisuria Wangsadinata_1 — Tue, 21 Jun 2005 02:28:54 GMT

Hi Otong,

You need to check on the disk where the database sit-on, looks like there's an issue in there based on (ORA-19502 & ORA-27072). Check the syslog.log, event.log & use dd to check the disk or STM to see the growing defect-list.

Backup is the good plan also on this situation.

Cheers,
AW

Re: Error while extending table space

Eric Antunes — Tue, 21 Jun 2005 03:24:38 GMT

Hi Otong,

To check space on /u01, do:

#bdf /u01

To check where the used space is, execute:

#du -k /u01|more

Best Regards,

Eric Antunes

Re: Error while extending table space

Indira Aramandla — Tue, 21 Jun 2005 03:37:21 GMT

Hi Otong,

ORA-01237: cannot extend datafile 8
ORA-01110: data file 8: '/u01/oradata/rman/cat1rman.dbf'
ORA-19502: write error on file "/u01/oradata/rman/cat1rman.dbf", blockno 53395
(blocksize=6144)
ORA-27072: skgfdisp: I/O error

The above errors could be due to the following reasons. As the other posts mentioned, it could be due to

1. Due to lack of available disk space on the hard drive. Increase space available on hard drive.

2. The default location rman writes to, $oracle_home/dbs, is full. You can free up space in the default location

3. When creating a data file and if you are using raw device, ensure that the data file is smaller than the size of the raw device. If you have a 100 MB raw partition, do not allocate a data file of 100 MB. Instead allocate a datafile of 100 MB - 1 MB; 99 MB. The rule of thumb is to leave 1MB unused. Following this rule ensures that you will not write over cylinder 0 of the disk.

4. Iif it is a file io error then add the following parameter to your init.ora file: \
disk_asynch_io = false
Explanation : â DISK_ASYNCH_IO can be used to control whether I/O to datafiles, controlfiles and logfiles are asynchronous. If a platform supports asynchronous I/O to disk, it is recommended that this parameter is left to its default. However, if the asynchronous I/O implementation is not stable, this parameter can be set to FALSE to disable asynchronous I/O. If a platform does not support asynchronous I/O to disk, this parameter has no effect."

Indir

Re: Error while extending table space

Yogeeraj_1 — Tue, 21 Jun 2005 11:01:43 GMT

hi,
in case you cannot extend due to diskspace problem on that file system, you can also add another datafile(from another file system of course) to that same tablespace.

hope this helps!
regards
yogeeraj