Subscriber Database Operations
Use this form of ttRepAdmin
to check the status or reset the state of a subscriber (receiver) database.
ttRepAdmin -receiver [-name receiverName] [-host receiverHostName] [-state receiverState] [-reset] [-list] [-scheme [owner.]schemeName] {DSN | -connStr connection_string}
Options
ttRepAdmin -receiver
has the options:
Option | Description |
---|---|
|
Data source name of the master database. |
|
Connection string of the master database, an ODBC connection string that specifies a database location, driver, and optionally other connection attribute settings. |
|
Subscriber databases receiving updates from the master. Use |
|
A specific subscriber (receiving) database. The |
|
Host name or TCP/IP address of the subscriber host. |
|
Sets the state of replication for the subscriber.
See Set the Replication State of Subscribers in Oracle TimesTen In-Memory Database Replication Guide for more information. |
|
Clears the bookmark in the master database log for the latest transaction to be sent to a given subscriber. This option should only be used when the transaction numbering of the master database is changed, such as when the database is re-created using |
|
Lists information about a replication definition. |
|
Specifies the replication scheme name when there is more than one scheme. |
Examples
% ttRepAdmin -receiver -list my_dsn
The above syntax lists replication information for all the subscribers of the master database, my_dsn
.
% ttRepAdmin -receiver -name rep_dsn -list my_dsn
The above syntax lists replication information for the rep_dsn
subscriber of the master database, my_dsn
.
% ttRepAdmin -receiver -name rep_dsn -reset my_dsn
The above syntax resets the replication bookmark with respect to the rep_dsn
subscriber of the master database. Should only be used when migrating a replicated database with ttMigrate
or ttBulkCp
.
% ttRepAdmin -receiver -name rep_dsn -state Start my_dsn
The above syntax resets the replication state of the rep_dsn
subscriber database to the Start
state with respect to the master database, my_dsn
.