Skip Headers
Oracle® TimesTen In-Memory Database TimesTen to TimesTen Replication Guide
Release 11.2.1

Part Number E13072-06
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

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

A

active 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
adding tables or cache groups, 4.9, 5.9, 5.9
altering, 4.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 data store, 4.4
replicating a global AWT cache group, 5.3
replicating a local read-only cache group, 5.2
restrictions, 3.1
return service, 3.5
return twosafe service, 8.6.4
setting up, 4.3
states, 4.1
SUBSCRIBER clause, 3.4
subscriber failure, 4.6
verify that standby has received updates, 11.3.4
active standby pair with cache groups
altering, 5.9
recover active when standby not ready, 5.4.2
recovering active data store, 5.4
subscriber failure, 5.6
ADD ELEMENT clause
data store, 12.1.2
ADMIN privilege, 3.3, 8.2
aging, 1.9
ALTER ELEMENT clause, 12.1.1
ALTER REPLICATION, use of, 12.1
ALTER TABLE
and replication, 12.2
AppCheckCmd Clusterware attribute, 7.1
AppFailoverDelay Clusterware attribute, 7.1
AppFailureThreshold Clusterware attribute, 7.1
application failover
Oracle Clusterware, 6.2.4
apply threads
active standby pair, 9.2.4
AppName Clusterware attribute, 7.1
AppScriptTimeout Clusterware attribute, 7.1
AppStartCmd Clusterware attribute, 7.1
AppStopCmd Clusterware attribute, 7.1
AppType Clusterware attribute, 7.1
asynchronous writethrough cache group
propagating to Oracle database, 1.6.2
replication, 1.6.1
autocommit, 8.6.2, 8.6.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, 10.2.3
automatic client failover, 6.1
AutoRecover Clusterware attribute, 7.1
AWT cache group
propagating to Oracle Database, 1.6.2
replicating, 1.6.1, 5.3

B

bidirectional general workload
syntax example, 8.9.6
update conflicts, 8.9.6
bidirectional replication, 1.5.3
bidirectional split workload
syntax example, 8.9.5
bookmarks in log, 9.2.3.3, 11.5

C

cache grid
active standby pairs, 5.3
cache group
excluding from data store, 12.1.2.2
including in data store, 12.1.2.1
cache groups
replicating, 1.6
replicating a global AWT cache group, 5.3
replicating a read-only cache group, 5.2
CacheConnect Clusterware attribute, 7.1
catch-up feature, 10.2.3
CHECK CONFLICTS clause
examples, 13.3.2
in CREATE REPLICATION statement, 8.4
client failover, 6.1
cluster
virtual IP addresses, 6.1
cluster agent, 6.3.2
cluster manager
role, 8.1.1
cluster.oracle.ini file, 6.1
advanced availability, 6.2.2
advanced availability, one subscriber, 6.2.2
application failover, 6.2.4, 6.2.4
attribute descriptions, 7
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
examples, 6.2
excluding tables, cache groups and sequences, 6.2.6
location, 6.2
manual recovery from failure of both master nodes, 6.2.5
specify route, 6.2.6
Windows example, 6.2.1, 6.2.4
Clusterware
required privileges, 6.1.2
COMPRESS TRAFFIC clause
in CREATE ACTIVE STANDBY PAIR statement, 3.6.3
in CREATE REPLICATION statement, 8.7.3
configuring replication, 8.1
configuring the network, 9.1
conflict report
XML Document Type Definition, 13.5
conflict reporting, 13.4
CONFLICT REPORTING clause
in CREATE REPLICATION statement, 8.7
conflict resolution, 13.1
update rules, 13.2
conflict types, 13.1
controlling replication, 9.6
copying a data store
privileges, 4.2, 9.2.2
copying a master data store, 9.2.2
CREATE ACTIVE STANDBY PAIR statement, 4.3, 5.2
syntax, 3.3
CREATE REPLICATION statement
defining data store element, 8.3.1
defining table element, 8.3.2
use of, 8.2

D

data store
ForceConnect attribute, 10.2.3
data store element, 8.3.1
data store file name
defined, 3.2, 8.2.2
data store name, 8.2.2
data store objects
excluding from active standby pair, 3.8
data stores
attributes of, 9.2.1.1
duplicating, 9.2.2
establishing, 9.2.1
failed, 3.6.5, 8.7.5
managing logs, 9.2.3
recovering, 8.1.1
setting state, 9.6
data types
size limits, 9.2.1.2
DatabaseFailoverDelay Clusterware attribute, 7.1
DATASTORE element, 8.3
adding to replication scheme, 12.1.2
and materialized views, 8.3.4
and nonmaterialized views, 8.3.4
default column values, 12.2
DISABLE RETURN attribute, 8.7
DISABLE RETURN clause
in CREATE REPLICATION statement, 8.7, 8.7
DISABLE RETURN policy, 8.7.2.2.2, 8.7.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
distributed workload configuration, 1.5.3.2
recovery issues, 8.1.1
DNS server, 9.1.3.2, 9.1.3.3
DROP REPLICATION statement, 2.2.6, 12.4
dropping replication scheme, 2.2.6, 12.4
DSN
creating, 2.2.1, 9.2.1
define for active standby pair, 3.2
defining, 8.2.2
duplicating a data store
privileges, 4.2, 9.2.2
with cache groups, 4.2
duplicating a master data store, 9.2.2
DURABLE COMMIT clause
in CREATE REPLICATION statement, 8.7

E

element
defined, 1.1
ELEMENT descriptions, 8.3
example
replicating tables to different subscribers, 8.9.3
EXCLUDE clause
in CREATE ACTIVE STANDBY PAIR statement, 3.8
EXCLUDE SEQUENCE clause
in ALTER REPLICATION statement, 12.1.2.2
in CREATE REPLICATION statement, 8.3.1
EXCLUDE TABLE clause
in ALTER REPLICATION statement, 12.1.2.2
in CREATE REPLICATION statement, 8.3.1

F

failback, 4.4.3, 5.4.3
failed data store
connecting to, 3.6.5, 8.7.5
Failed state, 8.7.5, 9.6
log threshold, 3.6.5
failover and recovery
issues, 8.1.1
FAILTHRESHOLD attribute, 10.2.1
FAILTHRESHOLD clause
altering, 12.1.12
example, 8.9.2
in CREATE ACTIVE STANDBY PAIR statement, 3.6.2.2.1, 3.6.5
in CREATE REPLICATION statement, 8.7, 8.7.2.2.1, 8.7.5
subscriber failures, 10.2.1
failure recovery script, 10.5
failure threshold
displaying, 11.4.1
example, 8.9.2
subscriber failures, 10.2.1
FailureThreshold Clusterware attribute, 7.1
ForceConnect attribute, 10.2.3, 10.2.3, 10.4
foreign keys, 1.8
replication, 8.3.3
full replication, 1.5.2
full store name
active standby pair, 3.4

G

general workload
syntax example, 8.9.6
GridPort Clusterware attribute, 7.1

H

host name
identifying, 8.3.1, 9.1.3
hostname command, 8.3.1

I

INCLUDE CACHE GROUP clause
in CREATE REPLICATION statement, 8.3.1
INCLUDE clause
in CREATE ACTIVE STANDBY PAIR statement, 3.8
INCLUDE SEQUENCE clause
in ALTER REPLICATION statement, 12.1.2.1
in CREATE REPLICATION statement, 8.3.1
INCLUDE TABLE
in ALTER ACTIVE STANDBY PAIR, 5.9
in CREATE REPLICATION statement, 8.3.1
INCLUDE TABLE clause
in ALTER REPLICATION statement, 4.9, 12.1.2.1
IP addresses, 9.1.3

L

LOCAL COMMIT ACTION clause
in CREATE ACTIVE STANDBY PAIR, 3.6.2.2.5
in CREATE REPLICATION statement, 8.7
log
locating bookmarks, 9.2.3.3, 11.5
management, 9.2.3
size and persistence, 9.2.3.1
threshold value, 8.7.5, 8.7.5, 9.2.3.3
log sequence number, 11.5
log threshold value
active standby pair, 3.6.5
LogBufMB attribute, 9.2.1.1, 9.2.3.3, 9.2.3.3
LogFileSize attribute, 9.2.1.1, 9.2.3.3
logging, 9.2.3.3
Logging attribute, 9.2.1.1
logs
setting the size, 9.2.3.3
LSN, 11.5

M

master catch-up, 10.2.3
master data store
defined, 8.2.2
MasterHosts Clusterware attribute, 7.1
MasterStoreAttribute Clusterware attribute, 7.1
MasterVIP Clusterware attribute, 7.1
materialized views
replicating, 8.3.4
MonInterval Clusterware attribute, 7.1
monitoring replication, 11

N

network requirements, 9.1.3
NO RETURN clause
in CREATE ACTIVE STANDBY PAIR statement, 3.5.5
in CREATE REPLICATION statement, 8.6.5
NVARCHAR columns
size limit, 9.2.1.2

O

ocrConfig option, 6.3.3
ON DELETE CASCADE clause, 1.8
Oracle Cluster Registry
configuring for TimesTen cluster, 6.3.3
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
changing cache administration user name or password, 6.5.14
changing internal user name or password, 6.5.14
creating or dropping tables and cache groups, 6.5.1
failure of more than two master hosts, 6.4.5
host maintenance, 6.5.12
machine room maintenance, 6.5.13
manual recovery for advanced availability, 6.4.4.2
manual recovery for basic availability, 6.4.4.3
moving a data store to another host, 6.5.11
network maintenance, 6.5.12
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
stopping the TimesTen daemon, 6.3.4
storage for backups, 6.2.5
switching the active and the standby, 6.5.10
TimesTen advanced level, 6.1
TimesTen basic level, 6.1
ttDaemonAdmin, 6.3.4
upgrading TimesTen, 6.5.3
virtual IP addresses, 6.1
Oracle Clusterware attributes
AppCheckCmd, 7.1
AppFailoverDelay, 7.1
AppFailureThreshold, 7.1
AppName, 7.1
AppScriptTimeout, 7.1
AppStartCmd, 7.1
AppStopCmd, 7.1
AppType, 7.1
AutoRecover, 7.1
CacheConnect, 7.1
conditional, 7.1
DatabaseFailoverDelay, 7.1
FailureThreshold, 7.1
GridPort, 7.1
MasterHosts, 7.1
MasterStoreAttribute, 7.1
MasterVIP, 7.1
MonInterval, 7.1
optional, 7.1, 7.1
RemoteSubscriberHosts, 7.1
RepBackupDir, 7.1
RepBackupPeriod, 7.1
RepDDL, 6.2.6, 7.1
RepfullbackupCycle, 7.1
required, 7.1, 7.1
ReturnServiceAttribute, 7.1
ScriptInstallDir, 7.1
SubscriberHosts, 7.1
SubscriberStoreAttribute, 7.1
SubscriberVIP, 7.1
TimesTenScriptTimeout, 7.1
VIPInterface, 7.1
VIPNetMask, 7.1
owner name, 8.2.1

P

parallel replication, 9.2.5, 9.2.5
partitions
in a table, 8.7.6
Pause state, 9.6
performance
logging attributes, 9.2.3.3
replication, 11.8
PORT assignment
active standby pair, 3.6.4
PORT attribute
in CREATE REPLICATION statement, 8.7, 8.7.4
ports
dynamic, 8.7.4
static, 8.7.4
privilege
create a replication scheme, 8.2
create an active standby pair, 3.3
propagation, 1.5.4
examples, 8.9.4
PROPAGATOR clause
examples, 8.9.4
propagator data store, 1.5.4
defined, 8.2.2

R

read-only cache group
replicating, 1.6.3
ReceiverThreads attribute, 9.2.4
recovering failed data stores, 8.1.1
RemoteSubscriberHosts Clusterware attribute, 7.1
RepBackupDir Clusterware attribute, 7.1
RepBackupPeriod Clusterware attribute, 7.1
RepDDL Clusterware attribute, 6.2.6, 7.1
RepfullbackupCycle Clusterware attribute, 7.1
replicated tables
requirements, 9.2.1.2
replicating over a network, 1.5.4, 9.1
replication
across releases, 9.3
and ttAdmin, 9.5
bidirectional, 1.5.3
configuration issues, 8.1
configuring timestamp comparison, 13.3
conflict reporting, 13.4
conflict resolution, 13.1
controlling, 9.6
described, 1.1
element, 1.1, 8.3
FAILTHRESHOLD clause in CREATE ACTIVE STANDBY PAIR statement, 3.6.2.2.1
FAILTHRESHOLD clause in CREATE REPLICATION statement, 8.7.2.2.1
foreign keys, 8.3.3
gauging performance, 11.5
monitoring, 11
multiple threads, 9.2.5
of materialized views, 8.3.4
parallel, 9.2.5, 9.2.5
restart policy, 9.5.1, 9.5.1, 9.5.2
return receipt, 1.4.2
starting, 9.5
state, 9.6
stopping, 9.5
timestamp column maintenance, 13.3.2.1
unidirectional, 1.5.3
replication agent
defined, 1.3
starting, 2.2.4, 9.5
stopping, 2.2.4, 9.5
replication daemon, see "replication agent"
replication scheme
active standby pair, 1.5.1
applying to DSNs, 9.4
configuring, 8.1
defining, 8.2
dropping, 2.2.6
examples of, 8.9
for cache groups, 1.6
naming, 8.2.1
replication schemes
types, 1.5
replication tracks, 9.2.5
ReplicationApplyOrdering data store attribute, 9.2.5
ReplicationParallelism data store attribute, 9.2.5
ReplicationTrack connection attribute, 9.2.5
repschemes
ttIsql command, 11.4.1
resource
defined, 6.1
restart policy, 9.5.1
RESUME RETURN clause
in CREATE REPLICATION statement, 8.7
RESUME RETURN policy, 3.6.2.2.3, 8.7.2.2.3
return receipt
definition, 1.4
RETURN RECEIPT BY REQUEST clause
example, 8.9.2
in CREATE ACTIVE STANDBY PAIR statement, 3.5.2
in CREATE REPLICATION statement, 8.6.2
RETURN RECEIPT clause
active standby pair, 3.5.1
example, 8.9.1, 8.9.2
in CREATE REPLICATION statement, 8.6.1
RETURN RECEIPT failure policy
report settings, 11.4.1
return receipt replication, 1.4.2
RETURN RECEIPTclause
example, 8.9.2
RETURN RECEPT timeout errors, 1.4.2, 8.7
return service
active standby pair, 3.5
performance and recovery tradeoffs, 8.1.2
return service blocking
disabling, 3.6.2.2, 8.7.2.2
return service failure policy, 8.7.2
active standby pair, 3.6.2
return service timeout errors, 3.6.2, 8.7.2
RETURN SERVICES WHEN REPLICATION STOPPED clause
in CREATE REPLICATION statement, 8.7
return twosafe
active standby pair, 8.6.4
definition, 1.4
RETURN TWOSAFE BY REQUEST clause
in CREATE ACTIVE STANDBY PAIR statement, 3.5.4
in CREATE REPLICATION statement, 8.6.3
RETURN TWOSAFE clause
in CREATE ACTIVE STANDBY PAIR statement, 3.5.3
in CREATE REPLICATION statement, 8.6.4
RETURN WAIT TIME clause
in CREATE REPLICATION statement, 8.7
ReturnServiceAttribute Clusterware attribute, 7.1
ROUTE clause
in CREATE ACTIVE STANDBY PAIR statement, 3.7

S

ScriptInstallDir Clusterware attribute, 7.1
selective replication, 1.5.2
sequences
replicating, 1.7
split workload, 1.5.3.1
syntax example, 8.9.5
SQLGetInfo function, 3.6.5, 8.7.5, 10.2.1
standby data store
recover from failure, 4.5, 5.5
verify that updates have been received, 11.3.4
Start state, 9.6
starting the replication agent, 2.2.4, 9.5, 9.5
Stop state, 9.6
stopping the replication agent, 2.2.6, 9.5, 9.5
STORE attributes
in CREATE ACTIVE STANDBY PAIR statement, 3.6
in CREATE REPLICATION statement, 8.7
subscriber
verifying updates from master, 11.3.4
SUBSCRIBER clause
in CREATE ACTIVE STANDBY PAIR statement, 3.4
in CREATE REPLICATION statement, 8.6
subscriber data store
defined, 8.2.2
subscriber failure, 4.6, 5.6
SubscriberHosts Clusterware attribute, 7.1
subscribers
number allowed, 8.9.2
SubscriberStoreAttribute Clusterware attribute, 7.1
SubscriberVIP Clusterware attribute, 7.1

T

table
dropping from replication scheme, 12.1.3
excluding from data store, 12.1.2.2
including in data store, 12.1.2.1
partitioned, 8.7.6
TABLE DEFINITION CHECKING clause
examples, 8.7.6
in CREATE REPLICATION statement, 8.7
TABLE element, 8.3
table element, 8.3.2
table requirements, 9.2.1.2
tables
altering and replication, 12.2
threshold log setting, 8.7.5, 8.7.5, 9.2.3.3
active standby pair, 3.6.5, 3.6.5
throughput
active standby pair, 9.2.4
timeout
return service for an active standby pair, 3.6.1
TIMEOUT clause
in CREATE REPLICATION statement, 8.7
timestamp
from operating system, 13.2
timestamp column maintenance
by user, 13.3.2.2
system, 13.3.2.1
timestamp comparison
configuring, 13.3
local transactions, 13.2.1
TimesTen cluster agent, 6.3.2
TimesTenScriptTimeout Clusterware attribute, 7.1
track
parallel replication, 9.2.5.1
tracks
replication, 9.2.5
TRANSMIT DURABLE clause
in CREATE REPLICATION statement, 8.5
TRANSMIT NONDURABLE clause
and recovery, 10.4
in CREATE REPLICATION statement, 8.5
TRUNCATE TABLE statement, 12.3
truncating a replicated table, 12.3
ttAdmin utility
-ramPolicy option, 10.3.1, 10.3.2
-repPolicy option, 9.5.1
-repStart option, 9.5.1, 9.5.1
-repStop option, 9.5.1
ttCkpt built-in procedure, 9.2.3.2
ttCkptBlocking built-in procedure, 9.2.3.2
ttcrsagent.options file, 6.3.2
ttCWAdmin utility, 6.1, 6.2.1
ocrConfig option, 6.3.3
-relocate option, 6.5.11
required privileges, 6.1.2
-switch option, 6.5.10
ttDestroy utility, 10.3.1
ttDestroyDataStore built-in procedure, 10.3.2
ttDurableCommit built-in procedure, 3.6.2.1, 8.7.2.1
ttIsql utility
-f option, 9.4
ttRepAdmin -duplicate
privileges, 9.2.2
ttRepAdmin utility
-bookmark option, 11.5.1
-duplicate option, 8.5, 9.2.2, 10.2.3, 10.3.1, 10.3.1, 10.4
privileges for -duplicate options, 4.2
-ramLoad option, 10.3.1, 10.3.1
-receiver -list options, 11.3.1
-self -list options, 11.2.1
-showconfig option, 11.4.2
-state option, 9.6
ttRepDuplicate built-in procedure, 10.3.2
ttRepDuplicateEx C function
privileges, 4.2, 9.2.2
ttReplicationStatus built-in procedure, 11.3.2
ttRepReturnTransitionTrap SNMP trap, 8.7.2.2.2
ttRepStart built-in procedure, 9.5.1, 9.5.2, 12.1
ttRepStop built-in procedure, 9.5.1, 9.5.2, 12.1
ttRepSubscriberStateSet built-in procedure, 9.6
ttRepSubscriberSync built-in procedure, 11.3.4
ttRepSubscriberWait built-in procedure, 8.3.5
ttRepSyncGet built-in procedure, 3.5.2, 3.5.4, 8.6.2, 8.6.3
ttRepSyncSet built-in procedure, 3.5.2, 3.5.4, 3.6, 3.6, 3.6.1, 3.6.2, 3.6.2.2.5, 8.6.2, 8.6.3, 8.6.3, 8.7, 8.7, 8.7.1, 8.7.1, 8.7.2, 8.7.2.2.5, 8.9.2
ttRepSyncSubscriberStatus built-in procedure, 8.7.2.2.2, 11.7
ttRepXactStatus built-in procedure, 3.5.1, 8.6.1, 8.7.2.2.5, 11.7
ttRepXactTokenGet built-in procedure, 11.7

U

unidirectional replication, 1.5.3
update conflicts
managing, 8.9.6
syntax example, 8.9.6

V

VARBINARY columns
size limit, 9.2.1.2
VARCHAR2 columns
size limit, 9.2.1.2
VIPInterface Clusterware attribute, 7.1
VIPNetMask Clusterware attribute, 7.1
virtual IP address
Oracle Clusterware, 6.1

W

WINS server, 9.1.3.2, 9.1.3.3