Replication Agent Commands Table

log_system_name

Returns the path to the Replication Agent system log file.

lr_dump_marker

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

pdb_capabilities

Returns a list of Replication Agent capabilities.

pdb_date

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

pdb_execute_sql

Executes the specified SQL statement in the current database.

pdb_gen_id

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

pdb_get_columns

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

pdb_get_databases

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

pdb_get_primary_keys

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

pdb_get_procedure_parms

Returns a list of the properties for the specified procedure.

pdb_get_procedures

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

pdb_get_sql_database

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

pdb_get_tables

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

pdb_ownerfilter

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

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

Specifies the database to be used for SQL statement execution.

pdb_setrepcol

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

pdb_setrepddl

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

pdb_setrepproc

Changes and reports stored procedure marking status.

pdb_setrepseq

Changes and reports sequence replication marking status.

pdb_setreptable

Changes and reports table replication marking status.

pdb_skip_op

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

pdb_thread_filter

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

Truncates the Replication Agent primary database transaction log.

pdb_version

Returns the type and version of the primary data server.

pdb_xlog

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

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

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

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

ra_date

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

ra_downgrade

Prepares Replication Agent to downgrade to an earlier version.

ra_downgrade_accept

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

ra_downgrade_prepare

Prepares Replication Agent for a version downgrade.

ra_dump

Records a dump marker in the primary database transaction log.

ra_dumptran

Returns information for use in troubleshooting a specific database transaction.

ra_finalize_upgrade

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

ra_help

Returns help information for Replication Agent commands.

ra_helparchive

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

Returns information about articles from the RASD.

ra_helpdb

Returns information about the primary database from the RASD.

ra_helpdevice

Returns information about primary database log devices from the RASD.

ra_helpfield

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

ra_helplocator

Returns LTM locator field values.

ra_helpop

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

ra_helptran

Returns a list of all open transactions.

ra_helpuser

Returns information about primary database users from the RASD.

ra_license

Returns license information for Replication Agent and its licensed features.

ra_locator

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

ra_maintid

Returns the maintenance user for the Replication Agent connection.

ra_marker

Records a marker in the primary database transaction log.

ra_migrate

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

ra_purge_first_open

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

ra_regenerate_keys

Regenerates the value of the instance_rand configuration property and the instance_password_ key entry in the RASD encryption keys table

ra_set_autocorrection

Enables or disables autocorrection for marked tables.

ra_set_login

Sets the Replication Agent admin user login and password.

ra_statistics

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

ra_statrack

Starts and stops the statistics tracking thread.

ra_statrack_list

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

Returns the current Replication Agent state.

ra_truncatearticles

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

ra_truncateddlfilters

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

ra_truncateusers

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

ra_updatedevices

Updates the log device repository in the RASD.

ra_updateusers

Reloads user information from the primary database to the RASD.

ra_version

Returns the Replication Agent version.

ra_version_all

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

rasd_backup

Backs up the Replication Agent System Database (RASD).

rasd_helpbackup

Displays a list of RASD backups.

rasd_removebackup

Removes RASD backups.

rasd_restore

Restores the Replication Agent System Database (RASD).

rasd_trunc_schedule

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

resume

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

rs_create_repdef

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

rs_drop_repdef

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

rs_ticket

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

shutdown

Shuts down Replication Agent.

suspend

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

test_connection

Tests Replication Agent connectivity.

trace

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