LOGSTDBY status: ORA-01418,Logical standby問題可真多
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
