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

19
Figure 9: Set Oracle database name
2. Enter the exp command and press Enter to accept the database backup.
Table 2 lists the Oracle parameters that are listed and the recommended action.
Table 2: Oracle Database parameters for Backup
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.
Array fetch Buffer size
Click Enter to select default of 4096.
Export file BACKUP.DMP Enter the file name and the path to dump the database.
<Path\backup.dmp>
Note: If a path is not provided, the .dmp file is placed
under the users home directory.
1) E(ntire) Database Type E and press Enter.
2) U(sers)
3) T(ables)
Export Grants (Yes/No)
Press Enter to select Yes.
Export Table Data (Yes/No)
Press Enter to select Yes.
Compress Extents (Yes/N0)
Press Enter to select Yes.