Software Knowledge

  1. Home
  2. Docs
  3. Software Knowledge
  4. Database
  5. Oracle: Temp file corrupt after restore database via rman
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Oracle: Temp file corrupt after restore database via rman

ORA-01187: cannot read from file 209 because it failed verification tests
ORA-01110: data file 209: ‘/oradata/temp01.dbf’

SQL> SELECT FILE_ID,FILE_NAME, STATUS FROM DBA_TEMP_FILES;

ERROR at line 1:
ORA-01187: cannot read from file 209 because it failed verification tests
ORA-01110: data file 209: ‘/oradata/temp01.dbf’

Resolved:

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE ‘/oradata/temp02.dbf’ size50M;
SQL> ALTER TABLESPACE TEMP DROP TEMPFILE ‘/oradata/temp01.dbf’ ;