Oracle database hint Ora-27069:skgfdisp: Trying to perform I/O outside the file range

Received technical support requests, WIN 2003 NTFS format file system, Oracle 8.1.7 version, the host restart, the database can not start normally, offline DataFile 15, the database open successfully, but datafile can not normal online, The error is: Ora-27069:skgfdisp:attempt to do I/O beyond the range of the file, requesting assistance in handling
sql> recover DataFile ' d:/oracle/oradata/orcl/zsf_data. DBF ';
ORA-00283: Recovery session canceled due to error
ORA-01115: IO Error while reading block from File 15 (Block # 1030071)
ORA-01110: Data file: ' D:/oracle/oradata/orcl/zsf_data. DBF '
Ora-27069:skgfdisp: Attempting to perform I/O outside the file scope
OSD-04026: Invalid parameter passed. (OS 1030071)
Using bbed, Success online datafile 15
Tue Oct 28 16:30:35 2014
ALTER DATABASE RECOVER datafile 15
Tue Oct 28 16:30:35 2014
Media Recovery datafile:15
Media Recovery Start
Media Recovery Log
Recovery of Online Redo log:thread 1 Group 1 Seq 245110 Reading Mem 0
mem# 0 errs 0:d:/oracle/oradata/orcl/redo03. LOG
Media Recovery failed with error 1115
ORA-283 signalled During:alter DATABASE RECOVER datafile 15 ...
Tue Oct 28 16:32:53 2014
Shutting down instance (abort)
License High Water mark = 6
Instance terminated by USER, PID = 1548
Starting up ORACLE RDBMS version:8.1.7.0.0.
System parameters with Non-default values:
processes = 600
Shared_pool_size = 52428800
Large_pool_size = 20971520
Java_pool_size = 20971520
Control_files = D:/oracle/oradata/orcl/control01.ctl, D:/oracle/oradata/orcl/control02.ctl
Db_block_buffers = 19200
Db_block_size = 8192
Compatible = 8.1.0
Log_buffer = 32768
Log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
Db_files = 1024
Db_file_multiblock_read_count= 8
Max_enabled_roles = 30
Remote_login_passwordfile= EXCLUSIVE
Global_names = TRUE
Distributed_transactions = 500
instance_name = ORCL
Service_names = ORCL
Mts_dispatchers = (protocol=tcp) (Pre=oracle.aurora.server.sgiopserver)
Open_links = 4
Sort_area_size = 65536
Sort_area_retained_size = 65536
Db_name = ORCL
Open_cursors = 500
IFile = D:/oracle/admin/orcl/pfile/init.ora
Os_authent_prefix =
Job_queue_processes = 4
Job_queue_interval = 10
Parallel_max_servers = 5
Background_dump_dest = D:/oracle/admin/orcl/bdump
User_dump_dest = D:/oracle/admin/orcl/udump
Max_dump_file_size = 10240
Oracle_trace_collection_name=
Pmon started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
Smon started with pid=6
Reco started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Tue Oct 28 16:33:01 2014
Starting up 1 Shared server (s) ...
Starting up 1 Dispatcher (s) to network address ' (Address= (Partial=yes) (protocol=tcp)) ' ...
Tue Oct 28 16:33:02 2014
ALTER DATABASE MOUNT
Tue Oct 28 16:33:06 2014
Successful mount of Redo thread 1 with Mount ID 1389958722.
Tue Oct 28 16:33:06 2014
Database mounted in Exclusive Mode.
Completed:alter DATABASE MOUNT
Tue Oct 28 16:33:49 2014
ALTER database RECOVER database until cancel
Tue Oct 28 16:33:49 2014
Media Recovery Start
Media Recovery Log
Kcrrga:warning. Log sequence in archive filename wrapped
To fix length as indicated by%s in Log_archive_format.
The old log archive with same name might is overwritten.
ORA-279 signalled during:alter database RECOVER database until cancel ...
Tue Oct 28 16:34:03 2014
ALTER DATABASE RECOVER LOGFILE ' d:/oracle/oradata/orcl/redo02. LOG '
Tue Oct 28 16:34:03 2014
Media Recovery Log d:/oracle/oradata/orcl/redo02. LOG
Incomplete recovery applied all redo ever generated.
Recovery completed through Change%s139866389
Media Recovery Complete
Completed:alter DATABASE RECOVER LOGFILE ' D:/oracle/orada
Tue Oct 28 16:34:29 2014
ALTER DATABASE DataFile Online

Tue Oct 28 16:34:29 2014
Completed:alter Database datafile Online
Tue Oct 28 16:34:36 2014
ALTER DATABASE open Resetlogs

Resetlogs is being done without consistancy checks. This could result
In a corrupted database. The database should be recreated.
Resetlogs after incomplete recovery UNTIL change 139866389
Tue Oct 28 16:34:38 2014
Thread 1 opened at log sequence 1
Current log# 2 seq# 1 mem# 0:d:/oracle/oradata/orcl/redo02. LOG
Successful open of Redo thread 1.
Tue Oct 28 16:34:38 2014
Smon:enabling Cache Recovery
Tue Oct 28 16:34:38 2014
Dictionary Check Beginning
Dictionary Check Complete
Tue Oct 28 16:34:39 2014
smon:enabling TX Recovery
Tue Oct 28 16:34:44 2014
Completed:alter Database Open Resetlogs
The customer operation Business continues to ORA-600[KTSXS_ADD2] error after the database datafile online success
Tue Oct 28 17:07:42 2014
Errors in file d:/oracle/admin/orcl/udump/ora02340. TRC:
ORA-00600: Internal error code, independent variable: [KTSXS_ADD2], [14], [15], [42534], [5732], [5733], [], []

Tue Oct 28 17:07:53 2014
Errors in file d:/oracle/admin/orcl/udump/ora02340. TRC:
ORA-00600: Internal error code, independent variable: [KTSXS_ADD2], [14], [15], [42534], [5732], [5733], [], []

Tue Oct 28 17:08:03 2014
Errors in file d:/oracle/admin/orcl/udump/ora02340. TRC:
ORA-00600: Internal error code, independent variable: [KTSXS_ADD2], [14], [15], [42534], [5732], [5733], [], []

Tue Oct 28 17:08:16 2014
Errors in file d:/oracle/admin/orcl/udump/ora02340. TRC:
ORA-00600: Internal error code, independent variable: [KTSXS_ADD2], [14], [15], [42534], [5732], [5733], [], []

Tue Oct 28 17:08:23 2014
Errors in file d:/oracle/admin/orcl/udump/ora02308. TRC:
ORA-00600: Internal error code, independent variable: [KTSXS_ADD2], [14], [15], [42534], [5732], [5733], [], []

Tue Oct 28 17:08:31 2014
Errors in file d:/oracle/admin/orcl/udump/ora02340. TRC:
ORA-00600: Internal error code, independent variable: [KTSXS_ADD2], [14], [15], [42534], [5732], [5733], [], []

Tue Oct 28 17:08:38 2014
Errors in file d:/oracle/admin/orcl/udump/ora02308. TRC:
ORA-00600: Internal error code, independent variable: [KTSXS_ADD2], [14], [15], [42534], [5732], [5733], [], []
Through the analysis of the relevant log found that the Insert table error, it is well understood that the library's datafile 15 has exceeded the system limit, now continue to insert data, so the error, query possible exception object
Sql> Col segment_name for A20
Sql> SELECT distinct OWNER, segment_name, Segment_type, A.partition_name
2 from Dba_extents A
3 WHERE file_id = 15
4 and 1030071 <= block_id;

OWNER segment_name Segment_type
------------------------------ -------------------- ------------------
Partition_name
------------------------------
ZSF DETAIL TABLE


ZSF DETAIL1 INDEX


ZSF DETAIL2 INDEX



OWNER segment_name Segment_type
------------------------------ -------------------- ------------------
Partition_name
------------------------------
ZSF DETAIL3 INDEX


ZSF DETAIL4 INDEX


ZSF Fk_reci_ord INDEX



OWNER segment_name Segment_type
------------------------------ -------------------- ------------------
Partition_name
------------------------------
ZSF PREPAY1 INDEX


ZSF RECEDETAIL1 INDEX
Create a new table space
Create tablespace zsf_new datafile ' d:/oracle/oradata/orcl/zsf_data_new01.dbf ' size 4096m;
Alter tablespace zsf_new add datafile ' d:/oracle/oradata/orcl/zsf_data_new02.dbf '
Size 128m autoextend on next 128M maxsize 4096m;
Migrating an exception object to a new table space
ALTER TABLE ZSF. DETAIL move tablespace zsf_new;
Alter index ZSF. DETAIL1 rebuild Tablespace zsf_new;
Alter index ZSF. DETAIL2 rebuild Tablespace zsf_new;
Alter index ZSF. DETAIL3 rebuild Tablespace zsf_new;
Alter index ZSF. DETAIL4 rebuild Tablespace zsf_new;
Alter index ZSF. Fk_reci_ord rebuild Tablespace zsf_new;
Alter index ZSF. PREPAY1 rebuild Tablespace zsf_new;
Alter index ZSF. RECEDETAIL1 rebuild Tablespace zsf_new;
Then add a new file to the table space for datafile 15 because the exception object has been migrated, then resize DataFile 15 is less than 8G, and the extension is turned off so that the database is restored to completion