Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Informix Новый топик    Ответить
 Ombar backup level 1 problem  [new]
Maxim_Z
Guest
Уважаемы господа!
Помогите разобраться со следующей проблемой:

Имеется 3 database instance (IDS 9.21.FC3) с общим объемом данных около 500 Гбайт работающие под HX-UX 11.0. Для backup используется Legato, работающий под Windows 2000. Согласно расписания выполняется backup level 0 каждую субботу и level 1 в остальные дни.
Проблема в том что одна из database instance упорно отказывается выполнять backup level 1 выполняя вместо этого level 0. И так каждый день :-(

Bar_act.log:
2005-05-16 16:32:32 5939 5938 Completed level 0 backup sp050 (Storage Manager copy ID: 1116275510 1116275557).
2005-05-16 16:32:32 5939 5938 Begin level 0 backup sp051.
2005-05-16 16:35:41 5939 5938 Completed level 0 backup sp051 (Storage Manager copy ID: 1116275552 1116275600).
2005-05-16 16:35:46 5939 5938 Begin backup logical log 493.
2005-05-16 16:35:46 5939 5938 Successfully connected to Storage Manager.
2005-05-16 16:35:47 5939 5938 Completed backup logical log 493 (Storage Manager copy ID: 1116275746 1116275747).
2005-05-16 22:08:51 2279 2277 /usr/local/informix/9.21/bin/onbar_d -b -l
2005-05-16 22:08:51 2279 2277 /usr/local/informix/9.21/bin/onbar_d complete, returning 0 (0x00)
2005-05-17 03:00:22 14395 14394 /usr/local/informix/9.21/bin/onbar_d -b -L 1
2005-05-17 03:00:25 14395 14394 rootdbs does not have a level 0 backup. A level 0 backup will be
performed by default.
2005-05-17 03:00:25 14395 14394 loglog1 does not have a level 0 backup. A level 0 backup will be
performed by default.
2005-05-17 03:00:26 14395 14394 loglog2 does not have a level 0 backup. A level 0 backup will be
performed by default.
…..
2005-05-17 11:47:11 14395 14394 Begin level 0 backup sp049.
2005-05-17 11:49:27 14395 14394 Completed level 0 backup sp049 (Storage Manager copy ID: 1116344831 1116344877).
2005-05-17 11:49:27 14395 14394 Begin level 0 backup sp050.
2005-05-17 11:50:37 14395 14394 Completed level 0 backup sp050 (Storage Manager copy ID: 1116344967 1116345014).
2005-05-17 11:50:37 14395 14394 Begin level 0 backup sp051.
2005-05-17 11:56:01 14395 14394 Completed level 0 backup sp051 (Storage Manager copy ID: 1116345037 1116345085).
2005-05-17 11:56:07 14395 14394 Begin backup logical log 494.
2005-05-17 11:56:07 14395 14394 Successfully connected to Storage Manager.
2005-05-17 11:56:08 14395 14394 Completed backup logical log 494 (Storage Manager copy ID: 1116345367 1116345368).
2005-05-17 11:56:08 14395 14394 /usr/local/informix/9.21/bin/onbar_d complete, returning 0 (0x00)
2005-05-17 11:56:09 11588 11586 /usr/local/informix/9.21/bin/onbar_d -b -l
2005-05-17 11:56:09 11588 11586 /usr/local/informix/9.21/bin/onbar_d complete, returning 0 (0x00)
2005-05-18 03:00:23 20116 20115 /usr/local/informix/9.21/bin/onbar_d -b -L 1
2005-05-18 03:00:25 20116 20115 rootdbs does not have a level 0 backup. A level 0 backup will be
performed by default.
2005-05-18 03:00:26 20116 20115 loglog1 does not have a level 0 backup. A level 0 backup will be
performed by default.
2005-05-18 03:00:26 20116 20115 loglog2 does not have a level 0 backup. A level 0 backup will be
performed by default.
2005-05-18 03:00:27 20116 20115 loglog3 does not have a level 0 backup. A level 0 backup will be
performed by default.

Backup L1 для второй database instance до недавнего времени работал корректно, однако после добавления нового chunk и backup level 0 стал работать так же как описано выше.

Backup L1 для третей database instance стал работать по той же схеме без видимой причины с начала этой недели.
“Onmonitor” и “onstst –g arc” показывают противоречивую информацию.

Onmonitor -> Achive
ARCHIVE INFORMATION
Level of Date and Time Logical Log Used
Archive of Archive at Time of Archive
0 0
1 0
2 0

onstat -g arc

Informix Dynamic Server 2000 Version 9.21.FC3 -- On-Line -- Up 72 days 22:42:58 -- 384004 Kbytes


num DBSpace Q Size Q Len Buffer partnum size scanner
1 rootdbs 0 0 0x1000b3
2 loglog1 0 0
3 loglog2 0 0
4 loglog3 0 0
5 physlog3 0 0
9 sp009 3 0 12 0x800054 0
10 sp010 3 0 4 0x6000ae 0
11 sp011 5 0 19 0x70066b 128
12 sp012 4 0 4 0x6000b4 0
13 sp013 2 0 6 0x6000b2 0
14 sp014 4 0 1 0x6000a4 96
15 sp015 11 0 3 0x70066f 384
16 sp016 8 0 29 0x6000a6 480
17 sp017 0 0
18 sp018 4 0 0 0x6000ab 160
19 sp019 9 0 9 0x6000aa 480
20 sp020 5 0 7 0x80004f 96
21 sp021 3 0 7 0x700662 0
22 sp022 5 0 30 0x6000af 128
23 sp023 13 0 11 0x800053 384
24 sp024 5 0 5 0x70066c 128
25 sp025 7 0 12 0x700667 384
26 sp026 12 0 8 0x800050 256
27 sp027 11 0 7 0x6000b1 960
28 sp028 6 0 23 0x6000b0 128
29 sp029 1 0 3 0x700669 0
30 sp030 5 0 5 0x700664 64
31 sp031 55 0 25 0x6000b3 704
32 sp032 5 0 1 0x700671 192
33 sp033 6 0 28 0x80004b 256
34 sp034 9 0 28 0x800047 352
35 sp035 6 0 28 0x800044 256
36 sp036 5 0 21 0x70066d 96
37 sp037 8 0 31 0x6000ad 448
38 sp038 4 0 15 0x700668 320
39 sp039 58 0 15 0x6000ac 1952
40 sp040 8 0 8 0x80004e 512
41 sp041 5 0 27 0x800051 128
42 sp042 25 0 27 0x70066a 992
43 sp043 111 0 23 0x80004a 14048
44 sp044 6 0 21 0x800040 256
45 sp045 7 0 20 0x700670 64
46 sp046 142 0 12 0x800048 21504
47 sp047 7 0 14 0x700673 0
48 sp048 7 0 14 0x800057 0
49 sp049 4 0 6 0x800056 96
50 sp050 4 0 7 0x6000b5 128
51 sp051 6 0 7 0x6000b6 192

Dbspaces - Archive Status
name number level date log log-position
rootdbs 1 0 05/17/2005.03:01 494 0x1e3018
loglog1 2 0 05/17/2005.03:01 494 0x1e3018
loglog2 3 0 05/17/2005.03:01 494 0x1e3018
loglog3 4 0 05/17/2005.03:01 494 0x1e3018
physlog3 5 0 05/17/2005.03:01 494 0x1e3018
sp009 9 0 05/17/2005.03:01 494 0x1e3018
sp010 10 0 05/17/2005.03:01 494 0x1e3018
sp011 11 0 05/17/2005.03:01 494 0x1e3018
sp012 12 0 05/17/2005.03:01 494 0x1e3018
sp013 13 0 05/17/2005.03:01 494 0x1e3018
sp014 14 0 05/17/2005.03:01 494 0x1e3018
sp015 15 0 05/17/2005.03:01 494 0x1e3018
sp016 16 0 05/17/2005.03:01 494 0x1e3018
sp017 17 0 05/17/2005.03:01 494 0x1e3018
sp018 18 0 05/17/2005.03:01 494 0x1e3018
sp019 19 0 05/17/2005.03:01 494 0x1e3018
sp020 20 0 05/17/2005.03:01 494 0x1e3018
sp021 21 0 05/17/2005.03:01 494 0x1e3018
sp022 22 0 05/17/2005.03:01 494 0x1e3018
sp023 23 0 05/17/2005.03:01 494 0x1e3018
sp024 24 0 05/17/2005.03:01 494 0x1e3018
sp025 25 0 05/17/2005.03:01 494 0x1e3018
sp026 26 0 05/17/2005.03:01 494 0x1e3018
sp027 27 0 05/17/2005.03:01 494 0x1e3018
sp028 28 0 05/17/2005.03:01 494 0x1e3018
sp029 29 0 05/17/2005.03:01 494 0x1e3018
sp030 30 0 05/17/2005.03:01 494 0x1e3018
sp031 31 0 05/17/2005.03:01 494 0x1e3018
sp032 32 0 05/17/2005.03:01 494 0x1e3018
sp033 33 0 05/17/2005.03:01 494 0x1e3018
sp034 34 0 05/17/2005.03:01 494 0x1e3018
sp035 35 0 05/17/2005.03:01 494 0x1e3018
sp036 36 0 05/17/2005.03:01 494 0x1e3018
sp037 37 0 05/17/2005.03:01 494 0x1e3018
sp038 38 0 05/17/2005.03:01 494 0x1e3018
sp039 39 0 05/17/2005.03:01 494 0x1e3018
sp040 40 0 05/17/2005.03:01 494 0x1e3018
sp041 41 0 05/17/2005.03:01 494 0x1e3018
sp042 42 0 05/17/2005.03:01 494 0x1e3018
sp043 43 0 05/17/2005.03:01 494 0x1e3018
sp044 44 0 05/17/2005.03:01 494 0x1e3018
sp045 45 0 05/17/2005.03:01 494 0x1e3018
sp046 46 0 05/17/2005.03:01 494 0x1e3018
sp047 47 0 05/17/2005.03:01 494 0x1e3018
sp048 48 0 05/17/2005.03:01 494 0x1e3018
sp049 49 0 05/17/2005.03:01 494 0x1e3018
sp050 50 0 05/17/2005.03:01 494 0x1e3018
sp051 51 0 05/17/2005.03:01 494 0x1e3018



Заранее спасибо за подсказки
18 май 05, 21:31    [1553235]     Ответить | Цитировать Сообщить модератору
 Re: Ombar backup level 1 problem  [new]
Andron
Member

Откуда: Cherepovets
Сообщений: 1816
Вот эти записи в bar_act.log настораживают :
... does not have a level 0 backup ...

onbar не находит в sysutils информации о предшествующем Level-0, а раз он этого не видит, то и делает Level-0 а не 1. Проверьте базу sysutils с помощью oncheck. Можно также посмотреть в файл ixbar.$servernum есть ли там записи о Level-0.
18 май 05, 22:03    [1553266]     Ответить | Цитировать Сообщить модератору
 Re: Ombar backup level 1 problem  [new]
Maxim_Z
Guest
Так в том и вопрос почему onbar рапортует что все в порядке а на следующий день не находит информации о backup L0. Что и куда он забыл засать? И почему onmonitor и onstat показывают разную информацию.

oncheck делал проблем нет.
Фрагмент файла прилагаю

orate_shm loglog2 CD 0 7148 0 1116140468 1116140471 2005-05-15 03:01:07 1 0 0 7148 0 - -
orate_shm loglog3 CD 0 7149 0 1116140469 1116140473 2005-05-15 03:01:09 1 0 0 7149 0 - -
orate_shm physlog3 CD 0 7150 0 1116140470 1116140475 2005-05-15 03:01:10 1 0 0 7150 0 - -
orate_shm sp009 ND 0 7151 0 1116140471 1116140477 2005-05-15 03:01:10 1 0 0 7151 0 - -
orate_shm sp010 ND 0 7152 0 1116142287 1116142294 2005-05-15 03:31:27 1 0 0 7152 0 - -
orate_shm sp011 ND 0 7153 0 1116144681 1116144689 2005-05-15 04:11:21 1 0 0 7153 0 - -
orate_shm sp012 ND 0 7154 0 1116146260 1116146269 2005-05-15 04:37:40 1 0 0 7154 0 - -
orate_shm sp013 ND 0 7155 0 1116147641 1116147651 2005-05-15 05:00:41 1 0 0 7155 0 - -
orate_shm sp014 ND 0 7156 0 1116148664 1116148675 2005-05-15 05:17:44 1 0 0 7156 0 - -
orate_shm sp015 ND 0 7157 0 1116149670 1116149682 2005-05-15 05:34:30 1 0 0 7157 0 - -
orate_shm sp016 ND 0 7158 0 1116150687 1116150700 2005-05-15 05:51:27 1 0 0 7158 0 - -
orate_shm sp017 ND 0 7159 0 1116151209 1116151223 2005-05-15 06:00:09 1 0 0 7159 0 - -
orate_shm sp018 ND 0 7160 0 1116151767 1116151782 2005-05-15 06:09:27 1 0 0 7160 0 - -
orate_shm sp019 ND 0 7161 0 1116152700 1116152716 2005-05-15 06:25:00 1 0 0 7161 0 - -
orate_shm sp020 ND 0 7162 0 1116153329 1116153346 2005-05-15 06:35:29 1 0 0 7162 0 - -
orate_shm sp021 ND 0 7163 0 1116153738 1116153756 2005-05-15 06:42:18 1 0 0 7163 0 - -
orate_shm sp022 ND 0 7164 0 1116154438 1116154457 2005-05-15 06:53:58 1 0 0 7164 0 - -
orate_shm sp023 ND 0 7165 0 1116156080 1116156100 2005-05-15 07:21:20 1 0 0 7165 0 - -
orate_shm sp024 ND 0 7166 0 1116156540 1116156561 2005-05-15 07:29:00 1 0 0 7166 0 - -
orate_shm sp025 ND 0 7167 0 1116157207 1116157229 2005-05-15 07:40:07 1 0 0 7167 0 - -
orate_shm sp026 ND 0 7168 0 1116157690 1116157713 2005-05-15 07:48:10 1 0 0 7168 0 - -
orate_shm sp027 ND 0 7169 0 1116158699 1116158723 2005-05-15 08:04:59 1 0 0 7169 0 - -
orate_shm sp028 ND 0 7170 0 1116159306 1116159331 2005-05-15 08:15:06 1 0 0 7170 0 - -
orate_shm sp029 ND 0 7171 0 1116161457 1116161483 2005-05-15 08:50:57 1 0 0 7171 0 - -
orate_shm sp030 ND 0 7172 0 1116161959 1116161986 2005-05-15 08:59:19 1 0 0 7172 0 - -
orate_shm sp031 ND 0 7173 0 1116162609 1116162637 2005-05-15 09:10:09 1 0 0 7173 0 - -
orate_shm sp032 ND 0 7174 0 1116163025 1116163054 2005-05-15 09:17:05 1 0 0 7174 0 - -
orate_shm sp033 ND 0 7175 0 1116163531 1116163561 2005-05-15 09:25:31 1 0 0 7175 0 - -
orate_shm sp034 ND 0 7176 0 1116164103 1116164134 2005-05-15 09:35:03 1 0 0 7176 0 - -
orate_shm 492 L 0 7177 0 1116198393 1116198394 2005-05-15 19:06:33 1 0 0 7177 0 - -
orate_shm rootdbs R 0 7179 0 1116253194 1116253195 2005-05-16 10:19:54 1 0 0 7179 0 - -
orate_shm loglog1 CD 0 7180 0 1116253198 1116253200 2005-05-16 10:19:58 1 0 0 7180 0 - -
orate_shm loglog2 CD 0 7181 0 1116253199 1116253202 2005-05-16 10:19:59 1 0 0 7181 0 - -
orate_shm loglog3 CD 0 7182 0 1116253200 1116253204 2005-05-16 10:20:00 1 0 0 7182 0 - -
orate_shm physlog3 CD 0 7183 0 1116253201 1116253206 2005-05-16 10:20:01 1 0 0 7183 0 - -
orate_shm sp009 ND 0 7184 0 1116253202 1116253208 2005-05-16 10:20:02 1 0 0 7184 0 - -
orate_shm sp010 ND 0 7185 0 1116255254 1116255261 2005-05-16 10:54:14 1 0 0 7185 0 - -
orate_shm sp011 ND 0 7186 0 1116257677 1116257685 2005-05-16 11:34:36 1 0 0 7186 0 - -
orate_shm sp012 ND 0 7187 0 1116258659 1116258668 2005-05-16 11:50:59 1 0 0 7187 0 - -
orate_shm sp013 ND 0 7188 0 1116259480 1116259490 2005-05-16 12:04:40 1 0 0 7188 0 - -
orate_shm sp014 ND 0 7189 0 1116260057 1116260068 2005-05-16 12:14:17 1 0 0 7189 0 - -
orate_shm sp015 ND 0 7190 0 1116260621 1116260633 2005-05-16 12:23:41 1 0 0 7190 0 - -
orate_shm sp016 ND 0 7191 0 1116261201 1116261214 2005-05-16 12:33:21 1 0 0 7191 0 - -
orate_shm sp017 ND 0 7192 0 1116261485 1116261499 2005-05-16 12:38:05 1 0 0 7192 0 - -
orate_shm sp018 ND 0 7193 0 1116261813 1116261828 2005-05-16 12:43:33 1 0 0 7193 0 - -
orate_shm sp019 ND 0 7194 0 1116262363 1116262379 2005-05-16 12:52:43 1 0 0 7194 0 - -
orate_shm sp020 ND 0 7195 0 1116262703 1116262720 2005-05-16 12:58:23 1 0 0 7195 0 - -
orate_shm sp021 ND 0 7196 0 1116262927 1116262945 2005-05-16 13:02:07 1 0 0 7196 0 - -
orate_shm sp022 ND 0 7197 0 1116263312 1116263331 2005-05-16 13:08:32 1 0 0 7197 0 - -
orate_shm sp023 ND 0 7198 0 1116264197 1116264217 2005-05-16 13:23:17 1 0 0 7198 0 - -
orate_shm sp024 ND 0 7199 0 1116264440 1116264461 2005-05-16 13:27:20 1 0 0 7199 0 - -
orate_shm sp025 ND 0 7200 0 1116264804 1116264826 2005-05-16 13:33:24 1 0 0 7200 0 - -
orate_shm sp026 ND 0 7201 0 1116265076 1116265099 2005-05-16 13:37:56 1 0 0 7201 0 - -
orate_shm sp027 ND 0 7202 0 1116265705 1116265729 2005-05-16 13:48:25 1 0 0 7202 0 - -
orate_shm sp028 ND 0 7203 0 1116266054 1116266079 2005-05-16 13:54:14 1 0 0 7203 0 - -
orate_shm sp029 ND 0 7204 0 1116267359 1116267385 2005-05-16 14:15:59 1 0 0 7204 0 - -
orate_shm sp030 ND 0 7205 0 1116267655 1116267682 2005-05-16 14:20:55 1 0 0 7205 0 - -
orate_shm sp031 ND 0 7206 0 1116268037 1116268065 2005-05-16 14:27:17 1 0 0 7206 0 - -
orate_shm sp032 ND 0 7207 0 1116268291 1116268320 2005-05-16 14:31:31 1 0 0 7207 0 - -
orate_shm sp033 ND 0 7208 0 1116268588 1116268618 2005-05-16 14:36:28 1 0 0 7208 0 - -
orate_shm sp034 ND 0 7209 0 1116268961 1116268992 2005-05-16 14:42:41 1 0 0 7209 0 - -
orate_shm sp035 ND 0 7210 0 1116269345 1116269377 2005-05-16 14:49:05 1 0 0 7210 0 - -
orate_shm sp036 ND 0 7211 0 1116270493 1116270526 2005-05-16 15:08:13 1 0 0 7211 0 - -
orate_shm sp037 ND 0 7212 0 1116270937 1116270971 2005-05-16 15:15:37 1 0 0 7212 0 - -
orate_shm sp038 ND 0 7213 0 1116271572 1116271607 2005-05-16 15:26:12 1 0 0 7213 0 - -
orate_shm sp039 ND 0 7214 0 1116271906 1116271942 2005-05-16 15:31:46 1 0 0 7214 0 - -
orate_shm sp040 ND 0 7215 0 1116272062 1116272099 2005-05-16 15:34:22 1 0 0 7215 0 - -
orate_shm sp041 ND 0 7216 0 1116272352 1116272390 2005-05-16 15:39:12 1 0 0 7216 0 - -
orate_shm sp042 ND 0 7217 0 1116274110 1116274149 2005-05-16 16:08:30 1 0 0 7217 0 - -
orate_shm sp043 ND 0 7218 0 1116274396 1116274436 2005-05-16 16:13:16 1 0 0 7218 0 - -
orate_shm sp044 ND 0 7219 0 1116274638 1116274679 2005-05-16 16:17:18 1 0 0 7219 0 - -
orate_shm sp045 ND 0 7220 0 1116274844 1116274886 2005-05-16 16:20:44 1 0 0 7220 0 - -
orate_shm sp046 ND 0 7221 0 1116275072 1116275115 2005-05-16 16:24:32 1 0 0 7221 0 - -
orate_shm sp047 ND 0 7222 0 1116275270 1116275314 2005-05-16 16:27:50 1 0 0 7222 0 - -
orate_shm sp048 ND 0 7223 0 1116275347 1116275392 2005-05-16 16:29:07 1 0 0 7223 0 - -
orate_shm sp049 ND 0 7224 0 1116275422 1116275468 2005-05-16 16:30:22 1 0 0 7224 0 - -
orate_shm sp050 ND 0 7225 0 1116275510 1116275557 2005-05-16 16:31:50 1 0 0 7225 0 - -
orate_shm sp051 ND 0 7226 0 1116275552 1116275600 2005-05-16 16:32:32 1 0 0 7226 0 - -

orate_shm 493 L 0 7227 0 1116275746 1116275747 2005-05-16 16:35:46 1 0 0 7227 0 - -
18 май 05, 22:48    [1553314]     Ответить | Цитировать Сообщить модератору
 Re: Ombar backup level 1 problem  [new]
Vybegallo
Guest
1. приложите результат oncheck -pr в части, касающейся бэкапов
2. покажите, что у вас в ixbar файле
3. попробуйте установить BAR_DEBUG и BAR_DEBUG_LOG и запостьте лог файл
см http://www.geocities.com/Heartland/Acres/4927/debug.html
19 май 05, 00:13    [1553397]     Ответить | Цитировать Сообщить модератору
 Re: Ombar backup level 1 problem  [new]
Maxim_Z
Guest
1. oncheck -pr
Validating Informix Dynamic Server 2000 reserved pages

Validating PAGE_PZERO...

Identity INFORMIX-OnLine Copyrigh
t(C) 1986-1995 Informix
Software, Inc.
Database system state 0
Database system flags 0x1
Page Size 2048 (b)
Date/Time created 07/20/1998 10:55:39
Version number of creator 8
Last modified time stamp 0

Validating PAGE_CONFIG...

ROOTNAME rootdbs
ROOTPATH /CHUNKS/e2d3c5
ROOTOFFSET 0 (k)
ROOTSIZE 432000 (k)
MIRROR 1
MIRRORPATH
MIRROROFFSET 0 (k)
JVPHOME
.....
ONDBSPACEDOWN 0
LBU_PRESERVE 0
OPCACHEMAX 0 (k)
BAR_ACT_LOG /tmp/bar_act.log.vista
BAR_DEBUG_LOG /tmp/bar_dbug.log
BAR_MAX_BACKUP 2
ONCONFIG config file error on element BAR_MAX_BACKUP.
Value in reserved page: 2
Value in config file: 1
BAR_RETRY 1
BAR_DEBUG 0
BAR_BSALIB_PATH /usr/lib/libxnmi.sl.1
RESTARTABLE_RESTORE 0
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31 (p)
BAR_PROGRESS_FREQ 0
BAR_HISTORY 0
CDR_LOGBUFFERS 2048 (k)

Validating PAGE_1CKPT & PAGE_2CKPT...
Using check point page PAGE_2CKPT.

Time stamp of checkpoint 0xeee0a699
Time of checkpoint 05/19/2005 10:34:59
Physical log begin address 0x500035
Physical log size 53947 (p)
Physical log position at Ckpt 10553
Logical log unique identifier 495
Logical log position at Ckpt 0xbc65f4 (Page 3014, byte 1524)
DBspace descriptor page 0x100004
Chunk descriptor page 0x100007
Mirror chunk descriptor page 0x100009

Log file number 1
Unique identifier 3264548
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 0x2a2d
Log size 1760 (p)
Number pages used 131077
Date/Time file filled 12/31/1969 19:07:42
Time stamp 0x425faef9

......

Log file number 100
Unique identifier 2215972
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 0x2a2d
Log size 4 (p)
Number pages used 495
Date/Time file filled 12/31/1969 19:07:41
Time stamp 0x425e5b2c

Fast recovery starting point: Log ID 495, Position 0xa56228

Validating PAGE_1DBSP & PAGE_2DBSP...
Using DBspace page PAGE_1DBSP.

DBspace number 1
DBspace name rootdbs
Flags 0x1 No mirror chunks
Number of chunks 1
First chunk 1
Date/Time created 07/20/1998 10:55:39
Partition table page number 14
Logical Log Unique Id 0
Logical Log Position 0x0
Oldest Logical Log Unique Id 0
Last Logical Log Unique Id 0
DBspace archive status

Archive Level 0
Real Time Archive Began 05/17/2005 03:01:03
Time Stamp Archive Began -346326556
Logical Log Unique Id 494
Logical Log Position 0x1e3018

DBspace number 2
DBspace name loglog1
Flags 0x1 No mirror chunks
Number of chunks 1
First chunk 2
Date/Time created 07/20/1998 11:24:32
Partition table page number 4
Logical Log Unique Id 0
Logical Log Position 0x0
Oldest Logical Log Unique Id 0
Last Logical Log Unique Id 0
DBspace archive status

Archive Level 0
Real Time Archive Began 05/17/2005 03:01:03
Time Stamp Archive Began -346326556
Logical Log Unique Id 494
Logical Log Position 0x1e3018

.......
DBspace number 50
DBspace name sp050
Flags 0x1 No mirror chunks
Number of chunks 1
First chunk 126
Date/Time created 05/04/2001 17:09:56
Partition table page number 4
Logical Log Unique Id 0
Logical Log Position 0x0
Oldest Logical Log Unique Id 0
Last Logical Log Unique Id 0
DBspace archive status

Archive Level 0
Real Time Archive Began 05/17/2005 03:01:03
Time Stamp Archive Began -346326556
Logical Log Unique Id 494
Logical Log Position 0x1e3018

DBspace number 51
DBspace name sp051
Flags 0x1 No mirror chunks
Number of chunks 2
First chunk 127
Date/Time created 05/04/2001 17:19:41
Partition table page number 4
Logical Log Unique Id 0
Logical Log Position 0x0
Oldest Logical Log Unique Id 0
Last Logical Log Unique Id 0
DBspace archive status

Archive Level 0
Real Time Archive Began 05/17/2005 03:01:03
Time Stamp Archive Began -346326556
Logical Log Unique Id 494
Logical Log Position 0x1e3018

Validating PAGE_1PCHUNK & PAGE_2PCHUNK...
Using primary chunk page PAGE_2PCHUNK.

Chunk number 1
Flags 0x40 Chunk is online
Chunk path /CHUNKS/e2d3c5
Chunk offset 0 (p)
Chunk size 216000 (p)
Number of free pages 213007
DBspace number 1

Chunk number 2
Flags 0x40 Chunk is online
Chunk path /CHUNKS/e1d8c5
Chunk offset 0 (p)
Chunk size 216000 (p)
Number of free pages 7
DBspace number 2
....
Chunk number 208
Flags 0x40 Chunk is online
Chunk path /CHUNKS/orate/or1d3c3
Chunk offset 256000 (p)
Chunk size 256000 (p)
Number of free pages 255997
DBspace number 51

Validating PAGE_1MCHUNK & PAGE_2MCHUNK...
Using mirror chunk page PAGE_2MCHUNK.

Validating PAGE_1ARCH & PAGE_2ARCH...
Using archive page PAGE_2ARCH.

No archives have occurred.


DR has not been initialized.

2. Фрагмент был приведен выше
19 май 05, 19:09    [1556890]     Ответить | Цитировать Сообщить модератору
 Re: Ombar backup level 1 problem  [new]
Maxim_Z
Guest
3. За ссылки спасибо буду изучать
19 май 05, 19:09    [1556893]     Ответить | Цитировать Сообщить модератору
 Re: Ombar backup level 1 problem  [new]
vybegallo
Guest
Validating PAGE_1ARCH & PAGE_2ARCH...
Using archive page PAGE_2ARCH.

No archives have occurred.

Вот почему он требует архива L0 - в резервных страницах не сохранена инфо о прошедших бэкапах.
19 май 05, 21:45    [1557090]     Ответить | Цитировать Сообщить модератору
 Re: Ombar backup level 1 problem  [new]
Maxim_Z
Guest
Ok. Но почему он не сохраняет эту информацию в резервных страницах ???
Что нужно изменить что бы работало ???

onstat -g arc
Informix Dynamic Server 2000 Version 9.21.FC3 -- On-Line -- Up 73 days 23:20:15 -- 384004 Kbytes
num DBSpace Q Size Q Len Buffer partnum size scanner

Dbspaces - Archive Status
name number level date log log-position
rootdbs 1 0 05/19/2005.03:00 495 0x9a3018
loglog1 2 0 05/19/2005.03:00 495 0x9a3018
loglog2 3 0 05/19/2005.03:00 495 0x9a3018
loglog3 4 0 05/19/2005.03:00 495 0x9a3018
physlog3 5 0 05/19/2005.03:00 495 0x9a3018
sp009 9 0 05/19/2005.03:00 495 0x9a3018
.....
sp050 50 0 05/19/2005.03:00 495 0x9a3018
sp051 51 0 05/19/2005.03:00 495 0x9a3018

bar_act.log
2005-05-19 03:00:23 26811 26810 /usr/local/informix/9.21/bin/onbar_d -b -L 0
2005-05-19 03:00:35 26811 26810 Begin level 0 backup rootdbs.
2005-05-19 03:00:35 26811 26810 Successfully connected to Storage Manager.
2005-05-19 03:00:39 26811 26810 Completed level 0 backup rootdbs (Storage Manager copy ID: 1116486035 1116486036).
2005-05-19 03:00:39 26811 26810 Begin level 0 backup loglog1.
2005-05-19 03:00:40 26811 26810 Completed level 0 backup loglog1 (Storage Manager copy ID: 1116486039 1116486041).
2005-05-19 03:00:40 26811 26810 Begin level 0 backup loglog2.
....
2005-05-19 11:53:49 26811 26810 Completed level 0 backup sp049 (Storage Manager copy ID: 1116517908 1116517954).
2005-05-19 11:53:49 26811 26810 Begin level 0 backup sp050.
2005-05-19 11:54:55 26811 26810 Completed level 0 backup sp050 (Storage Manager copy ID: 1116518029 1116518076).
2005-05-19 11:54:55 26811 26810 Begin level 0 backup sp051.
2005-05-19 12:00:18 26811 26810 Completed level 0 backup sp051 (Storage Manager copy ID: 1116518095 1116518143).
2005-05-19 12:00:25 26811 26810 Begin backup logical log 495.
2005-05-19 12:00:25 26811 26810 Successfully connected to Storage Manager.
2005-05-19 12:00:27 24541 24539 /usr/local/informix/9.21/bin/onbar_d -b -l
2005-05-19 12:00:27 26811 26810 Completed backup logical log 495 (Storage Manager copy ID: 1116518425 1116518426).
2005-05-19 12:00:27 26811 26810 /usr/local/informix/9.21/bin/onbar_d complete, returning 0 (0x00)
2005-05-19 12:00:27 24541 24539 /usr/local/informix/9.21/bin/onbar_d complete, returning 0 (0x00)
19 май 05, 22:09    [1557121]     Ответить | Цитировать Сообщить модератору
 Re: Ombar backup level 1 problem  [new]
vybegallo
Guest
А что в логе Информикса написано по поводу бэкапов ? завершились успешно ?
Похоже, onbar не дает финальной отмашки информиксу что бэкап прошел.
19 май 05, 22:41    [1557163]     Ответить | Цитировать Сообщить модератору
 Re: Ombar backup level 1 problem  [new]
Maxim_Z
Guest
В логфайле все выглядит отлично:

03:00:35 Level 0 Archive started on rootdbs, loglog1, loglog2, loglog3, physlog3, sp009, sp010, sp011, sp012, sp013, sp014,
sp015, sp016, sp017, sp018, sp019, sp020, sp021, sp022, sp023, sp024, sp025, sp026, sp027, sp028, sp029, sp030, sp031, sp03
2, sp033, sp034, sp035, sp036, sp037, sp038, sp039, sp040, sp041, sp042, sp043, sp044, sp045, sp046, sp047, sp048, sp049, sp
050, sp051
03:30:34 Fuzzy Checkpoint Completed: duration was 0 seconds, 2 buffers not flushed.
03:30:34 Checkpoint loguniq 495, logpos 0x9bd244

04:00:52 Fuzzy Checkpoint Completed: duration was 0 seconds, 2 buffers not flushed.
04:00:52 Checkpoint loguniq 495, logpos 0x9d21b4

04:31:10 Fuzzy Checkpoint Completed: duration was 0 seconds, 2 buffers not flushed.
04:31:10 Checkpoint loguniq 495, logpos 0x9ef2a4

05:01:30 Fuzzy Checkpoint Completed: duration was 0 seconds, 2 buffers not flushed.
05:01:30 Checkpoint loguniq 495, logpos 0xa0920c

05:31:49 Fuzzy Checkpoint Completed: duration was 0 seconds, 2 buffers not flushed.
05:31:49 Checkpoint loguniq 495, logpos 0xa1c284
.......
12:00:24 Archive on rootdbs, loglog1, loglog2, loglog3, physlog3, sp009, sp010, sp011, sp012, sp013, sp014, sp015, sp016, sp017, sp018, sp019, sp020, sp021, sp022, sp023, sp024, sp025, sp026, sp027, sp028, sp029, sp030, sp031, sp032, sp033, sp034, sp035, sp036, sp037, sp038, sp039, sp040, sp041, sp042, sp043, sp044, sp045, sp046, sp047, sp048, sp049, sp050, sp051 Completed.
19 май 05, 22:51    [1557170]     Ответить | Цитировать Сообщить модератору
 Re: Ombar backup level 1 problem  [new]
vybegallo
Guest
Что в ixbar файле ? Есть строки относящиеся к бэкапам ?
19 май 05, 23:23    [1557196]     Ответить | Цитировать Сообщить модератору
 Re: Ombar backup level 1 problem  [new]
Maxim_Z
Guest
Я же приводил эту информацию в своем первом посте :-)

orate_shm rootdbs R 0 7278 0 1116486035 1116486036 2005-05-19 03:00:35 1 0 0 7278 0 - -
orate_shm loglog1 CD 0 7279 0 1116486039 1116486041 2005-05-19 03:00:39 1 0 0 7279 0 - -
orate_shm loglog2 CD 0 7280 0 1116486040 1116486043 2005-05-19 03:00:40 1 0 0 7280 0 - -
orate_shm loglog3 CD 0 7281 0 1116486041 1116486045 2005-05-19 03:00:41 1 0 0 7281 0 - -
orate_shm physlog3 CD 0 7282 0 1116486042 1116486047 2005-05-19 03:00:41 1 0 0 7282 0 - -
orate_shm sp009 ND 0 7283 0 1116486044 1116486050 2005-05-19 03:00:44 1 0 0 7283 0 - -
orate_shm sp010 ND 0 7284 0 1116488812 1116488819 2005-05-19 03:46:52 1 0 0 7284 0 - -
orate_shm sp011 ND 0 7285 0 1116492259 1116492267 2005-05-19 04:44:19 1 0 0 7285 0 - -
orate_shm sp012 ND 0 7286 0 1116493829 1116493838 2005-05-19 05:10:29 1 0 0 7286 0 - -
orate_shm sp013 ND 0 7287 0 1116495219 1116495229 2005-05-19 05:33:39 1 0 0 7287 0 - -
orate_shm sp014 ND 0 7288 0 1116496235 1116496246 2005-05-19 05:50:35 1 0 0 7288 0 - -
orate_shm sp015 ND 0 7289 0 1116497225 1116497237 2005-05-19 06:07:05 1 0 0 7289 0 - -
orate_shm sp016 ND 0 7290 0 1116498231 1116498244 2005-05-19 06:23:51 1 0 0 7290 0 - -
orate_shm sp017 ND 0 7291 0 1116498756 1116498770 2005-05-19 06:32:36 1 0 0 7291 0 - -
orate_shm sp018 ND 0 7292 0 1116499308 1116499323 2005-05-19 06:41:48 1 0 0 7292 0 - -
orate_shm sp019 ND 0 7293 0 1116500199 1116500215 2005-05-19 06:56:39 1 0 0 7293 0 - -
orate_shm sp020 ND 0 7294 0 1116500836 1116500853 2005-05-19 07:07:16 1 0 0 7294 0 - -
orate_shm sp021 ND 0 7295 0 1116501257 1116501275 2005-05-19 07:14:17 1 0 0 7295 0 - -
orate_shm sp022 ND 0 7296 0 1116501957 1116501976 2005-05-19 07:25:57 1 0 0 7296 0 - -
orate_shm sp023 ND 0 7297 0 1116503366 1116503386 2005-05-19 07:49:26 1 0 0 7297 0 - -
orate_shm sp024 ND 0 7298 0 1116503682 1116503703 2005-05-19 07:54:42 1 0 0 7298 0 - -
orate_shm sp025 ND 0 7299 0 1116504134 1116504156 2005-05-19 08:02:14 1 0 0 7299 0 - -
orate_shm sp026 ND 0 7300 0 1116504471 1116504494 2005-05-19 08:07:51 1 0 0 7300 0 - -
orate_shm sp027 ND 0 7301 0 1116505139 1116505163 2005-05-19 08:18:59 1 0 0 7301 0 - -
orate_shm sp028 ND 0 7302 0 1116505537 1116505562 2005-05-19 08:25:37 1 0 0 7302 0 - -
orate_shm sp029 ND 0 7303 0 1116506959 1116506985 2005-05-19 08:49:19 1 0 0 7303 0 - -
orate_shm sp030 ND 0 7304 0 1116507298 1116507325 2005-05-19 08:54:58 1 0 0 7304 0 - -
orate_shm sp031 ND 0 7305 0 1116507735 1116507763 2005-05-19 09:02:15 1 0 0 7305 0 - -
orate_shm sp032 ND 0 7306 0 1116508017 1116508046 2005-05-19 09:06:57 1 0 0 7306 0 - -
orate_shm sp033 ND 0 7307 0 1116508326 1116508356 2005-05-19 09:12:06 1 0 0 7307 0 - -
orate_shm sp034 ND 0 7308 0 1116508664 1116508695 2005-05-19 09:17:44 1 0 0 7308 0 - -
orate_shm sp035 ND 0 7309 0 1116509044 1116509076 2005-05-19 09:24:04 1 0 0 7309 0 - -
orate_shm sp036 ND 0 7310 0 1116510072 1116510105 2005-05-19 09:41:12 1 0 0 7310 0 - -
orate_shm sp037 ND 0 7311 0 1116510546 1116510580 2005-05-19 09:49:06 1 0 0 7311 0 - -
orate_shm sp038 ND 0 7312 0 1116511242 1116511277 2005-05-19 10:00:42 1 0 0 7312 0 - -
orate_shm sp039 ND 0 7313 0 1116513524 1116513560 2005-05-19 10:38:44 1 0 0 7313 0 - -
orate_shm sp040 ND 0 7314 0 1116513706 1116513743 2005-05-19 10:41:46 1 0 0 7314 0 - -
orate_shm sp041 ND 0 7315 0 1116514048 1116514086 2005-05-19 10:47:28 1 0 0 7315 0 - -
orate_shm sp042 ND 0 7316 0 1116516048 1116516087 2005-05-19 11:20:48 1 0 0 7316 0 - -
orate_shm sp043 ND 0 7317 0 1116516401 1116516441 2005-05-19 11:26:41 1 0 0 7317 0 - -
orate_shm sp044 ND 0 7318 0 1116516720 1116516761 2005-05-19 11:32:00 1 0 0 7318 0 - -
orate_shm sp045 ND 0 7319 0 1116517043 1116517085 2005-05-19 11:37:23 1 0 0 7319 0 - -
orate_shm sp046 ND 0 7320 0 1116517374 1116517417 2005-05-19 11:42:54 1 0 0 7320 0 - -
orate_shm sp047 ND 0 7321 0 1116517699 1116517743 2005-05-19 11:48:19 1 0 0 7321 0 - -
orate_shm sp048 ND 0 7322 0 1116517804 1116517849 2005-05-19 11:50:04 1 0 0 7322 0 - -
orate_shm sp049 ND 0 7323 0 1116517908 1116517954 2005-05-19 11:51:48 1 0 0 7323 0 - -
orate_shm sp050 ND 0 7324 0 1116518029 1116518076 2005-05-19 11:53:49 1 0 0 7324 0 - -
orate_shm sp051 ND 0 7325 0 1116518095 1116518143 2005-05-19 11:54:55 1 0 0 7325 0 - -
orate_shm 495 L 0 7326 0 1116518425 1116518426 2005-05-19 12:00:25 1 0 0 7326 0 - -
19 май 05, 23:30    [1557208]     Ответить | Цитировать Сообщить модератору
 Re: Ombar backup level 1 problem  [new]
Maxim_Z
Guest
>>Backup L1 для второй database instance до недавнего времени работал корректно, однако после добавления нового chunk и backup level 0 стал работать так же как описано выше.

Хм. Сегодня вдруг backup L1 для второй database instance вдруг прошел корректно.
Никаких работ с базой не производилось. Мистика какая то.

Backup L1 для третей database instance после перехода на 9.40FC5 стал работать корректно. Похоже что sysutils database а с ней и onbar tables пересоздавались в ходе миграции и теперь содержат корректную информацию.
25 май 05, 17:50    [1570852]     Ответить | Цитировать Сообщить модератору
Все форумы / Informix Ответить