Oracle主(单机)备(两节点RAC)切换.txt

明靓

云和恩墨交付战队

585

7页

18次

2023-02-21

10墨值下载

Oracle 单机主库和两节点的 RAC dg 库（简称 DG 库 A）主备切换,另外老主库还有一个单节点 dg（简称 DG

库 B），需要转移到切换后的俩节点主库上

一、切换前准备及检查

1.standby redo 配置（可提前创建）

select GROUP#,MEMBER from v$logfile where type='STANDBY'

检查路径是否可生成

select THREAD#,GROUP#,BYTES,BLOCKSIZE from v$standby_log;

检查 THREAD#，大小，组数，Blocksize。

#主库删除 standby redo 脚本

#alter database disable thread 2;

#alter database drop logfile group 2;

alter database add standby logfile thread 1 group 11

'/u01/oradata/prod/standbylog11.log' size 500M;

alter database add standby logfile thread 1 group 12

'/u01/oradata/prod/standbylog12.log' size 500M;

alter database add standby logfile thread 1 group 13

'/u01/oradata/prod/standbylog13.log' size 500M;

alter database add standby logfile thread 1 group 14

'/u01/oradata/prod/standbylog14.log' size 500M;

alter database add standby logfile thread 2 group 15

'/u01/oradata/prod/standbylog15.log' size 500M;

alter database add standby logfile thread 2 group 16

'/u01/oradata/prod/standbylog16.log' size 500M;

alter database add standby logfile thread 2 group 17

'/u01/oradata/prod/standbylog17.log' size 500M;

alter database add standby logfile thread 2 group 18

'/u01/oradata/prod/standbylog18.log' size 500M;

10:18:07 SYS@prod>select * from v$logfile where TYPE='STANDBY' order by GROUP#;

GROUP# STATUS TYPE MEMBER IS_

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

---

11 STANDBY /u01/oradata/prod/standbylog11.log NO

12 STANDBY /u01/oradata/prod/standbylog12.log NO

13 STANDBY /u01/oradata/prod/standbylog13.log NO

14 STANDBY /u01/oradata/prod/standbylog14.log NO

15 STANDBY /u01/oradata/prod/standbylog15.log NO

16 STANDBY /u01/oradata/prod/standbylog16.log NO

17 STANDBY /u01/oradata/prod/standbylog17.log NO

18 STANDBY /u01/oradata/prod/standbylog18.log NO

8 rows selected.

#DG 库 A 处理 standby redo

alter database recover managed standby database cancel;

alter database add standby logfile thread 2 group 24 '+DATA' size 500M;

alter database add standby logfile thread 2 group 25 '+DATA' size 500M;

alter database add standby logfile thread 2 group 26 '+DATA' size 500M;

alter database add standby logfile thread 2 group 27 '+DATA' size 500M;

10:20:40 SYS@orcl1>select * from v$logfile where TYPE='STANDBY' order by GROUP#;

GROUP# STATUS TYPE MEMBER

IS_

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

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

20 STANDBY +DATA/orcl/onlinelog/group_20.540.1116407163

21 STANDBY +DATA/orcl/onlinelog/group_21.541.1116407167

22 STANDBY +DATA/orcl/onlinelog/group_22.542.1116407169

23 STANDBY +DATA/orcl/onlinelog/group_23.543.1116407169

24 STANDBY +DATA/orcl/onlinelog/group_24.762.1120213235

25 STANDBY +DATA/orcl/onlinelog/group_25.763.1120213239

26 STANDBY +DATA/orcl/onlinelog/group_26.764.1120213239

27 STANDBY +DATA/orcl/onlinelog/group_27.765.1120213241

8 rows selected.

alter database recover managed standby database using current logfile disconnect

from session;

#DG 库 B 处理 standby redo

alter database recover managed standby database cancel;

alter database drop logfile group 15;

alter database drop logfile group 16;

alter database add standby logfile thread 2 group 15

'/u01/app/oracle/oradata/proddg/onlinelog/standbylog15.log' size 500M;

alter database add standby logfile thread 2 group 16

'/u01/app/oracle/oradata/proddg/onlinelog/standbylog16.log' size 500M;

alter database add standby logfile thread 2 group 17

'/u01/app/oracle/oradata/proddg/onlinelog/standbylog17.log' size 500M;

alter database add standby logfile thread 2 group 18

'/u01/app/oracle/oradata/proddg/onlinelog/standbylog18.log' size 500M;

10:40:02 SYS@proddg>select * from v$logfile where TYPE='STANDBY' order by

GROUP#;

GROUP# STATUS TYPE MEMBER

IS_

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

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

11 STANDBY

/u01/app/oracle/oradata/proddg/onlinelog/standbylog11.log NO

12 STANDBY

/u01/app/oracle/oradata/proddg/onlinelog/standbylog12.log NO

13 STANDBY

/u01/app/oracle/oradata/proddg/onlinelog/standbylog13.log NO

14 STANDBY

/u01/app/oracle/oradata/proddg/onlinelog/standbylog14.log NO

15 STANDBY

/u01/app/oracle/oradata/proddg/onlinelog/standbylog15.log NO

16 STANDBY

/u01/app/oracle/oradata/proddg/onlinelog/standbylog16.log NO

17 STANDBY

Oracle 单机主库和两节点的 RAC dg 库（简称 DG 库 A）主备切换,另外老主库还有一个单节点 dg（简称 DG

库 B），需要转移到切换后的俩节点主库上

一、切换前准备及检查

1.standby redo 配置（可提前创建）

select GROUP#,MEMBER from v$logfile where type='STANDBY'

检查路径是否可生成

select THREAD#,GROUP#,BYTES,BLOCKSIZE from v$standby_log;

检查 THREAD#，大小，组数，Blocksize。

#主库删除 standby redo 脚本

#alter database disable thread 2;

#alter database drop logfile group 2;

alter database add standby logfile thread 1 group 11

'/u01/oradata/prod/standbylog11.log' size 500M;

alter database add standby logfile thread 1 group 12

'/u01/oradata/prod/standbylog12.log' size 500M;

alter database add standby logfile thread 1 group 13

'/u01/oradata/prod/standbylog13.log' size 500M;

alter database add standby logfile thread 1 group 14

'/u01/oradata/prod/standbylog14.log' size 500M;

alter database add standby logfile thread 2 group 15

'/u01/oradata/prod/standbylog15.log' size 500M;

alter database add standby logfile thread 2 group 16

'/u01/oradata/prod/standbylog16.log' size 500M;

alter database add standby logfile thread 2 group 17

'/u01/oradata/prod/standbylog17.log' size 500M;

alter database add standby logfile thread 2 group 18

'/u01/oradata/prod/standbylog18.log' size 500M;

10:18:07 SYS@prod>select * from v$logfile where TYPE='STANDBY' order by GROUP#;

GROUP# STATUS TYPE MEMBER IS_

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

---

11 STANDBY /u01/oradata/prod/standbylog11.log NO

12 STANDBY /u01/oradata/prod/standbylog12.log NO

13 STANDBY /u01/oradata/prod/standbylog13.log NO

14 STANDBY /u01/oradata/prod/standbylog14.log NO

15 STANDBY /u01/oradata/prod/standbylog15.log NO

16 STANDBY /u01/oradata/prod/standbylog16.log NO

17 STANDBY /u01/oradata/prod/standbylog17.log NO

18 STANDBY /u01/oradata/prod/standbylog18.log NO

8 rows selected.

#DG 库 A 处理 standby redo

alter database recover managed standby database cancel;

alter database add standby logfile thread 2 group 24 '+DATA' size 500M;

alter database add standby logfile thread 2 group 25 '+DATA' size 500M;

alter database add standby logfile thread 2 group 26 '+DATA' size 500M;

alter database add standby logfile thread 2 group 27 '+DATA' size 500M;

10:20:40 SYS@orcl1>select * from v$logfile where TYPE='STANDBY' order by GROUP#;

GROUP# STATUS TYPE MEMBER

IS_

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

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

20 STANDBY +DATA/orcl/onlinelog/group_20.540.1116407163

21 STANDBY +DATA/orcl/onlinelog/group_21.541.1116407167

22 STANDBY +DATA/orcl/onlinelog/group_22.542.1116407169

23 STANDBY +DATA/orcl/onlinelog/group_23.543.1116407169

24 STANDBY +DATA/orcl/onlinelog/group_24.762.1120213235

25 STANDBY +DATA/orcl/onlinelog/group_25.763.1120213239

26 STANDBY +DATA/orcl/onlinelog/group_26.764.1120213239

27 STANDBY +DATA/orcl/onlinelog/group_27.765.1120213241

8 rows selected.

alter database recover managed standby database using current logfile disconnect

from session;

#DG 库 B 处理 standby redo

alter database recover managed standby database cancel;

alter database drop logfile group 15;

alter database drop logfile group 16;

alter database add standby logfile thread 2 group 15

'/u01/app/oracle/oradata/proddg/onlinelog/standbylog15.log' size 500M;

alter database add standby logfile thread 2 group 16

'/u01/app/oracle/oradata/proddg/onlinelog/standbylog16.log' size 500M;

alter database add standby logfile thread 2 group 17

'/u01/app/oracle/oradata/proddg/onlinelog/standbylog17.log' size 500M;

alter database add standby logfile thread 2 group 18

'/u01/app/oracle/oradata/proddg/onlinelog/standbylog18.log' size 500M;

10:40:02 SYS@proddg>select * from v$logfile where TYPE='STANDBY' order by

GROUP#;

GROUP# STATUS TYPE MEMBER

IS_

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

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

11 STANDBY

/u01/app/oracle/oradata/proddg/onlinelog/standbylog11.log NO

12 STANDBY

/u01/app/oracle/oradata/proddg/onlinelog/standbylog12.log NO

13 STANDBY

/u01/app/oracle/oradata/proddg/onlinelog/standbylog13.log NO

14 STANDBY

/u01/app/oracle/oradata/proddg/onlinelog/standbylog14.log NO

15 STANDBY

/u01/app/oracle/oradata/proddg/onlinelog/standbylog15.log NO

16 STANDBY

/u01/app/oracle/oradata/proddg/onlinelog/standbylog16.log NO

17 STANDBY

of 7

10墨值下载

关注

评论