Datafile offline problem

From: Frnak9e Chabn <frchan_at_asl.com.hk>
Date: Wed, 06 May 1998 04:04:09 GMT
Message-ID: <354fdb4a.159467101@news.huge.net.hk>

Hi all,

           I had the following transient datafile problem during heavy Database insertion (either through ProC or SQLoader). After I have recovered the database using 'Alter database recover datafile ... ; Alter database datafile ... online;', the database insertion can still operate over a period of time (sometimes several hours, sometimes several minutes) and the same datafile error appears causing the datafile(s) to offline. I have checked the hardware and it is ok. I suspect the database is corrupted but I am not sure. Can anyone help me ? I attached the following trace file for additional information.

Thanks

William

---

[File: alert_abcc.log] under bdump directory

Wed May 6 10:00:41 1998
KCF: write/open error dba=0x18002966 block=0x2966 online=1

     file=6 /dev/rdsk/c1t0d0s0
     error=7376 txt: 'SVR4 Error: 8992896: Unknown system error
Additional information: 10598

Additional information: 2048
Additional information: 8992896'
Automatic datafile offline due to write error on file 6: /dev/rdsk/c1t0d0s0
Wed May 6 10:08:02 1998
alter database recover datafile '/dev/rdsk/c1t0d0s0' Wed May 6 10:08:02 1998
Media Recovery Datafile: '/dev/rdsk/c1t0d0s0' Media Recovery Start
Media Recovery Log
Media Recovery Complete
Completed: alter database recover datafile '/dev/rdsk/c1t0d0s... Wed May 6 10:09:00 1998
alter database datafile '/dev/rdsk/c1t0d0s0' online Wed May 6 10:09:01 1998
Completed: alter database datafile '/dev/rdsk/c1t0d0s0' onlin... Wed May 6 10:10:47 1998
KCF: write/open error dba=0x18002f9e block=0x2f9e online=1

     file=6 /dev/rdsk/c1t0d0s0
     error=7376 txt: 'SVR4 Error: 1: Not owner
Additional information: 12190

Additional information: 2048
Additional information: 1'
Automatic datafile offline due to write error on file 6: /dev/rdsk/c1t0d0s0
Wed May 6 11:00:24 1998
alter database recover datafile '/dev/rdsk/c1t0d0s0' Wed May 6 11:00:24 1998
Media Recovery Datafile: '/dev/rdsk/c1t0d0s0' Media Recovery Start
Media Recovery Log
Media Recovery Complete
Completed: alter database recover datafile '/dev/rdsk/c1t0d0s... Wed May 6 11:00:47 1998
alter database datafile '/dev/rdsk/c1t0d0s0' online Wed May 6 11:00:48 1998
Completed: alter database datafile '/dev/rdsk/c1t0d0s0' onlin... Wed May 6 11:02:13 1998
Thread 1 advanced to log sequence 230
  Current log# 2 seq# 230 mem# 0: /dev/md/rdsk/d5

---

[File: abcc_dbwr_27090.trc ] under bdump

Dump file /opt2/oracle/app/oracle/admin/abcc/bdump/abcc_dbwr_27090.trc Oracle7 Server Release 7.3.3.3.0 - Production Release With the distributed and replication options PL/SQL Release 2.3.3.3.0 - Production
ORACLE_HOME = /opt2/oracle/app/oracle/product/7.3.3

System name:	SunOS
Node name:	abcccdm1
Release:	5.5.1
Version:	Generic_103640-08
Machine:	sun4u

Instance name: abcc
Redo thread mounted by this instance: 1 Oracle process number: 3
Unix process pid: 27090, image: ora_dbwr_abcc

Tue May 5 21:15:30 1998
*** SESSION ID:(2.1) 1998.05.05.21.15.30.000 KCF: write/open error dba=0x8000007 block=0x7 online=1

     file=2 /dev/rdsk/c1t0d0s6
     error=7376 txt: 'SVR4 Error: 8992756: Unknown system error
Additional information: 7

Additional information: 2048
Additional information: 8992784'
Automatic datafile offline due to write error on file 2: /dev/rdsk/c1t0d0s6
Wed May 6 10:00:41 1998
KCF: write/open error dba=0x18002966 block=0x2966 online=1

     file=6 /dev/rdsk/c1t0d0s0
     error=7376 txt: 'SVR4 Error: 8992896: Unknown system error
Additional information: 10598

Additional information: 2048
Additional information: 8992896'
Automatic datafile offline due to write error on file 6: /dev/rdsk/c1t0d0s0
Wed May 6 10:10:47 1998
KCF: write/open error dba=0x18002f9e block=0x2f9e online=1

     file=6 /dev/rdsk/c1t0d0s0
     error=7376 txt: 'SVR4 Error: 1: Not owner
Additional information: 12190

Additional information: 2048
Additional information: 1'
Automatic datafile offline due to write error on file 6: /dev/rdsk/c1t0d0s0 Received on Tue May 05 1998 - 23:04:09 CDT