RAC One Node的Failover

来源：互联网发布：碰碰交友软件编辑：程序博客网时间：2024/05/22 06:55

1.查看现在数据库运行的节点，是在rac1：

[oracle@rac1 ~]$ srvctl status database -d ronInstance ron_1 is running on node rac1Online relocation: INACTIVE

2.联机迁移到rac2

[root@rac1 bin]# ./srvctl relocate database -d ron -n rac2 -w 15 -vConfiguration updated to two instancesInstance ron_2 startedServices relocatedWaiting for up to 15 minutes for instance ron_1 to stop ...Instance ron_1 stoppedConfiguration updated to one instance

3.查看现在数据库运行的节点，跑到了rac2：

[root@rac1 bin]# ./srvctl status database -d ronInstance ron_2 is running on node rac2Online relocation: INACTIVE

4.如果这个时候有活动事务呢？

SQL> create table lm_t1(id number);Table created.SQL> insert into lm_t1 values(66);1 row created.SQL>未提交。

5.执行廉洁迁移到rac1

[root@rac2 bin]# ./srvctl relocate database -d ron -n rac1 -w 1 -vConfiguration updated to two instancesInstance ron_1 startedServices relocatedWaiting for up to 1 minutes for instance ron_2 to stop ...

6.提交

SQL> commit;Commit complete.

[root@rac2 bin]# ./srvctl relocate database -d ron -n rac1 -w 1 -vConfiguration updated to two instancesInstance ron_1 startedServices relocatedWaiting for up to 1 minutes for instance ron_2 to stop ...Instance ron_2 stoppedConfiguration updated to one instance

7.查看状态

[root@rac2 bin]# ./srvctl status database -d ronInstance ron_1 is running on node rac1Online relocation: INACTIVE

又回来了！！！

0 0