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

 

Symptoms

1.Query a table to prompt the following error

ERROR at line 1:
ORA-01187: cannot read from file 44 because it failed verification tests
ORA-01110: data file 44: ‘+DATA4/ispro/datafile/fttxwkf_tbs.1021.885226031’

2. Check tablespaces status, it shows all are online

3. Check datafiles status, it show all are available

Fixed: Do system check datafiles to the database

SQL> alter system check datafiles;

 

 

%d bloggers like this: