Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2013
    Posts
    2

    Unanswered: Sybase ASE logging during boot/db server startup

    Hi database guru's,

    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?
    Should I worry, could DB be corrupted?

    Thank you very much
    CaptainDB

  2. #2
    Join Date
    Nov 2013
    Location
    Bangalore
    Posts
    30
    Provided Answers: 2
    Hi Captain,

    Also Checked my Production DB logs.Its normal boot up logs.
    No need to worry(least u hav ur DB online ..)
    ...

  3. #3
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    CaptainDB, have you performed consistency checks (DBCC) and if so, what does the result say?
    I'm not crazy, I'm an aeroplane!

  4. #4
    Join Date
    Dec 2013
    Posts
    2

    Sybase ASE logging during boot/db server startup

    Quote Originally Posted by Martijnvs View Post
    CaptainDB, have you performed consistency checks (DBCC) and if so, what does the result say?
    Hi,

    Thanks all for your replies, I really appreciate it.
    Yes, I ran a dbcc checkdb which didn't show any errors.

    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"?

    Thanks,
    CaptainDB
    Last edited by CaptainDB; 12-28-13 at 19:48.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •