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

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. Enter the following command to count the number of rows and columns in the database table to

ensure the tables are successfully restored.

select count(*) from user_tables or dba_tables similarly for views,

indexes

Note:

The count of tables, indexes, and views should be the same after

export and import.

15. Restart Systems Insight Manager service by entering mxstart. Systems Insight Manager starts and

all the data from the backup database are restored.