导航：首页 > 数据库 >

maximum protection 转 maximum availability

发表于：2025-02-01 作者：千家信息网编辑

千家信息网最后更新 2025年02月01日，PS：该实验建立在之前DG博客的基础之上的主库之前的状态，执行转换语句，主库之后的状态15:00:01 SYS @ slow >select name,database_role,protection

千家信息网最后更新 2025年02月01日maximum protection 转 maximum availabilityPS：该实验建立在之前DG博客的基础之上的

主库之前的状态，执行转换语句，主库之后的状态

15:00:01 SYS @ slow >select name,database_role,protection_mode from v$database;
NAME DATABASE_ROLE PROTECTION_MODE
--------- ---------------- --------------------
SLOW PRIMARY MAXIMUM PROTECTION
1 row selected.
Elapsed: 00:00:00.00
15:00:35 SYS @ slow >select status from v$instance;
STATUS
------------
OPEN
1 row selected.
Elapsed: 00:00:00.00
18:57:24 SYS @ slow >startup mount force;
ORACLE instance started.
Total System Global Area 521936896 bytes
Fixed Size 2254824 bytes
Variable Size 377489432 bytes
Database Buffers 138412032 bytes
Redo Buffers 3780608 bytes
Database mounted.
18:57:44 SYS @ slow >select name,database_role,protection_mode from v$database;
NAME DATABASE_ROLE PROTECTION_MODE
--------- ---------------- --------------------
SLOW PRIMARY MAXIMUM PROTECTION
1 row selected.
Elapsed: 00:00:00.01
18:58:20 SYS @ slow >select status from v$instance;
STATUS
------------
MOUNTED
1 row selected.
Elapsed: 00:00:00.01
18:58:39 SYS @ slow >alter database set standby database to maximize availability;
Database altered.
Elapsed: 00:00:00.00
19:00:09 SYS @ slow >alter database open;
Database altered.
Elapsed: 00:00:03.03
19:00:25 SYS @ slow >select name,database_role,protection_mode from v$database;
NAME DATABASE_ROLE PROTECTION_MODE
--------- ---------------- --------------------
SLOW PRIMARY MAXIMUM AVAILABILITY
1 row selected.
Elapsed: 00:00:00.00
19:01:20 SYS @ slow >

备库之前的状态，主库执行转换语句，备库之后的状态，，，一切正常，转换成功！！！

14:56:33 SYS @ gotime >select name,database_role,protection_mode from v$database;
NAME DATABASE_ROLE PROTECTION_MODE
--------- ---------------- --------------------
SLOW PHYSICAL STANDBY MAXIMUM PROTECTION
1 row selected.
Elapsed: 00:00:00.00
14:57:21 SYS @ gotime >select status from v$instance;
STATUS
------------
OPEN
1 row selected.
Elapsed: 00:00:00.00
18:56:45 SYS @ gotime >startup mount force;
ORACLE instance started.
Total System Global Area 521936896 bytes
Fixed Size 2254824 bytes
Variable Size 377489432 bytes
Database Buffers 138412032 bytes
Redo Buffers 3780608 bytes
Database mounted.
18:57:07 SYS @ gotime >select name,database_role,protection_mode from v$database;
NAME DATABASE_ROLE PROTECTION_MODE
--------- ---------------- --------------------
SLOW PHYSICAL STANDBY MAXIMUM AVAILABILITY
1 row selected.
Elapsed: 00:00:00.04
19:02:08 SYS @ gotime >