Hello Alex,
as one can see after "---------- Begin of output of Backint for SAP DB (C:\lab...",
the Backint for SAP DB program (C:\lab\sapdb\depend\bin\backint.exe) has read data
from backup pipe \\.\pipe\INST1 <file://\\.\pipe\INST1> and after creating one
temporary file (most probably C:\lab\sapdb\indep_data\wrk\INST1\backup\stage\STAGE1.0
of size 64 byte), has called Backint for Oracle
(C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_OB\backint.cmd) to backup that
temporary file.
Backint for Oracle answered with the single line:
C:\LAB\SAPDB\DEPEND>C:\perl\bin\perl.exe
C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_OB\wrapper.pl
That is not exactly a answer for a successful backup run of Backint for Oracle.
Backint for SAP DB therefore thinks, that the first temporary file was not backed up
successfully and concludes, that there is no need to create and backup other temporary
files, as the backup of the database can only be complete, if all temporary files were
backed up successfully by Backint for Oracle. It therefore ends with an error for the
pipe backup ("#ERROR \\.\pipe\INST1 <file://\\.\pipe\INST1> ").
Best Regards,
Tilo Heinrich
SAP Labs Berlin
-----Original Message-----
From: Rodriguez, Alex (SGBU - MIAMI) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 13, 2004 9:05 PM
To: [EMAIL PROTECTED]
Cc: Rodriguez, Alex (SGBU - MIAMI)
Subject: SAPDB 7.4.3 - HP Data Protector 5.1
Hello There,
We are trying to configure the backup/restore utility backint using HP Data Protector
and
we are getting an error related to the pipe we have created.
Here is the command we are running :
> backup_start BACK_INST1_SAPDB DATA
or
> backup_start BACK_INST1_SAPDB
The dbm.edp file shows :
======= Starts =========
2004-10-13 14:44:12
Using environment variable 'TEMP' with value 'C:\DOCUME~1\ALRODR3\LOCALS~1\Temp' as
directory for temporary files and pipes.
Using connection to Backint for SAP DB Interface.
2004-10-13 14:44:13
Checking existence and configuration of Backint for SAP DB.
Using configuration variable 'BSI_ENV' =
'C:\lab\sapdb\indep_data\wrk\INST1\backup\bsi.env' as path of the configuration file
of Backint for SAP DB.
Reading the Backint for SAP DB configuration file
'C:\lab\sapdb\indep_data\wrk\INST1\backup\bsi.env'.
Found keyword 'BACKINT' with value 'C:\lab\sapdb\depend\bin\backint.exe'.
Found keyword 'INPUT' with value
'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.in'.
Found keyword 'OUTPUT' with value
'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.out'.
Found keyword 'ERROROUTPUT' with value
'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.err'.
Found keyword 'PARAMETERFILE' with value
'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_OB\SecondConf.txt'.
Found keyword 'TIMEOUT_SUCCESS' with value '600'.
Found keyword 'TIMEOUT_FAILURE' with value '300'.
Found keyword 'ORIGINAL_RUNDIRECTORY' with value
'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\P1'.
Finished reading of the Backint for SAP DB configuration file.
Using 'C:\lab\sapdb\depend\bin\backint.exe' as Backint for SAP DB program.
Using 'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.in' as
input file for Backint for SAP DB.
Using 'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.out' as
output file for Backint for SAP DB.
Using 'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.err' as
error output file for Backint for SAP DB.
Using 'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_OB\SecondConf.txt' as
parameter file for Backint for SAP DB.
Using '600' seconds as timeout for Backint for SAP DB in the case of success.
Using '300' seconds as timeout for Backint for SAP DB in the case of failure.
Using 'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\P1\dbm.knl' as backup
history of a database to migrate.
Using 'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\P1\dbm.ebf' as external
backup history of a database to migrate.
Check passed successful.
2004-10-13 14:44:13
Checking medium.
Check passed successfully.
2004-10-13 14:44:13
Preparing backup.
Setting environment variable 'BI_CALLER' to value 'DBMSRV'.
Setting environment variable 'BI_REQUEST' to value 'NEW'.
Setting environment variable 'BI_BACKUP' to value 'FULL'.
Constructed Backint for SAP DB call 'C:\lab\sapdb\depend\bin\backint.exe -u INST1 -f
backup -t file -p C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_OB\SecondConf.txt
-i C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.in -c'.
Created temporary file
'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.out' as output
for Backint for SAP DB.
Created temporary file
'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.err' as error
output for Backint for SAP DB.
Writing '\\.\pipe\INST1 #PIPE' to the input file.
Prepare passed successfully.
2004-10-13 14:44:13
Starting database action for the backup.
Requesting 'SAVE DATA QUICK TO '\\.\pipe\INST1' PIPE NO CHECKPOINT MEDIANAME
'BACK_INST1_SAPDB'' from db-kernel.
The database is working on the request.
2004-10-13 14:44:13
Waiting until database has prepared the backup.
2004-10-13 14:44:13 The database is working on the request.
Waiting 1 second ... Done.
Asking for state of database.
Got the following reply from db-kernel:
SQL-Code :0
Date :20041013
Time :00144413
Database :INST1
Server :rodriguezalej4
KernelVersion :Kernel 7.4.3 Build 032-123-068-842
PagesTransfered :0
PagesLeft :0
DevicesUsed :1
DatabaseID :rodriguezalej4:INST1_20041013_144413
Max Used Data Page :0
Redo Transactions Read:0
Redo Transactions Done:0
2004-10-13 14:44:14 The database is working on the request.
The database has prepared the backup successfully.
2004-10-13 14:44:14
Starting Backint for SAP DB.
Starting Backint for SAP DB process 'C:\lab\sapdb\depend\bin\backint.exe -u INST1 -f
backup -t file -p C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_OB\SecondConf.txt
-i C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.in -c
>>C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.out
2>>C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.err'.
Process was started successfully.
Backint for SAP DB has been started successfully.
2004-10-13 14:44:14
Waiting for end of the backup operation.
2004-10-13 14:44:14 The backup tool is running.
2004-10-13 14:44:14 The database is working on the request.
2004-10-13 14:44:16 The backup tool process has finished work with return code 2.
2004-10-13 14:44:16 The database has finished work on the request.
Receiving a reply from the database kernel.
Got the following reply from db-kernel:
SQL-Code :-903
The backup operation has ended.
2004-10-13 14:44:16
Filling reply buffer.
Have encountered error -24920:
The backup tool failed with 2 as sum of exit codes. The database request failed with
error -903.
Constructed the following reply:
ERR
-24920,ERR_BACKUPOP: backup operation was unsuccessful
The backup tool failed with 2 as sum of exit codes. The database request failed with
error -903.
Reply buffer filled.
2004-10-13 14:44:16
Cleaning up.
Copying output of Backint for SAP DB to this file.
---------- Begin of output of Backint for SAP DB
(C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.out)----------
Reading parameter file
C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_OB\SecondConf.txt.
Using staging area C:\lab\sapdb\indep_data\wrk\INST1\backup\stage\STAGE1 of size 64.
Using 1 file per Backint for Oracle call.
Using C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_OB\backint.cmd as Backint for
Oracle.
Using C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backintparam.utl as
parameterfile of Backint for Oracle.
Using C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_OB\BackintHistory as history
file.
Using C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_OB\backint4Oracle.in as input
of Backint for Oracle.
Using C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_OB\backint4Oracle.out as output
of Backint for Oracle.
Using C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_OB\backint4Oracle.err as error
output of Backint for Oracle.
Using a maximal delay for a Backint for Oracle call of 60 seconds.
Reading input file
C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.in.
Backing up pipe \\.\pipe\INST1.
Found 1 entry in the input file.
Starting the backup.
Starting pipe2file program(s).
Waiting for creation of temporary files.
1 temporary file is available for backup.
Calling Backint for Oracle at 2004-10-13 14:44:15.
Backint for Oracle has ended at 2004-10-13 14:44:15.
Backint for Oracle output:
Backint for Oracle output: C:\LAB\SAPDB\DEPEND>C:\perl\bin\perl.exe
C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_OB\wrapper.pl
Backint for Oracle output:
Backint for Oracle error output:
Finished the backup unsuccessfully.
#ERROR \\.\pipe\INST1
---------- End of output of Backint for SAP DB
(C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.out)----------
Removed Backint for SAP DB's temporary output file
'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.out'.
Copying error output of Backint for SAP DB to this file.
---------- Begin of error output of Backint for SAP DB
(C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.err)----------
Backint for Oracle has not processed all files as requested.
Could not write history file.
---------- End of error output of Backint for SAP DB
(C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.err)----------
Removed Backint for SAP DB's temporary error output file
'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.err'.
Removed the Backint for SAP DB input file
'C:\lab\sapdb\indep_data\wrk\INST1\backup\backint_SAPDB\backint4SAPDB.in'.
Have finished clean up successfully.
========== ENDS =========
Right between the error message and the "database is working on requested",
an Application error is stored in the Event Viewer.
Event Type: Error
Event Source: SAPDB:Inst1
Event Category: Fast
Event ID: 18206
Date: 10/13/2004
Time: 2:44:15 PM
User: AMERICAS\alrodr3
Computer: RODRIGUEZALEJ4
Description:
SAPDB - Inst1 :
- ERROR TID: 0xAB0 PID: 0xB78 MsgID: 18206
Could not write to '\\.\pipe\INST1', rc = 232
=======================
We have already checked all the configuration files requested by HP Data Protector and
ASPDB, we also created a Backup Medium called "BACK_INST1_SAPDB", Device Type
PIPE, Backup type "Complete DATA" and Location \\.\pipe\INST1 <file://\\.\pipe\INST1> .
Something is telling us that the location is not right.
Do you know what should be the correct value?
Best regards,
Alex Rodriguez
Senior Engineer
HP OpenView DP/OBII
Alex Rodriguez
SGBU Support & Services
<http://www.hp.com/> OpenView LAR
Hewlett-Packard Co.
5200 Blue Lagoon Dr. Suite 950
Miami, FL 33126
Email <mailto:[EMAIL PROTECTED]>
[EMAIL PROTECTED]
Team web:
http://www.openview.hp.com/ <http://www.openview.hp.com/>
Voice Mail Net
Telephone
Fax
1742-265-6030
305-267-4050
305-267-4073
_____
