V11 SP8
Loading...

Advanced Backup - FlexFrame for IntelliSnap 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.

Optimizing IntelliSnap Backup

Each IntelliSnap backup job snaps many volumes that are used for data, archive logs, detail and summary files, database init files. A large number of IntelliSnap backup jobs can use the snap data reserve. Use the CV_SAP_SNAP_BKP_OPTIMIZE additional setting to reduce the total number of snapshots per job.

The following table shows the snapshots of volumes with this additional setting for Online backups. The following paths are assumed to be the default locations.

Snapshots of volumes without the setting Snapshots of volumes with the setting
Data detail and summary files location - $SAPDATA_HOME<SID>\sapbackup Data detail and summary files location - $SAPDATA_HOME<SID>\sapbackup
DATA directory - $SAPDATA_HOME<SID>\sapdata DATA directory - $SAPDATA_HOME<SID>\sapdata
Log detail and summary files location - $SAPDATA_HOME<SID>\saparch Log detail and summary files location - $SAPDATA_HOME<SID>\saparch
Logs directory - $SAPDATA_HOME<SID>\saparch Logs directory - $SAPDATA_HOME<SID>\saparch
Database Init files - $SAPDATA_HOMEdbs NOT SNAPPED
Space reorg file - $SAPDATA_HOME<SID>\sapreorg NOT SNAPPED
Ctrl file -  $SAPDATA_HOME<SID>\sapbackup Ctrl file -  $SAPDATA_HOME<SID>\sapbackup

The following table shows the snapshots of volumes with this additional setting for offline backups.

Snapshots of volumes without the setting Snapshots of volumes with the setting
Data detail and summary files location - $SAPDATA_HOME<SID>\sapbackup Data detail and summary files location - $SAPDATA_HOME<SID>\sapbackup
DATA directory - $SAPDATA_HOME<SID>\sapdata DATA directory - $SAPDATA_HOME<SID>\sapdata
Log detail and summary files location - $SAPDATA_HOME<SID>\saparch Log detail and summary files location - $SAPDATA_HOME<SID>\saparch
Logs Directory - $SAPDATA_HOME<SID>\saparch Logs Directory - $SAPDATA_HOME<SID>\saparch
Redo logs directory -  $SAPDATA_HOME<SID>\origlog*  $SAPDATA_HOME<SID>\mirrlog* Redo logs directory -  $SAPDATA_HOME<SID>\origlog*  $SAPDATA_HOME<SID>\mirrlog*
Database Init files - $SAPDATA_HOMEdbs NOT SNAPPED
Space reorg file - $SAPDATA_HOME<SID>\sapreorg NOT SNAPPED
Ctrl file -  $SAPDATA_HOME<SID>\sapbackup Ctrl file -  $SAPDATA_HOME<SID>\sapbackup

Procedure

  1. From the CommCell Browser, right-click the client, and then click Properties:

    The Client Properties dialog box is displayed.

  2. On the Additional Settings tab, click Add.

    The Add Additional Settings dialog box is displayed.

  3. Enter the details for the additional setting:
    1. In the Name box, type CV_SAP_SNAP_BKP_OPTIMIZE.
    2. In Category box, select Sap.
    3. In the Type box, select String.
    4. In Value box, type Y.
    5. Click OK to close the Add Additional Settings dialog box.
  4. Click OK to close the Client Properties 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

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. Verify that the IntelliSnap check box is selected in the CommCell Console, at the client level and the instance level. For additional information, see IntelliSnap - Getting Started - Configuration.

For information on how to perform third part command line backups, see SAP on Oracle Backup Examples Using the BR*Tools Command Line Interface

Managing Jobs

For information on how to manage the job, see Job Controller Overview.

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