If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > ontape restore taking time

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-25-05, 03:54
pathri pathri is offline
Registered User
 
Join Date: Apr 2004
Location: zxczxczxc
Posts: 52
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
Reply With Quote
  #2 (permalink)  
Old 01-31-05, 02:38
saatatya saatatya is offline
Registered User
 
Join Date: Jan 2005
Posts: 30
Try to use more than one chunk for physdbs and logdbs.

SC
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On