Oracle数据库克隆后temp文件因路径变化无法找到出现如下报错
Errors in filexxxx.trc:
ORA-01157: cannot identify/lock data file xxx - see DBWR trace file
ORA-01110: data file 201: 'xxx/temp01.dbf'
部分trace文件：
DDE: Problem Key 'ORA 1110' was flood controlled (0x5) (no incident)
ORA-01110: data file 201: 'xxx/temp01.dbf'
ORA-01157: cannot identify/lock data file xxx - see DBWR trace file
ORA-01110: data file 201: 'xxx/temp01.dbf'
Dump of memory from 0x0000000126DCFA78 to 0x0000000126DCFDEA
126DCFA70 48544957 53574D20 [WITH MWS]
126DCFA80 20534120 45532820 5443454C 574F5220 [ AS (SELECT ROW]
126DCFA90 204D554E 2C786469 4E495720 5F574F44 [NUM idx, WINDOW_]
126DCFAA0 454D414E 454E202C 535F5458 54524154 [NAME, NEXT_START]
126DCFAB0 5441445F 64732045 2020202C 20202020 [_DATE sd, ]
处理方法：
1、select * from dba_temp_files;也会报找不到数据文件错误。
可以查询select * from v$tempfile;
2、通过v$tempfile 查看文件，将数据库启动到mount状态，alter database rename file '' to '';修改路径。
3、再打开数据库会自动创建临时数据文件。