Backing up and restoring HP Systems Insight Manager 7.x or greater data files in a Windows environment

White paper | HP Systems Insight Manager 7.x
20 | March 2013
Figure 18: Setting the database name
2. Enter the imp command, and then press Enter.
Table 4 lists the Oracle database parameters and the recommended actions.
Table 4. Oracle database parameters for database restoration
Parameter
Action
Username
Enter the user name of the database (the
database user name that was used to install HP
SIM), and then press Enter.
Password
Enter the password of the database user, and
then press Enter.
Import file: EXPDAT.DMP
<Path\backup.dmp>
Enter the file name and path of the location in
which you want to dump the database to restore,
and then press Enter.
Insert Buffer size
Press Enter to select 30720 (the default).
List contents of import file only (Yes/No)
Press Enter to select No.
Ignore create error due to Object existence
(Yes/No)
Select Yes, and then press Enter.
Import Grants (Yes/No)
Press Enter to select Yes.
Import Table Data (Yes/No)
Press Enter to select Yes.
Import Entire export file (Yes/No)
Press Enter to select No.
Username
Enter the user name of the database, and then
press Enter.
Table (T) Partition (T:P) Or if done (.)
Enter the dot character (.), and then press Enter to
begin the database restoration.