Video Screencast Help

OpsCenter lost history after rebuilt

Created: 13 Sep 2013 • Updated: 10 Oct 2013 | 4 comments
This issue has been solved. See solution.

we are trying to generate some client count and backup capacity historic reports. But we found all history got lost before the time we rebuilt the master. The master rebuild was caused by a diaster, we recovered full catalog and database. Is there any way we can fix it?

NBU master: HP-UX 11.31 IA64, 7.1.0.4

OpsCenter: 7.5.0.6 on windows 2008 R2, with OpCenter Analytics licensed.

thanks in advance

Operating Systems:

Comments 4 CommentsJump to latest comment

Will Restore's picture

From the OpsCenter Guide

 

Backing up the OpsCenter database

OpsCenter is shipped with a database backup script that performs backup of the

database without interrupting its operations, which is referred to as hot backup.

On UNIX as well as Windows platforms, the script overwrites existing database

(db) files before backing up or restoring the database. The database files are as

follows: vxpmdb.db, symcOpscache.db, and vxpmdb.log. The script backs up or

restores the vxpmdb.db, symcOpscache.db, and vxpmdb.log file (if it exists).

Note: Regular file system backups are not sufficient for backing up the OpsCenter

database. You must schedule periodic hot backups for the OpsCenter database to

avoid losing any important data.

 

Restoring the OpsCenter database

After you back up the database, you can restore it. On Windows and UNIX hosts,

the restore operation automatically stops the database, restores the backup

database files, and restarts the database. The dbbackup script overwrites existing

database (db) files before backing up or restoring the database. The database files

are as follows: vxpmdb.db, symcOpscache.db, and vxpmdb.log. The script backs

up or restores the vxpmdb.db, symcOpscache.db, and vxpmdb.log file (if it exists).

 

Will Restore -- where there is a Will there is a way

FelixZhou's picture

Thanks for reply.

We did rebuild and upgrade OpsCenter a few times and we assume the OpsCenter database should sync with master itself to catch up everything.

our issue looks not on OpsCenter itself. Looks after we rebuilt the master, then the OpsCenter only reported from this point.

Will Restore's picture

Unless you have separate backup and restore of OpsCenter you will not get the old data back.  It does not go back in time to 'sync with master'.

 

Will Restore -- where there is a Will there is a way

FelixZhou's picture

finally understand OpsCenter will only start holding data from first Sync with master and hold the time period which OpsCenter set on purge (420days by default). Without OPA license, this time period will only be 60 days.

For "search & hold" function, it talks to catalog throug index server instead of other DBs, it doesn't need OPA license.

thanks for all your help

SOLUTION