一、物理DG与逻辑DG的区别
官方文档是这样说明的
The main difference between physical and logical standby databases is the manner
in which log apply services apply the archived redo logs:
For physical standby databases, Data Guard uses redo apply technology, which
applies redo data on the standby database using standard recovery techniques
of the Oracle database server.
For logical standby databases, Data Guard uses SQL apply technology, which
first transforms the received redo data into SQL statements and then executes
the generated SQL statements on the logical standby database.
实现机制不同,一个是基于block的,一个是基于SQL statement.
物理dg是通过传日志的形式block对block的完全把主库复制,复制出来的从库和主库完全一样
10g的物理dg只能只读打开,但11g可以读写打开
从库名必须和主库名相同
逻辑dg是通过传日志,再应用logmin的技术将日志中的sql挖出,处理,并重新执行
主库和从库可以不完全相同
逻辑dg从库可以读写打开
逻辑dg有些表和数据是不能同
官方文档是这样说明的
The main difference between physical and logical standby databases is the manner
in which log apply services apply the archived redo logs:
For physical standby databases, Data Guard uses redo apply technology, which
applies redo data on the standby database using standard recovery techniques
of the Oracle database server.
For logical standby databases, Data Guard uses SQL apply technology, which
first transforms the received redo data into SQL statements and then executes
the generated SQL statements on the logical standby database.
实现机制不同,一个是基于block的,一个是基于SQL statement.
物理dg是通过传日志的形式block对block的完全把主库复制,复制出来的从库和主库完全一样
10g的物理dg只能只读打开,但11g可以读写打开
从库名必须和主库名相同
逻辑dg是通过传日志,再应用logmin的技术将日志中的sql挖出,处理,并重新执行
主库和从库可以不完全相同
逻辑dg从库可以读写打开
逻辑dg有些表和数据是不能同