Hi, I receive this error when trying to restore my last autolog file: >recover_start auto LOG 002 ERR -24988,ERR_SQL: sql error -71,connection broken
Below you will see my dbm.knl, dbm.prt, and kernel traces. I am able to restore my data backup, but I cannot recover my last data from autosave.002. Any help will be very appreciated. Thanks. Martin. 1) My Scenario: I re-created my database instance to simulate a total crash, I used the same script that was run to create it. Before dropping my database to simulate the crash, I executed a full data backup, added some more data, and then executed a log backup, which created another autosave.002 file (using DBM GUI). This is my creation script: param_startsession param_init param_put MAXUSERTASKS 50 param_put MAXDATADEVSPACES 50 param_checkall param_commitsession param_addvolume 1 LOG c:\sapdb\data\prod\LOG_001 F 1000 param_addvolume 1 DATA c:\sapdb\data\prod\DAT_001 F 10000 db_admin util_connect util_execute INIT CONFIG util_activate dba,dba util_release load_systab -ud domain sql_connect dba,dba sql_execute CREATE USER sa PASSWORD basica DBA NOT EXCLUSIVE medium_put data c:\sapdb\data\prod\datasave FILE DATA 0 8 YES medium_put auto c:\sapdb\data\prod\autosave FILE AUTO util_connect dbm,dbm backup_save data autosave_on 2) My recover script: db_admin util_connect dbm,dbm util_execute init config recover_start data DATA recover_start auto LOG 002 util_release db_online 3) My output from the recover script shown above: >db_admin OK --- >util_connect dbm,dbm OK --- >util_execute init config OK --- >recover_start data DATA OK Returncode 0 Date 20030623 Time 00121711 Server MAQUINA_MCS Database PROD Kernel Version Kernel 7.4.3 Build 017-123-039-277 Pages Transferred 296 Pages Left 0 Volumes 1 Medianame data Location c:\sapdb\data\prod\datasave Errortext Label DAT_00005 Is Consistent true First LOG Page 14401 Last LOG Page DB Stamp 1 Date 20030618 DB Stamp 1 Time 00105111 DB Stamp 2 Date DB Stamp 2 Time Page Count 279 Devices Used 1 Database ID MAQUINA_MCS:PROD_20030612_170056 Max Used Data Page 0 --- >recover_start auto LOG 002 ERR -24988,ERR_SQL: sql error -71,connection broken --- 4) DBM.KNL 3EF726780002| |HISTLOST | | |2003-06-23 12:10:32| | | | | | | | 0| | 3EF726900004|DAT_00001|SAVE WARM|2003-06-23 12:10:56|2003-06-23 12:10:56|2003-06-23 12:10:57|2003-06-23 12:10:58| 1005| |NO |data | 224| 1| 0| | 3EF726920006|LOG_00001|SAVE WARM|2003-06-23 12:10:39|2003-06-23 12:10:54|2003-06-23 12:10:58|2003-06-23 12:11:00| 0| 971| |auto | 352| 1| 0| | 3EF728060002| |HISTLOST | | |2003-06-23 12:17:10| | | | | | | | 0| | 3EF728070003|DAT_00005|RESTORE |2003-06-18 10:51:11|2003-06-18 10:51:11|2003-06-23 12:17:11|2003-06-23 12:17:13| 14401| |NO |data | 296| 1| 0| | 5) DBM.UTL ---------------------------------------------------------------------------- ---- Date Time Message-Text ---------------------------------------------------------------------------- ---- 2003-06-23 12:10:22 3EF7266E0001 0000 ICF INIT CONFIG 2003-06-23 12:10:32 3EF7266E0001 0001 RET RETURNCODE 0 2003-06-23 12:10:32 3EF726780003 0000 AC1 ACTIVATE SERVERDB SYSDBA DBA 2003-06-23 12:10:35 3EF726780003 0001 RET RETURNCODE 0 2003-06-23 12:10:56 3EF726900004 0000 SDB SAVE DATA QUICK TO 'c:\sapdb\data\prod\datasave' FILE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'data' 2003-06-23 12:10:58 3EF726900004 0001 RET RETURNCODE 0 2003-06-23 12:10:58 3EF726900004 0002 TAP DATE.............. 2003-06-23 2003-06-23 12:10:58 3EF726900004 0003 TAP TIME.............. 12:10:57 2003-06-23 12:10:58 3EF726900004 0004 TAP SERVERDB.......... PROD 2003-06-23 12:10:58 3EF726900004 0005 TAP SERVERNODE........ MAQUINA_MCS 2003-06-23 12:10:58 3EF726900004 0006 TAP KERNEL VERSION.... Kernel 7.4.3 Build 017-123-039-277 2003-06-23 12:10:58 3EF726900004 0007 TAP PAGES TRANSFERRED. 224 2003-06-23 12:10:58 3EF726900004 0008 TAP PAGES LEFT........ 0 2003-06-23 12:10:58 3EF726900004 0009 TAP NO OF VOLUMES..... 1 2003-06-23 12:10:58 3EF726900004 000A TAP MEDIA NAME........ data 2003-06-23 12:10:58 3EF726900004 000B TAP TAPE NAME......... c:\sapdb\data\prod\datasave 2003-06-23 12:10:58 3EF726900004 000C TAP TAPE ERRORTEXT.... UNDEF 2003-06-23 12:10:58 3EF726900004 000D TAP TAPE LABEL........ DAT_00001 2003-06-23 12:10:58 3EF726900004 000E TAP IS CONSISTENT..... TRUE 2003-06-23 12:10:58 3EF726900004 000F TAP FIRST LPNO........ 1005 2003-06-23 12:10:58 3EF726900004 0010 TAP LAST LPNO......... UNDEF 2003-06-23 12:10:58 3EF726900004 0011 TAP DBSTAMP1 DATE..... 2003-06-23 2003-06-23 12:10:58 3EF726900004 0012 TAP DBSTAMP1 TIME..... 12:10:56 2003-06-23 12:10:58 3EF726900004 0013 TAP DBSTAMP2 DATE..... UNDEF 2003-06-23 12:10:58 3EF726900004 0014 TAP DBSTAMP2 TIME..... UNDEF 2003-06-23 12:10:58 3EF726900004 0015 TAP BD PAGE COUNT..... 206 2003-06-23 12:10:58 3EF726900004 0016 TAP TAPEDEVICES USED.. 1 2003-06-23 12:10:58 3EF726900004 0017 TAP DB_IDENT.......... MAQUINA_MCS:PROD_20030623_121057 2003-06-23 12:10:58 3EF726900004 0018 TAP MAX USED DATA PNO. 0 2003-06-23 12:10:58 3EF726920005 0000 ASO AUTOSAVE ON 'c:\sapdb\data\prod\autosave' FILE MEDIANAME 'auto' 2003-06-23 12:10:58 3EF726920005 0001 RET RETURNCODE 0 2003-06-23 12:16:53 3EF727F50007 0000 ASE AUTOSAVE END 2003-06-23 12:16:53 3EF727F50007 0001 RET RETURNCODE 0 2003-06-23 12:16:56 3EF727F80008 0000 SHT SHUTDOWN 2003-06-23 12:17:09 3EF728050001 0000 ICF INIT CONFIG 2003-06-23 12:17:10 3EF728050001 0001 RET RETURNCODE 0 2003-06-23 12:17:11 3EF728070003 0000 RDB RESTORE DATA QUICK FROM 'c:\sapdb\data\prod\datasave' FILE BLOCKSIZE 8 MEDIANAME 'data' 2003-06-23 12:17:13 3EF728070003 0001 RET RETURNCODE 0 2003-06-23 12:17:13 3EF728070003 0002 TAP DATE.............. 2003-06-23 2003-06-23 12:17:13 3EF728070003 0003 TAP TIME.............. 12:17:11 2003-06-23 12:17:13 3EF728070003 0004 TAP SERVERDB.......... PROD 2003-06-23 12:17:13 3EF728070003 0005 TAP SERVERNODE........ MAQUINA_MCS 2003-06-23 12:17:13 3EF728070003 0006 TAP KERNEL VERSION.... Kernel 7.4.3 Build 017-123-039-277 2003-06-23 12:17:13 3EF728070003 0007 TAP PAGES TRANSFERRED. 296 2003-06-23 12:17:13 3EF728070003 0008 TAP PAGES LEFT........ 0 2003-06-23 12:17:13 3EF728070003 0009 TAP NO OF VOLUMES..... 1 2003-06-23 12:17:13 3EF728070003 000A TAP MEDIA NAME........ data 2003-06-23 12:17:13 3EF728070003 000B TAP TAPE NAME......... c:\sapdb\data\prod\datasave 2003-06-23 12:17:13 3EF728070003 000C TAP TAPE ERRORTEXT.... UNDEF 2003-06-23 12:17:13 3EF728070003 000D TAP TAPE LABEL........ DAT_00005 2003-06-23 12:17:13 3EF728070003 000E TAP IS CONSISTENT..... TRUE 2003-06-23 12:17:13 3EF728070003 000F TAP FIRST LPNO........ 14401 2003-06-23 12:17:13 3EF728070003 0010 TAP LAST LPNO......... UNDEF 2003-06-23 12:17:13 3EF728070003 0011 TAP DBSTAMP1 DATE..... 2003-06-18 2003-06-23 12:17:13 3EF728070003 0012 TAP DBSTAMP1 TIME..... 10:51:11 2003-06-23 12:17:13 3EF728070003 0013 TAP DBSTAMP2 DATE..... UNDEF 2003-06-23 12:17:13 3EF728070003 0014 TAP DBSTAMP2 TIME..... UNDEF 2003-06-23 12:17:13 3EF728070003 0015 TAP BD PAGE COUNT..... 279 2003-06-23 12:17:13 3EF728070003 0016 TAP TAPEDEVICES USED.. 1 2003-06-23 12:17:13 3EF728070003 0017 TAP DB_IDENT.......... MAQUINA_MCS:PROD_20030612_170056 2003-06-23 12:17:13 3EF728070003 0018 TAP MAX USED DATA PNO. 0 2003-06-23 12:17:13 3EF728090004 0000 RLG RESTORE LOG QUICK FROM 'c:\sapdb\data\prod\autosave.002' FILE MEDIANAME 'auto' -------------------------------------------- current write position ---------------- 6) DBM.PRT ---------------------------------------------------------------------------- -- Date Time TID(hex) Typ MsgID Label Message ---------------------------------------------------------------------------- -- 2003-06-23 12:16:53 0x00000324 0 DBM command db_admin 2003-06-23 12:17:09 0x00000324 0 DBM command util_execute init config 2003-06-23 12:17:10 0x00000324 0 DBM command recover_start data DATA 2003-06-23 12:17:13 0x00000324 0 DBM command recover_start auto LOG 002 2003-06-23 12:17:14 0x00000324 ERR -24988 DBM ERR_SQL: sql error 0x00000324 ERR -24988 DBM -71,connection broken 7) KNLDIAG.ERR ---------------------------------------------------------------------------- ---- Date Time TID(hex) Typ MsgID Label Message-Text ---------------------------------------------------------------------------- ---- 2003-06-23 12:10:15 --- Starting GMT 2003-06-23 12:10:15 7.4.3 Build 017-123-039-277 2003-06-23 12:17:01 --- Starting GMT 2003-06-23 12:17:01 7.4.3 Build 017-123-039-277 2003-06-23 12:17:14 0x32C ERR 52608 RESTART LOCAL: failed 2003-06-23 12:17:14 0x32C ERR 60 Log RESTART ERROR '400' => SHUTDOWN IS FORCED 8) KNLDIAG ---------------------------------------------------------------------------- ---- Date Time TID(hex) Typ MsgID Label Message-Text ---------------------------------------------------------------------------- ---- 2003-06-23 12:17:01 0x190 19769 INFO Starting SERVERDB: 'PROD' 2003-06-23 12:17:01 0x190 19770 INFO SERVERNODE: 'MAQUINA_MCS' 2003-06-23 12:17:01 0x190 19771 INFO Process ID: 940 2003-06-23 12:17:01 0x190 19773 INFO Date: 2003-06-23 2003-06-23 12:17:01 0x190 19772 INFO Owner: 'SYSTEM' 2003-06-23 12:17:01 0x190 19775 INFO Processors: 1 2003-06-23 12:17:01 0x190 19782 INFO Fiber: 'YES' 2003-06-23 12:17:01 0x190 19776 INFO Max virtual memory: 2047 MB 2003-06-23 12:17:01 0x190 19777 INFO Total physical memory: 255 MB 2003-06-23 12:17:01 0x190 19778 INFO Available physical memory: 158 MB 2003-06-23 12:17:01 0x190 19779 INFO Kernel shared data size: 91 MB 2003-06-23 12:17:01 0x190 19692 TCLUSTER tw;al;ut;2000*sv,100*bup;10*ev,10*gc;ti,100*dw;30000*us;compress 2003-06-23 12:17:01 0x190 19693 TCLUSTER number of 'BUP': 0 2003-06-23 12:17:01 0x190 19693 TCLUSTER number of ' DW': 50 2003-06-23 12:17:01 0x190 19693 TCLUSTER number of ' US': 50 2003-06-23 12:17:01 0x190 19693 TCLUSTER number of ' SV': 60 2003-06-23 12:17:01 0x190 19693 TCLUSTER number of ' EV': 1 2003-06-23 12:17:01 0x190 19693 TCLUSTER number of ' GC': 0 2003-06-23 12:17:01 0x190 19860 MEMORY RTE PageAllocator: 10000 Pages allocated 2003-06-23 12:17:01 0x190 19811 EVENTING Suppressing output to 'knldiag.evt' 0 pages 2003-06-23 12:17:01 0x190 19812 EVENTING Eventbuffer 100 events 1 tasks 2003-06-23 12:17:01 0x190 19815 EVENTING No AliveEvent generation 2003-06-23 12:17:01 0x190 19831 TRACE_IO Configured _MAX_MESSAGE_FILES:0 2003-06-23 12:17:01 0x190 19832 TRACE_IO Disabled: No TraceMessagefiles wanted 2003-06-23 12:17:01 0x1BC 19688 THREAD CLOCK thread started 2003-06-23 12:17:01 0xFC 19688 THREAD TIMER thread started 2003-06-23 12:17:01 0x354 19688 THREAD ASYNC0 thread started 2003-06-23 12:17:01 0x330 19688 THREAD CONSOLE thread started 2003-06-23 12:17:01 0x12C 19688 THREAD REQUESTOR thread started 2003-06-23 12:17:01 0x374 19627 TASKING UKT started, TID:0x374 2003-06-23 12:17:01 0x368 19627 TASKING UKT started, TID:0x368 2003-06-23 12:17:01 0x144 19627 TASKING UKT started, TID:0x144 2003-06-23 12:17:01 0x32C 19627 TASKING UKT started, TID:0x32C 2003-06-23 12:17:01 0x1D4 19627 TASKING UKT started, TID:0x1D4 2003-06-23 12:17:01 0x29C 19627 TASKING UKT started, TID:0x29C 2003-06-23 12:17:01 0x380 19627 TASKING UKT started, TID:0x380 2003-06-23 12:17:04 0x380 19615 VOLUMEIO Attaching volume 'knltrace' 2003-06-23 12:17:04 0x338 19613 DBSTATE I/O thread for 'knltrace' started 2003-06-23 12:17:04 0x380 19617 VOLUMEIO Single I/O attach, 'knltrace', UKT:6 2003-06-23 12:17:04 0x380 54003 dynpool DYNP_A51_CACHE : 1020 2003-06-23 12:17:04 0x380 54003 dynpool AK51SIZES user + 1 : 51 2003-06-23 12:17:04 0x380 54003 dynpool AK51SIZES headlist all : 204 2003-06-23 12:17:04 0x380 54003 dynpool AK51SIZES headlist elem: 4 2003-06-23 12:17:04 0x380 54003 dynpool AK51SIZES list all : 816 2003-06-23 12:17:04 0x380 54003 dynpool AK51SIZES list element : 16 2003-06-23 12:17:04 0x380 54003 dynpool INDEX FileListItemSize : 8 2003-06-23 12:17:04 0x380 54003 dynpool INDEX NumFileListItems : 2048 2003-06-23 12:17:04 0x380 54003 dynpool INDEX FileListSizeAll : 16384 2003-06-23 12:17:04 0x380 54003 dynpool INDEX FunnelItemSize : 8 2003-06-23 12:17:04 0x380 54003 dynpool INDEX QueueItemPtrSize : 4 2003-06-23 12:17:04 0x380 54003 dynpool INDEX QueueItemSize : 36 2003-06-23 12:17:04 0x380 54003 dynpool INDEX SortItemSize : 16 2003-06-23 12:17:04 0x380 54003 dynpool INDEX NumFunnelItems : 2048 2003-06-23 12:17:04 0x380 54003 dynpool INDEX FunnelSizeAll : 131072 2003-06-23 12:17:04 0x380 54003 dynpool DYNP_B49_IDXSIZE : 147456 2003-06-23 12:17:04 0x380 19600 VERSION 'Kernel 7.4.3 Build 017-123-039-277' 2003-06-23 12:17:04 0x380 19600 VERSION 'W32/INTEL 7.4.3 Build 017-123-039-277' 2003-06-23 12:17:04 0x380 54003 dynDATA DYND_K57_KB_PAGES : 11 2003-06-23 12:17:04 0x380 54003 dynDATA BACKUP RESTART REC (8K): 1 2003-06-23 12:17:04 0x380 54003 dynpool BACKUP TASK LIST : 832 2003-06-23 12:17:04 0x380 54003 dynpool BACKUP TAPE LIST : 304 2003-06-23 12:17:04 0x380 54003 dynpool BACKUP DEVSP LIST : 800 2003-06-23 12:17:04 0x380 54003 dynpool BACKUP SRR QUEUE : 2528 2003-06-23 12:17:04 0x380 54003 dynpool DYNP_K38_SAVE_GLOB : 4464 2003-06-23 12:17:04 0x380 54003 dynDATA DYND_K38_SAVE : 841 2003-06-23 12:17:04 0x380 54003 dynDATA BACKUP RESTART REC (8K): 1 2003-06-23 12:17:04 0x380 54003 dynpool BACKUP TASK LIST : 32 2003-06-23 12:17:04 0x380 54003 dynpool BACKUP TAPE LIST : 304 2003-06-23 12:17:04 0x380 54003 dynpool BACKUP DEVSP LIST : 16 2003-06-23 12:17:04 0x380 54003 dynpool BACKUP SRR QUEUE : 128 2003-06-23 12:17:04 0x380 54003 dynpool DYNP_K38_AUTOSAVE : 480 2003-06-23 12:17:04 0x380 54003 dynDATA DYND_K38_AUTOSAVE : 41 2003-06-23 12:17:04 0x380 54003 dynpool KB50 mdesc item size : 232 2003-06-23 12:17:04 0x380 54003 dynpool KB90 mdesc items : 113 2003-06-23 12:17:04 0x380 54003 dynpool KB90 mdesc list size : 26216 2003-06-23 12:17:04 0x380 54003 dynpool KB90 mdesc list aligned: 26224 2003-06-23 12:17:04 0x380 54003 dynpool KB90 packet items : 61 2003-06-23 12:17:04 0x380 54003 dynpool KB90 packet desc size : 16 2003-06-23 12:17:04 0x380 54003 dynpool KB90 packet desc list : 976 2003-06-23 12:17:04 0x380 54003 dynpool KB90 packet size : 36656 2003-06-23 12:17:04 0x380 54003 dynpool KB90 packetsize aligned: 36656 2003-06-23 12:17:04 0x380 54003 dynpool KB90 packet list :2236016 2003-06-23 12:17:04 0x380 54003 dynpool KB90 parent list : 2576 2003-06-23 12:17:04 0x380 54003 dynpool KB90 kbfunction_task : 112 2003-06-23 12:17:04 0x380 54003 dynpool KB90 parent items / 0.7: 160 2003-06-23 12:17:04 0x380 54003 dynpool KB90 parent desc size : 16 2003-06-23 12:17:04 0x380 54003 dynpool KB90 parentdesc aligned: 2560 2003-06-23 12:17:04 0x380 54003 dynpool KB90 parent hash list : 640 2003-06-23 12:17:04 0x380 54003 dynpool KB90 parenthash aligned: 640 2003-06-23 12:17:04 0x380 54003 dynpool KB90 maxservertasks : 60 2003-06-23 12:17:04 0x380 54003 dynpool KB90 server desc size : 24 2003-06-23 12:17:04 0x380 54003 dynpool KB90 server list : 1440 2003-06-23 12:17:04 0x380 54003 dynpool KB90 serverlist aligned: 1440 2003-06-23 12:17:04 0x380 54003 dynpool DYNP_K90_DISTRIB :2267856 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 5 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:0 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 54 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:1 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 53 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:2 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 52 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:3 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 51 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:4 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 50 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:5 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 49 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:6 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 48 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:7 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 47 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:0 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 46 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:1 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 45 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:2 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 44 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:3 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 43 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:4 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 42 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:5 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 41 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:6 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 40 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:7 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 39 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:0 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 38 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:1 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 37 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:2 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 36 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:3 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 35 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:4 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 34 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:5 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 33 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:6 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 32 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:7 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 31 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:0 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 30 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:1 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 29 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:2 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 28 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:3 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 27 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:4 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 26 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:5 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 25 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:6 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 24 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:7 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 23 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:0 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 22 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:1 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 21 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:2 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 20 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:3 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 19 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:4 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 18 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:5 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 17 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:6 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 16 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:7 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 15 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:0 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 14 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:1 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 13 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:2 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 12 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:3 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 11 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:4 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 10 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:5 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 9 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:6 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 8 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:7 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 7 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:0 2003-06-23 12:17:04 0x380 14 Pager Start TaskId: 6 2003-06-23 12:17:04 0x380 15 Pager First DataCacheSegment:1 2003-06-23 12:17:05 0xFC 19601 DBSTATE SERVERDB is ready ============================================ begin of write cycle ================== 2003-06-23 12:17:06 0x144 19633 CONNECT Connect req. (T4, Node:'', PID:804) 2003-06-23 12:17:06 0x144 19651 CONNECT Connection released, T4 2003-06-23 12:17:06 0x144 19633 CONNECT Connect req. (T4, Node:'', PID:804) 2003-06-23 12:17:06 0x144 19651 CONNECT Connection released, T4 2003-06-23 12:17:09 0x144 19633 CONNECT Connect req. (T4, Node:'', PID:804) 2003-06-23 12:17:09 0x144 19615 VOLUMEIO Attaching volume 'c:\sapdb\data\prod\LOG_001' 2003-06-23 12:17:09 0x3A8 19613 DBSTATE I/O thread for 'c:\sapdb\data\prod\LOG_001' started 2003-06-23 12:17:09 0x144 19617 VOLUMEIO Single I/O attach, 'c:\sapdb\data\prod\LOG_001', UKT:3 2003-06-23 12:17:09 0x144 19616 VOLUMEIO Detaching volume 'c:\sapdb\data\prod\LOG_001' 2003-06-23 12:17:09 0x3A8 19614 DBSTATE I/O thread for 'c:\sapdb\data\prod\LOG_001' stopped 2003-06-23 12:17:09 0x378 19618 VOLUMEIO Single I/O detach, 'c:\sapdb\data\prod\LOG_001', UKT:3 2003-06-23 12:17:09 0x144 19615 VOLUMEIO Attaching volume 'c:\sapdb\data\prod\LOG_001' 2003-06-23 12:17:09 0x3A8 19613 DBSTATE I/O thread for 'c:\sapdb\data\prod\LOG_001' started 2003-06-23 12:17:10 0x144 19617 VOLUMEIO Single I/O attach, 'c:\sapdb\data\prod\LOG_001', UKT:3 2003-06-23 12:17:10 0x144 19615 VOLUMEIO Attaching volume 'c:\sapdb\data\prod\DAT_001' 2003-06-23 12:17:10 0x370 19613 DBSTATE I/O thread for 'c:\sapdb\data\prod\DAT_001' started 2003-06-23 12:17:10 0x144 19617 VOLUMEIO Single I/O attach, 'c:\sapdb\data\prod\DAT_001', UKT:3 2003-06-23 12:17:10 0x144 19616 VOLUMEIO Detaching volume 'c:\sapdb\data\prod\DAT_001' 2003-06-23 12:17:10 0x370 19614 DBSTATE I/O thread for 'c:\sapdb\data\prod\DAT_001' stopped 2003-06-23 12:17:10 0x378 19618 VOLUMEIO Single I/O detach, 'c:\sapdb\data\prod\DAT_001', UKT:3 2003-06-23 12:17:10 0x144 19615 VOLUMEIO Attaching volume 'c:\sapdb\data\prod\DAT_001' 2003-06-23 12:17:10 0x370 19613 DBSTATE I/O thread for 'c:\sapdb\data\prod\DAT_001' started 2003-06-23 12:17:10 0x144 19617 VOLUMEIO Single I/O attach, 'c:\sapdb\data\prod\DAT_001', UKT:3 2003-06-23 12:17:10 0x144 54003 dynpool DATA_CACHE_REGIONS : 8 2003-06-23 12:17:10 0x144 54003 dynpool B20_DATACACHE_HEAD : 79784 2003-06-23 12:17:10 0x144 54003 dynpool DATACACHE head num item: 9973 2003-06-23 12:17:10 0x144 54003 dynpool DATACACHE head item siz: 8 2003-06-23 12:17:10 0x144 54003 dynpool DATACACHE task queue : 2688 2003-06-23 12:17:10 0x144 54003 dynpool US + SV + DW + 8 : 168 2003-06-23 12:17:10 0x144 54003 dynpool DATACACHE taskq elem : 16 2003-06-23 12:17:10 0x144 54003 dynpool B20_DATACACHE_TASKQ : 82472 2003-06-23 12:17:10 0x144 54003 dynDATA DATA_CACHE_PAGES : 1243 2003-06-23 12:17:10 0x144 54003 dynpool B20_DATACACHE_CB : 89496 2003-06-23 12:17:10 0x144 54003 dynpool DATACACHE num cblocks : 1243 2003-06-23 12:17:10 0x144 54003 dynpool DATACACHE cblock size : 72 2003-06-23 12:17:10 0x144 54003 dynpool DYNP_B20_DATACACHE :1375744 2003-06-23 12:17:10 0x144 54003 dynDATA DYND_B20_DATACACHE : 9944 2003-06-23 12:17:10 0x144 54003 dynpool TREELOCK_HEAD_LIST all : 40028 2003-06-23 12:17:10 0x144 54003 dynpool DATA_CACHE_PAGES*10/par: 10007 2003-06-23 12:17:10 0x144 54003 dynpool TREELOCK_HEAD_LIST elem: 4 2003-06-23 12:17:10 0x144 54003 dynpool TREELOCK_LIST all : 10752 2003-06-23 12:17:10 0x144 54003 dynpool (USER + SERVER + 2) * 2: 224 2003-06-23 12:17:10 0x144 54003 dynpool TREELOCK_LIST elem : 48 2003-06-23 12:17:10 0x144 54003 dynpool TREE_LOCK region count : 8 2003-06-23 12:17:10 0x144 54003 dynpool DYNP_B77_TREE_LOCK : 406240 2003-06-23 12:17:10 0x144 53000 DATACACH Reduce Data Cache (pool): 1243 2003-06-23 12:17:10 0x144 53000 DATACACH Reduce Data Cache (pool): 1243 2003-06-23 12:17:10 0x144 53000 DATACACH Reduce Data Cache (pool): 1243 2003-06-23 12:17:10 0x144 5 Log Formatting from offset 1 to 998. 2003-06-23 12:17:10 0x144 19616 VOLUMEIO Detaching volume 'c:\sapdb\data\prod\DAT_001' 2003-06-23 12:17:10 0x370 19614 DBSTATE I/O thread for 'c:\sapdb\data\prod\DAT_001' stopped 2003-06-23 12:17:10 0x378 19618 VOLUMEIO Single I/O detach, 'c:\sapdb\data\prod\DAT_001', UKT:3 2003-06-23 12:17:10 0x144 19616 VOLUMEIO Detaching volume 'c:\sapdb\data\prod\LOG_001' 2003-06-23 12:17:10 0x3A8 19614 DBSTATE I/O thread for 'c:\sapdb\data\prod\LOG_001' stopped 2003-06-23 12:17:10 0x378 19618 VOLUMEIO Single I/O detach, 'c:\sapdb\data\prod\LOG_001', UKT:3 2003-06-23 12:17:11 0x144 19615 VOLUMEIO Attaching volume 'c:\sapdb\data\prod\DAT_001' 2003-06-23 12:17:11 0x3A8 19613 DBSTATE I/O thread for 'c:\sapdb\data\prod\DAT_001' started 2003-06-23 12:17:11 0x144 19617 VOLUMEIO Single I/O attach, 'c:\sapdb\data\prod\DAT_001', UKT:3 2003-06-23 12:17:11 0x144 19616 VOLUMEIO Detaching volume 'c:\sapdb\data\prod\DAT_001' 2003-06-23 12:17:11 0x3A8 19614 DBSTATE I/O thread for 'c:\sapdb\data\prod\DAT_001' stopped 2003-06-23 12:17:11 0x378 19618 VOLUMEIO Single I/O detach, 'c:\sapdb\data\prod\DAT_001', UKT:3 2003-06-23 12:17:11 0x144 19615 VOLUMEIO Attaching volume 'c:\sapdb\data\prod\DAT_001' 2003-06-23 12:17:11 0x3A8 19613 DBSTATE I/O thread for 'c:\sapdb\data\prod\DAT_001' started 2003-06-23 12:17:11 0x144 19617 VOLUMEIO Single I/O attach, 'c:\sapdb\data\prod\DAT_001', UKT:3 2003-06-23 12:17:11 0x370 19625 IO Async I/O thread started, 'c:\sapdb\data\prod\DAT_001 2003-06-23 12:17:11 0x388 19625 IO Async I/O thread started, 'c:\sapdb\data\prod\datasave 2003-06-23 12:17:11 0x32C 52101 RESTORE Filetype: file 2003-06-23 12:17:12 0x32C 52024 RESTORE 200 pages <- "\sapdb\data\prod\datasave" 2003-06-23 12:17:13 0x388 19626 IO Async I/O thread stopped, 'c:\sapdb\data\prod\datasave' 2003-06-23 12:17:13 0x32C 52024 RESTORE 296 pages <- "\sapdb\data\prod\datasave" 2003-06-23 12:17:13 0x370 19626 IO Async I/O thread stopped, 'c:\sapdb\data\prod\DAT_001' 2003-06-23 12:17:13 0x144 19616 VOLUMEIO Detaching volume 'c:\sapdb\data\prod\DAT_001' 2003-06-23 12:17:13 0x3A8 19614 DBSTATE I/O thread for 'c:\sapdb\data\prod\DAT_001' stopped 2003-06-23 12:17:13 0x378 19618 VOLUMEIO Single I/O detach, 'c:\sapdb\data\prod\DAT_001', UKT:3 2003-06-23 12:17:13 0x144 52012 RESTORE ready 2003-06-23 12:17:13 0x144 19615 VOLUMEIO Attaching volume 'c:\sapdb\data\prod\DAT_001' 2003-06-23 12:17:13 0x3A8 19613 DBSTATE I/O thread for 'c:\sapdb\data\prod\DAT_001' started 2003-06-23 12:17:13 0x144 19617 VOLUMEIO Single I/O attach, 'c:\sapdb\data\prod\DAT_001', UKT:3 2003-06-23 12:17:13 0x144 19615 VOLUMEIO Attaching volume 'c:\sapdb\data\prod\LOG_001' 2003-06-23 12:17:13 0x370 19613 DBSTATE I/O thread for 'c:\sapdb\data\prod\LOG_001' started 2003-06-23 12:17:13 0x144 19617 VOLUMEIO Single I/O attach, 'c:\sapdb\data\prod\LOG_001', UKT:3 2003-06-23 12:17:13 0x144 12 Pager Start Read Converter 2003-06-23 12:17:13 0x144 13 Pager Stop Read Converter, Pages: 8 IO: 8 2003-06-23 12:17:13 0x144 54003 dynpool DATA_CACHE_REGIONS : 8 2003-06-23 12:17:13 0x144 54003 dynpool B20_DATACACHE_HEAD : 79784 2003-06-23 12:17:13 0x144 54003 dynpool DATACACHE head num item: 9973 2003-06-23 12:17:13 0x144 54003 dynpool DATACACHE head item siz: 8 2003-06-23 12:17:13 0x144 54003 dynpool DATACACHE task queue : 2688 2003-06-23 12:17:13 0x144 54003 dynpool US + SV + DW + 8 : 168 2003-06-23 12:17:13 0x144 54003 dynpool DATACACHE taskq elem : 16 2003-06-23 12:17:13 0x144 54003 dynpool B20_DATACACHE_TASKQ : 82472 2003-06-23 12:17:13 0x144 54003 dynDATA DATA_CACHE_PAGES : 1242 2003-06-23 12:17:13 0x144 54003 dynpool B20_DATACACHE_CB : 89424 2003-06-23 12:17:13 0x144 54003 dynpool DATACACHE num cblocks : 1242 2003-06-23 12:17:13 0x144 54003 dynpool DATACACHE cblock size : 72 2003-06-23 12:17:13 0x144 54003 dynpool DYNP_B20_DATACACHE :1375168 2003-06-23 12:17:13 0x144 54003 dynDATA DYND_B20_DATACACHE : 9936 2003-06-23 12:17:13 0x144 54003 dynpool DYNP_K51_LOCK_LIST :1147920 2003-06-23 12:17:13 0x144 54003 dynpool LOCK maxlocks : 4480 2003-06-23 12:17:13 0x144 54003 dynpool LOCK items : 15900 2003-06-23 12:17:13 0x144 54003 dynpool LOCK Regions : 24 2003-06-23 12:17:13 0x144 54003 dynpool LOCK TransRegions : 8 2003-06-23 12:17:13 0x144 54003 dynpool LOCK RegionGlob+Space : 2688 2003-06-23 12:17:13 0x144 54003 dynpool LOCK TransGlob : 640 2003-06-23 12:17:13 0x144 54003 dynpool LOCK SupplyItemsPerRgn : 100 2003-06-23 12:17:13 0x144 54003 dynpool LOCK SupplySize : 153600 2003-06-23 12:17:13 0x144 54003 dynpool LOCK RowHash entries : 4480 2003-06-23 12:17:13 0x144 54003 dynpool LOCK TabHash entries : 896 2003-06-23 12:17:13 0x144 54003 dynpool LOCK Row+Tab hash size : 21504 2003-06-23 12:17:13 0x144 54003 dynpool LOCK Trans entries : 448 2003-06-23 12:17:13 0x144 54003 dynpool LOCK trans_list size : 75264 2003-06-23 12:17:13 0x144 54003 dynpool LOCK TransPtrList : 1792 2003-06-23 12:17:13 0x144 54003 dynpool LOCK TransHash entries : 448 2003-06-23 12:17:13 0x144 54003 dynpool LOCK TransHash size : 1792 2003-06-23 12:17:13 0x144 54003 dynpool LOCK SupplyPoolSegments: 135 2003-06-23 12:17:13 0x144 54003 dynpool LOCK SupplyPoolSize : 866704 2003-06-23 12:17:13 0x144 54003 dynpool LOCK ObjColl_list size : 14336 2003-06-23 12:17:13 0x144 54003 dynpool LOCK ObjReq_list size : 7168 2003-06-23 12:17:13 0x144 0 Log no update of LogInfoPage: DeviceState = Cleared, LogIsEmpty = true 2003-06-23 12:17:13 0x144 7 Log 1 queues, flushmode is 'MinimizeSpace', devstate is 'Cleared' 2003-06-23 12:17:13 0x144 8 Log Oldest not saved is ioseq -1 @ off 1 2003-06-23 12:17:13 0x144 10 Log LogVolume not completely written until now 2003-06-23 12:17:13 0x144 6 Log Restart from ioseq 14401 @ off 659 to ioseq -1 @ off -1 2003-06-23 12:17:13 0x144 11 Log Result after checking the log device: 'Ok' 2003-06-23 12:17:13 0x388 19625 IO Async I/O thread started, 'c:\sapdb\data\prod\autosave.002 2003-06-23 12:17:14 0x32C 52101 RESTORE Filetype: file 2003-06-23 12:17:14 0x388 19626 IO Async I/O thread stopped, 'c:\sapdb\data\prod\autosave.002' 2003-06-23 12:17:14 0x32C 42 Log recovering log from tape from IOSeq '14401' until IOSeq: '-1' 2003-06-23 12:17:14 0x32C 46 Log last-redo-read#0:TR-1(0)[EMAIL PROTECTED]'NoOp':0:0 2003-06-23 12:17:14 0x32C WRN 16 Log REDO: Aborted 2003-06-23 12:17:14 0x32C 41 Log Savepoint requested by T105 reason 'Restart' (started). 2003-06-23 12:17:14 0x32C 4 Pager SVP(1) Start Write Data 2003-06-23 12:17:14 0x32C 5 Pager SVP(1) Stop Data IO, Pages: 0 IO: 0 2003-06-23 12:17:14 0x32C 6 Pager SVP(2) Wait for last split, TaskId: 160 2003-06-23 12:17:14 0x32C 7 Pager SVP(2) Stop Wait for last split, Pages: 0 IO: 0 2003-06-23 12:17:14 0x32C 53070 SAVPOINT B20PREPARE_SVP: 11 2003-06-23 12:17:14 0x32C 8 Pager SVP(3) Start Write Data 2003-06-23 12:17:14 0x32C 9 Pager SVP(3) Stop Data IO, Pages: 1 IO: 1 2003-06-23 12:17:14 0x32C 10 Pager SVP(3) Start Write Converter 2003-06-23 12:17:14 0x32C 11 Pager SVP(3) Stop Converter IO, Pages: 2 IO: 2 2003-06-23 12:17:14 0x32C 53071 SAVPOINT B20SVP_COMPLETED: 11 2003-06-23 12:17:14 0x32C ERR 52608 RESTART LOCAL: failed 2003-06-23 12:17:14 0x32C ERR 60 Log RESTART ERROR '400' => SHUTDOWN IS FORCED 2003-06-23 12:17:14 0x32C 19620 DBSTATE Shutdown normal requested 2003-06-23 12:17:14 0x374 19617 VOLUMEIO Single I/O attach, 'knltrace', UKT:1 2003-06-23 12:17:14 0x190 19684 TASKING Tracewriter termination timeout: 1200 sec 2003-06-23 12:17:14 0x374 19619 TASKING Releasing tracewriter 2003-06-23 12:17:14 0x190 19890 DIAGHIST Backup of diagnostic files will be forced at next restart 2003-06-23 12:17:14 0x190 19600 VERSION 'Kernel 7.4.3 Build 017-123-039-277' 2003-06-23 12:17:14 0x190 19654 DBSTATE SERVERDB 'PROD' has stopped -------------------------------------------- current write position ---------------- _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
