This post is more than 5 years old
16 Posts
1
2086
How to backup VNX MR database and configuration files
I am looking for steps how to backup database on VNX MR:
1. I know that I have to lock database to perform backup - question which script I should use from VNX\bin on Windows:
database-maintenance-tasks.cmd
lock-apg-database.cmd
lock-mysql-database.cmd
2. Which directory I should backup to backup database?
3. Which files should I backup to restore configuration of VNX MR:
a. licenses and modules
b. arrays
c. my reports
d. scheduled reports
Regards Arek
chojna
16 Posts
0
July 26th, 2016 06:00
Yes I did Thanks:
I have no idea why when I searched for VNX Monitoring and reporting data base backup I did not get this results.
Thanks Again
ViPR SRM / Watch4net / VNX M&R : How to manually backup and restore the database
VNX M&R : How to backup VNX M&R database
Issue
This article explains only the procedure to manually backup the database used by VNX M&R. Diagnostic logs if taken, would take backup of configuration data.
How do I backup my VNX M&R database ?
Resolution
There is only manual procedure to backup the VNX M&R database. This procedure is conceptually similar for VNX M&R running on Linux platform.
Step by step procedure:
Log into mysql database
1. Log into VNX M&R virtual machine as 'root' with default password 'watch4net'
2. Cd to :\Program Files\VNX\bin
3. Run 'mysql-client.cmd'
4. Enter 'apg' for username, 'apg' for database, and 'watch4net' as password
Lock database folders
5. \bin\lock-apg-database.cmd
6. \bin\lock-mysql-database.cmd
Once the database is locked, copy the following folders to a secure location
7. Go to :\Program Files\VNX\Databases\MySQL\Default\data
8. Copy 'apg' and 'master' folders to a secure location
9. Your are done with your VNX M&R database backup. There is no further script to run.
Notes
By default the database folders are locked for 2 hours. So the maintenance mode would be 2 hours before all the locked database folders will automatically unlocked. But this maintenance period can be modified as followed:
1. Go to :\Program Files\VNX\Tools\MySQL-Maintenance-Tool\Default\bin
2. Right-click on lock-apg-database.cmd file and edit in Notepad
3. Change this parameter 'set WAIT_TIME=7200' to an hour for example
set WAIT_TIME=3600
4. Save the file
kelleg
4.5K Posts
0
July 22nd, 2016 09:00
Not sure what VNX MR is but backup is an server function and not an array function. I would recommend that you contact the server/application for the database vendor for support. In the future it would be helpful for provide more detailed information about the array model you're using and the type of database (Oracle, SQL, etc).
glen
chojna
16 Posts
0
July 22nd, 2016 09:00
VNX Monitoring and reporting.This EMC product!
Rainer_EMC
8.6K Posts
0
July 25th, 2016 02:00
Hi,
there is some information about backup in the VNX M&R manuals.
There are also detailed knowledgebase articles available if you simply open support.emc.com and search for “M&R backup”
If that is not sufficient I would suggest to open a service request.
If you are running M&R as a virtual machine the easiest is probably to just snapshot/clone using your Hypervisor tools
Rainer_EMC
8.6K Posts
0
July 26th, 2016 05:00
Arek,
were you able to find the knowledgebase article ?
Rainer