You need to perform various tasks to administer your Oracle database in an SAP environment.
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.
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 (Oracle)
If you have an integrated SAP environment with multiple SAP systems, you can use the Central DBA Planning Calendar.
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 |
Space Management with BR*Tools
|
|
Table or index management |
||
Performance problem |
None |
|
Access required to other systems, such as a BW source system |
None |
|
New database version |
Database upgrade |
service.sap.com/instguides ® Other Documentation ® Database Upgrades ® Oracle |
System copy required |
Database copy |
service.sap.com/nw04installation ® SAP Web AS ® SAP Web AS 6.40 SR1 Installation and Related Documentation ® Homogeneous and Heterogeneous System Copy |
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 |
· Run database system check · Run database backup · Monitor the Oracle database and check for alerts: ¡ Database Backup and Restore Alerts · Check the results of actions in the DBA Planning Calendar – daily task with Oracle 10g or later |
DBA Planning Calendar with a predefined action pattern |
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
See also:
· You can find full information on all aspects of Oracle DBA at:
· For more information on Oracle DBA, see:
service.sap.com/dbaora
· For more information on advanced Oracle DBA, see:
¡ Advanced Backup and Recovery
¡ Oracle Real Application Cluster
¡ SAP/Oracle Database Monitor for advanced Oracle database monitoring, also suitable to monitor an Oracle Real Application Cluster (RAC)