DataGuard

Passi:

1- Crea db con nome diverso dall'originale <SIDDBSTBY> Oracle Home indifferente da ODA ad altra ODA Es.:

oakcli create database -db <SIDDBSTBY> -oh OraDb12102_home3

2- Crea il listener per la comunicazione con SID diverso dall'originale <SIDDBSTBY> Es.:

SID_LIST_LISTENER_II_DG =
 (SID_LIST =
  (SID_DESC =
      (SDU=32767)
      (GLOBAL_DBNAME=<SIDDBSTBY>)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/dbhome_3)
      (SID_NAME =<SIDDBSTBY>_1)
      (SERVICE_NAME =<SIDDBSTBY>)
   )
  (SID_DESC =
      (SDU=32767)
      (GLOBAL_DBNAME=<SIDDBSTBY>_DGMGRL)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/dbhome_3)
      (SID_NAME =IIJDEPS_1)
      (SERVICE_NAME =IIJDEPS)
   )
  (SID_DESC =
      (SDU=32767)
      (GLOBAL_DBNAME=<SIDDBSTBY>_DGB)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/dbhome_3)
      (SID_NAME =<SIDDBSTBY>_1)
      (SERVICE_NAME =<SIDDBSTBY>)
   )
 )

QUERY USATE DI CONTROLLO:

  select DB_UNIQUE_NAME from v$database;