on 12-23-2009 10:05 AM
Hello,
I have installed MaxDB 7.7 on Windows Server 2008 and want to backup it with Backint for Oracle.
My Problem is that I can't do a backup because -903, Host file I/O error. But this isn't the problem. The problem looks into the pipe2file program.
Has someone an idea who is my problem?
Here you find the Logfile dbm.ebp:
2009-12-23 10:41:48
Using environment variable 'TEMP' with value 'C:\Windows\TEMP' as directory for temporary files and pipes.
Using connection to Backint for MaxDB Interface.
2009-12-23 10:41:48
Checking existence and configuration of Backint for MaxDB.
Using configuration variable 'BSI_ENV' = 'I:\sapdb\data\wrk\SD1\bsi.env' as path of the configuration file of Backint for MaxDB.
Setting environment variable 'BSI_ENV' for the path of the configuration file of Backint for MaxDB to configuration value 'I:\sapdb\data\wrk\SD1\bsi.env'.
Reading the Backint for MaxDB configuration file 'I:\sapdb\data\wrk\SD1\bsi.env'.
Found keyword 'BACKINT' with value 'F:\sapdb\SD1\db\bin\backint.exe'.
Found keyword 'INPUT' with value 'F:\sapdb\temp\backint4MAXDB.in'.
Found keyword 'OUTPUT' with value 'F:\sapdb\temp\backint4MAXDB.out'.
Found keyword 'ERROROUTPUT' with value 'F:\sapdb\temp\backint4MAXDB.err'.
Found keyword 'PARAMETERFILE' with value 'I:\sapdb\data\wrk\SD1\backintmaxdbconfig.par'.
Found keyword 'TIMEOUT_SUCCESS' with value '600'.
Found keyword 'TIMEOUT_FAILURE' with value '400'.
Finished reading of the Backint for MaxDB configuration file.
Using 'F:\sapdb\SD1\db\bin\backint.exe' as Backint for MaxDB program.
Using 'F:\sapdb\temp\backint4MAXDB.in' as input file for Backint for MaxDB.
Using 'F:\sapdb\temp\backint4MAXDB.out' as output file for Backint for MaxDB.
Using 'F:\sapdb\temp\backint4MAXDB.err' as error output file for Backint for MaxDB.
Using 'I:\sapdb\data\wrk\SD1\backintmaxdbconfig.par' as parameter file for Backint for MaxDB.
Using '600' seconds as timeout for Backint for MaxDB in the case of success.
Using '400' seconds as timeout for Backint for MaxDB in the case of failure.
Using 'I:\sapdb\data\wrk\SD1\dbm.knl' as backup history of a database to migrate.
Using 'I:\sapdb\data\wrk\SD1\dbm.ebf' as external backup history of a database to migrate.
Checking availability of backups using backint's inquire function.
Check passed successful.
2009-12-23 10:41:48
Checking medium.
Check passed successfully.
2009-12-23 10:41:48
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 MaxDB call 'F:\sapdb\SD1\db\bin\backint.exe -u SD1 -f backup -t file -p I:\sapdb\data\wrk\SD1\backintmaxdbconfig.par -i F:\sapdb\temp\backint4MAXDB.in -c'.
Created temporary file 'F:\sapdb\temp\backint4MAXDB.out' as output for Backint for MaxDB.
Created temporary file 'F:\sapdb\temp\backint4MAXDB.err' as error output for Backint for MaxDB.
Writing 'F:\sapdb\temp\oraback1.tmp #PIPE' to the input file.
Prepare passed successfully.
2009-12-23 10:41:48
Starting database action for the backup.
Requesting 'SAVE DATA QUICK TO 'F:\sapdb\temp\oraback1.tmp' PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'ORABACK1'' from db-kernel.
The database is working on the request.
2009-12-23 10:41:48
Waiting until database has prepared the backup.
Asking for state of database.
2009-12-23 10:41:48 Database is still preparing the backup.
Waiting 1 second ... Done.
Asking for state of database.
2009-12-23 10:41:49 Database has finished preparation of the backup.
The database has prepared the backup successfully.
2009-12-23 10:41:49
Starting Backint for MaxDB.
Starting Backint for MaxDB process 'F:\sapdb\SD1\db\bin\backint.exe -u SD1 -f backup -t file -p I:\sapdb\data\wrk\SD1\backintmaxdbconfig.par -i F:\sapdb\temp\backint4MAXDB.in -c >>F:\sapdb\temp\backint4MAXDB.out 2>>F:\sapdb\temp\backint4MAXDB.err'.
Process was started successfully.
Backint for MaxDB has been started successfully.
2009-12-23 10:41:49
Waiting for end of the backup operation.
2009-12-23 10:41:49 The backup tool is running.
2009-12-23 10:41:49 The database is working on the request.
2009-12-23 10:41:50 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
2009-12-23 10:41:50 The backup tool is running.
2009-12-23 10:41:54 The backup tool is running.
2009-12-23 10:42:04 The backup tool is running.
2009-12-23 10:42:19 The backup tool is running.
2009-12-23 10:42:20 The backup tool process has finished work with return code 0.
The backup operation has ended.
2009-12-23 10:42:20
Filling reply buffer.
Have encountered error -24920:
The database was unable to fulfill a request (-903, Host file I/O error).
Constructed the following reply:
ERR
-24920,ERR_BACKUPOP: backup operation was unsuccessful
The database was unable to fulfill a request (-903, Host file I/O error).
Reply buffer filled.
2009-12-23 10:42:20
Cleaning up.
Copying output of Backint for MaxDB to this file.
-
Begin of output of Backint for MaxDB (F:\sapdb\temp\backint4MAXDB.out)----
Reading parameter file I:\sapdb\data\wrk\SD1\backintmaxdbconfig.par.
Using staging area F:\sapdb\temp\maxdb2ora1.tmp with a size of 104857600 bytes.
Using 20 file per Backint for Oracle call.
Using C:\Program Files\Atempo\tina\Bin\backint.exe as Backint for Oracle.
Using I:\sapdb\data\wrk\SD1\backintoraconfig.utl as parameterfile of Backint for Oracle.
Using I:\sapdb\data\wrk\SD1\BackintHistory as history file.
Using F:\sapdb\temp\backint4Oracle.in as input of Backint for Oracle.
Using F:\sapdb\temp\backint4Oracle.out as output of Backint for Oracle.
Using F:\sapdb\temp\backint4Oracle.err as error output of Backint for Oracle.
Using a maximal delay for a Backint for Oracle call of 60 seconds.
Using BRBACKUP as value for environment variable BI_CALLER.
Reading input file F:\sapdb\temp\backint4MAXDB.in.
Backing up pipe F:\sapdb\temp\oraback1.tmp.
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 2009-12-23 10:41:51.
Calling 'C:\Program Files\Atempo\tina\Bin\backint.exe -u SD1 -f backup -t file -p I:\sapdb\data\wrk\SD1\backintoraconfig.utl -i F:\sapdb\temp\backint4Oracle.in -c' .
Backint for Oracle ended at 2009-12-23 10:42:06 with return code 0.
Backint for Oracle output: Starting Time Navigator Enterprise Edition backint - version 1.1
Backint for Oracle output: Catalog : catbb01
Backint for Oracle output: Folder for BRBACKUP : ssd111
Backint for Oracle output: Folder for BRARCHIVE : ssd111
Backint for Oracle output: Date begin : Wed Dec 23 10:41:53 2009
Backint for Oracle output: Request mode : backup
Backint for Oracle output: Backup mode : off-line
Backint for Oracle output: Number of files : 1
Backint for Oracle output: Parallelism : 1
Backint for Oracle output: #SAVED S200912231041___ F:\sapdb\temp\maxdb2ora1.tmp.0
Backint for Oracle output: Date end : Wed Dec 23 10:42:06 2009
Backint for Oracle output: Total duration : 00h00:13
Backint for Oracle output: Files processed : 1
Backint for Oracle output: Time Navigator Enterprise Edition backint - end of process
Backint for Oracle output:
Backint for Oracle error output:
Waiting for creation of temporary files.
0 temporary files are available for backup.
Backing up history file.
Calling Backint for Oracle at 2009-12-23 10:42:07.
Calling 'C:\Program Files\Atempo\tina\Bin\backint.exe -u SD1 -f backup -t file -p I:\sapdb\data\wrk\SD1\backintoraconfig.utl -i F:\sapdb\temp\backint4Oracle.in -c' .
Backint for Oracle ended at 2009-12-23 10:42:19 with return code 0.
Backint for Oracle output: Starting Time Navigator Enterprise Edition backint - version 1.1
Backint for Oracle output: Catalog : catbb01
Backint for Oracle output: Folder for BRBACKUP : ssd111
Backint for Oracle output: Folder for BRARCHIVE : ssd111
Backint for Oracle output: Date begin : Wed Dec 23 10:42:08 2009
Backint for Oracle output: Request mode : backup
Backint for Oracle output: Backup mode : off-line
Backint for Oracle output: Number of files : 1
Backint for Oracle output: Parallelism : 1
Backint for Oracle output: #SAVED S200912231042___ I:\sapdb\data\wrk\SD1\BackintHistory
Backint for Oracle output: Date end : Wed Dec 23 10:42:19 2009
Backint for Oracle output: Total duration : 00h00:11
Backint for Oracle output: Files processed : 1
Backint for Oracle output: Time Navigator Enterprise Edition backint - end of process
Backint for Oracle output:
Backint for Oracle error output:
Finished the backup successfully.
#SAVED S200912231041___ F:\sapdb\temp\oraback1.tmp 65536
-
End of output of Backint for MaxDB (F:\sapdb\temp\backint4MAXDB.out)----
Removed Backint for MaxDB's temporary output file 'F:\sapdb\temp\backint4MAXDB.out'.
Copying error output of Backint for MaxDB to this file.
-
Begin of error output of Backint for MaxDB (F:\sapdb\temp\backint4MAXDB.err)----
-
End of error output of Backint for MaxDB (F:\sapdb\temp\backint4MAXDB.err)----
Removed Backint for MaxDB's temporary error output file 'F:\sapdb\temp\backint4MAXDB.err'.
Removed the Backint for MaxDB input file 'F:\sapdb\temp\backint4MAXDB.in'.
Have finished clean up successfully.
Kind regards
Carlos
> I have installed MaxDB 7.7 on Windows Server 2008 and want to backup it with Backint for Oracle.
> My Problem is that I can't do a backup because -903, Host file I/O error. But this isn't the problem. The problem looks into the pipe2file program.
Hi there,
if you're a SAP customer, opening a support message would make life much easier, since we then could at least read the log files properly...
Anyhow, the problem here is that you try to make a backup to pipe into a file :
> 2009-12-23 10:41:48
> Starting database action for the backup.
> Requesting 'SAVE DATA QUICK TO 'F:\sapdb\temp\oraback1.tmp' PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'ORABACK1'' from db-kernel.
> The database is working on the request.
>
'F:\sapdb\temp\oraback1.tmp' cannot be a pipe on Windows!
You need to create a backup medium with type BACK to correctly use the backint adapter.
E.g. like this
backup_media_put "ORABACK1" "\\.\pipe\ORABACK1" PIPE DATA 0 0 NO NO "" BACK
Please check the documentation [Connecting to a Backint for Oracle Interface|http://maxdb.sap.com/doc/7_7/45/746a5712e14022e10000000a1553f6/content.htm] on that.
regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.