Clarity Service Management

Expand all | Collapse all

How to configure SDM in AA freshly and copy MDB data from an existing database.

Jump to Best Answer
  • 1.  How to configure SDM in AA freshly and copy MDB data from an existing database.

    Posted 12-29-2017 02:58 AM

    Hi,

    We have a DC DR setup in AA mode with database replication configured in such a way that DR is a replica of DC including usp_servers and other env specific tables. 

    At the time of initial implementation we had configured DC and DR setup with their own separate db and when customer configured the replication they did not omit the tables that shouldn't be replicated. Now due to some reasons we had to remove our DR SDM applications completely.

    Now we are left with one set of applications in AA mod in DC which are connected to the DC db and a db in DR replicating with DC without any applications in DR.

    Our goal is to configure a DR application setup freshly and connect it to the existing DR db. Database is Oracle. 

    I am thinking the best way is to configure a set of applications in DR using a fresh database in another DB server and after that point the newly created applications in DR to the actual DR database making necessary table changes.

    Can i follow this method or is there a better way to achieve this?

     

    Regards,

    Vysakh



  • 2.  Re: How to configure SDM in AA freshly and copy MDB data from an existing database.
    Best Answer

    Posted 12-29-2017 09:44 AM

    It sounds like you have a good plan. I'd recommend setting up a clean install, then once completed copy and replace the usp_servers and the al_cdb tables from the clean system to the replica database, then run pdm_configure to reconfigure for the replica database.



  • 3.  Re: How to configure SDM in AA freshly and copy MDB data from an existing database.

    Posted 01-10-2018 02:48 AM

    Hi Alex,

     

    We managed to do the same and it's working properly. So far everything is working fine. Thanks for your valuable feedback.

     

    Regards,

    Vysakh 



  • 4.  Re: How to configure SDM in AA freshly and copy MDB data from an existing database.

    Posted 01-02-2018 12:54 PM

    Vysakh..........

     

    Happy New Year.

     

    Did the information provided by Alex address your question?

     

    If so, please mark his answer as "correct" so that this thread can be marked as completed.



  • 5.  Re: How to configure SDM in AA freshly and copy MDB data from an existing database.

    Posted 01-10-2018 02:51 AM

    Hi Paul,

     

    Sorry for the delayed response. The solution provided by Alex is working fine. Thanks for all the support providing by you guys. Best community ever. 

     

    Regards,

    Vysakh