Introduction to Basic Commands
All keywords are case-insensitive.
The following list of commands is meant to be an overview of basic and most used Dbvisit Replicate commands. For details (and the full list of commands) see Full Command-Line Reference.
Managing the processes
START process_name
Starts process.Â
This command cannot be run from the dbvrep console. Start the process from the command line using the --daemon option instead.
[oracle@src ~]$ dbvrep --daemon --ddcfile /home/oracle/TESTSUITE1/TESTSUITE1-MINE.ddc start MINE Initializing......done DDC loaded from database (230 variables). Dbvisit Replicate version 2.6.00.0012 Copyright (C) Dbvisit Software Limited. All rights reserved. DDC file /home/oracle/TESTSUITE1/TESTSUITE1-MINE.ddc loaded. Starting process MINE...started
SHUTDOWN process_name
Connect to MINE/APPLY/FETCHER and request it to shut down.
SHUTDOWN ALL means requesting all processes defined in DDC to shut down.
dbvrep> shutdown all Dbvisit Replicate APPLY process shutting down. Dbvisit Replicate FETCHER process shutting down. Dbvisit Replicate MINE process shutting down.
Managing conflicts
LIST CONFLICT
List the current conflict(s). This information is obtained from Dbvisit Replicate internal table DBRSAPPLY_CONFLICT_LOG on the APPLY side.
dbvrep> list conflict current Information for conflict 8576010028511: Table: SCOTT.CONF at transaction 0009.02f.00003ffc at SCN 29913656 SQL text (with replaced bind values): insert into SCOTT."CONF" (ID,VALUE) values (3, 'c') Error: ORA-00001: unique constraint (SCOTT.PK_ID) violated Handled as: RETRY
Â
After the all conflicts were resolved:
dbvrep> list conflict last Information for conflict 8576010038761: Table: SCOTT.CONF at transaction 0002.000.00004102 at SCN 29918665 SQL text (with replaced bind values): insert into SCOTT."CONF" (ID,VALUE) values (6, 'f') Error: ORA-00001: unique constraint (SCOTT.PK_ID) violated Handled as: RETRY Resolved at: 15.12.2012 01:00:34 Resolved as: STATEMENT IGNORED
In 2-way replication if there is a conflict with APPLY1, then the CHOOSE REPLICATION command first has to be issued before the list conflict command will list the actual conflict of the APPLY1 process. See the CHOOSE REPLICATION command.Â
RESOLVE
Contacts APPLY and resolves current conflict.
dbvrep> resolve conflict 8576010038761 as ignore Conflict resolution set. Â OR Â dbvrep> resolve conflict 0 as ignore Conflict resolution set.
Managing the replication
LIST PROGRESS
Show tabular overview of MINE/APPLY records processed and conflicts. You can optionally specify a schema to filter the results to a particular database schema (this is source schema if renaming is used). Use ALL to see everything including Dbvisit Replicate internal tables.
dbvrep> list progress Progress of replication TESTSUITE1: total/this execution -------------------------------------------------------------------------------------------------------------------------------------------- SCOTT.CONF: 100% Mine:4/4 Unrecov:0/0 Applied:4/4 Conflicts:0/0 Last:15/12/2012 03:02:53/OK SCOTT.CONF2: 100% Mine:6/6 Unrecov:0/0 Applied:6/6 Conflicts:0/0 Last:15/12/2012 03:02:53/OK -------------------------------------------------------------------------------------------------------------------------------------------- 2 tables listed.
LIST STATS
Display statistics for number of rows processed/minute and/or lag between MINE and APPLY. The lag can be displayed in terms of time or SCN difference; the number of rows per minute can be shown globally or for specified table.
By default, the number of rows processed/minute represents APPLY performance; use LIST STATS TOTAL MINE to see MINE statistics.
dbvrep> list stats total APPLY: Cumulative totals for all tables: *** Total statistics since 15.12.2012 02:26:15 (last 24 hours) *** Total inserts/minute: 659.20 Total updates/minute: 5.99 Total deletes/minute: 0.00 Total operations/minute: 665.19 Total commits/minute: 18.64 Total rollbacks/minute: 18.64 *** Total statistics since 15.12.2012 03:57:13 (last 1 hour) *** Total inserts/minute: 0.08 Total updates/minute: 0.08 Total deletes/minute: 0.00 Total operations/minute: 0.16 Total commits/minute: 22.13 Total rollbacks/minute: 22.13 *** Total statistics since 15.12.2012 04:53:15 (last 5 minutes) *** Total inserts/minute: 0.00 Total updates/minute: 0.00 Total deletes/minute: 0.00 Total operations/minute: 0.00 Total commits/minute: 24.50 Total rollbacks/minute: 24.50 *** Total statistics since 15.12.2012 02:26:15 (since last started) *** Total inserts/minute: 659.20 Total updates/minute: 5.99 Total deletes/minute: 0.00 Total operations/minute: 665.19 Total commits/minute: 18.64 Total rollbacks/minute: 18.64 *** Total statistics since 15.12.2012 02:26:15 (whole history) *** Total inserts/minute: 659.20 Total updates/minute: 5.99 Total deletes/minute: 0.00 Total operations/minute: 665.19 Total commits/minute: 18.64 Total rollbacks/minute: 18.64
PREPARE
This adds tables or schemas to the replication. Prepares a schema/table for replication and declares that their content is in sync as of now. If a schema is prepared and DDL replication is enabled, new tables created in this schema in future will be also prepared and replicated.
Create a new schema on both Source and Target database.
SQL> conn sys/oracle@src as sysdba Connected. SQL> create user new_schema identified by new_schema; User created. SQL> grant connect, resource to new_schema; Grant succeeded. SQL> conn sys/oracle@trg as sysdba Connected. SQL> create user new_schema identified by new_schema; User created. SQL> grant connect, resource to new_schema; Grant succeeded.
Â
Prepare the schema:
dbvrep> prepare schema new_schema Connecting to running mine [new_schema]: [Schema prepared (2 internal records).]
Â
The PREPARE command enables DDL replication unless NODDL option is specified. Therefore a new table will be automatically prepared and replicated to the Target database:
SQL> conn new_schema/new_schema@src Connected. SQL> create table tab1 (i number primary key, a varchar2(5)); Table created. SQL> insert into tab1 values (1, 'a'); 1 row created. SQL> commit; Commit complete.
dbvrep> list progress Progress of replication TESTSUITE1: total/this execution ------------------------------------------------------------------------------------------------------------------ NEW_SCHEMA.TAB1: 100% Mine:1/1 Unrecov:0/0 Applied:1/1 Conflicts:0/0 Last:18/12/2012 14:36:10/OK ------------------------------------------------------------------------------------------------------------------ 1 tables listed.
It's not necessary to replicate the whole schema. Dbvisit Replicate can also replicate individual tables.Â
Â
There are some prerequisites to preparing the table. The table needs to exist on both the source and target, appropriate privileges have to be given to the Dbvisit Replicate owner and historical data needs to be loaded to the target table. For details please see Manually Replicating new objects (adding new tables).
dbvrep> prepare table oe.promotions Connecting to running apply [oe.promotions]: [Apply table added.] Connecting to running mine [oe.promotions]: [Table prepared (4 internal records).] Table oe.promotions instantiated at SCN 33550622
SQL> insert into oe.promotions values (5, 'test promo');
dbvrep> list progress Progress of replication TESTSUITE1: total/this execution -------------------------------------------------------------------------------------------------------------------------------------------- OE.PROMOTIONS: 100% Mine:1/1 Unrecov:0/0 Applied:1/1 Conflicts:0/0 Last:21/12/2012 02:57:51/OK -------------------------------------------------------------------------------------------------------------------------------------------- 1 tables listed.
UNPREPARE
Removes tables or schemas from the replication. Unprepares a schema/table for replication and declares that this object should no longer be replicated.Â
dbvrep> unprepare table oe.promotions dbvrep> unprepare schema new_schema dbvrep>
Managing the settings
SET
Sets configuration variable in memory and DDC DB. This setting will be permanent. See memory_set for setting in memory only and which are not permanent.
dbvrep> set MINE.MINE_PLOG = /home/oracle/TESTSUITE1/mine/%S.%E Variable MINE_PLOG set to /home/oracle/TESTSUITE1/mine/%S.%E for process MINE.
SHOW
With no parameter or with ALL, shows all configuration variables, as they are seen by current process. It does not reread DDC file nor DDC DB to update the settings.
With variable, shows variable value. (For * and also for all processes.)
dbvrep> show setup_script_path MINE.SETUP_SCRIPT_PATH = /home/oracle/TESTSUITE1 FETCHER.SETUP_SCRIPT_PATH = /home/oracle/TESTSUITE1 *.SETUP_SCRIPT_PATH = APPLY.SETUP_SCRIPT_PATH = /home/oracle/TESTSUITE1
HELP
Shows general help, help for specific command or help for a variable.
dbvrep> help list LIST: Reports. LIST MINE|APPLY REDOLOGS|PLOGS: Display status of plogs and redologs on mine/apply. LIST PROGRESS [schema | PLSQL]: show table of current progress of mine/apply. This can be shown on-line in the status bar by setting DDC variable STATUS_BAR to 'LIST' or 'STATUS+LIST'; full list of PL/SQL replication is stored in DBRSAPPLY_DDL_HISTORY. LIST PREPARE: show tables prepared for replication. LIST OBSOLETE REDO [THREAD thread]: show which redo logs are no longer needed by mine. LIST CONFLICT { id|CURRENT|LAST }: show information about conflict (current one, last one or by specified id). LIST STATUS: show status bar text. LIST STATS {ALL|TIME|SCN|TOTAL|TOTAL mine/apply | schema.table }: list statistics for all tables or specified table - number of operations per minute and/or process lags in seconds or SCNs.
2-way or One-to-many replication
CHOOSE REPLICATION
By default all commands in the Dbvisit Replicate console work with the default processes MINE and APPLY. The choose replication command is useful when working with 2-way or one-to-many replication where there are multiple processes such as MINE, APPLY, MINE1 and APPLY1.
Â
The CHOOSEÂ REPLICATIONÂ command selects all processes for the indicated replication (so both MINE and APPLY processes).
Â
Example:
dbvrep> CHOOSE REPLICATION MINE1
The above command will choose the replication pair that is associated with MINE1. Typically this is MINE1->APPLY1.
Â
The CHOOSE REPLICATION command is needed prior to issuing commands to list conflicts, resolve conflicts and set conflicts with the APPLY1 process.