HP Storage Essentials Enterprise Edition Software - Manual (Page 263)

HP Storage Essentials SRM 6.0 User Guide 225
8 Database Maintenance and Management
This chapter contains information about backing up and restoring the database using the Database
Admin Utility.
This chapter contains the following topics:
• Database Maintenance Window , page 225
• Overview of Backups , page 226
• Database Mode , page 228
• Architectural Overview of RMAN Backups , page 229
• Performing an RMAN Hot Backup , page 230
• Scheduling RMAN Hot Backups , page 231
• Viewing Results from RMAN Backup , page 232
• About the Database Admin Utility , page 232
• About Database Passwords , page 244
• Troubleshooting Listener and Database Connection Problems , page 246
Database Maintenance Window
Schedule a maintenance window of two to four hours weekly during off peak hours of operation to
do the following database maintenance operation:
1. Stop the service for the management server. See ” Restarting the Service for the Management
Server ” on page 16.
2. Access the Database Admin Utility. See ” Accessing the Database Admin Utility ” on page 233
for more information.
3. Using the Database Admin Utility, verify that the database is in an open state and the listener is
running. See ” Checking the Database and Listener Status ” on page 234.
If the database state is not OPEN and shows an error, get the following logs and then contact
technical support:
• Log file for the Database Admin Utility:
%MGR_DIST%/logs/dbAdmin.log
• Database alert log, which can be found in one of the following locations:
• On Microsoft Windows: \oracle\admin\APPIQ\bdump
• On UNIX systems: $ORACLE_BASE/admin/APPIQ/bdump
4. Reset the temporary tablespace, as described in ” Resetting the Temp and Undo Tablespace ” on
page 238.
5. Export the database, as described in ” Exporting the Database ” on page 236.
6. If the database is running in archive mode, set the database to no-archive mode, as described in
” Changing the Archive Mode ” on page 240. Then, clean the
\oracle\oradata\APPIQ\archive
on Microsoft Windows and
$ORACLE_HOME/oradata/APPIQ/archive
on UNIX systems.