Forum Stats

  • 3,760,131 Users
  • 2,251,648 Discussions
  • 7,870,992 Comments

Discussions

Data capture in GG

AATP
AATP Member Posts: 324 Blue Ribbon

Hi Experts ,


We have GG setup between two oracle databases , its working fine , for one of the rollback scenario , We are planning to restore the table data from backup file , So when we perform the import operation , Will GG capture the importing changes and replicate to target database ? Will that cause any impact, ?


Thanks

Aatp

Comments

  • ORASCN
    ORASCN Member Posts: 1,816 Gold Trophy

    Yes, of course it do capture. I would suggest two options,

    1. Set a tag to the session and exclude it in Extract parameter file -- TRANLOGOPTIONS EXCLUDETAG
    2. Perform the import using the user and exclude that user in the Extract parameter file -- TRANLOGOPTIONS EXCLUDEUSER

    This should work.

    Regards,

    Veera

    AATP
  • AATP
    AATP Member Posts: 324 Blue Ribbon

    Hi Veera,


    Thanks for the detail , its useful . Also like to know when we use Guarantee restore point to recover the Source Oracle database , How gg will work for target , is there any extraction or we need to manually recover the target database as like source ? Please assist


    Thanks

    Arun