Mixing RMAN stream and RMAN proxy NetBackup for SAP backups
You can use the split-mirror full backups that use RMAN proxy with the standard incremental backups that use RMAN stream methods. For example, use RMAN proxy file-based backups for weekly full backups using snapshot methods. You can then use RMAN stream-based incremental backups for daily backups. To mix backup methods, perform the following additional configuration procedure.
To mix RMAN stream and RMAN proxy NetBackup for SAP backups
- Copy initSID.sap to the initFullSID.sap and initIIncrSID.sap files.
- Edit the init_fullSID.sap and initI_incrSID.sap.
Edit the files as follows:
Specify the rman_parms parameter.
Set the NB_ORA_SAP environment variable to the initSID.utl path.
- Edit the init_fullSID.sap file.
Do the following:
Enable the rman_proxy flag.
Set the following, where "auto_sched" is the name of the automatic schedule:
rman_send = "'NB_ORA_PC_SCHED=auto_sched'"
- Copy following sample script to a different location on your client:
on UNIX or Linux:
/usr/openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/sap_rman_backup
on Windows:
install_path\NetBackup\DbExt\SAP\samples\sap_rman_backup.cmd
- On UNIX or Linux, modify the if..elif..fi condition as follows:
if [ $SAP_FULL -eq 1 ] then CMD_LINE="$SAP_ENV brbackup -d rman_util -t offline -p initFullSID.sap -m full -c" elif [ $SAP_CINC -eq 1 ] then CMD_LINE="$SAP_ENV brbackup -d rman_util -t offline -p initIncrSID.sap -m incr -c"
- On Windows, modify the condition as follows:
@if "%SAP_FULL%" EQU "1" @set CMD_LINE=%BRBACKUP% -u internal/ -c -d rman_util -t offline -m full -p initFullSID.sap @if "%SAP_CINC%" EQU "1" @set CMD_LINE=%BRBACKUP% -u internal/ -c -d rman_util -t offline -m incr -p initIncrSID.sap
- Specify the script from step 4 in the backup selection of your NetBackup for SAP policy