Database Administration for Oracle

Show TOC

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.

Tasks on Demand

The table below shows tasks that you need to perform when required:

Example Example

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.

End of the example.

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	http://service.sap.com/instguides Other Documentation Database Upgrades Oracle
System copy required	Database copy	http://service.sap.com/instguides SAP NetWeaver SAP NetWeaver <Product> 7.1 Installation

Periodic Tasks

The table below shows tasks that you need to perform periodically:

Note Note

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.

End of the note.

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 Displaying the Status of a Day's Actions 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

More Information

You can find full information on all aspects of Oracle DBA at:
SAP Database Guide: Oracle
For more information about Oracle DBA, see:
www.sdn.sap.com/irj/sdn/ora
For more information about 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)