Re: Solved: import shuts down database

yong321_at_yahoo.com wrote:
>
> 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.

Its rare that when someone solves their own problem that they post it back to the group for everyone's benefit.

Good to see...

Cheers

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse