Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Location
    zxczxczxc
    Posts
    52

    Unanswered: ontape restore taking time

    Hi,
    I am working on HP-UX 11i and IDS 9.3. I am trying to restore the data using ontape. the server is in Fast recovery mode for a long time even after the Dbspaces restore is complete. For restoring the actual data its taking around 10 min and for clearing the physical log its taking 45 min. In the message log it says clearing the physical and logical logs started and stays in Recovery mode for 2450 seconds.

    Here is the message from log file.


    11:42:56 Checkpoint Completed: duration was 0 seconds.
    11:42:56 Checkpoint loguniq 60, logpos 0x7983018

    11:42:56 Maximum server connections 0
    11:42:58 Physical Restore of scl_rootdbs, scldbs1, scldbs2, scldbs3, scldbs4, scldbs5, scldbs6, scldbs7, scldbs8, scldbs9, sc
    ldbs10, scllocaldbs1, scldbs11, scldbs12, scldbs Completed.
    11:42:58 Checkpoint Completed: duration was 0 seconds.
    11:42:58 Checkpoint loguniq 60, logpos 0x7983018

    11:42:58 Maximum server connections 0
    11:47:30 No logical log restore will be performed.
    11:47:30 Preparing Physical Log for Fast Recovery ...
    11:47:30 Clearing the physical and logical logs has started
    12:28:21 Cleared 1013 MB of the physical and logical logs in 2450 seconds
    12:28:21 Physical Recovery Started at Page(1:31210).
    12:28:21 Physical Recovery Complete: 0 Pages Examined 0 Pages Restored.

    12:28:21 Logical Recovery Started.
    12:28:21 10 recovery worker threads will be started.
    12:28:21 Checkpoint Completed: duration was 0 seconds.
    12:28:21 Checkpoint loguniq 60, logpos 0x7983018

    12:28:21 Maximum server connections 0
    12:28:23 Logical Recovery has reached the transaction cleanup phase.
    12:28:23 Logical Recovery Complete.
    0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

    12:28:24 Bringing system to Quiescent Mode with no Logical Restore.

    12:28:25 Quiescent Mode
    12:28:25 Checkpoint Completed: duration was 0 seconds.

    Any inputs on this problem so that i can decrease the recovery time.


    Bye.
    zxczxczc

  2. #2
    Join Date
    Jan 2005
    Posts
    30
    Try to use more than one chunk for physdbs and logdbs.

    SC

Posting Permissions

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