今天去DG备库上生成报告，然后给了一段提示：
ORA-01187: cannot read from file because it failed verification tests
ORA-01110: data file 201: ‘/oradata/seven/temp01.dbf’
临时表空间坏了？查看一下大小，跟主库不一样，主库6G，备库只有50M，真是怪了。
SQL>SELECT FILE_ID,FILE_NAME, STATUS FROM DBA_TEMP_FILES;
ERROR at line 1:
ORA-01187: cannot read from file 201 because it failed verification tests
ORA-01110: data file 201: ‘/u03/oradata/AGX/temp01.dbf’
SQL> select name,bytes/1024/1024,status from v$tempfile;
NAME BYTES/1024/1024 STATUS
/oradata/seven/temp01.dbf 30 ONLINE
直接开干吧，老外说可以让系统检查一下，我试了一下，没用：
SQL>ALTER SYSTEM CHECK DATAFILES；
删除临时文件：
SQL> alter database tempfile ‘/oradata/seven/temp01.dbf’ drop;
Database altered.
SQL> select name,bytes/1024/1024,status from v$tempfile;
no rows selected
重新添加临时数据文件：
SQL> alter tablespace temp add tempfile ‘/oradata/seven/temp01.dbf’ size 30M reuse autoextend on;
Tablespace altered.
SQL> select name,bytes/1024/1024,status from v$tempfile;
NAME BYTES/1024/1024 STATUS
/oradata/seven/temp01.dbf 30 ONLINE