Results 1 to 4 of 4

Thread: fast recovery

  1. #1
    Join Date
    Jun 2003
    Posts
    140

    Unanswered: fast recovery

    Hi All

    I've some doubts abt db recovery after ASE shutdown


    (1) What can I do to recover all the db faster than normal time taken

    (2) If ASE was shutdown with nowait and if there are long trans rolling back while restart , how can i speed up recovery

    (3) While restarting what 'll happen to the db which had tranlog full before shutdown (' dump tran with no log' did not clear tranlog and even sp_who could not be executed because tran log was full)

    All above questions are to do with ASE 11.9.2 , pl. also inform if there
    is somthing new to deal with in ASE 12.5 in such cases


    thx in advance

  2. #2
    Join Date
    Dec 2003
    Location
    Mumbai
    Posts
    7

    Re: fast recovery

    while recovering every database activities are recorded into the log file.

    either increase the log file size or use the option which will stop loging the recovery activities into the log file while loading the database.
    you can also use option to increase the cache size.

    regards,
    Gautam

    Originally posted by perl
    Hi All

    I've some doubts abt db recovery after ASE shutdown


    (1) What can I do to recover all the db faster than normal time taken

    (2) If ASE was shutdown with nowait and if there are long trans rolling back while restart , how can i speed up recovery

    (3) While restarting what 'll happen to the db which had tranlog full before shutdown (' dump tran with no log' did not clear tranlog and even sp_who could not be executed because tran log was full)

    All above questions are to do with ASE 11.9.2 , pl. also inform if there
    is somthing new to deal with in ASE 12.5 in such cases


    thx in advance

  3. #3
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Re: fast recovery

    [SIZE=1]Originally posted by perl
    (1) What can I do to recover all the db faster than normal time taken
    Add a 16K buffer pool if needed
    sp_dbrecovery_order to pass first your most important DB

    [SIZE=1]Originally posted by perl
    (2) If ASE was shutdown with nowait and if there are long trans rolling back while restart , how can i speed up recovery
    See 1)
    Else, it's posible to restart the server bypassing some recovery, but it's an at risk situation

    [SIZE=1]Originally posted by perl
    (3) While restarting what 'll happen to the db which had tranlog full before shutdown (' dump tran with no log' did not clear tranlog and even sp_who could not be executed because tran log was full)
    Are you using replication ?
    What's the status of a dbcc gettrunc() in the specific database ?
    sp_dboption YourDb, "abort tran", on

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208

    Re: fast recovery

    Originally posted by perl

    (1) What can I do to recover all the db faster than normal time taken Recovery has historically been single-threaded in Sybase. ASE 12.5.1 now provides multi-threaded faster recovery and also rcovers all databases at the sametime.
    http://sybooks.sybase.com/onlinebook...T_RESTART_N%25

    If you are not on 12.5.1, then the only way to speed up recovery is to checkpoint all user databases prior to shutdown.


    (2) If ASE was shutdown with nowait and if there are long trans rolling back while restart , how can i speed up recovery.
    You can't, although creating a 4K pool for the transaction log can greatly improve log performance.


    (3) While restarting what 'll happen to the db which had tranlog full before shutdown (' dump tran with no log' did not clear tranlog and even sp_who could not be executed because tran log was full)
    It will remain full after restart, and reuest you to take action either dump or alter database.


    All above questions are to do with ASE 11.9.2 , pl. also inform if there
    is somthing new to deal with in ASE 12.5 in such cases


    thx in advance

Posting Permissions

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