HDR problem - ontape -p
Posted in 2005
Topics: High Availability & Replication, Backup & Restore, Server Administration, Networking & sqlhosts Configuration
Hello,
I have done the entries in SQLhosts/Services and Onconfig files for HDR on 2
servers ...
I have fired an "ontape -p" on secondary but its "onstat -g ath" shows :-
Informix Dynamic Server Version 7.31.FD6 -- Fast Recovery (CKPT REQ) -- Up 0
1:43:44 -- 928416 Kbytes
Blocked:CKPT
Threads:
tid tcb rstcb prty status vp-class
name
2 c0000000581a0828 0 2 sleeping forever 5lio
lio vp 0
3 c0000000581a0df0 0 2 sleeping forever 6pio
pio vp 0
4 c0000000581a13b8 0 2 running 7aio
aio vp 0
5 c0000000581a1980 0 2 sleeping forever 8msc
msc vp 0
6 c0000000581dfad8 0 2 sleeping forever 9aio
aio vp 1
7 c000000058200ec8 0 2 sleeping forever 10aio
aio vp 2
8 c000000058201490 0 2 sleeping forever 11aio
aio vp 3
9 c000000058201a58 0 2 sleeping forever 12aio
aio vp 4
10 c000000058db41e0 0 2 sleeping forever 13aio
aio vp 5
11 c000000058db47a8 0 2 sleeping forever 14aio
aio vp 6
12 c000000058db4d70 0 2 sleeping forever 15aio
aio vp 7
13 c000000058db5338 0 2 sleeping forever 16aio
aio vp 8
14 c000000058db5900 0 2 sleeping forever 17aio
aio vp 9
15 c000000058dba1e0 0 2 sleeping forever 18aio
aio vp 10
16 c000000058dba6c8 0 2 sleeping forever 19aio
aio vp 11
17 c000000058dbac30 0 2 sleeping forever 20aio
aio vp 14
18 c000000058dbb4b8 0 2 sleeping forever 21aio
aio vp 17
19 c000000058dbb778 0 2 sleeping forever 22aio
aio vp 16
20 c000000058dbbd40 0 2 sleeping forever 23aio
aio vp 18
21 c000000058dc01e0 0 2 sleeping forever 24aio
aio vp 19
22 c000000058dbaef0 0 2 sleeping forever 25aio
aio vp 15
23 c000000058dc0db8 0 2 sleeping forever 26aio
aio vp 13
24 c000000058dc1078 0 2 sleeping forever 27aio
aio vp 12
25 c000000058dc1c50 0 2 sleeping forever 28aio
aio vp 20
26 c000000058de84a8 0 2 sleeping forever 29aio
aio vp 21
27 c000000058de89d0 0 2 sleeping forever 30aio
aio vp 22
28 c000000058de8f98 0 2 sleeping forever 31aio
aio vp 23
29 c000000058de9560 0 2 sleeping forever 32aio
aio vp 24
30 c000000058de9b28 0 2 sleeping forever 33aio
aio vp 25
31 c000000058e0a4a8 0 2 sleeping forever 34aio
aio vp 26
32 c000000058e0a990 0 2 sleeping forever 35aio
aio vp 27
33 c000000058e0ae78 0 2 sleeping forever 36aio
aio vp 28
34 c000000058e0b440 0 2 sleeping forever 37aio
aio vp 29
35 c000000058e0ba08 0 2 sleeping forever 38aio
aio vp 30
36 c000000058e2c1e0 0 2 sleeping forever 39aio
aio vp 31
37 c000000058e2c768 0 2 sleeping forever 40aio
aio vp 32
38 c000000058e2ca28 0 2 sleeping forever 41aio
aio vp 33
39 c000000058e2cff0 0 2 sleeping forever 42aio
aio vp 34
40 c000000058e2d8c0 0 2 sleeping forever 43aio
aio vp 36
41 c000000058e5e1e0 0 2 sleeping forever 44aio
aio vp 37
42 c000000058e5e6c8 0 2 sleeping forever 45aio
aio vp 35
43 c000000058e5ebf0 0 2 sleeping forever 46aio
aio vp 38
44 c000000058e5f1b8 0 2 sleeping forever 47aio
aio vp 39
45 c000000058e5f780 0 2 sleeping forever 48aio
aio vp 40
46 c000000058e5fd48 0 2 sleeping forever 49aio
aio vp 41
47 c000000058e844e8 c000000058204028 4 sleeping secs: 1 3cpu
main_loop()
48 c000000058e84ab0 0 2 running 50soc
soctcppoll
49 c000000058e85078 0 2 cond wait arrived 51soc
soctcppoll
50 c000000058e85640 0 2 running 52soc
soctcppoll
51 c000000058e85c08 0 2 cond wait arrived 53soc
soctcppoll
52 c000000058ea64a8 0 2 cond wait arrived 54soc
soctcppoll
53 c000000058ea6990 0 2 running 55shm
sm_poll
54 c000000058ea6f98 0 3 sleeping forever 1cpu
soctcplst
55 c000000058ea7560 0 3 sleeping forever 1cpu
sm_listen
56 c000000058ea7c38 0 2 sleeping secs: 1 1cpu
sm_discon
57 c000000058ec84a8 c000000058204710 2 sleeping forever 3cpu
flush_sub(0)
58 c000000058ec8990 c000000058204df8 2 sleeping forever 1cpu
flush_sub(1)
59 c000000058ec8f58 c0000000582054e0 2 sleeping forever 1cpu
flush_sub(2)
60 c000000058ec9520 c000000058205bc8 2 sleeping forever 1cpu
flush_sub(3)
61 c000000058ec9ae8 c0000000582062b0 2 sleeping forever 1cpu
flush_sub(4)
62 c000000058ec9de8 c000000058206998 2 sleeping forever 1cpu
flush_sub(5)
63 c000000058eea850 c000000058207080 2 sleeping forever 1cpu
flush_sub(6)
64 c000000058eeae18 c000000058207768 2 sleeping forever 1cpu
flush_sub(7)
65 c000000058eeb3e0 c000000058207e50 2 sleeping forever 1cpu
flush_sub(8)
66 c000000058eeb9a8 c000000058208538 2 sleeping forever 1cpu
flush_sub(9)
67 c000000058f0c1e0 c000000058208c20 2 sleeping forever 1cpu
flush_sub(10)
68 c000000058f0c708 c000000058209308 2 sleeping forever 1cpu
flush_sub(11)
69 c000000058f0ccd0 c0000000582099f0 2 sleeping forever 1cpu
flush_sub(12)
70 c000000058f0d298 c00000005820a0d8 2 sleeping forever 1cpu
flush_sub(13)
71 c000000058f0d860 c00000005820a7c0 2 sleeping forever 1cpu
flush_sub(14)
72 c000000058f2e1e0 c00000005820aea8 2 sleeping forever 1cpu
flush_sub(15)
73 c000000058f2e6c8 c00000005820b590 2 sleeping forever 1cpu
flush_sub(16)
74 c000000058f2ebb0 c00000005820bc78 2 sleeping forever 1cpu
flush_sub(17)
75 c000000058f2f178 c00000005820c360 2 sleeping forever 1cpu
flush_sub(18)
76 c000000058f2f740 c00000005820ca48 2 sleeping forever 1cpu
flush_sub(19)
77 c000000058f2fd08 c00000005820d130 2 sleeping forever 1cpu
flush_sub(20)
78 c000000058f504a8 c00000005820d818 2 sleeping forever 1cpu
flush_sub(21)
79 c000000058f50a70 c00000005820df00 2 sleeping forever 1cpu
flush_sub(22)
80 c000000058f51038 c00000005820e5e8 2 sleeping forever 1cpu
flush_sub(23)
81 c000000058f51600 c00000005820ecd0 2 sleeping forever 1cpu
flush_sub(24)
82 c000000058f51bc8 c00000005820f3b8 2 sleeping forever 1cpu
flush_sub(25)
83 c000000058f724a8 c00000005820faa0 2 sleeping forever 1cpu
flush_sub(26)
84 c000000058f72990 c000000058210188 2 sleeping forever 1cpu
flush_sub(27)
85 c000000058f72ef8 c000000058210870 2 sleeping forever 1cpu
flush_sub(28)
86 c000000058f734c0 c000000058210f58 2 sleeping forever 1cpu
flush_sub(29)
87 c000000058f73a88 c000000058211640 2 sleeping forever 1cpu
flush_sub(30)
88 c000000058f94220 c000000058211d28 2 sleeping forever 1cpu
flush_sub(31)
89 c000000058f947e8 c000000058212410 2 sleeping forever 1cpu
flush_sub(32)
90 c000000058f94db0 c000000058212af8 2 sleeping forever 1cpu
flush_sub(33)
91 c000000058f95378 c0000000582131e0 2 sleeping forever 1cpu
flush_sub(34)
92 c000000058f95940 c0000000582138c8 2 sleeping forever 1cpu
flush_sub(35)
93 c000000058fb61e0 c000000058213fb0 2 sleeping forever 1cpu
flush_sub(36)
94 c000000058fb66c8 c000000058214698 2 sleeping forever 1cpu
flush_sub(37)
95 c000000058fb6c90 c000000058214d80 2 sleeping forever 1cpu
flush_sub(38)
96 c000000058fb7258 c000000058215468 2 sleeping forever 1cpu
flush_sub(39)
97 c000000058fb7820 c000000058215b50 2 sleeping forever 1cpu
flush_sub(40)
98 c000000058fb7de8 c000000058216238 2 sleeping forever 1cpu
flush_sub(41)
99 c000000058fe2588 c000000058216920 2 sleeping forever 1cpu
flush_sub(42)
100 c000000058fe2b50 c000000058217008 2 sleeping forever 1cpu
flush_sub(43)
101 c000000058fe3118 c0000000582176f0 2 sleeping forever 1cpu
flush_sub(44)
102 c000000058fe36e
>
-----Original Message-----
> From: forum.subscriber@iiug.org
> [mailto:forum.subscriber@iiug.org] On Behalf Of SANTOSH NIKUMBH
> Sent: Friday, July 15, 2005 2:59 AM
> To: ids@iiug.org
> Subject: HDR problem - ontape -p [5437]
>
> Hello,
>
>
>
> I have done the entries in SQLhosts/Services and Onconfig
> files for HDR on 2 servers ...
>
> I have fired an "ontape -p" on secondary but its "onstat
> -g ath" shows :-
> Informix Dynamic Server Version 7.31.FD6 -- Fast Recovery
> (CKPT REQ) -- Up 0
> 1:43:44 -- 928416 Kbytes
> Blocked:CKPT
>
> Threads:
> tid tcb rstcb prty status
> vp-class
> name
> 2 c0000000581a0828 0 2 sleeping
> forever 5lio
> lio vp 0
> 3 c0000000581a0df0 0 2 sleeping
> forever 6pio
> pio vp 0
> 4 c0000000581a13b8 0 2 running
> 7aio
> aio vp 0
<<snipped>>
> 118 c0000000590e7a10 c00000005821e570 2 cond wait
> netnorm 1cpu
> ontape> 119 c000000059108228 c00000005821ec58 4 sleeping
> forever 1cpu
> physrecover
>
>
>
> my question is :-
> 1] Is this normal ?
> 2] How do I confirm whether restore is going to work or not ?
Other than having a lot of AIO VP's (I assume by that that you are *not*
using raw disk), looks OK to me. The status line (first line of onstat
output) looks normal for an ontape -p.
If I were you, I would just go ahead and issue the "onmode -d ..."
commands on the primary and secondary, then watch the message logs to
make sure that primary / secondary connect, send log info across
(primary to secondary), and go operational.
If you run into problems, simply issue "onmode -d standard" on the
primary and/or shut down the secondary.
HTH,
Paul Mosser
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g