January 31, 2008

Physical standby vs logical standby

In a 3-tie application scenario:

  • If primary db dies, developers can just re-config java connection pool to point to standby db without DBA to manually open the db. For physical standby, you have to manually open it read only
  • If primary db wont come back and you want to do a failvoer, you have to restart it if the physical standby database has been opened in read-only mode since the last time it was started. Since the physical db has been oepned read-only in precedding step, you must have to restart it. That means downtime of the whole site.
  • If primary do come back , but you do not trust it anymore. You can do a switchover. That will certainly have to re-start physical standby.

- No comments Not publicly viewable

Add a comment

You are not allowed to comment on this entry as it has restricted commenting permissions.

Search this blog

Search Warwick Blogs



Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
Not signed in
Sign in

Powered by BlogBuilder