CommCell Console SAP Oracle Backups

Table of Contents

Full Backups

A full backup is the most comprehensive backup and is the baseline for incremental backups.

Note: When you perform an offline backup from the CommCell Console, the database is shut down by default. You can disable the forced shutdown by setting the sNOOFFLINEFORCE Additional Setting to Y.

Before You Begin

  • Configure an offline, online, datafile or log subclient for SAP Oracle.

    If the database is in NOARCHIVELOG mode, you must back up the database offline.

    If the database is in ARCHIVELOG mode and database accessibility is a priority, perform an online backup of the database.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP for Oracle > instance.
  2. Right-click the subclient and click Backup.
  3. On the Backup Options for Subclient dialog box, select the backup type and job initiation:
    1. In the Backup Type section, select Full.
    2. In the Job Initiation section, specify whether to run the backup now or if it will be scheduled.

      Note: If you selected Schedule, set up the schedule.

      For information on configuring a backup schedule, see Schedule Backups.

  4. Click OK to close the Backup Options dialog box.

Incremental Backups

An incremental backup contains the changed data from the last full backup. Incremental backups use less media and resources than full backups.

For more information on incremental backups, see Incremental Backups.

Before You Begin

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP for Oracle > instance.
  2. Right-click the subclient and click Backup.
  3. On the Backup Options for Subclient dialog box, select the backup type and job initiation:
    1. In the Backup Type section, select the backup type.
    2. In the Job Initiation section, specify whether to run the backup now or if it will be scheduled.

      Note: If you selected Schedule, set up the schedule.

      For information on configuring a backup schedule, see Schedule Backups.

  4. Click OK to close the Backup Options dialog box.

Selective Online Full Backup

You perform a selective online full backup when the database is online. A selective copy subclient includes the data, logs and control file. The advantage of a selective online full backup is that the data and logs use the same storage policy, which means that they reside on the same media and are self-contained for long-term archiving. You can use this in a disaster recovery, because you do not need to locate different media from multiple jobs to recover the database.

For more information on selective online full backups, see Selective Online Full Backups.

For information on special data aging rules for selective online full backups, see Selective Online Full Backup Retention Rules.

Before You Begin

Procedure

  • Run SAP Oracle selective online full backups from the CommCell Console by using the util_file, util_file_online and rman_util utilities.

Performing Parallel Backups with Multiple DataPaths for Load Sharing

Sometimes, the resources on a single datapath may not be enough to perform a backup job. When you configure a primary storage policy copy with multiple datapaths and perform a backup, this backup job can get the reservations from multiple datapaths that are present in the primary copy. This will share the load of your backups between multiple DataPaths.

  1. From the CommCell Console, navigate to <Client> | SAP for Oracle |<Instance>
  2. Right-click the Subclient and click Backup.
  3. Select Full as backup type and Immediate to run the job immediately.
  4. Click OK.
  5. You can track the progress of the job from the Job Controller window of the CommCell console.
  6. Right-click the client computer, click View and then click View Job History.

    Example:

    In the following image, when you right-click the Job ID 32747 and select View Media, you can view that the resources are allocated on all the 4 drives that were part of different datapaths while Configuring Multiple Data Paths for Load Sharing. This example displays that the resource allocation is performed on to different media datapaths with effective load sharing.

Example of JM Log with RM Messages enabled:

9272 e38 05/02 16:14:00 33080 Database Added new stream. (dest)RCID [53989] Reservation Id [60368] Stream Number [1] Copy Id [95] Is Primary [true] srcRCId [0] srcResvId [0] srcCopyId [0].
9272 e38 05/02 16:14:00 33080 JobSvr Obj CVBkpJobSvr::updateInfo(rcid=53989),setMediaInfo(dbserve12)
9272 14c 05/02 16:14:00 33080 Database Added new stream. (dest)RCID [53987] Reservation Id [60366] Stream Number [2] Copy Id [95] Is Primary [true] srcRCId [0] srcResvId [0] srcCopyId [0].
9272 14c 05/02 16:14:00 33080 JobSvr Obj CVBkpJobSvr::updateInfo(rcid=53987),setMediaInfo(dbserve12)
9272 e38 05/02 16:14:00 33080 Database Added new stream. (dest)RCID [53988] Reservation Id [60367] Stream Number [3] Copy Id [95] Is Primary [true] srcRCId [0] srcResvId [0] srcCopyId [0].
9272 e38 05/02 16:14:00 33080 JobSvr Obj CVBkpJobSvr::updateInfo(rcid=53988),setMediaInfo(dbserve12)
9272 14c 05/02 16:14:00 33080 Database Added new stream. (dest)RCID [53990] Reservation Id [60369] Stream Number [4] Copy Id [95] Is Primary [true] srcRCId [0] srcResvId [0] srcCopyId [0].
9272 14c 05/02 16:14:00 33080 JobSvr Obj CVBkpJobSvr::updateInfo(rcid=53990),setMediaInfo(dbserve12)
9272 e38 05/02 16:15:38 33080 Resource Removed resource user 53987
9272 e38 05/02 16:15:38 33080 Resource Removed resource user 53988
9272 e38 05/02 16:15:38 33080 Resource Removed resource user 53989
9272 e38 05/02 16:15:38 33080 Resource Removed resource user 53990

Managing Jobs

You can restart SAP Oracle backup jobs that you performed from the CommCell Console. For more information on configuring job restarttability, see Job Restartability - Advanced.

The table provides the job status for the BR*Tools error codes. The BR*Tools Error Code and Description columns are from the Messages and Return Codes for BR*Tools page on the SAP Help website.

BR*Tools Error Code Description Job Status
0 Successful Completed
1 Warnings – all files were processed (for example, backed up or restored) Completed With Warning
2 Canceled during the initialization phase by a user or other signal Completed With One or More Errors
3 Errors occurred during the initialization phase, processing was not started Completed With One or More Errors
4 Canceled by a user or other signal during processing Completed With One or More Errors
5 Started, but not completed because errors occurred during processing Completed With One or More Errors
6 Internal termination Completed With One or More Errors
9 Successful, but did not finish. Details can be seen in the summary logs that are copied to the backup media Completed With One or More Errors