MySQL Forums
Forum List  »  MaxDB

Veriyas Netbackup Backint for Oracle out put: ERROR: incorrect format or option in .utl file (-p)
Posted by: Raymond De Bie
Date: July 16, 2007 12:48PM

Hello

Configuring netbackup for SAP on maxdb on windows 2003 SP1.
We get the following errors and we have no clue where to look at anymore.
Does anyone have some tips?

here are the log and configuration files.
dbm.prt:
2007-07-16 15:43:55 0x00000ccc INF 283 DBMSrv command backup_start BACKTBP DATA
2007-07-16 15:45:01 0x00000ccc ERR -24920 DBMSrv ERR_BACKUPOP: backup operation was unsuccessful
0x00000ccc ERR -24778 DBMSrv The backup tool failed with 2 as sum of exit codes. The database request failed with error -8020.

dbm.ebp:
2007-07-16 16:08:32
Using environment variable 'TEMP' with value 'C:\DOCUME~1\SRVCNBU\LOCALS~1\Temp\3' as directory for temporary files and pipes.
Using connection to Backint for MaxDB Interface.

2007-07-16 16:08:32
Checking existence and configuration of Backint for MaxDB.
Using configuration variable 'BSI_ENV' = 'F:\sapdb\data\wrk\TBP\bsi.env' as path of the configuration file of Backint for MaxDB.
Reading the Backint for MaxDB configuration file 'F:\sapdb\data\wrk\TBP\bsi.env'.
Found keyword 'BACKINT' with value 'D:\sapdb\TBP\db\bin\backint.exe'.
Found keyword 'INPUT' with value 'D:\sapdb\Logs\backint.in'.
Found keyword 'OUTPUT' with value 'D:\sapdb\Logs\backint.out'.
Found keyword 'ERROROUTPUT' with value 'D:\sapdb\Logs\backint.err'.
Found keyword 'PARAMETERFILE' with value 'F:\sapdb\data\wrk\TBP\backint_parameter.txt'.
Found keyword 'ORIGINAL_RUNDIRECTORY' with value 'F:\sapdb\data\wrk\TBP'.
Found keyword 'TIMEOUT_SUCCESS' with value '600'.
Found keyword 'TIMEOUT_FAILURE' with value '300'.
Finished reading of the Backint for MaxDB configuration file.

Using 'D:\sapdb\TBP\db\bin\backint.exe' as Backint for MaxDB program.
Using 'D:\sapdb\Logs\backint.in' as input file for Backint for MaxDB.
Using 'D:\sapdb\Logs\backint.out' as output file for Backint for MaxDB.
Using 'D:\sapdb\Logs\backint.err' as error output file for Backint for MaxDB.
Using 'F:\sapdb\data\wrk\TBP\backint_parameter.txt' as parameter file for Backint for MaxDB.
Using '600' seconds as timeout for Backint for MaxDB in the case of success.
Using '300' seconds as timeout for Backint for MaxDB in the case of failure.
Using 'F:\sapdb\data\wrk\TBP\dbm.knl' as backup history of a database to migrate.
Using 'F:\sapdb\data\wrk\TBP\dbm.ebf' as external backup history of a database to migrate.
Checking availability of backups using backint's inquire function.
Check passed successful.

2007-07-16 16:08:32
Checking medium.
Check passed successfully.

2007-07-16 16:08:32
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 'D:\sapdb\TBP\db\bin\backint.exe -u TBP -f backup -t file -p F:\sapdb\data\wrk\TBP\backint_parameter.txt -i D:\sapdb\Logs\backint.in -c'.
Created temporary file 'D:\sapdb\Logs\backint.out' as output for Backint for MaxDB.
Created temporary file 'D:\sapdb\Logs\backint.err' as error output for Backint for MaxDB.
Writing '\\.\pipe\TBP #PIPE' to the input file.
Prepare passed successfully.

2007-07-16 16:08:32
Starting database action for the backup.
Requesting 'SAVE DATA QUICK TO '\\.\pipe\TBP' PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'BACKTBP'' from db-kernel.
The database is working on the request.

2007-07-16 16:08:32
Waiting until database has prepared the backup.
Asking for state of database.
2007-07-16 16:08:33 Database is still preparing the backup.
Waiting 1 second ... Done.
Asking for state of database.
2007-07-16 16:08:34 Database has finished preparation of the backup.
The database has prepared the backup successfully.

2007-07-16 16:08:34
Starting Backint for MaxDB.
Starting Backint for MaxDB process 'D:\sapdb\TBP\db\bin\backint.exe -u TBP -f backup -t file -p F:\sapdb\data\wrk\TBP\backint_parameter.txt -i D:\sapdb\Logs\backint.in -c >>D:\sapdb\Logs\backint.out 2>>D:\sapdb\Logs\backint.err'.
Process was started successfully.
Backint for MaxDB has been started successfully.

2007-07-16 16:08:34
Waiting for end of the backup operation.
2007-07-16 16:08:34 The backup tool is running.
2007-07-16 16:08:34 The database is working on the request.

2007-07-16 16:08:39 The backup tool is running.
2007-07-16 16:08:39 The database is working on the request.

2007-07-16 16:08:49 The backup tool is running.
2007-07-16 16:08:49 The database is working on the request.

2007-07-16 16:09:04 The backup tool is running.
2007-07-16 16:09:04 The database is working on the request.

2007-07-16 16:09:24 The backup tool is running.
2007-07-16 16:09:24 The database is working on the request.

2007-07-16 16:09:37 The backup tool process has finished work with return code 2.
2007-07-16 16:09:37 The database has finished work on the request.
Receiving a reply from the database kernel.
Got the following reply from db-kernel:
SQL-Code :-8020
Date :20070716
Time :00160833
Database :TBP
Server :sap002.domus.local
KernelVersion :Kernel 7.6.01 Build 015-121-147-649
PagesTransfered :131072
PagesLeft :3361555
MediaName :BACKTBP
Location :\\.\pipe\TBP
Errortext :end of file [109]
Label :DAT_000000190
IsConsistent :true
FirstLogPageNo :824893
DBStamp1Date :20070716
DBStamp1Time :00160832
BDPageCount :3492603
DevicesUsed :1
DatabaseID :sap002.domus.local:TBP_20070716_160833
Max Used Data Page :0
Converter Page Count :1886
The backup operation has ended.

2007-07-16 16:09:37
Filling reply buffer.
Have encountered error -24920:
The backup tool failed with 2 as sum of exit codes. The database request failed with error -8020.

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 -8020.
Reply buffer filled.

2007-07-16 16:09:37
Cleaning up.
Copying output of Backint for MaxDB to this file.
---------- Begin of output of Backint for MaxDB (D:\sapdb\Logs\backint.out)----------
Reading parameter file F:\sapdb\data\wrk\TBP\backint_parameter.txt.
Using C:\Program Files\Veritas\Netbackup\bin\backint.exe as Backint for Oracle.
Using F:\sapdb\data\wrk\TBP\initTBP.utl as parameterfile of Backint for Oracle.
Using D:\sapdb\Logs\backuphistory.log as history file.
Using D:\sapdb\Logs\backintoracle.in as input of Backint for Oracle.
Using D:\sapdb\Logs\backintoracle.out as output of Backint for Oracle.
Using D:\sapdb\Logs\backintoracle.err as error output of Backint for Oracle.
Using staging area D:\sapdb\stage\stage1 with a size of 1073741824 bytes.
Using 2 file per Backint for Oracle call.
Using a maximal delay for a Backint for Oracle call of 30 seconds.

Reading input file D:\sapdb\Logs\backint.in.
Backing up pipe \\.\pipe\TBP.
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 2007-07-16 16:09:36.
Calling 'C:\Program Files\Veritas\Netbackup\bin\backint.exe -u TBP -f backup -t file -p F:\sapdb\data\wrk\TBP\initTBP.utl -i D:\sapdb\Logs\backintoracle.in -c' .
Backint for Oracle ended at 2007-07-16 16:09:37 with return code 2.
Backint for Oracle output: E
Backint for Oracle output: ERROR: incorrect format or option in .utl file (-p)
Backint for Oracle output:
Backint for Oracle error output:

Finished the backup unsuccessfully.

#ERROR \\.\pipe\TBP

---------- End of output of Backint for MaxDB (D:\sapdb\Logs\backint.out)----------
Removed Backint for MaxDB's temporary output file 'D:\sapdb\Logs\backint.out'.
Copying error output of Backint for MaxDB to this file.
---------- Begin of error output of Backint for MaxDB (D:\sapdb\Logs\backint.err)----------
Backint for Oracle was unsuccessful.

---------- End of error output of Backint for MaxDB (D:\sapdb\Logs\backint.err)----------
Removed Backint for MaxDB's temporary error output file 'D:\sapdb\Logs\backint.err'.
Removed the Backint for MaxDB input file 'D:\sapdb\Logs\backint.in'.
Have finished clean up successfully.

BSI.ENv :
BACKINT "D:\sapdb\TBP\db\bin\backint.exe"
INPUT "D:\sapdb\Logs\backint.in"
OUTPUT "D:\sapdb\Logs\backint.out"
ERROROUTPUT "D:\sapdb\Logs\backint.err"
PARAMETERFILE "F:\sapdb\data\wrk\TBP\backint_parameter.txt"
ORIGINAL_RUNDIRECTORY "F:\sapdb\data\wrk\TBP"
TIMEOUT_SUCCESS 600
TIMEOUT_FAILURE 300

backint_parameter.txt :
BACKINT: "C:\Program Files\Veritas\Netbackup\bin\backint.exe"
PARAMETERFILE OF BACKINT: "F:\sapdb\data\wrk\TBP\initTBP.utl"
HISTORY FILE: "D:\sapdb\Logs\backuphistory.log"
INPUTFILE FOR BACKINT: "D:\sapdb\Logs\backintoracle.in"
OUTPUTFILE FOR BACKINT: "D:\sapdb\Logs\backintoracle.out"
ERRORFILE FOR BACKINT: "D:\sapdb\Logs\backintoracle.err"
STAGING AREA: D:\sapdb\stage\stage1 1 GB
FILES PER BACKINT CALL: 2
MAXIMAL DELAY OF BACKINT CALL: 30

initTBP.utl :
switch_list D:\sapdb\TBP\switch.list
switch_sem D:\sapdb\TBP\switch.sem
switch_log D:\sapdb\TBP\switch.log
policy maxdb_hot_backup

Options: ReplyQuote


Subject
Written By
Posted
Veriyas Netbackup Backint for Oracle out put: ERROR: incorrect format or option in .utl file (-p)
July 16, 2007 12:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.