Re: 오늘의 마지막 문제. 이수자 평가 9번 문

[22기_정민수]

-----------------------------------------------------------------------------------------------------------------------------
-- FAIL OVER (수동)
-----------------------------------------------------------------------------------------------------------------------------
-- 데이터가드 구동 상태 확인.
SQL(SYS@NEROSTBY)>
SELECT process, status FROM v$managed_standby;

-- 장애 시뮬레이션 ( DB 정지 )
SQL(SYS@NERO)>
shutdown abort

-----------------------------------------------------------------------------------------------------------------------------
-- STANDBY DB에서 복구 조치 (standby -> primary)
-----------------------------------------------------------------------------------------------------------------------------
SQL(SYS@NEROSTBY)>

ALTER DATABASE recover managed standby database cancel;
-- 비동기 방식의 경우 REDO 일치 시키기
ALTER DATABASE recover managed standby database finish;

ALTER DATABASE activate standby database;
ALTER DATABASE OPEN;

SELECT database_role, open_mode FROM v$database;

-----------------------------------------------------------------------------------------------------------------------------
-- FAIL OVER (데이터가드 브로커)
-----------------------------------------------------------------------------------------------------------------------------
dgmgrl
DGMGRL> 
connect sys/oracle@NEROSTBY

failover to 'NEROSTBY';

show configuration;


-----------------------------------------------------------------------------------------------------------------------------
-- 검수
-----------------------------------------------------------------------------------------------------------------------------
select database_role, open_mode from v$database;