一个逻辑standby的库，当在主库上创建索引的时候，standby的库就会报一个LOGSTDBY status: ORA-16227: DDL skipped due to missing object错误出来，按照错误的提示，仔细核对了主库和standby库上的表，发现这个表明明存在的，怎么会报missing object的错误呢？？看看dba_logstdby_skip视图，也没有过滤掉这个建索引的语句啊，它怎么就会莫名奇妙的被skip了呢？google了半天，没有结果，看来还是metalink吧，结果找到了答案，一个bug，前几天整天看见大家叫，说10Gbug满天飞，唉，我也碰上了一大堆，不过还好，没有碰上很棘手的！下面来看看metalink上是怎么说的吧。[@more@]

上面说如果在主库上使用online关键字来创建索引，就会导致逻辑standby上导致这个bug发生，晕，生产库要创建索引，才有几个是不需要online的啊？oracle这个bug也有点搞了。

Bug 3023540 "Create index ... online" does not create index on logical standby

Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions < 11
Versions confirmed as being affected
10.2.0.2
10.2.0.3

Platforms affected Generic (all / most platforms affected)

Fixed:
This issue is fixed in 10.2.0.4 (Server Patch Set)
11.1.0.6 (Base Release)

Description
Create Index Online statements may be skipped by a Logical Standby.

An error appears in the DBA_LOGSTDBY_EVENTS table:

ORA-16227: DDL skipped due to missing object

Workaround:
Execute the Create Index statement without the ONLINE clause on the
primary, or execute the Create Index Online statement directly on the
Logical Standby.

ITPub博客

LOGSTDBY status: ORA-16227: DDL skipped due to missing object

最新文章