Switchover

Standby로 switchover

Primary에 DGMGRL로 접속

dgmgrl sys/oracle@ORCL
[oracle@orcl ~]$ dgmgrl sys/oracle@ORCL
DGMGRL for Linux: Release 18.0.0.0.0 - Production on Mon Sep 10 15:41:25 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected to "ORCL"
Connected as SYSDBA.

 

Standby로 switchover

SWITCHOVER TO orcl_stb;
DGMGRL> SWITCHOVER TO orcl_stb;
Performing switchover NOW, please wait...
Operation requires a connection to database "orcl_stb"
Connecting ...
Connected to "ORCL_STB"
Connected as SYSDBA.
New primary database "orcl_stb" is opening...
Operation requires start up of instance "orcl" on database "orcl"
Starting instance "orcl"...
Connected to an idle instance.
ORACLE instance started.
Database mounted.
Connected to "ORCL"
Switchover succeeded, new primary is "orcl_stb"

 

Switchover 결과 확인

SHOW CONFIGURATION;
SHOW DATABASE orcl;
SHOW DATABASE orcl_stb;
DGMGRL> SHOW CONFIGURATION;

Configuration - dg_orcl

  Protection Mode: MaxPerformance
  Members:
  orcl_stb - Primary database
    orcl     - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 77 seconds ago)

DGMGRL> SHOW DATABASE orcl;

Database - orcl

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 1 second ago)
  Apply Lag:          0 seconds (computed 1 second ago)
  Average Apply Rate: 210.00 KByte/s
  Real Time Query:    OFF
  Instance(s):
    orcl

Database Status:
SUCCESS

DGMGRL> SHOW DATABASE orcl_stb;

Database - orcl_stb

  Role:               PRIMARY
  Intended State:     TRANSPORT-ON
  Instance(s):
    orcl

Database Status:
SUCCESS

 

Switchover 결과 확인

SELECT instance_name, status FROM v$instance;
SELECT db_unique_name, database_role, switchover_status, dataguard_broker FROM v$database;
SQL> SELECT instance_name, status FROM v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
orcl             MOUNTED

SQL> SELECT db_unique_name, database_role, switchover_status, dataguard_broker FROM v$database;

DB_UNIQUE_NAME                 DATABASE_ROLE    SWITCHOVER_STATUS    DATAGUAR
------------------------------ ---------------- -------------------- --------
ORCL                           PRIMARY          TO STANDBY           ENABLED
SQL> SELECT instance_name, status FROM v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
orcl             OPEN

SQL> SELECT db_unique_name, database_role, switchover_status, dataguard_broker FROM v$database;

DB_UNIQUE_NAME                 DATABASE_ROLE    SWITCHOVER_STATUS    DATAGUAR
------------------------------ ---------------- -------------------- --------
ORCL_STB                       PRIMARY          TO STANDBY           ENABLED

 

Primary로 복원

Standby에 DGMGRL로 접속

dgmgrl sys/oracle@ORCL_STB
[oracle@orcl ~]$ dgmgrl sys/oracle@ORCL_STB
DGMGRL for Linux: Release 18.0.0.0.0 - Production on Mon Sep 10 15:54:25 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected to "ORCL_STB"
Connected as SYSDBA.

 

Primary로 switchover

SWITCHOVER TO orcl;
DGMGRL> SWITCHOVER TO orcl;
Performing switchover NOW, please wait...
Operation requires a connection to database "orcl"
Connecting ...
Connected to "ORCL"
Connected as SYSDBA.
New primary database "orcl" is opening...
Operation requires start up of instance "orcl" on database "orcl_stb"
Starting instance "orcl"...
Connected to an idle instance.
ORACLE instance started.
Database mounted.
Connected to "ORCL_STB"
Switchover succeeded, new primary is "orcl"

 

복원 결과 확인

SHOW CONFIGURATION;
SHOW DATABASE orcl;
SHOW DATABASE orcl_stb;
DGMGRL> SHOW CONFIGURATION;

Configuration - dg_orcl

  Protection Mode: MaxPerformance
  Members:
  orcl     - Primary database
    orcl_stb - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 71 seconds ago)

DGMGRL> SHOW DATABASE orcl;

Database - orcl

  Role:               PRIMARY
  Intended State:     TRANSPORT-ON
  Instance(s):
    orcl

Database Status:
SUCCESS

DGMGRL> SHOW DATABASE orcl_stb;

Database - orcl_stb

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 0 seconds ago)
  Apply Lag:          0 seconds (computed 0 seconds ago)
  Average Apply Rate: 386.00 KByte/s
  Real Time Query:    OFF
  Instance(s):
    orcl

Database Status:
SUCCESS

 

복원 결과 확인

SELECT instance_name, status FROM v$instance;
SELECT db_unique_name, database_role, switchover_status, dataguard_broker FROM v$database;
SQL> SELECT instance_name, status FROM v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
orcl             OPEN

SQL> SELECT name, database_role, switchover_status, dataguard_broker FROM v$database;

NAME      DATABASE_ROLE    SWITCHOVER_STATUS    DATAGUAR
--------- ---------------- -------------------- --------
ORCL      PRIMARY          TO STANDBY           ENABLED
SQL> SELECT instance_name, status FROM v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
orcl             MOUNTED

SQL> SELECT name, database_role, switchover_status, dataguard_broker FROM v$database;

NAME      DATABASE_ROLE    SWITCHOVER_STATUS    DATAGUAR
--------- ---------------- -------------------- --------
ORCL      PHYSICAL STANDBY NOT ALLOWED          ENABLED