After a shutdown with no wait during REORG when ASE restarts, the recovery can raise Error: 3478 and failed to put online the affected database.
From ASE errorlog:
Error: 3478, Severity: 21, State: 1
server During undo the page timestamp value is less than new timestamp from log.
Page #=377555457, object id = 530816953, page timestamp=153e b499eff3.
Log new timestamp=153e e5936e70. Log record marker = (17925807, 6).
server Database 'database_name' (dbid 4): Recovery failed. Check the ASE errorlog for further information as to the cause.
SAP Adaptive Server Enterprise (ASE)
reorg parallel Error 3478 CR#786727 786727 timestamp shutdown recovery recovered , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.