10.2.0.4逻辑备份数据无法同步

caolilin_24

环境：
[root@tmg211 ~]# uname -a
Linux tmg211 2.6.9-78.ELlargesmp #1 SMP Wed Jul 9 16:03:59 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux
DB：10.2.0.4  逻辑DG
问题：逻辑DG无法应用日志，但是查看主库的日志正常发送到逻辑备库的相应目录下，但是备库相应的LOGSTDBY Apply process无法启动，执行启动应用日志以后，自己就关闭了。日志信息如下：
[oracle@tmg211 ~]$ tailbdump
Tue Aug  6 14:00:58 2013
RFS LogMiner: Client enabled and ready for notification
Tue Aug  6 14:00:58 2013
Primary database is in MAXIMUM PERFORMANCE mode
RFS[46]: Successfully opened standby log 8: '/home/oracle/standby_logfiles/mspdb/standby_redo02.log'
Tue Aug  6 14:01:01 2013
RFS LogMiner: Registered logfile [/home/oracle/archivelog/mspdb/702819540_138013_1.log] to LogMiner session id [1]
Tue Aug  6 14:20:02 2013
RFS LogMiner: Client enabled and ready for notification
Tue Aug  6 14:20:03 2013
Primary database is in MAXIMUM PERFORMANCE mode
RFS[46]: Successfully opened standby log 7: '/home/oracle/standby_logfiles/mspdb/standby_redo01.log'
Tue Aug  6 14:20:05 2013
RFS LogMiner: Registered logfile [/home/oracle/archivelog/mspdb/702819540_138014_1.log] to LogMiner session id [1]
Tue Aug  6 14:29:13 2013
alter database start logical standby apply immediate
Tue Aug  6 14:29:14 2013
ALTER DATABASE START LOGICAL STANDBY APPLY (mspdb)
Tue Aug  6 14:29:14 2013
with optional part
IMMEDIATE
Attempt to start background Logical Standby process
LOGSTDBY Parameter:                        MAX_SGA = 350
LOGSTDBY Parameter:            DISABLE_APPLY_DELAY =  
LOGSTDBY Parameter:                      REAL_TIME =  
LSP0 started with pid=76, OS id=20063
Tue Aug  6 14:29:14 2013
Completed: alter database start logical standby apply immediate
Tue Aug  6 14:29:14 2013
LOGSTDBY status: ORA-16111: log mining and apply setting up
Tue Aug  6 14:29:14 2013
LOGMINER: Parameters summary for session# = 1
LOGMINER: Number of processes = 3, Transaction Chunk Size = 201
LOGMINER: Memory Size = 350M, Checkpoint interval = 1750M
LOGMINER: session# = 1, reader process P000 started with pid=215 OS id=20493
LOGMINER: session# = 1, preparer process P002 started with pid=218 OS id=20501
LOGMINER: session# = 1, builder process P001 started with pid=217 OS id=20497
Tue Aug  6 14:29:22 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 137554, /home/oracle/archivelog/mspdb/702819540_137554_1.log
Tue Aug  6 14:29:22 2013
LOGMINER: Turning ON Log Auto Delete
LOGSTDBY Analyzer process P003 started with pid=53 OS id=20513
LOGSTDBY Apply process P008 started with pid=132 OS id=20529
LOGSTDBY Apply process P005 started with pid=21 OS id=20519
LOGSTDBY Apply process P004 started with pid=66 OS id=20517
LOGSTDBY Apply process P007 started with pid=119 OS id=20527
LOGSTDBY Apply process P006 started with pid=107 OS id=20523
Tue Aug  6 14:29:29 2013
LOGMINER: End mining logfile: /home/oracle/archivelog/mspdb/702819540_137554_1.log
Tue Aug  6 14:29:29 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 137555, /home/oracle/archivelog/mspdb/702819540_137555_1.log
Tue Aug  6 14:29:40 2013
LOGMINER: End mining logfile: /home/oracle/archivelog/mspdb/702819540_137555_1.log
Tue Aug  6 14:29:40 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 137556, /home/oracle/archivelog/mspdb/702819540_137556_1.log
Tue Aug  6 14:29:41 2013
LOGSTDBY status: ORA-00942: table or view does not exist
LOGSTDBY Apply process P004 pid=66 OS id=20517 stopped
Tue Aug  6 14:29:42 2013
Errors in file /home/oracle/admin/mspdb/bdump/mspdb_lsp0_20063.trc:
ORA-12801: error signaled in parallel query server P004
ORA-00942: table or view does not exist
LOGSTDBY Analyzer process P003 pid=53 OS id=20513 stopped
LOGSTDBY Apply process P006 pid=107 OS id=20523 stopped
LOGSTDBY Apply process P005 pid=21 OS id=20519 stopped
LOGSTDBY Apply process P007 pid=119 OS id=20527 stopped
LOGSTDBY Apply process P008 pid=132 OS id=20529 stopped
Tue Aug  6 14:29:42 2013
LOGSTDBY status: ORA-16222: automatic Logical Standby retry of last action
LOGSTDBY status: ORA-16111: log mining and apply setting up
Tue Aug  6 14:29:42 2013
LOGMINER: Parameters summary for session# = 1
LOGMINER: Number of processes = 3, Transaction Chunk Size = 201
LOGMINER: Memory Size = 350M, Checkpoint interval = 1750M
LOGMINER: session# = 1, reader process P000 started with pid=215 OS id=20493
LOGMINER: session# = 1, preparer process P002 started with pid=218 OS id=20501
LOGMINER: session# = 1, builder process P001 started with pid=217 OS id=20497
LOGSTDBY Analyzer process P003 started with pid=53 OS id=20513
Tue Aug  6 14:29:46 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 137554, /home/oracle/archivelog/mspdb/702819540_137554_1.log
Tue Aug  6 14:29:46 2013
LOGMINER: Turning ON Log Auto Delete
LOGSTDBY Apply process P004 started with pid=66 OS id=20517
LOGSTDBY Apply process P007 started with pid=119 OS id=20527
LOGSTDBY Apply process P008 started with pid=132 OS id=20529
LOGSTDBY Apply process P006 started with pid=107 OS id=20523
LOGSTDBY Apply process P005 started with pid=21 OS id=20519
Tue Aug  6 14:29:53 2013
LOGMINER: End mining logfile: /home/oracle/archivelog/mspdb/702819540_137554_1.log
Tue Aug  6 14:29:53 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 137555, /home/oracle/archivelog/mspdb/702819540_137555_1.log
Tue Aug  6 14:30:04 2013
LOGMINER: End mining logfile: /home/oracle/archivelog/mspdb/702819540_137555_1.log
Tue Aug  6 14:30:04 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 137556, /home/oracle/archivelog/mspdb/702819540_137556_1.log
Tue Aug  6 14:30:05 2013
LOGSTDBY status: ORA-00942: table or view does not exist
LOGSTDBY Apply process P004 pid=66 OS id=20517 stopped
Tue Aug  6 14:30:06 2013
Errors in file /home/oracle/admin/mspdb/bdump/mspdb_lsp0_20063.trc:
ORA-12801: error signaled in parallel query server P004
ORA-00942: table or view does not exist
LOGSTDBY Analyzer process P003 pid=53 OS id=20513 stopped
LOGSTDBY Apply process P005 pid=21 OS id=20519 stopped
LOGSTDBY Apply process P006 pid=107 OS id=20523 stopped
LOGSTDBY Apply process P007 pid=119 OS id=20527 stopped
LOGSTDBY Apply process P008 pid=132 OS id=20529 stopped

备库查询状态都没有信息：
sys@LGMSPDB2> select sid,type,status_code,status from v$logstdby_process;

no rows selected
select * from v$Logstdby_progress;
          APPLIED_SCN APPLIED_TIME                RESTART_SCN RESTART_TIME                           LATEST_SCN LATEST_TIME         MINING_SCN MINING_TIME
----------------------- ------------------- ------------------- ------------------- ----------------------------- ------------------- ---------- -------------------
           234559855876                            234559688395 2013-08-01 15:46:41                  236061549250 2013-08-06 14:49:08
可以看到从8月1号15点46分就没有再应用日志，但所以日志已经传到备库。
求大家帮分析，急…

renjixinchina

LOGSTDBY status: ORA-00942: table or view does not exist
LOGSTDBY Apply process P004 pid=66 OS id=20517 stopped

caolilin_24

renjixinchina 发表于 2013-8-6 14:55
LOGSTDBY status: ORA-00942: table or view does not exist
LOGSTDBY Apply process P004 pid=66 OS id=20 ...

询问开发和应用，都表示不清楚。有什么方法可以查到这个不存在的table的table_name或其他信息么？

renjixinchina

select xidusn, xidslt, xidsqn, status, status_code from dba_logstdby_events where event_time = (select max(event_time) from dba_logstdby_events);