You need to perform various tasks to administer your Oracle database in an SAP environment.
Getting Started
If you are new to the Oracle database, see Getting Started with Oracle and the SAP System.
For information on the concepts behind Oracle database administration (DBA), see Approach to Oracle DBA.
Tools
You can use the following SAP tools for Oracle DBA:
BR*Tools for Oracle DBA (outside the SAP system)
Other Tools for Oracle DBA (outside the SAP system)
CCMS: Oracle (in the SAP system), including the DBA Planning Calendar.
Tasks on Demand
The table below shows tasks that you need to perform when required:
If you see a space management alert (see below in Periodic Tasks), indicating that your tablespaces are running out of space, you perform space management to correct the problem.
Reason |
Task |
More Information |
---|---|---|
Database start or stop |
||
Database failure with data loss |
||
Tablespace or data file management |
||
Table or index management |
||
Performance problem |
None |
|
New database version |
Database upgrade |
|
System copy required |
Database copy |
|
Periodic Tasks
The table below shows tasks that you need to perform periodically:
Whenever possible, use the DBA Planning Calendar for these tasks.
You can choose from a range of predefined action patterns that include the tasks listed here.
Frequency |
Task |
Recommended Tool |
---|---|---|
Daily |
|
DBA Planning Calendar with a predefined action pattern |
Troubleshooting
The following problems are the most common in an Oracle environment:
Archiver stuck- for more information, see Backup and Database Copy with BR*Tools
Online backup crashed - for more information, see Fixing an Online Backup Crash
Tablespace full - for more information, see Extending a Tablespace with BR*Tools
You can find full information on all aspects of Oracle DBA at:
For more information about Oracle DBA, see:
For more information about advanced Oracle DBA, see:
SAP/Oracle Database Monitor for advanced Oracle database monitoring, also suitable to monitor an Oracle Real Application Cluster (RAC)