000029238 - Preferred IMG Database Backup Process

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000029238
Applies ToIMG Server - local database
IssueIt is important to backup the IMG database while there is no system activity.  Performing a backup with ongoing application activity can result in an invalid/incomplete backup.
TasksThe recommended backup procedure is as follows:

This backup procedure is done with the IMG application shut down to ensure that there is no database activity. This method is appropriate for a planned "maintenance" window:

1. Login to the appliance as the 'oracle' user and stop the IMG application.

Command: acm stop

2. Export the database with provided scripts.  Use a naming convention for the backup file ID to clearly identify it by including date/time, version, system name, etc.
Command: /home/oracle/database/DBA/AVDB/scripts/AVDB_Export_AVUSER.sh -t <file ID>
or with alias:

Command: avdbexport -t <file ID>
For example:
/home/oracle/database/DBA/AVDB/scripts/AVDB_Export_AVUSER.sh -t _02_28_2015_V681P12_BCP
creates backup file Export_AVDB_avuser_02_28_2015_V681P12_BCP.dmp


3. Restart the server:

Command: acm start

NotesDatabase backup files should always be moved to redundant backup media on a different machine and/or in a different physical location for safe keeping.