Backing up and restoring HP Systems Insight Manager 6.3 database in a HP-UX or Linux Environment

ManualsBrandsHP ManualsSoftwareHP Systems Insight Manager 5.x HP-UX Software

TableofContents

Introduction ......................................................................................................................................... 2

Backing

and

restoring

data

files

for

PostgreSQL database

.................................................................. 2

Backing

data

files

for

PostgreSQL

database

................................................................................. 2

Restoring

data

files

for

use

with

PostgreSQL

......................................................................................... 4

Backing

and

restoring

data

files

for

Oracle

database

...................................................................... 6

Saving

data

files

for

use

with

Oracle

.................................................................................................. 6

Restoring

data

files

for

use

with

Oracle

............................................................................................... 8

For more information .......................................................................................................................... 12

Backing up and restoring HP Systems Insight

Manager 6.0 or greater data files in a HP-UX

and Linux environment White Paper

Summary of content (12 pages)

PAGE 1
Backing up and restoring HP Systems Insight Manager 6.0 or greater data files in a HP-UX and Linux environment White Paper Table of Contents Introduction ......................................................................................................................................... 2 Backing up and restoring data files for a PostgreSQL database.................................................................. 2 Backing up data files for a PostgreSQL database .......................................
PAGE 2
Introduction HP Systems Insight Manager (Systems Insight Manager) uses a PostgreSQL server database to store collected information about the systems on your network. Always back up your database using an appropriate backup schedule. In the event of a catastrophic database problem, this backup can be restored to return Systems Insight Manager to operation. Important: The procedures in this paper are for backing up and restoring Systems Insight Manager core data only from/to the same PostgreSQL database.
PAGE 3
Table 1. Configuration files that must be backed up Directory of file Description /etc/opt/mx/config Directory of configuration files /var/opt/mx/config/ Additional configuration files /etc/opt/hp/sslshare/ Shared OpenSSL certificate directory /var/opt/mx/logs/mx.log Audit file /opt/mx/patch Program updates (required if Systems Insight Manager is to be reinstalled) /opt/mx/bin/server_cert.
PAGE 4
8. Enter the following commands to backup the database: For HP-UX: cd /opt/hpsmdb/pqsql/bin For Linux: cd /opt/hpsmdb/bin ./pg_dump –h 127.0.0.1 –U mxadmin –p 50006 insight_v1_0 > /tmp/saveHPSIMdb Where: -h = host name of the server -U = PostgreSQL user name -p = port number (to find the port number, open the /etc/opt/mx/config/database.props file and find the property value for the hp.Database.portNumber property.
PAGE 5
Or service hpsmdb stop 4. To verify that all Systems Insight Manager mx processes have stopped: ps -ef | grep mx 5. For Linux systems: a. Verify that the postmaster is running: ps –ef | grep postmaster If postmaster is running, kill the service: kill -9 b. Uninstall hpsmdb: rm –rf /opt/hpsmdb /var/opt/hpsmdb c. Install hpsmdb from Systems Insight Manager binary: Navigate to the Systems Insight Manager binary, then execute the following command to unpack all RPMs: ./sysmgmt.
PAGE 6
9. Create the database with the name insight_v1_0 using the following command: At the command line, enter: For HP-UX: cd /opt/hpsmdb/pqsql/bin ./psql –q –h 127.0.0.1 –U mxadmin –p 50006 –f /tmp/saveHPSIMdb –d insight_v1_0 For Linux: cd /opt/hpsmdb/bin ./psql –q –h 127.0.0.1 –U mxadmin –p 50006 –f /tmp/saveHPSIMdb –d insight_v1_0 Where -h = Host name of the server -U = PostgreSQL user name -p = port number (to find the port number, open the /etc/opt/mx/config/database.
PAGE 7
Table 2. Configuration files to save Directory of file Description /etc/opt/mx/config/ Directory of configuration files /var/opt/mx/config/ Additional configuration files /etc/opt/hp/sslshare/ Shared OpenSSL certificate directory /var/opt/mx/logs/mx.log Audit file /opt/mx/patch Program updates (required if Systems Insight Manager is to be reinstalled) /opt/mx/bin/server_cert.
PAGE 8
Table 3. Oracle database parameters Parameter Action Username Type the username of dba and press Enter. Password Type the password of dba-user-password and press Enter. Array fetch butter size Press Enter to select default of 4096. Export file Type the file name and path to dump the database and press Enter. EXPDAT.DMP (1) E(ntire database) (2) U(sers) (3) T(ables) Type E and press Enter. Export grants (yes/no) Press Enter to select default of Yes.
PAGE 9
7. Restore the configuration files listed in Table 4.
PAGE 10
0 Table 4. Configuration files to be restored Directory of file Description /etc/opt/mx/config/ Directory of configuration files /var/opt/mx/config/ Additional configuration files /etc/opt/hp/sslshare/ (for HP-UX) Shared OpenSSL certificate directory Etc/opt/hp/sslshare (for Linux) /var/opt/mx/logs/mx.log Audit file /opt/mx/patch Program updates (required if Systems Insight Manager is to be reinstalled) /opt/mx/bin/server_cert.
PAGE 11
Table 5. Oracle database parameters Parameter Action Username Type the username of Dba and press Enter. Password Type the password of Dba-user and press Enter. Insert buffer size Press Enter to select default of 30720. Import file Type the file name and path of the database to restore and press Enter. BACKUP.DMP List contents of import file only (yes/no) Press Enter to select default of No. Ignore create error due to Object existence (yes/no) Select Yes and press Enter.
PAGE 12
For more information For additional information, visit www.hp.com/go/hpsim. Technology for better business outcomes © Copyright 2010, 2011 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.