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

[22기_정민수]

-----------------------------------------------------------------------------------------------------------------------------
-- SQL 공통 
-----------------------------------------------------------------------------------------------------------------------------
-- standby 로그 파일 확인.
SELECT GROUP#, THREAD#, BYTES/1024/1024 MB, STATUS
  FROM V$STANDBY_LOG
 ORDER BY GROUP#;

-----------------------------------------------------------------------------------------------------------------------------
-- Sh
-----------------------------------------------------------------------------------------------------------------------------
mkdir -p /u01/app/oracle/oradata/NEROSTBY


-----------------------------------------------------------------------------------------------------------------------------
-- SQL [SYS@NERO]  사전 준비: standby 리두 로그 구성
-----------------------------------------------------------------------------------------------------------------------------
ALTER DATABASE ADD STANDBY LOGFILE
  GROUP 10 ('/u01/app/oracle/oradata/NERO/stby_redo10.log') SIZE 100M,
  GROUP 11 ('/u01/app/oracle/oradata/NERO/stby_redo11.log') SIZE 100M,
  GROUP 12 ('/u01/app/oracle/oradata/NERO/stby_redo12.log') SIZE 100M,
  GROUP 13 ('/u01/app/oracle/oradata/NERO/stby_redo13.log') SIZE 100M,
  GROUP 14 ('/u01/app/oracle/oradata/NERO/stby_redo14.log') SIZE 100M,
  GROUP 15 ('/u01/app/oracle/oradata/NERO/stby_redo15.log') SIZE 100M;

-----------------------------------------------------------------------------------------------------------------------------
-- SQL [SYS@NEROSTBY] 사전 준비: standby 리두 로그 구성
-----------------------------------------------------------------------------------------------------------------------------
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

shutdown immediate
startup mount

ALTER DATABASE ADD STANDBY LOGFILE
  GROUP 10 ('/u01/app/oracle/oradata/NEROSTBY/stby_redo10.log') SIZE 100M,
  GROUP 11 ('/u01/app/oracle/oradata/NEROSTBY/stby_redo11.log') SIZE 100M,
  GROUP 12 ('/u01/app/oracle/oradata/NEROSTBY/stby_redo12.log') SIZE 100M,
  GROUP 13 ('/u01/app/oracle/oradata/NEROSTBY/stby_redo13.log') SIZE 100M,
  GROUP 14 ('/u01/app/oracle/oradata/NEROSTBY/stby_redo14.log') SIZE 100M,
  GROUP 15 ('/u01/app/oracle/oradata/NEROSTBY/stby_redo15.log') SIZE 100M;
  
  
-----------------------------------------------------------------------------------------------------------------------------
-- SQL [SYS@NEROSTBY] Real-Time Apply 모드로 변경.
-----------------------------------------------------------------------------------------------------------------------------
-- MOUNT -> OPEN(READ ONLY)
ALTER DATABASE OPEN READ ONLY;

-- 연결 프로세스 가동.
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
USING CURRENT LOGFILE DISCONNECT;

-- 연결 프로세스 확인
SELECT process, status 
  FROM v$managed_standby;


PROCESS   STATUS
--------- ------------
ARCH      CONNECTED
DGRD      ALLOCATED
DGRD      ALLOCATED
ARCH      CONNECTED
ARCH      CLOSING
ARCH      CLOSING
RFS       IDLE
RFS       IDLE
RFS       IDLE
MRP0      APPLYING_LOG

-----------------------------------------------------------------------------------------------------------------------------
--SQL [SYS@NERO] Real-Time apply 데이터 가드 검수
-----------------------------------------------------------------------------------------------------------------------------
CONNECT scott/tiger

UPDATE EMP SET sal = 0 WHERE ename = 'KING';

COMMIT;

SELECT COUNT(*) FROM emp;

SELECT empno, ename, sal FROM emp;

-----------------------------------------------------------------------------------------------------------------------------
--SQL [SYS@NEROSTBY] Real-Time apply 데이터 가드 검수
-----------------------------------------------------------------------------------------------------------------------------
CONNECT scott/tiger

SELECT COUNT(*) FROM emp;

SELECT empno, ename, sal FROM emp;