【RAC】RAC增加控制文件

1.备份参数文件
# su - oracle
$ export ORACLE_SID=oratest1
SQL> create pfile='/home/oracle/oratest1.ora' from spfile;

2.停止数据库实例
# su - oracle
$ export ORACLE_SID=oratest1
$ srvctl stop database -d oratest

3.拷贝控制文件
# su - grid
$ asmcmd
ASMCMD> cd +DATADG/ORAZBJK/CONTROLFILE
ASMCMD> cp Current.352.1123695493 Current.353

4.修改控制文件参数
# su - oracle
$ export ORACLE_SID=oratest1
$ sqlplus / as sysdba
SQL> startup nomount;
SQL> show parameter control;
SQL> alter system set control_files='+DATADG/ORATEST/CONTROLFILE/Current.352.1123695493','+DATADG/ORATEST/CONTROLFILE/Current.353' scope=spfile;
SQL> shutdown immediate;
SQL> start nomount;
SQL> show parameter control;
SQL> alter database mount;
SQL> alter database open;

5.启动节点二
# su - oracle
$ export ORACLE_SID=oratest2
$ sqlplus / as sysdba
SQL> startup
SQL> show parameter control;"

6.检查数据库实例状态
# su - grid
$ crsctl stat res -t

7.再次备份参数文件
# su - oracle
$ export ORACLE_SID=oratest1
SQL> create pfile='/home/oracle/oratest1.ora' from spfile;