DR Setup for ITAM

[Anon Anon]

It’s a DC- DR Setup which we want to create. The Database of ITAM Server is stored on a SQL Server  and the Tool refers to the Cluster Name of this Server. DC Server is mapped to ABC Cluster.

In DR Environment, We have the DB cluster name as DEF. Databases of DC and DR  will be made in synch through Logshipping. We have copied the DC VM in DR Environment. Which will be turned ON only when the DC Production environment goes down.

 

So the DR VM will use DC hostname and DR IP address. Problem is this VM will have DB cluster name of DC i.e ABC. However we want to change it to DEF which is the DR Cluster name. Pls let us know how can we change the DB cluster name. (Databases inside the cluster name will be same as DC)

[Anon Anon]

Dear All,

 

Pls let me know about the best practices of CA for creating a DR setup for ITAM.

[Vinod Subburaj]

Hi Soumya ,

Not sure if you have implemented DR setup for ITAM. I find no official document on it.

However you need to replicate the MDB data from DC environment to DR Environment .

To find the list of the ITAM tables , try select  table_name from arg_table_def.

You may exclude these tables :
al_cdb_comp_installstate_bkup 
al_cdb_componentinstallstate 
al_cdb_config_params_backup 
al_cdb_configurationparameters 
al_cdb_files
 ca_application_registration
al_applications 

 

~Vinod.

[sahilk]

Dear All who might face such kind of Issues.

 

Rather than  copying the DC VM in DR Environment, Install ITAM in Both DC and DR with the same DB name and Credentials.

The DR system is in cold state so no need to do any configurations on it.

Just do a Default Installation and leave everything on the DR site. Do all the Customization on the DC site.

 

The DB credentials that are used to connect to DB are stored in the Config Files which in this case are already pointing to the default DB on DR Site.

This way you need not worry about changing the Credentials to point to DB Server DEF, Just make sure the DB name (mdb) and credentials used to connect to DB are same in both DC and DR.

 

Now you can start replicating your DB to the DR site and once your DC goes down, You can Restore the DB in the DR site and Move the DR site in the Active State. This restoration will move all your Customization that were made in the DC to the DR site because they are stored in the DB.

 

This is the Best-Practice for almost every application.

 

Regards,

 

Sahil