Using RMAN with Tape Backup Applications

June 25, 2020 1-minute read

Oracle • RMAN

Quick Tip

When using a Backup Application like NetBackup or DD Boost you need to prepare accordingly your RMAN channels in order to connect your target database to the device type SBT_TAPE and be able to send or retreive your backup files.
Here some examples of how they can be configured to use them, after their software has been installed and setup in our database server.

NetBackup

For NetBackup you need to specify the backup server and also the client that normally is the database server:

run {
allocate channel x1 type 'SBT_TAPE' parms 'ENV=(NB_ORA_SERV=backup-host,NB_ORA_CLIENT=patoracle)';
allocate channel x2 type 'SBT_TAPE' parms 'ENV=(NB_ORA_SERV=backup-host,NB_ORA_CLIENT=patoracle)';
...
}

Remember that before using RMAN with NetBackup you need to link them with the command /usr/openv/netbackup/bin/oracle_link and restart the database.

DD Boost

For DDBoost you need to specify the installed library, normally in $ORACLE_HOME/lib/libddobk.so along with the backup server and storage identifier.

Remember that you need to send a user and password to connect to the storage server.

run {
allocate CHANNEL dd0 DEVICE TYPE 'SBT_TAPE' 
  parms 'SBT_LIBRARY=/opt/oracle/product/19c/dbhome_1/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle, BACKUP_HOST=backup.host, ORACLE_HOME=/opt/oracle/product/19c/dbhome_1)';
send 'set username ddbuser password ********  servername backup.host';
RELEASE CHANNEL dd0;
}

run {
allocate channel x1 device type 'SBT_TAPE' 
  parms 'SBT_LIBRARY=/opt/oracle/product/19c/dbhome_1/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle, BACKUP_HOST=backup.host, ORACLE_HOME=/opt/oracle/product/19c/dbhome_1)';
allocate channel x2 device type 'SBT_TAPE' 
  parms 'SBT_LIBRARY=/opt/oracle/product/19c/dbhome_1/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle, BACKUP_HOST=backup.host, ORACLE_HOME=/opt/oracle/product/19c/dbhome_1)';
...
}