Backing Up with R/3 

Use

In the R/3 System, you can use the CCMS DBA Planning Calendar to schedule backups of the database or transaction log. SAP recommends that you use the Planning Calendar to schedule all regular backups that are part of your overall backup strategy. The calendar offers two approaches:

A backup that has been scheduled in the CCMS Planning Calendar is displayed in the Job List of the Enterprise Manager. However, a backup that has been scheduled in the Enterprise Manager is not visible in the Planning Calendar.

Procedure

Scheduling Backups Manually

  1. To access the Planning Calendar in R/3, choose Administration ® CCMS ® DB Administration ® DBA Planning Calendar
    Alternatively enter the transaction code DB13.

    2. The Planning Calendar is displayed.

  2. Double-click on the header of the day on which you want to schedule a backup.

    3. If actions have already been scheduled on the chosen day, these are displayed.
    If not, a list of the actions available for scheduling is displayed.

  3. Choose either Full Database Backup or Transaction Log Backup from the list of actions. Specify a Start time for the backup. In the Period field, specify the time interval in which the backup is to be repeated.
    If actions have already been planned on the chosen day, you have to choose the Insert button before you can access the list of available actions.
  4. Now a series of dialog boxes appears requiring you to enter a number of technical details. Depending on whether you are backing up an entire database or only the transaction log, the entries required are different.

    5. Entire Database

    Dialog Box

    Entry

    Database Selection

    Choose the databases you wish to back up.

    Backup Device Selection

    Select the backup device that the backup will be written to. Generally the default device R3DUMP0 is the correct entry here.

    Details for Tapes

    Unload Tape
    The tape is automatically unloaded

    Initialize Tape
    The existing contents of the tape are overwritten.

    Verify backup
    Ensures that all files that have just been written are readable.

    Format tape
    Formats the tape so that the existing contents and header is deleted

    Expiration Period
    Accept the default value of 28 days, if you are performing the backup in the framework of the overall backup strategy recommended by SAP. Otherwise enter a different value.

     

    Transaction Log

    Dialog Box

    Entry

    Backup Device Selection

    Select the device that the backup will be written to. Generally the default device
    R3DUMP0 is the correct entry here.

    Log Backup Tape Options

    Accept the expiration period of 28 days, if you are performing the backup in the framework of the overall backup strategy recommended by SAP.

    Verify backup
    Ensures that all files that have just been written to the backup device are readable. Always choose this option.

    If you want to write multiple log backups of one day to a single tape, set the following options:
    1st backup: Select Initialize Tape and deselect Unload tape
    Intermediate backups: Deselect Initialize Tape and Unload Tape.
    Last backup: Select Unload Tape and deselect Initialize Tape.

    If you assume that the backup of the database will not fit on one tape, you need to perform a parallel backup. Prerequisite is that you have installed a second tape device. Select both available devices in the Backup Device dialog box. The backup will automatically be written to both selected tapes in parallel.

  5. When you have completed the above steps, the backup is scheduled to run on the chosen day of the week at the specified weekly intervals. To run the backup on every day of the week, repeat the scheduling process for all the remaining days of the week.
  6. Before the scheduled backup starts, make sure that the correctly labeled tape volume is inserted in the device. The Planning Calendar automatically assigns the volume a label that complies with SAP naming conventions.

See also:

Backup Device Management

To find out which label has been assigned to a volume, double-click on the header of the day when the backup is scheduled. In the window that appears, select the backup in question and choose Volumes Needed.

The backup device and the name assigned to the tape volume are displayed.

If you wish to modify a backup scheduled in the Planning Calendar, do so within the Planning Calendar and not within the Enterprise Manager. Modifications made within the Enterprise Manager are not visible within the R/3 Calendar.

Scheduling Backups with Planning Patterns

  1. To access the Planning Calendar in R/3, choose Administration ® CCMS ® DB Administration ® DBA Planning Calendar.
    Alternatively enter the transaction code DB13.

    2. The Planning Calendar is displayed.

  2. Choose Planning ® Planning Pattern.

    3. A dialog box with a planning pattern appears.

  3. Depending on the backup strategy you have decided to implement, choose the pattern.

    4. 5 workdays, DB backup + hourly log backup (8am - 6pm) + Monthly Check DB

  4. When you have selected the pattern, you are prompted to enter a time for the daily database backups. All other backups that are part of the pattern are scheduled on the basis of this time.

    5. The planning pattern will only be applied, if there are no collisions with existing tasks scheduled at the same time.
    All the backups that are scheduled are subsequently displayed in the calendar.

  5. Check whether the parameter values that have been automatically set for the scheduled backups meet your requirements. To view the predefined parameters, double-click on the header of the relevant day in the calendar. A list of all the activities scheduled on the chosen day appears. Mark the action for which you wish to check the parameters and then select Parameters.

A sequence of dialog boxes appears showing the parameter values that have been set. Confirm each dialog box with OK in order to proceed to the next one.

For more information, see Working with the R/3 Planning Calendar