All keywords are case-insensitive.
These internal commands form part of the regular Dbvisit Replicate commands. Regular Dbvisit Replicate commands maybe made up of several internal commands.
Use these internal commands with caution.
If the command works directly with an mine. apply or fetcher process (not by process name), choose the process by using the “choose” command.
CREATE SERVICE process_name
Create Windows service for the process.
DELETE SERVICE process_name
Delete Windows service for the process.
START SERVICE process_name
Start Windows service for the process (=equal to pressing the start button in Windows Services console).
ENGINE SETUP {MINE|APPLY} CREATE DICTIONARY
Create mine dictionary in database (structure only).
ENGINE SETUP {MINE|APPLY} LOAD DICTIONARY
Create mine dictionary in database (data only).
ENGINE SETUP {MINE|APPLY} DROP DICTIONARY
Drops mine dictionary in database.
ENGINE SETUP MINE DELETE DICTIONARY
Delete data in dictionary in database, just for current DDC_ID.
ENGINE SETUP PAIR MINE AND APPLY
Register target database in mine metadata, must be executed after you load/create mine and apply dictionary.
ENGINE SUPPLEMENTAL LOGGING TABLE schema.table_name ENABLE PRIMARY KEY
ENGINE SUPPLEMENTAL LOGGING TABLE schema.table_name DISABLE PRIMARY KEY
Enables/disables supplemental logging on table for its primary key. This is mandatory on source for replicate tables. (This is done automatically by PREPARE commands.)
It is also mandatory to enable supplemental logging at database level. This is done automatically during ENGINE SETUP MINE DICTIONARY.
ENGINE SUPPLEMENTAL LOGGING SCHEMA schema ENABLE PRIMARY KEY
ENGINE SUPPLEMENTAL LOGGING SCHEMA schema DISABLE PRIMARY KEY
Enables/disables supplemental logging on all table in the schema for their primary key. This is mandatory on source for replicate tables. (This is done automatically by PREPARE commands.)
It is also mandatory to enable supplemental logging at database level. This is done automatically during ENGINE SETUP MINE DICTIONARY.
ENGINE DUMP MESSAGES
Dumps buffer of debug messages that were suppressed by DEBUG_LEVEL setting. (Dumps about last 400kB.)
ENGINE DUMP MEMORY_ACCOUNTING
Dumps memory accounting info – number of allocations, memory used, etc.
Each allocation point (=malloc call in C code) has it’s own id and this is equal to error code that is raised if the malloc fails – so refer to error code list to find out where is the memory allocated.
ENGINE DUMP ALL
Runs both ENGINE DUMP MESSAGES and ENGINE DUMP MEMORY_ACCOUNTING commands. This command can be also invoked by sending SIGUSR2 (kill -12) to the process (not available on Windows).
ENGINE ENCRYPT string
Encrypts/decrypts given string. To be used when setting passwords.
ENGINE SWITCH_REDOLOG
Do a log switch on the database.
ENGINE PREPARE_DP SETUP CLEAR
Forget all tables for next instantiation script.
ENGINE PREPARE_DP WRITE DP_NETWORKLINK DIRECTORY directory FILE file DBLINK dblink USERID user/pass@db
Write data load script for network import (data pump).
ENGINE PREPARE_DP WRITE DP_EXP DIRECTORY directory FILE file MINE_USERID user/pass@db APPLY_USERID user/pass@db
Write data load script for file export/import (data pump).
ENGINE PREPARE_DP WRITE EXP FILE file MINE_USERID user/pass@db APPLY_USERID user/pass@db
Write data load script for file export/import (pre-10g export/import).
ENGINE PREPARE_DP WRITE DDL_FILE FILE file USERID user/pass@db
Write data load script – ddl create (just DDL, so it actually does not load the data).
ENGINE DDL_CHECK ddlopid ddltext
Check whether the given DDL text would be replicated with DDL replication. Ddlopid is Oracle DDL operation id.
ENGINE LOCK TABLES list of tables
ENGINE LOCK SCHEMAS list of tables
Lock the listed tables/schemas in share exclusive mode and remember the SCN. This is used for single-scn instantiation.
ENGINE LOCK RELEASE LOCKS
Release the locks held.
ENGINE CLEAR SCN
Forget the SCN remembered for single-scn. Finish the instantiation (some operations on dictionary are done in batches instead for each table, this command finishes all pending work needed).
ENGINE LOCK RELEASE ALL
Runs both ENGINE LOCK RELEASE LOCKS and ENGINE CLEAR SCN. This is kept for compatibility only (used before 2.3.14, when the locks were released only after PREPARE statements were executed and no caching of PREPARE statements was used).
ENGINE MINE RESET
ENGINE MINE RESET TO PLOG sequence
Force mine to forget generated plogs (after sequence or all of them). Mine will thus on next start go back in history to parse the redo logs again. Run when mine is stopped.