Database Administration for Oracle

Use

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:

Tasks on Demand

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

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

New database version

Database upgrade

Start of the navigation pathhttp://service.sap.com/instguides Next navigation step Other Documentation Next navigation step Database Upgrades Next navigation step OracleEnd of the navigation path

System copy required

Database copy

Start of the navigation pathhttp://service.sap.com/instguides Next navigation step SAP NetWeaver Next navigation step SAP NetWeaver <Product> 7.1 Next navigation step InstallationEnd of the navigation path

Periodic Tasks

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

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:

More Information