offline tempfile
Hi,
Today I faced a unique situation.
i) I checked the tempfiles
SQL> select file_name,bytes/1024/1024/1024 as GB from dba_temp_files where tablespace_name='TEMP2';
FILE_NAME
--------------------------------------------------------------------------------
GB
----------
+DATA_1 /tempfile/temp2.273.876993405
31.25
ii) Added one tempfile
SQL> alter tablespace TEMP2 add tempfile '+DATA_1' size 10G autoexteNd on maxsize 30G;
Tablespace altered.
iii) checked the tempfiles, found two new files instead of 1.
and the old file got owent offline
SQL> select file_name,bytes/1024/1024/1024 as GB from dba_temp_files where tablespace_name='TEMP2';
FILE_NAME
--------------------------------------------------------------------------------
GB
----------
+DATA_1 /tempfile/temp2.297.913399843
10
+DATA_1 /tempfile/temp2.283.913399909 <how did it get created?>