Symptom
- After a scheduled maintenance on the ASE host, one of the user databases failed to recover due to missing device on the OS:
Error: 840, Severity: 17, State: 2
Device 'devname' (with physical name '/path/to/log/device/devicename.dat', and virtual device number #) has not been correctly activated at startup time. Please contact a user with System Administrator (SA) role.
Unable to proceed with the recovery of dbid <#> because of previous errors. Continuing recovery with the next database.
- DBA used touch command to recreate an empty missing device and restarted the database successfully, however, a dump database ends with the following error:
Backup Server: 4.23.2.1: dd_read: read </path/to/log/device/devicename.dat>: Number bytes transferred <= 0. Backup Server: 2.23.1.1: Connection from Server <ASESERVERNAME> Host <hostname> with HostProcid #######. Open Server Session Fatal Error: 16315.15.0: srv__internal_read_packet: Protocol error occurred: length in header (30519) more than packet size(512)
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
lost device, log device missing, 840, dd_read, error 840, backup server, Unable to proceed with the recovery of dbid , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview