The following are the recommended methods for backing up the DX NetOps Spectrum Archive Manager (DDM) database.
Release: Any
Component: SPCAEM - Archive Manager
There are two ways to backup the Archive Manager (DDM) database:
Manual Backup:
You can perform a DDM database backup at any time using the ddm_save.pl script
ddm_save.pl script:
The ddm_save.pl script, located in the $SPECROOT/SS/DDM directory, performs a full save of the historical database to the file you specify.
Steps:
./ddm_save.pl [-quiet] -f <SAVE_FILE>
Where the first letter of an argument name appears in bold type, you can use the letter only, rather than entering the whole name.
-quiet
Disables interactive/verbose mode.
-f <SAVE_FILE>
Specifies the name of the destination file for the saved database.
The backup file is saved in "mbi" format.
Online (Scheduled) Backup
Whenever an online backup is run on the SpectroSERVER database, the post_olb_script also runs. Out of the box, this script does nothing. However, the script can be modified to backup the DDM database.
The script is located in the $SPECROOT/SG-Support/CsScript directory. Because of the size of the DDM database, it is generally recommended to only run this script once a week. The following are the steps to modify the script to backup the DDM database on Sunday when the SpectroSERVER online backup is run.
day_of_week=`date +%w`
target_day=0
if [ $day_of_week -eq $target_day ]
then
cd $SPECROOT/SS/DDM
backup_dir=`dirname $ss_db_filename`
./ddm_save.pl -f $backup_dir/db_$time_string.DDMDb > $backup_dir/ddm_backup.log 2>&1
retval=$?
fi
You can modify the day of the week to backup the DDM database by changing the value of "target_day".
0 = Sunday
1 = Monday
2 = Tuesday
3 = Wednesday
4 = Thursday
5 = Friday
6 = Saturday
Please reference the "Database Backup" section of the documentation for more information.