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
•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
\oracle\oradata\APPIQ\archive on Microsoft Windows and $ORACLE_HOME/oradata/APPIQ/archive on UNIX systems.
HP Storage Essentials SRM 6.0 User Guide 225