Oracle7 Server Distributed Systems Manual, Vol. 2 Go to Product Documentation Library
Go to books for this product
Go to Contents for this book
Go to Index

Go to previous file in sequence Go to next file in sequence


This manual describes Oracle7 Server replication capabilities. To use the synchronous replication facility, you must have installed Oracle's advanced replication option. Basic replication (read-only and updatable snapshots) is standard Oracle distributed functionality. Procedural replication requires PL/SQL and the advanced replication option.

Information in this manual applies to the Oracle7 Server running on all operating systems.

Topics include the following:


This manual is written for application developers and database administrators who develop and maintain advanced Oracle7 distributed systems.

Knowledge Assumed of the Reader

This manual assumes you are familiar with relational database concepts, distributed database administration, PL/SQL (if using procedural replication), and the operating system under which you run will run an Oracle replicated environment.

This manual also assumes that you have read and understand the information in the following documents:

How Oracle7 Server Distributed Systems, Volume II Is Organized

This manual contains 13 chapters and two appendices, as described below.

Chapter 1: Understanding Replication This chapter provides an overview of the options available for data replication with the Oracle Server.

Chapter 2: Designing a Replicated Environment This chapter introduces many of the issues that you will need to consider when designing your replicated environment.

Chapter 3: Read-Only Snapshots This chapter explains how to use read-only snapshots to perform basic primary site replication.

Chapter 4: Multi-Master Replication This chapter describes how to create and maintain a multi-master replicated environment using the Oracle symmetric replication facility.

Chapter 5: Snapshot Replication This chapter describes how to create and maintain a snapshot site using the Oracle symmetric replication facility. This chapter also describes updatable snapshots.

Chapter 6: Conflict Resolution This chapter describes how to use Oracle-supplied conflict resolution methods to resolve conflicts resulting from dynamic or shared ownership of data in a replicated environment.

Chapter 7: Administering a Replicated Environment This chapter describes how to detect and resolve unresolved replication errors, as well as how to monitor successful conflict resolution.

Chapter 8: Advanced Techniques This chapter describes advanced replication techniques, including how to do the following: create your own conflict resolution routines; implement a fail-over site; implement token passing; use procedural replication; and handle deletes.

Chapter 9: Troubleshooting This chapter describes how to solve several common problems that you may encounter in setting up your replicated environment.

Chapter 10: Using Job Queues This chapter describes how to use job queues to schedule routines to be executed periodically.

Chapter 11: Using Deferred Transactions This chapter describes how to build transactions for deferred execution at remote locations.

Chapter 12: Reference This chapter describes the parameters for the packaged procedures used to implement a replicated environment, as well as any exceptions that might be raised by these procedures.

Chapter 13: Data Dictionary Views This chapter describes the views that may be of interest to users of deferred transactions, read-only snapshots, and the symmetric replication facility.

Appendix A: Compatibility This appendix discusses the compatibility issues between release 7.3 of the advanced replication option and previous releases.

Appendix B: Operating System-Specific Information This appendix is a summary of all the operating system-specific references contained within this manual.

Conventions Used in This Manual

This manual uses different fonts to represent different types of information.

Special Icons

Special icons alert you to particular information within the body of this manual:

Suggestion: The lightbulb highlights suggestions and practical tips that could save time, make procedures easier, and so on.

Attention: This icon draws your attention to items of particular importance.

Warning: The warning symbol highlights text that warns you of actions that could be particularly damaging or fatal to your operations.

Additional Information: The OSDoc icon refers you to the Oracle operating system-specific documentation for additional information.

Text of the Manual

The following sections describe the conventions used in the text of this manual.

UPPERCASE Characters

Uppercase text is used to call attention to command keywords, object names, parameters, filenames, and so on.

For example, "If you create a private rollback segment, the name must be included in the ROLLBACK_SEGMENTS parameter of the parameter file."

Italicized Characters

Italicized words within text indicate the definition of a word, book titles, or emphasized words.

An example of a definition is the following: "A database is a collection of data to be treated as a unit. The general purpose of a database is to store and retrieve related information, as needed."

An example of a reference to another book is the following: "For more information, see Oracle7 Server Tuning."

An example of an emphasized word is the following: "You must back up your database regularly."

Code Examples

SQL, Server Manager line mode, and SQL*Plus commands/statements appear separated from the text of paragraphs in a monospaced font. For example:

INSERT INTO emp (empno, ename) VALUES (1000, 'SMITH'); 

Example statements may include punctuation, such as commas or quotation marks. All punctuation in example statements is required. All example statements terminate with a semicolon (;). Depending on the application, a semicolon or other terminator may or may not be required to end a statement.

Uppercase words in example statements indicate the keywords within Oracle SQL. When issuing statements, however, keywords are not case sensitive.

Lowercase words in example statements indicate words supplied only for the context of the example. For example, lowercase words may indicate the name of a table, column, or file.

Your Comments Are Welcome

We value and appreciate your comments as an Oracle user and reader of the manuals. As we write, revise, and evaluate, your opinions are the most important input we receive. At the back of this manual is a Reader's Comment Form, which we encourage you to use to tell us what you like and dislike about this manual or other Oracle manuals.

Oracle7 Server Documentation Manager
Oracle Corporation
500 Oracle Parkway
Redwood Shores, CA 94065

Go to previous file in sequence Go to next file in sequence
Prev Next
Copyright © 1996 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Go to books for this product
Go to Contents for this book
Go to Index