Switchover of Logical Standby database

From: Gerry Miller <gerry_at_millerandbowman.com>
Date: Fri, 16 Dec 2011 15:24:24 +1000
Message-ID: <4EEAD608.5060709_at_millerandbowman.com>



Hi

I have had some experience with physical standby databases and the Data Guard broker but have recently been asked to implement a logical standby on 10.2.0.4 on Windows 2008 Server. I was quite surprised to find that when a switchover or failover is performed that the databases are not shutdown, which results in a faster operation. However, I was perturbed to find that any sessions that were originally on the primary remained on the same database, that is, ended up on the standby database, when I would have expected them to be on the new primary. Queries can still be executed but any attempts at DML result in : "ORA-16224 Database Guard is enabled". This seems an unlikely situation and I can't help but feel that I must have something wrong with the configuration, although I can't imagine that it would work at all if that were the case.

Is this the expected behaviour or should the sessions have transferred during the switchover?

Regards

Gerry

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 15 2011 - 23:24:24 CST

Original text of this message