#acl merlyn:read,write All:read
= How to =
https://nsrd.info/blog/2016/09/07/backing-up-oracle-with-nmda/

== Incremental backup ? ==
{{{
  backup incremental <?> database filesperset 4 format 'full_%d_%u'
}}}
  * The level for Oracle backups is not determined from the NetWorker schedule. It always takes the level set on the script. Thus <?> does not work here.

  https://community.emc.com/message/831238#831238

= Troubleshooting =
== 19.2 backup NMC database ==

  * savepsm staging_directory

From a command prompt, use the savepsm command to backup the NMC database

where staging_directory is the location that the backup uses to temporarily store a copy of

{{{
root@emc-networker:/nsr/backup/#: find / -iname "psqlodbcw*" -type f
/opt/lgtonmc/postgres/9.2/odbc/psqlodbcw.so
/opt/lgtonmc/postgres/11.1/odbc/psqlodbcw.so
root@emc-networker:/nsr/backup/#: export LD_LIBRARY_PATH=/opt/lgtonmc/postgres/11.1/odbc/
root@emc-networker:/nsr/backup/#: savepsm /nsr/backup/
108179:savepsm: Replicating database contents to /nsr/backup//pgdata...

savepsm: /nsr/backup/  80 MB 00:00:02   1563 files
94694:savepsm: The backup of save set '/nsr/backup/' succeeded.
108175:savepsm: Deleting database copy in /nsr/backup/
108176:savepsm: Backup of database copy and authentication configuration files completed successfully
completed savetime=1584693165
You have new mail in /var/spool/mail/root

}}}


== ORA 19554 27211 ==
RMAN-03009: failure of allocate command on t1 channel at 06/16/2015 17:07:28
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library

it is possible that the symlinks were not created during the installation.
Solve the problem by creating the required symlink:
{{{
cd $ORACLE_HOME/lib
ln -s /usr/lib/libnsrora.so libobk.so 
}}}

http://sempike.blogspot.com/2013/04/emc-networker-installation-for-oracle.html

https://community.emc.com/thread/78426

http://www.orafaq.com/forum/t/171443/80704/

https://community.emc.com/thread/119162

https://community.emc.com/thread/129585

{{{
Hi,

The error 'failed to load media management library' means that the NMO software
and Oracle have not been integrated correctly.  There are many different
possible reasons for this.  One of the more common would be that you have
installed the wrong bit-version of NMO (if Oracle is 32 bit, you need 32 bit
    NMO even if it's running on a 64 bit OS.).  If this is not it, you should
    check out the Oracle RMAN User Guide for your Oracle version which should
    have details on integrating the media management layer.  Alternatively, you
    could type the error message into a powerlink search and you will get a
    list of articles that give possible reasons for this error.

     -Bobby
}}}

== Backup Script ==
{{{
connect target user/password@{database to be backedup};
connect rcvcat user/password@{recovery catalog};

run {
change archivelog all crosscheck;
allocate channel t0 type 'SBT_TAPE' parms 'ENV=(NSR_DATA_VOLUME_POOL=Poolname)';
allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_DATA_VOLUME_POOL=Poolname)';
allocate channel t2 type 'SBT_TAPE' parms 'ENV=(NSR_DATA_VOLUME_POOL=Poolname)';
allocate channel t3 type 'SBT_TAPE' parms 'ENV=(NSR_DATA_VOLUME_POOL=Poolname)';
backup full filesperset 4
format '/FULL_%d_%u/'
database
include current controlfile
;
sql 'alter system switch logfile'
;
backup
(archivelog all);

release channel t0;
release channel t1;
release channel t2;
release channel t3;

}
}}}

== Troubleshooting error message: "Permission denied, user '(username)' on '(client)' does not have 'Backup local data' privilege'" ==
{{{
NetWorker

 

Symptom:

'Permission denied, user '(username)' on '(client)' does not have 'Backup local data' privilege'

'Permission denied, user '(username)' on '(client)' does not have 'Recover local data' privilege'

'Permission denied user 'system' does not have 'Configure NW privilege'

 

Cause: 

The account referenced in the error message was not included in the list of Users in the User group

As a result, the user was denied the privilege to backup local data

By default, the Users user group specifies that *@*has the privileges to backup local data, recovery local data and monitor NetWorker

    

Resolution

Modify the Users Group and allow the referenced account Backup or Restore local data privilege

 

    Run NetWorker Administrator
    Click User Groups
    Edit Users
    In the Users field add the account referenced 

i.e. account_name@machine_name or user=account_name,host=machine_name

Note: If one syntax does not work, try the other one.

    In the privileges field add the privilege Networker is complaining about in the error message

 

 

Refer to KB article esg64586 for more information
}}}

== Manually Run a Filesystem Clean on a Data Domain Device ==
# filesys show space
{{{
Resource           Size GiB Used GiB Avail GiB Use% Cleanable GiB*
------------------ -------- -------- --------- ---- --------------
/backup: pre-comp         -  42264.9         -    -              -
/backup: post-comp   5236.5   4601.7     634.8  88%            6.5
/ddvar                 19.7      8.2      10.5  44%              -
------------------ -------- -------- --------- ---- --------------
 * Estimated based on last cleaning of 2011/01/04 12:18:14.
}}}

The above shows that running the cleaning task will free up 6.5GB.
Run Filesystem Clean

    Type filesys clean start
    Example:
{{{
sysadmin@orbdd530-1# filesys clean start
Cleaning started. Use 'filesys clean watch' to monitor progress.

Monitor Cleaning Task

    Type filesys clean watch
    Example:

sysadmin@orbdd530-1# filesys clean watch
}}}

  * https://community.emc.com/docs/DOC-24033

== Linux ==
=== Installing the lgtobbb package on Linux ===
{{{
About this task
You must install the lgtobbb package, which is packaged along with NetWorker, for block basedincremental backups and recoveries to succeed on Linux. If you do not install the package, blockbased full backups succeed, but incremental backups and recoveries fail.
}}}