3 Replies Latest reply: Jul 30, 2013 12:27 PM by stevencallan RSS

    How to reset all setup

    yxes2013

      Hi all,

       

      ggs 11.2

       

      I have tested setup of mssqlserver replication to oracle successfully.

      I want to repeat the setup again  as I did not understand the process well.

      I want to use the same set of schemas and tables. So I want to undo all what I have done.

      What are the steps to undo the setup?


      In the sqlserver side:


      How do I undo or remove :


      ADD TRANDATA HRSCHEMA.EMP

      ADD EXTRACT MSEXT, TRANLOG, BEGIN NOW

      ADD RMTTRAIL /u01/app/oracle/gg/dirdat/ms, EXTRACT MSEXT

       

      In the oracle side, how to I undo or remove:

       

      ADD CHECKPOINTTABLE gg_user.chkpt

      ADD REPLICAT MSREP, EXTTRAIL /u01/app/oracle/gg/dirdat/ms, CHECKPOINTTABLE gg_user.chkpt


      Thanks a lot,

      zxy

        • 1. Re: How to reset all setup
          marie.couch

          On the source side you would do the following:

           

          DELETE TRANDATA HRSCHEMA.EMP

          DELETE EXTRACT MSEXT

          DELETE RMTTRAIL /u01/app/oracle/gg/dirdat/ms

           

          Note that this command only deletes references to the specified trail from the checkpoint file. It does not delete the trail files themselves. To delete the trail files, use standard operating system commands for removing files.

           

          On the target side you would do these corresponding commands:

           

          DROP CHECKPOINTTABLE gg_user.chkpt

          DELETE REPLICAT MSREP

           

          Deleting the Extract and Replicat will remove the checkpoint files but leave the parameter files intact, so you can then recreate the groups as desired.

           

           

          Let me know if you have any other questions.

           

          Best regards,

          Marie

          • 2. Re: How to reset all setup
            yxes2013

            Thanks Marie,

             

            Yes I have other questions .  I want to replicate EMP table from sqlserver to  3  separate Oracle databases. One(1) source but 3 targents. How do I do that?

            Is there sample docs I can follow on this. or I will just follow the same procedure on a 1 to 1 replication?

             

            Thanks a lot,

            • 3. Re: How to reset all setup
              stevencallan

              Create an OBEY file, it basically runs a GGSCI script. You'll want something like anyway for DR purposes - how would you re-create your GoldenGate environment today? Remember every single command used in GGSCI? Not likely.