Veritas NetBackup™ for SAP Administrator's Guide

Last Published:
Product(s): NetBackup (8.1.1, 8.1)
  1. Introduction to NetBackup for SAP
    1.  
      About NetBackup for SAP
    2.  
      Features of NetBackup for SAP
    3.  
      Technical overview of NetBackup for SAP
    4.  
      Sequence of operation for NetBackup for SAP
    5.  
      Using NetBackup for SAP on Oracle databases without RMAN
    6.  
      Using NetBackup for SAP on Oracle databases with RMAN
    7.  
      SAP tools overview
    8.  
      NetBackup for SAP on MaxDB databases
  2. Introduction to NetBackup SAP HANA
    1.  
      About NetBackup for SAP HANA
    2.  
      NetBackup for SAP HANA databases
  3. Installing NetBackup for SAP
    1.  
      Planning the installation of NetBackup for SAP
    2.  
      Verifying the operating system and platform compatibility
    3.  
      NetBackup server and client requirements
    4.  
      SAP server software requirementsSAP server software requirements for NetBackup for SAP
    5.  
      Requirements for using NetBackup for SAP in a NetBackup cluster
    6.  
      Configuration and licensing requirements for NetBackup for SAP with Snapshot Client
    7.  
      About the license for NetBackup for SAP
    8.  
      Copying the SAP binary file (Windows Oracle databases without RMAN only)
    9.  
      Linking NetBackup for SAP with backint (UNIX or Linux Oracle databases without RMAN only)
    10.  
      Linking the Oracle instances with the SBT library (UNIX or Linux Oracle databases with RMAN only)
  4. Installing NetBackup for SAP HANA
    1.  
      Planning the installation
    2.  
      Verifying the operating system and platform compatibility for NetBackup for SAP HANA
    3.  
      NetBackup server and client requirements for NetBackup for SAP HANA
    4.  
      SAP HANA software requirements for NetBackup for SAP HANA
  5. Configuring NetBackup for SAP
    1.  
      About configuring NetBackup for SAP
    2. About configuring a backup policy for an SAP database
      1.  
        Adding a new NetBackup for SAP policy
      2.  
        About policy attributes
      3. About adding schedules to a NetBackup for SAP policy
        1.  
          NetBackup for SAP backup types
        2.  
          Configuring an application backup schedule
        3.  
          Example application backup schedule
        4.  
          Configuring automatic backup schedules
        5.  
          Example automatic backup schedule
      4.  
        About schedule properties
      5.  
        Adding clients to a policy
      6.  
        Adding NetBackup for SAP scripts to the backup selections list
      7.  
        Rules for NetBackup for SAP scripts
    3. NetBackup for SAP backup scripts
      1.  
        Modifying the NetBackup for SAP backup scripts
      2.  
        Example NetBackup for SAP backup script (Windows)
      3.  
        Example NetBackup for SAP backup script (UNIX)
      4.  
        NetBackup for SAP backup script parameters
    4.  
      Configuring the logon account for the NetBackup Client Service for NetBackup for SAP
    5. About SAP configuration files
      1.  
        Relationships between SAP database configuration files
      2.  
        Modifying the initSID.utl file for NetBackup for SAP
      3.  
        Example NetBackup for SAP initSID.utl file
      4.  
        Modifying the initSID.sap file (NetBackup for SAP Oracle databases only)
      5.  
        Example initSID.sap file (NetBackup for SAP on Oracle databases only)
      6.  
        Modifying the bsi.env file (NetBackup for SAP on MaxDB databases)
    6.  
      Backing up files mounted with LOFS with NetBackup for SAP (UNIX or Linux)
    7.  
      About permissions for NetBackup for SAP log files (UNIX)
    8.  
      Reviewing the auto-discovered mappings in Host Management
    9.  
      Configuring the Maximum jobs per client for NetBackup for SAP
    10.  
      Performing a manual backup
    11.  
      Testing multiple concurrent backup jobs for NetBackup for SAP for Oracle (without RMAN)
  6. Configuring NetBackup for SAP HANA
    1.  
      About configuring the master and the media servers
    2.  
      Configuring the media server for NetBackup SAP HANA
    3. Configuring the master server for NetBackup SAP HANA
      1.  
        Setting the logging level
      2.  
        Setting maximum jobs per client
      3.  
        Creating a backup policy for SAP HANA
      4.  
        Configuring redirected restores
    4. Configuring the NetBackup client
      1.  
        Updating the initsap.utl file
    5. Configuring the SAP HANA Agent
      1.  
        Node level configuration
      2.  
        SAP HANA backint configuration
    6.  
      Configuring SAP HANA Instance for redirected restore
  7. Performing backups and restores of SAP
    1.  
      Using NetBackup for SAP to perform a backup
    2. Using BRTools to start an SAP backup (for Oracle database only)
      1.  
        Performing an SAP offline backup with SAPDBA
      2.  
        Performing brbackup online SAP backups
    3. Performing an SAP archive
      1.  
        Using the NetBackup multiple copies feature to create an SAP archive
      2.  
        Using two brarchive commands in sequence to create an SAP archive
    4.  
      Performing SAP restores using the SAPDBA utility (SAP on Oracle databases only)
    5.  
      Redirecting a restore to a different client (SAP on Oracle databases only)
    6.  
      SAP redirected restore sample environment (UNIX)
    7.  
      Disaster recovery using BRRECOVER
    8. Restarting failed NetBackup for SAP backups and restores
      1. Restarting NetBackup for SAP backups
        1.  
          Configuring the checkpoint restart option in a NetBackup for SAP policy
        2.  
          Restarting a NetBackup for SAP backup with the brbackup -f command
        3.  
          Example: Restarting a failed NetBackup for SAP backup job (UNIX or Linux)
        4.  
          Example: Restarting a failed NetBackup for SAP backup job (Windows)
      2. Restarting SAP database restores on Oracle
        1.  
          Restarting a restore with the brrestore -f option
        2.  
          Example: Restarting a NetBackup for SAP restore job (UNIX or Linux)
        3.  
          Example: Restarting a NetBackup for SAP restore job (Windows)
  8. Performing backups and restores of SAP HANA
    1.  
      About backup and restore of SAP HANA
    2.  
      Using the SAP HANA studio for backup
    3.  
      Using the SAP HANA studio for restore
    4.  
      Using SAP HANA studio for SAP HANA instance redirected restore
  9. NetBackup for SAP with Snapshot Client
    1.  
      NetBackup for SAP with Snapshot Client overview
    2.  
      Using NetBackup for SAP with Snapshot Client to back up large databases
    3. How the NetBackup for SAP Snapshot Client works
      1.  
        How NetBackup for SAP performs a split mirror backup using backint
      2.  
        How NetBackup for SAP performs a split mirror backup using RMAN
      3.  
        The util_file parameter incompatible with Snapshot Client
      4.  
        About the NetBackup for SAP restore process
      5.  
        SAP database objects supported by advanced backup methods
    4.  
      Configuration requirements for snapshot backups with NetBackup for SAP
    5. About configuring Snapshot Client with NetBackup for SAP
      1.  
        Configuring a snapshot policy for NetBackup for SAP
      2.  
        About NetBackup for SAP backup types
      3.  
        Prerequisites for instant recovery backups (UNIX or Linux)
      4.  
        Configuring a snapshot policy with Instant Recovery for NetBackup for SAP
      5.  
        Additional configuration required for NetBackup for SAP with Network Attached Storage (NAS) on UNIX or Linux
      6.  
        Configuring a NAS snapshot policy for NetBackup for SAP on UNIX/Linux
    6. About configuring NetBackup for SAP block-level incremental backups on UNIX
      1.  
        How BLI works with NetBackup for SAP (UNIX)
      2.  
        About Nodata Storage Checkpoint and NetBackup for SAP
      3.  
        About Fulldata Storage Checkpoint and NetBackup for SAP
      4.  
        Storage Checkpoint configuration on the NetBackup for SAP client
      5.  
        Configuration requirements for BLI backups with NetBackup for SAP
      6. Configuring policies for BLI backups with NetBackup for SAP
        1.  
          About the types of NetBackup for SAP BLI backups
    7.  
      About restoring individual files from a NetBackup for SAP snapshot backup
    8. About NetBackup for SAP restores of volumes and file systems using snapshot rollback
      1.  
        Performing a NetBackup for SAP snapshot rollback
      2.  
        Notes on NetBackup for SAP instant recovery restores
      3.  
        Performing SAP restores of volumes and file systems using block-level restore (Unix/Linux) or Fast File Resync (Windows)
      4.  
        Troubleshooting NetBackup for SAP rollback restores
    9.  
      About NetBackup for SAP sample backup scripts (UNIX or Linux)
    10.  
      About NetBackup for SAP sample backup scripts (Windows)
    11.  
      Mixing RMAN stream and RMAN proxy NetBackup for SAP backups
    12.  
      Performing user-directed snapshot backups with NetBackup for SAP
  10. NetBackup for SAP on MaxDB databases
    1.  
      About NetBackup for SAP on MaxDB databases
    2.  
      About configuring NetBackup for SAP on MaxDB databases
    3.  
      Creating a backup medium for NetBackup for SAP
    4. Using NetBackup for SAP on a MaxDB database to perform backups and restores
      1.  
        Performing a MaxDB database backup
      2.  
        Performing a MaxDB database query
      3.  
        Performing a MaxDB database restore
      4.  
        Performing SAP backups and restores using parallel medium groups
  11. Troubleshooting NetBackup for SAP and SAP HANA
    1.  
      About troubleshooting NetBackup for SAP
    2. NetBackup debug logs and reports
      1.  
        Enabling the debug logs for a NetBackup for SAP client automatically (Windows)
      2.  
      3.  
        Enabling the debug logs manually (UNIX)
      4.  
        About the bphdb directory on the Windows database client
      5.  
        About the bphdb directory on the UNIX database client
      6.  
        About the backint directory on the UNIX database client
      7.  
        Setting the debug level on a Windows client
      8.  
        Setting the debug level on a UNIX client
      9.  
        About NetBackup server reports
    3. sapdba logs and messages (Oracle-based SAP environments only)
      1.  
        NetBackup for SAP backup and restore log files
      2.  
        NetBackup for SAP archive log files
    4.  
      Minimizing timeout failures on large database restores
    5. About troubleshooting NetBackup for SAP HANA
      1.  
        NetBackup for SAP Oracle backup fails
      2.  
        NetBackup SAP HANA backup jobs fail with error 41 and 25
      3.  
        Recovery of SAP HANA database from tape storage fails
      4.  
        Log backup fails with status 50 for SAP HANA
    6.  
      Disaster recovery of an SAP Hana database
  12. Appendix A. backint command line interface
    1. About backint command line interface for SAP
      1.  
        About the BC-BRI BACKINT Interface
    2.  
      About backint command line interface for SAP HANA
  13. Appendix B. Input and output files for SAP HANA
    1.  
      About input and output files for SAP HANA
  14. Appendix C. backint -i in_file contents
    1.  
      About backint -i in_file contents
  15. Appendix D. backint -o out_file contents
    1.  
      About backint -o out_file contents
  16. Appendix E. NetBackup for SAP environment variables for backint
    1.  
      NetBackup for SAP backint interface environment variables
  17. Appendix F. NetBackup for SAP configuration or bp.conf file settings
    1.  
      NetBackup for SAP configuration or bp.conf file settings
  18. Appendix G. Parameters used in initSID.utl
    1.  
      About parameters used in initSID.utl
    2.  
      initSID.utl parameter summary
    3.  
      backup_stream_buffersize <size>
    4.  
      client <client_name>
    5.  
      custom_sort_file <file_path>
    6.  
      drives <number_of_drives>
    7.  
      inquiry_query_period <months>
    8.  
      master_time_offset <minutes> (UNIX or Linux)
    9.  
      multistream_restore
    10.  
      policy <policy_name>
    11.  
      policy2 <policy_name>
    12.  
      restore_stream_buffersize <size>
    13.  
      retry_backup <number_of_retries>
    14.  
      schedule <schedule_name>
    15.  
      schedule2 <schedule_name>
    16.  
      server <server_name>
    17. sort_backup_type <value>
      1.  
        sort_backup_type custom
      2.  
        sort_backup_type device
      3.  
        sort_backup_type drive
      4.  
        sort_backup_type size (default)
    18. sort_restore_type <value>
      1.  
        sort_restore_type custom
      2.  
        sort_restore_type drive
      3.  
        sort_restore_type image (default)
    19.  
      switch_list <control_file_path>
    20.  
      switch_log <control_file_path>
    21.  
      switch_sem <control_file_path>
  19. Appendix H. Configuring split mirror backups
    1.  
      About configuring split mirror backups
    2.  
      Local-host snapshot method: nbu_snap (Solaris SPARC platform only)
    3.  
      Local-host snapshot method: VxVM (Solaris SPARC, HP-UX, Windows)
    4.  
      Local-host snapshot method: VxFS_Checkpoint (UNIX or Linux)
    5.  
      Off-host alternate client, FlashSnap method
    6.  
      Off-host alternate client, VVR method (Solaris SPARC, HP-UX)
    7.  
      Hardware array-based snapshot method: Hitachi Shadow Image, EMC TimeFinder, HP Business Copy (UNIX or Linux)
  20. Appendix I. Register authorized locations
    1.  
      Registering authorized locations used by a NetBackup database script-based policy

custom_sort_file <file_path>

Specify this parameter only when the sort_backup_type or the sort_restore_type parameters are set to custom.

When custom is specified, set the custom_sort_file parameter to a valid file. The file_path value must be a full path name to a custom sort file that an end user created, and it must have public permissions. The following is an example argument to the custom_sort_file parameter:

UNIX or Linux:

/usr/openv/dbext/ext/db_ext/sap/scripts/sap_custom_sort_file

Windows:

install_path\NetBackup\dbext\SAP\Samples\sap_custom_sort_file

Note:

Not applicable in MaxDB database environments or in any Oracle database environments that use RMAN.

The custom sort file must include two fields. The first field groups a set of files into a particular job. The second field is a file path name that maps the SAP backup file list to a group ID.

The following is an example of a custom sort file for Windows:

1 c:\oracle\sap\sapdata1\btabd_1\btabd.data1
1 c:\oracle\sap\sapdata2\btabi_1\btabi.data1
1 c:\oracle\sap\sapdata2\clud_1\clud.data1
1 c:\oracle\sap\sapdata1\ddicd_1\ddicd.data1
1 c:\oracle\sap\sapdata5\ddici_1\ddici.data1
1 c:\oracle\sap\sapdata4\el30cd_1\EL30cd.data1
1 c:\oracle\sap\sapdata1\el30ci_1\el30ci.data1
1 c:\oracle\sap\sapdata6\es30cd_1\es30cd.data1
1 c:\oracle\sap\sapdata2\poold_1\poold.data1
1 c:\oracle\sap\sapdata1\pooli_1\pooli.data1
1 c:\oracle\sap\sapdata4\protd_1\protd.data1
2 c:\oracle\sap\sapdata1\roll_1\roll.data1
2 c:\oracle\sap\sapdata2\sourced_1\sourced.data1
2 c:\oracle\sap\sapdata3\stabd_1\stabd.data1
2 c:\oracle\sap\sapdata2\stabi_2\stabi.data2
2 c:\oracle\sap\sapdata1\temp_1\temp.data1
2 c:\oracle\sap\sapdata4\user1d_1\user1d.data1
2 c:\oracle\sap\sapdata2\user1i_1\user1i.data1
2 c:\oracle\sap\sapdata1\system_1\system.data1
2 c:\oracle\sap\saplog1\log_g1_m1\log1_m1.dbf
2 c:\oracle\sap\saplog1\log_g2_m1\log2_m1.dbf
2 c:\oracle\sap\saplog1\log_g3_m1\log3_m1.dbf
2 c:\oracle\sap\saplog1\log_g4_m1\log4_m1.dbf
2 c:\oracle\sap\dbs\cntrlSAP.dbf

The following is an example of a custom sort file for UNIX or Linux:

1 /oracle/sap/sapdata1/btabd_1/btabd.data1
1 /oracle/sap/sapdata2/btabi_1/btabi.data1
1 /oracle/sap/sapdata2/clud_1/clud.data1
1 /oracle/sap/sapdata1/ddicd_1/ddicd.data1
1 /oracle/sap/sapdata5/ddici_1/ddici.data1
1 /oracle/sap/sapdata4/el30cd_1/EL30cd.data1
1 /oracle/sap/sapdata1/el30ci_1/el30ci.data1
1 /oracle/sap/sapdata6/es30cd_1/es30cd.data1
1 /oracle/sap/sapdata2/poold_1/poold.data1
1 /oracle/sap/sapdata1/pooli_1/pooli.data1
1 /oracle/sap/sapdata4/protd_1/protd.data1
1 /dev/rdsk/c0t4d0s6
2 /oracle/sap/sapdata1/roll_1/roll.data1
2 /oracle/sap/sapdata2/sourced_1/sourced.data1
2 /oracle/sap/sapdata3/stabd_1/stabd.data1
2 /oracle/sap/sapdata2/stabi_2/stabi.data2
2 /oracle/sap/sapdata1/temp_1/temp.data1
2 /oracle/sap/sapdata4/user1d_1/user1d.data1
2 /oracle/sap/sapdata2/user1i_1/user1i.data1
2 /oracle/sap/sapdata1/system_1/system.data1
2 /oracle/sap/saplog1/log_g1_m1/log1_m1.dbf
2 /oracle/sap/saplog1/log_g2_m1/log2_m1.dbf
2 /oracle/sap/saplog1/log_g3_m1/log3_m1.dbf
2 /oracle/sap/saplog1/log_g4_m1/log4_m1.dbf
2 /oracle/sap/dbs/cntrlSAP.dbf

Based on the custom sort file, if SAP tools submit the entire file list to backint for backup, two jobs are created. The first job includes all the files that have a "1" in the first field. The second job includes all the files that have a "2" in the first field.

The following is a list of jobs and associated files:

  • Backup job and restore job 1

    Windows:

    c:\oracle\sap\sapdata1\btabd_1\btabd.data1
c:\oracle\sap\sapdata2\btabi_1\btabi.data1
c:\oracle\sap\sapdata2\clud_1\clud.data1
c:\oracle\sap\sapdata1\ddicd_1\ddicd.data1
c:\oracle\sap\sapdata5\ddici_1\ddici.data1
c:\oracle\sap\sapdata4\el30cd_1\EL30cd.data1
c:\oracle\sap\sapdata1\el30ci_1\el30ci.data1
c:\oracle\sap\sapdata6\es30cd_1\es30cd.data1
c:\oracle\sap\sapdata2\poold_1\poold.data1
c:\oracle\sap\sapdata1\pooli_1\pooli.data1
c:\oracle\sap\sapdata4\protd_1\protd.data1
c:\dev\rdsk\c0t4d0s6

    UNIX or Linux:

    /oracle/sap/sapdata1/btabd_1/btabd.data1
/oracle/sap/sapdata2/btabi_1/btabi.data1
/oracle/sap/sapdata2/clud_1/clud.data1
/oracle/sap/sapdata1/ddicd_1/ddicd.data1
/oracle/sap/sapdata5/ddici_1/ddici.data1
/oracle/sap/sapdata4/el30cd_1/EL30cd.data1
/oracle/sap/sapdata1/el30ci_1/el30ci.data1
/oracle/sap/sapdata6/es30cd_1/es30cd.data1
/oracle/sap/sapdata2/poold_1/poold.data1
/oracle/sap/sapdata1/pooli_1/pooli.data1
/oracle/sap/sapdata4/protd_1/protd.data1/dev/rdsk/c0t4d0s6

  • Backup job and restore job 2:

    Windows:

    c:\oracle\sap\sapdata1\roll_1\roll.data1
c:\oracle\sap\sapdata2\sourced_1\sourced.data1
c:\oracle\sap\sapdata3\stabd_1\stabd.data1
c:\oracle\sap\sapdata2\stabi_2\stabi.data2
c:\oracle\sap\sapdata1\temp_1\temp.data1
c:\oracle\sap\sapdata4\user1d_1\user1d.data1
c:\oracle\sap\sapdata2\user1i_1\user1i.data1
c:\oracle\sap\sapdata1\system_1\system.data1
c:\oracle\sap\saplog1\log_g1_m1\log1_m1.dbf
c:\oracle\sap\saplog1\log_g2_m1\log2_m1.dbf
c:\oracle\sap\saplog1\log_g3_m1\log3_m1.dbf
c:\oracle\sap\saplog1\log_g4_m1\log4_m1.dbf
c:\oracle\sap\dbs\cntrlSAP.dbf

    UNIX or Linux:

    /oracle/sap/sapdata1/roll_1/roll.data1
/oracle/sap/sapdata2/sourced_1/sourced.data1
/oracle/sap/sapdata3/stabd_1/stabd.data1
/oracle/sap/sapdata2/stabi_2/stabi.data2
/oracle/sap/sapdata1/temp_1/temp.data1
/oracle/sap/sapdata4/user1d_1/user1d.data1
/oracle/sap/sapdata2/user1i_1/user1i.data1
/oracle/sap/sapdata1/system_1/system.data1
/oracle/sap/saplog1/log_g1_m1/log1_m1.dbf
/oracle/sap/saplog1/log_g2_m1/log2_m1.dbf
/oracle/sap/saplog1/log_g3_m1/log3_m1.dbf
/oracle/sap/saplog1/log_g4_m1/log4_m1.dbf
/oracle/sap/dbs/cntrlSAP.dbf

More Information

About parameters used in initSID.utl

initSID.utl parameter summary