Active - Standby pair "feature"

When i was preparing to Developer Day i found some Active-Standby pair feature :).

I wrote about using and creating Active - Standby pair replication for ensuring high avalbility.

But, in this time, i will try to execute some DDL.


For example, i have a configuration:

[root@rac1 bin]# ./ttCWAdmin -statusTimesTen Cluster status report as of Mon Nov  1 19:58:49 2010

====================================================================
TimesTen daemon monitors:
Host:RAC1 Status: online
Host:RAC2 Status: online

====================================================================
====================================================================
TimesTen Cluster agents
Host:RAC1 Status: online
Host:RAC2 Status: online

====================================================================

Status of Cluster related to DSN HA_DS:
====================================================================
1. Status of Cluster monitoring components:
Monitor Process for Master Datastore 1 on Host rac1: RUNNING
Monitor Process for Master Datastore 2 on Host rac2: RUNNING
Monitor Process for Active datastore:RUNNING on Host rac1
Monitor Process for Standby datastore:RUNNING on Host rac2

2.Status of  Datastores comprising the cluster
Master Datastore 1:
Host:rac1
Status:AVAILABLE
State:ACTIVE
Master Datastore 2:
Host:rac2
Status:AVAILABLE
State:STANDBY
====================================================================
The cluster containing the replicated DSN is online

I use Active host and connect to ha_ds DSN and create table test.

[oracle@rac1 ~]$ ttisql "DSN=ha_ds;UID=app;PWD=app"

Copyright (c) 1996-2009, Oracle.  All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.

connect "DSN=ha_ds;UID=app;PWD=app";
Connection successful: DSN=ha_ds;UID=app;DataStore=/u01/app/oracle/datastore/ha_ds;DatabaseCharacterSet=AL32UTF8;ConnectionCharacterSet=US7ASCII;DRIVER=/u01/app/oracle/product/11.2.1/TimesTen/tt1/lib/libtten.so;PermSize=40;TempSize=32;TypeMode=0;
(Default setting AutoCommit=1)
Command> tables;
  APP.PLANS
1 table found.
Command> create table test (id number);
Command> tables;
  APP.PLANS
  APP.TEST
2 tables found.
Command>

What do i see on standby host?

[oracle@rac2 info]$ ttisql "DSN=ha_ds;UID=app;PWD=app"
Copyright (c) 1996-2009, Oracle.  All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.

connect "DSN=ha_ds;UID=app;PWD=app";
Connection successful: DSN=ha_ds;UID=app;DataStore=/u01/app/oracle/datastore/ha_ds;DatabaseCharacterSet=AL32UTF8;ConnectionCharacterSet=US7ASCII;DRIVER=/u01/app/oracle/product/11.2.1/TimesTen/tt1/lib/libtten.so;PermSize=40;TempSize=32;TypeMode=0;
(Default setting AutoCommit=1)
Command> tables;
  APP.PLANS
1 table found.

Very strange, don't you? I expected transferring changes from Active to Standby host.
Beside that, you can create objects on Standby host!

Explanation - Active - standby pair replication can replicate only DML. The support DDL replication is planing in a future.

PS. Foto - "Spatrak" - champion :)))