If you decide to restore the archive logs to enable SharePlex to resume capture and replication, use the following procedure to determine the required archive logs.
Determine the sequence number that Capture needs to resume processing from. Capture stops when it encounters a log wrap and prints a message to the Event Log (event_log) containing the redo log sequence number it needs. You also can find out this number by querying the SHAREPLEX_ACTID table and looking at the SEQNO column, as shown in the following example:
SQL> select * from splex.shareplex_actid;
| ACTID | SEQNO | OFFSET | AB_FLAG | QUE_SEQ_NO_1 | QUE_SEQ_NO_2 | COMMAND |
| ----- | ------ | -------- | -------- | ------------- | -------------- | ------------ |
| 14 | 114 | 9757200 | 0 | 672101000 | 0 |
Query the Oracle V$LOG_HISTORY table to find out when that sequence number was archived, then copy the logs from that point forward to the source system.
SQL> select * from V$LOG_HISTORY;
| RECID | STAMP | THREAD# | SEQUENCE# | FIRST_CHANGE# | FIRST_TIM NEXT_CHANGE# |
| ----- | ------ | -------- | -------- | ------------- | -------------- |
| 111 | 402941650 | 1 | 111 | 2729501 | 14-JUL-00 2729548 |
| 112 | 402941737 | 1 | 112 | 2729548 | 14-JUL-00 2729633 |
| 113 | 402941930 | 1 | 113 | 2729633 | 14-JUL-00 2781791 |
| 114 | 402942019 | 1 | 114 | 2781791 | 14-JUL-00 2836155 |
| 115 | 402942106 | 1 | 115 | 2836155 | 14-JUL-00 2890539 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
