Setting Up the DBA Planning Calendar (Oracle) 
You need to set up the DBA Planning Calendar because – when you start your system for the first time – there are no actions planned. For this you need to do the following:
The most important thing when setting up the DBA Planning Calendar is to choose a pattern of actions covering your regular database administration (DBA) needs, specifying any required action parameters and taking account of any dependencies between actions, as described in the procedure below.
Example
You set up a pattern to do the following:
Check and update database statistics daily at 05:00.
Check database daily at 06:00.
Back up the database online and the logs daily at 22:00.
Clean up logs weekly at 07:00 on Sunday.
The DBA Planning Calendar offers you a number of preselected patterns, which you can later edit as required.
Caution
Some of the actions available have an impact on database performance and availability. Check the start and end times of scheduled actions to make sure that they do not impact each other and that they do not impact other activities in your system.
You cannot perform all required DBA actions from the DBA Planning Calendar or the DBA Cockpit. For more information on actions that you must perform with the SAP system down, such as offline database backup, see the SAP Database Administration Guide for your database
You can schedule the following actions with the DBA Planning Calendar:
Tasks |
Actions |
|---|---|
Database backup and recovery |
Whole database offline + redo log backup |
Whole database online backup |
|
Whole database offline backup |
|
Whole database online + redo log backup |
|
Full database offline + redo log backup |
|
Full database online backup |
|
Full database offline backup |
|
Full database online + redo log backup |
|
Incremental database offline + redo log backup |
|
Incremental database online backup |
|
Incremental database offline backup |
|
Incremental database online + redo log backup |
|
Partial database offline backup |
|
Partial database online |
|
Prepare for RMAN Backup |
|
Redo log backup |
|
Space Management |
Adapt next extents |
Compress database |
|
Other |
Check database |
Check and update optimizer statistics |
|
Cleanup logs |
|
Initialize tape |
|
Validate structure |
|
Verify database |
|
Central Calendar Log Mirror |
Check the following before you start using the DBA Planning Calendar:
SAP system authorizations
Check that you have authorization for DBA and background job scheduling, which is provided by profiles S_RZL_ADMIN and S_BTCH_ALL.
Check that external programs are able to run on the database server so that actions affecting the database can be performed from other application servers.
Database system authorizations
Check that actions requiring authorization to connect to the database are permitted. Some actions, such as online backup, require higher levels of authorization.
Before scheduling database backups, see the information on how to back up the database in the SAP Database Administration Guide for your database.
Hardware and backup media
Check that you have enough hardware (such as tape drives) and backup media (such as tapes) for the backup strategy you intend to use.
You make sure that the media are initialized and ready so that the operator does not have to interrupt scheduled backup runs. For example, check that tapes are already in the specified tape drive or tape changer. You might require different tape drives for database backups and log backups.
You also need to make sure that the initialization profile for BR*Tools – init<DBSID>.sap by default – is set up correctly for backup and archiving.
Start the DBA Planning Calendar from the DBA Cockpit by choosing .
Choose Pattern Setup.
Follow the wizard to set up a pattern of recurring actions to cover your regular DBA needs.
You can navigate between the actions in the pattern by choosing Next and Previous.
When you have finished defining the pattern, choose Save on the last screen to enter the pattern into the DBA Planning Calendar.
Caution
When you start using the DBA Planning Calender in production operation, make sure that you check the results daily to make sure that actions have been executed correctly.