RE: using archive_stage und archive_stage_repeat in scripts

Hello Frank,

So pipe2file gets killed, because "sapmnt/AAI/exe/backint" finished with =
an error. Somewhere below in dbm.ebl you should find the output of =
backint. Maybe that gives us a hint, why the backups fail.

Best regards,
Tilo Heinrich
Senior Developer
MaxDB&liveCache
SAP AG
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=20
Sent: Montag, 20. August 2007 18:49
To: [email protected]
Subject: Re: using archive_stage und archive_stage_repeat in scripts

Hello Tilo,

below a part of dbm.ebl=20
The period from start Pipe2file till kill pipe2file seems always about
60 sec.

best Regards

Frank


-------------------------------------------------------------------------=
--------------------------
    Constructed pipe2file call 'pipe2file -d file2pipe -f
/sapdb/ALI/saparch/LCLOG.719 -p /sapdb/ALI/saparch/BACKINT_LOG_PIPE
-nowait'.

    Starting pipe2file for stage file '/sapdb/ALI/saparch/LCLOG.719'.
        Starting pipe2file process 'pipe2file -d file2pipe -f
/sapdb/ALI/saparch/LCLOG.719 -p /sapdb/ALI/saparch/BACKINT_LOG_PIPE
-nowait >>/tmp/temp1187627401-0 2>>/tmp/temp1187627401-1'.
        Process was started successfully.
    Pipe2file has been started successfully.

    Starting Backint for MaxDB.
        Starting Backint for MaxDB process '/sapmnt/AAI/exe/backint -u
ALI -f backup -t file -p /sapdb/ALI/sapbackup/backint/initALI.utl -i
/sapdb/ALI/sapbackup/backint/backint.inp -c
>>/sapdb/ALI/sapbackup/backint/backint.out
2>>/sapdb/ALI/sapbackup/backint/backint.err'.
        Process was started successfully.
    Backint for MaxDB has been started successfully.

    Waiting for end of the backup operation.
        2007-08-20 18:30:01 The backup tool is running.
        2007-08-20 18:30:01 Pipe2file is running.

        2007-08-20 18:30:02 The backup tool process has finished work
with return code 2.

        2007-08-20 18:30:06 Pipe2file is running.

        2007-08-20 18:30:16 Pipe2file is running.

        2007-08-20 18:30:31 Pipe2file is running.

        2007-08-20 18:30:51 Pipe2file is running.

        Killing not reacting pipe2file process.
        Pipe2file killed successfully.

        2007-08-20 18:31:03 The pipe2file process has finished work
with return code -1.
    The backup operation has ended.
-------------------------------------------------------------------------=
-----------------------------


On Mon, 20 Aug 2007 17:13:54 +0200, [email protected] ("Heinrich,
Tilo") wrote:

>Hello Frank,
>
>I do not remember pipe2file having any timeout. What do you see exactly =
in dbm.ebl?
>
>Best regards,
>Tilo
>
>Tilo Heinrich
>Senior Developer
>MaxDB&liveCache
>SAP AG
>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=20
>Sent: Freitag, 17. August 2007 18:18
>To: [email protected]
>Subject: Re: using archive_stage und archive_stage_repeat in scripts
>
>Hello Tilo,
>
>As I see in dbm.ebl or *.ssa it seems that the pipe2file-cmd timed
>out. This happens only one or two times a day likely because highload
>of the backup-Server.
>
>Is there any way to avoid this situation or change the timeout-value
>for the pipe2file-cmd
>
>Best Regards Uwe
>
>
>On Fri, 27 Jul 2007 18:00:31 +0200, [email protected] ("Heinrich,
>Tilo") wrote:
>
>>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
>>
>>
>>


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]