ORA-01187: cannot read from file because it failed verification tests

If you get an error like “ORA-01187: cannot read from file because it failed verification tests” after any homogenenous system copy operation on ORACLE database then you should check this article…

Trying creation of controlfile ;

SQL> alter database backup controlfile to trace as ‘<controlfile location>’;

ORA-01187: cannot read from file because it failed verification tests

Let’s check the v$tempfile

SQL> select file#,ts#,name,status from v$tempfile;

ORA-01187: cannot read from file because it failed verification tests

Drop the related TEMP file from the database

SQL> alter database tempfile ‘G:\ORACLE\SID\SAPDATA1\TEMP_1\TEMP.DATA1′ drop;

ORA-01187: cannot read from file because it failed verification tests

Let’s check again v$tempfile should be empty like follow

SQL> select file#,ts#,name,status from v$tempfile;

ORA-01187: cannot read from file because it failed verification tests

Try to create controlfile again

SQL> alter database backup controlfile to trace as ‘<controlfile location>’;

ORA-01187: cannot read from file because it failed verification tests

Add TEMP file to related database

SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE
 ‘G:\ORACLE\SID\SAPDATA1\TEMP_1\TEMP.DATA1′
SIZE 702545920  REUSE AUTOEXTEND ON NEXT 20971520  MAXSIZE 10000M;

ORA-01187: cannot read from file because it failed verification tests

 

Leave a Reply


× five = 30

Blogroll