Replication Agent Commands Table

log_system_name

All

Returns the path to the Replication Agent system log file.

lr_dump_marker

Oracle

Returns or sets the system change number (SCN), indicating the point at which the primary database was last dumped.

pdb_capabilities

All

Returns a list of Replication Agent capabilities.

pdb_date

All

Returns the current date and time from the primary data server.

pdb_execute_sql

All

Executes the specified SQL statement in the current database.

pdb_gen_id

All

Returns the current value of the database generation ID; updates the value of the database generation ID.

pdb_get_columns

All

Returns a list of all the columns in the specified table.

pdb_get_databases

All

Returns a list of all the databases in the primary data server.

pdb_get_primary_keys

All

Returns a list of all the columns that make up the primary keys in the specified table.

pdb_get_procedure_parms

Oracle

MSSQL

Returns a list of the properties for the specified procedure.

pdb_get_procedures

Oracle

MSSQL

Returns a list of all the procedures in the specified database.

pdb_get_sql_database

All

Returns the name of the database specified for SQL statement execution.

pdb_get_tables

All

Returns a list of all the tables in the specified database.

pdb_ownerfilter

Oracle

MSSQL

Returns a list of owners whose objects will be filtered for initialization; adds or removes owners to or from the list.

pdb_send_osuser_list

Oracle

Returns and modifies a list of database users whose primary database user names will be replaced with the corresponding operating system user name in LTL sent to Replication Server®.

pdb_set_sql_database

All

Specifies the database to be used for SQL statement execution.

pdb_setrepcol

All

Returns replication marking status; enables or disables replication for all marked columns or a specified column.

pdb_setrepddl

Oracle

MSSQL

Returns DDL replication status; enables or disables replication for DDL statements.

pdb_setrepproc

Oracle

MSSQL

Changes and reports stored procedure marking status.

pdb_setrepseq

Oracle

Changes and reports sequence replication marking status.

pdb_setreptable

All

Changes and reports table replication marking status.

pdb_skip_op

All

Returns, adds, or removes record identifiers from a list of records to skip in processing.

pdb_thread_filter

Oracle

Filters all activity on an Oracle instance redo log thread or threads during replication, and displays a list of threads being filtered.

pdb_truncate_xlog

All

Truncates the Replication Agent primary database transaction log.

pdb_version

All

Returns the type and version of the primary data server.

pdb_xlog

All

Returns names of transaction log objects; creates Replication Agent system objects in the primary database; removes Replication Agent system objects from the primary database.

quiesce

All

Stops current Log Reader activity after all data remaining in the transaction log and Replication Agent internal queues is processed and puts Replication Agent in Admin state.

ra_admin

All

Returns the names of Replication Agent system objects; creates Replication Agent system objects in the primary database; or removes Replication Agent system objects from the primary database.

ra_config

All

Returns help information for configuration parameters; sets the value of a configuration parameter.

ra_date

All

Returns the current date and time from the Replication Agent server.

ra_deviceoffset

MSSQL

Changes the raw disk device read offset for a log device recorded in the Replication Agent System Database (RASD).

ra_devicepath

MSSQL

Changes the disk device path for a log device recorded in the RASD.

ra_downgrade

All

Prepares Replication Agent to downgrade to an earlier version.

ra_downgrade_accept

All

Completes the version downgrade process initiated by the instance from which Replication Agent is being downgraded.

ra_downgrade_prepare

All

Prepares Replication Agent for a version downgrade.

ra_dump

All

Records a dump marker in the primary database transaction log.

ra_dumptran

Oracle

Returns information for use in troubleshooting a specific database transaction.

ra_finalize_upgrade

All

Finalizes the upgrade of an instance from a previous version and prevents downgrade to the previous version.

ra_help

All

Returns help information for Replication Agent commands.

ra_helparchive

Oracle

Displays a list of metadata for all managed archive logs, for a specific redo log thread, or for archive logs for a specific redo log thread.

ra_helparticle

All

Returns information about articles from the RASD.

ra_helpdb

Oracle

MSSQL

Returns information about the primary database from the RASD.

ra_helpdevice

Oracle

MSSQL

Returns information about primary database log devices from the RASD.

ra_helpdeviceoffset

MSSQL

Returns device offset information about primary database log devices from the RASD log device repository.

ra_helpfield

All

Returns information about fields (columns in tables, or input parameters in stored procedures) from the RASD.

ra_helplocator

All

Returns LTM locator field values.

ra_helpop

All

Returns information for use in troubleshooting a specific database transaction log operation.

ra_helptran

Oracle

Returns a list of all open transactions.

ra_helpuser

Oracle

MSSQL

Returns information about primary database users from the RASD.

ra_license

All

Returns license information for Replication Agent and its licensed features.

ra_locator

All

Returns and changes the current value of the LTM Locator stored by Replication Agent.

ra_maintid

All

Returns the maintenance user for the Replication Agent connection.

ra_marker

All

Records a marker in the primary database transaction log.

ra_migrate

All

Performs any necessary migration and downgrade tasks between releases of Replication Agent.

ra_purge_first_open

Oracle

Removes the first open transaction from the list of open transactions.

ra_regenerate_keys

All

Regenerates the value of the instance_rand configuration property.

ra_set_autocorrection

All

Enables or disables autocorrection for marked tables.

ra_set_login

All

Sets the Replication Agent admin user login and password.

ra_statistics

All

Returns statistics for either a specified Replication Agent component or all components, and resets statistics for all components.

ra_statrack

All

Starts and stops the statistics tracking thread.

ra_statrack_list

All

Adds or removes a group of statistics from the tracking list, replaces the tracking list, and displays a list of statistics currently being tracked.

ra_status

All

Returns the current Replication Agent state.

ra_truncatearticles

All

Truncates older versions of primary database articles in the system data repository in the RASD.

ra_truncateddlfilters

Oracle

Truncates old lists of DDL commands that are filtered in the RASD.

ra_truncateusers

Oracle

MSSQL

Truncates older versions of primary database users in the system data repository in the RASD.

ra_updatedevices

Oracle

MSSQL

Updates the log device repository in the RASD.

ra_updateusers

Oracle

Reloads user information from the primary database to the RASD.

ra_version

All

Returns the Replication Agent version.

ra_version_all

All

Returns Replication Agent, primary data server, Replication Server, and communications driver versions.

rasd_backup

Oracle

MSSQL

Backs up the Replication Agent System Database (RASD).

rasd_helpbackup

Oracle

MSSQL

Displays a list of RASD backups.

rasd_removebackup

Oracle

MSSQL

Removes RASD backups.

rasd_restore

Oracle

MSSQL

Restores the Replication Agent System Database (RASD).

rasd_trunc_schedule

Oracle

MSSQL

Returns a list of the repository truncation weekly schedule; also adds or removes a specific schedule.

resume

All

Starts replication for the current active log and puts Replication Agent in Replicating state.

rs_create_repdef

All

Creates a replication definition at Replication Server for a marked table and procedure, or for all marked tables and procedures.

rs_drop_repdef

All

A replication definition at the configured Replication Server for a table and procedure is dropped.

rs_ticket

All

Supports Replication Server rs_ticket processing by placing an rs_ticket marker in the primary database transaction log.

server_xlog

MSSQL

Creates or removes Replication Agent system objects in the Microsoft SQL Server system resource database. This command is used for first-time initialization of Replication Agent for Microsoft SQL Server and should be run before pdb_xlog init.

shutdown

All

Shuts down Replication Agent.

suspend

All

Immediately stops all Log Reader activity, drops connections, and puts Replication Agent in Admin state.

test_connection

All

Tests Replication Agent connectivity.

trace

All

Returns current trace flag settings; changes a specified trace flag.