Hello Tilo,
I have another question regarding backup.
if I do a logbackup in the following way, I get an error if no
log-pages available for backup. How can I avoid an Error-Message.
Skript:
--------
dbmcli -d $SID -u control,control autolog_off
dbmcli -d $SID -u control,control -uUTL -c backup_start $LOG_MEDIUM
LOG
dbmcli -d $SID -u control,control autolog_on $LOG_MEDIUM
Error:
--------
ERR
-24988,ERR_SQL: sql error
-123,No more log to save
best regards Frank
On Mon, 11 Jun 2007 13:44:41 +0200, [EMAIL PROTECTED] ("Heinrich,
Tilo") wrote:
>Hello Frank,
>
>Of course you are right, the second archive_stage should have been an
>archive_stage_repeat.
>
>Best regards,
>Tilo Heinrich
>Senior Developer
>MaxDB&liveCache
>SAP AG
>http://www.sap.com <http://www.sap.com/>
>
>Sitz der Gesellschaft/Registered Office: Walldorf, Germany
>Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Shai Agassi,
>Léo Apotheker, Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke
>Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso
>Plattner
>Registergericht/Commercial Register Mannheim No HRB 350269
>
>Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige
>vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich
>erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine
>Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte
>benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank.
>
>This e-mail may contain trade secrets or privileged, undisclosed, or otherwise
>confidential information. If you 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.
>Thank you for your cooperation.
>
>
>-----Original Message-----
>From: Frank
>Sent: Freitag, 8. Juni 2007 22:36
>To: maxdb@lists.mysql.com
>Subject: Re: using archive_stage und archive_stage_repeat in scripts
>
>Hi Tilo,
>
>thanks for the support. Just for my information: Shouldn't be the
>second archive_stage-call a archive_stage_repeat. Maybe I missed
>something.
>
>Thanks in advance.
>Frank
>
>
>On Tue, 5 Jun 2007 13:48:53 +0200, [EMAIL PROTECTED] ("Heinrich,
>Tilo") wrote:
>
>>Hello Frank,
>>
>>You can A) write the archive_stage command and the archive_stage_repeat
>>command to an input file for the dbmcli call ("dbmcli ... <inputfile") or use
>>the inline input data facility of your shell:
>>
>>dbmcli -u control,control -d $SID -uUTL -c <<EOF
>>archive_stage $ARCHIVE_MEDIUM $LOG_MEDIUM NOVERIFY KEEP
>>archive_stage $ARCHIVE_MEDIUM2 $LOG_MEDIUM VERIFY
>>EOF
>>
>>Best regards,
>>Tilo Heinrich
>>Senior Developer
>>MaxDB&liveCache
>>SAP AG
>>http://www.sap.com <http://www.sap.com/>
>>
>>Sitz der Gesellschaft/Registered Office: Walldorf, Germany
>>Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Shai Agassi,
>>Léo Apotheker, Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke
>>Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board:
>>Hasso Plattner
>>Registergericht/Commercial Register Mannheim No HRB 350269
>>
>>Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige
>>vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich
>>erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine
>>Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte
>>benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank.
>>
>>This e-mail may contain trade secrets or privileged, undisclosed, or
>>otherwise confidential information. If you 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. Thank you for your cooperation.
>>
>>-----Original Message-----
>>From: Frank
>>Sent: Freitag, 1. Juni 2007 14:34
>>To: maxdb@lists.mysql.com
>>Subject: using archive_stage und archive_stage_repeat in scripts
>>
>>Hallo,
>>
>>regarding maxdb-documentation I have to use archive_stage und
>>archive_stage_repeat in one utility-session.
>>
>> In addition to that we want to use environmentvariables in the
>>archivingscript.
>>Our script looks like:
>>
>>#/bin/sh
>>export SID=ALT
>>export LOG_MEDIUM=$SID'_LOG'
>>export ARCHIVE_MEDIUM=BACKUP_LOG_PIPE
>>
>>dbmcli -u control,control -d $SID -uUTL -c archive_stage
>>$ARCHIVE_MEDIUM $LOG_MEDIUM NOVERIFY KEEP
>>
>>How can I add the archive_stage_repeat-step in the script and make
>>shure both steps run in the same utility-session
>>
>>with Regards Frank
>>
>>
>>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
