Database Administration for Oracle 

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 (Oracle)

If you have an integrated SAP environment with multiple SAP systems, you can use the Central 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	Instance Management with BR*Tools	Instance Management
Database failure with data loss	Restore and Recovery with BR*Tools	Restore and Recovery
Tablespace or data file management	Space Management with BR*Tools	Space Management
Table or index management	Segment Management with BR*Tools	Segment Management
Performance problem	Maintain Database Parameters	None
Access required to other systems, such as a BW source system	Maintain Database Connection Information	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

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	·        Run database system check ·        Run database backup ·        Monitor the Oracle database and check for alerts: ¡        Space Management Alerts ¡        Database Performance Alerts ¡        Database Backup and Restore Alerts ¡        Database Consistency Alerts ¡        Database Health Alerts ·        Check the results of actions in the DBA Planning Calendar ·        Run update statistics – daily task with Oracle 10g or later	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

 

See also:

·        You can find full information on all aspects of Oracle DBA at:

SAP Database Guide: Oracle

·        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)