Tuesday, April 03, 2012

File 201

I had the following error in an Oracle 9 database in 2005:
 
ORA-01114: IO error writing block to file 201 (block # 63625)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Compaq Tru64 UNIX Error: 28: No space left on device
 
I checked the file_id column in dba_data_files and dba_temp_files but there was no file 201. However, the db_files initialisation parameter was set to 200. For the purposes of the message above, temporary files are numbered from the value of db_files + 1. File 201 was therefore the database’s first temporary file and it was unable to autoextend. Moving this temporary file to a disk with more room cured the problem.

No comments: