RE: using archive_stage und archive_stage_repeat in scripts

------_=_NextPart_001_01C7D067.42C65E58
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello Frank,

One option would be to put the archive_stage* commands into an =
additional file and use the '-i <input_file>' option of dbmcli. In this =
case dbmcli would not execute the archive_stage_repeat, if the =
archive_stage had already failed (at least, this is stated by =
http://maxdb.sap.com/currentdoc/84/5b0282467f11d4aa1100a0c9430730/framese=
t.htm =
<http://maxdb.sap.com/currentdoc/84/5b0282467f11d4aa1100a0c9430730/frames=
et.htm> ).

Best regards,
Tilo

Tilo Heinrich
Senior Developer
MaxDB&liveCache
SAP AG
http://www.sap.com <http://www.sap.com/>=20

Sitz der Gesellschaft/Registered Office: Walldorf, Germany
Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), L=E9o =
Apotheker (stellvertretender Sprecher/Deputy CEO), Werner Brandt, Claus =
Heinrich, Gerhard Oswald, Peter Zencke
Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: =
Hasso Plattner=20
Registergericht/Commercial Register Mannheim No HRB 350269

Diese E-Mail kann Betriebs- oder Gesch=E4ftsgeheimnisse oder sonstige =
vertrauliche Informationen enthalten. Sollten Sie diese E-Mail =
irrt=FCmlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, =
eine Vervielf=E4ltigung oder Weitergabe der E-Mail ausdr=FCcklich =
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, 27. Juli 2007 14:12
To: [email protected]
Subject: Re: using archive_stage und archive_stage_repeat in scripts

Helle Tilo,

sorry that I didn't explain the error-situation.

if the backup-infrastructure (tape_changer,robots, Mediaserver etc)
has to work on a  high load the responsetime of the external backup
program is higher then the TIMEOUT...-Parameter in bsi.env
So the first archive_step fails
Now the second archive_step can run ok and we have only 1 copy of the
logfile.

I increased the TIMEOUT...-Parameter in bsi.env to 300 sec. Now we
have nearly no errors.

The last error seems not covered from the timeout-Parameter because
" The pipe2file process has finished work with return
code -1."  after 1 min 03 sec

I will send you the dbm.ebl.

Best Regards
Frank



On Wed, 25 Jul 2007 14:51:08 +0200, [email protected] ("Heinrich,
Tilo") wrote:

>Hello Frank,
>
>Does log file dbm.ebl contain any information about such an error =
situation, if so can you please send the log file dbm.ebl to the mailing =
list or to me?
>
>Best regards,
>Tilo
>
>Tilo Heinrich
>Senior Developer
>MaxDB&liveCache
>SAP AG
>http://www.sap.com <http://www.sap.com>  <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=E9o 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=E4ftsgeheimnisse oder sonstige =
vertrauliche Informationen enthalten. Sollten Sie diese E-Mail =
irrt=FCmlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, =
eine Vervielf=E4ltigung oder Weitergabe der E-Mail ausdr=FCcklich =
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: Dienstag, 24. Juli 2007 19:17
>To: [email protected]
>Subject: Re: using archive_stage und archive_stage_repeat in scripts
>
>Hello Tilo,
>
>I use the following skript for archiving (thanks for your support)
>
>dbmcli -u control,control -d $SID -uUTL -c <<EOF
>(step-1) archive_stage $ARCHIVE_MEDIUM $LOG_MEDIUM NOVERIFY KEEP
>(step-2) archive_stage_repeat $ARCHIVE_MEDIUM2 $LOG_MEDIUM VERIFY
>EOF
>
>If step_1 fails and step_2 succeed I get only 1 backup  and afterwards
>the log wil be deleted.
>
>Is there any possibility to avoid this situation?
>
>best regards Frank





------_=_NextPart_001_01C7D067.42C65E58--