You are here

MySQL Enterprise Edition Database Repository Backup

MySQL Enterprise Edition Database Repository Backup

Starting with Oracle VM Manager Release 3.2.1 and above, simple MySQL Oracle VM Manager installations are automatically backed up within the /u01/app/oracle/mysql/dbbackup directory every 24 hours using the MySQL Enterprise Backup utility. By default the Oracle VM Manager MySQL database backups are rotated regularly so that only the 15 most recent backups are retained. It is also possible to perform manual backups using the MySQL Enterprise Backup utility.
 
The default path for the Oracle VM Manager MySQL backups is defined in the /etc/sysconfig/ovmm file on the Oracle VM Manager host. The next example shows the default path settings in the /etc/sysconfig/ovmm file:
DBBACKUP=/u01/app/oracle/mysql/dbbackup
 
Note: The default path can be changed to accommodate disk space requirements.
 
To confirm the existence of the Oracle VM Manager MySQL backups, on the Oracle VM Manager host change to the /u01/app/oracle/mysql/dbbackup directory, and list the contents of the directory. The next example shows how to change to the /u01/app/oracle/mysql/dbbackup directory and list its contents.
# cd /u01/app/oracle/mysql/dbbackup
# ls -lart
 
If your daily backups are failing, it is possible to run a manual backup. As root, access the Oracle VM Manager host, and follow these steps:
# cd /u01/app/oracle/ovm-manager-3/bin
# ./createBackup.sh
Backing up the Oracle VM Manager MySQL Database...
Please enter the Oracle VM manager user name: admin
Please enter the Oracle VM manager user password:
INFO: Succesfully backed up database as AutoFullBackup-20130911_212701
 
If the above command fails, check if both services are running:
# /etc/init.d/ovmm status
Oracle VM Manager is running...
# /etc/init.d/ovmm_mysql status
MySQL running (1977) [ OK ]
 
If ether of the two services are not running, restart the failed service.
 
Manual backups are retained for 15 backups, before being automatically removed. Using the -n switch with a user defined backup name excludes the backup from being automatically removed. The next example shows how to create a backup useing the -n switch.
# /u01/app/oracle/ovm-manager-3/bin/createBackup.sh -n MyBackup1
 
Download PDF Now!