Setting the Instance or Database field in Netbackup 7.6 activity from RMAN

You may have noticed the new field called “Instance or Database” in Netbackup 7.6 activity monitor. This field will populate with the SID during backup using Intelligent Policies. But the joy does not stop here – you can also populate this field using custom scripts.  Just set NB_ORA_SID= during the RMAN send in the RCV script.

This is a sample script - database SID is NMATEST:

# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------
RUN {
ALLOCATE CHANNEL ch00
TYPE 'SBT_TAPE'
PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_CLIENT=ora1.mass.dk,NB_ORA_SID=NMATEST,NB_ORA_SERV=srv1.mass.dk,NB_ORA_POLICY=ORA_MANUAL,NB_ORA_SCHED=daily';
BACKUP
INCREMENTAL LEVEL=1
FORMAT 'bk_d%d_u%u_s%s_p%p_t%t'
DATABASE;
RELEASE CHANNEL ch00;
# Backup Archived Logs
sql 'alter system archive log current';
ALLOCATE CHANNEL ch00
TYPE 'SBT_TAPE'
PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
ALLOCATE CHANNEL ch01
TYPE 'SBT_TAPE'
PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_CLIENT=ora1.mass.dk,NB_ORA_SID=NMATEST,NB_ORA_SERV=srv1.mass.dk,NB_ORA_POLICY=ORA_MANUAL,NB_ORA_SCHED=daily';
BACKUP
FORMAT 'arch_d%d_u%u_s%s_p%p_t%t'
ARCHIVELOG
ALL;
DELETE ARCHIVELOG ALL BACKED UP 2 TIMES to DEVICE TYPE sbt;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
# Control file backup
ALLOCATE CHANNEL ch00
TYPE 'SBT_TAPE'
PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_CLIENT=ora1.mass.dk,NB_ORA_SID=NMATEST,NB_ORA_SERV=srv1.mass.dk,NB_ORA_POLICY=ORA_MANUAL,NB_ORA_SCHED=daily';
BACKUP
FORMAT 'ctrl_d%d_u%u_s%s_p%p_t%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}