V11 SP8
Loading...

Advanced Backup - FlexFrame for SAP Oracle

Table of Contents

Full Backup

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 set the sNOOFFLINEFORCE Additional Setting to Y to disable the forced database shutdown.

If you use a stand-alone drive, the software prompts you to load a specific cartridge. The software automatically loads the tapes when you use a library.

A consistent online backup includes the data and the offline redo logs that are generated during the data backup. When you perform a backup on a consistent online data subclient, the data is consistent because the offline redo log files created by BRBACKUP backed up with the database files on the same volume. The logs that are part of the consistent online backup are part of the data backup and included in the BRBACKUP summary file.

Before You Begin

If the database is in NOARCHIVELOG mode, you must create an offline subclient.

If the database is in ARCHIVELOG mode and database accessibility is a priority, create an online or consistent online subclient.

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 Full option.
    2. In the Job Initiation section, choose to run the backup now or schedule it.

      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, choose Incremental.
    2. In the Job Initiation section, choose to run the backup now or schedule it.

      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 can use the selective copy of a full backup to make copies of the backup using an auxiliary copy operation. The selective copy advantages include:
  • The data and log backups use the same storage policy and reside on the same media.
  • The data and log backups use the same selective online full backup data aging rules. For more information on selective copies, see Secondary Copy (Selective Copy).

Selective online full backup jobs include complete and up-to-date data because of the following built-in job management features.

  • Currently running SAP for Oracle backup jobs must complete before the selective online full backup job begins.
  • During the data backup phase of a selective online full backup job, the only other Oracle data backup jobs that are allowed to run on the same instance are archive log backups. The log backup jobs are forced to use the selective online full backup storage policy.
  • During the log backup phase of a selective online full backup, no other Oracle data or log backup jobs can run on the same instance. New jobs started on the instance are queued in the Job Controller until the selective online full backup job is completed.
  • If a selective online full backup is restarted during a currently running selective online full backup, the current job restarts from the beginning of the phase. For example, if a selective online full backup job goes to the pending state during the data phase, when restarted, the job starts from the beginning of the data phase.

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

Before You Begin

Procedure

Expand All

UTIL_FILE

  1. Include the SelectiveOnlineFull parameter in the $ORACLE_HOME/dbs/init<SID>.utl file and set the parameter value to 1.

    Example

    SAPOracle11gr2124@saporavm2>vi initCER.utl
    numstreams
    1
    SelectiveOnlineFull
    1

  2. On the command line, type the following command to run the data backup.

    brbackup -t online -d util_file -m all -c force -u /

  3. On the command line, type the following command to run the log backup.

    brarchive –d util_file –s –c force u /

RMAN_UTIL

  1. Include the SelectiveOnlineFull parameter in the $ORACLE_HOME/dbs/init<SID>.sap file and set the parameter value to 1.

    Example

    RMAN_PARMS="SBT_LIBRARY= /Base/libobk.so,BLKSIZE=1048576,ENV=(CvClientName= ,CvInstanceName= ,SelectiveOnlineFull=1)

  2. On the command line, type the following command to run the data backup.

    brbackup -t online -d rman_util -m FULL -c force -u /

  3. On the command line, type the following command to run the log backup.

    brbackup -t online -d rman_util -s -c force

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. 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

Third Party Command Line Backups

In addition to using the CommCell Console, you can also perform full and incremental backups from the Command Line Interface.

For information on how to perform command line backups, see

Managing Jobs

Once you initiate the backup operation, a backup job is generated in the Job Controller. Jobs can be managed in a number of ways. The following sections provide information on the different job management options available:

Restarting Jobs

Jobs that fail to complete successfully are automatically restarted based on the job restartability configuration set in the Control Panel.

Changes made to this configuration will affect all jobs in the entire CommCell.

To configure the job restartability for a specific job, you can modify the retry settings for that job. This will override the setting in the Control Panel. It is also possible to override the default CommServe configuration for individual jobs by configuring retry settings when initiating the job. This configuration, however, will apply only to the specific job.

Backup jobs for this Agent are resumed from the point-of-failure.

Configure Job Restartability at the CommServe Level

  1. From the CommCell Console ribbon, click the Home tab, and then click Control Panel.
  2. Under Data, click Job Management.

    The Job Management dialog box appears.

  3. Click the Job Restarts tab.
  4. From the Job Type list, select the appropriate item.
  5. Select the Restartable check box to make the job restartable.
  6. In the Max Restarts box, change the maximum number of times the Job Manager will try to restart a job.
  7. In the Restart Interval (Mins) box, change the time interval between attempts for the Job Manager to restart the job.
  8. Click OK.

Configure Job Restartability for an Individual Job

  1. From the CommCell Console, navigate to <Client> | SAP for Oracle | <Instance>
  2. Right-click the Subclient and select Backup.
  1. Click Advanced.
  2. In the Advanced Backup Options dialog box, click the Job Retry tab.
  3. Select Enable Total Running Time and specify the maximum elapsed time before a job can be restarted or killed.

    Select Kill Running Jobs When Total Running Time Expires to kill the job after reaching the maximum elapsed time.

  4. Select Enable Number Of Retries and specify the number of retries.
  5. Click OK.

Controlling Jobs

The following controls are available for running jobs in the Job Controller window:

Suspend

Temporarily stops a job. A suspended job is not terminated; it can be restarted at a later time.

Resume

Resumes a job and returns the status to Waiting, Pending, Queued, or Running. The status depends on the availability of resources, the state of the Operation Windows, or the Activity Control setting.

Kill

Terminates a job.

Suspending a Job

  1. From the Job Controller of the CommCell Console, right-click the job and select Suspend.
  2. The job status may change to Suspend Pending for a few moments while the operation completes. The job status then changes to Suspended.

Resuming a Job

  1. From the Job Controller of the CommCell Console, right-click the job and select Resume.
  2. As the Job Manager attempts to restart the job, the job status changes to Waiting, Pending, or Running.

Killing a Job

  1. From the Job Controller of the CommCell Console, right-click the job and select Kill.
  2. Click Yes when the confirmation prompt appears if you are sure you want to kill the job. The job status may change to Kill Pending for a few moments while the operation completes. Once completed, the job status will change to Killed and it will be removed from the Job Controller window after five minutes.

Job Status

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

Additional Options

Several additional options are available to further refine your backup operations. The following table describes these options, as well as the steps for configuring them.
Be sure to read the overview material referenced for each feature prior to using them.

Option Description Related Topics
Data You can select transaction logging options for a backup job.
  1. From the CommCell Browser, click Client Computers | SAP For Oracle | < instance name >.The default and other subclients (if available) are displayed on the right-hand window pane.
  2. Right-click the subclient.
  3. Click Backup.
  4. Click Advanced.
  5. Click  Data.
  6. Select the desired Catalog option for transaction logging.
  7. Click OK.
 
Startup Options The Startup options facilitate the startup behavior of the backup job.
  1. From the CommCell Browser ,Click Client Computers |SAP for Oracle | <instance name> |.

    The default and other subclients (if available) are displayed on the right-hand windowpane).

  2. Right-click the subclient,
  3. Click Backup.
  4. Click Advanced.
  5. Click Startup.
    • Select Use Default Priority option to use default priority for the job.
    • Select Change priority option to change the priority for a job, between 0 (highest priority) and 999 (lowest priority).
  6. Select Start up in Suspended State option to add a level of manual control.
  7. Click OK.
Refer to Job Priority and Priority Precedence for more information.
Job Retry Options Job Retry options enable you to configure the retry behavior of the backup jobs.
  1. From the CommCell Browser, click Client Computers | SAP For Oracle | < instance name >. The default and other subclients (if available) are displayed on the right-hand window pane.
  2. Right-click the subclient.
  3. Click Backup.
  4. Click Advanced.
  5. Click Job Retry Options.
  6. Select Enable Total Running Time.
  7. Select Enable Number of Retries option to select number of times the Job Manager will attempt to restart the job.
  8. Select Kill Running Jobs When Total Running Time Expires option to kill the job when the specified Total Running Time has elapsed.
  9. Click OK.
Refer to the Job Management documentation for a comprehensive overview prior to using these features
Media Options You can start the backup operation in a new media.
  1. From the CommCell Browser, click Client Computers | SAP For Oracle | < instance name >. The default and other subclients (if available) are displayed on the right-hand window pane.
  2. Right-click the subclient.
  3. Click Backup.
  4. Click Advanced.
  5. Click Media.
  6. Select Start New Media to start archive operation on a new media.
  7. Select Mark Media Full on Success to mark this media full after the completion of the backup operation.
  8. Select Infinite under Extend Job Retention to retain this job indefinitely.
  9. Select Number of Days to specify the number of days after which this job will be pruned.
  10. Select Storage Policy Default to apply the retention rules of the associated storage policy.
  11. Click OK.
Refer to Creating an Exportable Media Set  and Start New Media for more information.
Allow Other Schedules To Use Media Set This options allows jobs that are part of a schedule policy or schedule and using a specific storage policy to start a new media and also prevent other jobs from writing to the set of media. This option is available only when Start New Media and Mark Media Full options are enabled.
  1. From the CommCell Browser, click Client Computers | SAP For Oracle | < instance name >. The default and other subclients (if available) are displayed on the right-hand window pane.
  2. Right-click the subclient.
  3. Click Backup.
  4. Click Advanced.
  5. Click Media.
  6. Select Allow other Schedules to use the Media Set.
  7. Click OK.
 
Data Path Options Data Protection operations use a specific data path (Library, MediaAgent, Drive Pool, and Drive) to perform the backup operations as configured in the CommCell. By default, the system automatically identifies the data path for the backup operations.
  1. From the CommCell Browser, click Client Computers | SAP For Oracle | < instance name >. The default and other subclients (if available) are displayed on the right-hand window pane.
  2. Right-click the subclient.
  3. Click Backup.
  4. Click Advanced.
  5. Click Data Path.
  6. Select Use MediaAgent and Use Library or Use Drive Pool and Use Drive from the respective drop-down combo boxes.
  7. Click OK.
Refer to Change Data Path for more information.
Vault Tracker The Vault Tracker feature provides the facility to manage media that are removed from a library and stored in offsite locations.
  1. From the CommCell Browser, click Client Computers | SAP For Oracle | < instance name >. The default and other subclients (if available) are displayed on the right-hand window pane.
  2. Right-click the subclient.
  3. Click Backup.
  4. Click Advanced.
  5. Click Vault Tracking.
  6. Select the desired option.
  7. Click OK.
Refer to Vault Tracker documentation for a comprehensive overview prior to using this feature.
Alerts You can configure alerts for a specific backup job.
  1. From the CommCell Browser, click Client Computers | SAP For Oracle | < instance name >.The default and other subclients (if available) are displayed on the right-hand window pane.
  2. Right-click the subclient.
  3. Click Backup.
  4. Click Advanced.
  5. Click Add Alert and it opens Add Alert Wizard window.
  6. From the Add Alert Wizard window, select the Threshold and Notification Criteria.
  7.  Click Next.
  8. Select the Notification Types and Click Next.
  9. Select the Users and User Groups and  Click Next.
  10. Click Finish.
Refer to Alerts and Notifications for more information.