Results 1 to 4 of 4

Thread: recover failed

  1. #1
    Join Date
    Apr 2004
    Posts
    4

    Post Unanswered: recover failed

    my sybase ase 11.9.2 is running on linux (redhat7) and i was accidentallly shutdown, when i rrestarted it, the following error occurs:

    00:00000:00001:2004/04/09 15:42:15.12 server Recovering database 'p_account'.
    00:00000:00001:2004/04/09 15:42:15.12 server Redo pass of recovery has processed 2 committed and 0 aborted transactions.
    00:00000:00001:2004/04/09 15:42:15.12 server Error: 1105, Severity: 17, State: 3
    00:00000:00001:2004/04/09 15:42:15.12 server Can't allocate space for object 'syslogs' in database 'p_account' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase size of the segment.
    00:00000:00001:2004/04/09 15:42:15.12 server Error: 3475, Severity: 21, State: 7
    00:00000:00001:2004/04/09 15:42:15.12 server There is no space available in SYSLOGS for process 1 to log a record for which space has been reserved. This process will retry at intervals of one minute. The internal error number is -4.

    The error said it cannot recover my db (p_account) as the log is full, i tried to alter database or use sp_extendsegment to add a logsegment to it by the follow command:

    alter database p_account on log_account = 200

    and the follow error occurs:

    Server Message: Number 5005, Severity 10
    Line 9:
    Extending database by 102400 pages on disk log_account
    Server Message: Number 921, Severity 14
    Line 9:
    Database 'p_account' has not been recovered yet - please wait and try again.

    the same happends to sp_extendsegment, please help me to solve it! million thanks!!!

  2. #2
    Join Date
    Apr 2004
    Posts
    4

    Re: recover failed

    I tried to startup the ase by:
    /opt/sybase-11.9.2/bin/dataserver -T3608 \
    -sSybase \
    -d/data/master.dat \
    -e/opt/sybase-11.9.2/install/Sybase.log \
    -M/opt/sybase-11.9.2 \

    The ASE boot with recover master db only and therefore it can startup now. However, the problematic db is still not recovered hey! I also tried to dump tran but the follow error occurs:
    1> dump transaction p_account with no_log
    2> go
    Msg 921, Level 14, State 1:
    Line 1:
    Database 'p_account' has not been recovered yet - please wait and try again.

    so how to add/free log to the db (p_account)? pls help!

  3. #3
    Join Date
    Nov 2002
    Posts
    207
    Try this...

    In the master database, issue the following:

    sp_configure "allow updates to system tables", 1

    1. update sysdatabases
    set status = -32767
    where dbid = id for DB 'x'

    2. checkpoint master database

    3. shutdown and restart ASE Server

    The database should now be in by-pass recovery mode.

    4. use database 'x'

    5. dump tran database with no_log

    6. update sysdatabases set status = 0

    where dbid = ID for db 'x'

    9. checkpoint master

    10. shutdown and restart ASE

  4. #4
    Join Date
    Apr 2004
    Posts
    4
    It works!!! million thanks!



    Originally posted by mkalsi
    Try this...

    In the master database, issue the following:

    sp_configure "allow updates to system tables", 1

    1. update sysdatabases
    set status = -32767
    where dbid = id for DB 'x'

    2. checkpoint master database

    3. shutdown and restart ASE Server

    The database should now be in by-pass recovery mode.

    4. use database 'x'

    5. dump tran database with no_log

    6. update sysdatabases set status = 0

    where dbid = ID for db 'x'

    9. checkpoint master

    10. shutdown and restart ASE

Posting Permissions

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