SAP Database Guide: Oracle (BC-DB-ORA-DBA) (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

SAP Database Guide: Oracle (BC-DB-ORA-DBA)

Purpose

This component lets you administer your Oracle database with the SAP System. Read this documentation to make sure that you administer your database as efficiently as possible, which helps your company get the most from its SAP System.

SAP provides the following database administration (DBA) tools for this purpose:

BRBACKUP, BRARCHIVE, BRRESTORE, and BRCONNECT

SAPDBA

Recommendation

BRCONNECT was originally only a utility tool. Now you can also start it from the command line and it has taken over some of the functionality of SAPDBA. Therefore, certain SAPDBA functions are no longer being developed.

We strongly recommend you to use BRCONNECT rather than SAPDBA where the two tools perform the same tasks.

Implementation Considerations

For more information if you are new to Oracle database administration with the SAP System, see Getting Started with Oracle and the SAP System.

For more information about installing the Oracle database with an SAP System, see the documentation at http://service.sap.com/instguides.

Features

SAP DBA tools can perform the following important functions:

Backup, restore, and recovery

Database system check with BRCONNECT

Reorganization with SAPDBA

Update statistics for the cost-based optimizer

For more information about new features in this release, see New Features in SAP Release 6.20.

Constraints

Caution

Be sure to use the SAP tools SAPDBA, BRBACKUP, BRARCHIVE, BRRESTORE, and BRCONNECT in accordance with your conditions of use of the SAP System and other SAP products.