Grateful if you could help interpret these data. Is it recovering from 3273458 -> 3273461 ?
2005-01-12 20:33:42 0x864 7 Log Oldest not saved is ioseq 3254654 @ off 5219 2005-01-12 20:33:42 0x864 8 Log First known on LogVolume is ioseq 3206963 @ off 23641 2005-01-12 20:33:42 0x864 5 Log Restart from ioseq 3273458 @ off 23639 to ioseq 3273461 @ off 23640 2005-01-12 20:33:42 0x864 10 Log Result after checking the log device: 'Ok' 2005-01-12 20:33:42 0x8D8 3 Restart recovering log from log_volume from IOSeq: '3273458' 2005-01-12 20:33:42 0x8D8 42 Log normal end of log found at off 23640 lastseq 3273461. 2005-01-12 20:33:42 0x8D8 12 Log last-redo-read#52:TR1515814(1)[EMAIL PROTECTED]'Commit':20050112:201706 Now i am begining to get these information. Am I close to going online or is it still a long way. What message should I see further ? 2005-01-13 03:23:02 0x19C 56 Log Savepoint requested by T10 reason 'FreeBlockManagement' (started). 2005-01-13 03:23:02 0x8D8 4 Pager SVP(1) Start Write Data 2005-01-13 03:23:10 0x8D8 5 Pager SVP(1) Stop Data IO, Pages: 4275 IO: 2850 2005-01-13 03:23:10 0x8D8 6 Pager SVP(2) Wait for last split, TaskId: 35 2005-01-13 03:23:10 0x8D8 7 Pager SVP(2) Stop Wait for last split, Pages: 0 IO: 0 2005-01-13 03:23:10 0x8D8 53070 SAVPOINT B20PREPARE_SVP: 864 2005-01-13 03:23:10 0x8D8 8 Pager SVP(3) Start Write Data 2005-01-13 03:23:11 0x8D8 9 Pager SVP(3) Stop Data IO, Pages: 11 IO: 9 2005-01-13 03:23:11 0x8D8 10 Pager SVP(3) Start Write Converter 2005-01-13 03:23:11 0x8D8 11 Pager SVP(3) Stop Converter IO, Pages: 700 IO: 700 2005-01-13 03:23:11 0x8D8 53071 SAVPOINT B20SVP_COMPLETED: 864 . . . . . . 2005-01-13 07:51:04 0x19C 56 Log Savepoint requested by T10 reason 'FreeBlockManagement' (started). 2005-01-13 07:51:04 0x8D8 4 Pager SVP(1) Start Write Data 2005-01-13 07:51:14 0x8D8 5 Pager SVP(1) Stop Data IO, Pages: 4575 IO: 3425 2005-01-13 07:51:14 0x8D8 6 Pager SVP(2) Wait for last split, TaskId: 35 2005-01-13 07:51:15 0x8D8 7 Pager SVP(2) Stop Wait for last split, Pages: 12 IO: 12 2005-01-13 07:51:15 0x8D8 53070 SAVPOINT B20PREPARE_SVP: 865 2005-01-13 07:51:15 0x8D8 8 Pager SVP(3) Start Write Data 2005-01-13 07:51:15 0x8D8 9 Pager SVP(3) Stop Data IO, Pages: 4 IO: 4 2005-01-13 07:51:15 0x8D8 10 Pager SVP(3) Start Write Converter 2005-01-13 07:51:16 0x8D8 11 Pager SVP(3) Stop Converter IO, Pages: 699 IO: 699 2005-01-13 07:51:16 0x8D8 53071 SAVPOINT B20SVP_COMPLETED: 865 Thank you kana -----Original Message----- From: "D�hr, Markus ICC-H" [mailto:[EMAIL PROTECTED] Sent: Thursday, January 13, 2005 12:36 AM To: Kana; '[email protected]' Subject: RE: Monitoring the progress of Restart recovering log from log_volume from IOSeq: '3273458' > 0x418 19631 CONNECT Connect req., but UTILITY is busy I think due to shutting down the instance during the long run it will rollback everything, this may take as long as the deletion took (depending on the last commit/savepoint). Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus D�hr SAP-CC/BC, SAPDB-DBA Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
