今天去检查dataguard的日志，在备机发现
LOGSTDBY stmt: create table test2 (id varchar(32))
LOGSTDBY status: ORA-00955: name is already used by an existing object
LOGSTDBY id: XID 0x0008.010.00010f1b, hSCN 0x0000.24657242, lSCN 0x0000.24657242, Thread 1, RBA 0x0352.0002b110.1a4, txnCscn 0x0000.24657246, PID 29742, oracle@IZP-HN-HHY-1 (P004)
LOGSTDBY Apply process P004 pid=40 OS id=29742 stopped
Thu Sep 30 05:04:13 2010
Errors in file /oracle/admin/zjzboss/bdump/zjzboss_lsp0_29801.trc:
ORA-12801: error signaled in parallel query server P004
ORA-00955: name is already used by an existing object
LOGSTDBY Analyzer process P003 pid=39 OS id=29740 stopped
LOGSTDBY Apply process P006 pid=42 OS id=29746 stopped
LOGSTDBY Apply process P005 pid=41 OS id=29744 stopped
LOGSTDBY Apply process P007 pid=43 OS id=29748 stopped
LOGSTDBY Apply process P008 pid=44 OS id=29750 stopped
已经停止应用了，有个表已经在备机存在了，应用日志的时候发现有个create语句，所以报错，无法进行
下去了，这个库经常有别的操作，这个test2表是用来测试的，没想到谁在主节点上也建了这个表，所以
出问题了，执行这两条命令解决
drop table test2
alter database start logical standby apply immediate
日志开始重新应用了。。
阅读(1527) | 评论(0) | 转发(0) |
