|
 |
|
Visit The *EVEN NEWER* Barrow-Downs Photo Page |
REPLICAT rep01 -- existing parameters MAP schema.table, TARGET schema.table, FILTER (@GETENV('GGHEADER','XID') != '3.27.12345'); Start the replicat with NOHANDLECOLLISIONS (if appropriate) or ALLOWNOOPUPDATES .
TransInd: 1 (First record of transaction) XID: 3.27.12345 Add a FILTER or MAP exception in the Replicat parameter file:
ggsci> ALTER REPLICAT rep01, EXTSEQNO 12, EXTRBA 4819000 ggsci> START REPLICAT rep01 You lose all changes after RBA 4819000. Resync required for the missing window. Solution 3: Recover from Source Trail or Archive (Recommended for Production) If you have archive trails enabled ( EXTTRAIL with ROLLOVER at source) or a backup of the trail files before corruption:
REPLICAT rep01 -- existing parameters MAP schema.table, TARGET schema.table, FILTER (@GETENV('GGHEADER','XID') != '3.27.12345'); Start the replicat with NOHANDLECOLLISIONS (if appropriate) or ALLOWNOOPUPDATES .
TransInd: 1 (First record of transaction) XID: 3.27.12345 Add a FILTER or MAP exception in the Replicat parameter file: ogg-01184 expected 4 bytes but got 0 bytes in trail
ggsci> ALTER REPLICAT rep01, EXTSEQNO 12, EXTRBA 4819000 ggsci> START REPLICAT rep01 You lose all changes after RBA 4819000. Resync required for the missing window. Solution 3: Recover from Source Trail or Archive (Recommended for Production) If you have archive trails enabled ( EXTTRAIL with ROLLOVER at source) or a backup of the trail files before corruption: REPLICAT rep01 -- existing parameters MAP schema
