Index

A B C D E F H I L M N O P R S T U V W

A

active master data store

detecting dual active masters, 4.8

active standby pair

adding host to cluster, 6.5.8

adding or dropping a subscriber, 5.9

adding or dropping subscriber, 4.9, 5.9

adding tables or cache groups, 4.9, 5.9, 5.9

altering, 4.9

altering STORE attributes, 5.9

altering store attributes, 4.9, 5.9

configuring network interfaces, 3.7

detecting dual active masters, 4.8

disaster recovery, 5.10

dropping tables or cache groups, 4.9, 5.9

DSN, 3.2

excluding tables or cache groups, 5.9

failback, 4.4.3, 5.4.3

overview, 1.5.1

recover active when standby not ready, 4.4.2

recovering active master data store, 4.4

replicating a global AWT cache group, 5.3

replicating local read-only cache group, 5.2

restrictions, 3.1

return service, 3.5

return twosafe service, 7.3.4

setting up, 4.3

states, 4.1

SUBSCRIBER clause, 3.4

subscriber failure, 4.6

active standby pair with cache groups

altering, 5.9

recover active when standby not ready, 5.4.2

recovering active master data store, 5.4

subscriber failure, 5.6

ADD ELEMENT clause

data store, 10.1.2

ADMIN privilege, 3.3, 7.2, 8.2

aging, 1.9

ALTER ELEMENT clause, 10.1.1

ALTER REPLICATION, use of, 10.1

ALTER TABLE

and replication, 10.2

application failover

Oracle Clusterware, 6.2.4

asynchronous writethrough cache group

propagating to Oracle database, 1.6.2

replication, 1.6.1

attributes

ForceConnect, 11.2.1.3

autocommit, 7.3.2, 7.3.3

RETURN RECEIPT BY REQUEST, 3.5.2

RETURN TWOSAFE BY REQUEST, 3.5.4

AutoCommit connection attribute

RETURN TWOSAFE, 3.5.3

automatic catch-up, 11.2.1.3

automatic client failover, 6.1

AWT cache group

propagating to Oracle Database, 1.6.2

replicating, 5.3

replication, 1.6.1

B

bidirectional replication, 1.5.3

bookmarks in log, 8.2.2.4, 9.5

C

cache grid

active standby pairs, 5.3

cache group

excluding from data store, 10.1.2.2

including in data store, 10.1.2.1

cache groups

replicating a global AWT cache group, 5.3

replicating a read-only cache group, 5.2

cache groups, replicating, 1.6

catch-up feature, 11.2.1.3

CHECK CONFLICTS clause, 7.2.4, 11.1.4.2

client failover, 6.1

cluster

virtual IP addresses, 6.1

cluster agent, 6.3.2

cluster manager, role of, 7.1.1

cluster.oracle.ini

advanced availability, 6.2.2

advanced availability, one subscriber, 6.2.2

application failover, 6.2.4, 6.2.4

automatic recovery from failure of both master nodes, 6.2.5

basic availability, 6.2.1

basic availability, one subscriber, 6.2.1

cache groups, 6.2.3

excluding tables, cache groups and sequences, 6.2.6

location, 6.2

manual recovery from failure of both master nodes, 6.2.5

Windows example, 6.2.1, 6.2.4

cluster.oracle.ini file, 6.1

examples, 6.2

specify route, 6.2.6

Clusterware

required privileges, 6.1.2

COMPRESS TRAFFIC

active standby pair, 3.6.3

STORE attribute in CREATE REPLICATION statement, 7.4.3

configuring replication, 7.1

configuring the network, 8.1

configuring timestamp comparison, 11.1.4

conflict reporting, 11.1.8

CONFLICT REPORTING attributes, 7.4

conflict resolution, 11.1, 11.1.3

conflict types, 11.1

controlling replication, 8.6

copying a data store

privileges, 4.2, 8.2.1.3

copying a master data store, 8.2.1.3

CREATE ACTIVE STANDBY PAIR, 5.2

syntax, 3.3

using, 3.3

CREATE ACTIVE STANDBY PAIR statement, 4.3

CREATE REPLICATION

defining data store element, 7.2.3.1

defining table element, 7.2.3.2, 7.2.3.3

use of, 7.2

D

data store

ForceConnect attribute, 11.2.1.3

data store element, 7.2.3.1

data store file name

defined, 3.2, 7.2.2

data store name, 7.2.2

data store objects

excluding from active standby pair, 3.8

data stores

attributes of, 8.2.1.1

duplicating, 8.2.1.3

establishing, 8.2.1

failed, 3.6.5, 8.2.2.3, 11.2

managing logs, 8.2.2

recovering, 7.1.1, 11.2

setting state, 8.6

data types, size limits on, 8.2.1.2

DATASTORE element, 7.2.3

adding to replication scheme, 10.1.2

and materialized views, 7.8

and nonmaterialized views, 7.8

default column values, 10.2

DISABLE RETURN attribute, 7.4, 7.4, 7.4

DISABLE RETURN policy, 7.4.2.2.2, 7.4.2.2.4

active standby pair, 3.6.2.2.2, 3.6.2.2.4

disaster recovery

active standby pair with AWT cache group, 5.10

disk-based logs

setting size of, 8.2.2.4

distributed workload configuration, 1.5.3.3

recovery issues, 7.1.1

DNS server, 8.1.3.3

DROP REPLICATION, 2.2.6, 10.4

dropping replication scheme, 2.2.6, 10.4

DSN

define for active standby pair, 3.2

defining, 7.2.2

DSNs

creating, 2.2.1, 8.2.1

duplicating a data store

privileges, 4.2, 8.2.1.3

with cache groups, 4.2

duplicating a master data store, 8.2.1.3

DURABLE COMMIT attribute, 7.4

E

element

defined, 1.1

ELEMENT descriptions, 7.2.3

EXCLUDE

active standby pair, 3.8

EXCLUDE SEQUENCE

in CREATE REPLICATION statement, 7.2.3.1

EXCLUDE SEQUENCE clause, 10.1.2.2

EXCLUDE TABLE

in CREATE REPLICATION statement, 7.2.3.1

EXCLUDE TABLE clause, 10.1.2.2

F

failback, 4.4.3, 5.4.3

failed data store, 11.2

connecting to, 3.6.5, 8.2.2.3

Failed state, 8.2.2.3, 8.6, 11.2

log threshold, 3.6.5

failover and recovery, 11.2

issues, 7.1.1

FAILTHRESHOLD, 3.6.2.2.1, 7.4.2.2.1

FAILTHRESHOLD attribute, 7.4, 8.2.2.3, 11.2.1.1, 11.2.1.1, 11.2.1.1

active standby pair, 3.6.5

report setting, 9.4.1

failure recovery script, 11.2.4

ForceConnect attribute, 11.2.1.3, 11.2.1.3, 11.2.3

foreign keys, 1.8

replication, 7.7

full replication, 1.5.2

full store name

active standby pair, 3.4

H

host name

identifying, 7.2.3.1

hostname command, 7.2.3.1

hostnames, 8.1.3

hot standby configuration, 1.4.3, 1.5.3.2

hot-standby configuration

recovery issues, 7.1.1

I

INCLUDE

active standby pair, 3.8

INCLUDE CACHE GROUP

in CREATE REPLICATION statement, 7.2.3.1

INCLUDE SEQUENCE

in CREATE REPLICATION statement, 7.2.3.1

INCLUDE SEQUENCE clause, 10.1.2.1

INCLUDE TABLE, 4.9, 5.9

in CREATE REPLICATION statement, 7.2.3.1

INCLUDE TABLE clause, 10.1.2.1

IP addresses, 8.1.3

L

LOCAL COMMIT ACTION

active standby pair, 3.6.2.2.5

LOCAL COMMIT ACTION attribute, 7.4

log

locating bookmarks, 8.2.2.4, 9.5

management, 8.2.2

size and persistence, 8.2.2.1

threshold value, 8.2.2.3, 8.2.2.3, 8.2.2.4

log sequence number, 9.5

log threshold value

active standby pair, 3.6.5

LogBufMB attribute, 8.2.1.1, 8.2.2.4

LogFileSize attribute, 8.2.1.1, 8.2.2.4

logging, 8.2.2.4

Logging attribute, 8.2.1.1

LSN, 9.5

M

master catch-up, 11.2.1.3

master data store

defined, 7.2.2

materialized views, replicating, 7.8

monitoring replication, 9

N

network requirements, 8.1.3

NO RETURN attribute, 7.3.5

NO RETURN clause

active standby pair, 3.5.5

NVARCHAR columns, size limit, 8.2.1.2

O

ON DELETE CASCADE, 1.8

Oracle Clusterware, 6

adding active standby pair to cluster, 6.5.6

adding subscriber to active standby pair, 6.5.4

altering tables and cache groups, 6.5.1

automatic recovery from dual failure, 6.4.4.1

creating or dropping tables and cache groups, 6.5.1

failure of more than two master hosts, 6.4.5

host maintenance, 6.5.10

machine room maintenance, 6.5.11

manual recovery for advanced availability, 6.4.4.2

manual recovery for basic availability, 6.4.4.3

network maintenance, 6.5.10

removing active standby pair from cluster, 6.5.7

removing host from cluster, 6.5.9

removing subscriber from active standby pair, 6.5.5

required privileges, 6.1.2

restricted commands, 6.1.4

rolling upgrade, 6.5.2

routing, 6.2.6

storage for backups, 6.2.5

TimesTen advanced level, 6.1

TimesTen basic level, 6.1

upgrading TimesTen, 6.5.3

virtual IP addresses, 6.1

owner name, 7.2.1

P

Pause state, 8.6

PORT assignment

active standby pair, 3.6.4

PORT attribute, 7.4

privilege

create an active standby pair, 3.3

required, 8.2

to create a replication scheme, 7.2

propagation, 1.5.4

propagator data store, 1.5.4

defined, 7.2.2

R

read-only cache group

replicating, 1.6.3

recovering failed data stores, 7.1.1, 11.2

RepDDL attribute, 6.2.6

replicated tables, requirements for, 8.2.1.2

replicating over a network, 1.5.4, 8.1

replication

across releases, 8.3

and ttAdmin, 8.5

bidirectional, 1.5.3

configuration issues, 7.1

configuring timestamp comparison, 11.1.4

conflict reporting, 11.1.8

conflict resolution, 11.1

controlling, 8.6

described, 1.1

element, 1.1, 7.2.3

FAILTHRESHOLD, 3.6.2.2.1, 7.4.2.2.1

foreign keys, 7.7

gauging performance, 9.5

monitoring, 9

of materialized views, 7.8

restart policy, 8.5.1, 8.5.1, 8.5.2

return receipt, 1.4.2

starting, 8.5

state of, 8.6

stopping, 8.5

timestamp column maintenance, 11.1.5

unidirectional, 1.5.3

replication agent

defined, 1.3

starting, 2.2.4, 8.5

stopping, 2.2.4, 8.5

replication conflicts, types of, 11.1

replication daemon, see "replication agent"

replication scheme

active standby pair, 1.5.1

applying to DSNs, 8.4

configuring, 7.1

defining, 7.2

dropping, 2.2.6

examples of, 7.10

for cache groups, 1.6

multiple, 7.6

naming, 7.2.1

replication schemes

types, 1.5

repschemes command, 9.4.1

resource

defined, 6.1

restart policy, 8.5.1

RESUME RETURN attribute, 7.4

RESUME RETURN policy, 3.6.2.2.3, 7.4.2.2.3

return receipt

definition, 1.4

RETURN RECEIPT attribute, 7.3.1

example use of, 7.10.1

RETURN RECEIPT BY REQUEST attribute, 7.3.2

example use of, 7.10.2

RETURN RECEIPT BY REQUEST clause

active standby pair, 3.5.2

RETURN RECEIPT clause

active standby pair, 3.5.1

RETURN RECEIPT failure policy

report settings, 9.4.1

return receipt replication, 1.4.2

RETURN RECEPT timeout errors, 1.4.2, 7.4

return service

active standby pair, 3.5

performance and recovery tradeoffs, 7.1.2

return service blocking

disabling, 3.6.2.2, 7.4.2.2

return service failure policy, 7.4.2

active standby pair, 3.6.2

return service timeout errors, 3.6.2, 7.4.2

RETURN SERVICES WHEN REPLICATION STOPPED attribute, 7.4

return twosafe

active standby pair, 7.3.4

definition, 1.4

RETURN TWOSAFE attribute, 7.3.4

RETURN TWOSAFE BY REQUEST attribute, 7.3.3

RETURN TWOSAFE BY REQUEST clause

active standby pair, 3.5.4

RETURN TWOSAFE clause

active standby pair, 3.5.3

RETURN WAIT TIME attribute, 7.4

ROUTE clause

active standby pair, 3.7

S

selective replication, 1.5.2

sequences

replicating, 1.7

split workload, 1.5.3.1

SQLGetInfo function, 3.6.5, 8.2.2.3, 11.2.1.1

standby master data store

recover from failure, 4.5, 5.5

Start state, 8.6

starting the replication agent, 2.2.4, 8.5, 8.5

Stop state, 8.6

stopping the replication agent, 2.2.6, 8.5, 8.5

STORE attributes, 7.4

active standby pair, 3.6

SUBSCRIBER attributes, 7.3

SUBSCRIBER clause, 3.4

subscriber data store

defined, 7.2.2

subscriber failure, 4.6, 5.6

subscribers

number allowed, 7.10.2

T

table

dropping from replication scheme, 10.1.3

excluding from data store, 10.1.2.2

including in data store, 10.1.2.1

TABLE DEFINITION CHECKING attribute, 7.4

examples, 7.4.5

TABLE element, 7.2.3

table element, 7.2.3.2, 7.2.3.3

table requirements, 8.2.1.2

tables

altering and replication, 10.2

threshold log setting, 8.2.2.3, 8.2.2.3, 8.2.2.4

active standby pair, 3.6.5, 3.6.5

timeout

return service for an active standby pair, 3.6.1

TIMEOUT attribute, 7.4

timestamp column maintenance, 11.1.5

timestamp-based conflict resolution, 11.1

TimesTen cluster agent, 6.3.2

TRANSMIT DURABLE attribute, 7.2.5

TRANSMIT NONDURABLE

and recovery, 11.2.3

TRANSMIT NONDURABLE attribute, 7.2.5

TRUNCATE TABLE, 10.3

truncating a replicated table, 10.3

ttAdmin -ramPolicy, use of, 11.2.2.1, 11.2.2.2

ttAdmin -repPolicy, use of, 8.5.1

ttAdmin -repStart, use of, 8.5.1, 8.5.1

ttAdmin -repStop, use of, 8.5.1

ttCkpt procedure, 8.2.2.2

ttCkptBlocking procedure, 8.2.2.2

ttcrsagent.options file, 6.3.2

ttCWAdmin

required privileges, 6.1.2

ttCWAdmin utility, 6.1

ttDestroy, use of, 11.2.2.1

ttDestroyDataStore procedure, use of, 11.2.2.2

ttDurableCommit built-in procedure, 3.6.2.1, 7.4.2.1

ttIsql -f, use of, 8.4

ttRepAdmin -bookmark, use of, 9.5.1

ttRepAdmin -duplicate

privileges, 4.2, 8.2.1.3

ttRepAdmin -duplicate, use of, 7.2.5, 8.2.1.3, 11.2.1.3, 11.2.2.1, 11.2.2.1, 11.2.3

ttRepAdmin -ramLoad, use of, 11.2.2.1, 11.2.2.1

ttRepAdmin -receiver -list, use of, 9.3.1

ttRepAdmin -self -list, use of, 9.2.1

ttRepAdmin -showconfig, use of, 9.4.2

ttRepAdmin -state, use of, 8.6

ttRepDuplicate procedure, use of, 11.2.2.2

ttRepDuplicateEx

privileges, 4.2, 8.2.1.3

ttReplicationStatus procedure, 9.3.2

ttRepReturnTransitionTrap SNMP trap, 7.4.2.2.2

ttRepStart procedure, 8.5.1, 8.5.2, 10.1

ttRepStop procedure, 8.5.1, 8.5.2, 10.1

ttRepSubscriberStateSet procedure, 8.6

ttRepSubscriberWait built-in procedure, 7.9

ttRepSyncGet built-in procedure, 3.5.2, 3.5.4

ttRepSyncGet procedure, 7.3.2, 7.3.3

ttRepSyncSet built-in procedure, 3.5.2, 3.5.4, 3.6, 3.6, 3.6.1, 3.6.2, 7.3.2, 7.3.3, 7.4, 7.4, 7.10.2

ttRepSyncSet procedure, 3.6.2.2.5, 7.3.3, 7.4.1, 7.4.1, 7.4.2, 7.4.2.2.5

ttRepSyncSubscriberStatus procedure, 7.4.2.2.2, 9.7

ttRepXactStatus built-in procedure, 3.5.1, 9.7

ttRepXactStatus procedure, 7.3.1, 7.4.2.2.5

ttRepXactTokenGet built-in procedure, 9.7

U

unidirectional replication, 1.5.3

update conflicts, managing, 7.10.6

V

VARBINARY columns, size limit, 8.2.1.2

VARCHAR2 columns, size limit, 8.2.1.2

virtual IP address

Oracle Clusterware, 6.1

W

WINS server, 8.1.3.3