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
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
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).
chojna
1 Rookie
•
16 Posts
1491
0
Posted 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