头疼sybase
上班这么几年来,最头疼的只能是处理sybase问题了,sybase12.5版本作为10几年前发布的软件版本,出了问题只能考备份作为恢复的最后手段。
所以备份是否有效,能否正常恢复,在出故障的时候,牵动着我的小心脏,而且在一些情况下,备份并不能完成恢复,头疼。
今天这个问题由于AIX系统异常,HMC里面强制重启后,sybase出现以下问题
Recovering database 'cwbase3'.
00:00000:00001:2019/07/03 18:17:50.13 server Error: 3474, Severity: 21, State: 1
00:00000:00001:2019/07/03 18:17:50.13 server During redo the page timestamp value is less than old timestamp from log. Page #=377, object id = 23, page timestamp=4002 883f0a20. Log old timestamp=4002 883f5d02.
00:00000:00001:2019/07/03 18:17:50.14 server Error: 3414, Severity: 21, State: 1
00:00000:00001:2019/07/03 18:17:50.14 server Database 'cwbase3' (dbid 11): Recovery failed. Check the SQL Server errorlog for further information as to the cause.
00:00000:00001:2019/07/03 18:17:50.18 server Recovering database 'cwbase6'.
00:00000:00001:2019/07/03 18:17:50.19 server Error: 624, Severity: 21, State: 1
00:00000:00001:2019/07/03 18:17:50.19 server Adaptive Server failed to retrieve a row via its RID in database 'cwbase6' because the requested RID has a higher number than the last RID on the page. Rid pageid = 0x32ab09; row num = 0x15. Page pointer = 0x4d319e000, pageno = 3320585, status = 0x1, objectid = 8, indexid = 0, level = 0.
00:00000:00001:2019/07/03 18:17:50.19 server Error: 3414, Severity: 21, State: 1
00:00000:00001:2019/07/03 18:17:50.19 server Database 'cwbase6' (dbid 12): Recovery failed. Check the SQL Server errorlog for further information as to the cause.