I. Switchover
1. Standby로 switchover
A) Primary에 DGMGRL로 접속
DGMGRL로 primary DB에 접속
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.
B) Standby로 switchover
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"
C) Switchover 결과 확인
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
D) Switchover 결과 확인
Primary DB와 Standby DB에서 수행
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
2. Primary로 복원
A) Standby에 DGMGRL로 접속
DGMGRL로 standby DB에 접속
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.
B) Primary로 switchover
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"
C) 복원 결과 확인
복원 결과 확인
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
D) 복원 결과 확인
Primary DB와 Standby DB에서 수행
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
