03-10-2019 08:05 AM
03-10-2019 08:51 AM
03-10-2019 09:04 AM
03-10-2019 09:07 AM
03-11-2019 08:11 AM
With any kind of backup failure, it is important to follow the process flow diagram and logs in order to see where exactly in the process the failure occurred.
For OIP, there should be connection request in client's bpcd log.
Start of OIP process will be logged in bpdbsbora log on the client.
Let us know if it at least gets to this stage.
If so, then the processes will be handed off to dbclient and subsequently to bprd on the master.
You should at least have dbclient and bprd logs for successful backups (after reboot), right?
03-12-2019 05:06 AM
The issue is mostly smilar to this TN.
https://www.veritas.com/support/en_US/article.TECH37307
Followed the below article as well with reboot.
https://support.microsoft.com/default.aspx?scid=kb;en-us;170359
Backup worked for that time as the reboot was done. afterwards the issue recurs.
03-12-2019 05:13 AM
bpdbsora is showing unable to start the oracle command something like that.
02:53:51.319 [15116.11220] <2> debuglog: <16> bphdb: ERR - send() to server failed: The established connection was aborted by software on the host computer.
02:53:51.319 [15116.11220] <2> debuglog: <16> bphdb: ERR - could not write progress log message to the NAME socket
Nov 8, 2018 11:23:16 AM - Info bphdb (pid=12345) INF - RMAN-00571: ===========================================================
Nov 8, 2018 11:23:16 AM - Info bphdb (pid=14188) INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
Nov 8, 2018 11:23:16 AM - Info bphdb (pid=12345) INF - RMAN-00571: ===========================================================
Nov 8, 2018 11:23:16 AM - Info bphdb (pid=12345) INF - RMAN-03009: failure of backup command on ch01 channel at 11/08/2018 14:53:09
Nov 8, 2018 11:23:16 AM - Info bphdb (pid=12345) INF - ORA-19506: failed to create sequential file, name="arch_3405_u39t5987_s59890_p1_t8948945095", parms=""
Nov 8, 2018 11:23:16 AM - Info bphdb (pid=12345) INF - ORA-27028: skgfqcre: sbtbackup returned error
Nov 8, 2018 11:23:16 AM - Info bphdb (pid=12345) INF - ORA-19511: Error received from media manager layer, error text:
Nov 8, 2018 11:23:16 AM - Info bphdb (pid=12345) INF - VxBSAValidateFeatureId: Failed with error:
Nov 8, 2018 11:23:16 AM - Info bphdb (pid=12345) INF - Recovery Manager complete.
Nov 8, 2018 11:23:16 AM - Info bphdb (pid=12345) INF - End of Recovery Manager output.
Nov 8, 2018 11:23:16 AM - Info bphdb (pid=12345) INF - End Oracle Recovery Manager.
Nov 8, 2018 11:23:17 AM - Error bpbrm (pid=1234) from client client.com: ERR - exit status: <1>
Nov 8, 2018 11:23:17 AM - Error bpbrm (pid=1234) from client client: ERR - bphdb exit status = 6: the backup failed to back up the requested files
03-12-2019 06:02 AM
Log snippets do not help.
The snippet does not give any clue if 'aborted connection' has anything to do with an OS or TCP or NBU timeout, or if the client is simply running out of TCP sockets.
Full logs are needed from the same backup attempt.
You have different timestamps in log snippet and RMAN output.
03-13-2019 05:30 AM
03-13-2019 08:04 PM
Hi Amol,
Tried restarting the services but no luck. Will see next time, just FYI we logged support case last time. They just mentioned that they are unable to find the exact clue. for trouble shooting they asked us to reboot the server and proceed further. BTW when thereboot is done, the issue vanished.
03-14-2019 08:42 AM
I often had similar errors with oracle rac in some servers, the solution when there were oracle errors was that the dba did a crosscheck and relaunch the backup, in addition to fixing that they are not running in parallel backup of base and redologs, since control files may be blocked, I hope it helps.