Search <book_title>...

Veritas NetBackup™ for SAP Administrator's Guide

Last Published: 2018-02-16

Product(s): NetBackup (8.1.1, 8.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
Introduction to NetBackup SAP HANA
1. About NetBackup for SAP HANA
2. NetBackup for SAP HANA databases
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)
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
Configuring NetBackup for SAP
1. About configuring NetBackup for SAP
2. About configuring a backup policy for an SAP database
3. NetBackup for SAP backup scripts
4. Configuring the logon account for the NetBackup Client Service for NetBackup for SAP
5. About SAP configuration files
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)
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
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
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
  2. Restarting SAP database restores on Oracle
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
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
4. Configuration requirements for snapshot backups with NetBackup for SAP
5. About configuring Snapshot Client with NetBackup for SAP
6. About configuring NetBackup for SAP block-level incremental backups on UNIX
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
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
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
Troubleshooting NetBackup for SAP and SAP HANA
1. About troubleshooting NetBackup for SAP
2. NetBackup debug logs and 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
6. Disaster recovery of an SAP Hana database
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
Appendix B. Input and output files for SAP HANA
1. About input and output files for SAP HANA
Appendix C. backint -i in_file contents
1. About backint -i in_file contents
Appendix D. backint -o out_file contents
1. About backint -o out_file contents
Appendix E. NetBackup for SAP environment variables for backint
1. NetBackup for SAP backint interface environment variables
Appendix F. NetBackup for SAP configuration or bp.conf file settings
1. NetBackup for SAP configuration or bp.conf file settings
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>
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)
Appendix I. Register authorized locations
1. Registering authorized locations used by a NetBackup database script-based policy

Example: Restarting a failed NetBackup for SAP backup job (UNIX or Linux)

This example shows how to restart a failed backup job on UNIX or Linux. In this example, assume the following:

The backup job was deliberately cancelled from the activity manager. In a real user case, a job might fail for different reasons.
You enabled checkpoint (the Take Checkpoints Every option in the policy).
You ran the backup according to the following brbackup command:
```
brbackup -d util_file -t offline -m all -c force
```

The following is an excerpt from the output log:

BR0280I BRBACKUP time stamp: 2006-02-28 21.07.59
BR0057I Backup of database: SUD
BR0058I BRBACKUP action ID: bdsbecnl
BR0059I BRBACKUP function ID: aff
BR0110I Backup mode: ALL
BR0077I Database files for backup:

/oracle/SUD/origlogA/log1_m1.dbf
/oracle/SUD/origlogB/log2_m1.dbf
/oracle/SUD/origlogA/log3_m1.dbf
/oracle/SUD/origlogB/log4_m1.dbf
/oracle/SUD/saparch/cntrl/cntrlSUD.dbf

BR0061I 29 files found for backup, total size 853.604 MB

The previous output log shows the 29 files for backup. brbackup calls the NetBackup SAP agent for backup.

In this example, we have configured the checkpoint frequency for 5 minutes. By the time first checkpoint was taken (that is, in the first 5 minutes), 13 files were backed up. The user killed the job from the NetBackup activity monitor after NetBackup took the first checkpoint. backint returned #SUCCESS messages to brbackup for 13 files that were backed up. For the files that were yet to be backed up, backint retuned #ERROR. The following are the output messages from the brbackup log:

BR0280I BRBACKUP time stamp: 2006-02-28 21.08.04
BR0229I Calling backup utility with function 'backup'...

BR0278I Command output of '/usr/sap/SUD/SYS/exe/run/backint -u SUD -f backup -I /oracle/
SUD/sapbackup/.bdsbecnl.lst -t file -p /home1/orasap/ora920/dbs/initSUD.utl 
-c':

*******************************************************************

Program:                     /usr/sap/SUD/SYS/exe/run/backint 6.5
Input File:                  /oracle/SUD/sapbackup/.bdsbecnl.lst
Profile:                     /home1/orasap/ora920/dbs/initSUD.utl

Program:                     backint 6.5
Input File:                  C:\oracle\SUD\sapbackup\.bdsbedhj.lst
Profile:                     C:\oracle\ora920\dbs\initSUD.utl

Function:                       BACKUP
Backup Type:                BACKUP_FILE
*******************************************************************
BR0280I BRBACKUP time stamp: 2006-02-28 21.15.50

#FILE..... /oracle/SUD/sapdata1/btabd_1/btabd.data1

#SAVED.... VXF1141141105
  
BR0280I BRBACKUP time stamp: 2006-02-28 21.15.50

#FILE..... /oracle/SUD/sapdata2/btabi_1/btabi.data1

#SAVED.... VXF1141141105
  
….
….
BR0233E Backup utility has reported an error while saving file

/oracle/SUD/saparch/cntrl/cntrlSUD.dbf

*******************************************************************
BR0280I BRBACKUP time stamp: 2006-02-28 21.15.50

BR0279E Return code from '/usr/sap/SUD/SYS/exe/run/backint -u SUD -f backup -I /oracle/
SUD/sapbackup/.bdsbecnl.lst -t file -p /home1/orasap/ora920/dbs/initSUD.utl 
-c': 2

BR0232E 13 of 29 files saved by backup utility
BR0280I BRBACKUP time stamp: 2006-02-28 21.15.50
BR0231E Backup utility call failed
  
BR0280I BRBACKUP time stamp: 2006-02-28 21.15.52
BR0304I Starting and opening database instance SUD ...
  
BR0280I BRBACKUP time stamp: 2006-02-28 21.16.00
BR0305I Start and open of database instance SUD successful
  
BR0056I End of database backup: bdsbecnl.aff 2006-02-28 21.15.50
BR0280I BRBACKUP time stamp: 2006-02-28 21.16.00
BR0054I BRBACKUP terminated with errors

You can then restart the preceding job with following command:

brbackup -d util_file -t offline -m all -f last -c force

The brbackup command examined the last backup log and found that the backup failed for some files. It writes following messages in the beginning of output log for this session:

BR0051I BRBACKUP 6.40 (22)
BR0055I Start of database backup: bdsbedhj.aff 2006-02-28 21.16.35

BR0453W Error message found in /oracle/SUD/sapbackup/bdsbecnl.aff:

'BR0233E Backup utility has reported an error while saving file 
/oracle/SUD/sapraw/rawDev4'
BR0453W Error message found in /oracle/SUD/sapbackup/bdsbecnl.aff:
'BR0233E Backup utility has reported an error while saving file 
/oracle/SUD/sapraw/rawDev5'

….
….

BR0453W Error message found in /oracle/SUD/sapbackup/bdsbecnl.aff:
'BR0279E Return code from '/usr/sap/SUD/SYS/exe/run/backint -u SUD -f backup -I 
/oracle/SUD/sapbackup/.bdsbecnl.lst -t file -p /home1/orasap/ora920/dbs/initSUD.utl 
-c': 2'

BR0453W Error message found in /oracle/SUD/sapbackup/bdsbecnl.aff:

'BR0232E 13 of 29 files saved by backup utility'

BR0453W Error message found in /oracle/SUD/sapbackup/bdsbecnl.aff:

'BR0231E Backup utility call failed'

BR0459W Backup /oracle/SUD/sapbackup/bdsbecnl.aff terminated with errors

….
….
BR0280I BRBACKUP time stamp: 2006-02-28 21.16.36
BR0057I Backup of database: SUD
BR0058I BRBACKUP action ID: bdsbedhj
BR0059I BRBACKUP function ID: aff
BR0110I Backup mode: ALL
BR0077I Database files for backup:

/oracle/SUD/origlogA/log1_m1.dbf
/oracle/SUD/origlogB/log2_m1.dbf
/oracle/SUD/origlogA/log3_m1.dbf
/oracle/SUD/origlogB/log4_m1.dbf
/oracle/SUD/saparch/cntrl/cntrlSUD.dbf

BR0061I 16 files found for backup, total size 283.502 MB
BR0091I 13 files were already saved in: bdsbecnl.aff

As the preceding output log shows, 13 files were already backed up. The following is the output of a successful brbackup restart job. This job is the one that backed up the remaining 16 files:

BR0280I BRBACKUP time stamp: 2006-02-28 21.16.41
BR0229I Calling backup utility with function 'backup'...

BR0278I Command output of '/usr/sap/SUD/SYS/exe/run/backint -u SUD -f backup -I
/oracle/SUD/sapbackup/.bdsbedhj.lst -t file -p /home1/orasap/ora920/dbs/initSUD.utl

-c':
*******************************************************************

Program:                     /usr/sap/SUD/SYS/exe/run/backint 6.5
Input File:                  /oracle/SUD/sapbackup/.bdsbedhj.lst
Profile:                     home1/orasap/ora920/dbs/initSUD.utl

Function:                    BACKUP
Backup Type:                 BACKUP_FILE
*******************************************************************
  
BR0280I BRBACKUP time stamp: 2006-02-28 21.21.38

#FILE..... /oracle/SUD/sapraw/rawDev4

#SAVED.... VXF1141141607
  
….
….
BR0280I BRBACKUP time stamp: 2006-02-28 21.21.38

#FILE..... /oracle/SUD/saparch/cntrl/cntrlSUD.dbf

#SAVED.... VXF1141141607
*******************************************************************
  
BR0280I BRBACKUP time stamp: 2006-02-28 21.21.38
BR0232I 16 of 16 files saved by backup utility
BR0230I Backup utility called successfully

More Information

Restarting a restore with the brrestore -f option

Restarting SAP database restores on Oracle