Prerequisites for Using the CCMS DBA Tools: Oracle (SAP Library - Computing Center Management System (BC-CCM))

Prerequisites for Using the CCMS DBA Tools: Oracle

Hardware (Tape drives and tapes):

Database backups and offline redo log backups are not interactive. When they are executed from the DBA Planning Calendar, the operator is not informed when a tape needs to be changed.

Therefore, you need one of the following:

The number of tape drives required to hold all tapes needed. The advantage of this is that BRBACKUP uses tape drives in parallel thus increasing the speed of the backup

If you start BRBACKUP and BRARCHIVE as separate actions, assign them to separate tape drives using the initialization profile init<DBSID>.sap . This allows you to use different tapes for database backups and offline redo log backups

An automatic tape changer, supported by SAPDBA. This devices changes the tapes as required by BRBACKUP and BRARCHIVE

For more information, see Initialization Profile init<DBSID>.sap, parameter descriptions for backup_dev_type and rewind_offline

Enter the tape drives to use in the BRBACKUP/BRARCHIVE initialization profile init<DBSID>.sap

For more information, see Volume Management.

R/3 System: Authorizations

To use the DBA Planning Calendar, you need authorizations for database administration and background job scheduling. The profiles S_RZL_ADMIN and S_BTCH_ALL must be entered for the administrator.

For more information, see:

Profile Maintenance (authorization object S_RZL_ADM )

Authorizations for Background Jobs

External programs must be able to run on the database server so that actions affecting the database can be executed from other application servers.

Database System / Operating System: Users and Authorizations

DBA Planning Calendar actions are executed under the authorizations of the host system user with which an R/3 application server was started. This is usually the user <SID>adm on UNIX, or SAPService<SID> on Windows NT.

The user <SID>adm or SAPService<SID> must be specified as a trusted user OPS$ in the Oracle database. Make sure this prerequisite is met. For more information, see the Oracle database documentation.

These prerequisites are normally met in the standard R/3 System.

BRBACKUP and BRARCHIVE Configuration

The backup programs BRBACKUP and BRARCHIVE use the backup parameter file init<DBSID>.sap .

If you are using different tape drives for BRBACKUP and BRARCHIVE, you must adjust the backup parameter file init<DBSID>.sap . If you are using multiple tape drives, you must also specify these in the configuration file.

Set the following parameters:

For BRBACKUP: tape_address, tape_address_rew

For BRARCHIVE: tape_address_arch, tape_address_rew_arch

If you have scheduled BRBACKUP and BRARCHIVE to start in one action, the system only uses the tape drives defined for BRBACKUP.

For more information, see Backing Up the Database in the SAP Database Administration: Oracle documentation.