rac存储级别容灾切换步骤

1、修改ip

mv ifcfg-bond0_101 ifcfg-bond0_101.bak
mv ifcfg-bond0.bak ifcfg-bond0
mv ifcfg-bond0:0.bak ifcfg-bond0:0
systemctl restart network

注：ifcfg-bond0_101为临时IP（共远程登录），ifcfg-bond0.bak和ifcfg-bond0:0.bak是提前编辑好的RAC的正式IP

2、重启udev服务

systemctl restart systemd-udev-trigger.service

查看/dev/目录下有没有asm-data1磁盘生成

3、查看ora.cssd的服务是否启动，若没启动则先启动（root用户）

/u01/app/12.1.0/grid/bin/crsctl status res -t
/u01/app/12.1.0/grid/bin/crsctl start resource ora.cssd -unsupported

4、关闭asm实例，并用修改好的pfile启动asm实例

sqlplus / as sysasm
shutdown immediate
startup nomount pfile='/u01/app/12.1.0/grid/dbs/init+ASM.ora';
create spfile='/u01/app/12.1.0/grid/dbs/spfile+ASM.ora' from pfile='/u01/app/12.1.0/grid/dbs/init+ASM.ora';
shutdown immediate;
startup;

5、查看DATA是否挂载成功

sqlplus / as sysasm
select name,path from v$asm_disk where group_number=(select group_number from v$asm_diskgroup where name='DATA');

6、更改/u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle权限

chown oracle:asmadmin /u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle
chmod 6751 /u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle

7、启动数据库并生成spfile

startup nomount pfile='/u01/app/oracle/product/12.1.0/dbhome_1/dbs/initgpp.ora';
create spfile='/u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfilegpp.ora' from pfile='/u01/app/oracle/product/12.1.0/dbhome_1/dbs/initgpp.ora';
shutdown immediate;
startup;

export ORACLE_SID=nbank
startup nomount pfile='/u01/app/oracle/product/12.1.0/dbhome_1/dbs/initnbank.ora';
create spfile='/u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfilegpp.ora' from pfile='/u01/app/oracle/product/12.1.0/dbhome_1/dbs/initnbank.ora';
shutdown immediate;
startup;

一共两个实例

8、生成密码文件

cd /u01/app/oracle/product/12.1.0/dbhome_1/dbs
orapwd file=orapwgpp password=oracle
orapwd file=orapwnabnk password=oracle

9、尝试远程连接，测试数据