Does anyone have any reference to some of the terms used by the different
RDBMS vendors for the different HA/DR technology ?
For eg: I think Mirroring on SQL is Data Guard on Oracle and HADR on DB2A quick readup on IBM's HADR at http://www.dbazine.com/db2/db2-disarticles/zikopoulos19 show that it
is basically the same thing as database mirroring. They seem to have three modes (asynchronous,
near-synchronous, and synchronous) compared to SQL Server's two modes. But the technology behind
this are both based on re-playing log records on a standby server.
It seems like Oracle's Data Guard also is similar in implementation to Database Mirroring but with
two options. You either run it same thing as database mirroring. Or, you can have it implemented
pretty much the same way as Transaction Replication (re-generating SQL statements from the log
instead of sending the physical log records), allowing fro different physical database schema on
standby server. http://www.oracle.com/technology/deploy/availability/htdocs/DataGuardOverview.html
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Hassan" <hassan@.hotmail.com> wrote in message news:%23DUxW%239RHHA.4028@.TK2MSFTNGP03.phx.gbl...
> Does anyone have any reference to some of the terms used by the different RDBMS vendors for the
> different HA/DR technology ?
> For eg: I think Mirroring on SQL is Data Guard on Oracle and HADR on DB2
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment