OGG-01476

ERROR   OGG-01476  The previous run abended due to an out of order transaction. Issue ALTER ETROLLOVER
to advance the output trail sequence past the current trail sequence number, then restart. Then, use ALTER EXTSEQNO on the s
ubsequent pump EXTRACT, or REPLICAT, process group to start reading from the new trail file created by ALTER ETROLLOVER; the
 downstream process will not automatically switch to the new trail file.

 

问题产生的原因：

在初始化的时候，由于容灾端没有准备就绪，生产端来回进行了很多次的操作，导致生产端抽取混乱，此时在进行RMAN之前，重新启动抽取，忽略调之前的混乱信息。

解决办法：

alter extract xxx,etrollover

--------------------------------------------------------------------------------------------------

GGSCI (rac1) 16> alter extract eora,etrollover

2012-05-29 20:34:15  INFO    OGG-01520  Rollover performed.  For each affected output trail of Version 10 or higher format, after starting the source extract, issue ALTER EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file;  it will not happen automatically.
EXTRACT altered.

 

GGSCI (rac1) 18> start eora

Sending START request to MANAGER ...
EXTRACT EORA starting

 

GGSCI (rac1) 26> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER    RUNNING                                          
EXTRACT     RUNNING     EORA        00:00:00      00:00:11   
EXTRACT     RUNNING     PUMP_SO     00:00:00      00:15:59   

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26162300/viewspace-731656/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26162300/viewspace-731656/