Chat now with support
Chat with Support

SharePlex 9.0.1 - Reference Guide

About this guide Conventions used in this guide SharePlex commands SharePlex parameters General SharePlex utilities Database Setup utilities SharePlex environment variables

quit

Use the quit command to close the current session of sp_ctrl. Closing sp_ctrl does not shut down replication; all replication processes continue without interruption unless they have been stopped by a user. This command merely discontinues your session with sp_ctrl on that system. To run sp_ctrl again, change to the directory containing the SharePlex binaries and enter the ./sp_ctrl command (for Unix and Linux systems) or double-click the sp_ctrl shortcut (Windows systems).

There are no [on host] options for the quit command. It must be issued on the system where you want to stop running sp_ctrl. This command is the same as the exit command.

Usage

Supported sources: Oracle and SQL Server
Supported targets: All
Authorization level: Viewer (3)
Issued for: source or target system
Related commands: exit

Syntax

Basic command Remote options
quit | q Not available

reconcile

Use the reconcile command as part of a procedure to synchronize (instantiate) source and target data with minimal interruption to the database users. The reconcile command coordinates the results of ongoing replication with a copy of the source data that is applied to the target system, such as that applied by a hot-backup or a native copy utility. The reconcile function compares the replicated changes in the post queue with the state of the target database after the recovery process. It differentiates between the transactions that were applied during recovery from those that have not yet been applied (still waiting in the post queue), and it only posts the non-duplicated changes so that both systems are synchronized.

Although the reconcile command is designed for use in high-volume environments, it can be used in low-volume environments with an understanding that the reconcile process can, in some circumstances, seem to stall. This happens because the reconcile command depends on data continuing to arrive from the source system. If there is no replication activity on the source system after the hot backup or copy, the reconcile process waits until source activity resumes.

Considerations when using the reconcile command

The reconcile command should be used when following specific procedures for the initial synchronization of source and target data. It is not meant to be a standalone command. For initial synchronization procedures, see the SharePlex Administration Guide.

Usage

Supported sources: Oracle and SQL Server
Supported targets: All
Authorization level: Administrator (1)
Issued for: target system
Related commands: flush

Syntax

Basic command Command options Remote options
reconcile queue queuename for datasource-datadest

lsn log_sequence_number

[seq sequence_number]

[scn scn_number]

[to flush]

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Syntax description

Component Description*
queue queue is a required part of the command.
queuename

The post queue on the target system that you want to reconcile. Valid values are:

  • The name of the source system if using default queues
  • The name of the queue if using named queues

When using named post queues, issue the reconcile command for each one. To determine the queue name, issue the qstatus command in sp_ctrl. Queue names are case-sensitive on all platforms.

for datasource-datadest
  • datasource is expressed as o.SID, where SID is the ORACLE_SID of the source instance.
  • datadest is expressed as o.SID, where SID is the ORACLE_SID of the target instance.

Example:

sp_ctrl (sysB)> reconcile queue SysA for o.oraA-o.oraB

lsn log_sequence_number

(SQL Server) Use this option to reconcile to the end of a specific SQL Server transaction log.

sequence_number is the sequence number of the log. The LSN can be in decimal format or hex format seperated by two colons.

Do not use this option with the to flush option.

Example:

sp_ctrl (sysB)> reconcile queue SysA for r.mssA-r.mssB lsn 3ef:00000df6:000b

seq sequence_number

(Oracle) Use this option when an Oracle hot backup is used to establish Oracle target data in the synchronization procedure. It directs SharePlex to reconcile to the end of the same log that Oracle uses for its recovery.

sequence_number is the sequence number of the log to which Oracle recovers.

The syntax must appear after the syntax for the basic command. Do not use this option with the to flush option.

Example:

sp_ctrl (sysB)> reconcile queue SysA for o.oraA-o.oraB seq 1234

scn scn_number

(Oracle) Use this option when an Oracle hot backup is used to establish Oracle target data in the synchronization procedure. It directs SharePlex to reconcile to a specific Oracle System Change Number (SCN).

scn_number is the SCN to which Oracle recovers.

The syntax must appear after the syntax for the basic command. Do not use this option with the to flush option.

Example:

sp_ctrl (sysB)> reconcile queue SysA for o.oraA-o.oraB scn 0123456789

to flush

Use this option to reconcile to a flush marker that is established with the flush command. Use it for synchronizing multiple Oracle databases in a peer-to-peer replication environment.

The syntax must appear after the syntax for the basic command. Do not use this option with the seq sequence_number option.

Example:

sp_ctrl (sysA)> reconcile queue SysA for o.oraA-o.oraB to flush

Remote options

These options enable you to issue the command on a remote machine and to script commands that include a login name, password, port number, or combination of those items.

Option Description
on host

Execute the command on a remote system (one other than the one where the current sp_ctrl session is running). You are prompted for login credentials for the remote system. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on SysA

on host:portnumber

Execute the command on a remote system when a remote login and port number must be provided. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on SysA:8304

on login/password@host

Execute the command on a remote system when a remote login, password, and host name must be provided. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on john/spot5489@SysA

on login/password@host:portnumber

Execute the command on a remote system when a remote login, password, host name, and port number must be provided. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on john/spot5489@SysA:8304

redo

Use the redo command to execute the previous command again without having to retype it. This command is useful when you are making frequent status checks with the information commands, for example using the qstatus command to monitor changes in queue volume.

This command only can be issued from within sp_ctrl; it cannot be issued directly from the operating system’s command line. There are no [on host] options for this command.

SharePlex also provides keyboard short-cuts that perform the same task as the redo command. Invoking the forward slash or the up arrow while in sp_ctrl will execute the previous command.

Usage

Supported sources: Oracle and SQL Server
Supported targets: All
Authorization level: To “redo” the previous command, the user must have that command’s authorization level or higher.
Issued for: The system affected by the previous command.
Related commands: none

Syntax

Basic command Remote options
redo | / | r Not available

remove config

Use the remove config command to permanently delete a configuration file from the system. This command does not prompt for confirmation, and removing a configuration file cannot be undone. You cannot remove an active configuration. To remove an active configuration, deactivate it first.

TIP: You might be able to recover an accidentally deleted configuration if that configuration was previously active and you did not run ora_cleansp since it was activated. To recover the configuration, view the Event Log to determine the activation ID for that configuration file, then look in the save sub-directory of the SharePlex variable-data directory for a .conf.actid file, where actid is the activation ID you got from the Event Log.

Usage

Supported sources: Oracle and SQL Server
Supported targets: All
Authorization level: Operator (2)
Issued for: source system
Related commands: deactivate config, list config, show config, view config

Syntax

Basic command Remote options
remove config filename

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Syntax description

Component Description
filename

The name of the configuration that you want to remove. Configuration names are case-sensitive.

Example:

sp_ctrl(sysA)> remove config sales

Remote options

These options enable you to issue the command on a remote machine and to script commands that include a login name, password, port number, or combination of those items.

Option Description
on host

Execute the command on a remote system (one other than the one where the current sp_ctrl session is running). You are prompted for login credentials for the remote system. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on SysA

on host:portnumber

Execute the command on a remote system when a remote login and port number must be provided. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on SysA:8304

on login/password@host

Execute the command on a remote system when a remote login, password, and host name must be provided. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on john/spot5489@SysA

on login/password@host:portnumber

Execute the command on a remote system when a remote login, password, host name, and port number must be provided. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on john/spot5489@SysA:8304

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating