V11 SP8
Loading...

Advanced Restore - FlexFrame for SAP Oracle

Table of Contents

Choosing the Restore Destination

Out-of-Place Restore

A out-of-place restore is one where you restore the data to a different directory on the same client where the data came from, or a different client. Out-of-place restores can include individual data files, tablespaces, or the entire database.

This option is only supported from the command line only.

Note: The destination client must be configured in the CommCell Console that contains the client for backed up data. The restored data has the rights (permissions) of the parent directory where you restore the data.

When you perform an out-of-place restore, the restored data assumes the rights (i.e., permissions) of the parent directory.

Example:

brrestore –d util_file –b last –m all ==/<newpath>

Restoring to a Different Client (Cross Machine Restore)

For information on how to perform a cross-machine restore, see SAP for Oracle Database Copy.

Restoring from an Online Backup

Online backups require a further roll forward operation to get them to a consistent database state.

You can recover the database to the current time if all the archived online redo logs are available, otherwise recover the database to a point-in-time.

Before You Begin

  1. Perform a full backup for SAP for Oracle on a SAP for Oracle online subclient.
  2. Set the database to the correct mode defined in the table, or set the Commvault software to automatically move the database to the correct mode before the restore.
    Control File in the Restore Required Database Mode
    Control file is included in the restore NOMOUNT
    Control file not included in the restore MOUNT
  3. If the backup you want to restore is a third party command line backup, edit the init<SID>.sap file and add the following line to set the BLKSIZE parameter to 1048576.

    RMAN_PARMS="SBT_LIBRARY=/opt/software name/Base/libobk.so,BLKSIZE=1048576,ENV=(CvClientName=sde-sap2,CvInstanceName=Instance001)"

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP for Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. On the Browse view, select the data to restore in the right pane and click Recover All Selected.
  5. Optional: Use non-default Browse and Restore options. See Browse and Restore.
  6. On the Restore Options dialog box:
    1. Select the Restore Control File check box.
    2. Select the Restore Archive Log check box.
    3. Select the Restore Data check box.
    4. Optional: Select the Recover check box to recover the database.
    5. Verify that the status of the database is STARTED. Click Refresh to refresh the status.
    6. Click Advanced.

      The Advanced Restore Options dialog box appears.

  7. To set the Commvault software to automatically move the database to the correct mode before the restore, select the Switch Database mode for Restore check box.
  8. On the Restore tab, select the restore log option.
    Expand All

    Restore all logs

    Select the All option

    Restore logs by a specific log time

    Select By Log Time and enter the Start and End time in the boxes.

    If you only specify the start log time and not the end log time, the system restores all logs from the start time to the current time.

    If the restore includes the database, restore the database to a specific point-in-time.

    Restore by specifying a serial number

    Select the By Log Serial Number option.

    Check the Start or End check boxes and enter the serial numbers.

    The following are the rules for specifying the serial number.

    • The end serial number must be greater than or equal to the start serial number
    • The start and the end serial number cannot be 0
    • The range of serial numbers restore can be from one or more backup jobs or from a part of a job and from one or more cycles
    • When you specify only the start sequence number, logs starting from that sequence number to the current sequence number are restored

    Restore logs to a different location

    Enter the new path in the Target Directory box.

  9. To set the Commvault software to automatically move the database to the correct mode before the restore, on the Options tab, select the Switch Database mode for Restore check box.
  10. Optional: Select the restore options.
    Expand All

    Validate the restore

    Validation verifies that the backup copies of the data and logs are intact and usable for restores. RMAN simulates the restore job without the media to determine whether the restore can be successfully performed.

    When a validate job is complete, you can view the job log files to identify and correct any issues.

    On the Options tab, select the Validate check box.

    Open the database after the restore

    After a restore, set the Commvault software to automatically open the database. When the database is open, it records transactions.

    On the Options tab, select the Open DB check box.

    Reset the database and logs.

    By default, the database is automatically set to open, and the logs are reset.

    If you reset the logs to an open state, you can then reset the database.

    On the Options tab, select the Reset Database check box and one of the following Reset Log options:

    • To open the database without the RESETLOGS option, select None.
    • To open the database with the RESETLOGS option, select Yes.
    • To open the database with the NORESETLOGS option, select No.

    Perform a point-in-time restore of a database that was backed up in NOARCHIVELOG mode

    If the database was backed up in NOARCHIVELOG mode, enable the redo logs.

    When the no redo log is disabled, RMAN searches archived redo logs after applying the incremental backup data during a restore. When you set No Re-do Logs, RMAN restores the data from the incremental backup and not the archived redo logs.

    On the Options tab, select the No Re-do Logs check box.

    Validate the restore

    Validation verifies that the backup copies of the data and logs are intact and usable for restores. RMAN simulates the restore job without the media to determine whether the restore can be successfully performed.

    When a validate job is complete, you can view the job log files to identify and correct any issues.

    On the Options tab, select the Backup Validations Only check box.

    Select one verification option.

    • DB Verify - The Commvault software performs a temporary database restore and then verifies the files for database block consistency.
    • RMAN Validate - The Oracle Recovery manager performs a temporary database restore and then verifies the files for database block consistency. The restored files are deleted after the verification.
    • Only Backup Inquiry - BACKINT displays the list of available backups to validate.

    Restore the control file to an alternate location

    You can use this option when the database is in the MOUNT state.

    The Commvault software restores the control file to the location you specify. The control file is not replicated to the database. You can manually replicate the files to the database.

  11. Click OK to close the Advanced Restore Options dialog box.
  12. Click OK to close the Restore Options dialog box and start the restore.

Restoring and Recovering the Entire Database

Offline backups taken after the database is cleanly shutdown, and they do not require a roll forward operation to get them to a consistent database state.

You can apply the redo log or incremental backups for the latest database changes.

Before You Begin

  1. Perform a full backup for SAP for Oracle on a SAP for Oracle offline subclient.
  2. Set the database to the correct mode defined in the table, or set the Commvault software to automatically move the database to the correct mode before the restore.
    Control File in the Restore Required Database Mode
    Control file is included in the restore NOMOUNT
    Control file not included in the restore MOUNT
  3. If the backup you want to restore is a third party command line backup, edit the init<SID>.sap file and add the following line to set the BLKSIZE parameter to 1048576.

    RMAN_PARMS="SBT_LIBRARY=/opt/software name/Base/libobk.so,BLKSIZE=1048576,ENV=(CvClientName=sde-sap2,CvInstanceName=Instance001)"

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP for Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. On the Browse view, select the data to restore in the right pane and click Recover All Selected.
  5. Optional: Use non-default Browse and Restore options. See Browse and Restore.
  6. On the Restore Options dialog box:
    1. Select the name of the client computer from the Destination Client list.
    2. Select the Restore Control File check box.
    3. Select the Restore Archive Log check box.
    4. Select the Restore Data check box.
    5. Optional: Select the Recover check box to recover the database.
    6. Verify that the status of the database is STARTED. Click Refresh to refresh the status.
    7. Click Advanced.

      The Advanced Restore Options dialog box appears.

  7. To set the Commvault software to automatically move the database to the correct mode before the restore, select the Switch Database mode for Restore check box.
  8. To set the Commvault software to automatically move the database to the correct mode before the restore, on the Options tab, select the Switch Database mode for Restore check box.
  9. Reset the database. On the Options tab, select the Reset Database check box.
  10. Optional: Select the restore options.
    Expand All

    Open the database after the restore

    After a restore, set the Commvault software to automatically open the database. When the database is open, it records transactions.

    On the Options tab, select the Open DB check box.

    Reset the database and logs.

    By default, the database is automatically set to open, and the logs are reset.

    If you reset the logs to an open state, you can then reset the database.

    On the Options tab, select the Reset Database check box and one of the following Reset Log options:

    • To open the database without the RESETLOGS option, select None.
    • To open the database with the RESETLOGS option, select Yes.
    • To open the database with the NORESETLOGS option, select No.

    Perform a point-in-time restore of a database that was backed up in NOARCHIVELOG mode

    If the database was backed up in NOARCHIVELOG mode, enable the redo logs.

    When the no redo log is disabled, RMAN searches archived redo logs after applying the incremental backup data during a restore. When you set No Re-do Logs, RMAN restores the data from the incremental backup and not the archived redo logs.

    On the Options tab, select the No Re-do Logs check box.

    Validate the restore

    Validation verifies that the backup copies of the data and logs are intact and usable for restores. RMAN simulates the restore job without the media to determine whether the restore can be successfully performed.

    When a validate job is complete, you can view the job log files to identify and correct any issues.

    On the Options tab, select the Backup Validations Only check box.

    Select one verification option.

    • DB Verify - The Commvault software performs a temporary database restore and then verifies the files for database block consistency.
    • RMAN Validate - The Oracle Recovery manager performs a temporary database restore and then verifies the files for database block consistency. The restored files are deleted after the verification.
    • Only Backup Inquiry - BACKINT displays the list of available backups to validate.

    Restore the control file to an alternate location

    You can use this option when the database is in the MOUNT state.

    The Commvault software restores the control file to the location you specify. The control file is not replicated to the database. You can manually replicate the files to the database.

  11. Click OK to close the Advanced Restore Options dialog box.
  12. Click OK to close the Restore Options dialog box and start the restore.
  13. Optional: Recover the database.

Restoring Individual Datafiles and Tablespaces

Recover a missing or corrupted datafile and tablespace when:

  • A datafile or tablespace is corrupted after you have restored the database.
  • A datafile or tablespace is the only lost data that must be restored. You can restore the datafile or tablespace instead of the entire database.

Before You Begin

  • Perform a full backup with a subclient configured for datafiles and tablespaces.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP for Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. Select Latest Backup and click View Content.
  4. In the right pane of the CommCell Browser window, select the datafiles and tablespaces to restore, and click Recover All Selected.
  5. On the Restore Options dialog box:
    1. Select the Restore Data check box.
    2. Select the Recover check box.
    3. Click Advanced.

      The Advanced Restore Options dialog box appears.

  6. On the Options tab, select the Switch Database mode for Restore check box.
  7. To set the Commvault software to automatically move the database to the correct mode before the restore, select the Switch Database mode for Restore check box.
  8. Optional: Select the restore options.
    Expand All

    Open the database after the restore

    After a restore, set the Commvault software to automatically open the database. When the database is open, it records transactions.

    On the Options tab, select the Open DB check box.

    Reset the database and logs.

    By default, the database is automatically set to open, and the logs are reset. If you reset the logs to an open state, you can then reset the database.

    On the Options tab, select the Reset Database check box and one of the following Reset Log options:

    • To open the database without the RESETLOGS option, select None.
    • To open the database with the RESETLOGS option, select Yes.
    • To open the database with the NORESETLOGS option, select No.

    Perform a point-in-time restore of a database that was backed up in NOARCHIVELOG mode

    If the database was backed up in NOARCHIVELOG mode, enable the redo logs.

    When the no redo log is disabled, RMAN searches archived redo logs after applying the incremental backup data during a restore. When you set No Re-do Logs, RMAN restores the data from the incremental backup and not the archived redo logs.

    On the Options tab, select the No Re-do Logs check box.

    Validate the restore

    Validation verifies that the backup copies of the data and logs are intact and usable for restores. RMAN simulates the restore job without the media to determine whether the restore can be successfully performed. When a validate job is complete, you can view the job log files to identify and correct any issues.

    On the Options tab, select the Backup Validations Only check box.

    Select one verification option.

    • DB Verify - The Commvault software performs a temporary database restore and then verifies the files for database block consistency.
    • RMAN Validate - The Oracle Recovery manager performs a temporary database restore and then verifies the files for database block consistency. The restored files are deleted after the verification.
    • Only Backup Inquiry - BACKINT displays the list of available backups to validate.

    Restore the control file to an alternate location

    You can use this option when the database is in the MOUNT state.

    The Commvault software restores the control file to the location you specify. The control file is not replicated to the database. You can manually replicate the files to the database.

  9. Click OK to close the Advanced Restore Options dialog box.
  10. Click OK to close the Restore Options dialog box and start the restore.

If your restore includes SYSTEM tablespaces, switch the database mode to MOUNT.

Restoring Archive Logs

You can restore archive logs separately or in addition to the database.

Restore an archive log when you are restoring any of the following data items:

  • A database to the most recent state after a database failure.
  • Logs from a specific time range that were lost due to a hard disk corruption. You can use a point-in-time option, to restore the archive logs.

Before You Begin

  1. Perform a full backup with a log file subclient.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Optional: Use non-default Browse and Restore options. See Browse and Restore.
  5. From the Browse window, select the data to restore in the right pane and click Recover All Selected.
  6. On the Restore Options dialog box:
    1. Select the Restore Archive Log check box.
    2. To restore the log files without the database, clear the Restore Data check box.
    3. Click Advanced.

      The Advanced Restore Options dialog box appears.

  7. On the Restore tab, select the restore log option.
    Expand All

    Restore all logs

    Select the All option

    Restore logs by a specific log time

    Select By Log Time and enter the Start and End time in the boxes.

    If you only specify the start log time and not the end log time, the system restores all logs from the start time to the current time.

    Restore by specifying a serial number

    Select the By Log Serial Number option.

    Check the Start or End check boxes and enter the serial numbers.

    The following are the rules for specifying the serial number.

    • The end serial number must be greater than or equal to the start serial number
    • The start and the end serial number cannot be 0
    • The range of serial numbers restore can be from one or more backup jobs or from a part of a job and from one or more cycles
    • When you specify only the start sequence number, logs starting from that sequence number to the current sequence number are restored

    Restore logs to a different location

    Enter the new path in the Target Directory box.

  8. To set the Commvault software to automatically move the database to the correct mode before the restore, select the Switch Database mode for Restore check box.
  9. Optional: Select the restore options.
    Expand All

    Open the database after the restore

    After a restore, set the Commvault software to automatically open the database. When the database is open, it records transactions.

    On the Options tab, select the Open DB check box.

    Reset the database and logs.

    By default, the database is automatically set to open, and the logs are reset.

    If you reset the logs to an open state, you can then reset the database.

    On the Options tab, select the Reset Database check box and one of the following Reset Log options:

    • To open the database without the RESETLOGS option, select None.
    • To open the database with the RESETLOGS option, select Yes.
    • To open the database with the NORESETLOGS option, select No.

    Perform a point-in-time restore of a database that was backed up in NOARCHIVELOG mode

    If the database was backed up in NOARCHIVELOG mode, enable the redo logs.

    When the no redo log is disabled, RMAN searches archived redo logs after applying the incremental backup data during a restore. When you set No Re-do Logs, RMAN restores the data from the incremental backup and not the archived redo logs.

    On the Options tab, select the No Re-do Logs check box.

    Validate the restore

    Validation verifies that the backup copies of the data and logs are intact and usable for restores. RMAN simulates the restore job without the media to determine whether the restore can be successfully performed.

    When a validate job is complete, you can view the job log files to identify and correct any issues.

    On the Options tab, select the Backup Validations Only check box.

    Select one verification option.

    • DB Verify - The Commvault software performs a temporary database restore and then verifies the files for database block consistency.
    • RMAN Validate - The Oracle Recovery manager performs a temporary database restore and then verifies the files for database block consistency. The restored files are deleted after the verification.
    • Only Backup Inquiry - BACKINT displays the list of available backups to validate.

    Restore the control file to an alternate location

    You can use this option when the database is in the MOUNT state.

    The Commvault software restores the control file to the location you specify. The control file is not replicated to the database. You can manually replicate the files to the database.

  10. Click OK to close the Advanced Restore Options dialog box.
  11. Click OK to close the Restore Options dialog box and start the restore.

Restoring Control Files

Control files are required to recover a database to the current state. Restore control files when the control file is lost and you need to restore the backup repository contained in the control file.

Configure an auto backup of control files to restore the control file from auto backup. The control file restore destroys all the previous backups.

If your database consists of multiple control files copies, you can replace a corrupted control file by manually copying an existing control file, and then restoring it.

Note: After you restore the control file, you must reset the logs before you open the database.

Before You Begin

  1. Perform a full backup with an online or offline subclient.
  2. Place the database in NOMOUNT mode, or set the Commvault software to automatically move the database to the correct mode before the restore.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Optional: Use non-default Browse and Restore options. See Browse and Restore.
  5. From the Browse window, select the data to restore in the right pane and click Recover All Selected.

    The Restore Options dialog box appears.

  6. To restore the latest backup to the same location, on the General tab, select the Restore Control File check box and click OK.
  7. For all other restore options, on the Restore Options dialog box, select the Restore Control File check box and then click Advanced.

    The Advanced Restore Options dialog box appears.

  8. On the Ctrl Files tab:
    1. Select the Restore Control File check box.
    2. Select the Restore Control File As check box.
    3. Type the full path where you want to restore the control file.
    4. Click OK to close the Advanced Restore Options dialog box.
  9. Click OK to close the Restore Options dialog box and start the restore.

What to Do Next

  1. Place the database in MOUNT mode.
  2. Perform a full database restore.

Restoring Data from a Specific Time Range

Use a point-in-time restore to revert the database to a state before an undesired transaction or before a point of failure.

Restore the control files when you restore and recover an entire database to a previous point-in-time from an online backup or offline backup to the original host.

Before You Begin

  1. Perform an online full backup if one is not available.
  2. Set the database to the correct mode defined in the table, or select the Switch Database mode for Restore check box (Options tab), to set the Commvault software to automatically move the database to the correct mode before the restore.
    Control File in the Restore Required Database Mode
    Control file is included in the restore NOMOUNT
    Control file not included in the restore MOUNT
  3. If the backup you want to restore is a third party command line backup, edit the init<SID>.sap file and add the following line to set the BLKSIZE parameter to 1048576.

    RMAN_PARMS="SBT_LIBRARY=/opt/software name/Base/libobk.so,BLKSIZE=1048576,ENV=(CvClientName=sde-sap2,CvInstanceName=Instance001)"

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP for Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. Select Latest Backup and click Time Range.
  4. Select the Absolute Time option and enter the End Time date and time.

    For Oracle agents the default Time Zone is the client's time zone. For all other agents the default Time Zone is the CommServe computer's time zone.

  5. On the Browse view, select the data to restore in the right pane and click Recover All Selected.
  6. On the General tab of the Restore Options dialog box:
    1. Select the name of the client computer from the Destination Client list.
    2. Select the Restore Control File check box.
    3. Click Advanced.

      The Advanced Restore Options dialog box appears.

  7. On the Restore tab, select the To Point-in-Time option and enter the date and time.

    Note: The selected time is specific to the CommServe computer's time zone.

  8. On the Recover tab, select the To Point-in-Time option and enter the date and time.
  9. When you restore the control file, on the Ctrl Files tab:
    • Select the Restore Control File check box.
    • Select the Point-in-Time option and enter the date and time.

      You must restore the control files to a point-in-time later than or equal to the point-in-time set in the Restore tab.

  10. When the time zone is different for the client and CommServe computer, on the Options tab, in the Time Zone box, select the time zone of the client computer.
  11. To set the Commvault software to automatically move the database to the correct mode before the restore, select the Switch Database mode for Restore check box.
  12. Click OK to close the Advanced Restore Options dialog box.
  13. Click OK to close the Restore Options dialog box and start the restore.

Recovering a Database

In certain cases, you might restore the data and then recover the database at a later point of time. To facilitate this capability, SAP Oracle iDataAgent allows you to perform a recover operation independently.

  1. From the CommCell Browser, right-click the SAP Oracle instance and select All Tasks | Browse and Restore.
  2. Click View Content.
  3. On the Restore Options dialog box, navigate to the General tab.
    • Select the name of the client computer to restore the database in the Destination Client from the list.
    • Choose the Number of streams to use for restore
    • Recover to restore and recover the database based on the criteria specified in Oracle/SAP Oracle Restore Options.
    • Verify the Status of the database is displayed as STARTED; if necessary click on the Refresh button to refresh the status.
  4. On the Restore Options dialog box, click Advanced.
  5. On the Advanced Restore Options dialog box, navigate to the Recover tab .
    • Select the Recover check box.
    • Select the Current Time to recover an entire database at the current time and to the original host or to a different host.
    • Select the Point In Time option and specify the a specific point in time to restore the database. When selected, the To Point in Time option, the backups required to restore the database to the indicated time are restored.
  6. On the Advanced Restore Options dialog box, navigate the Options tab.
    • Select the Reset Database check box
    • Select the Open DB check box to open the database after recovering the database.
    • If required set Yes for Reset Logs o reset the logs after opening the database.
  7. Click OK.

  • The system automatically resets the logs and the database. Before you can restore and recover the database to the current time, it is good practice to perform another full backup and wait for it to complete successfully.
  • Select the Reset Database check box to recover the database from an offline backup.

Scheduling a Restore

For information on how to schedule a restore, see Schedule Restores.

Third Party Command Line Restore

For information on Third Party Command Line Restores, see SAP on Oracle Restore Examples Using the BR*Tools Command Line Interface

Restoring by Jobs

The Restore By Jobs feature provides the facility to select a specific backup job to be restored. This method of restoring data is considerably faster as it reads continuously on the tape and retrieves the data and does not depend on the indexing subsystem to get the seek offsets on the media.

This feature can be used in different scenarios such as the following:

  • To restore point-in-time data associated with a specific backup job, such as full, incremental, differential, etc.
  • To restore CommServe DR data for the disaster recovery or for creating a hot-site purposes.
  • To restore multiplexed data from the same client.
Consider the following when restoring by jobs:
  • Run a restore by jobs whenever you want to restore the entire contents of the job.
  • Avoid modifying the contents of any associated subclients since this may result in the retrieval of older data.
  • Avoid running restores by jobs for jobs associated with the default subclient. If you do this, the entire contents of the computer will be restored. As such, this may cause problems (e.g., the computer might run out of space) or produce undesirable results (e.g., you might end up restoring operating system files or directories that you really do not want to restore).

Use the following steps to restore data by jobs:

  1. From the CommCell Browser, right-click the level whose data you want to browse, click View and then click Backup History.
  2. From the Backup History Filter window, select the filter options, if any, that you want to apply and click OK.
  3. From the Backup Job History window, right-click the backup job that need to be restored and select Browse and Restore.
  4. Click View Content.
  5. From the Browse window, select the required content to be restored and click Recover All Selected.
  6. Select the desired restore options and click OK.

Manage Restore Jobs

Once you initiate the restore operation, a restore 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:

Restart Jobs

Jobs that fail to complete successfully are automatically restarted based on the job restartability configuration set in the Control Panel. This configuration can be changed at any time; however, changes to this configuration will affect all jobs run in the entire CommCell.

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.

Restore jobs for this Agent are re-started from the beginning.

Configure Job Restartability at the CommServe level

  1. In the CommCell Console, click the Control Panel icon, then double-click Job Management.
  2. In the Job Restarts tab of the Job Management dialog box, select a job type from the Job Type list, and then select the Restartable check box.
  3. To change the maximum number of times the Job Manager will try to restart a job, select a number in the Max Restarts box.
  4. To change the time interval between attempts by the Job Manager to restart the job, select a number of minutes in the Restart Interval (Mins) box.
  5. Click OK to save your changes.

Configure Job Restartability for an Individual Job

  1. From the Restore Options dialog box, click Advanced, then select the Job Retry tab and specify the following as desired:
    • Total Running Time - The maximum elapsed time, in hours and minutes, from the time that the job is created.
    • Number of Retries - The number of times that Job Manager will attempt to restart the job.
    • Kill Running Jobs When Total Running Time Expires - Option to kill the job when the specified Total Running Time has elapsed, even if its state is "Running".
  2. Click OK.

Resubmit Jobs

If a restore job fails to complete successfully, you can resubmit the job without the need to reconfigure the original job's restore options using the Resubmit Job feature. When a job is resubmitted, all the original options, restore destinations, and other settings configured for the job remain in tact.

Resubmit a Restore Job

  1. From the CommCell Browser, right-click a client computer whose data recovery history you want to view, click View, then click to view a job history.
  2. From the Job History Filter dialog box, select Restore.
    • If you want to view more advanced options for restores, from the Job History Filter, select Restore, then click Advanced.
    • From the Data Recovery History Advanced Filter select the destination client computer of the restores you would like to view, then click OK.
  3. The system displays the results of the options you selected in the Data Recovery Job History window.
  4. Right-click on any job, and select Resubmit.
  5. Select the job options.
  6. Click OK.

Control 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. Only preemptible jobs can be suspended.
Resume Resumes a job and returns the status to Waiting, Pending, Queued, or Running depending on the availability of resources or the state of the operation windows and activity control settings.

Restore jobs for this Agent are resumed from the beginning.

Kill Terminates a job.

These controls can be applied to:

  • All jobs in the Job Controller.
  • All selected jobs in the Job Controller providing you have the correct security associations at the proper level for each job selected.
  • All data protection operations running for a particular client or client/agent.
  • All data protection operations running for a particular MediaAgent.

Control a Job

  1. From the Job Controller of the CommCell Console, right-click the job and select Kill, Suspend, or Resume as desired.
    • When killing a job:

      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.

    • When suspending a job:

      The job status may change to Suspend Pending for a few moments while the operation completes. The job status then changes to Suspended.

    • When resuming a job:

      As the Job Manager attempts to restart the job, the job status changes to Waiting, Pending, or Running.

Job Status

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