In this post, you’ll learn more about the Oracle ErrorORA-01186: file string failed verification tests with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-01186: file string failed verification tests
Reason for the Error ORA-01186: file string failed verification tests
The data file did not pass the checks to insure it is part of the database. See the accompanying error messages for the reason the verification failed.
How to fix the Error ORA-01186: file string failed verification tests ?
You can fix this error in Oracle by following the below steps
Make the correct file available to the database. Then, either open the database, or execute ALTER SYSTEM CHECK DATAFILES.