Using the DBA Planning Calendar: Oracle (SAP Library - Computing Center Management System (BC-CCM))

Using the DBA Planning Calendar: Oracle

The DBA Planning Calendar is used to automate database administration. This includes implementing, executing and checking actions.

You can use the DBA Planning Calendar for almost all regular database administration actions. This includes tasks for which the Oracle database system must be stopped, such as offline backups.

There is a restriction on use of the DBA Planning Calendar. You can only use the DBA Planning Calendar to start actions, if the R/3 System is active and available. Tasks, such as a recovery, for which the R/3 System must be inactive, cannot be executed using the SAPDBA program.

All DBA activities which stop the database, such as offline backups, will terminate active R/3 transactions. Schedule such activities for night runs, and warn users of the interruption using Utilities: System Messages.

In all such tasks, the DBA Planning Calendar stops the database and starts the action automatically. The R/3 System is not available as long as the database is stopped. However, the R/3 System itself is not stopped. Once the database is available again, the R/3 System is automatically reconnected.

Prerequisites

Before you use the DBA Planning Calendar for the first time, check the configuration of the following:

Authorizations:
Make sure you have the required R/3 authorizations. Also, ensure that the Oracle and operating system users are set up correctly.
Alerts:
You can change the default values for backup-related alerts.
Profiles:
Ensure that the BRBACKUP and BRARCHIVE profiles are set up correctly.
Tape drives and tapes:
Ensure that the required tape drives are available, and the required tapes are initialized.

For more information, see Prerequisites for Using the CCMS DBA Tools: Oracle

Procedure

Start the DBA Planning Calendar
Choose Tools ® CCMS ® DB administration ® DBA Planning Calendar (or call Transaction DB13 ).

Use a predefined action pattern for database administration
Choose Calendar ® Action pattern

An action pattern implements a backup strategy and other database administration activities that must be regularly performed. Using a pre-defined action pattern ensures you are following the SAP standards for database activities.

Once you choose a pre-defined action pattern, the system adds the corresponding activities to the DBA Planning Calendar, and plans the background jobs that will execute the activities.

For more information, see Selecting Action Patterns: Oracle

Edit the pre-defined action pattern, to make any required changes to activities or start times

For more information, see:

! Adding Actions to Planning Calendar (Oracle)

! Editing/Deleting Actions (Oracle)

Analyze the DBA Planning Calendar
Check the calendar daily to be sure that scheduled activities have been executed correctly.

Here is a suggested cycle of activities for using the Calendar:

Daily:

Start the Planning Calendar and check that the actions scheduled for the previous day were executed successfully.

For more information, see Checking the Results of Actions: Oracle

Also choose Environment ® Backup logs to verify that your backups are adequate for a database recovery.

For more information, see Displaying Backup Logs and Status: Oracle

Make sure that the tapes for the next scheduled backup are installed, initialized and ready to go.

To determine which tapes are required for the next data backup and offline redo log backup, choose the Tapes needed function in the Planning Calendar.

This function always displays the information for the next database backup or offline redo log backup, but not the information for completed or future actions.

As required:

Warn users before an offline backup. Transactions active in the R/3 System are canceled when the backup starts.
For more information, see Utilities: System Messages

If any action did not run successfully, analyze the problem and repeat the action if necessary.
For more information, see Troubleshooting: Oracle

For more information about the DBA Planning Calendar, see:

SAP/Oracle DBA in CCMS

This gives you an overview of CCMS database administration tools.

BC – SAP Database Administration:Oracle

This gives you an overview of the SAPDBA program for managing Oracle databases.