Backing up and restoring HP SIM 5.2 or greater data files in a Windows environment

ManualsBrandsHP ManualsSoftwareHP Systems Insight Manager for Linux

Backing up and restoring HP SIM 5.2 or greater data files

in a Windows environment

Abstract.............................................................................................................................................. 2

Introduction......................................................................................................................................... 2

Saving and restoring data files.............................................................................................................. 2

Saving and restoring files where HP SIM is installed using a Microsoft SQL database .............................. 3

Saving HP SIM configuration files and SQL server data files .............................................................. 3

Restoring HP SIM configuration files and SQL server data files from a backup ..................................... 5

Saving and restoring files where HP SIM is installed using Microsoft SQL Server 2005 Express................. 7

Saving HP SIM configuration files and SQL server data files: ............................................................. 7

Saving HP SIM configuration and HP SIM database using Microsoft SQL Enterprise Manager............... 7

Backing up the HP SIM database: .................................................................................................. 8

Restoring HP SIM configuration files and SQL server 2005 Express data files from a backup ................ 9

Saving and restoring files for an Oracle database ............................................................................. 11

Saving data files for use with Oracle ............................................................................................ 11

Restoring data files for use with Oracle. ........................................................................................ 12

For more information.......................................................................................................................... 14

Summary of content (14 pages)

PAGE 1
Backing up and restoring HP SIM 5.2 or greater data files in a Windows environment Abstract.............................................................................................................................................. 2 Introduction......................................................................................................................................... 2 Saving and restoring data files ...........................................................................................
PAGE 2
Abstract HP Systems Insight Manager (HP SIM) is a flexible management utility for an enterprise environment employing HP ProLiant, HP BladeSystem, HP StorageWorks, and HP Integrity solutions. The system database and configuration files used by HP SIM should be backed up regularly to allow recovery from a catastrophic system failure or an instance of corrupted files.
PAGE 3
Saving and restoring files where HP SIM is installed using a Microsoft SQL database This section describes saving (backing up) and restoring files used with a Microsoft SQL database. Saving HP SIM configuration files and SQL server data files Microsoft SQL Enterprise Manager has built-in utilities for backing up the database, including an automated procedure. HP recommends viewing the Help files provided by the SQL Enterprise Manager to gain a complete understanding of this procedure.
PAGE 4
SQL Server Wizard by right-clicking SQL server group and selecting New SQL Server Registration to bring up the Register SQL Server Wizard window (Figure 1). This procedure assumes the desired server is already listed and that the wizard is not required. Figure 1: Register SQL Server Wizard window 8. Select the server where the HP SIM database is located. From the Tools menu at the top, select Backup database.
PAGE 5
Figure 2: SQL Server Backup window 9. In the Destination field, click Add, select a location (such as disk or tape) for storing the backup copy of database, and then click OK to initiate the backup. Restoring HP SIM configuration files and SQL server data files from a backup 1. If reinstalling HP SIM, for instructions refer to the HP Systems Insight Manager 5.3 Installation and Configuration Guide for Microsoft Windows, available at the following URL: http://h18013.www1.hp.
PAGE 6
. Using the file management tool of your choice, restore the directories and files listed in Table 1. For each occurrence of , substitute the actual path name where HP SIM is installed. If offered, be sure that the Always replace the file on disk option is selected. Note: You must use a tool that preserves file permissions (such as the Windows Backup tool) while restoring directories and files. 7. From the Windows Start menu on a Windows console, open Microsoft SQL Enterprise Manager. 8.
PAGE 7
Figure 4: Restoring the backup set 12. Open the command line window and type mxconfigrepo –c to check for database errors. Use the command mxconfigrepo –f to fix any errors, and run the command mxconfigrepo –c once again as a final check. 13. Start the HP SIM service and any plug-in application. Saving and restoring files where HP SIM is installed using Microsoft SQL Server 2005 Express, Microsoft SQL Server 2005, or 2008 Microsoft SQL Server 2005 Express allows backing up both data files.
PAGE 8
2. Save any existing user-supplied (custom) files contained in the HP SIM directory tree such as tool definition files (TDEFs), Management Information Bases (MIBs), login prompt, actions, etc. 3. Save the OpenSSH Keys from the \etc folder. 4. Save any custom support packs used by the Version Control Repository manager (VCRM). 5. Save any data files corresponding to any plug-in utilities used with HP SIM.
PAGE 9
Figure 6 Restoring HP SIM configuration files and SQL server 2005 Express data files from a backup 1. If reinstalling HP SIM, for instructions refer to the HP Systems Insight Manager 5.3 Installation and Configuration Guide for Microsoft Windows, available at the following URL: http://h18013.www1.hp.com/cpq-products/servers/management/hpsim/infolibrary.html. If not performing a reinstallation of HP SIM, then proceed to step 5. Note: You must reinstall HP SIM with the same user account used previously.
PAGE 10
5. Stop the HP SIM Service if it is running, along with any HP SIM plug-in applications such as HP Performance Management Pack. 6. Using the file management tool of your choice, restore the directories and files listed in Table 1. For each occurrence of , substitute the actual path name where HP SIM is installed. If offered, be sure that the Always replace the file on disk option is selected.
PAGE 11
Figure 8 15. Open the command line window and enter mxconfigrepo –c to check for database errors. Use the command mxconfigrepo –f to fix any errors. 16. Run the command mxconfigrepo –c again as a final check. 17. Start the HP SIM service and any plug-in application. Saving and restoring files for an Oracle database The following procedures describe backing up and restoring data files for a system using an Oracle database with HP SIM.
PAGE 12
2. Open the /config/database.props file and check the property value for hp.database.username. A user with Oracle Database Administrator (DBA) privilege must conduct the backup and restore process. 3. Save any existing user-supplied (custom) files contained in the HP SIM directory tree such as tool definition files (TDEFs), Management Information Bases (MIBs), login prompt, actions, etc. 4. Save the OpenSSH Keys from \etc folder. 5.
PAGE 13
Table 2: Configuration files to restore for Oracle Directory or file Description \config\ (see note) Directory of configuration files C:\hp\sslshare\ Shared openSSL certificate directory \logs\mx.log Audit log file \patch Program updates (required if you want to reinstall HP SIM), this might be empty \bin\servercert.pem Certificate used by the Command Line Interface (CLI) \bin\cliclientconfig.
PAGE 14
For more information For additional information about HP SIM, visit www.hp.com/go/hpsim. © 2006-2009 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice. The only warranties for HP products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty.