This section initialises and starts the replication processes
1. Go in to into the home directory of the replication that has been setup by the setup wizard
| No Format |
|---|
su - oracle |
| No Format |
|---|
cd ~oracle/dbvrep_orclXE |
2. The configuration scripts can be inspected if needed. They are in the ./config directory.
| No Format |
|---|
ls ./config dbvrep_orclXE-dbsetup_ttorcl_srcsource.sql dbvrep_orclXE-grants_ttorcl_srcsource.sql dbvrep_orclXE-onetime.ddc dbvrep_orclXE-wizard-databases.cfg dbvrep_orclXE-wizard-pairs.cfg dbvrep_orclXE-dbsetup_ttorcl_trgtarget.sql dbvrep_orclXE-grants_ttorcl_trgtarget.sql dbvrep_orclXE-setup.dbvrep dbvrep_orclXE-wizard-ddc.cfg dbvrep_orclXE-wizard-tables.cfg |
The following types of scripts are in the config directory
- SQL scripts. These scripts will run SQL statements in the source or target databases.
- CFG scripts. These are used in the setup wizard to remember user inputs. The setup wizard can be run again and the previous input will be displayed based on information in the .cfg files.
- DDC scripts. These scripts contain all the configurational settings for the replication.
- DBVREP script. This script runs Dbvisit Replicate commands and initialises the replication.
3. The dbvrep_orclXE-all.sh is the main script that calls all the other script to initialise the replication. Start this script
| No Format |
|---|
./dbvrep_orclXE-all.sh |
4. The replication is now being initialised. This takes approximately 3-5 minutes.
| No Format |
|---|
Setting up Dbvisit Replicate configuration Configure database ttorcl_srcsource... This check fails if the DBID is not the expected one... Ok, check passed. Configure database ttorcl_trgtarget... This check fails if the DBID is not the expected one... Ok, check passed. Object grants for database ttorcl_srcsource... Object grants for database ttorcl_trgtarget... Setting up the configuration Initializing......done WARN-1850: No DDC DB available, dictionary table does not exist. DDC loaded from database (0 variables). Dbvisit Replicate version 2.7.02.4333 Copyright (C) Dbvisit Software Limited. All rights reserved. DDC file /u01/app/oracle/dbvrep_orclXE/config/dbvrep_orclXE-onetime.ddc loaded. MINE: Cannot determine Dbvisit Replicate dictionary version. (no dictionary exists) APPLY: Cannot determine Dbvisit Replicate dictionary version. (no dictionary exists) dbvrep> #clear the no-DDC-DB-available warning dbvrep> process clear previous warnings dbvrep> set ON_WARNING SKIP Variable ON_WARNING set to SKIP for process *. dbvrep> set ON_ERROR EXIT Variable ON_ERROR set to EXIT for process *. dbvrep> PROCESS SWITCH_REDOLOG WARN-1258: Insufficient privileges to do a redolog switch. Please issue it manually. dbvrep> PROCESS SETUP MINE DROP DICTIONARY 0 dictionary objects dropped. dbvrep> PROCESS SETUP MINE CREATE DICTIONARY dbvrep> PROCESS SETUP MINE LOAD DICTIONARY Supplemental logging on database set. Loading dictionary table DBRSCOL$ Loading dictionary table DBRSIND$ Loading dictionary table DBRSOBJ$ Loading dictionary table DBRSTAB$ Loading dictionary table DBRSUSER$ Loading dictionary table DBRSV_$DATABASE WARN-1258: Insufficient privileges to do a redolog switch. Please issue it manually. WARN-1258: Insufficient privileges to do a redolog switch. Please issue it manually. dbvrep> PROCESS SETUP APPLY DROP DICTIONARY 0 dictionary objects dropped. dbvrep> PROCESS SETUP APPLY CREATE DICTIONARY dbvrep> PROCESS SETUP APPLY LOAD DICTIONARY dbvrep> PROCESS PREPARE_DP SETUP CLEAR dbvrep> PROCESS SETUP PAIR MINE AND APPLY Applier SCN set (start=3141006513646, current=3141006513646). dbvrep> SET APPLY.INSTANTIATE_SCN NOW Variable INSTANTIATE_SCN set to NOW for process APPLY. dbvrep> EXCLUDE CREATE TABLE %.DBMS_TABCOMP_TEMP_UNCMP #Ignore tables created by Compression Advisor Exclude rule created. dbvrep> EXCLUDE CREATE TABLE %.DBMS_TABCOMP_TEMP_CMP #Ignore tables created by Compression Advisor Exclude rule created. dbvrep> SET PREPARE_SCHEMA_EXCEPTIONS OE.SUBCATEGORY_REF_LIST_NESTEDTAB,OE.PRODUCT_REF_LIST_NESTEDTABnone Variable PREPARE_SCHEMA_EXCEPTIONS set to OE.SUBCATEGORY_REF_LIST_NESTEDTAB,OE.PRODUCT_REF_LIST_NESTEDTABnone for process *. dbvrep> PROCESS SUPPLEMENTAL LOGGING SCHEMA "OEREPOE" ENABLE PRIMARY KEY dbvrep> PROCESS SWITCH_REDOLOG WARN-1258: Insufficient privileges to do a redolog switch. Please issue it manually. dbvrep> PROCESS WAIT_SCN_FLIP Waited 2 seconds until scn_to_timestamp changed. dbvrep> #single-scn instantiation: lock all tables and schemas dbvrep> PROCESS LOCK SCHEMAS "OEREPOE" Locking all schemas. Lock done. dbvrep> #single-scn instantiation: unlock all tables and schemas, but keep the SCN dbvrep> PROCESS LOCK RELEASE LOCKS dbvrep> dbvrep> #prepare the tables (we use OFFLINE as neither MINE not APPLY is running; with OFFLINE we won't wait on network timeout) dbvrep> PREPARE OFFLINE SCHEMA "OEREPOE" Table OEREPOE.ADDRESSES instantiated at SCN 3144204515210 Table OEREPOE.CARD_DETAILS instantiated at SCN 3144204515210 Table OE.CMP3$95780 instantiated at SCN 3144204 Table OE.CMP4$95780 instantiated at SCN 3144204 Table OEREPOE.CUSTOMERS instantiated at SCN 3144204515210 Column SYS_NC00017$ is special: virtual column. Excluding. Column SYS_NC00017$ is special: hidden column. Excluding. Column SYS_NC00017$ is special: system-generated column. Excluding. Column SYS_NC00017$ is special: virtual column. Excluding. Column SYS_NC00018$ is special: virtual column. Excluding. Column SYS_NC00018$ is special: hidden column. Excluding. Column SYS_NC00018$ is special: system-generated column. Excluding. Column SYS_NC00018$ is special: virtual column. Excluding. Table OEREPOE.INVENTORIES instantiated at SCN 3144204515210 Table OEREPOE.LOGON instantiated at SCN 3144204515210 Table OEREPOE.ORDERENTRY_METADATA instantiated at SCN 3144204515210 Table OEREPOE.ORDERS instantiated at SCN 3144204515210 Table OEREPOE.ORDER_ITEMS instantiated at SCN 3144204515210 Table OEREPOE.PRODUCT_DESCRIPTIONS instantiated at SCN 3144204515210 Table OEREPOE.PRODUCT_INFORMATION instantiated at SCN 3144204515210 Table OE.PROMOTIONS instantiated at SCN 3144204 Table OEREPOE.WAREHOUSES instantiated at SCN 3144204515210 dbvrep> dbvrep> #single-scn instantiation: unlock all tables and schemas, forget the SCN (so it does not affect any further PREPARE statements) dbvrep> PROCESS LOCK CLEAR SCN dbvrep> PROCESS SWITCH_REDOLOG WARN-1258: Insufficient privileges to do a redolog switch. Please issue it manually. dbvrep> #prepare script for instantiation dbvrep> PROCESS PREPARE_DP WRITE DP_NETWORKLINK DIRECTORY ttorcl_trg_DATA_PUMP_DIR FILE /u01/app/oracle/dbvrep_orclXE/APPLY.sh DBLINK ttorcl_srcsource USERID SYSTEM/oracle@ttorcl_trgmanager@target Created Data Pump script /u01/app/oracle/dbvrep_orclXE/APPLY.sh, using network import. dbvrep> create ddcdb from ddcfile DDC loaded into database (346 variables). dbvrep> set ON_WARNING SKIP Variable ON_WARNING set to SKIP for process *. dbvrep> set ON_ERROR SKIP Variable ON_ERROR set to SKIP for process *. OK-0: Completed, but some operation(s) raised warnings and/or errors. |
| Note |
|---|
WARN-1258: Insufficient privileges to do a redolog switch. Please issue it manually.This warning is expected. In Oracle 12c when you connect to a CDB, you don't have privileges for a system-wide log switch. The warning will not stop replication. Replication may take a bit longer to initialize as the MINE process will have to read through the current log. Or you could run the command manually. |
successfully. |
At the end of the output, the Next Steps to be completed will be shown.
| No Format |
|---|
These steps are required after the dbvrep_orclXE-all.sh script runs: 1) Create the necessary directory(ies) on the servers: target: /u01/app/oracle/dbvrep_orcl XE 2) Copy the DDC files to the server(s) where the processes will run: target: /u01/app/oracle/dbvrep_orclXE/dbvrep_orclXE-APPLY.ddc source: /u01/app/oracle/dbvrep_orclXE/dbvrep_orclXE-MINE.ddc 3) Review that path to dbvrep executable is correct in the run scripts: /u01/app/oracle/dbvrep_orclXE/dbvrep_orclXE-run-source.sh /u01/app/oracle/dbvrep_orclXE/dbvrep_orclXE-run-target.sh 4) Copy the run script to the server(s) where the processes will run: source: /u01/app/oracle/dbvrep_orclXE/dbvrep_orclXE-run-source.sh target: /u01/app/oracle/dbvrep_orclXE/dbvrep_orclXE-run-target.sh 5) Ensure firewall is open for listen interfaces 0.0.0.0:7902, 0.0.0.0:7901 used by the processes. 6) Make sure the data on apply are in sync as of time when setup was run. Scripts for Data Pump/export/DDL were created as requested: /u01/app/oracle/dbvrep_orclXE/APPLY.sh Create referenced database links (if any) before running the scripts. 7) Start the replication processes on all servers: source: /u01/app/oracle/dbvrep_orclXE/dbvrep_orclXE-run-source.sh target: /u01/app/oracle/dbvrep_orclXE/dbvrep_orclXE-run-target.sh 8) Start the console to monitor the progress: /u01/app/oracle/dbvrep_orclXE/start-console.sh The above list is stored in /u01/app/oracle/dbvrep_orclXE/Nextsteps.txt. |
...
Complete the Configuration
Follow the Next Steps instructions to complete the configuration.
On the target server (dbv02) create the /u01/app/oracle/dbvrep_orcl XE directory
...
su - oracle |
| No Format |
|---|
mkdir /u01/app/oracle/dbvrep_orclXE |
6. On the source server (dbv01), copy the DDC file to the target server using scp. The oracle account password is oracle on both machines. The Dbvisit Database Configuration file contains all the configurational settings for the replication.
| No Format |
|---|
scp /u01/app/oracle/dbvrep_orclXE/dbvrep_orclXE-APPLY.ddc oracle@target-int:/u01/app/oracle/dbvrep_orcl/XE/dbvrep_XE-APPLY.ddc The authenticity of host 'target-int (10192.0168.256.567)' can't be established. RSA key fingerprint is ad4b:116c:0347:c0e5:f0ba:78cd:7f45:295f:8222:7cf3:35b8:e7c7:665e:bc40:e01f:5b27. |
| No Format |
Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added 'target-int,192.168.56.67' (RSA) to the list of known hosts. |
The scp password is oracle
| No Format |
|---|
oracle@target-int oracle@target's password: dbvrep_orclXE-APPLY.ddc 100% 522 0.5KB/s 00:00 |
7. On the source server (dbv01), copy the dbvrepthe dbvrep_orclXE-run-target.sh file to the target server using scp. The oracle account password is oracle on both machines.
| No Format |
|---|
scp /u01/app/oracle/dbvrep_orclXE/dbvrep_orclXE-run-target.sh oracle@target-int:/u01/app/oracle/dbvrep_orcl/ |
The scp password is oracle
| No Format |
|---|
oracle@target-intXE/dbvrep_XE-run-target.sh oracle@target's password: dbvrep_orclXE-run-target.sh 100% 108 0.1KB/s 00:00 |
| Note |
|---|
The word "target" in dbvrep_orcl-run-target.sh is dependent on your target hostname. In this case, the target hostname is called target |