We're here to help!

Adding Tables Using the Silent Flag

Follow

Problem Description

This article explains how to Add/Prepare tables to replication using the silent Flag. This suppresses the header messages which might be unwanted when executed by a script or batch process.

Solution

Adding tables into an existing Replication can be performed using the --silent flag to suppress the display of header information. For example:

  1. On the Source Machine where Replicate console is running, navigate to the DDC directory:
    $cd /home/oracle/REPPOC
  2. Add table test.t2 using:
    $./start-console.sh --silent prepare table test.t2

When replicating multiple tables you can simplify the process by creating a bash script. For example test.sh:

#!/bin/bash
cd /home/oracle/REPPOC
./start-console.sh --silent prepare table test.t2
./start-console.sh --silent prepare table test.t3
./start-console.sh --silent prepare table test.t4

Executing test.sh outputs the following:

[oracle@dbvrep01 REPPOC]$ ./test.sh
Prepare enabled supplemental logging, waiting for SCN advance enough to prevent ORA-01466
during consistent export....Waited 3 seconds until scn_to_timestamp changed.
Connecting to running apply [TEST.T2]: [Apply table removed (0 metadata record(s)). Apply table added (1 metadata record(s)).]
Connecting to running mine [TEST.T2]: [Table prepared (1 internal records).]
Table TEST.T2 instantiated at SCN 1654565
OK-0: Completed successfully.
Prepare enabled supplemental logging, waiting for SCN advance enough to prevent ORA-01466
during consistent export....Waited 2 seconds until scn_to_timestamp changed.
Connecting to running apply [TEST.T3]: [Apply table removed (0 metadata record(s)). Apply table added (1 metadata record(s)).]
Connecting to running mine [TEST.T3]: [Table prepared (1 internal records).]
Table TEST.T3 instantiated at SCN 1654637
OK-0: Completed successfully.
Prepare enabled supplemental logging, waiting for SCN advance enough to prevent ORA-01466
during consistent export....Waited 2 seconds until scn_to_timestamp changed.
Connecting to running apply [TEST.T4]: [Apply table removed (0 metadata record(s)). Apply table added (1 metadata record(s)).]
Connecting to running mine [TEST.T4]: [Table prepared (1 internal records).]
Table TEST.T4 instantiated at SCN 1654709
OK-0: Completed successfully.

Other ways to add tables to a Replication include:

Ankit Arora January 23, 2015 14:09

Have more questions? Submit a request

Comments