NetWorker: Sample Oracle RMAN script for backup to Data Domain Appliance with NMDA

Summary: This article presents a sample Oracle RMAN backup script using NetWorker Module for Databases and Applications (NMDA) with a Data Domain appliance.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Instructions

The following is an example RMAN backup script used to configure Oracle Database backups to a Data Domain system using SBT channels.

The script establishes connections to the target database and the RMAN recovery catalog. It allocates four SBT channels for the operation. Each channel is configured with a single open file limit. A backup is then performed for the database datafiles and the archived redo logs. The backup also includes the current control file and deletes archived logs after a successful backup.

connect target / ;
connect catalog rman/rman@rmancatsvr
run
{
set command id to 'RMAN'  ;

allocate channel CH1 device type SBT  parms "SBT_PARMS=(NSR_DEBUG_LEVEL=2,NSR_SERVER=nsr.networker.com,NSR_CLIENT=client.networker.com,NSR_DATA_VOLUME_POOL=DDBACKUP)";
allocate channel CH2 device type SBT  parms "SBT_PARMS=(NSR_DEBUG_LEVEL=2,NSR_SERVER=nsr.networker.com,NSR_CLIENT=client.networker.com,NSR_DATA_VOLUME_POOL=DDBACKUP)";
allocate channel CH3 device type SBT  parms "SBT_PARMS=(NSR_DEBUG_LEVEL=2,NSR_SERVER=nsr.networker.com,NSR_CLIENT=client.networker.com,NSR_DATA_VOLUME_POOL=DDBACKUP)";
allocate channel CH4 device type SBT  parms "SBT_PARMS=(NSR_DEBUG_LEVEL=2,NSR_SERVER=nsr.networker.com,NSR_CLIENT=client.networker.com,NSR_DATA_VOLUME_POOL=DDBACKUP)";

set limit channel CH1 maxopenfiles=1;
set limit channel CH2 maxopenfiles=1;
set limit channel CH3 maxopenfiles=1;
set limit channel CH4 maxopenfiles=1;

BACKUP
(DATAFILE 1,2,3,4,5,6,7,8 FILESPERSET 8 CHANNEL CH1)
(DATAFILE 9,10,11,12,13,14,15,16 FILESPERSET 8 CHANNEL CH2)
(DATAFILE 17,18,19,20,21,22,23,24 FILESPERSET 8 CHANNEL CH3)
(ARCHIVELOG ALL DELETE INPUT FILESPERSET 1 CHANNEL CH4 INCLUDE 
CURRENT CONTROLFILE);

release channel CH1 ;
release channel CH2;
release channel CH3;
release channel CH4;
 
}

Additional Information

Consider the following:

  • SBT_PARMS is a keyword introduced in Oracle 11gR2.
  • The NSR_CLIENT parameter is required for cluster backups.
    • For Oracle RAC cluster backups, NSR_CLIENT must reference a single virtual IP (VIP) name only.
    • In other words, the NSR_CLIENT value for a RAC cluster backup should update only one virtual IP name index in the NetWorker client index.
  • The NSR_DATA_VOLUME_POOL parameter is used for manual backups.
    • Scheduled, NetWorker server-initiated backups do not require NSR_DATA_VOLUME_POOL.

Affected Products

NetWorker, NetWorker Module for Databases and Applications

Products

NetWorker Family, NetWorker Module
Article Properties
Article Number: 000023102
Article Type: How To
Last Modified: 25 آذار 2026
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.