cancel
Showing results for 
Search instead for 
Did you mean: 

Backup MaxDB 7.7 with BackInt for Oracle

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
0 Kudos

> 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

Former Member
0 Kudos

Dear Lars,

Thank you very much for the solution!

My problem was, that the pipe configuration isn't good documented. I haven't founf the
.\pipe\<Name> entry.

Regards

Carlos

Answers (0)