Re: Urhent help needed: import shuts down database

Thanks, Jerry. I ran dbv like this:

dbv file=logician7.dbf blocksize=8192 logfile=dbv7.log

on all data files. All show 0 on the lines Total Pages Failing (both data and index) and Total Pages Marked Corrupt.

If nothing helps, I'll drop the tablespace and start over.

Yong Huang

In article <20000418.5314900_at_noname.nodomain.nowhere>,   Jerry Gitomer <jgitomer_at_erols.com> wrote:
>
>
> Sounds like you have a corrupted datafile. To be on the safe side I
> suggest that you export every table that is stored in the tablespace
> the datafile belongs to and plan on cleaning up your disk problem and
> then rebuilding the tablespace. (I say this because if you have been
> getting the error for a while you probably can't recover from your
> backups.)
>
> >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
>
> On 4/17/00, 5:41:07 PM, yong321_at_yahoo.com wrote regarding Urgent help
> needed: import shuts down database:
>
> > My import frequently aborts and shuts down the database. Here's the
> > 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
 

> > The import parameter file specifies commit=y, buffer=1024000,
> > ignore=y, analyze=N, feedback=50000, among other things, using
 conventional
>
> path.
> > When the import aborts, I can always restart the database and rerun
> > import, which aborts again after a while, at a different block
 number,
> > but the same "error=27072" and "error 1242". Trying many times I can
 

> > eventually import successfully. The dump file is only 700 MB. I
 wonder  

> > if there's a disk failure. Please help.
 

> > This is Oracle 8.1.6 on Solaris 7.
 

> > Yong Huang
> > Email: yong321_at_yahoo.com

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