Defining an Active Standby Pair Replication Scheme

Use the CREATE ACTIVE STANDBY PAIR SQL statement to create an active standby pair replication scheme. You must have the ADMIN privilege to use the CREATE ACTIVE STANDBY PAIR statement and to perform other replication operations. Only the instance administrator can duplicate databases.

Note:

See Configuring an Active Standby Pair With One Subscriber for an example. See CREATE ACTIVE STANDBY PAIR for the complete syntax in the Oracle TimesTen In-Memory Database SQL Reference.

Table 3-1 shows the components of the CREATE ACTIVE STANDBY PAIR statement that are used to create the active standby pair replication scheme. Each component is described with the identified topics in this chapter.

Table 3-1 Components of an Active Standby Pair Replication Scheme

Component	See...
`CREATE ACTIVE STANDBY PAIR` `FullDatabaseName, FullDatabaseName`	Identifying the Databases in the Active Standby Pair
`[ReturnServiceAttribute]`	Using a Return Service
`[SUBSCRIBER` `FullDatabaseName` `[,...]]`	Identifying the Databases in the Active Standby Pair
`[STORE` `FullDatabaseName` `[StoreAttribute` `[...]]]`	Setting STORE Attributes
`[NetworkOperation` `[...]]`	Configuring Network Interfaces With the ROUTE Clause
`[{INCLUDE\|EXCLUDE}` `{TABLE [[Owner.]TableName[,...]]\|` `CACHE GROUP [[Owner.]CacheGroupName[,...]\|` `SEQUENCE [[Owner.]SequenceName[,...]]}` `[,...]]`	Including or Excluding Database Objects From Replication Replicating Cache Groups Within Active Standby Pairs