HP Storage Essentials V5.1 User Guide First Edition (T4283-96026, August 2006)

Storage Essentials 5.1 User Guide 237
5. Click the Re-initialize Database button.
Resetting the Temp and Undo Tablespace
The temporary and undo tablespace may grow large due to high database activity. You should
regularly reset the temp and undo tablespace to its initial value, as described in this section.
To reset the tablespace:
1. Access the Database Admin Utility as described in ”Accessing the Database Admin Utility” on
page 232.
2. Click Reset Temp Tablespace in the left pane.
3. Type the SYS password in the SYS Password field.
4. Click the Reset Temp Tablespace button.
Restarting the Database
You may sometimes need to restart the AppIQ instance of the database. Use this feature in the
Database Admin Utility when the database is down or you need to shutdown and then start the
database.
To restart the database:
1. Access the Database Admin Utility as described in ”Accessing the Database Admin Utility” on
page 232.
2. Click Restart Database Server in the left pane.
3. Type the SYS password in the SYS Password field.
4. Click the Restart Database Server button.
Restoring a Cold Backup
If you performed an RMAN cold backup, follow the steps in this section to restore the RMAN cold
backup. You can only perform a cold backup if you selected Disable Database Archive Mode
and RMAN Backup. See ”Setting the Archive Mode” on page 238 for information about
changing the archive mode. The backup is referred to as being “cold” because the management
server is not running while the backup is occurring.
To restore a cold backup:
1. Access the Database Admin Utility as described in ”Accessing the Database Admin Utility” on
page 232.
2. Click Restore Cold Backup in the left pane.
3. Click the Browse button.
4. In the File Name field, provide a directory path containing the cold backup (may automatically
be populated in some Web browsers), but do not provide a file name. In this release the cold
backup is saved in the COLDBACKUP directory in the path specified by the person who did the
cold backup. The RMAN backup consists of several files. The Database Admin Utility
automatically notices the backup files in the directory provided.
5. Type the password of the SYS account.