Solved!
Go to SolutionS
SabarnaDeb
2 Intern
•
139 Posts
0
5746
June 7th, 2012 04:00
Authentication error (0:5:111) error during Online Oracle DB backup using NMO 5.0
Hi,
larger database backup have been failing with below error.
channel CH5: starting piece 1 at 06-JUN-12
RMAN-03009: failure of backup command on CH4 channel at 06/07/2012 05:24:16
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
Authentication error (0:5:111)
continuing other job steps, job failed will not be re-run
channel CH4: starting full datafile backup set
channel CH4: specifying datafile(s) in backup set
Kindly suggest...........
Hi,
If the problem only happens on larger backups, then you should implement a tcp keepalive. For details of this, you can look at the Configuring TCP Networks and Network Firewalls for EMC NetWorker technical note page 29 which explains how to implement this for each OS.
If this doesn't fix it, increase the debug level on the backup and check the debug log for more detail around the error message. You do this by adding NSR_DEBUG_LEVEL and NSR_DEBUG_FILE to the parms.
-Bobby
SabarnaDeb
2 Intern
•
139 Posts
2220
0
Posted June 8th, 2012 08:00
I disabled nsrauth in client and storage node. I will start backup...lets see
Hi Sabarna_Deb,
I think this error produced because of a miscommunication between NMO and NetWorker client, This error is not related to RMAN, it is either the nsrauth , or the username and password you are using for backups has been changed ( Permissions ). I believe by disabling the nsrauth ( As you done already ) this behavior will be changed and fixed, otherwise double check the username and password you are using for backing up.
Hope this helps you. Waiting your updates.
Thanks,
Ahmed Bahaa
SabarnaDeb
2 Intern
•
139 Posts
2230
0
Posted June 11th, 2012 07:00
No Backup failed again. I am using current username:sys and password. Kindly suggest...........:)
SabarnaDeb
2 Intern
•
139 Posts
2230
0
Posted June 11th, 2012 08:00
Previously backup was working fine from networker . No Authentication error. From oracle end, backup is completing. larger database backup is failing, not for small database like "user" tablespace with control file. At the end, backup is failing...............
SabarnaDeb
2 Intern
•
139 Posts
2230
1
Posted June 19th, 2012 06:00
TCP_keepalive was already set. Now issue has been resolved.
Steps: 1. Delete NSR_Peer information from another oracle physical server paired of effected server (Oracle database in RAC enviroment) because i believe somewhere else second server was interrupting the backup from first oracle client.
2. Again configure oracle client using legacy method.
ble1
6 Operator
•
14354 Posts
•
56186 Points
2549
0
Posted June 14th, 2012 05:00
Hopefully you did the same on backup server too (and you must restart daemons after that for change to take effect).
I have seen this on two different occasions:
a) nsrauth
b) client has been ugraded and there was an issue with NMDA/NMO licenses (server was lower version and client was higher using NMDA)
However, in both cases if I remeber correctly (for b) for sure) this error would happen imediatelly. In you case, it looks more as if control session is killed by timeout of some kind (firewall, TCP_KEEPALIVE, similar).