Solved: import shuts down database

From: <yong321_at_yahoo.com>
Date: 2000/04/20
Message-ID: <8dnkbt$4cl$1@nnrp1.deja.com>#1/1

Recap of the problem: importing dump files aborts and shuts down the database
with error in alert log:
KCF: write/open error block=0x375e online=1

     file=15 /hwh/oradata/logician7.dbf
     error=27072 txt: 'SVR4 Error: 5: I/O error

Additional information: 14174'
DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 4014

Short answer: hard drive problem.

Long answer:

Late yesterday afternoon, even an OS command "cp mydatafile.dbf mydatafile.dbf.bak" gave an I/O error. The hardware guy came back and said the
motherboard doesn't support the top speed for the new Western Digital drive. He
changed something (jumpers?) and reinstalled. Everything is fine.

Before that, I ran dbv on all datafiles and found no problems. dmesg didn't
show any problems. Import was successfully run for the first 1GB dump file and
started to have problems from the second dump file on (all 1 to 2 GB). At one
point, import reported Can't read datafile XXX. I used the command "recover
datafile 'XXX'" with success feedback but still can't read tables that happen
to be in 'XXX'.

Another lesson I learned. Initially I was importing in noarchivelog mode with
dbwr_io_slaves=0 (default) and 5 redo log files 20MB each. When import aborted,
the database was shut down. Later I set dbwr_io_slaves=2, 4 redo log files
100MB each, imported in archivelog mode and when import aborted, the database
was still up. I should've changed one thing at a time to see what made the
difference. Maybe dbwr_io_slaves.

Thanks to everyone that helped.

Yong Huang

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 20 2000 - 00:00:00 CDT