5.Click the
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 206.
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 206.
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 212 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 206.
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.
Storage Essentials 5.00.01 User Guide 211