Example: DDC file settings

Owned by Copy Space for Confluence
Sept 24, 2015
DDC file 1-way replication example:

The following DDC file settings shows an example of a 1-way replication process.
The source server is on Linux server:               rac11202node1
The target is on Linux server:                          dbvisit400
The TNS names for the source database is:     orcl
The TNS names for the target database is:      test11202
There is no FETCHER process.

DDC DB

The DDC DB is as follows (orcl-onetime.ddc):

####################################################################################
This file is used only during the setup, then it's contents is loaded as DDC DB into mine database
#################################################################################### 
@/home/oracle/orcl/orcl-MINE.ddc
set DDC_NAME orcl
#please update SETUP_SCRIPT_PATH if you move the setup scripts somewhere else -
this will help SUPPORT command to find them when creating Dbvisit Support packages
SET MINE.DDC_BACKUP_DIR /home/oracle/orcl/ddc_backup
SET MINE.FETCHER_ENABLED NO
SET MINE.LOG_FILE /home/oracle/orcl/log/dbvrep_%N_%D.%E
SET MINE.LOG_FILE_TRACE /home/oracle/orcl/log/trace/dbvrep_%N_%D_%I_%U.%E
SET MINE.MINE_ASM AUTO
SET MINE.MINE_DATABASE orcl
SET MINE.MINE_LISTEN_INTERFACE rac11202node1:7901
SET MINE.MINE_PASSWORD 53616c7465645f5f092f0f33aeb4be0371675629612d7ce61e4c4b006a1089e9
SET MINE.MINE_PLOG /home/oracle/orcl/mine/%S.%E
SET MINE.MINE_REMOTE_INTERFACE rac11202node1:7901
SET MINE.MINE_USER dbvrep
SET MINE.ORACLE_HOME /u01/app/11.2.0/grid
SET MINE.SETUP_SCRIPT_PATH /home/oracle/orcl
SET APPLY.APPLY_DATABASE test11202
SET APPLY.APPLY_LISTEN_INTERFACE dbvisit400:7902
SET APPLY.APPLY_PASSWORD 53616c7465645f5f3fa67e0ac06f36a653f0905a9e0b2f18c275c4a5e8ace4da
SET APPLY.APPLY_RDBMS Oracle
SET APPLY.APPLY_REMOTE_INTERFACE dbvisit400:7902
SET APPLY.APPLY_STAGING_DIR /home/oracle/orcl/apply
SET APPLY.APPLY_USER dbvrep
SET APPLY.DDC_BACKUP_DIR /home/oracle/orcl/ddc_backup
SET APPLY.LOG_FILE /home/oracle/orcl/log/dbvrep_%N_%D.%E
SET APPLY.LOG_FILE_TRACE /home/oracle/orcl/log/trace/dbvrep_%N_%D_%I_%U.%E
SET APPLY.SETUP_SCRIPT_PATH /home/oracle/orcl
set NETWORK_TRAFFIC_KEY 951f6ca180f83de089e4dd6935d6c58f
set STATUS_BAR STATUS+LIST

 

orcl-MINE.ddc
memory_set CHECKVARS ON
memory_set ON_WARNING SKIP
memory_set ON_ERROR EXIT
memory_set DDC_ID 1
memory_set DDC_DATABASE orcl
memory_set DDC_PASSWORD 53616c7465645f5f846088cc178d8bb44f9f0cb27201747399b628865de6c084
memory_set DDC_USER dbvrep
memory_set TNS_ADMIN /u01/app/oracle/product/11.2.0/dbhome_1/network/admin
#load rest of the settings from database
load ddcdb
memory_set ON_WARNING SKIP
memory_set ON_ERROR SKIP

 

orcl-APPLY.ddc
The apply DDC file is as follows:
memory_set CHECKVARS ON
memory_set ON_WARNING SKIP
memory_set ON_ERROR EXIT
memory_set DDC_ID 1
memory_set DDC_DATABASE orcl
memory_set DDC_PASSWORD 53616c7465645f5f846088cc178d8bb44f9f0cb27201747399b628865de6c084
memory_set DDC_USER dbvrep
memory_set TNS_ADMIN /u01/app/oracle/product/11.2.0/dbhome_1/network/admin
#load rest of the settings from database
load ddcdb
memory_set ON_WARNING SKIP
memory_set ON_ERROR SKIP

Memory_set command will set the value in APPLY memory and not in the actual metadata. Therefore you see the default value in console as it reads the metadata and not the APPLY memory

DDC file 2-way replication example:

The following DDC file settings shows an example of a 2-way replication process.
The source/target database is on Linux server:           dbvisit51
The target/source database is on Windows server:     win2008-01
The TNS names for the source/target database is:     dbvisit51_w112a
The TNS names for the target/target database is:      win_w112b
There is no FETCHER process.

set CHECKVARS ON
set ON_WARNING SKIP
set ON_ERROR EXIT
set DDC_ID 1
set DDC_NAME w112a2
set SIMPLE_CONFIG NO
set FETCHER.FETCHER_ENABLED NO
set MINE.FETCHER_ENABLED NO
set MINE.MINE_LISTEN_INTERFACE dbvisit51:7892
set MINE.MINE_REMOTE_INTERFACE dbvisit51:7892
set APPLY.MINE_REMOTE_INTERFACE dbvisit51:7892
set APPLY.APPLY_LISTEN_INTERFACE win2008-01:7893
set MINE.APPLY_REMOTE_INTERFACE win2008-01:7893
set APPLY.APPLY_REMOTE_INTERFACE win2008-01:7893
set MINE.MINE_DATABASE dbvisit51_w112a
set MINE.MINE_USER dbvrep2
set MINE.MINE_PASSWORD 53616c7465645f5f28844935a7ca6429892664945779edf04bccc10797
set MINE.MINE_ASM +ASM
set APPLY.APPLY_DATABASE win_w112b
set APPLY.APPLY_USER dbvrep2
set APPLY.APPLY_PASSWORD 53616c7465645f5fe821fbba607902c8077910024a2b2e22d390386ced
set MINE.MINE_PLOG /home/oracle/dbvrep/mine/%S.%E
set APPLY.APPLY_STAGING_DIR C:\app\oracle\dbvrep
set DEBUG_LEVEL 0
set MINE.LOG_FILE dbvrep_%P_%D.%E
set APPLY.LOG_FILE dbvrep_%P_%D.%E
set APPLY.APPLY_TRACE OFF
set MINE.MINE_TRACE OFF
#2nd direction
set FETCHER2.FETCHER_ENABLED NO
set MINE2.FETCHER_ENABLED NO
set MINE2.MINE_LISTEN_INTERFACE win2008-01:7894
set MINE2.MINE_REMOTE_INTERFACE win2008-01:7894
set APPLY2.MINE_REMOTE_INTERFACE win2008-01:7894
set APPLY2.APPLY_LISTEN_INTERFACE dbvisit51:7895
set MINE2.APPLY_REMOTE_INTERFACE dbvisit51:7895
set APPLY2.APPLY_REMOTE_INTERFACE dbvisit51:7895
set MINE2.MINE_DATABASE win_w112b
set MINE2.MINE_USER dbvrep2
set MINE2.MINE_PASSWORD 53616c7465645f5fe821fbba607902c8077910024a2b2e22d390386ced9
set MINE2.MINE_ASM +ASM
set APPLY2.APPLY_DATABASE dbvisit51_w112a
set APPLY2.APPLY_USER dbvrep2
set APPLY2.APPLY_PASSWORD 53616c7465645f5f28844935a7ca6429892664945779edf04bccc10797
set MINE2.MINE_PLOG C:\app\oracle\dbvrep\mine%S.%E
set APPLY2.APPLY_STAGING_DIR /home/oracle/dbvrep/apply
set DEBUG_LEVEL 0
set MINE2.LOG_FILE dbvrep_%P_%D.%E
set APPLY2.LOG_FILE dbvrep_%P_%D.%E
set APPLY2.APPLY_TRACE OFF
set MINE2.MINE_TRACE OFF 
set FETCHER.MINE_PEER=MINE
set APPLY.MINE_PEER=MINE
set MINE.FETCHER_PEER=FETCHER
set APPLY.FETCHER_PEER=FETCHER
set MINE.APPLY_PEER=APPLY
set FETCHER.APPLY_PEER=APPLY 
set FETCHER2.MINE_PEER=MINE2
set APPLY2.MINE_PEER=MINE2
set MINE2.FETCHER_PEER=FETCHER2
set APPLY2.FETCHER_PEER=FETCHER2
set MINE2.APPLY_PEER=APPLY2
set FETCHER2.APPLY_PEER=APPLY2 
set FETCHER.PROCESS_TYPE=FETCHER
set MINE.PROCESS_TYPE=MINE
set APPLY.PROCESS_TYPE=APPLY
set FETCHER2.PROCESS_TYPE=FETCHER
set MINE2.PROCESS_TYPE=MINE
set APPLY2.PROCESS_TYPE=APPLY 
choose process fetcher
choose process mine
choose process apply
set STATUS_BAR ON
set ON_WARNING SKIP
set ON_ERROR SKIP

The use of the following processes to enable 2-way replication:

  • MINE – default MINE process on the first server.
  • MINE2 – Second MINE process to MINE on the second server.
  • APPLY – default APPLY process to APPLY on the second server.
  • APPLY2 – Second APPLY process to APPLY on the first server.