Oracle DB Backup in NetWorker(NMDA) - Creating client instance manually

NetWorker Commands App:
Google Play Store -  https://qrgo.page.link/nBvSt

My Lab Set up:
AMD Ryzen 7 3700x processor - https://amzn.to/32SHIXX
GIGABYTE X570 AORUS ELITE Wifi - https://amzn.to/31VDJuE
RIPJAW 16GB - https://amzn.to/34Y5UuJ
Radeon RX 580 - https://amzn.to/32P3j3w
cooler master 550 watt power supply - https://amzn.to/3lMSUy8

Contact Information:
Twitter - Twitter: CrazyrovS
Website - https://crazyrov.com/
Email - [email protected]

DELL EMC Community Page - https://www.dell.com/community/user/v...


To configure the Oracle database backups in NetWorker We will be using NetWorker Module for Database application. This module supports a number of different databases, but in this video we will just be looking at Oracle.
Let's break the entire procedure into these 6  steps so that you have something to validate and then move forward.

Installation of NetWorker client agents and the NMDA on the respective Oracle server.
Link the library file
Get the relevant information from the DBA.
Make sure that appropriate pool and devices are created
Create the client instances.
Test backups

Link the library file
Oracle makes backups to a media manager for this RMAN must communicate with a media management library. NetWorker in this case acts as a media management layer and thus has to provide a library so that RMAN can interact with it to send the backup to a centralized storage. Libobk.so is the media management library and we need to create a soft link for this file name to the NetWorker media management library which is libbsrora.so.

cd $ORACLE_HOME/lib
If not relocated:
ln -s /usr/lib/libnsrora.so libobk.so

Get relevant information from the DBA
NLS_LANG=American_America.UTF8, Oracle Locale
TNS_ADMIN=/u01/app/oracle/product/12.2.0/dbhome_1/network/admin path to the tnsname.ora directory
ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1 which is the Oracle installation directory
ORACLE_SID=orcl , Oracle instance SID
User name, password, Net Service name



Sample basic RMAN scripts


Full Backup:
run {
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=nsr-linux.crazyrov.com,
NSR_DATA_VOLUME_POOL=FS, CONFIG_FILE=/home/oracle/nmda.cfg )';
backup full filesperset 4 format 'FULL_%d_%U' (database);
release channel t1;
release channel t2;
}

Archive Log Backup:
run {
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=nsr-linux.crazyrov.com,
NSR_DATA_VOLUME_POOL=FS)';
backup archivelog all;
release channel t1;
release channel t2;
}

• #education
• #nmda
• #oracle_backup
• #networker_oracle_backup
• #networker_module_for_database_application
• #networker_training
• #emcdell
• #dell_emc