Restore the HPOM database

If you used the scheduled task policy VP_SM_DB_Backup or the tool backup_openview.vbs to create a backup of the HPOM database, you can restore it manually. Before you can start restoring the HPOM database, you must stop the management server processes.

Stop management server processes

Note NOTE:
The restore procedure requires that the WMI service is stopped and remains stopped until the recovery is complete. System management tools, such as HP Systems Insight Manager and the HP Operations agent itself attempt to restart WMI automatically. Make sure that these tools are stopped while restoring the database.
  1. Close all open consoles first, before starting to restore the HPOM database.
  2. Stop all services and processes using vpstat -3 -r STOP.
  3. Use the service control panel (Services.MSC) to stop the Windows Management Instrumentation service. Note that there is a second service called "Windows Management Instrumentation Driver Extensions" - you do not need to stop this service (in fact you cannot stop it, the system disallows this). Alternatively, you can use the command net stop winmgmt to stop the WMI service.

Restore the openview database

Restore the backup files for the HPOM database backup to the same folder that they were generated in on the failed HPOM server. By default this is <HPOM database files folder>\Backup\.

To start the restore operation:

  1. If HPOM uses a local database, start the SQL SERVER (<instance name>) service again. Otherwise make sure the remote MS SQL Server instance is running.
  2. Run cscript %OvInstallDir%\support\restore_openview.vbs.
    Note NOTE:
    If your HPOM database resides on a remote database server you must add the SQL Server instance name as a parameter to the script restore_openview.vbs (for example, cscript restore_openview.vbs TCVM08\OVOPS).

Sample output

Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.

HPOM is stopped

This backup files will be used to restore the openview database:


BackupType: Full DB backup
BackupFileLocation:
E:\HPOM\Data\datafiles\OVOPS\backup\openview_dat.bak
BackupName:  openview_Full
BackupStartDate:  2006-11-09 14:55:59.000
BackupFinishDate:  2006-11-09 14:56:06.000


BackupType: Transaction log backup
BackupFileLocation:
E:\HPOM\Data\datafiles\OVOPS\backup\openview_log.bak
BackupName:  openview_Log
BackupStartDate:  2006-11-09 14:56:06.000
BackupFinishDate:  2006-11-09 14:56:06.000


Are you sure that you want to replace the current openview DB
with the contents of the backup above ? (y/n)
y

replace openview database with Restore


Restore succeeded

Related Topics: