지금 지원 담당자와 채팅
지원 담당자와 채팅

SharePlex 11.1 - Administration Guide

About this Guide Conventions used in this guide Revision History Overview of SharePlex Run SharePlex Run multiple instances of SharePlex Execute commands in sp_ctrl Set SharePlex parameters Configure data replication Configure replication to and from a container database Configure named queues Configure partitioned replication Configure replication to a change history target Configure a replication strategy Configure DDL replication Configure error handling Configure data transformation Configure security features Assign SharePlex users to security groups Start replication on your production systems Monitor SharePlex Prevent and solve replication problems Repair out-of-sync data Tune the Capture process Tune the Post process Recover replication after Oracle failover Make changes to an active replication environment Apply an Oracle application patch or upgrade Back up Oracle data on the source or target Troubleshooting Tips Appendix A: Peer-To-Peer Diagram Appendix B: SharePlex environment variables

About this Guide

This manual provides instructions for:

  • Operating SharePlex
  • Planning your replication strategy
  • Preparing the environment for replication
  • Configuring replication
  • Starting replication
  • Monitoring, tuning, and troubleshooting replication
  • Failover/failback in a high-availability environment
  • Performing administrative operations on replication systems

Other SharePlex Documentation

For the complete SharePlex documentation set, go to https://support.quest.com/shareplex/technical-documents.

View this Document in PDF Format

You can download, view, and save this document in Adobe PDF format. Click Download in the upper right-hand corner of this page. This action downloads the entire publication.

Conventions used in this guide

Conventions used in this manual

The following typographic conventions are used in this guide:

  • Bold represents required components of a command or option that must be typed as shown.
  • Italics represent variables defined, named or entered by the user.
  • {Braces} enclose required arguments.
  • [Brackets] represent optional command components and may also be used in example command strings to emphasize required user defined variables in long strings.

    Example:

    reconcile queue {queuename} for {datasource-datadest} [on host]

  • A vertical bar, or “pipe” character, ( | ) within brackets or braces indicates that you can use only one of the enclosed components.

    Example:

    abort service {service | all}

Names of commands, programs, directories and files are expressed in Bold.

Other names are expressed in capital letters using the default font.

Examples:

The sp_ctrl program is located in the bin directory.

Open the oramsglst file.

Find the value for ORACLE_HOME.

Click Apply.

System displays, such as prompts and command output, are expressed in a monofaced (fixed-space) font.

Examples:

sp_ctrl(sysA)>

User is a viewer (level=3)

Windows menu items, dialog boxes, and options within dialog boxes are expressed in Bold.

Example:

From the File menu, select Print.

System names are expressed generically or fictitiously. When necessary, the source system (or primary system) is referred to as SysA. Target systems (or secondary systems) are referred to as SysB, SysC, SysD, and so forth.

Revision History

Document version Date Change history
2 5th March 2024 Added a note regarding the {broker.name} property in the Replicate from Oracle to Kafka using Kerberos authentication section.
3 19th April 2024 Added the Activate replication with PostgreSQL hot backup on an active database section.
4 8th May 2024 Added the Initial Database Synchronization for PostgreSQL to PostgreSQL Replication section.

Overview of SharePlex

SharePlex provides high-speed replication that supports a variety of topology configurations in heterogeneous database environments. This chapter provides an overview of how SharePlex replication works. It explains concepts surrounding SharePlex replication and provides an overview of SharePlex capabilities.

For more information about the platforms and databases that SharePlex supports, see the SharePlex Release Notes.

Contents
셀프 서비스 도구
지식 기반
공지 및 알림
제품 지원
소프트웨어 다운로드
기술 설명서
사용자 포럼
비디오 자습서
RSS 피드
문의처
라이센싱 지원가져오기
기술 지원
모두 보기
관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택