Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: IO Error ORA-01114: IO error writing block to file %s (block # %s)

Re: IO Error ORA-01114: IO error writing block to file %s (block # %s)

From: <bdbafh_at_gmail.com>
Date: 18 Jul 2005 12:30:38 -0700
Message-ID: <1121715038.070594.68840@g43g2000cwa.googlegroups.com>


perhaps the file belonged to an undo tablespace. can you take the file# returned in the error message and examine v$datafile for what file it is?
perhaps this is on win32, and a backup operation that doesn't play nicely with oracle has that file locked. if this is the case, a server reboot followed by bringing that datafile online should get you back in the ball game, but it might be a small part of a larger problem.

as Daniel stated, without the proper information describing the environment, all we can do is postulate.

-bdbafh Received on Mon Jul 18 2005 - 14:30:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US