?
?
一个表空间offline后alert日志报ORA-01135和ORA-01110的问题(三)
hen the traces are expected and should be of no
concern.
Note that you can also use below query to find offline data files. The point from above steps is to get the data file triggering the error:
SQL> connect / as sysdba
SQL> column file_name format a40;
SQL> column tablespace_name format a12;
SQL> select file_name,file_id,tablespace_name,online_status from dba_data_files order by
tablespace_name, file_id;
Even when the temp file is offline, ORA-01110 is seen in alert log or trace file. Run the sql to check temp files and online or drop it.
SQL>
select file_name, tablespace_name, status from dba_temp_files order by file_name;