【DG】三大模式切换

 一：最大性能转最大可用（默认DG是最大性能模式）

1.确认主备数据库模式

1）主库：

SYS@ORA11GR2>select protection_mode,protection_level from v$database;

 

PROTECTION_MODE      PROTECTION_LEVEL

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

MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE

 

SYS@ORA11GR2>

SYS@ORA11GR2>select name,protection_mode,database_role,switchover_status from v$database;

 

NAME      PROTECTION_MODE      DATABASE_ROLE    SWITCHOVER_STATUS

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

ORA11GR2  MAXIMUM PERFORMANCE  PRIMARY          SESSIONS ACTIVE

 

SYS@ORA11GR2>

 

2）备库：

SQL> select name,protection_mode,database_role,switchover_status from v$database;

 

NAME      PROTECTION_MODE      DATABASE_ROLE    SWITCHOVER_STATUS

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

ORA11GR2  MAXIMUM PERFORMANCE  PHYSICAL STANDBY NOT ALLOWED

 

2.主库重启到mount

SYS@ORA11GR2>shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SYS@ORA11GR2>

SYS@ORA11GR2>startup mount;

ORACLE instance started.

 

Total System Global Area  830930944 bytes

Fixed Size                  2257800 bytes

Variable Size             503319672 bytes

Database Buffers          322961408 bytes

Redo Buffers                2392064 bytes

Database mounted.

SYS@ORA11GR2>

 

3.修改参数

SYS@ORA11GR2>alter system set LOG_ARCHIVE_DEST_2='SERVICE=ocm LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=OCMU';

 

System altered.

 

SYS@ORA11GR2>alter database set standby database to maximize availability;

 

Database altered.

 

 

4.打开主库验证：

SYS@ORA11GR2>alter database open;

 

Database altered.

 

SYS@ORA11GR2>select name,protection_mode,database_role,switchover_status from v$database;

 

NAME      PROTECTION_MODE      DATABASE_ROLE    SWITCHOVER_STATUS

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

ORA11GR2  MAXIMUM AVAILABILITY PRIMARY          SESSIONS ACTIVE

 

5.备库确认：

SQL> select name,protection_mode,database_role,switchover_status from v$database;

 

NAME      PROTECTION_MODE      DATABASE_ROLE    SWITCHOVER_STATUS

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

ORA11GR2  MAXIMUM AVAILABILITY PHYSICAL STANDBY NOT ALLOWED

 

——最好把备库也改一下，以便在主备切换时，依旧是最大可用：

SQL> alter system set LOG_ARCHIVE_DEST_2='SERVICE=ora lgwr sync VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ORA11GR2';

 

System altered.

 

二：最大可用模式切换为最大保护模式

（因为最大可用模式和最大保护模式对应的参数都是LGWR和SYNC,所以不需要再改参数了）

 

1.主库操作：

SYS@ORA11GR2>alter database set standby database to maximize protection;

 

Database altered.

 

——查看状态：

SYS@ORA11GR2>select name,protection_mode,database_role,switchover_status from v$database;

 

NAME      PROTECTION_MODE      DATABASE_ROLE    SWITCHOVER_STATUS

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

ORA11GR2  MAXIMUM PROTECTION   PRIMARY          SESSIONS ACTIVE

 

2.查看备库状态：

SQL> select name,protection_mode,database_role,switchover_status from v$database;

 

NAME      PROTECTION_MODE      DATABASE_ROLE    SWITCHOVER_STATUS

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

ORA11GR2  MAXIMUM PROTECTION   PHYSICAL STANDBY NOT ALLOWED

 

备库修改参数，与主库相同，上面已经修改过了；

 

三：最大保护模式转最大性能模式

（最大性能参数问LGWR、SYNC或者ASYNC或者ARCH、SYNC，因为上面已经改为LGWR、SYNC，所以不需要再设置了，直接转换）

 

1.主库：

SYS@ORA11GR2>alter database set standby database to maximize performance;

 

Database altered.

 

SYS@ORA11GR2>select name,protection_mode,database_role,switchover_status from v$database;

 

NAME      PROTECTION_MODE      DATABASE_ROLE    SWITCHOVER_STATUS

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

ORA11GR2  MAXIMUM PERFORMANCE  PRIMARY          SESSIONS ACTIVE

 

SYS@ORA11GR2>

 

2.备库：

SQL> select name,protection_mode,database_role,switchover_status from v$database;

 

NAME      PROTECTION_MODE      DATABASE_ROLE    SWITCHOVER_STATUS

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

ORA11GR2  MAXIMUM PERFORMANCE  PHYSICAL STANDBY NOT ALLOWED

 

最好把备库也改一下，以便在主备切换时，依旧是最大性能。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31397003/viewspace-2126912/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31397003/viewspace-2126912/