-
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.
KN
-
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!
-
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...
Jeff Hunter
-
What is the OS and Oracle versions? Did you try adding/resizing the file? IS the database in the archive log mode?
Sam
Thanx
Sam
Life is a journey, not a destination!
-
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
KN
-
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.
-
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
KN
-
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.
Jeff Hunter
-
How do I find out if it is the block corruption or the max file exceed?
Please help
KN
-
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.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|