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

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

Table of Contents

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

Backing up and restoring data files for a PostgreSQL database ................................................................. 3

Backing up data files for a PostgreSQL database ................................................................................. 3

Restoring data files for use with PostgreSQL ........................................................................................ 4

Backing up and restoring data files for an Oracle database ..................................................................... 8

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

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

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

Backing Up and Restoring HP Systems Insight

Manager 7.1 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 7.1 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 ................................................................. 3 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.
PAGE 3
Backing up and restoring data files for a PostgreSQL database Backing up data files for a PostgreSQL database Backing up the database with PostgreSQL requires changing the Systems Insight Manager database user password and saving the database and associated files. 1. If Systems Insight Manager is running, enter mxstop in the command line to stop the Systems Insight Manager daemons. 2.
PAGE 4
6. Change the password generated by Systems Insight Manager for mxadmin before you back up the database. To change the password, enter the following command at the Systems Insight Manager command line: /opt/mx/bin/mxpassword –m –x MxDBUserPassword= Where is the new password. 7. Restart the PostgreSQL service with the restart command. Note: The full command path might vary depending on the PostgreSQL install location. For HP-UX: /sbin/init.
PAGE 5
http://www.hp.com/go/hpsim (for Linux and HP-UX) • If you are not performing a reinstallation, complete the following procedure. 1. If Systems Insight Manager is running, enter mxstop in the command line to stop the Systems Insight Manager daemons. 2. Stop the PostgreSQL (HPSMDB) service with the stop command. Note: The full command path might vary depending on the PostgreSQL install location. For HP-UX: /sbin/init.
PAGE 6
swremove –x enforce_dependencies=false SysMgmtDB b. Install SysMgmtDB from the Systems Insight Manager Depot file by entering the following command: swinstall –s /hpsim.depot SysMgmtDB 6. Create a database with the name insight_v1_0 using the following command: For HP-UX enter: cd /opt/hpsmdb/pgsql/bin For Linux enter: cd /opt/hpsmdb/bin ./createdb -O hpsmdb –h 127.0.0.1 –p 50006 –U hpsmdb insight_v1_0 7. Create a user named mxadmin by using the following command: ./createuser –h 127.0.0.
PAGE 7
Note: To move HPSIM data from one Linux operating system to another, use the same steps listed above with the following command: scp Linuxsys1 (data file and configuration files) Linuxsys2:/path To restore HPSIM data on a different LINUX operating system, follow the restore procedure in Restoring Data Files for Use with PostgreSQL.
PAGE 8
Backing up and restoring data files for an Oracle database The following procedures describe saving (backing up) and restoring data files for a system using an Oracle database that is using Systems Insight Manager. Important: Only a user with Oracle Database Administration (DBA) privileges can conduct the backup and restore process. Saving data files for use with Oracle 1. If Systems Insight Manager is running, enter mxstop in the command line to stop the Systems Insight Manager daemons. 2.
PAGE 9
5. Open the /etc/opt/mx/config/database.props file and check the property value for hp.Database.username. Note: Before you start the database back up, note the database name, DBA user name, and DBA password. 6. At the Oracle server console command line, enter the following command: Set ORACLE_SID= Where is the database to be saved. 7. Log into the SQL by entering: sqlplus username/passwd as sysdba 8.
PAGE 10
6. To verify that all Systems Insight Manager mx processes have stopped, run the following command: ps –ef | grep mx 7. Restore the configuration files listed in Table 3. Table 3. Configuration files to be restored File Directory 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 /var/opt/mx/logs/mx.
PAGE 11
b. Log into the SQL by typing sqlplus user1/passwd as sysdba c. At SQL Prompt, execute the IMPD command with the following parameters: $impdp user1/passwd DIRECTORY=DATA_DUMP_DIR DUMPFILE=USER1.DMP SCHEMAS=user1 EXCLUDE=CONSTRAINT,REF_CONSTRAINT,INDEX TABLE_EXISTS_ACTION=REPLACE Note: Exception messages (for example, ORA-31684: Object type VIEW:"HPSIM4"."R_MEDIAACCESSDEVICES" already exists) are generated to remind you that certain object types are already present. The views are not affected. 14.
PAGE 12
For more information For additional information, visit www.hp.com/go/hpsim. Technology for better business outcomes © Copyright 2010, 2012 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.