Skip to Content
0
Former Member
Dec 29, 2013 at 09:47 AM

Sybase ASE logging during boot/db server startup

453 Views

Hi database guru's, I am not sure if I am posting in the correct area so please in that case forgive me and be so kind to "show me the way" 😊

In the Sybase ASE 15 mydbserver.errorlog I found the following records after server reboot:
(the system has been rebooted via the standard os process, no crash or anything)

00:02:00000:00014:2013/11/10 1:12:40.35 server Recovering database 'spongebobdb'.
00:02:00000:00014:2013/11/10 1:12:40.35 server Started estimating recovery log boundaries for database 'spongebobdb'.
00:02:00000:00014:2013/11/10 1:12:22.12 server Database 'spongebobdb', checkpoint=(049112, 3), first=(93221, 3), last=(104321, 3).
00:02:00000:00014:2013/11/10 1:12:22.12 server Completed estimating recovery log boundaries for database 'spongebobdb'.
00:02:00000:00014:2013/11/10 1:12:22.12 server Started ANALYSIS pass for database 'spongebobdb'.
00:02:00000:00014:2013/11/10 1:12:22.12 server Completed ANALYSIS pass for database 'spongebobdb'.
00:02:00000:00014:2013/11/10 1:12:22.12 server Log contains all committed transactions until 2013/11/10 1:01:10.23 for database spongebobdb.
00:02:00000:00014:2013/11/10 1:12:22.12 server Started REDO pass for database 'spongebobdb'. The total number of log records to process is 1.
00:02:00000:00014:2013/11/10 1:12:22.12 server Completed REDO pass for database 'spongebobdb'.
00:02:00000:00014:2013/11/10 1:12:22.12 server Timestamp for database 'spongebobdb' is (0x0000, 0x009c46a2).
00:02:00000:00014:2013/11/10 1:12:22.12 server Recovery of database 'spongebobdb' will undo incomplete nested top actions.
00:02:00000:00014:2013/11/02 1:12:22.12 server Started recovery checkpoint for database 'spongebobdb'.
00:02:00000:00014:2013/11/02 1:12:22.13 server Completed recovery checkpoint for database 'spongebobdb'.
00:02:00000:00014:2013/11/02 1:12:22.13 server Started filling free space info for database 'spongebobdb'.
00:02:00000:00014:2013/11/02 1:12:22.13 server Completed filling free space info for database 'spongebobdb'.
00:02:00000:00014:2013/11/02 1:12:22.13 server Started cleaning up the default data cache for database 'spongebobdb'.
00:00:00000:00014:2013/11/02 1:12:22.58 server Completed cleaning up the default data cache for database 'spongebobdb'.
00:02:00000:00014:2013/11/02 1:12:22.58 server The transaction log in the database 'spongebobdb' will use I/O size of 2 Kb.
00:02:00000:00014:2013/11/02 1:12:22.58 server Database 'spongebobdb' is now online

Can somebody explain this info, is it a normal and common boot sequence which was executed?
I think the "recovery" records are normal but can someone please confirm?

Do the "REDO" messages show that transaction log was checked for any open, to-be-executed (committed) entries?

Does anyone have more info about "recovery checkpoint"?

Should I worry, could DB be corrupted? (I ran a dbcc checkdb on this db which went fine)

Thank you very much
CaptainDB

Edit/Delete Message