cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Online backup -ORA-19506: failed to create sequential file

DoubleP
Level 5

Our master server is linux (v 8), however this issue is occurring with an Online oracle backup of a Windows server. The Policy shows as Oracle. Up until a couple days ago, it has never had any problems. The Backup schedule is failing with: "6) the backup failed to back up the requested files" The on_database_    schedule is failing with: "Apr 3, 2018 2:44:12 AM - Info bpbrm (pid=21239) INF - Client read timeout = 18000
Apr 3, 2018 7:44:12 AM - Error bpbrm (pid=21239) listen for client timeout during accept from data listen socket after 60 seconds
Apr 3, 2018 7:44:40 AM - Info dbclient (pid=0) done. status: 54: timed out connecting to client"

An Oracle DBA checked it from her side and this is the error she sees: 

"RMAN-03002: failure of backup plus archivelog command at 04/04/2018 03:08:29
ORA-19506: failed to create sequential file, name="_20180404_25316.p1_s26287.r", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSACreateObject: Failed with error:
Server Status: Communication with the server has not been initiated or the server status has not been retrieved from the serve

RMAN>"

 

Any ideas? As state above, this backup has been "good" for years.

1 ACCEPTED SOLUTION

Accepted Solutions

Nicolai
Moderator
Moderator
Partner    VIP   

Looks like oracle host did not respond to a network connection in time

listen for client timeout during accept from data listen socket after 60 seconds

its like a phone call where no one is answering. Verify connectivity with bptestbpcd as Marainne pointed out and re-try the operation.

View solution in original post

2 REPLIES 2

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

'Something' has changed causing connectivity to fail. 
Any chance that the master is no longer listed as 1st Server entry in the Registry? 

Important to test connectivity from master and media server as well as connectivity initiated by the client to the master server.

Ensure log folders exist before running tests:
Master: bprd (NBU must be restarted after folder is created)
Media: bpbrm (This is for backup-related troubleshooting)
Client: bpcd and dbclient (for connectivity and backup troubleshooting)

Connectivity tests: 
On master and media server: 
bptestbpcd -client <client-name> -debug -verbose

On client: 
bpclntcmd -pn

Nicolai
Moderator
Moderator
Partner    VIP   

Looks like oracle host did not respond to a network connection in time

listen for client timeout during accept from data listen socket after 60 seconds

its like a phone call where no one is answering. Verify connectivity with bptestbpcd as Marainne pointed out and re-try the operation.