Cpp五条

这个屌丝很懒，什么也没留下！

热门标签

oracle rac instance切换,Oracle RAC 更改instance name完整步骤

作者：Cpp五条 | 2024-02-19 13:55:56

踩

oracle rac切换实例export

2. 停止2台节点的数据库(2个节点运行，当然也可以使用srvctl)

SQL> conn /as sysdba

Connected.

SQL> shutdown immediate

Database closed.

Database dismounted.

Oracle instance shut down.

SQL>

再来看看状态：

[root@rac1 tmp]# /u01/app/crs/bin/crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.orcl.db application OFFLINE OFFLINE

ora....l1.inst application OFFLINE OFFLINE

ora....l2.inst application OFFLINE OFFLINE

ora....SM1.asm application ONLINE ONLINE rac1

ora....C1.lsnr application ONLINE ONLINE rac1

ora.rac1.gsd application ONLINE ONLINE rac1

ora.rac1.ons application ONLINE ONLINE rac1

ora.rac1.vip application ONLINE ONLINE rac1

ora....SM2.asm application ONLINE ONLINE rac2

ora....C2.lsnr application ONLINE ONLINE rac2

ora.rac2.gsd application ONLINE ONLINE rac2

ora.rac2.ons application ONLINE ONLINE rac2

ora.rac2.vip application ONLINE ONLINE rac2

可以看到instance都已经停止。

3. 修改 .bash_profile的ORACLE_SID的环境变量,其他的不需要修改(2个节点)

export ORACLE_SID=orcl3

export ORACLE_SID=orcl4

4. 通过pfile启动数据库(2个节点运行)

SQL> conn /as sysdba

Connected to an idle instance.

SQL> startup pfile='/tmp/pfile';

ORACLE instance started.

Total System Global Area 167772160 bytes

Fixed Size 1218316 bytes

Variable Size 88082676 bytes

Database Buffers 75497472 bytes

Redo Buffers 2973696 bytes

Database mounted.

Database opened.

再查看相关RAC状态：