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