Home > Oracle > ORA-01187: cannot read from file 201 because it failed verification tests

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

you will see the ORA-01187 error mainly when

1. you duplicate your database.
2. you trying to take backup controlfile to trace

when you query dba_temp_files you will see the error
SQL> select FILE_NAME,BYTES from dba_temp_files;
ERROR:
ORA-01187: cannot read from file because it failed verification tests
ORA-01110: data file 204: ‘/u11_2/oradata/nppxch/temp_mi02.dbf’

so to fix the error you can

SQL> alter tablespace TEMP_MI add tempfile '/u10_2/oradata/nppxch/temp_mi01.dbf' size 100M;

Tablespace altered.

SQL> alter database tempfile '/u10_2/oradata/nppxch/temp_mi02.dbf' drop;

Database altered.

This should resolve your issue.

Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: