Data Backup and Restoration

Periodically backing up the database is very essential, as it helps you restore OpManager service back during planned maintenance as well as unplanned mishaps. OpManager database contains two types of data:

Performance data: This is the data gathered by OpManager by periodically polling or querying the resources on a monitored device to determine its performance. This includes resources like CPU, Memory, Response time, Traffic etc.

Configuration data: There are quite a few configurations an administrator effects in OpManager for easy management and monitoring. The configurations include user settings, details of discovered devices, custom monitors, threshold settings, notification profiles, etc.
 

Steps to backup data:

  • Open command prompt with administrative privileges and go to <OpManagerHome>/bin/backup directory.
  • Execute BackupDB.bat (use BackupDB.sh for Linux) from the command prompt as shown below:

<OpManagerHome>/bin/backup>BackupDB.bat

Note: This utility does a backup of the complete database, i.e., performance and configuration data. Only the configuration data will be backed up for Netflow Analyzer and Firewall Analyzer modules.

  • The backup file created will be stored in <OpManagerHome>\backup directory. To store the backup file in a different directory, use the command given below:BackupDB.bat -destination "<DestinationFolderPath>" (Eg : BackupDB.bat -destination "C:\Backup")

To backup only the configuration data:

  • Open command prompt with administrative privileges and go to <OpManagerHome>/bin/backup directory and execute the below command:

<OpManagerHome>/bin/backup>BackupDB.bat -mode configdata

  • This is used to backup only the configuration data (Backup Conf., Images folder, the details of Devices, Device Templates, Interfaces, Interface Template, Dashboards & Widgets, Infrastructure Views, Business Views, Credentials, Notification Profiles and Users) and not the performance data.
     

Steps to restore data:

  • Open command prompt with administrative privileges and go to <OpManagerHome>/bin/backup directory.
  • Execute RestoreDB.bat (use RestoreDB.sh for Linux) with the backup file name as argument from the command prompt as shown below:

<OpManagerHome>/bin/backup>RestoreDB.bat "<Backup file name with path>"
(Eg:  RestoreDB.bat "C:\backup\Backup_Pgsql_Mar8_125128_123313.zip" )

Note: For MSSQL database, find the files bcp.exe and bcp.rll in MSSQL server and ensure to copy it to OpManager home folder. If the MSSQL server is installed on a 64-bit OS, and OpManager is installed on 32-bit server, the bcp.exe and bcp.rll copied from the MSSQL server will not work on the OpManager machine. You'll need a 32-bit bcp.exe and bcp.rll