Oracle basics: ORA-01187 & ORA-01110

Problem:

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

ORA-01110: data file 201: '/u01/oradata/md/temp01.dbf'

Problem reproduction:

[SQL]

1. Sys @ DENVER>Alter DatabaseBackup controlfileToTraceAs '/Tmp/t1. SQL';
2. Alter DatabaseBackup controlfileToTraceAs '/Tmp/t1. SQL'
3. *
4. ERRORAtLine 1:
5. ORA-01187: cannotRead FromFile because it failed verification tests
6. ORA-01110: data file 201:'/U01/oradata/md/temp01.dbf'

Or

[SQL]

1. Sys @ DENVER>SelectFile_name, statusFromDba_temp_files;
2. SelectFile_name, statusFromDba_temp_files
3. *
4. ERRORAtLine 1:
5. ORA-01187: cannotRead FromFile because it failed verification tests
6. ORA-01110: data file 201:'/U01/oradata/md/temp01.dbf'
9. Sys @ DENVER>SelectFile #, ts #,Name, StatusFromV $ tempfile;
11. FILE # TS #NAMESTATUS
12. -------------------------------------------------------------------
13. 1 3/u01/oradata/md/temp01.dbf ONLINE

Solution:

1. Remove temporary table

2. Recreate the data file.

[SQL]

1. Ys @ DENVER>Alter DatabaseTempfile'/U01/oradata/md/temp01.dbf' Drop;
3. DatabaseAltered.
5. Sys @ DENVER>SelectFile #, ts #,Name, StatusFromV $ tempfile;
7. No RowsSelected
9. Sys @ DENVER>AlterTablespaceTemp AddTempfile'/U01/oradata/md/temp01.dbf' Size512 m reuse;
11. Tablespace altered.
13. Sys @ DENVER>SelectFile_name, statusFromDba_temp_files;
15. FILE_NAME STATUS
16. -----------------------------------------------
17. /U01/oradata/md/temp01.dbf ONLINE