Page Comparison

All keywords are case-insensitive.

...

• Keywords are shown in UPPERCASE.
• Placeholders for which you must substitute an actual value are shown in lowercase. These can include clauses and other expressions.xxxdatafile249
• Vertical (|) bars separate multiple choices. They indicate "or".
• Square brackets ( [] ) are not typed. They indicate that the enclosed syntax is optional.
• Curly braces ( {} ) usually are not typed. They indicate that you must specify one of the enclosed choices. (The choices are separated by vertical bars.)
• Loops or repetitions are indicated by a second, bracketed appearance of the term, set of terms, or expression, followed by ellipsis points. The brackets indicate that the repetition is optional (all repetitions are optional). The ellipsis points indicate that multiple repetitions are allowed. The bracketed appearance of the term begins with a comma if the repetitions are comma delimited.
• All other punctuation (quotation marks, commas, semicolons, and so on) must be typed as shown.
• Some commands require a restart of the MINE or APPLY processes.

Anchor

...

APPLY

...

APPLY

...

APPLY

Image Removed

Shows general help, help for specific command or help for a variable.

READ

Image Removed

Reads the designated file like it would be entered at command prompt. As with SQL*Plus, both "@file" and "@ file" work.

READDDC

Image Removed

Read the specified DDC file. Same as command line option "--ddcfile file", which is preferred, as READDDC is from interactive prompt sets some variables too late to be effective (e.g. STATUSBAR).

EXEC

Image Removed

Execute command in a new shell.

HEALTHCHECK

Image Removed

Connects to MINE and APPLY (and FETCHER if configured). Checks that they see each other.

SET

Image Removed

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.

RESET

Image Removed

Unsets variable for a specified process, falling back to general non-process-specific setting.

To clear the counters, see clear.

MEMORY_SET

Image Removed

Sets configuration variable in memory only. Use for variables that cannot be set in the DDC DB or if you want the value to be valid for short time only. After restart of the process the setting will no longer APPLY  (unless MEMORY_SET is specified in the DDC file).

MEMORY_RESET

Image Removed

Unsets variable, in memory only.

SHOW

Image Removed

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.)

LIST

Image Removed

Displays the current status of MINE, APPLY and FETCHER processes. 

Image Removed

Connects to database and lists registered redologs / PLOGS.

Image Removed
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.

Image Removed
LIST PREPARE. Show list of prepared tables. 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 internal tables.

Image Removed

LIST OBSOLETE REDO. Obtains a list of obsolete archived redo log files that are not needed by Dbvisit Replicate anymore and therefore maybe deleted. For example when using RMAN to manage the archive logs, this information can be fed into the RMAN backup script.

Image Removed

LIST CONFLICT. List the current conflict(s). This information is obtained from Dbvisit Replicate internal table DBRSAPPLY_CONFLICT_LOG on the APPLY side. 

Image Removed

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.

Image Removed

LIST TRANSACTIONS. This command lists opened uncommitted transactions on APPLY. The Transaction ID is the hex value of the combined columns XIDUSN, XIDSLOT, XIDSQN from v$transaction on the target database. The Transaction ID is also set in columns MODULE and ACTION from V$SESSION on the target database.

The transaction list may also include internal non committed transaction not related to the replication. Please see List transactions for more information.

Use APPLY COMMIT TRANSACTION to force commit of the specified transactions on APPLY, or APPLY ROLLBACK TRANSACTION to force rollback of the transaction on APPLY. Ensure you fully understand the implication before running the COMMIT or ROLLBACK commands. 

APPLY

Image Removed

APPLY COMMIT TRANSACTION. Force commit of the specified transaction on APPLY. Use List transactions first to see what transactions are currently pending on APPLY.

Ensure you fully understand the implication before running this command. 

Image Removed

APPLY ROLLBACK TRANSACTION. Force rollback of the specified transaction on APPLY. Use List transactions first to see what transactions are currently pending on APPLY.

Ensure you fully understand the implication before running this command.

EXIT, QUIT

Image Removed

Exits dbvrep.

WAIT

Image Removed

Waits until killed.

QUERYMODE

Image Removed

FILE: Parses given online/archive redo, generates PLOG and parses the PLOG. (Note that to generate traces etc. during query mode, you still have to set the corresponding configuration variables.)
In query mode, incomplete PLOG will generate only an error, not a fatal error.
Note that this is a local API command, so you have to see the redo log on local filesystem.
No changes are actually applied to APPLY database.
PLOG: Parses selected PLOG (usually a conflict error PLOG) – either by specifying a filename, or by conflict id.
In query mode, incomplete PLOG will generate only an error, not a fatal error.
Note that this is a local API command, so you have to see the error-log on local filesystem, and have to be able to connect to APPLY database to query metadata if using conflict id.
No changes are actually applied to APPLY database.
CONFLICT: If error PLOGS are enabled (disabled by default), tries to get error PLOG for given conflict id and run QUERYMODE PLOG on that file.

COMMENT

Image Removed

Ignored. Just a comment, useful in scripts.

Note that if the # character is used, it must be preceeded by a space (" #"). If there is no space, it is considered part of the command, thus tables with # in their name can be used (e.g. "PREPARE TABLE SCOTT.TEST#").

SETUP WIZARD

Image Removed

Starts the setup wizard.

VERSION

Image Removed

Shows Dbvisit Replicate version. Can be also invoked by --V switch.

PREPARE

Image Removed

Image Removed

UNPREPARE

Image Removed

Used for removing tables or schemas from the replication.

Unprepares a schema/table for replication and declares that this object should no longer be replicated.

If OFFLINE is used, APPLY/MINE will pick the change on the next start. Use OFFLINE if the APPLY and MINE are not running, as some network configurations may cause long timeouts while PREPARE tries to connect to the APPLY/MINE.

REPREPARE

Image Removed

Image RemovedImage Added

APPLY COMMIT TRANSACTION. Force commit of the specified transaction on APPLY. Use List transactions first to see what transactions are currently pending on APPLY.

Ensure you fully understand the implication before running this command. 

Image Added

APPLY ROLLBACK TRANSACTION. Force rollback of the specified transaction on APPLY. Use List transactions first to see what transactions are currently pending on APPLY.

Ensure you fully understand the implication before running this command.

Anchor
COMMENT COMMENT

COMMENT

Image Added

Ignored. Just a comment, useful in scripts.

Anchor
EXCLUDE COLUMN EXCLUDE COLUMN

EXCLUDE COLUMN

Image Added

Set a column to be excluded in mining. Use this if you don't want to replicate a specific column(s) in a table. Use the % character as a wildcard. Underscore (_) is not treated as a special character.
Note that PREPARE automatically includes all columns and EXCLUDE thus must follow the prepare. The table must already be PREPARED for the column to be excluded.

The EXCLUDE COLUMN commands can be placed in the *.dbvrep script after the last PREPARE OFFLINE command, before the *-all.sh or *-all.bat script is run.

This command requires a restart of the MINE process.

Anchor
EXCLUDE CREATE TABLE EXCLUDE CREATE TABLE

EXCLUDE CREATE TABLE

Image Added

Maintain the list of tables/table name patters that should not be automatically prepared when created on source, although DDL is enabled and whole schema is prepared. The main use case for this feature is to skip various temporary tables that should not be replicated. Use the % character as a wildcard. Underscore (_) is not treated as a special character.

The commands add a new rule; if an existing rule of opposite meaning already exists, it is deleted instead. The matching starts with the oldest one and goes on till the newest rule added; if a reordering is needed, clear the list and start again. The SHOW option lists the existing rules using the very same syntax, so the list can be easily edited and then executed to APPLY the changes.

This command requires a restart of the MINE process.

Anchor
EXEC EXEC

EXEC

Image Added

Execute command in a new shell.

Anchor
EXIT QUIT EXIT QUIT

EXIT, QUIT

Image Added

Exits dbvrep.

Anchor
FILTER FILTER

FILTER

Image Added

Set filtering rules for an already prepared table/schema. The usual way how to configure filtering is using Setup wizard (which in turn uses this very command). 

If OFFLINE is used, APPLY/MINE will pick the change on the next start. Use OFFLINE if the APPLY and MINE are not running, as some network configurations may cause long timeouts while PREPARE tries to connect to the APPLY/MINE.

Anchor
HEALTHCHECK HEALTHCHECK

HEALTHCHECK

Image Added

Connects to MINE and APPLY (and FETCHER if configured). Checks that they see each other.

Anchor
HELP HELP

HELP

Image Added

Shows general help, help for specific command or help for a variable.

Anchor
LIST LIST

LIST

Image Added

Displays the current status of MINE, APPLY and FETCHER processes. 

Image Added

Connects to database and lists registered REDOLOGS / PLOGS.

Image Added
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.

Image Added
LIST PREPARE. Show list of prepared tables. 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 internal tables.

Image Added

LIST OBSOLETE REDO. Obtains a list of obsolete archived redo log files that are not needed by Dbvisit Replicate anymore and therefore maybe deleted. For example when using RMAN to manage the archive logs, this information can be fed into the RMAN backup script.

Image Added

LIST CONFLICT. List the current conflict(s). This information is obtained from Dbvisit Replicate internal table DBRSAPPLY_CONFLICT_LOG on the APPLY side. 

Image Added

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.

Image Added

LIST TRANSACTIONS. This command lists opened uncommitted transactions on APPLY. The Transaction ID is the hex value of the combined columns XIDUSN, XIDSLOT, XIDSQN from v$transaction on the target database. The Transaction ID is also set in columns MODULE and ACTION from V$SESSION on the target database.

The transaction list may also include internal non committed transaction not related to the replication. Please see List transactions for more information.

Use APPLY COMMIT TRANSACTION to force commit of the specified transactions on APPLY, or APPLY ROLLBACK TRANSACTION to force rollback of the transaction on APPLY. Ensure you fully understand the implication before running the COMMIT or ROLLBACK commands. 

Anchor
MEMORY_SET MEMORY_SET

MEMORY_SET

Image Added

Sets configuration variable in memory only. Use for variables that cannot be set in the DDC DB or if you want the value to be valid for short time only. After restart of the process the setting will no longer APPLY  (unless MEMORY_SET is specified in the DDC file).

Anchor
MEMORY_RESET MEMORY_RESET

MEMORY_RESET

Image Added

Unsets variable, in memory only.

Anchor
READ READ

READ

Image Added

Reads the designated file like it would be entered at command prompt. As with SQL*Plus, both "@file" and "@ file" work.

Anchor
READDDC READDDC

READDDC

Image Added

Read the specified DDC file. Same as command line option "--ddcfile file", which is preferred, as READDDC is from interactive prompt sets some variables too late to be effective (e.g. STATUSBAR).

Anchor
RESET RESET

RESET

Image Added

Unsets variable for a specified process, falling back to general non-process-specific setting.

To clear the counters, see clear.

Anchor
SET SET

SET

Image Added

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.

Anchor
SETUP WIZARD SETUP WIZARD

SETUP WIZARD

Image Added

Starts the setup wizard.

Anchor
SHOW SHOW

SHOW

Image Added

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.)

Anchor
WAIT WAIT

WAIT

Image Added

Waits until killed.

Anchor
QUERYMODE QUERYMODE

QUERYMODE

Image Added

FILE: Parses given online/archive redo, generates PLOG and parses the PLOG. (Note that to generate traces etc. during query mode, you still have to set the corresponding configuration variables.)
In query mode, incomplete PLOG will generate only an error, not a fatal error.
Note that this is a local API command, so you have to see the redo log on local filesystem.
No changes are actually applied to APPLY database.
PLOG: Parses selected PLOG (usually a conflict error PLOG) – either by specifying a filename, or by conflict id.
In query mode, incomplete PLOG will generate only an error, not a fatal error.
Note that this is a local API command, so you have to see the error-log on local filesystem, and have to be able to connect to APPLY database to query metadata if using conflict id.
No changes are actually applied to APPLY database.
CONFLICT: If error PLOGS are enabled (disabled by default), tries to get error PLOG for given conflict id and run QUERYMODE PLOG on that file.

Anchor
VERSION VERSION

VERSION

Image Added

Shows Dbvisit Replicate version. Can be also invoked by --V switch.

Anchor
PREPARE PREPARE

PREPARE

Image Added

Image Added

Reprepare does UNPREPARE and PREPARE in a single step to save typing. It also understands that there is no need to drop supplemental logging in the unprepare phase as prepare would create it again.

EXCLUDE COLUMN

Image Removed

Set a column to be excluded in mining. Use this if you don't want to replicate a specific column(s) in a table. Use the % character as a wildcard. Underscore (_) is not treated as a special character.
Note that PREPARE automatically includes all columns and EXCLUDE thus must follow the prepare. The table must already be PREPARED for the column to be excluded.

The EXCLUDE COLUMN commands can be placed in the *.dbvrep script after the last PREPARE OFFLINE command, before the *-all.sh or *-all.bat script is run.

Entering this command in the console requires a restart of the MINE process.

INCLUDE COLUMN

Image Removed

This command relates to the EXCLUDE COLUMN command and can be used to:

1. Remove and already existing EXCLUDE COLUMN rule 

This command requires a restart of the MINE process.

EXCLUDE CREATE TABLE

Image Removed

Maintain the list of tables/table name patters that should not be automatically prepared when created on source, although DDL is enabled and whole schema is prepared. The main use case for this feature is to skip various temporary tables that should not be replicated. Use the % character as a wildcard. Underscore (_) is not treated as a special character.

The commands add a new rule; if an existing rule of opposite meaning already exists, it is deleted instead. The matching starts with the oldest one and goes on till the newest rule added; if a reordering is needed, clear the list and start again. The SHOW option lists the existing rules using the very same syntax, so the list can be easily edited and then executed to APPLY the changes.

The MINE process has to be restarted for this to take effect.

INCLUDE CREATE TABLE

Image Removed

This command relates to the EXCLUDE CREATE TABLE command and can be used in two ways:

1. Remove and already existing EXCLUDE CREATE TABLE rule 
2. Add an exception to the EXCLUDE CREATE TABLE rule. For example, EXCLUDE CREATE TABLE SCOTT.TEMP%, but INCLUDE CREATE TABLE SCOTT.TEMP_REPL

The MINE process has to be restarted for this to take effect.

FILTER

Image Removed

Set filtering rules for an already prepared table/schema. The usual way how to configure filtering is using Setup wizard (which in turn uses this very command). 

...

Anchor
UNPREPARE UNPREPARE

UNPREPARE

Image Added

Used for removing tables or schemas from the replication.

Unprepares a schema/table for replication and declares that this object should no longer be replicated.

If OFFLINE is used, APPLY/MINE will pick the change on the next start. Use OFFLINE if the APPLY and MINE are not running, as some network configurations may cause long timeouts while PREPARE tries to connect to the APPLY/MINE.

Anchor
REPREPARE REPREPARE

REPREPARE

Image Added

Image Added

Used for adding tables or schemas to the replication.

Reprepare does UNPREPARE and PREPARE in a single step to save typing. It also understands that there is no need to drop supplemental logging in the unprepare phase as prepare would create it again.

Anchor
INCLUDE COLUMN INCLUDE COLUMN

INCLUDE COLUMN

Image Added

This command relates to the EXCLUDE COLUMN command and can be used to:

1. Remove and already existing EXCLUDE COLUMN rule 

This command requires a restart of the MINE process.

Anchor
INCLUDE CREATE TABLE INCLUDE CREATE TABLE

INCLUDE CREATE TABLE

Image Added

This command relates to the EXCLUDE CREATE TABLE command and can be used in two ways:

1. Remove and already existing EXCLUDE CREATE TABLE rule 
2. Add an exception to the EXCLUDE CREATE TABLE rule. For example, EXCLUDE CREATE TABLE SCOTT.TEMP%, but INCLUDE CREATE TABLE SCOTT.TEMP_REPL

This command requires a restart of the MINE process.

Anchor
CDCAUDIT CDCAUDIT

CDCAUDIT

Anchor
LICENSE LICENSE

LICENSE

Shows current license, as set by LICENSE_KEY variable.
The optional FULL keyword specifies the verbosity of the command:

dbvrep> license show
Licensed for , 30-day license (trial license). dbvrep> *license show full
Product: Dbvisit Replicate
Allowed versions:1.0-2.63
Key-version: 1
License type: RS1S
Customer id: 1.0 (trial license)
Production: yes
License-type: server
Name: *
Expiry: 30 days
CPU count mine: 0
CPU count apply: 0
Row-count limit: unlimited
Enabled options: rac, fetcher, partitions, onetomany, cascade, 2way, ddl, asm, mysql, mssql, oracle, snmp, mail_notify
Licensed for *, 30-day license (trial license).

Anchor
CHOOSE CHOOSE

CHOOSE

Choose process to work with when issuing commands or displaying settings. This can be done by specifying the process name or by means of source and target databases.

By default all commands work with the default processes MINE and APPLY. This command is useful when working with 2-way replication where there are multiple processes such as MINE, APPLY, MINE1 and APPLY1.

Example:

CHOOSE REPLICATION MINE1

The above command will choose the replication pair that is associated with MINE1. Typically this is MINE1->APPLY1

In contrast, CHOOSE PROCESS selects only the selected process (not the pair) and is generally not recommended. It can be used in special cases such as one to many replications to specify a specific process. 

Anchor
PAUSE PAUSE

PAUSE

Asks the given process to pause.

Anchor
RESUME process RESUME process

RESUME process_name

Asks the given process to resume.given process to resume.

Anchor
START process START process

START process_name

Starts process.

Anchor
SHUTDOWN process SHUTDOWN process

SHUTDOWN process_name

Connect to MINE/APPLY/FETCHER and request it to shut down.
ALL means requesting all processes defined in DDC to shut down.

Anchor
DUMP DUMP

DUMP

Request MINE/APPLY to dump debug information to log.
DUMP ALL is invoked automatically when exiting due to a untrapped fatal error.
DUMP ALL can be also invoked by sending SIGUSR2 (kill -12) to the process (not available on Windows).

Anchor
CLEAR CLEAR

CLEAR

PROGRESS: Asks MINE and APPLY to reset conflict progress counters.
CONFLICT: Asks MINE and APPLY to reset progress conflict counters.

Anchor
SET_CONFLICT_HANDLERS SET_CONFLICT_HANDLERS

SET_CONFLICT_HANDLERS

Gets object id as of current MINE progress and sets conflict handlers for this table (schema.name refers to current table name at MINE).

The DEFAULT conflict handler will not be applied to existing prepared (replicated) tables. The DEFAULT conflict handler will only be applied to tables that are prepared after the DEFAULT conflict handler is set. To change the conflict handler for existing prepared tables, each table has to be individually set using FOR TABLE conflict handler.

Anchor
SHOW_CONFLICT_HANDLERS SHOW_CONFLICT_HANDLERS

SHOW_CONFLICT_HANDLERS

Shows current setting of conflict handlers for given table (schema.name refers to table at MINE).

Anchor
RESOLVE RESOLVE

RESOLVE

Contacts APPLY and resolves current conflict.

Anchor
CLEAR SCREEN CLEAR SCREEN

CLEAR SCREEN, CLS

Clear console screen.

Anchor
DDL DDL

DDL

Create DDL for create or drop given table or all tables in a given schema. The output can be to screen (print), to file (spool) or directly executed (replicate). This is used if ddl_run is used as instantiation type in setup wizard.

Anchor
NOTIFY NOTIFY

...

NOTIFY

Image Added

Sends sample email/SNMP trap – use to test your SMTP/SNMP configuration.

Anchor
CREATE SERVICE process CREATE SERVICE process

CREATE SERVICE process

Create Windows service for given process.

Anchor
DELETE SERVICE process DELETE SERVICE process

DELETE SERVICE process

Delete Windows service for given process.for given process.

Anchor
START_SERVICE process START_SERVICE process

START_SERVICE process

Start Windows service for given process. Same as Windows command NET START.

Anchor
CREATE WINDOWS SHORTCUT CREATE WINDOWS SHORTCUT

CREATE WINDOWS SHORTCUT

Create a shortcut to start-console.bat and place it on the Desktop. (Windows only.)

Anchor
CREATE DDCDB/DDCFILE CREATE DDCDB/DDCFILE

CREATE DDCDB/DDCFILE

Load DDC from file to database or vice versa. This is done automatically during *-all.sh/.bat (from file to database) and then on every process start (from database to ddc_backup directory).

Anchor
ENCRYPT password ENCRYPT password

ENCRYPT password

Encrypts the password, so the value can be used in the DDC file, where all passwords are stored encrypted.

Anchor
UPGRADE REPOSITORY

...

UPGRADE REPOSITORY

UPGRADE REPOSITORY

Image Added 

Upgrade the Dbvisit Replicate repository to a newer version.

Anchor
DOWNGRADE REPOSITORY DOWNGRADE REPOSITORY

...

DOWNGRADE REPOSITORY

Image Added 

Downgrade the Dbvisit Replicate repository to an older version.