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

• 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.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.props
file and find the property value for the hp.database.portNumber property.)
insight_v1_0 = HP SIM database name (To find the database name, open the
/etc/opt/mx/config/database.props file and find the property value for the
hp.Database.databaseName property.)
saveHPSIMdb = the file name of the backup file to restore (this name is what you used when
backing up the database)
Using an appropriate file management utility, restore the configuration files listed in
Table 1. Configuration files that must be backed up
10. .
11. Restore any existing user-supplied (custom) files contained in the HP SIM directory tree, such as
TDEFs, MIBs, sign-in prompts, and actions.
12. Restart the HP SIM service with the mxstart command. The service is started and the data from
the backup database is restored.
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 with HP SIM. A user with Oracle Database Administrator (DBA) privileges must
conduct the backup and restore processes.