1. Login to NCM server from which you want to take the backup of database, and then set the VOYENCE_HOME environment variable.

    For example, in Linux, execute the following command:

    source /etc/voyence.conf

  2. Take the backup of database by using the backup.pl script under the <VOYENCE_HOME>/tools directory.

    The script creates a “backup-image-.*.tgz” file under the VOYENCE_HOME>/data-image directory.

    Note:
    • If you have Smarts Adapter configured with SMARTS IP and SAM, the backup.pl script will also backup the Smarts Adapter data.
    • If you are taking backup from lower version of NCM (10.1.3 and below) then before taking the backup run the database-changes.pl script present under Utils directory of 10.1.11 installer.
  3. Copy the “backup-image-.*.tgz” file to a host where a new NCM Combination setup is installed. The backup file can be copied under any directory.
  4. Login to the new NCM server setup, and then execute the following command:

    source /etc/voyence.conf

  5. Execute the following command from the <VOYENCE_HOME>/tools directory if you are restoring database across the same NCM version:

    perl restore.pl <Absolute path to backup image file /backup-image-.*.tgz>

  6. Execute the following command from the <VOYENCE_HOME>/tools directory if you are restoring database on higher NCM version:
    perl restore.pl <Absolute path to backup image file /backup-image-.*.tgz> --force
    Note: This step is required for the backups taken from NCM 9.6 version onwards.
  7. Update the InfraDB entry with the Device server host name. To update the InfraDB entry, perform the following steps:
    1. From the <VOYENCE_HOME>, execute the following command:

      \cgi-bin\cflist.cgi > cflist.txt

    2. Edit the cflist.txt to change the Device server FQDN to the new Device server FQDN (Same as Combination server FQDN).

      For example, POP 1000 “<hostname>”

    3. Execute the following command. It must return 'Status: 200 Success'.

      \cgi-bin\cfwrite.cgi < cflist.txt

  8. Change the ownership of <VOYENCE_HOME>/data directory to ncm:voyence using the command:

    chown -R ncm:voyence <VOYENCE_HOME>/data

  9. Change the ownership of <VOYENCE_HOME>/conf/key and <VOYENCE_HOME>/conf/iv files to ncm:voyence using the command: 
    chown ncm:voyence <VOYENCE_HOME>/conf/key
chown ncm:voyence <VOYENCE_HOME>/conf/iv
  10. Restart the vcmaster service.
  11. To update the Device server FQDN in cm_device_server table in the database, do the following:
    1. Login to NCM UI, and then navigate to Tools > System Administration > Global > Access > Device Servers.
    2. Select the Device server, and then click Edit.
    3. In the Edit Device Server window, click OK.

      Or,

      Run the following command from [Product directory]\db\controldb\bin: 

      psql.exe -h -d voyencedb -U pgdba -p 5435 -c "update cm_device_server set device_server_name='Device_Server_name';"
  12. If you have Smarts Adapter configured in your previous NCM setup, follow these steps:

    On Linux

    1. Stop the NCM Smarts Adapter service.

      systemctl stop ncmsmartsadapter

    2. Change the directory to $VOYENCE_HOME/NCMSmartsAdapter/.
    3. Open and edit the prodDb.script file, so that VOYENCE_CONFIGURATION table and SMARTS_CONFIGURATION table is populated with actual AS host name, as follows:
    4. Search for

      INSERT INTO VOYENCE_CONFIGURATION VALUES (1,4,TRUE,'auth.conf','2','10000','linbgh125.lss.vmware.com','jUpFF0M5HQuOdJUqIYKo0w==','sysadmin')

    5. Replace the old Application server host name with new Application server host name.

      For example, replace 'linbgh125.lss.vmware.com' with '<new Application server host name>'.

    6. Search for

      INSERT INTO SMARTS_CONFIGURATION VALUES (1,5,'aced0005757200135b4c6a6176612e6c616e672e537472696e673badd256e7e91d7b4702000078700000000274000e494e4348415247452d414d2d504d74000353414d','10.31.202.131',426,NULL,'z/RS9si+EWVsdA8kxzEovg==','SAM','linbgh131.lss.vmware.com','10.31.202.131','z/RS9si+EWVsdA8kxzEovg==','46499','admin',TRUE,'admin','linbgh125.lss.vmware.com')

    7. Replace the old Application server host name with new Application server host name.

      For example, replace 'linbgh125.lss.vmware.com' with '<new Application server host name>'.

    8. Open and edit the prodDb.script file, so that TOPOLOGY_SYNC table is populated with actual DS host name, as follows:
    9. Search for

      INSERT INTO TOPOLOGY_SYNC VALUES (1,43,120,300,TRUE,TRUE,200,'INCHARGE-AM-PM','DisplayName','Active Sync On',NULL,TRUE,FALSE,TRUE,TRUE,TRUE,TRUE,FALSE,'linbgh127.lss.vmware.com','1000','Derived','IP Devices','Run Upon Approval')

    10. Replace the old device server host name with the new device server host name.

      For example, replace 'linbgh127.lss.vmware.com' with '<new Device server host name>'.