Backing up and restoring HP SIM 5.2 or greater data files in an HP-UX and Linux environment

ManualsBrandsHP ManualsSoftwareHP Systems Insight Manager for Windows

Backing up and restoring HP SIM 5.2 or greater data files

in an HP-UX and Linux environment

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

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

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

For more information.......................................................................................................................... 10

Summary of content (10 pages)

PAGE 1
Backing up and restoring HP SIM 5.2 or greater data files in an HP-UX and Linux environment Backing up data files for a PostgreSQL database..................................................................................... 2 Backing up data files for a PostgreSQL database ................................................................................. 2 Restoring data files for use with PostgreSQL ........................................................................................
PAGE 2
HP Systems Insight Manager (HP SIM) 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 HP SIM to operation. IMPORTANT: The procedures in this paper are for backing up and restoring HP SIM core data only from/to the same PostgreSQL database.
PAGE 3
5. Open /etc/opt/mx/config/database.props file and check the property value for hp.Database.username. The default PostgreSQL user for HP SIM is mxadmin. 6. The password generated by HP SIM for mxadmin must be changed before backing up the database. To change the password, at the HP SIM command line enter the following: /opt/mx/bin/mxpassword –m –x MxDBUserPassword=newpassword Where newpassword is the new password. 7.
PAGE 4
http://docs.hp.com/en/418810-003/index.html If you are not performing a reinstallation, proceed with the next step. 2. If HP SIM is running, enter mxstop in the command line to stop the HP SIM daemons. 3. Stop the PostgreSQL (HPSMDB) service with the stop command (full path might vary depending on the PostgreSQL install location): For HP-UX: /sbin/init.d/hpsmdb stop For SUSE Linux Enterprise Server 9 and SUSE Linux Enterprise Server 10: /etc/init.
PAGE 5
• • 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 8. Create a user named “mxadmin” (with the role superuser with no permission to create the database and user) using the following command: ./createuser –h 127.0.0.1 –p 50006 –U hpsmdb mxadmin 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.
PAGE 6
Saving data files for use with Oracle 1. If HP SIM is running, enter mxstop in the command line to stop the HP SIM daemons. 2. To verify that all HP SIM “mx” processes have stopped, run the following command: ps –ef | grep mx 3. Using the file management utility of your choice, save the configuration files listed in Table 2. Table 2.
PAGE 7
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 buffer 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) Type E and press Enter. (2) U(sers) (3) T(ables) Export grants (yes/no) Press Enter to select default of Yes.
PAGE 8
7. Restore the configuration files listed in Table 4. Table 4. Configuration files to be restored Directory or 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 you want to reinstall HP SIM) /opt/mx/bin/server_cert.pem /opt/mx/bin/CLIClientConfig.
PAGE 9
Table 5. 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. 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. EXPDAT.DMP List contents of import file only (yes/no) Press Enter to select default of No.
PAGE 10
For more information For additional information, 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. HP shall not be liable for technical or editorial errors or omissions contained herein.