URGENT PLEASE HELP:KCF:WRITE/OPEN ERROR

[Knarayan]

I am getting the foll. err in my alert log. What could the problem be and where can I get further info about the errors:

KCF: write/open error dba=Ox28034bd block=Ox342bd
/u003/oradata/HRPROD/psindex.dbf
error 7374 txt: Additional information:213693'

What does this add. information point to? Do I have a way to find out the exact info from this error message.

Please help.

[oddster]

Try Oracle Support or Metalink for details of your specific problem.

you can try the following to resolve the error:

SVRMGR> recover datafile '';
SVRMGR> alter database datafile '' online;




Good Luck!

[marist89]

Sounds like you have a bad disk or something. Check your host's messages file (/var/adm/messages on solaris). Resolve your hardware error, and recover if necessary...

[sambavan]

What is the OS and Oracle versions? Did you try adding/resizing the file? IS the database in the archive log mode?


Sam

[Knarayan]

No, database is not in archivelog mode

OS: HP-Ux
Oracle:7.3.3

THis occured during resize of datafile, that is the info I collected from the person here. It is my first day in this place and that is all the info I have.

Please help

[gpsingh]

run dd if="ur file" of=/dev/null
and check if it hangs or comes out with different input and output blocks ,
then u do have a bad block.
Move the datafile to some other location.i do not know if u would be successfull.

[Knarayan]

THis is the extract of the dbwr trace files generated.

How do I proceed
dbwr 14:24
Sun Dec 2 20:14:24 2001
*** SESSION ID:(2.1) 2001.12.02.20.14.24.827
KCF: write/open error dba=0x5000a006 block=0xa006 online=1
file=20 /u002/oradata/HRPROD/bnlarge.dbf
error=7374 txt: 'Additional information: 40966'
error 1242 detected in background process
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 20 (block # 40966)
ORA-01110: data file 20: '/u002/oradata/HRPROD/bnlarge.dbf'
ORA-07374: sfwfb: invalid block number.
Additional information: 40966

[marist89]

Looks like you either got a bad block on disk or you have exceeded your maximum file size. If it is the latter, resize your datafile back down a couple of MB.

[Knarayan]

How do I find out if it is the block corruption or the max file exceed?
Please help

[marist89]

Is 2G your max filesize?
ls -l /u002/oradata/HRPROD/bnlarge.dbf

Use dd (as specified in another post in this very same thread) to see if you have a corrupt block.