From: Heinrich, Tilo (tilo.heinrichsap.com)
Date: Mon Jun 07 2004 - 11:39:03 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello Timo,

in most cases you are right, however, if log backups were created in parallel to the incremental backup log backups before LOGSAVE 10 could be needed. You can have a look into your backup history columns 8 and 9. They contain numbers (log page number or log IO sequence number) ordering the backups, as needed for restore. Column 8 contains for data backups (complete and incremental) the number representing the data contained in the backup. For log backups column 8 specifies the number for the first change contained in that log backup and column 9 specifies the number for the last change contained in that log backup.

So if you need to know, which log backup to start with after the incremental backup, search for the log backup whose two numbers from column 8 and 9 enclose the number from column 8 of your incremental backup.

Best Regards,
Tilo Heinrich
SAP Labs Berlin

>-----Original Message-----
>From: Timo Denis [mailto:timo.denisiee.lu]
>Sent: Thursday, June 03, 2004 1:41 PM
>To: maxdblists.mysql.com
>Subject: Re: Restore question
>
>
>Hi,
>
>This means, when I have the following backup parts
>
>/*
>FULLBACKUP
>LOGSAVE 1
>LOGSAVE 2
>LOGSAVE 3
>[...]
>LOGSAVE n
>INCRBACKUP
>LOGSAVE 10
>[...]
>LOGSAVE 19
>*/
>
>..., I need to restore: FULLBACKUP + INCRBACKUP + LOGSAVE 10 .. 19
>
>Regards, Timo
>
>
>Heinrich, Tilo wrote:
>> Hello Timo,
>>
>>
>>>But why does 'backup_history_list -r LAST' also report the log files
>>>between main backup and incremental backup, e.g.
>>
>>
>> because 'backup_history_list -r LAST' lists all backups
>starting at the last complete backup.
>>
>> Best Regards,
>> Tilo Heinrich
>> SAP Labs Berlin
>>
>>
>>>-----Original Message-----
>>>From: Timo Denis [mailto:timo.denisiee.lu]
>>>Sent: Thursday, June 03, 2004 11:31 AM
>>>To: maxdblists.mysql.com
>>>Subject: Restore question
>>>
>>>
>>>Hi,
>>>
>>>I've tried to restoer a database with a log files, e.g.
>>>
>>>/*
>>>db_admin
>>>util_connect
>>>util_execute INIT CONFIG
>>>medium_put data /space/data200405211800 file data
>>>medium_put logs /space/log file log
>>>recover_start data data
>>>recover_start logs log 012
>>>recover_replace logs /space/log.013
>>>[...]
>>>recover_replace logs /space/log.024
>>>db_online
>>>*/
>>>
>>>Now one of the log files [012] is brokken and knldiag reports
>>>
>>>/*
>>>last-redo-read#1929903:TR157019789(0)[161885214]-1.5184'Insert
>>
>> Record':20040526:144639
>>
>>>Log REDO: Aborted
>>>ERR 52608 RESTART LOCAL: failed
>>>ERR 63 Log RESTART ERROR '530' => SHUTDOWN IS FORCED
>>>ERR 11196 DBCRASH vabort:Emergency Shutdown, vkb811.cpp: 128
>>>*/
>>>
>>>We decided to do an incremental backup in order to restore the main
>>>backup file first and afterwards the incremental backup file. This
>>>procedure works fine, main backup file and incremental backup file
>>>reports returncode 0 and none left pages.
>>>
>>>But why does 'backup_history_list -r LAST' also report the log files
>>>between main backup and incremental backup, e.g.
>>>
>>>/*
>>>DAT_00102
>>>LOG_00012
>>>[...]
>>>LOG_00024
>>>PAG_00104
>>>
>>>Any hints?
>>>
>>>Kind 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?>unsub=tilo.heinrichsap.com
>>>
>>
>>
>
>--
>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?>unsub=tilo.heinrichsap.com
>

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]