DR problem?
Posted in 1996
Hi,
When using DR, it sometimes cause a long time to wait for the DR to
complete.
online.log:
~~~~~~~~~~~
17:03:08 Checkpoint Completed: duration was 1 seconds.
17:03:42 Logical Log 101758 Complete.
17:03:45 Logical Log 101758 - Backup Started
17:03:46 Logical Log 101758 - Backup Completed
17:26:28 DR: ping timeout
17:26:28 DR: Receive error
17:26:31 DR: Turned off on primary server
17:26:31 Checkpoint Completed: duration was 1102 seconds.
17:26:31 DR: Cannot connect to secondary server
17:26:41 DR: Primary server connected
17:26:42 DR: Receive error
17:26:42 DR: Failure recovery error (2)
17:26:44 DR: Turned off on primary server
17:26:45 Checkpoint Completed: duration was 0 seconds.
17:26:45 DR: Cannot connect to secondary server
17:26:55 DR: Primary server connected
17:28:34 DR: Sending log 101758, size 500 pages, 100.00% used
17:28:39 Logical Log 101759 Complete.
17:28:40 DR: Sending log 101759, size 500 pages, 39.80% used
17:28:42 Logical Log 101759 - Backup Started
17:28:42 Logical Log 101759 - Backup Completed
17:28:44 DR: Sending log 101760 (current), size 500 pages, 0.00% used
17:28:44 DR: Sending Logical Logs Completed
17:28:59 DR: Primary server operational
17:28:59 DR: LBU_PRESERVE turned on while primary
17:29:00 Checkpoint Completed: duration was 0 seconds.
17:34:02 Checkpoint Completed: duration was 0 seconds.
17:38:50 Logical Log 101760 Complete.
17:38:52 Logical Log 101760 - Backup Started
17:38:53 Logical Log 101760 - Backup Completed
17:39:02 Checkpoint Completed: duration was 1 seconds.
17:44:03 Checkpoint Completed: duration was 1 seconds.
17:44:05 Logical Log 101761 Complete.
17:44:08 Logical Log 101761 - Backup Started
17:44:09 Logical Log 101761 - Backup Completed
17:49:05 Checkpoint Completed: duration was 1 seconds.
and the DR parameters:
INFORMIX-OnLine Version 7.12.UC1X8 -- On-Line (Prim) -- Up 26 days 21:10:45 -- 1
56776 Kbytes
Data Replication:
Type State Paired server Last DR CKPT (id/pg)
primary on u4bdrsoc 102264 / 36
DRINTERVAL -1
DRTIMEOUT 300
DRAUTO 0
DRLOSTFOUND /users/info712/dr.lost+found
Where is the problem?
Jack
.