|
|
|
load database в ASE 15.0.2 ESD #5 под Win2003Server из дампа ASE 12.5.3 под SunSolaris
|
|||
|---|---|---|---|
|
#18+
Привет, пара вопросов: 1) Нормально ли поднимет дамп ASE 15.0.2 Developer Edition ESD #5 под Win2003Server 32bit сделанный ASE 12.5.3 ESD #4 под Sun Solaris 5.8 64bit, дамп размером 600Гб? О поддержке мультиплатформенных дампов начиная с версии ASE 12.5.3 я знаю. 2) Пустая БД с опцией for load размером в 600Гб создается 1.5 суток, как можно ускорить этот процесс? 3) В ASE 15.0.2 Developer Edition ESD #5 не могу установить в разделе [processors] корректное кол-во процессоров на сервере. Стоит ограничение 1. Физически на сервере 2шт. Xeon 5050 по 2 ядра. Я не видел такого ограничения на Developer Edition в документации. В чем может быть дело? 4) Если у ASE присутствует хоть одна база с опцией for load, он на отрез отказывается изменять charset. Например надо cp1251 вместо iso_1. Как можно обойти эти грабли, не удаляя записи из master? Спасибо. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.08.2008, 20:58 |
|
||
|
load database в ASE 15.0.2 ESD #5 под Win2003Server из дампа ASE 12.5.3 под SunSolaris
|
|||
|---|---|---|---|
|
#18+
автор3) В ASE 15.0.2 Developer Edition ESD #5 не могу установить в разделе [processors] корректное кол-во процессоров на сервере. Стоит ограничение 1. Физически на сервере 2шт. Xeon 5050 по 2 ядра. Я не видел такого ограничения на Developer Edition в документации. В чем может быть дело? ASE лицензируется на ядра, а не на процессора! ASE DE будет работать только на одном ядре, а не на процессоре! ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.08.2008, 21:18 |
|
||
|
load database в ASE 15.0.2 ESD #5 под Win2003Server из дампа ASE 12.5.3 под SunSolaris
|
|||
|---|---|---|---|
|
#18+
Vladimir_ShatiloПривет, пара вопросов: 1) Нормально ли поднимет дамп ASE 15.0.2 Developer Edition ESD #5 под Win2003Server 32bit сделанный ASE 12.5.3 ESD #4 под Sun Solaris 5.8 64bit, дамп размером 600Гб? О поддержке мультиплатформенных дампов начиная с версии ASE 12.5.3 я знаю. почему бы нет? следуйте инструкции по переносу кросс-платформенного дампа попробуйте перенести сначала маленькую тестовую бд, мегов на 20-30 проверьте использование компрессии - в вашем случае может ускорить процесс Vladimir_Shatilo 2) Пустая БД с опцией for load размером в 600Гб создается 1.5 суток, как можно ускорить этот процесс? ускорить дисковую подсистему либо поиграть с кэшем, пулами кстати, у меня большое подозрение, что база с for load есть набор записей в sysdatabases & sysusages поэтому можно попробовать занести необходимые строки в эти таблицы и получить базу for load Vladimir_Shatilo 3) В ASE 15.0.2 Developer Edition ESD #5 не могу установить в разделе [processors] корректное кол-во процессоров на сервере. Стоит ограничение 1. Физически на сервере 2шт. Xeon 5050 по 2 ядра. Я не видел такого ограничения на Developer Edition в документации. В чем может быть дело? вы конфиг-фал правите что ли ? Vladimir_Shatilo 4) Если у ASE присутствует хоть одна база с опцией for load, он на отрез отказывается изменять charset. Например надо cp1251 вместо iso_1. Как можно обойти эти грабли, не удаляя записи из master? вам надо её спрятать как - выбирать вам я бы стер записи из sysusages & sysdatabases это проще, чем ждать полтора суток ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.08.2008, 23:21 |
|
||
|
load database в ASE 15.0.2 ESD #5 под Win2003Server из дампа ASE 12.5.3 под SunSolaris
|
|||
|---|---|---|---|
|
#18+
Такой крос не пройдет. на маздай можно накатывать "чужые" дампы только от линукса. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 03.08.2008, 19:07 |
|
||
|
load database в ASE 15.0.2 ESD #5 под Win2003Server из дампа ASE 12.5.3 под SunSolaris
|
|||
|---|---|---|---|
|
#18+
Vitaliy MarinТакой крос не пройдет. на маздай можно накатывать "чужые" дампы только от линукса. почему не пройдет? тынц : мануалAdaptive Server allows dump and load databases across platforms with different endian architecture. This means you can perform dump database and load database from either a big endian platform to a little endian platform, or from a little endian platform to a big endian platform. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 04.08.2008, 11:21 |
|
||
|
load database в ASE 15.0.2 ESD #5 под Win2003Server из дампа ASE 12.5.3 под SunSolaris
|
|||
|---|---|---|---|
|
#18+
Vitaliy MarinТакой крос не пройдет. на маздай можно накатывать "чужые" дампы только от линукса. пройдет... делали в обе стороны неоднократно... но с большой вероятностью индексы будут битыми... вон честно пишут : After Adaptive Server converts the index rows, the order of index rows may be incorrect. Adaptive Server marks following indexes on user tables as suspect indexes during online database. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.08.2008, 11:52 |
|
||
|
load database в ASE 15.0.2 ESD #5 под Win2003Server из дампа ASE 12.5.3 под SunSolaris
|
|||
|---|---|---|---|
|
#18+
Через sysusages & sysdatabases база прячется, настраивается кодировка сервера как надо, потом записи надо вернуть в эти таблицы обратно. Дамп подниматься стал, заливался 2 дня, и лег с ошибкой. I/O error detected on disk buffer 0x22F0C820 for page request 105912320, dbid 5. Кто может подсказать, как лучше поступить? Собираюсь через sysdatabases снять флаг for load и при помощи dbcc попробывать восстанавливать. ---------------------------------------------------------- -- testdb Restore Messages ---------------------------------------------------------- Backup Server session id is: 6. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server. Backup Server: 6.28.1.1: Dumpfile name 'testdb082050991D ' section number 1 mounted on disk file 'E:\soyuz.dmp' Backup Server: 4.188.1.1: Database testdb: 6425096 kilobytes (1%) LOADED. Backup Server: 4.188.1.1: Database testdb: 12848398 kilobytes (2%) LOADED. Backup Server: 4.188.1.1: Database testdb: 19272724 kilobytes (3%) LOADED. Backup Server: 4.188.1.1: Database testdb: 25685464 kilobytes (4%) LOADED. Backup Server: 4.188.1.1: Database testdb: 32110558 kilobytes (5%) LOADED. Backup Server: 4.188.1.1: Database testdb: 38534884 kilobytes (6%) LOADED. Backup Server: 4.188.1.1: Database testdb: 44947624 kilobytes (7%) LOADED. Backup Server: 4.188.1.1: Database testdb: 51371950 kilobytes (8%) LOADED. Backup Server: 4.188.1.1: Database testdb: 57797044 kilobytes (9%) LOADED. Backup Server: 4.188.1.1: Database testdb: 64209784 kilobytes (10%) LOADED. Backup Server: 4.188.1.1: Database testdb: 70634110 kilobytes (11%) LOADED. Backup Server: 4.188.1.1: Database testdb: 77058436 kilobytes (12%) LOADED. Backup Server: 4.188.1.1: Database testdb: 83483530 kilobytes (13%) LOADED. Backup Server: 4.188.1.1: Database testdb: 89896270 kilobytes (14%) LOADED. Backup Server: 4.188.1.1: Database testdb: 96320596 kilobytes (15%) LOADED. Backup Server: 4.188.1.1: Database testdb: 102744922 kilobytes (16%) LOADED. Backup Server: 4.188.1.1: Database testdb: 109157662 kilobytes (17%) LOADED. Backup Server: 4.188.1.1: Database testdb: 115582756 kilobytes (18%) LOADED. Backup Server: 4.188.1.1: Database testdb: 122006954 kilobytes (19%) LOADED. Backup Server: 4.188.1.1: Database testdb: 128419694 kilobytes (20%) LOADED. Backup Server: 4.188.1.1: Database testdb: 134844020 kilobytes (21%) LOADED. Backup Server: 4.188.1.1: Database testdb: 141269114 kilobytes (22%) LOADED. Backup Server: 4.188.1.1: Database testdb: 147681854 kilobytes (23%) LOADED. Backup Server: 4.188.1.1: Database testdb: 154106180 kilobytes (24%) LOADED. Backup Server: 4.188.1.1: Database testdb: 160530506 kilobytes (25%) LOADED. Backup Server: 4.188.1.1: Database testdb: 166944014 kilobytes (26%) LOADED. Backup Server: 4.188.1.1: Database testdb: 173368340 kilobytes (27%) LOADED. Backup Server: 4.188.1.1: Database testdb: 179792666 kilobytes (28%) LOADED. Backup Server: 4.188.1.1: Database testdb: 186216992 kilobytes (29%) LOADED. Backup Server: 4.188.1.1: Database testdb: 192630500 kilobytes (30%) LOADED. Backup Server: 4.188.1.1: Database testdb: 199050440 kilobytes (31%) LOADED. Backup Server: 4.188.1.1: Database testdb: 205470714 kilobytes (32%) LOADED. Backup Server: 4.188.1.1: Database testdb: 211893804 kilobytes (33%) LOADED. Backup Server: 4.188.1.1: Database testdb: 218316894 kilobytes (34%) LOADED. Backup Server: 4.188.1.1: Database testdb: 224739984 kilobytes (35%) LOADED. Backup Server: 4.188.1.1: Database testdb: 231151872 kilobytes (36%) LOADED. Backup Server: 4.188.1.1: Database testdb: 237574578 kilobytes (37%) LOADED. Backup Server: 4.188.1.1: Database testdb: 243997668 kilobytes (38%) LOADED. Backup Server: 4.188.1.1: Database testdb: 250420758 kilobytes (39%) LOADED. Backup Server: 4.188.1.1: Database testdb: 256843848 kilobytes (40%) LOADED. Backup Server: 4.188.1.1: Database testdb: 263266938 kilobytes (41%) LOADED. Backup Server: 4.188.1.1: Database testdb: 269678442 kilobytes (42%) LOADED. Backup Server: 4.188.1.1: Database testdb: 276101532 kilobytes (43%) LOADED. Backup Server: 4.188.1.1: Database testdb: 282524622 kilobytes (44%) LOADED. Backup Server: 4.188.1.1: Database testdb: 288947712 kilobytes (45%) LOADED. Backup Server: 4.188.1.1: Database testdb: 295370418 kilobytes (46%) LOADED. Backup Server: 4.188.1.1: Database testdb: 301782306 kilobytes (47%) LOADED. Backup Server: 4.188.1.1: Database testdb: 308205396 kilobytes (48%) LOADED. Backup Server: 4.188.1.1: Database testdb: 314628486 kilobytes (49%) LOADED. Backup Server: 4.188.1.1: Database testdb: 321051576 kilobytes (50%) LOADED. Backup Server: 4.188.1.1: Database testdb: 327474282 kilobytes (51%) LOADED. Backup Server: 4.188.1.1: Database testdb: 333886170 kilobytes (52%) LOADED. Backup Server: 4.188.1.1: Database testdb: 340316560 kilobytes (53%) LOADED. Backup Server: 4.188.1.1: Database testdb: 346728064 kilobytes (54%) LOADED. Backup Server: 4.188.1.1: Database testdb: 353151154 kilobytes (55%) LOADED. Backup Server: 4.188.1.1: Database testdb: 359571940 kilobytes (56%) LOADED. Backup Server: 4.188.1.1: Database testdb: 365994646 kilobytes (57%) LOADED. Backup Server: 4.188.1.1: Database testdb: 372417736 kilobytes (58%) LOADED. Backup Server: 4.188.1.1: Database testdb: 378840826 kilobytes (59%) LOADED. Backup Server: 4.188.1.1: Database testdb: 385258094 kilobytes (60%) LOADED. Backup Server: 4.188.1.1: Database testdb: 391676320 kilobytes (61%) LOADED. Backup Server: 4.188.1.1: Database testdb: 398097814 kilobytes (62%) LOADED. Backup Server: 4.188.1.1: Database testdb: 404520904 kilobytes (63%) LOADED. Backup Server: 4.188.1.1: Database testdb: 410943994 kilobytes (64%) LOADED. Backup Server: 4.188.1.1: Database testdb: 417362028 kilobytes (65%) LOADED. Backup Server: 4.188.1.1: Database testdb: 423785118 kilobytes (66%) LOADED. Backup Server: 4.188.1.1: Database testdb: 430208208 kilobytes (67%) LOADED. Backup Server: 4.188.1.1: Database testdb: 436622402 kilobytes (68%) LOADED. Backup Server: 4.188.1.1: Database testdb: 443042362 kilobytes (69%) LOADED. Backup Server: 4.188.1.1: Database testdb: 449465452 kilobytes (70%) LOADED. Backup Server: 4.188.1.1: Database testdb: 455889758 kilobytes (71%) LOADED. Backup Server: 4.188.1.1: Database testdb: 462309392 kilobytes (72%) LOADED. Backup Server: 4.188.1.1: Database testdb: 468734146 kilobytes (73%) LOADED. Backup Server: 4.188.1.1: Database testdb: 475146034 kilobytes (74%) LOADED. Backup Server: 4.188.1.1: Database testdb: 481569124 kilobytes (75%) LOADED. Backup Server: 4.188.1.1: Database testdb: 487992214 kilobytes (76%) LOADED. Backup Server: 4.188.1.1: Database testdb: 494414920 kilobytes (77%) LOADED. Backup Server: 4.188.1.1: Database testdb: 500838054 kilobytes (78%) LOADED. Backup Server: 4.188.1.1: Database testdb: 507260430 kilobytes (79%) LOADED. Backup Server: 4.188.1.1: Database testdb: 513680866 kilobytes (80%) LOADED. Backup Server: 4.188.1.1: Database testdb: 520101154 kilobytes (81%) LOADED. Backup Server: 4.188.1.1: Database testdb: 526521442 kilobytes (82%) LOADED. Backup Server: 4.188.1.1: Database testdb: 532939996 kilobytes (83%) LOADED. Backup Server: 4.188.1.1: Database testdb: 539359318 kilobytes (84%) LOADED. Backup Server: 4.188.1.1: Database testdb: 545777872 kilobytes (85%) LOADED. Backup Server: 4.188.1.1: Database testdb: 552196426 kilobytes (86%) LOADED. Backup Server: 4.188.1.1: Database testdb: 558627334 kilobytes (87%) LOADED. Backup Server: 4.188.1.1: Database testdb: 565045888 kilobytes (88%) LOADED. Backup Server: 4.188.1.1: Database testdb: 571465210 kilobytes (89%) LOADED. Backup Server: 4.188.1.1: Database testdb: 577883764 kilobytes (90%) LOADED. Backup Server: 4.188.1.1: Database testdb: 584302318 kilobytes (91%) LOADED. Backup Server: 4.188.1.1: Database testdb: 590721640 kilobytes (92%) LOADED. Backup Server: 4.188.1.1: Database testdb: 597147106 kilobytes (93%) LOADED. Backup Server: 4.188.1.1: Database testdb: 603568534 kilobytes (94%) LOADED. Backup Server: 4.188.1.1: Database testdb: 608640176 kilobytes (100%) LOADED. Backup Server: 3.42.1.1: LOAD is complete (database testdb). Started cross-platform conversion for database testdb. Started cross-platform conversion for system objects. Cross-platform conversion for database testdb: 10000 pages completed. Cross-platform conversion for database testdb: 20000 pages completed. Cross-platform conversion for database testdb: 30000 pages completed. Cross-platform conversion for database testdb: 40000 pages completed. Cross-platform conversion for database testdb: 50000 pages completed. Cross-platform conversion for database testdb: 60000 pages completed. Cross-platform conversion for database testdb: 70000 pages completed. Cross-platform conversion for database testdb: 80000 pages completed. Cross-platform conversion for database testdb: 90000 pages completed. Cross-platform conversion for database testdb: 100000 pages completed. Cross-platform conversion for database testdb: 110000 pages completed. Cross-platform conversion for database testdb: 120000 pages completed. Cross-platform conversion for database testdb: 130000 pages completed. Cross-platform conversion for database testdb: 140000 pages completed. Cross-platform conversion for database testdb: 150000 pages completed. Cross-platform conversion for database testdb: 160000 pages completed. Cross-platform conversion for database testdb: 170000 pages completed. Cross-platform conversion for database testdb: 180000 pages completed. Cross-platform conversion for database testdb: 190000 pages completed. Cross-platform conversion for database testdb: 200000 pages completed. Cross-platform conversion for database testdb: 210000 pages completed. Cross-platform conversion for database testdb: 220000 pages completed. Cross-platform conversion for database testdb: 230000 pages completed. Cross-platform conversion for database testdb: 240000 pages completed. Cross-platform conversion for database testdb: 250000 pages completed. Cross-platform conversion for database testdb: 260000 pages completed. Cross-platform conversion for database testdb: 270000 pages completed. Cross-platform conversion for database testdb: 280000 pages completed. Cross-platform conversion for database testdb: 290000 pages completed. Cross-platform conversion for database testdb: 300000 pages completed. Cross-platform conversion for database testdb: 310000 pages completed. Cross-platform conversion for database testdb: 320000 pages completed. Cross-platform conversion for database testdb: 330000 pages completed. Cross-platform conversion for database testdb: 340000 pages completed. Cross-platform conversion for database testdb: 350000 pages completed. Cross-platform conversion for database testdb: 360000 pages completed. Cross-platform conversion for database testdb: 370000 pages completed. Cross-platform conversion for database testdb: 380000 pages completed. Cross-platform conversion for database testdb: 390000 pages completed. Cross-platform conversion for database testdb: 400000 pages completed. Cross-platform conversion for database testdb: 410000 pages completed. Cross-platform conversion for database testdb: 420000 pages completed. Cross-platform conversion for database testdb: 430000 pages completed. Cross-platform conversion for database testdb: 440000 pages completed. Cross-platform conversion for database testdb: 450000 pages completed. Cross-platform conversion for database testdb: 460000 pages completed. Cross-platform conversion for database testdb: 470000 pages completed. Cross-platform conversion for database testdb: 480000 pages completed. Cross-platform conversion for database testdb: 490000 pages completed. Cross-platform conversion for database testdb: 500000 pages completed. Cross-platform conversion for database testdb: 510000 pages completed. Cross-platform conversion for database testdb: 520000 pages completed. Cross-platform conversion for database testdb: 530000 pages completed. Cross-platform conversion for database testdb: 540000 pages completed. Cross-platform conversion for database testdb: 550000 pages completed. Cross-platform conversion for database testdb: 560000 pages completed. Cross-platform conversion for database testdb: 570000 pages completed. Cross-platform conversion for database testdb: 580000 pages completed. Cross-platform conversion for database testdb: 590000 pages completed. Cross-platform conversion for database testdb: 600000 pages completed. Cross-platform conversion for database testdb: 610000 pages completed. Cross-platform conversion for database testdb: 620000 pages completed. Cross-platform conversion for database testdb: 630000 pages completed. Cross-platform conversion for database testdb: 640000 pages completed. Cross-platform conversion for database testdb: 650000 pages completed. Cross-platform conversion for database testdb: 660000 pages completed. Cross-platform conversion for database testdb: 670000 pages completed. Cross-platform conversion for database testdb: 680000 pages completed. Cross-platform conversion for database testdb: 690000 pages completed. Cross-platform conversion for database testdb: 700000 pages completed. Cross-platform conversion for database testdb: 710000 pages completed. Cross-platform conversion for database testdb: 720000 pages completed. Cross-platform conversion for database testdb: 730000 pages completed. Cross-platform conversion for database testdb: 740000 pages completed. Cross-platform conversion for database testdb: 750000 pages completed. Cross-platform conversion for database testdb: 760000 pages completed. Cross-platform conversion for database testdb: 770000 pages completed. Cross-platform conversion for database testdb: 780000 pages completed. Cross-platform conversion for database testdb: 790000 pages completed. Cross-platform conversion for database testdb: 800000 pages completed. Cross-platform conversion for database testdb: 810000 pages completed. Cross-platform conversion for database testdb: 820000 pages completed. Cross-platform conversion for database testdb: 830000 pages completed. Cross-platform conversion for database testdb: 840000 pages completed. Cross-platform conversion for database testdb: 850000 pages completed. Cross-platform conversion for database testdb: 860000 pages completed. Cross-platform conversion for database testdb: 870000 pages completed. Cross-platform conversion for database testdb: 880000 pages completed. Cross-platform conversion for database testdb: 890000 pages completed. Cross-platform conversion for database testdb: 900000 pages completed. Cross-platform conversion for database testdb: 910000 pages completed. Cross-platform conversion for database testdb: 920000 pages completed. Cross-platform conversion for database testdb: 930000 pages completed. Cross-platform conversion for database testdb: 940000 pages completed. Cross-platform conversion for database testdb: 950000 pages completed. Cross-platform conversion for database testdb: 960000 pages completed. Cross-platform conversion for database testdb: 970000 pages completed. Cross-platform conversion for database testdb: 980000 pages completed. Cross-platform conversion for database testdb: 990000 pages completed. Cross-platform conversion for database testdb: 1000000 pages completed. Cross-platform conversion for database testdb: 1010000 pages completed. Cross-platform conversion for database testdb: 1020000 pages completed. Cross-platform conversion for database testdb: 1030000 pages completed. Cross-platform conversion for database testdb: 1040000 pages completed. Cross-platform conversion for database testdb: 1050000 pages completed. Cross-platform conversion for database testdb: 1060000 pages completed. Cross-platform conversion for database testdb: 1070000 pages completed. Cross-platform conversion for database testdb: 1080000 pages completed. Cross-platform conversion for database testdb: 1090000 pages completed. Cross-platform conversion for database testdb: 1100000 pages completed. Cross-platform conversion for database testdb: 1110000 pages completed. Cross-platform conversion for database testdb: 1120000 pages completed. Cross-platform conversion for database testdb: 1130000 pages completed. Cross-platform conversion for database testdb: 1140000 pages completed. Cross-platform conversion for database testdb: 1150000 pages completed. Cross-platform conversion for database testdb: 1160000 pages completed. Cross-platform conversion for database testdb: 1170000 pages completed. Cross-platform conversion for database testdb: 1180000 pages completed. Cross-platform conversion for database testdb: 1190000 pages completed. Cross-platform conversion for database testdb: 1198751 pages completed. Completed cross-platform conversion for system objects. Started cross-platform conversion for user objects. Cross-platform conversion for database testdb: 3042876 pages completed. Cross-platform conversion for database testdb: 6085616 pages completed. Cross-platform conversion for database testdb: 9128493 pages completed. Cross-platform conversion for database testdb: 12171362 pages completed. Cross-platform conversion for database testdb: 15214184 pages completed. Cross-platform conversion for database testdb: 18257091 pages completed. Cross-platform conversion for database testdb: 21300006 pages completed. Cross-platform conversion for database testdb: 24342891 pages completed. Cross-platform conversion for database testdb: 27385720 pages completed. Cross-platform conversion for database testdb: 30428503 pages completed. Cross-platform conversion for database testdb: 33471334 pages completed. Cross-platform conversion for database testdb: 36514211 pages completed. Cross-platform conversion for database testdb: 39557128 pages completed. Cross-platform conversion for database testdb: 42599801 pages completed. Cross-platform conversion for database testdb: 45642564 pages completed. Cross-platform conversion for database testdb: 48685395 pages completed. Cross-platform conversion for database testdb: 51728267 pages completed. Cross-platform conversion for database testdb: 54771186 pages completed. Cross-platform conversion for database testdb: 57814065 pages completed. Cross-platform conversion for database testdb: 60856862 pages completed. Cross-platform conversion for database testdb: 63899682 pages completed. Cross-platform conversion for database testdb: 66942597 pages completed. Cross-platform conversion for database testdb: 69985512 pages completed. Cross-platform conversion for database testdb: 73028427 pages completed. Cross-platform conversion for database testdb: 76071327 pages completed. Cross-platform conversion for database testdb: 79114234 pages completed. Cross-platform conversion for database testdb: 82156955 pages completed. Cross-platform conversion for database testdb: 85199791 pages completed. Cross-platform conversion for database testdb: 88242706 pages completed. Cross-platform conversion for database testdb: 91285621 pages completed. Cross-platform conversion for database testdb: 94328536 pages completed. Cross-platform conversion for database testdb: 97371451 pages completed. Cross-platform conversion for database testdb: 100414366 pages completed. Cross-platform conversion for database testdb: 103457281 pages completed. I/O error detected on disk buffer 0x22F0C820 for page request 105912320, dbid 5. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 06.08.2008, 12:25 |
|
||
|
load database в ASE 15.0.2 ESD #5 под Win2003Server из дампа ASE 12.5.3 под SunSolaris
|
|||
|---|---|---|---|
|
#18+
Vladimir_ShatiloBackup Server: 3.42.1.1: LOAD is complete (database testdb). Started cross-platform conversion for database testdb. Started cross-platform conversion for system objects. Completed cross-platform conversion for system objects. Started cross-platform conversion for user objects. I/O error detected on disk buffer 0x22F0C820 for page request 105912320, dbid 5. а что это за страница - не смотрели ? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 06.08.2008, 13:28 |
|
||
|
load database в ASE 15.0.2 ESD #5 под Win2003Server из дампа ASE 12.5.3 под SunSolaris
|
|||
|---|---|---|---|
|
#18+
Не получилось. Сервак попытался сам поднять базу. В результате перевел ее в offline. А как можно посмотреть что у offline базы находится на определенной странице? Я так понимаю, это бесполезно, и надо по новой запускать load database. У меня размер 2 устройств больше, чем в дампе, но врядли это могло быть причиной. Восстановить он так не может, потому что часть объектов сконвертировал для Win, а часть так и оставил. Recovering database 'testdb'. Started estimating recovery log boundaries for database 'testdb'. Database 'testdb', checkpoint=(92197160, 16), first=(92197160, 16), last=(92197160, 17). Completed estimating recovery log boundaries for database 'testdb'. Started ANALYSIS pass for database 'testdb'. Completed ANALYSIS pass for database 'testdb'. Log contains all committed transactions until '-'(/10/22 22:18:45.12 for database testdb. Started REDO pass for database 'testdb'. The total number of log records to process is 2. Completed REDO pass for database 'testdb'. Recovery of database 'testdb' will undo incomplete nested top actions. Started recovery checkpoint for database 'testdb'. Completed recovery checkpoint for database 'testdb'. Started filling free space info for database 'testdb'. Completed filling free space info for database 'testdb'. Started cleaning up the default data cache for database 'testdb'. Completed cleaning up the default data cache for database 'testdb'. Checking external objects. Database 'testdb' appears to be at an older revision than the present installation; ASE will assess it, and upgrade it as required. Database 'testdb': beginning upgrade step [ID 247]: verifying sysstatistics row format Database 'testdb': beginning upgrade step [ID 2]: validate basic system type data Database 'testdb': beginning upgrade step [ID 3]: alter table (table sysindexes) Database 'testdb': beginning upgrade step [ID 4]: creating table (table sysanchors) Database 'testdb': beginning upgrade step [ID 5]: changing name of system table (table syspartitions, new name: sysslices) Database 'testdb': beginning upgrade step [ID 6]: creating table (table syspartitions) Database 'testdb': beginning upgrade step [ID 7]: insert rows into syspartitions for each system table and index Error: 15601, Severity: 20, State: 1 Failed to cache systabstats contents for database 'testdb' (5), object 'tObjectSeed' (405654). Error: 3422, Severity: 20, State: 1 Database 'testdb' (dbid 5): failed to open table ID 405654, for which a row exists in Invalid pointer param number 6, pointer value 0x0000000A closetable: table already closed for sdes 20FA7760 Symbolic stack trace information is successfully loaded pc: 0x014E4178 os_get_cur_stk_desc+ 0x170 (0x02E0E58C, 0x77E61A60, 0x77E64598, 0xFFFFFFFF) pc: 0x014E4178 os_get_cur_stk_desc+ 0x170 (0x02E0E58C, 0x02E0D8C4, 0x0000270F, 0x00000002) pc: 0x014B4BE7 pcstkwalk+ 0x31e (0x00030003, 0x00000002, 0x0000270F, 0x00000000) pc: 0x014B46B3 ucstkgentrace+ 0x263 (0x00030003, 0x00000001, 0x200B7B00, 0x00000000) pc: 0x0143C3CB ucbacktrace+ 0xab (0x20FA7760, 0x20FA7760, 0x02E0F7C4, 0x007B3B77) pc: 0x006AD285 closetable+ 0x2f3 (0x02E0F438, 0x02E0FAC8, 0x2002F1E0, 0x00000000) pc: 0x006ADB26 closetable_byref+ 0x24 (0x02E0F8BC, 0x00000001, 0x00000006, 0x20FA714C) pc: 0x007B3B77 upgd__do_fill_ptns+ 0xe96 (0x02E0F8BC, 0x00000001, 0x20FA714C, 0x00000001) pc: 0x007B0F02 upgd__upgrade_item+ 0x210 (0x02E0F8BC, 0x01AFEA38, 0x00000001, 0x00000048) pc: 0x007ACBA5 upgd__depends+ 0x1b9 (0x02E0F8BC, 0x00000001, 0x20FA714C, 0x00000001) pc: 0x007B0D9F upgd__upgrade_item+ 0xad (0x02E0F8BC, 0x01AFEB48, 0x02E0F894, 0x0000009E) pc: 0x007ACBA5 upgd__depends+ 0x1b9 (0x02E0F8BC, 0x02E0FE94, 0x207394F4, 0x20FA714C) pc: 0x007B0FFF upgd__upgrade_item+ 0x30d (0x20E8C280, 0x02E0FAA8, 0x00527F29, 0x00000001) [Handler pc: 0x0048A13D hdl_backout_msg installed by the following function:-] pc: 0x007A7F49 upgd_upgrade_db+ 0x209 (0x20E8C280, 0x00000000, 0x00000000, 0x22D1D27B) [Handler pc: 0x0048A13D hdl_backout_msg installed by the following function:-] pc: 0x007E82A0 onl_online_db+ 0x8b8 (0x21A57800, 0x0051DB3B, 0x00000001, 0x00000000) pc: 0x007950DC boot__recover_and_online+ 0x822 (0x21A57800, 0x02E0FC68, 0x00000002, 0x0051DB3B) [Handler pc: 0x007A366A rec__caller_hdlr installed by the following function:-] pc: 0x007975ED rec__boot_recover_dbs+ 0x540 (0x21A57800, 0x02E0FC68, 0x00000001, 0x00000000) pc: 0x00793080 rec_run_parallel_recovery+ 0xc10 (0x00000001, 0x20E76700, 0x00000000, 0x00000000) [Handler pc: 0x007A366A rec__caller_hdlr installed by the following function:-] pc: 0x00796BF7 dorecover+ 0x191 (0x20FA714C, 0x00000000, 0x00000000, 0x00000000) pc: 0x0040D481 ds__recoverdbs+ 0xa57 (0x00000000, 0x00000000, 0x00000000, 0x214CC4C8) pc: 0x00406678 dsinit+ 0x1648 (0x214CC4C8, 0x00000000, 0x00000000, 0x214CC4C8) pc: 0x014302D7 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000) pc: 0x77E64829 GetModuleHandleA+ 0xdf (0x00000000, 0x00000000, 0x00000000, 0x00000000) end of stack trace, spid 1, kpid 196611, suid 0 Error: 3461, Severity: 20, State: 1 Database 'testdb': upgrade could not install required upgrade item '7'. Please refer to previous error messages to determine the problem. Fix the problem, then try again. Error: 3451, Severity: 20, State: 1 Database 'testdb': upgrade has failed for this database. Please refer to previous messages for the cause of the failure, correct the problem and try again. Error: 3454, Severity: 20, State: 1 Database 'testdb': ASE could not completely upgrade this database; upgrade item 1417 could not be installed. Error: 14108, Severity: 20, State: 4 Could not find partition descriptor for objid 8, indid -1, ptnid 8 in dbid 5. ASE could not bring database 'testdb' online. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 06.08.2008, 14:45 |
|
||
|
load database в ASE 15.0.2 ESD #5 под Win2003Server из дампа ASE 12.5.3 под SunSolaris
|
|||
|---|---|---|---|
|
#18+
Vladimir_ShatiloНе получилось. Сервак попытался сам поднять базу. В результате перевел ее в offline. А как можно посмотреть что у offline базы находится на определенной странице? Я так понимаю, это бесполезно, и надо по новой запускать load database. У меня размер 2 устройств больше, чем в дампе, но врядли это могло быть причиной. Восстановить он так не может, потому что часть объектов сконвертировал для Win, а часть так и оставил. можно посмотреть что у живой базы на этой странице командой dbcc page кстати, а у вас в живой базе случаем нет проблем (таблица tObjectSeed)? выдержка из логаDatabase 'testdb': beginning upgrade step [ID 7]: insert rows into syspartitions for each system table and index Error: 15601, Severity: 20, State: 1 Failed to cache systabstats contents for database 'testdb' (5), object 'tObjectSeed' (405654). Error: 3422, Severity: 20, State: 1 Database 'testdb' (dbid 5): failed to open table ID 405654, for which a row exists in Invalid pointer param number 6, pointer value 0x0000000A sp_flushstats делали перед снятием бекапа ?? тынц база, по ходу дела, диасофтовская ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 06.08.2008, 16:34 |
|
||
|
load database в ASE 15.0.2 ESD #5 под Win2003Server из дампа ASE 12.5.3 под SunSolaris
|
|||
|---|---|---|---|
|
#18+
У меня два предположения: 1. База была создана не по правилам Sybase для мультиплатформенного дампа 2. Cross-platform conversion for database testdb: 103457281 pages completed. I/O error detected on disk buffer 0x22F0C820 for page request 105912320, dbid 5. какраз в этом месте и находится tObjectSeed. Пока что попросил чтобы сделали маленькую базу, и сделали дамп в соотв. инструкции Sybase (http://www.sybase.com/content/1033627/18XPDL_1253_WP.pdf). Попросил проверить был ли дамп testdb сделан с соотв. этой инструкции. да, это Диасофт, базу предоставили в рамках проекта. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 06.08.2008, 17:11 |
|
||
|
load database в ASE 15.0.2 ESD #5 под Win2003Server из дампа ASE 12.5.3 под SunSolaris
|
|||
|---|---|---|---|
|
#18+
Vladimir_ShatiloУ меня два предположения: 1. База была создана не по правилам Sybase для мультиплатформенного дампа 2. Cross-platform conversion for database testdb: 103457281 pages completed. I/O error detected on disk buffer 0x22F0C820 for page request 105912320, dbid 5. какраз в этом месте и находится tObjectSeed. Пока что попросил чтобы сделали маленькую базу, и сделали дамп в соотв. инструкции Sybase (http://www.sybase.com/content/1033627/18XPDL_1253_WP.pdf). Попросил проверить был ли дамп testdb сделан с соотв. этой инструкции. да, это Диасофт, базу предоставили в рамках проекта. всё правильно сделали ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 06.08.2008, 17:14 |
|
||
|
load database в ASE 15.0.2 ESD #5 под Win2003Server из дампа ASE 12.5.3 под SunSolaris
|
|||
|---|---|---|---|
|
#18+
Vladimir_Shatiloда, это Диасофт, базу предоставили в рамках проекта. базу то обезличили перед предоставлением? ;) ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 06.08.2008, 17:15 |
|
||
|
|

start [/forum/topic.php?fid=55&msg=35474391&tid=2011451]: |
0ms |
get settings: |
8ms |
get forum list: |
18ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
176ms |
get topic data: |
9ms |
get forum data: |
2ms |
get page messages: |
52ms |
get tp. blocked users: |
2ms |
| others: | 235ms |
| total: | 510ms |

| 0 / 0 |
