Modifying the initSID.sap file (NetBackup for SAP Oracle databases only)
The initSID.sap file is the SAP profile file. This file signals to the SAP tools that you use the backint interface and conveys information about NetBackup for SAP to the SAP tools. Edit this file as part of configuring NetBackup for SAP when the underlying database is Oracle.
To modify the initSID.sap file
- Check for an existing profile file.
If an initSID.sap file already exists in the $ORACLE_HOME/dbs (%ORACLE_HOME%\database) directory, copy it to a backup file.
- Create a new profile file.
Copy the profile file that is included in the NetBackup for SAP software distribution to the $ORACLE_HOME/dbs (%ORACLE_HOME%\database) directory.
For example, if the Oracle instance is SAP, copy the NetBackup example .sap file to initSAP.sap, as follows:
Unix or Linux:
cp /usr/openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/initSAP.sap \ $ORACLE_HOME/dbs/initSAP.sap
Windows:
copy install_path\NetBackup\dbext\sap\scripts\initSAP.sap %ORACLE_HOME%\database\initSAP.sap
- Modify the initSID.sap file with a text editor to set the backup_dev_type and util_par_file parameters to values that are appropriate to your site.
- (Conditional) Specify the rman_parms parameter and set the NB_ORA_SAP environment variable.
Perform this step only if you use NetBackup for SAP on an Oracle database with RMAN. For example:
rman_parms = "ENV=(NB_ORA_SAP=file)"
where file specifies the full path to the initSID.utl file. Do not use substitution in the file specification.
For example, this parameter might look like the following:
Unix or Linux:
rman_parms = "ENV=(NB_ORA_SAP=/apps/oracle/dbs/initCER.utl)"
Windows:
rman_parms = "ENV=(NB_ORA_SAP=C:\apps\oracle\database\initCER.utl)"
Depending on your site practices, you might want to specify the following additional NetBackup environment variables and their values as arguments to the rman_parms parameter: NB_ORA_POLICY, NB_ORA_SCHED, NB_ORA_CLIENT, and NB_ORA_SERV. You can also specify values for these environment variables in the initSID.utl file. If you specify differing values, the ones in initSID.sap override those in initSID.utl.
For example, consider that you want to use one policy and schedule for the first part of a backup (data files). You want a different policy and schedule for the second part of a backup (the control file backup). You can set the NB_ORA_POLICY and NB_ORA_SCHED variables in initSID.sap to pertain to the first part of the backup. Then, you can set these variables to the different values that pertain to the second part of the backup in initSID.utl. NetBackup for SAP checks only initSID.utl when backing up the control files; it does not check initSID.sap.
You can include other RMAN parameters in this file. For more information on other parameters, see your SAP documentation.
- Save and close the initSID.sap file.