问题处理 ：ORA-01157 ORA-01110

Oracle DG库报错

SQL> select * from w.v_result_detail;
select * from w.v_result_detail
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '+DATA'

 

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
+DATA
/u01/app/oracle/oradata/orcl/temp01.dbf
/u01/app/oracle/oradata/orcl/temp02.dbf
/u01/app/oracle/oradata/orcl/temp03.dbf

 

推测原因：搭建RAC的单节点备库，需要指明详细临时表空间临时文件路径。

数据文件+DATA/orcl/datafile  临时文件：+DATA/orcl/tempfile

解决方式：

1、重启备库，清理临时表空间。

2、新增临时表空间文件

alter tablespace temp add tempfile '/u01/app/oracle/oradata/orcl/temp04.dbf' size 20G autoextend on;

alter tablespace temp add tempfile '/u01/app/oracle/oradata/orcl/temp05.dbf' size 20G autoextend on;