hi,
We are trying to setup HDR (using IDS 7.31UD3X5a) on NCR UNIX.
The two enviroments are configured identically. HDR starts successfully
(We also created databases and table and everything works fine),
when we try to simulate a failure on the primary (onmode -ky), then the
secondary is manually set to standard. (Logical logs are backed up for
both the primary and the secondary).
When we are changing the failed server to primary (having also set
the secondary back to secondary) and applying the logs, the server
starts in fast recovery and sits there for ever.
Below is the message logs file:
(Pri)
$ onstat -
Informix Dynamic Server Version 7.31.UD3X5a -- Fast Recovery (Prim) (CKPT REQ) -- 24576 Kbytes
Blocked:CKPT
Thu Oct 23 17:44:41 2003
17:44:41 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh'
17:44:46 DR: DRAUTO is 0 (Off)
17:44:46 Requested shared memory segment size rounded from 176KB to 4096KB
17:44:46 Attempting to 'nail' shared memory id 2143...
17:44:46 Nailing (Memory residency) for id 2143 succeeded.
17:44:46 Informix Dynamic Server Version 7.31.UD3X5a
17:44:48 Informix Dynamic Server Initialized -- Shared Memory Initialized.
17:44:48 DR: Trying to connect to secondary server ...
17:44:49 DR: Primary server connected
17:44:50 Physical Recovery Started.
17:44:50 Physical Recovery Complete: 0 Pages Restored.
17:44:50 Dataskip is now OFF for all dbspaces
17:44:50 Restartable Restore has been ENABLED
17:44:50 Recovery Mode
17:44:52 DR: Start failure recovery from tape ...
17:45:24 Logical Recovery Started.
17:45:24 Start Logical Recovery - Start Log 13, End Log ?
17:45:24 Starting Log Position - 14 0x204c
17:45:24 Clearing the physical and logical logs has started
17:45:26 Cleared 29 MB of the physical and logical logs in 2 seconds
17:46:01 Suspending Logical Restore
17:46:01 Resuming Logical Restore
17:46:01 Checkpoint Completed: duration was 0 seconds.
17:46:01 Checkpoint loguniq 14, logpos 0x3018
17:46:01 Checkpoint Completed: duration was 0 seconds.
17:46:01 Checkpoint loguniq 32, logpos 0x18
17:46:13 Suspending Logical Restore
17:46:13 Resuming Logical Restore
17:46:43 DR: Failure recovery from disk in progress ...
(Sec)
$ onstat -
Informix Dynamic Server Version 7.31.UD3X5a -- Read-Only (Sec) -- 24576 Kbytes
$
17:43:31 DR: Turned off on secondary server
17:44:06 Checkpoint Completed: duration was 0 seconds.
17:44:06 Checkpoint loguniq 34, logpos 0x5d018
17:44:28 Shutdown Mode
17:44:29 Quiescent Mode
17:44:39 Checkpoint Completed: duration was 0 seconds.
17:44:39 Checkpoint loguniq 34, logpos 0x5e018
17:44:39 DR: new type = secondary, primary server name = servdevrepl_tcp
17:44:39 DR: Trying to connect to primary server ...
17:44:42 Recovery Mode
17:45:02 DR: Secondary server connected
17:46:56 DR: Sending log 33, size 250 pages, 1.20 percent used
17:46:57 DR: Sending log 34 (current), size 250 pages, 38.00 percent used
17:46:57 DR: Sending Logical Logs Completed
Can some one please help me out ?
Thanks
We are trying to setup HDR (using IDS 7.31UD3X5a) on NCR UNIX.
The two enviroments are configured identically. HDR starts successfully
(We also created databases and table and everything works fine),
when we try to simulate a failure on the primary (onmode -ky), then the
secondary is manually set to standard. (Logical logs are backed up for
both the primary and the secondary).
When we are changing the failed server to primary (having also set
the secondary back to secondary) and applying the logs, the server
starts in fast recovery and sits there for ever.
Below is the message logs file:
(Pri)
$ onstat -
Informix Dynamic Server Version 7.31.UD3X5a -- Fast Recovery (Prim) (CKPT REQ) -- 24576 Kbytes
Blocked:CKPT
Thu Oct 23 17:44:41 2003
17:44:41 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh'
17:44:46 DR: DRAUTO is 0 (Off)
17:44:46 Requested shared memory segment size rounded from 176KB to 4096KB
17:44:46 Attempting to 'nail' shared memory id 2143...
17:44:46 Nailing (Memory residency) for id 2143 succeeded.
17:44:46 Informix Dynamic Server Version 7.31.UD3X5a
17:44:48 Informix Dynamic Server Initialized -- Shared Memory Initialized.
17:44:48 DR: Trying to connect to secondary server ...
17:44:49 DR: Primary server connected
17:44:50 Physical Recovery Started.
17:44:50 Physical Recovery Complete: 0 Pages Restored.
17:44:50 Dataskip is now OFF for all dbspaces
17:44:50 Restartable Restore has been ENABLED
17:44:50 Recovery Mode
17:44:52 DR: Start failure recovery from tape ...
17:45:24 Logical Recovery Started.
17:45:24 Start Logical Recovery - Start Log 13, End Log ?
17:45:24 Starting Log Position - 14 0x204c
17:45:24 Clearing the physical and logical logs has started
17:45:26 Cleared 29 MB of the physical and logical logs in 2 seconds
17:46:01 Suspending Logical Restore
17:46:01 Resuming Logical Restore
17:46:01 Checkpoint Completed: duration was 0 seconds.
17:46:01 Checkpoint loguniq 14, logpos 0x3018
17:46:01 Checkpoint Completed: duration was 0 seconds.
17:46:01 Checkpoint loguniq 32, logpos 0x18
17:46:13 Suspending Logical Restore
17:46:13 Resuming Logical Restore
17:46:43 DR: Failure recovery from disk in progress ...
(Sec)
$ onstat -
Informix Dynamic Server Version 7.31.UD3X5a -- Read-Only (Sec) -- 24576 Kbytes
$
17:43:31 DR: Turned off on secondary server
17:44:06 Checkpoint Completed: duration was 0 seconds.
17:44:06 Checkpoint loguniq 34, logpos 0x5d018
17:44:28 Shutdown Mode
17:44:29 Quiescent Mode
17:44:39 Checkpoint Completed: duration was 0 seconds.
17:44:39 Checkpoint loguniq 34, logpos 0x5e018
17:44:39 DR: new type = secondary, primary server name = servdevrepl_tcp
17:44:39 DR: Trying to connect to primary server ...
17:44:42 Recovery Mode
17:45:02 DR: Secondary server connected
17:46:56 DR: Sending log 33, size 250 pages, 1.20 percent used
17:46:57 DR: Sending log 34 (current), size 250 pages, 38.00 percent used
17:46:57 DR: Sending Logical Logs Completed
Can some one please help me out ?
Thanks