Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Error while extending table space

SOLVED
Go to solution
Otong Sunaryo
Occasional Advisor

Error while extending table space

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
5 REPLIES
Joseph Loo
Honored Contributor
Solution

Re: Error while extending table space

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.
what you do not see does not mean you should not believe
Adisuria Wangsadinata_1
Honored Contributor

Re: Error while extending table space

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
now working, next not working ... that's unix
Eric Antunes
Honored Contributor

Re: Error while extending table space

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
Each and every day is a good day to learn.
Indira Aramandla
Honored Contributor

Re: Error while extending table space

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
Never give up, Keep Trying
Yogeeraj_1
Honored Contributor

Re: Error while extending table space

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)