You are currently browsing the tag archive for the ‘ORA-01110:’ tag.
I faced with those errors on 12c database. While I try to drop some tablespace it throws errors such as:
SQL> DROP TABLESPACE MY_TABLESPACE INCLUDING CONTENTS AND DATAFILES; DROP TABLESPACE MY_TABLESPACEINCLUDING CONTENTS AND DATAFILES * ERROR at line 1: ORA-01116: error in opening database file 35 ORA-01110: data file 35: '/u01/app/oracle/product/12.1.0/dbhome_2/dbs/MY_TABLESPACE02_A.DBF' ORA-27041: unable to open file SVR4 Error: 2: No such file or directory Additional information: 3
Advertisements
Oracle Database Block corruptions
There are many possible causes of a block corruption including:
– Bad IO hardware / firmware
– OS problems
– Oracle problems
– Recovering through “UNRECOVERABLE” or “NOLOGGING” database actions (in which case ORA-01578&ORA-01110 is expected behavior)
Before start to post, let me remind you how many corruptions we have… There are 2 types of corruptions. Data corruption can manifest itself as a physical or a logical corruptions.
So Let us define all those,
You can hit this error on your alert.log. Error could be similar as:
ORA-01578: ORACLE data block corrupted (file # 12, block # 4207)
ORA-01110: data file 11: ‘/xx/sytem.dbf’
There are many possible causes of a block corruption including:
– Bad IO hardware / firmware
– OS problems
– Oracle problems
– Recovering through “UNRECOVERABLE” or “NOLOGGING” database actions
(in which case ORA-1578 is expected behavior) Read the rest of this entry »
