Netbackup for SAP BACKUP USING RMAN
I am here to share SAP Backup process using Netbackup, with some of detailed SAP level changes required.
My environment for SAP is listed below;
O/S: SUSE Linux 11 SP1 for SAP
DB: Oracle 11g
SAP: ECC 6 ERP 4 ABAP
Backup Utility: RMAN
NBU: Netbackup 7.1 for Windows (installed on Windows 2008 Server)
- First we need to make sure that NBU server and SAP Servers can access each other via Host Name resolution, so you need to make eateries in below listed Host file of Both Hosts.
- Install NBU Client on SAP Server that is as simple as a normal RPM installation, thing that need to consider while installing NBU Client is the Server name (NBU) and the Client Name (SAP Server) that have configured in Host files. So NBU can access SAP Server as Client.
#/NBU/NetBackup_7.1_CLIENTS/NetBackup_7.1_CLIENTS # ./install
Symantec Installation Script
Copyright 1993 - 2011 Symantec Corporation, All Rights Reserved.
Installing NetBackup Client Software
Do you wish to continue? [y,n] (y) y
Do you want to install the NetBackup client software for this client? [y,n] (y)
This package will install Linux/SuSE2.6.16 client.
This package will install NetBackup client 7.1.
Enter the name of the NetBackup server : NBU-SRV
Would you like to use "SAP Server" as the configured
name of the NetBackup client? [y,n] (y)
Please wait while installation is in progress...
File /usr/openv/tmp/install_trace.20427 contains a trace of this install.
That file can be deleted after you are sure the install was successful.
- Linking the Oracle database with the SBT library
(Oracle databases with RMAN only)
# ln –s /usr/openv/netbackup/bin/libsapora.so64 \
- Copy initSAP.utl from “/usr/openv/netbackup/ext/db_ext/sap/script/sap_oracle” to below location:
- Modify parameters of above file for RMAN:
Policy name i.e “pol_sap_sid”; Server name i.e “NBU”; Schedule i.e “default application backup”
- copy initSAP.sap from ““/usr/openv/netbackup/ext/db_ext/sap/script/sap_oracle” to below location
- Modify above file with below changes:
backup_dev_type = util_filebackup_mode = all
backup_type = online
backup_root_dir = /oracle/SID/sapbackup
util_par_file = /oracle/SID/11203/dbs/initDEV.utl
######ONLY FOR RMAN PARM######
rman_parms = "ENV=(NB_ORA_SAP=/oracle/SID/11203/dbs/initSID.utl)"
- Assign appropriate rights to Netbackup SAP Script.
chmod 775 /usr/openv/netbackup/ext/db_ext/sap/sap_oracle/sap_rman_script
- Edit SAP RMAN script installed with NBU Client located @ “/usr/openv/netbackup/ext/db_ext/sap/sap_oracle/sap_rman_script”
At the end of script provide user ID of “OraSID”
su - qasadm -c "$CMD_LINE"
- Enable Netbackup Logs that will help if facing any error during backup run
Create folder with name “bphdb” under “/usr/openv/netbackup/logs/”
- Create new Netbackup Policy for SAP Backup as shown in below snapshots that I have taken from my NBU server.
- Now Run SAP Execute backup Policy Manually to test your success results.
DURING BACKUP YOU MAY FOUNDS SOME ISSUES RELATED TO SAP & OS THAT SHOULD RESOLVE BY SYSTEM ADMINISTRATOR OF SAP & LINUX HOWEVER I AM ADDING SOME USEFULL TIPS RELATED TO PERMISSIONS THAT CAUSE BIG TROUBLE DURING BACKUPS
- Follow snotes if facing any issues related to access denied errors during backups.
Note 113747 - Owners and authorizations for BR*Tools
Note 400241 - Problems with ops$ or sapr3 connect to Oracle
Note 776505 BR*Tools fail with ORA-01017 / ORA-01031 on Linux
- SQL PLUS Commands May Required for Granting permission on DB:
- >Sqlplus “/as sysdba”
- >grant DBA to OPS$<QAS>ADM;
- >grant CONNECT to OPS$<QAS>ADM;
- >grant RESOURCE to OPS$<QAS>ADM;
- >select granted_role from dba_role_privs where grantee = 'OPS$ORA<QAS>';
- >alter user username account unlock