Restricted Commands and SQL Statements
When you use Oracle Clusterware with TimesTen, the active standby pair
replication scheme is created on the active database with the ttCWAdmin
-create
command and dropped with the ttCWAdmin -drop
command.
ttCWAdmin -create
and ttCWAdmin
-drop
commands, you cannot run certain commands or SQL statements.
However, you can perform these commands or SQL statements when you use the
ttCWAdmin -beginAlterSchema
and the ttCWAdmin
-endAlterSchema
commands, as described in Changing the Schema.
You cannot run the following commands or SQL statements:
-
Creating, altering, or dropping the active standby pair with the
CREATE ACTIVE STANDBY PAIR
,ALTER ACTIVE STANDBY PAIR
, andDROP ACTIVE STANDBY PAIR
SQL statements. -
Starting or stopping the replication agent with either the
-repStart
and-repStop
options of thettAdmin
utility or thettRepStart
orttRepStop
built-in procedures. For more information, see Starting and Stopping the Replication Agents. -
Starting or stopping the cache agent after the active standby pair has been created with either the
-cacheStart
and-cacheStop
options of thettAdmin
utility or thettCacheStart
andttCacheStop
built-in procedures. -
Duplicating the database with the
-duplicate
option of thettRepAdmin
utility.
In addition, do not call ttDaemonAdmin -stop
before calling ttCWAdmin -shutdown
.
The TimesTen integration with Oracle Clusterware accomplishes these operations with the ttCWAdmin
utility and the attributes specified in the cluster.oracle.ini
file.