Backup configuration for Standby DB for NMSAP Oracle

Pre-Requisites

1. Backups run using SYSTEM user. SYSTEM user has access to all the System Schemas. It is required for BrConnect to connect to the Database.
2. Check the connection from Standby to Primary Databases, Ensure that the Connection Strings are properly configured on both.
3. Check the sql statement. Verify it works from the "Standby Node" to the "Primary Node"

   sqlplus  system/password@TNS

4. RMAN_UTIL interface must be used to take backup of Standby Node
5. NMC configuration for the client has to be a Manual method. Wizard configuration not supported
6. Create client instances for Both the Primary and Standby Node.
7. Choose only one NSR_CLIENT value. In this case Standby Node can be used.

Steps:

Configure the backint interface file "initSID.utl"

• NSR_SERVER
• NSR_CLIENT
• NSR_DATA_VOLUME_POOL

Configure the sap interface file "initSID.sap"

Important parameters

backup_type = offline_standby|online_standby
backup_dev_type = rman_util
primary_db = "SID_PRIMARY"
standby_db = "SID_STANDBY"
 rman_send = ("channel sbt_1 'NSR_ENV=(NSR_CLIENT=orasap,NSR_DATA_VOLUME_POOL=sap_data,NSR_SERVER=nwserver.dc.vapp.ctc,NSR_DIAGNOSTIC_DEST=/nsr/applogs,NSR_DEBUG_LEVEL=9,NSR_DPRINTF=TRUE,DPRINTF=TRUE)'",
 "channel sbt_2 'NSR_ENV=(NSR_CLIENT=orasap,NSR_DATA_VOLUME_POOL=sap_data,NSR_SERVER=nwserver.dc.vapp.ctc,NSR_DIAGNOSTIC_DEST=/nsr/applogs,NSR_DEBUG_LEVEL=9,NSR_DPRINTF=TRUE,DPRINTF=TRUE)'",
 "channel sbt_3 'NSR_ENV=(NSR_CLIENT=orasap,NSR_DATA_VOLUME_POOL=sap_data,NSR_SERVER=nwserver.dc.vapp.ctc,NSR_DIAGNOSTIC_DEST=/nsr/applogs,NSR_DEBUG_LEVEL=9,NSR_DPRINTF=TRUE,DPRINTF=TRUE)'",
 "channel sbt_4 'NSR_ENV=(NSR_CLIENT=orasap,NSR_DATA_VOLUME_POOL=sap_data,NSR_SERVER=nwserver.dc.vapp.ctc,NSR_DIAGNOSTIC_DEST=/nsr/applogs,NSR_DEBUG_LEVEL=9,NSR_DPRINTF=TRUE,DPRINTF=TRUE)'"
 )

Configure the NetWorker Configuration file "nsrsapsv_sap_oracle.cfg"

Create the update the parameters for SAP oracle backup in the .cfg file.
The following are some important parameters for Standby Database backup.
Check Customer's ENV for appropriate values.

BR_EXEC = brbackup -r /oracle/PRD/sapprof/initPRD_rman.utl -p /oracle/PRD/sapprof/initPRD.sap
ORACLE_HOME = /oracle/PRD/19

ORACLE_SID = PRD

NLS_LANG = AMERICAN_AMERICA.US7ASCII
SAPDATA_HOME = /oracle/PRD
SAP_BIN = /sapmnt/PRD/exe/uc/linuxx86_64
SAP_CONFIG = /oracle/PRD/sapprof/initPRD_rman.sap
BKUP_OBJECTS = LOGS, DB
BKUP_TYPE = online_standby
SAPBACKUP = /oracle/PRD/sapbackup
SAPARCH = /oracle/PRD/saparch
SAPCHECK = /oracle/PRD/sapcheck
SAPREORG = /oracle/PRD/sapreorg
SAPTRACE = /oracle/PRD/saptrace
LD_LIBRARY_PATH = /oracle/PRD/19/lib
PATH = /bin

Encrypt the nsrsapsv_sap_oracle.cfg file.

Use the nsrsapadm utility to encrypt with the SIDadm user.

nsrsapadm -P oracle -z /path-to-nsrsapsv_sap_oracle.cfg

Client Configuration

1. Create the client instance for both Primary and Standby Node.
2. Primary Node is Option for backup configuration.
3. On the secondary node following are the values.

   Saveset: backint:PRD
   Backup Command: nsrsapsv -f /path-to-nsrsapsv_sap_oracle.cfg

4. Add the Client to the appropriate Policy-Workflow

Test the backups and confirm the backup of Standby Node work.

See SAP Notes:
842240 - FAQ: Backup strategy for large and highly available databases
968507 - Considerable enhancements in backups using BR*Tools 7.00