Skip to Content
0
Apr 07, 2020 at 12:01 PM

Database 'SID' (dbid 4): Recovery failed. Check the ASE errorlog for further information

230 Views

Hi Experts,

My Solution Manager system 7.2 on SAP ASE DB 16 is not coming up since last few days, on further analysis found below logs in the Sybase logs SID.log under <SAP ASE DB Install Directory>/ASE 16/install

Database 'SID' (dbid 4): Recovery failed. Check the ASE errorlog for further information as to the cause.

00:0007:00000:00019:2020/04/07 10:58:54.22 server Started ANALYSIS pass for database 'SID'. 00:0008:00000:00019:2020/04/07 10:58:55.45 server Error: 3301, Severity: 21, State: 12 00:0008:00000:00019:2020/04/07 10:58:55.45 server Invalid log record found in syslogs (logop 141). 00:0008:00000:00019:2020/04/07 10:58:55.49 server Database 'SID' (dbid 4): Recovery failed. Check the ASE errorlog for further information as to the cause.

So far I have tried below notes but to no help

2195104 - Error 926: Database cannot be opened. An earlier attempt at recovery... - SAP ASE

2671154 - How to load a database in suspect state after error 926 - SAP ASE for BS and SAP ASE

Being new to the ASE database I don't want to proceed with further steps which might corrupt the database or installation. I have database backups till past week where this system was running normally. Please suggest how to resolve this and where exactly to look for further error log/details

Thanks in advance for your kind help