NetBackup for SAP backup scripts
If you configured a policy for automatic scheduling, you also need to specify backup scripts to be run automatically. You can either create your own scripts or you can modify one or more of the scripts that are included in the following locations:
Windows:
install_path\NetBackup\DbExt\SAP\samples
UNIX or Linux:
/usr/openv/netbackup/ext/db_ext/sap/scripts/sap_oracle /usr/openv/netbackup/ext/db_ext/sap/scripts/sap_maxdb
Table: NetBackup for SAP scripts shows the sample scripts.
Table: NetBackup for SAP scripts
Script name | Used by (underlying database) | Comments |
|---|---|---|
sap_offline_backup sap_offline_backup.cmd | Oracle without RMAN | Issues a brbackup command and performs a whole offline database backup. When it is initiated from an automatic schedule, the NetBackup bphdb process sets these variables in the environment, for use by the script or SAP backint interface. They identify the primary server and policy that caused the script to run. UNIX/Linux: $SAP_SERVER $SAP_POLICY Windows: %SAP_SERVER% %SAP_POLICY% If the script is initiated from the client host, these variables can be set into the environment manually. On UNIX/Linux, you should export the variables after they are set. |
sap_online_backup.cmd sap_online_backup | Oracle without RMAN | Issues the brbackup and brarchive commands and performs a whole online database backup and then an offline redo log backup. |
sap_redo_log_backup sap_redo_log_backup.cmd | Oracle without RMAN | Issues the brarchive command and backs up the offline redo log files. |
sap_rman_backup sap_rman_backup.cmd | Oracle with RMAN | Issues the brbackup command to perform either an RMAN incremental level 0 or incremental level 1 cumulative backup. The level depends on whether the script was initiated from an Automatic Full or Automatic Cumulative schedule. If this script is to be initiated from the client, add logic to set the SAP_FULL or SAP_CINC variable appropriately. Otherwise the script exits with status 0 without taking a backup. |
sap_maxdb_backup sap_maxdb_backup.cmd | MaxDB | Issues a dbmcli command and uses the specified backup medium to perform either a full or cumulative incremental backup. The type depends on whether the script was initiated from an Automatic Full or Automatic Cumulative schedule. If this script is to be initiated from the client, add logic to set the SAP_FULL or SAP_CINC variable appropriately. Otherwise the script exits with status 0 without taking a backup. |
If you decide to use these scripts, customize them for your environment.
Note:
Always specify the correct script when configuring automatic backups or when starting operations through NetBackup. NetBackup for SAP does not generate an error if a restore script is used for a backup operation or a backup script is used for a restore operation.
Note:
All scripts must be stored and run locally. One recommendation is that scripts should not be world-writable. Scripts are not allowed to be run from network or remote locations. Any script that is created and saved in the NetBackup db_ext (UNIX) or dbext (Windows) location needs to be protected during a NetBackup uninstall.