Problem during restoring MaxDB backup for SAP

Question

Hi,I am trying to restore MAXDB backup with netbackup 7.6.bsi.env:BACKINT /usr/openv/netbackup/bin/backintOUTPUT /sapdb/data/wrk/backint_dir/backint.inOUTPUT /sapdb/data/wrk/backint_dir/backint.outERROROUTPUT /sapdb/data/wrk/backint_dir/backint.errPARAMETERFILE /sapdb/data/wrk/backint_dir/initSAP.utlinitSAP.utl:switch_list /sapdb/data/wrk/.switch.lisswitch_sem /sapdb/data/wrk/.switch.semswitch_log /sapdb/data/wrk/.switch.logbackint_dir /sapdb/data/wrk/backint_dirserver &lt;serveraddr&gt;client &lt;clientaddr&gt;drives 1policy sapdb-DB-REMOTE-TAPEschedule Default-Application-BackupPolicy is active and NB client sees backup files:[root@client backint_dir]# /usr/openv/netbackup/bin/bplist -C &lt;clientaddr&gt; -t 17 -l -R /-rw-rw---- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 684181 Sep 17 22:27 /storage/sapdb/data/wrk/SDB/dbm.ebf-rw-rw---- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1283690 Sep 17 22:27 /storage/sapdb/data/wrk/SDB/dbm.knl-rw------- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 712838144K Sep 17 16:37 /sapdb/data/wrk/backdata-rw-rw---- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 683671 Sep 15 18:31 /storage/sapdb/data/wrk/SDB/dbm.ebf-rw-rw---- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1282841 Sep 15 18:31 /storage/sapdb/data/wrk/SDB/dbm.knl-rw------- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 712856064K Sep 15 11:00 /sapdb/data/wrk/backdata-rw-rw---- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 682311 Sep 08 18:15 /storage/sapdb/data/wrk/SDB/dbm.ebf-rw-rw---- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1280577 Sep 08 18:15 /storage/sapdb/data/wrk/SDB/dbm.knl-rw------- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 712764416K Sep 08 11:00 /sapdb/data/wrk/backdata-rw-rw---- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 680951 Sep 01 18:16 /storage/sapdb/data/wrk/SDB/dbm.ebf-rw-rw---- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1278313 Sep 01 18:16 /storage/sapdb/data/wrk/SDB/dbm.knl-rw------- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 712537088K Sep 01 11:00 /sapdb/data/wrk/backdata-rw-rw---- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 680101 Aug 28 09:03 /storage/sapdb/data/wrk/SDB/dbm.ebf-rw-rw---- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1276898 Aug 28 07:47 /storage/sapdb/data/wrk/SDB/dbm.knl-rw------- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 349765632 Aug 28 09:00 /sapdb/data/wrk/backlog-rw-rw---- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 648949 Jun 29 14:36 /storage/sapdb/data/wrk/SDB/dbm.ebf-rw-rw---- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1223694 Jun 29 14:36 /storage/sapdb/data/wrk/SDB/dbm.knl-rw------- sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 670006784K Jun 29 09:45 /sapdb/data/wrk/backdataBut.... If I try to start restore or check backup, after timeout it fails with:&nbsp;backup operation was unsuccessful The backup tool failed with 2 as sum of exit codes. The database request was canceled and ended with error -903.bsi.ebp:2018-09-26 14:37:24Setting environment variable 'TEMP' for the directory for temporary files and pipes to default ''.Setting environment variable 'TMP' for the directory for temporary files and pipes to default ''.Using connection to Backint for MaxDB Interface.2018-09-26 14:37:24Checking existence and configuration of Backint for MaxDB.&nbsp;&nbsp;&nbsp; Reading the Backint for MaxDB configuration file '/sapdb/data/wrk/SDB/bsi.env'.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Found keyword 'BACKINT' with value '/usr/openv/netbackup/bin/backint'.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Found keyword 'OUTPUT' with value '/sapdb/data/wrk/backint_dir/backint.in'.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Found keyword 'OUTPUT' with value '/sapdb/data/wrk/backint_dir/backint.out'.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Found keyword 'ERROROUTPUT' with value '/sapdb/data/wrk/backint_dir/backint.err'.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Found keyword 'PARAMETERFILE' with value '/sapdb/data/wrk/backint_dir/initSAP.utl'.&nbsp;&nbsp;&nbsp; Finished reading of the Backint for MaxDB configuration file.&nbsp;&nbsp;&nbsp; Using '/usr/openv/netbackup/bin/backint' as Backint for MaxDB program.&nbsp;&nbsp;&nbsp; Using '/sapdb/data/wrk/SDB/bsi.in' as input file for Backint for MaxDB.&nbsp;&nbsp;&nbsp; Using '/sapdb/data/wrk/backint_dir/backint.out' as output file for Backint for MaxDB.&nbsp;&nbsp;&nbsp; Using '/sapdb/data/wrk/backint_dir/backint.err' as error output file for Backint for MaxDB.&nbsp;&nbsp;&nbsp; Using '/sapdb/data/wrk/backint_dir/initSAP.utl' as parameter file for Backint for MaxDB.&nbsp;&nbsp;&nbsp; Using '300' seconds as timeout for Backint for MaxDB in the case of success.&nbsp;&nbsp;&nbsp; Using '300' seconds as timeout for Backint for MaxDB in the case of failure.&nbsp;&nbsp;&nbsp; Using '/sapdb/data/wrk/SDB/dbm.knl' as backup history of a database to migrate.&nbsp;&nbsp;&nbsp; Using '/sapdb/data/wrk/SDB/dbm.ebf' as external backup history of a database to migrate.&nbsp;&nbsp;&nbsp; Checking availability of backups using backint's inquire function.Check passed successful.2018-09-26 14:37:24Checking medium.Check passed successfully.2018-09-26 14:37:24Preparing restore.&nbsp;&nbsp;&nbsp; Setting environment variable 'BI_CALLER' to value 'DBMSRV'.&nbsp;&nbsp;&nbsp; Setting environment variable 'BI_REQUEST' to value 'NEW'.&nbsp;&nbsp;&nbsp; Setting environment variable 'BI_BACKUP' to value 'FULL'.&nbsp;&nbsp;&nbsp; Got the following list of external backup ID's:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "SDB VXP11537140637 /sapdb/data/wrk/backdata"&nbsp;&nbsp;&nbsp; Constructed Backint for MaxDB call '/usr/openv/netbackup/bin/backint -u SDB -f restore -t file -p /sapdb/data/wrk/backint_dir/initSAP.utl -i /sapdb/data/wrk/SDB/bsi.in -c'.&nbsp;&nbsp;&nbsp; Created temporary file '/sapdb/data/wrk/backint_dir/backint.out' as output for Backint for MaxDB.&nbsp;&nbsp;&nbsp; Created temporary file '/sapdb/data/wrk/backint_dir/backint.err' as error output for Backint for MaxDB.&nbsp;&nbsp;&nbsp; Writing 'VXP11537140637 /sapdb/data/wrk/backdata' to the input file.Prepare passed successfully.2018-09-26 14:37:24Creating pipes for data transfer.&nbsp;&nbsp;&nbsp; Creating pipe '/sapdb/data/wrk/backdata' ... Done.All data transfer pipes have been created.2018-09-26 14:37:24Starting database action for the restore.&nbsp;&nbsp;&nbsp; Requesting 'RESTORE DATA FROM '/sapdb/data/wrk/backdata' PIPE&nbsp; BLOCKSIZE 64 MEDIANAME 'BACKData'' from db-kernel.The database is working on the request.2018-09-26 14:37:24Waiting until database has prepared the restore.&nbsp;&nbsp;&nbsp; Asking for state of database.&nbsp;&nbsp;&nbsp; 2018-09-26 14:37:42 Database has finished preparation of the restore.The database has prepared the restore successfully.2018-09-26 14:37:42Starting Backint for MaxDB.&nbsp;&nbsp;&nbsp; Starting Backint for MaxDB process '/usr/openv/netbackup/bin/backint -u SDB -f restore -t file -p /sapdb/data/wrk/backint_dir/initSAP.utl -i /sapdb/data/wrk/SDB/bsi.in -c &gt;&gt;/sapdb/data/wrk/backint_dir/backint.out 2&gt;&gt;/sapdb/data/wrk/backint_dir/backint.err'.&nbsp;&nbsp;&nbsp; Process was started successfully.Backint for MaxDB has been started successfully.2018-09-26 14:37:42Waiting for end of the restore operation.&nbsp;&nbsp;&nbsp; 2018-09-26 14:37:42 The backup tool is running.&nbsp;&nbsp;&nbsp; 2018-09-26 14:37:42 The database is working on the request.&nbsp;&nbsp;&nbsp; 2018-09-26 14:37:47 The backup tool is running.&nbsp;&nbsp;&nbsp; 2018-09-26 14:37:47 The database is working on the request.&nbsp;&nbsp;&nbsp; 2018-09-26 14:37:49 The backup tool process has finished work with return code 2.&nbsp;&nbsp;&nbsp; 2018-09-26 14:37:52 The database is working on the request.&nbsp;&nbsp;&nbsp; 2018-09-26 14:38:02 The database is working on the request.&nbsp;&nbsp;&nbsp; 2018-09-26 14:38:17 The database is working on the request.&nbsp;&nbsp;&nbsp; 2018-09-26 14:38:37 The database is working on the request.&nbsp;&nbsp;&nbsp; 2018-09-26 14:38:50 Canceling Utility-task after a timeout of 60 seconds elapsed ... OK.&nbsp;&nbsp;&nbsp; 2018-09-26 14:38:51 The database has finished work on the request.&nbsp;&nbsp;&nbsp; Receiving a reply from the database kernel.&nbsp;&nbsp;&nbsp; Got the following reply from db-kernel:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQL-Code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :-903The restore operation has ended.2018-09-26 14:38:51Filling reply buffer.&nbsp;&nbsp;&nbsp; Have encountered error -24920:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The backup tool failed with 2 as sum of exit codes. The database request was canceled and ended with error -903.&nbsp;&nbsp;&nbsp; Constructed the following reply:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ERR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -24920,ERR_BACKUPOP: backup operation was unsuccessful&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The backup tool failed with 2 as sum of exit codes. The database request was canceled and ended with error -903.Reply buffer filled.2018-09-26 14:38:51Cleaning up.&nbsp;&nbsp;&nbsp; Removing data transfer pipes.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Removing data transfer pipe /sapdb/data/wrk/backdata ... Done.&nbsp;&nbsp;&nbsp; Removed data transfer pipes successfully.&nbsp;&nbsp;&nbsp; Copying output of Backint for MaxDB to this file.&nbsp;&nbsp;&nbsp; ---------- Begin of output of Backint for MaxDB (/sapdb/data/wrk/backint_dir/backint.out)----------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ********************************************************************************&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Program:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /usr/openv/netbackup/bin/backint 7.6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Input File:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /sapdb/data/wrk/SDB/bsi.in&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Profile:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /sapdb/data/wrk/backint_dir/initSAP.utl&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Function:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RESTORE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ********************************************************************************&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ********************************************************************************&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ********************************************************************************&nbsp;&nbsp;&nbsp; ---------- End of output of Backint for MaxDB (/sapdb/data/wrk/backint_dir/backint.out)----------&nbsp;&nbsp;&nbsp; Removed Backint for MaxDB's temporary output file '/sapdb/data/wrk/backint_dir/backint.out'.&nbsp;&nbsp;&nbsp; Copying error output of Backint for MaxDB to this file.&nbsp;&nbsp;&nbsp; ---------- Begin of error output of Backint for MaxDB (/sapdb/data/wrk/backint_dir/backint.err)----------&nbsp;&nbsp;&nbsp; ---------- End of error output of Backint for MaxDB (/sapdb/data/wrk/backint_dir/backint.err)----------&nbsp;&nbsp;&nbsp; Removed Backint for MaxDB's temporary error output file '/sapdb/data/wrk/backint_dir/backint.err'.&nbsp;&nbsp;&nbsp; Removed the Backint for MaxDB input file '/sapdb/data/wrk/SDB/bsi.in'.Have finished clean up successfully.And in log of netbacku's backint I can see following:14:15:03.068 [9002] &lt;2&gt; backint_get_param: -i argv: &lt;/sapdb/data/wrk/SDB/bsi.in&gt;14:15:03.076 [9002] &lt;2&gt; vnet_pbxConnect: pbxConnectEx Succeeded14:15:03.076 [9002] &lt;2&gt; logconnections: BPRD CONNECT FROM 192.168.80.9.54770 TO 192.168.80.80.1556 fd = 914:15:03.682 [9002] &lt;2&gt; vnet_pbxConnect: pbxConnectEx Succeeded14:15:03.682 [9002] &lt;2&gt; logconnections: BPRD CONNECT FROM 192.168.80.9.59049 TO 192.168.80.80.1556 fd = 914:15:04.212 [9002] &lt;16&gt; open_file_list: Opening input file: &lt;/sapdb/data/wrk/SDB/bsi.in&gt;14:15:04.213 [9002] &lt;4&gt; /usr/openv/netbackup/bin/backint 7.6: ********************************************************************************14:15:04.213 [9002] &lt;4&gt; /usr/openv/netbackup/bin/backint 7.6: Program:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /usr/openv/netbackup/bin/backint 7.614:15:04.213 [9002] &lt;4&gt; /usr/openv/netbackup/bin/backint 7.6: Input File:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /sapdb/data/wrk/SDB/bsi.in14:15:04.213 [9002] &lt;4&gt; /usr/openv/netbackup/bin/backint 7.6: Profile:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /sapdb/data/wrk/backint_dir/initSAP.utl14:15:04.213 [9002] &lt;4&gt; /usr/openv/netbackup/bin/backint 7.6: Function:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INQUIRE14:15:04.213 [9002] &lt;4&gt; /usr/openv/netbackup/bin/backint 7.6: ********************************************************************************14:15:04.213 [9002] &lt;4&gt; read_input_file: Entering.14:15:04.213 [9002] &lt;4&gt; read_inquire_input_file: line: &lt;VXP11537140637 /sapdb/data/wrk/backdata&gt;14:15:04.213 [9002] &lt;4&gt; read_inquire_input_file: objectID: &lt;VXP11537140637&gt; objectName: &lt;/sapdb/data/wrk/backdata&gt;14:15:04.213 [9002] &lt;4&gt; read_inquire_input_file: line: &lt;VXP11537054238 /sapdb/data/wrk/backdata............................ many lines of such enties with different backupIDs..................14:15:04.240 [9002] &lt;4&gt; read_inquire_input_file: objectID: &lt;VXP11372254270&gt; objectName: &lt;/sapdb/data/wrk/backdata&gt;14:15:04.248 [9002] &lt;4&gt; read_input_file: Exiting.14:15:04.251 [9002] &lt;2&gt; vnet_pbxConnect: pbxConnectEx Succeeded14:15:04.251 [9002] &lt;2&gt; logconnections: BPRD CONNECT FROM 192.168.80.9.55984 TO 192.168.80.80.1556 fd = 1014:15:04.783 [9002] &lt;2&gt; vnet_pbxConnect: pbxConnectEx Succeeded14:15:04.783 [9002] &lt;2&gt; logconnections: BPRD CONNECT FROM 192.168.80.9.43062 TO 192.168.80.80.1556 fd = 1014:15:05.518 [9002] &lt;2&gt; vnet_pbxConnect: pbxConnectEx Succeeded14:15:05.518 [9002] &lt;2&gt; logconnections: BPRD CONNECT FROM 192.168.80.9.52521 TO 192.168.80.80.1556 fd = 1014:15:06.375 [9002] &lt;4&gt; VxBSAQueryObject: INF - No match was found for query14:15:06.375 [9002] &lt;4&gt; do_fifo_inquire: No object matched the specified predicate.14:15:06.375 [9002] &lt;4&gt; do_fifo_inquire: #NOTFOUND /sapdb/data/wrk/backdata14:15:06.375 [9002] &lt;4&gt; do_fifo_inquire: #NOTFOUND /sapdb/data/wrk/backdata................................... many lines...............................................................................................14:36:55.295 [9850] &lt;4&gt; do_fifo_inquire: No object matched the specified predicate.14:36:55.295 [9850] &lt;4&gt; /usr/openv/netbackup/bin/backint 7.6: ********************************************************************************14:37:42.262 [9918] &lt;2&gt; backint_get_param: -i argv: &lt;/sapdb/data/wrk/SDB/bsi.in&gt;14:37:42.271 [9918] &lt;2&gt; vnet_pbxConnect: pbxConnectEx Succeeded14:37:42.271 [9918] &lt;2&gt; logconnections: BPRD CONNECT FROM 192.168.80.9.50726 TO 192.168.80.80.1556 fd = 914:37:42.800 [9918] &lt;2&gt; vnet_pbxConnect: pbxConnectEx Succeeded14:37:42.800 [9918] &lt;2&gt; logconnections: BPRD CONNECT FROM 192.168.80.9.56937 TO 192.168.80.80.1556 fd = 914:37:43.340 [9918] &lt;16&gt; open_file_list: Opening input file: &lt;/sapdb/data/wrk/SDB/bsi.in&gt;14:37:43.340 [9918] &lt;4&gt; /usr/openv/netbackup/bin/backint 7.6: ********************************************************************************14:37:43.340 [9918] &lt;4&gt; /usr/openv/netbackup/bin/backint 7.6: Program:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /usr/openv/netbackup/bin/backint 7.614:37:43.340 [9918] &lt;4&gt; /usr/openv/netbackup/bin/backint 7.6: Input File:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /sapdb/data/wrk/SDB/bsi.in14:37:43.340 [9918] &lt;4&gt; /usr/openv/netbackup/bin/backint 7.6: Profile:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /sapdb/data/wrk/backint_dir/initSAP.utl14:37:43.340 [9918] &lt;4&gt; /usr/openv/netbackup/bin/backint 7.6: Function:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RESTORE14:37:43.340 [9918] &lt;4&gt; /usr/openv/netbackup/bin/backint 7.6: ********************************************************************************14:37:43.340 [9918] &lt;4&gt; read_input_file: Entering.14:37:43.340 [9918] &lt;4&gt; read_inquire_input_file: line: &lt;VXP11537140637 /sapdb/data/wrk/backdata&gt;14:37:43.340 [9918] &lt;4&gt; read_inquire_input_file: objectID: &lt;VXP11537140637&gt; objectName: &lt;/sapdb/data/wrk/backdata&gt;14:37:43.340 [9918] &lt;4&gt; read_input_file: Exiting.14:37:43.340 [9921] &lt;4&gt; get_client_read_timeout: Enter.14:37:43.340 [9921] &lt;4&gt; verifyFifoExist: Enter.14:37:43.340 [9918] &lt;2&gt; do_fifo_restore: Started child process &lt;9921&gt;14:37:43.340 [9918] &lt;2&gt; sap_Wait: Start waiting.14:37:43.343 [9921] &lt;2&gt; vnet_pbxConnect: pbxConnectEx Succeeded14:37:43.343 [9921] &lt;2&gt; logconnections: BPRD CONNECT FROM 192.168.80.9.59110 TO 192.168.80.80.1556 fd = 1014:37:43.875 [9921] &lt;2&gt; vnet_pbxConnect: pbxConnectEx Succeeded14:37:43.875 [9921] &lt;2&gt; logconnections: BPRD CONNECT FROM 192.168.80.9.47946 TO 192.168.80.80.1556 fd = 1014:37:44.601 [9921] &lt;2&gt; vnet_pbxConnect: pbxConnectEx Succeeded14:37:44.601 [9921] &lt;2&gt; logconnections: BPRD CONNECT FROM 192.168.80.9.43282 TO 192.168.80.80.1556 fd = 1014:37:45.351 [9921] &lt;2&gt; vnet_pbxConnect: pbxConnectEx Succeeded14:37:45.351 [9921] &lt;2&gt; logconnections: BPRD CONNECT FROM 192.168.80.9.38460 TO 192.168.80.80.1556 fd = 1014:37:46.197 [9921] &lt;4&gt; VxBSAQueryObject: INF - No match was found for query14:37:46.197 [9921] &lt;4&gt; restore_one_fifo: No object matched the specified predicate.14:37:46.197 [9921] &lt;4&gt; /usr/openv/netbackup/bin/backint 7.6: ********************************************************************************14:37:48.341 [9918] &lt;16&gt; sap_Wait: ERR - job (9921) failed status (2)14:37:48.341 [9918] &lt;4&gt; /usr/openv/netbackup/bin/backint 7.6: ********************************************************************************bsi.in for this case was:VXP11537140637 /sapdb/data/wrk/backdataSo it seems that backint can't find file in backup.Can you suggest why this happensThanks a alot

michal_mikulik1 · Answer

Hello,check the backups availability with dbmcli:dbmcli -d &lt;DBNAME&gt; -u &lt;USER&gt;,&lt;PSW&gt;dbmcli&gt; backup_ext_ids_get BACKdata &lt;DBNAME&gt;dbmcli&gt; backup_ext_ids_list[next]then you should get something like this:AVAILABLE|MAXDB VXP11444287599 \.\PIPE\medium1|DATA&nbsp; MIGRATION|2015-10-08 08:59:43|Do you see them as Available?RegardsMichal&nbsp;

woland255 · Answer

Hi, Michal./dbmcli on SDB&gt; backup_ext_ids_get BACKdata SDBOKThere are no ext itd's in this output.But:&nbsp;./dbmcli on SDB&gt;backup_history_list -e -r lastOKEND5B9EE77B01A7|DAT_000001287|SAVE WARM|2018-09-17 02:30:03|2018-09-17 02:30:03|2018-09-17 02:30:28|2018-09-17 08:08:55| 159785099|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |NO |BACKData&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 89104576|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |E:UNAVAILABLE|SDB VXP11537140637 /sapdb/data/wrk/backdata|So, they are not seen as available, correct? And why it could be so?Thanks a lot.

michal_mikulik1 · Answer

Hello,one note to backup_ext_ids_get&nbsp; - it displays only OK, it must be followed by backup_ext_ids_list to display id's availability.But ok when they are unavailable, then doublecheck that BSI_ENV is set to the correct file, with intended initSAP.utl with the proper policy name.dbmcli -d MAXDB -u &lt;user/,psw&gt; dbm_configset -raw BSI_ENV …\bsi*.envand this policy must be active (you mentioned it is).If it is a redirected restore (not in place restore), also client name must be set in initSAP.utl.RegardsMichal&nbsp;

woland255 · Answer

No, still no luck:[sdb@client bin]$ cat /storage/sapdb/data/wrk/SDB/bsi.envBACKINT /usr/openv/netbackup/bin/backintOUTPUT /sapdb/data/wrk/backint_dir/backint.inOUTPUT /sapdb/data/wrk/backint_dir/backint.outERROROUTPUT /sapdb/data/wrk/backint_dir/backint.errPARAMETERFILE /sapdb/data/wrk/backint_dir/initSAP.utl[sdb@client bin]$ ./dbmcli -u SUPERDBA,password -d SDB./dbmcli on SDB&gt;dbm_configset -raw BSI_ENV /storage/sapdb/data/wrk/SDB/bsi.envOK---./dbmcli on SDB&gt;backup_ext_ids_get BACKdata SDBOK---./dbmcli on SDB&gt;&nbsp;Client name is present in .utl (I have listed its contents).Thanks a lot

woland255 · Answer

And one more thing to mention:On production backup_ext_ids_get also returns no results. But it writes backups successfully&nbsp;

Forum Discussion

Problem during restoring MaxDB backup for SAP

6 Replies

Related Content

VC problem during agent install

VCS problem with virtual IP during failover

Error during restore backup

Error Code E00003BF During a restore

Tape restore problem...