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.
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
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.