ORA-01187: cannot read from file %s because it failed verification tests
Although we try to provide custom solutions, we do not have a solution yet for all Oracle Error Messages. We apologize for that. You can use the feedback part to indicate this was not helpfull and we'll try to prioritize the creation of a satisfying solution.
database. Reads are not allowed until it is verified.
*Action: Make the correct file available to the database. Then, either open
the database, or execute ALTER SYSTEM CHECK DATAFILES.
Welcome to our forum for Oracle error: ORA-01187 Add your own message
ORA-01187: cannot read from file 203 because it failed verification tests ORA-01110: data file 203: 'F:\SAGEMOBILE_TEMP01.DBF'
SELECT TO_CHAR(ROUND(DF.TOTAL+TF.TOTAL+LOG.TOTAL, 2), '999G999G990D99')||' GB' "TOTAL ALLOCATED SIZE" , TO_CHAR(ROUND(DF.MAXBYTES+TF.MAXBYTES+LOG.TOTAL, 2), '999G999G990D99')||' GB' "SIZE TO FULFILL AUTOEXTEND" , BS.* , NVL(MX.VALUE, '?') "MAX. AMOUNT OF DATABASE FILES" FROM (SELECT MIN(VALUE/1024)||' KB' "DEFAULT BLOCK SIZE" FROM V$PARAMETER WHERE NAME='DB_BLOCK_SIZE') BS, ( SELECT NVL(SUM(BYTES)/1024/1024/1024, 0) TOTAL , NVL(SUM(DECODE( MAXBYTES, 0, BYTES , NULL, 0 , DECODE( SIGN(MAXBYTES-BYTES), -1, BYTES, MAXBYTES) ) )/1024/1024/1024, 0) MAXBYTES FROM DBA_DATA_FILES ) DF, ( SELECT NVL(SUM(BYTES)/1024/1024/1024, 0) TOTAL , NV
You will need to check if the file still exists.
If it exists, use dbv9erify) to check for errors.
If needed, you will need to recover from backup
| 1 | SLX_DATA | Tablespace [SLX_DATA] is [86 percent] full | 86.825 | 01-APR-10 05.29.57.030000 PM +04:00 |
| Add space to the tablespace | ||||
**********
ORA-01187: cannot read from file 203 because it failed verification tests ORA-01110: data file 203: 'F:\SAGEMOBILE_TEMP01.DBF'
SELECT TS.TABLESPACE_NAME "TABLESPACE
NAME" , TS.BLOCK_SIZE "BLOCK
SIZE" , TS.EXTENT_MANAGEMENT||DECODE(TS.EXTENT_MANAGEMENT, 'LOCAL', ' '||DECODE(ALLOCATION_TYPE, 'SYSTEM', 'AUTOALLOCATE', 'UNIFORM', 'UNIFORM SIZE', '')||'', '') "EXTENT
MANAGEMENT" , TS.SEGMENT_SPACE_MANAGEMENT "SPACE
MGMT" , DECODE( TS.CONTENTS , 'UNDO', ''||TS.CONTENTS||'' , 'TEMPORARY', ''||TS.CONTENTS||'' , TS.CONTENTS ) "CONTENTS" , TS.STATUS "STATUS" , DFSIZE.ALLOCATED "ALLOCATED
SPACE" , NVL(FREESPACE.BYTES_FREE, 0) "FREE
SPACE" , DFSIZE.ALLOCATED-NVL(FREESPACE.BYTES_FREE, 0) "USED
SPACE" , DECODE( DFSIZE.ALLOCATED, 0,
It looks like the temp file is missing or corrupt.
You will need to recreate the temporary tablespace
Add your message
If you need more information about this particular error message, you can leave a forum message.
We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.
Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.
In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.
If you do not enter the validation correctly, your message will not be recorded.