ORA-ActiveDuplicate.md

ORACLE Active Duplicate

• DB refresh with RMAN DUPLICATE command

• Oracle Replication Products

• Data Guard replication setting

• 4種類のRMAN DUPLICATEでそれぞれ実際にデータベースをコピーする

• Duplicate from Active database

• DataGuard構築後に使うSQLコマンドまとめ（逆引き）

• Dataguard status

  -- from slave database
  https://dbtut.com/index.php/2020/01/30/how-to-check-data-guard-status/

• Dataguard sql reference

  -- check master setting
  SELECT DEST_NAME,RECOVERY_MODE FROM V$ARCHIVE_DEST_STATUS WHERE TYPE = 'PHYSICAL';
  -- check slave setting
  SELECT PROCESS,STATUS FROM V$MANAGED_STANDBY WHERE PROCESS LIKE 'MRP%';

• RESTORE AND RECOVER STANDBY DATABASE FROM NETWORK SERVICE