DG库临时表空间数据文件报错：ORA-01186 ORA-01122 ORA-01110 ORA-01130 ORA-01258

查看DG库alert日志，报错如下，临时表空间数据文件无法识别。

Errors in file /u01/app/oracle/diag/rdbms/XXXX/XXXX/trace/XXXX_ora_45537.trc:
ORA-01122: database file 5001 failed verification check
ORA-01110: data file 5001: '/XXXXXX/datafile/temp01.dbf'
ORA-01130: database file version 11.2.0.4.0 incompatible with ORACLE version 11.2.0.0.0
Errors in file /u01/app/oracle/diag/rdbms/XXXXXX/XXXXXX/trace/XXXXXX_ora_45537.trc:
ORA-01258: unable to delete temporary file /XXXXXX/datafile/temp01.dbf
Completed:  alter database tempfile '/XXXXXX/datafile/temp01.dbf' drop including datafiles
alter database tempfile '/XXXXXX/datafile/temp02.dbf' drop including datafiles

处理方法，新建临时表空间数据文件：

alter database open read only;
 alter system set standby_file_management=manual scope=memory;

创建新的tempfile

 alter tablespace temp add tempfile '/XXXXXX/datafile/temp03.dbf' size 20G; 
 alter tablespace temp add tempfile '/XXXXXX/datafile/temp04.dbf' size 20G;
 ```
删除报错的tempfile
```sql
 alter database tempfile '/XXXXXX/datafile/temp01.dbf' offline;
 alter database tempfile '/XXXXXX/datafile/temp02.dbf' offline;
 alter database tempfile '/XXXXXX/datafile/temp01.dbf' drop including datafiles;
 alter database tempfile '/XXXXXX/datafile/temp02.dbf' drop including datafiles;