Hello Timo, backups and restores of data backups (complete or incremental) and the backup of log itself copy only a lot of pages between the backup medium and the database. Therefore their speed is normally limited only by the speed of your storage systems (either database volumes or backup media). During a log recovery the actual database operations are repeated, therefore recovery of a log backups can be much slower. However it should not take much more time to recover a log backup then to create the same log amount in the first place within the database (before the log backup).
Best Regards Tilo Heinrich SAP Labs Berlin >-----Original Message----- >From: Timo Denis [mailto:[EMAIL PROTECTED] >Sent: Thursday, June 10, 2004 9:08 AM >To: [EMAIL PROTECTED] >Subject: slow recovery > > >Hi, > >when recovering via DATA + LOG + LOG + ... + LOG-n the DATA recovery >process for a 112GB files takes about 2 hours, but every LOG segment >with 300-600MB takes about one hours. This isn't very fast; are there >any hints to recover logs segments faster? > >I also tried to recover the DATA + INCR files which is very fast, but >what about the LOGS? > >Regards, Timo > >-- >Timo Denis, IT department >DBA / Developer / Administrator [LPIC1] > >IEE S.A. International Electronics & Engineering >Zone Industrielle, L-6468 Echternach, Luxembourg >Phone +(352)72 89 89-6801/6791, Fax +(352)72 89 89-6109 > >This e-mail may contain trade secrets or privileged, undisclosed >or otherwise confidential information. If you are not the intended >recipient and have received this e-mail in error, you are hereby >notified that any review, copying or distribution of it is strictly >prohibited. Please inform us immediately and destroy the original >transmittal from your system. Thank you for your co-operation. > >-- >MaxDB Discussion Mailing List >For list archives: http://lists.mysql.com/maxdb >To unsubscribe: >http://lists.mysql.com/maxdb?>[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
