Re: ORA-01115 IO errors

Gerald Sinkiewicz wrote:

The ORA-01115 references file 10. I cannot post file names.
Ah, I did misspell "owner" and there are other messages related to the ORA-01115 that really just say Oracle could not read a certain block in file 10....

That is an entirely different matter that has nothing to do with what
you sent the storage admins chasing ... stop them.

Oracle error messages are intended to be handled in a specific manner as
befits an enterprise database. First you go to
http://metalink.oracle.com and determine an appropriate actions plan:
Then you act precisely as instructed. What you appear to have done is
a guaranteed recipe for disaster ... not understand the message, not
research the message ... and start doing stuff hoping something will
fix it.

So lets get back to basics ...

Oracle can not read one or more specific blocks of a specific data file.
This is an indication of a specific problem with a specific solution.
Which blocks? In which tablespace? Being used by which objects? What
version of Oracle do you have and have you, as you should have, taken
backups with RMAN? If so what backups do you have, how were they taken,
and specifically what actions, if any, have been taken since the problem
was first discovered.

While you are contemplating the above run an RDA and open an SR.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • Tru64 5.1 System hangs when creating Oracle data file > 1Gb - any suggestions on cause
    ... was running Oracle 8.1.7.0.0 with a large database ... The system was updated to Oracle 8.1.7.4.0, ... This system was configured last year, and a 23Gb data file was created ... then in exactly the same way without this problem, no Tru64 upgrades ...
    (comp.unix.tru64)
  • Re: how can i shirnk your datafile file size?
    ... I have a tablespace have a datafile sizing 8GB, but actually, I just ... But when i resize that data file, ... Oracle Ace Director & Instructor ...
    (comp.databases.oracle.server)
  • SqlBulkCopy and Oracle?
    ... even in ADO.NET 1.1 without SqlBulkCopy class, ... using StringBuilder to create data file, ... Insert to save data into the database. ... Oracle, there are similar utilities to accommodate bulk ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cant find file with a *.ora extension
    ... Should I use the *.dbf extension ... Oracle does not care what extension is used. ... As far as 'where' the data file should go - you will find the data file ... a lot of Google time ) ...
    (comp.databases.oracle.server)
  • Re: Oracle on Red Hat best practices
    ... Oracle on Red Hat best practices ... Avoid raw devices if at all possible. ... Backups are most critical, ...
    (RedHat)