Optional attributes

These attributes are optional and have no default values. The optional attributes are listed inTable 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:

---

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:

---

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:

---

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:

---

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:

---

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:

---

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).

Setting

Set FailureThreshold as follows:

---

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:

---

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:

---

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:

---

RepDDL

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

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

• ReturnServiceAttribute

• MasterStoreAttribute

• SubscriberStoreAttribute

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:

• ActiveHost

• ActiveVIP

• StandbyHost

• StandbyVIP

• SubscriberHost

• SubscriberVIP

Setting

Set RepDDL as follows:

---

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:

---

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:

---

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:

---

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: