●フィジカル・スタンバイの作成 タスク7: フィジカル・スタンバイ・データベースが正しく実行されているかどうかの確認＜プライマリ＞col LOG_MODE for a15col PROTECTION_MODE for a20col DATABASE_ROLE for a15col FORCE_LOGGING for a15SELECT LOG_MODE, PROTECTION_MODE, DATABASE_ROLE, FORCE_LOGGING FROM V$DATABASE;
LOG_MODE PROTECTION_MODE DATABASE_ROLE FORCE_LOGGING--------------- -------------------- --------------- ---------------ARCHIVELOG MAXIMUM PERFORMANCE PRIMARY YES
SELECT RECOVERY_MODE FROM V$ARCHIVE_DEST_STATUS WHERE DEST_NAME='LOG_ARCHIVE_DEST_2';
RECOVERY_MODE----------------------------------MANAGED REAL TIME APPLY
set lines 10000col name for a100SELECT SEQUENCE#, NAME, STATUS FROM V$ARCHIVED_LOG ORDER BY 1; SEQUENCE# NAME STA---------- ---------------------------------------------------------------------------------------------------- --- 21 /u01/app/oracle/recovery_area/ORCL/archivelog/2023_09_16/o1_mf_1_21_ljbg2cwo_.arc A 22 sorcl A 22 /u01/app/oracle/recovery_area/ORCL/archivelog/2023_09_17/o1_mf_1_22_ljd5vlsx_.arc A 23 sorcl A 23 /u01/app/oracle/recovery_area/ORCL/archivelog/2023_09_17/o1_mf_1_23_ljfq2pgf_.arc A↑シーケンス番号ごとに2行表示されている
＜スタンバイ＞SELECT PROCESS, PID, STATUS FROM V$MANAGED_STANDBY WHERE PROCESS='MRP0';
PROCESS PID STATUS----------- -------- -----------------MRP0 9702 APPLYING_LOG↑リカバリーを行うMRP0プロセスがAPPLYING_LOG
SELECT SEQUENCE#, NAME, STATUS FROM V$ARCHIVED_LOG ORDER BY 1;
SEQUENCE# NAME STA---------- -------------------------------------------------------------------------------------- --- 11 D 12 D 13 /u01/app/oracle/recovery_area/SORCL/archivelog/2023_09_15/o1_mf_1_13_lj6fg54g_.arc A 14 /u01/app/oracle/recovery_area/SORCL/archivelog/2023_09_15/o1_mf_1_14_lj6fg544_.arc A 15 /u01/app/oracle/recovery_area/SORCL/archivelog/2023_09_15/o1_mf_1_15_lj6fg54r_.arc A 16 /u01/app/oracle/recovery_area/SORCL/archivelog/2023_09_15/o1_mf_1_16_lj6fg5cc_.arc A 17 /u01/app/oracle/recovery_area/SORCL/archivelog/2023_09_15/o1_mf_1_17_lj6fg715_.arc A 18 /u01/app/oracle/recovery_area/SORCL/archivelog/2023_09_15/o1_mf_1_18_lj6fg9qd_.arc A 19 /u01/app/oracle/recovery_area/SORCL/archivelog/2023_09_15/o1_mf_1_19_lj6fg9r0_.arc A 20 /u01/app/oracle/recovery_area/SORCL/archivelog/2023_09_16/o1_mf_1_20_lj90pgmp_.arc A 21 /u01/app/oracle/recovery_area/SORCL/archivelog/2023_09_16/o1_mf_1_21_ljbg2cz6_.arc A 22 /u01/app/oracle/recovery_area/SORCL/archivelog/2023_09_17/o1_mf_1_22_ljd5vlxx_.arc A 23 /u01/app/oracle/recovery_area/SORCL/archivelog/2023_09_17/o1_mf_1_23_ljfq2pkm_.arc A※シーケンス番号がプライマリと同じ
SELECT COUNT(*) FROM V$ARCHIVE_GAP;
COUNT(*)---------- 0↑受信キャップがない
set lines 10000set pages 10000col ROLE for a30SELECT ROLE, THREAD#, SEQUENCE#, ACTION FROM V$DATAGUARD_PROCESS;
ROLE THREAD# SEQUENCE# ACTION------------------------------ ---------- ---------- ------------------------------------log writer 0 0 IDLEredo transport monitor 0 0 IDLEgap manager 0 0 IDLEredo transport timer 0 0 IDLEarchive local 0 0 IDLEarchive redo 0 0 IDLEarchive redo 0 0 IDLEarchive redo 0 0 IDLEmanaged recovery 0 0 IDLErecovery logmerger 1 24 APPLYING_LOGrecovery apply slave 0 0 IDLErecovery apply slave 0 0 IDLERFS ping 1 24 IDLERFS archive 0 0 IDLERFS archive 0 0 IDLERFS archive 0 0 IDLERFS async 1 24 IDLE
17行が選択されました。
●テストdatag1にてCREATE TABLE emp ( empno VARCHAR2(10) NOT NULL, empname VARCHAR2(50), gender_f NUMBER(1,0) );
select GROUP#,SEQUENCE#,ARCHIVED,STATUS from v$log; GROUP# SEQUENCE# ARCHIVED STATUS---------- ---------- --------- ------------------------------------------------ 1 13 YES INACTIVE 2 14 NO CURRENT 3 12 YES INACTIVE
alter system archive log current;
GROUP# SEQUENCE# ARCHIVED STATUS---------- ---------- --------- ------------------------------------------------ 1 13 YES INACTIVE 2 14 YES ACTIVE 3 15 NO CURRENT