4、重建成功，启动到open
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> alter database open;
Database altered.
添加临时表空间数据文件：
SQL> select name from v$tempfile;
no rows selected
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS
UNDOTBS2
EXAMPLE
7 rows selected.
SQL> alter tablespace temp add
2 tempfile '/u01/app/oracle/oradata/prod/temp01.dbf' size 100m reuse;
Tablespace altered.
SQL> select name from v$tempfile;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/prod/temp01.dbf
5、修改cluster_database参数，启动所有instance
SQL> alter system set cluster_database =true scope=spfile;
System altered.
启动所有Instance，如果所有instance启动成功，则controlfile重建成功。