玉面飞龙的BLOG

Logical Standby

July 1st, 2007 | Categories: Boring | Tags:

10g从Physcial Standby转换到Logical Standby只需要一句话就可以了，配置比Oracle9i R2逻辑STANDBY配置果然简化很多。

Oracle10g Logical Standby也支持更多表类型的复制。支持LONG, LONG RAW数据类型；支持Tables used to support functional indexes，Tables used to support materialized views；但仍然不支持带有compress选项的表，而且可能还会触发ora-600。

配置logical standby的时候，有个奇怪的现象。默认情况下，当oracle不再需要某个从Primary DB传过来的Archive logs的时候，会自动删除。不观察alert.log，还会以为redo logfile没有被同步。

Thu Jun 28 02:30:35 2007
LOGMINER: Turning ON Log Auto Delete
Thu Jun 28 02:30:51 2007
LOGMINER: Log Auto Delete - deleting: /export/home/oracle_old/BINZHANG/archiveSTBY/binzhang_24_1_626316004.dbf
Deleted file /export/home/oracle_old/BINZHANG/archiveSTBY/binzhang_24_1_626316004.dbf
Thu Jun 28 02:30:51 2007
LOGMINER: Log Auto Delete - deleting: /export/home/oracle_old/BINZHANG/archiveSTBY/binzhang_25_1_626316004.dbf
Deleted file /export/home/oracle_old/BINZHANG/archiveSTBY/binzhang_25_1_626316004.dbf
Thu Jun 28 02:30:51 2007
LOGMINER: Log Auto Delete - deleting: /export/home/oracle_old/BINZHANG/archiveSTBY/binzhang_26_1_626316004.dbf
Deleted file /export/home/oracle_old/BINZHANG/archiveSTBY/binzhang_26_1_626316004.dbf

总体感觉logical standby在10g也不是很成熟，bug多多。当我在Primary DB对一个compressed table作DML操作后，按理说，logical standby能够自动skip相关DML，但却导致ora-600[krvtadc],Apply process全部自动停止。

Sat Jun 30 21:07:58 2007
krvtadc: invalid length -11449
Sat Jun 30 21:07:58 2007
Errors in file /export/home/oracle/admin/BINZHANG/bdump/binzhang_p002_4704.trc:
ORA-00600: internal error code, arguments: [krvtadc], [], [], [], [], [], [], []
Sat Jun 30 21:07:59 2007
krvxerpt: Errors detected in process 22, role preparer.
Sat Jun 30 21:07:59 2007
krvxmrs: Leaving by exception: 600
Sat Jun 30 21:07:59 2007
Errors in file /export/home/oracle/admin/BINZHANG/bdump/binzhang_p002_4704.trc:
ORA-00600: internal error code, arguments: [krvtadc], [], [], [], [], [], [], []
LOGSTDBY status: ORA-00600: internal error code, arguments: [krvtadc], [], [], [], [], [], [], []
Sat Jun 30 21:07:59 2007
Errors in file /export/home/oracle/admin/BINZHANG/bdump/binzhang_lsp0_4698.trc:
ORA-12801: error signaled in parallel query server P002
ORA-00600: internal error code, arguments: [krvtadc], [], [], [], [], [], [], []
LOGSTDBY Apply process P007 pid=27 OS id=4714 stopped
LOGSTDBY Apply process P006 pid=26 OS id=4712 stopped
LOGSTDBY Apply process P005 pid=25 OS id=4710 stopped
LOGSTDBY Apply process P004 pid=24 OS id=4708 stopped
LOGSTDBY Analyzer process P003 pid=23 OS id=4706 stopped
LOGSTDBY Apply process P008 pid=28 OS id=4716 stopped