Suspected database - error 3414

Jason L. Froebe [Team Sybase]

2005-09-16 02:20:50 UTC

Post by Pavel A. Stepanoff
Hi All,
sorry for dumb question.
My ASE 12.5 writes to errorlog this message and doesn't want to work with
this database any more.
00:00000:00001:2005/08/24 15:54:22.89 server Recovering database
'stdgvkgbase'.
00:00000:00001:2005/08/24 15:54:22.93 server Error: 624, Severity: 21,
State: 1
00:00000:00001:2005/08/24 15:54:22.93 server Adaptive Server failed to
retrieve a row via its RID in database 'stdgvkgbase' because the requested
RID has a higher number than the last RID on the page . Rid pageid =
0xad2a1; row num = 0xc. Page pointer = 0x2ECE3000, pageno = 709281, status =
0x1, obj ectid = 8, indexid = 0, level = 0.
00:00000:00001:2005/08/24 15:54:22.96 server Error: 3414, Severity: 21,
State: 1
00:00000:00001:2005/08/24 15:54:22.96 server Database 'stdgvkgbase' (dbid
4): Recovery failed. Chec
k the SQL Server errorlog for further information as to the cause.
I have no dump. Can I recover this database?
Thanx in advance,
Pavel.

Hi Pavel,

I would recommend point in time recovery (search for the phrase on
http://sybooks.sybase.com for the syntax). Recover up to the second
prior to the reference of the table. You will miss the transactions
that are a) uncompleted at the time b) occurred after the time.

to resolve the 'error' after to you have recovered the database,
recreate the clustered index (create/drop if you don't have one) for APL
tables. For DOL (data/row level locking) tables, perform an reorg
rebuild on the table.
--
Jason L. Froebe

"There is usually a balance between the left and the right... checks &
balances... the bane of the government but the boon of the people" -
Jason L. Froebe

WebBlog http://jfroebe.livejournal.com

TeamSybase (http://www.teamsybase.com)
ISUG member (http://www.isug.com)
Chicago Sybase Tools User Group (http://www.cpbug.com)