Video Screencast Help

Netbackup for SAP BACKUP USING RMAN

Created: 25 Jul 2013 • Updated: 29 Jul 2013
Language Translations
mumair109917's picture
+2 2 Votes
Login to vote

Hi All,

 

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)

 

  1. 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.

Windows:            c:\windows\system32\drivers\etc\hosts

Linux:                    /etc/Hosts

  1. 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)

Installing PBX...

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.

 

  1. Linking the Oracle database with the SBT library

(Oracle databases with RMAN only)

# ln –s /usr/openv/netbackup/bin/libsapora.so64 \

/oracle/SID/11203/lib/libobk.so

  1. Copy initSAP.utl from “/usr/openv/netbackup/ext/db_ext/sap/script/sap_oracle” to below location:

“/oracle/SID/11203/dbs/initSID.utl”

  1. 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”

Example:

switch_list /oracle/SID/sapbackup/.switch.lis

switch_sem /oracle/SID/sapbackup/.switch.sem

switch_log /oracle/SID/sapbackup/.switch.log

server nbu-srv

policy pol_sap_sid

schedule Default-Application-Backup

 

  1. copy initSAP.sap from ““/usr/openv/netbackup/ext/db_ext/sap/script/sap_oracle” to below location

“/oracle/SID/11203/dbs/initSID.sap”

  1. 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)"

  1. Assign appropriate rights to Netbackup SAP Script.

chmod 775 /usr/openv/netbackup/ext/db_ext/sap/sap_oracle/sap_rman_script

  1. 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"

  1. Enable Netbackup Logs that will help if facing any error during backup run

Create folder with name “bphdb” under “/usr/openv/netbackup/logs/”

  1. Create new Netbackup Policy for SAP Backup as shown in below snapshots that I have taken from my NBU server.

Attributes.png

 

Client.png

 

Backup Selection.png

 

 

  1. 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

 

  1. 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

 

 

  1. SQL PLUS Commands May Required for Granting permission on DB:

 

  1. >Sqlplus “/as sysdba”
  2. >grant DBA to OPS$<QAS>ADM;
  3. >grant CONNECT to OPS$<QAS>ADM;
  4. >grant RESOURCE to OPS$<QAS>ADM;
  5. >select granted_role from dba_role_privs where grantee = 'OPS$ORA<QAS>';
  6. >alter user username account unlock