LOGSTDBY status: ORA-01418,Logical standby問題可真多

       今天检查数据库状态的时候, 发现logical standby 停止apply SQL 了. 查看日志, 发现如下错误:

LOGSTDBY status: ORA-01418: specified index does not exist

LOGSTDBY Apply process P004 pid=30 OS id=1272 stopped

Tue Jul 15 09:58:44 2008

Errors in file d:"mes"dump"bdump"mess_lsp0_2616.trc:

ORA-12801: error signaled in parallel query server P004

ORA-01418: specified index does not exist

LOGSTDBY Analyzer process P003 pid=29 OS id=2744 stopped

LOGSTDBY Apply process P007 pid=33 OS id=2668 stopped

LOGSTDBY Apply process P008 pid=35 OS id=2456 stopped

LOGSTDBY Apply process P005 pid=31 OS id=2212 stopped

LOGSTDBY Apply process P006 pid=32 OS id=2396 stopped

Tue Jul 15 09:58:48 2008

LOGSTDBY status: ORA-16222: automatic Logical Standby retry of last action

LOGSTDBY status: ORA-16111: log mining and apply setting up

SQL>select EVENT,STATUS from DBA_LOGSTDBY_EVENTS;

ALTER INDEX MES.SYS_C0034908 REBUILD TABLESPACE NEWMES_I ORA-01418: specified index does not exist

查看standby,没有名为MES.SYS_C0034908,有一个MES.SYS_C0033908的index,其和主库的MES.SYS_C0034908是相同的,修改备库index MES.SYS_C0033908的名字为MES.SYS_C0034908,再次Alter database start logical standby apply;发现日志不断Apply.

估计是原表没有主键 ,Oracle 自动建立了一个主建 , 但主库和备库在建立时用了不同的 Index 名字 , 而不知何原因 alter 这个 index 时 , 在备库找不到 , 造成无法 apply, 这应该是 oracle 的一个 BUG 吧 .
參考:
Logical Standby 相关视图

DBA_LOGSTDBY_EVENTS (Logical Standby Databases Only)
DBA_LOGSTDBY_LOG (Logical Standby Databases Only)
DBA_LOGSTDBY_NOT_UNIQUE (Logical Standby Databases Only)
DBA_LOGSTDBY_PARAMETERS (Logical Standby Databases Only)
DBA_LOGSTDBY_PROGRESS (Logical Standby Databases Only)
DBA_LOGSTDBY_SKIP (Logical Standby Databases Only)
DBA_LOGSTDBY_SKIP_TRANSACTION (Logical Standby Databases Only)
DBA_LOGSTDBY_UNSUPPORTED (Logical Standby Databases Only)
V$ARCHIVE_DEST
V$ARCHIVE_DEST_STATUS
V$ARCHIVE_GAP
V$ARCHIVED_LOG
V$DATABASE
V$DATAFILE
V$DATAGUARD_STATUS
V$LOG
V$LOGFILE
V$LOG_HISTORY
V$LOGSTDBY (Logical Standby Databases Only)
V$LOGSTDBY_STATS (Logical Standby Databases Only)
V$MANAGED_STANDBY (Physical Standby Databases Only)
V$STANDBY_LOG

转载于:https://www.cnblogs.com/kevinsun/archive/2008/07/15/1243171.html