Backing up and restoring HP Systems Insight Manager 6.3 database in a Windows Environment

23
Figure 12: Set database name
2. Type the command imp and press Enter. Table 4 lists the Oracle database parameters that are
offered and the recommended action to take.
Table 4: Oracle Database parameters for Restoration
Parameter Action
Username Enter the username of database and click Enter. (The
Database user name used to install HP SIM).
Password Enter the password of the database user and click Enter.
Export file BACKUP.DMP Enter the file name and the path to dump the database
<Path\backup.dmp> to restore and press Enter.
Insert Buffer size
Press Enter to select the default 30720.
List contents of import Press Enter to select No.
file only (Yes\No)
Ignore create error due to
Object existence (Yes/No) Select Yes and press Enter.
Import Grants (Yes/N0) Press Enter to select Yes.
Import Table Data (Yes/No)
Press Enter to select Yes.
Import Entire export file
(Yes/N0)
Press Enter to select No.
Username Type the user name of the database and press Enter.
Table (T) Partition (T:P) Type the dot character (.) and press Enter to begin
Or if done (.) the database restoration.