Oracle Study之--Oracle RAC重建控制文件(三)

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重建成功。