ttCacheADGStandbyStateGet

Returns the state for the standby Oracle database that was specified with the ttCacheADGStandbyStateSet built-in procedure.

Required Privilege

This procedure requires no privileges.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic but not supported in TimesTen Scaleout.

Related Views

This procedure has no related views.

Syntax

ttCacheADGStandbyStateGet()

Parameters

ttCacheADGStandbyStateGet has no parameters.

Result Set

ttCacheADGStandbyStateGet returns the state of the standby Oracle database.

Column Type Description

Column	Type	Description
`ADGStandbyState`	`TT_VARCHAR(20)`	`OK`: The standby Oracle database in an Active Data Guard configuration is considered to be up. `FAILED`: The standby Oracle database in the Active Data Guard configuration has failed. The cache agent does not try to contact the standby Oracle database and continues the autorefresh with only the primary Oracle database.

ADGStandbyState

TT_VARCHAR(20)

OK: The standby Oracle database in an Active Data Guard configuration is considered to be up.

FAILED: The standby Oracle database in the Active Data Guard configuration has failed. The cache agent does not try to contact the standby Oracle database and continues the autorefresh with only the primary Oracle database.

Examples

The following example shows how to call the ttCacheADGStandbyStateSet built-in procedure to set the state of the standby Oracle database in an Active Data Guard environment first to OK and then to FAILED. The ttCacheADGStandbyStateGet built-in procedure retrieves the value of the current state of the standby Oracle database.

Command> call ttCacheADGStandbyStateSet('OK');
Command> call ttCacheADGStandbyStateGet();
< OK >
1 row found.
 
Command> call ttCacheADGStandbyStateSet('FAILED');
Command> call ttCacheADGStandbyStateGet();
< FAILED >
1 row found.