[OA Maintenance Guide] Configure system backup

Article ID: 113963, created on May 25, 2012, last review on Dec 1, 2016

Applies to:

Operations Automation

Configure OA system backup

Pay attention to protecting your business by developing the Disaster Recovery Plan. The goal of the Disaster Recovery Plan is to enable an organization to survive and re-establish normal business operations after disaster. Surviving means having an ability to recover all critical operations that can resume a business within a reasonable time frame.

There are many backup and recovery methods and specialized software and hardware applications, third-party backup and recovery solutions are not covered in this article. Instead, it helps configure OA built-in backup and recovery tools (for example, Windows Server Backup tool). For information on using the third-party Backup and Recovery software, refer to the corresponding manufacturer's documentation.

General notes

Configure periodic tasks to create full backups (weekly or monthly) and partial backups (daily) of servers in OA infrastructure.

If OA servers are installed Virtuozzo containers then use native Virtuozzo backup tools vzbackup/vzabackup to create backup of servers.

OA Management Node backup

Provided that OA is installed in the folder /usr/local/pem exclude the following directories from the backup:

/usr/local/pem/vhosts

/usr/local/pem/vhosts/sysvhosts

/usr/local/pem/vhosts/var/cores

Use the scripts /usr/local/pem/bin/backup.sh and /usr/local/pem/bin/restore.sh for backing up and restoring OA Management Node (MN). Run the scripts on OA MN under the root user's permissions. Put OA MN backup task into cron to run backups periodically.

OA Database Server

Use the backup_dbs.sql script included into OA distribution (doc/Scripts/backup_dbs.sql) to create backup of OA database running on Microsoft SQL server. By default backup will be stored in the folder c:\temp\sqlbak, the following data will be placed into it:

Content of the master database is placed in the master.bak file

The content of each database is placed in a separate N-name.bak file

N is an internal database number of SQL server

name is a name of a database.

The restore_dbs.sql file is generated during the backup process (with the backup_dbs.sql script). This file is used by the restore_dbs.cmd script which is also included into distribution (doc/Scripts/restore_dbs.cmd).