Example: DDC file settings

Owned by KrupeshD (Unlicensed)
Last updated: Dec 11, 2013 by Arjen Visser
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

 

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.