Hi guys,
I encountered a strange behavior when I dropped a table partition in a table that contains data in active data guard configuration
my environment is
Database instance A is the primary database and Database instance B is the physical standby database with active data guard ( Maximum performance configuration.) version 11.2.0.3 64 bit on red hat enterprise 6
there is a partitioned table called test with 2 table partitions (p1 and p2) and every table partition contains 1 record
Before I drop the table partition, I execute "select count(1) from test" and it returned 2;
After I issued "alter table test drop partition p1;" on the primary database, I execute "select count(1) from test and it returned 1;
I executed alter system switch logfile serveral" times so that redo logs are archived and transported to the physical standby database;
I have verified archived log has arrived on the physical standby database and been applied
When I execute "select count(1) from test" on the standby database, it returned 2;
I tried to issue "alter system flush buffer_cache;" to flush out the buffer cache, I still get the same result 2.
do you know what I need to do on the physical standby database with active data guard such that when I execute "select count(1) from test", I will get the result 1 (same result as primary server)
thank you