After cloning, continuesouly getting ORA-01187 error in alert log files. Following solutions is worked for me.
Error entry in Alert log :
Errors in file /db/diag/rdbms/test/TEST/trace/test_j000_19766.trc:
ORA-01187: cannot read from file because it failed verification tests
ORA-01110: data file 201: '/db/oradata/TEST/temp01.dbf'
Mon Dec 07 02:44:23 2015
Solution:
1. Check temp datafile exist on physical location.
2. Drop the tempfile.
alter database tempfile '/db/oradata/TEST/temp01.dbf' drop;
3. Add new tempfile to TEMP tablespace or Default Temporary tablespace.
alter tablespace TEMP add tempfile '/db/oradata/TEST/temp01.dbf' SIZE 2500M REUSE;
4. check your issue.
If your database having more than one temp tablespace and all giving same error, then you have to drop all temp datafiles and add new tempfile to respective temp tablespace.
Error entry in Alert log :
Errors in file /db/diag/rdbms/test/TEST/trace/test_j000_19766.trc:
ORA-01187: cannot read from file because it failed verification tests
ORA-01110: data file 201: '/db/oradata/TEST/temp01.dbf'
Mon Dec 07 02:44:23 2015
Solution:
1. Check temp datafile exist on physical location.
2. Drop the tempfile.
alter database tempfile '/db/oradata/TEST/temp01.dbf' drop;
3. Add new tempfile to TEMP tablespace or Default Temporary tablespace.
alter tablespace TEMP add tempfile '/db/oradata/TEST/temp01.dbf' SIZE 2500M REUSE;
4. check your issue.
If your database having more than one temp tablespace and all giving same error, then you have to drop all temp datafiles and add new tempfile to respective temp tablespace.
