/u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf AVAILABLE ONLINE
/u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf AVAILABLE ONLINE
/u01/app/oracle/oradata/ORA11GR2/system01.dbf AVAILABLE SYSTEM
/u01/app/oracle/oradata/ORA11GR2/ts_users01.dbf AVAILABLE ONLINE
/u01/app/oracle/oradata/ORA11GR2/ts_users02.dbf AVAILABLE ONLINE
7 rows selected.
SYS@ORA11GR2>
16) 转储步骤中还涉及到了临时表空间，我们验证一下，重建控制文件后，临时表空间的情况，没有任何数据文件
SYS@ORA11GR2>select file_name,tablespace_name from dba_temp_files;
no rows selected
SYS@ORA11GR2>
17) 按照转储中的语句给临时表空间增加数据文件
SYS@ORA11GR2>ALTER TABLESPACE TEMP
ADD TEMPFILE '/u01/app/oracle/oradata/ORA11GR2/temp01.dbf'
SIZE 30408704 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;
Tablespace altered.
SYS@ORA11GR2>
18) 临时文件已添加成功
SYS@ORA11GR2>select FILE_NAME,TABLESPACE_NAME from dba_temp_files;
FILE_NAME TABLESPACE_NAME
---------------------------------------------------- ---------------
/u01/app/oracle/oradata/ORA11GR2/temp01.dbf TEMP
SYS@ORA11GR2>
至此，控制文件恢复完毕