Checking the Results of Actions: Oracle (SAP Library - Computing Center Management System (BC-CCM))

Checking the Results of Actions: Oracle

The CCMS offers three ways to check the results of actions:

In the DBA Planning Calendar, for all scheduled actions (described here):

The color-coding in the DBA Planning Calendar provides an overview of the status of scheduled actions.
For more detailed information about an action, display the database action log and the R/3 background job log.

Also, Displaying Backup Logs and Status: Oracle (Transaction DB12):

This provides you with three additional tasks you can execute that are not possible using the Planning Calendar. You can:

Check the status of your backups
Display all backup logs and a history of backup activity in your R/3 System.
Use these to determine whether the backups you have could be used to recover the database after a database error (Recovery report)

Use the DB Operations Monitor (Transaction DB24 ) for online monitoring of database operations within both internal and external database tools. You can also monitor runtime and remaining time of operations that are running. The DBA operations monitor can be used regardless of which database you are using. It provides historical as well as current (online) information

For more information, see Troubleshooting: Oracle

Color-coding of headers

Color-coding of headers in the DBA Planning Calendar is as follows

Background color	Text color	Meaning
Light blue	Black	There is no action scheduled for today, or no action has failed.
Dark blue	Black	At least one action failed today.
Light turquoise	Black	All actions scheduled for today completed successfully, or no action was executed.
Dark turquoise	Black	At least one action executed today failed.

Color-coding of action lines

Color-coding of action lines in the DBA Planning Calendar is as follows:

Background color	Text color	Meaning
White (light gray in the Windows NT GUI)	Black	Action scheduled for execution today.
Light gray (gray in the Windows NT GUI)	Black	Action scheduled for execution on a day in the future.
Violet	Black	The action is currently running
Green	Black	The action has been completed successfully.
Yellow	Black	The action completed successfully, but warning messages were issued.
Red	Black	Errors occurred during execution of the action, or the database action log is missing. Analyze the problem and repeat the action if necessary to ensure availability of a complete backup or continued safe operation of the database.
Gray	Red	The action was or will not be executed due to a public holiday.

Displaying the Status of an Action

Select a particular day, for which you want to display the status of an action, by double-clicking the header of the action, or the + hotspot on the header.

The system displays the status of each action. Possible statuses are as follows:

SCHED	The action has been scheduled, but the scheduled time has not yet been reached. Color: Gray
START	The action started and is still running Color: Violet
SUCC.	The action has been completed successfully. Color: Green
WARN.	The action completed successfully, but warning messages were issued. Color: Yellow
ERROR	The action has either terminated abnormally or is currently running Color: Red
UNKN.	The status of the action is unavailable Color: Red

Displaying Action Logs and Job Logs

From the DBA Planning Calendar, you can display the logs generated by Planning Calendar actions. These logs detail the results of an action. You can also display the job logs generated by the background jobs that carry out Planning Calendar activities

To determine whether a database log (action log) has been generated for a particular action, select a day by double-clicking the header for the day, or the + hotspot on the header.

The Prot.field is selected if a log was written.

To display available action logs and job logs, put the cursor on a particular day.

Choose Action logs to display a list of the database action logs generated on that day.

Choose Job logs to see the background processing job logs generated by the activities on that day.

Log and action timestamps are used to associate database logs and scheduled actions. An action log is assigned to an action that has the same type and the closest corresponding timestamp. In rare cases, this assignment method may incorrectly associate a log and an action.

For more information, see Background Processing