DG保护模式切换

137 阅读 0 评论 91 点赞

我是靠谱客的博主冷酷铃铛，这篇文章主要介绍DG保护模式切换，现在分享给大家，希望可以做个参考。

ADG三种模式切换及介绍
1.1切换到最大保护模式(PERFORMANCE-->PROTECTION)

复制代码

--主库
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM PERFORMANCE  PRIMARY		TO STANDBY
--备库
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM PERFORMANCE  PHYSICAL STANDBY NOT ALLOWED
--主库操作
--切换到PROTECTION需要重启
alter database set standby database to maximize protection;
alter database set standby database to maximize protection
*
ERROR at line 1:
ORA-01126: database must be mounted in this instance and not open in any
instance

shu immediate
startup mount
alter database set standby database to maximize protection;

Database altered.
alter database open;
--主备库都是下面的输出（database_role肯定是有区别的）
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM PROTECTION   PHYSICAL STANDBY NOT ALLOWED

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
--主库
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM PERFORMANCE  PRIMARY		TO STANDBY
--备库
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM PERFORMANCE  PHYSICAL STANDBY NOT ALLOWED
--主库操作
--切换到PROTECTION需要重启
alter database set standby database to maximize protection;
alter database set standby database to maximize protection
*
ERROR at line 1:
ORA-01126: database must be mounted in this instance and not open in any
instance

shu immediate
startup mount
alter database set standby database to maximize protection;

Database altered.
alter database open;
--主备库都是下面的输出（database_role肯定是有区别的）
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM PROTECTION   PHYSICAL STANDBY NOT ALLOWED

1.2切换到最大可用模式(PERFORMANCE-->AVAILABILITY)

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
--主备库都是下面的输出（database_role肯定是有区别的）
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM PERFORMANCE  PHYSICAL STANDBY NOT ALLOWED
--主库不需要重启
alter database set standby database to maximize availability;

Database altered.
--主备库都是下面的输出（database_role肯定是有区别的）
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM AVAILABILITY PHYSICAL STANDBY NOT ALLOWED

2.1切换到最大性能模式(AVAILABILITY-->PERFORMANCE)

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
--主备库都是下面的输出（database_role肯定是有区别的）
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM AVAILABILITY PHYSICAL STANDBY NOT ALLOWED
--主库操作
alter database set standby database to maximize performance;

Database altered.
--主备库都是下面的输出（database_role肯定是有区别的）
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM PERFORMANCE  PRIMARY		TO STANDBY

2.2切换到最大保护模式(AVAILABILITY-->PROTECTION)

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
--主备库都是下面的输出（database_role肯定是有区别的）
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM AVAILABILITY PRIMARY		TO STANDBY
--主库操作不需要重启
alter database set standby database to maximize protection;

Database altered.
--主备库都是下面的输出（database_role肯定是有区别的）
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM PROTECTION   PRIMARY		TO STANDBY

3.1切换到最大性能模式(PROTECTION-->PERFORMANCE)

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
--主备库都是下面的输出（database_role肯定是有区别的）
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM PROTECTION   PRIMARY		TO STANDBY
--主库操作
alter database set standby database to maximize performance;

Database altered.
--主备库都是下面的输出（database_role肯定是有区别的）
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM PERFORMANCE  PRIMARY		TO STANDBY

3.2切换到最大可用模式(PROTECTION-->AVAILABILITY)

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
--主备库都是下面的输出（database_role肯定是有区别的）
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM PROTECTION   PRIMARY		TO STANDBY
--主库操作
alter database set standby database to maximize availability;

Database altered.
--主备库都是下面的输出（database_role肯定是有区别的）
select name,protection_mode,database_role,switchover_status from v$database;

NAME	  PROTECTION_MODE      DATABASE_ROLE	SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
ORCL	  MAXIMUM AVAILABILITY PRIMARY		TO STANDBY

总结
只有PERFORMANCE切换到PROTECTION模式的时候需要重启到MOUNT状态，其他的无论怎么切换都不需要重启；
还有就是要注意log_archive_dest_n中的参数，AVAILABILITY PROTECTION一定要是LGWR SYNC AFFIRM，PERFORMANCE可以是LGWR或者ARCH