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

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

Go to previous page
Previous
Go to next page
Next
View PDF

Optional attributes

These attributes are optional and have no default values. The optional attributes are listed in Table 7-3, "Optional attributes" and described in detail in this section.


AppFailoverDelay

This attribute denotes the number of seconds that the process that is monitoring the application waits after a failure is detected before performing a failover. The default is 0.

Setting

Set AppFailoverDelay as follows:

How the attribute is represented Setting
AppFailoverDelay An integer representing the number of seconds that the process that is monitoring the application waits after a failure is detected before performing a failover. The default is 0.


AppFailureThreshold

This attribute denotes the number of consecutive failures that Oracle Clusterware tolerates for the action script for an application. The default is 2.

Setting

Set AppFailureThreshold as follows:

How the attribute is represented Setting
AppFailureThreshold An integer indicating the number of consecutive failures that Oracle Clusterware tolerates for the action script for an application. The default is 2.


AppScriptTimeout

This attribute indicates the number of seconds that the TimesTen application monitor process waits for the start action script and the stop action script to complete for a specific application. The check action script has a nonconfigurable timeout of five seconds and is not affected by this attribute.

Setting

Set AppScriptTimeout as follows:

How the attribute is represented Setting
AppScriptTimeout An integer representing the number of seconds the TimesTen application container waits for start and stop action scripts to complete for a specific application. The default is 60.


AutoRecover

Specifies whether Oracle Clusterware automatically recovers the active data store from the backup in the case of a failure of both masters.

If recovery is not automated (AutoRecover=N), the data store can be recovered using the ttCWAdmin -restore command.

You cannot use AutoRecover if you are using cache groups in your configuration.

Setting

Set AutoRecover as follows:

How the attribute is represented Setting
AutoRecover Y - Oracle Clusterware automatically recovers the active data store from the backup if both masters fail.

N - In the case of the failure of both masters, you must recover manually. This is the default.



ClusterType

The value of this attribute indicates the type of the cluster and the types of replication schemes managed by Oracle Clusterware.

Setting

Set ClusterType as follows:

How the attribute is represented Setting
ClusterType Active - The cluster contains an active standby pair with or without subscribers. This is the default.


DatabaseFailoverDelay

This attributes specifies the number of seconds that Oracle Clusterware waits before migrating a data store to a new host after a failure. This is applicable when advanced availability is configured. The default is 60 seconds.

Setting

Set DatabaseFailoverDelay as follows:

How the attribute is represented Setting
DatabaseFailoverDelay An integer representing the number of seconds that Oracle Clusterware waits before migrating a data store to a new host after a failure. The default is 60.


FailureThreshold

This attribute denotes the number of concurrent failures of resources managed by Oracle Clusterware that are tolerated before the active standby pair is considered failed and a new active standby pair is created on spare hosts using the automated backup. This value is ignored for basic availability (no virtual IP addresses are configured) or when RepBackupPeriod is set to 0 when using advanced availability (includes virtual IP addresses).

Note:

TimesTen tolerates only one failure of a backup resource, regardless of the setting for this attribute.

Setting

Set FailureThreshold as follows:

How the attribute is represented Setting
FailureThreshold An integer representing the number of concurrent failures of resources managed by Oracle Clusterware that are tolerated before the active standby pair is considered failed and a new active standby pair is created on spare hosts using the automated backup. The default is 2.


MasterStoreAttribute

This attribute indicates the desired replication scheme STORE attributes for the master data stores. The STORE attributes apply to both the active and standby data stores. The STORE clause for replication schemes is defined in Oracle TimesTen In-Memory Database SQL Reference.

This attribute is not required when RepDDL is configured.

If this attribute is not set, the STORE attributes take their default values. See "Setting STORE attributes".

Setting

Set MasterStoreAttribute as follows:

How the attribute is represented Setting
MasterStoreAttribute The desired replication scheme STORE attributes for the master data stores. For example: PORT 20000 TIMEOUT 60.


MonInterval

This attribute denotes the number of seconds for the monitoring interval of processes that monitor an active standby pair.

Setting

Set MonInterval as follows:

How the attribute is represented Setting
MonInterval An integer representing the number of seconds for the monitoring interval of processes that monitor an active standby pair. The default is 5.


RepBackupPeriod

This attribute indicates the number of seconds between each backup of the active data store. If this attribute is set to a value greater than 0, you must also specify a backup directory by setting RepBackupDir.

Setting

Set RepBackupPeriod as follows:

How the attribute is represented Setting
RepBackupPeriod An integer indicating the number of seconds between each backup of the active data store. A value of 0 disables the backup process. The default is 0.


RepDDL

This attribute represents the SQL statement that creates the active standby pair.

If RepDDL is set, the following attributes are not required:

Replace the data store file name prefix in the SQL statement with <DSN>. Replace the host names by pseudo host names such as <MASTERHOST[1]>, <MASTERHOST[2]> and <SUBSCRIBERHOST[1]>.

There is no default value for RepDDL. This example sets RepDDL for two master data stores:

RepDDL=create active standby pair <DSN> on <MASTERHOST[1]>, <DSN> on <MASTERHOST[2]>

You do not usually need to set the ROUTE clause in RepDDL because the transmitter of the replication agent automatically obtains the private and public network interfaces that Oracle Clusterware uses. However, if hosts have network connectivity for replication schemes that are not managed by Oracle Clusterware, then RepDDL needs to include the ROUTE clause.

If this attribute is used, each STORE clause must be followed by the pseudo host names such as:

Setting

Set RepDDL as follows:

How the attribute is represented Setting
RepDDL Creates an active standby pair by issuing a CREATE ACTIVE STANDBY PAIR statement. There is no default value.


RepfullbackupCycle

This attribute specifies the number of incremental backups between full backups. The number of incremental backups depends on the capacity of the shared storage.

Setting this attribute can impact performance. There is a trade-off between the storage capacity and the time consumption for backup. An incremental backup can be performed much faster than a full backup. However, storage consumption increases until a full backup is performed.

Setting

Set RepfullbackupCycle as follows:

How the attribute is represented Setting
RepfullbackupCycle An integer value representing the number of incremental backups to perform between full backups. The default is 5.


ReturnServiceAttribute

This attribute specifies the return service for the active standby replication scheme. See "Using a return service".

If no value is specified for this attribute, the active standby pair is configured with no return service.

Setting

Set ReturnServiceAttribute as follows:

How the attribute is represented Setting
ReturnServiceAttribute The type of return service. For example: RETURN RECEIPT. There is no default value.


SubscriberStoreAttribute

This attribute indicates the replication scheme STORE attributes of subscriber data stores. The STORE attributes apply to all subscribers. The STORE clause for replication schemes is defined in Oracle TimesTen In-Memory Database SQL Reference.

This attribute is not required when RepDDL is present.

If this attribute is not set, the STORE attributes take their default values. See "Setting STORE attributes".

Setting

Set SubscriberStoreAttribute as follows:

How the attribute is represented Setting
SubscriberStoreAttribute The list of STORE attributes and their values for the subscriber data stores. For example: PORT 20000 TIMEOUT 60.


TimesTenScriptTimeout

This attribute denotes the number of seconds that Oracle Clusterware waits for the monitor process to start before assuming a failure.

Oracle TimesTen recommends setting a value of several hours because the action script may take a long time to duplicate the active data store. The default is 21600 seconds (6 hours).

Setting

Set TimesTenScriptTimeout as follows:

How the attribute is represented Setting
TimesTenScriptTimeout An integer representing the number of seconds that Oracle Clusterware waits for the monitor process to start before assuming a failure. The default is 21600 seconds (6 hours).