cancel
Showing results for 
Search instead for 
Did you mean: 

MAxdb restore stuck with error "connect to pipe failed"

pankaj_pabreja
Participant
0 Kudos
1,209

Hi Gurus,

We are doing the system copy on sandbox server from the production system and on the DB recovery step . We are doing the manual restore.

OS: windows 2008, DB: MAXDB 7.8.2.31.

Using netbackup tool for restore, we are triggering the restore from DB studio after defining the label.

The restore preparation gets successful but the backup tool terminates with the below error in dbm.prt file

2013-06-05 07:54:42       3836 INF          1 DBMKnl   Sending an administrative statement to the database

                          3836 INF          8 DBMKnl   Statement:  CREATE INSTANCE WITH RESTORE DATA FROM '\\.\pipe\PBW' PIPE  BLOCKSIZE 8 MEDIANAME 'BACKsapdb'

2013-06-05 08:07:59       3836 ERR          3 DBMKnl   Received the result of an administrative statement from the database

                          3836 ERR          9 DBMKnl   Statement:  CREATE INSTANCE WITH RESTORE DATA FROM '\\.\pipe\PBW' PIPE  BLOCKSIZE 8 MEDIANAME 'BACKsapdb'

                          3836 ERR         10 DBMKnl   Returncode: -903

                          3836 ERR          5 DBMKnl   Errortext:  Host file I/O error

2013-06-05 08:08:01       3836 ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'db_activate' has ended and failed with return code -24920.

The knlmsg file contains the below error logs:

ERR Recovery       6:  Data recovery failed,_FILE=Kernel_Administration.cpp,_LINE=2029

2850:                                 2013-06-05 08:07:58 ERR RTEIO        113:  Open medium on \\.\pipe\PBW for READ failed,_FILE=RTEIO_StreamMedium.cpp,_LINE=1336

2851:                                 2013-06-05 08:07:58     SrvTasks      17:  Servertask Info: because Error in backup task occured

2852:                                 2013-06-05 08:07:58     SrvTasks      10:  Job 1 (Backup / Restore Medium Task) [executing] WaitingT168 Result=3700

2853:                                 2013-06-05 08:07:58     KernelComm     6:  Error in backup task occured, Error code 3700 "hostfile_error"

2854:                                 2013-06-05 08:07:58 ERR RTEIO         69:  connect to pipe \\.\pipe\PBW failed,ERRORTEXT=Cancelled,ERROR_NUMBER=0,_FILE=RTEIO_StreamMedium.cpp,_LINE=3521

Please assist.

Thanks,

Pankaj

Accepted Solutions (0)

Answers (2)

Answers (2)

pankaj_pabreja
Participant
0 Kudos

Hi All,

I went through the notes and links but still unable to restore. Please find below the error logs which we are getting now after changing some parameter file settings. We are now trying to restore via recover a medium option. Also the backup_ext_ids_get BACKsapdb <DBSID> is failing. Please find below the error logs:

2013-07-29 11:18:09

Using environment variable 'TEMP' with value 'C:\Windows\TEMP' as directory for temporary files and pipes.

Using MaxDB Kernel Process.

Using connection to Backint for MaxDB Interface.

2013-07-29 11:18:10

Checking existence and configuration of Backint for MaxDB.

    Using configuration variable 'BSI_ENV' = 'F:\Veritas\SAPCONF\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 'F:\Veritas\SAPCONF\bsi.env'.

    Reading the Backint for MaxDB configuration file 'F:\Veritas\SAPCONF\bsi.env'.

        Found keyword 'BACKINT' with value 'F:\Veritas\SAPCONF\SapDBAgent.exe'.

        Found keyword 'INPUT' with value 'F:\Veritas\SAPCONF\input.f'.

        Found keyword 'OUTPUT' with value 'F:\Veritas\SAPCONF\output.f'.

        Found keyword 'ERROROUTPUT' with value 'F:\Veritas\SAPCONF\error.f'.

        Found keyword 'PARAMETERFILE' with value 'F:\Veritas\SAPCONF\SapDBAgent.par'.

        Found keyword 'CHECK_AVAILABILITY' with value 'YES'.

    Finished reading of the Backint for MaxDB configuration file.

    Using 'F:\Veritas\SAPCONF\SapDBAgent.exe' as Backint for MaxDB program.

    Using 'F:\Veritas\SAPCONF\input.f' as input file for Backint for MaxDB.

    Using 'F:\Veritas\SAPCONF\output.f' as output file for Backint for MaxDB.

    Using 'F:\Veritas\SAPCONF\error.f' as error output file for Backint for MaxDB.

    Using 'F:\Veritas\SAPCONF\SapDBAgent.par' as parameter file for Backint for MaxDB.

    Using '300' 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\QBW\data\wrk\QBW\dbm.knl' as backup history of a database to migrate.

    Using 'F:\sapdb\QBW\data\wrk\QBW\dbm.ebf' as external backup history of a database to migrate.

    Checking availability of backups using backint's inquire function.

Check passed successful.

2013-07-29 11:18:10

Preparing query for available backups.

    Setting environment variable 'BI_CALLER' to value 'DBMSRV'.

    Setting environment variable 'BI_REQUEST' to value 'NEW'.

    Setting environment variable 'BI_BACKUP' to value ''.

    Restoring the needed Backup History files.

        2013-07-29 11:18:10 The backup tool is not running completely.

       

       

        Preparing restore.

            Setting environment variable 'BI_CALLER' to value 'DBMSRV'.

            Setting environment variable 'BI_REQUEST' to value 'NEW'.

            Setting environment variable 'BI_BACKUP' to value ''.

            Constructed Backint for MaxDB call 'F:\Veritas\SAPCONF\SapDBAgent.exe -u PBW -f restore -t file -p F:\Veritas\SAPCONF\SapDBAgent.par -i F:\Veritas\SAPCONF\input.f -c'.

            Created temporary file 'F:\Veritas\SAPCONF\output.f' as output for Backint for MaxDB.

            Created temporary file 'F:\Veritas\SAPCONF\error.f' as error output for Backint for MaxDB.

            Writing '#NULL F:\sapdb\QBW\data\wrk\QBW\dbm.ebf F:\sapdb\QBW\data\wrk\QBW' to the input file.

            Writing '#NULL F:\sapdb\QBW\data\wrk\QBW\dbm.knl F:\sapdb\QBW\data\wrk\QBW' to the input file.

        Prepare passed successfully.

        Starting Backint for MaxDB.

            Starting Backint for MaxDB process 'F:\Veritas\SAPCONF\SapDBAgent.exe -u PBW -f restore -t file -p F:\Veritas\SAPCONF\SapDBAgent.par -i F:\Veritas\SAPCONF\input.f -c >>F:\Veritas\SAPCONF\output.f 2>>F:\Veritas\SAPCONF\error.f'.

            Process was started successfully.

        Backint for MaxDB has been started successfully.

        Waiting for the end of Backint for MaxDB.

            2013-07-29 11:18:11 The backup tool is running.

            2013-07-29 11:18:16 The backup tool is running.

            2013-07-29 11:18:20 The backup tool process has finished work with return code 2.

        Ended the waiting.

        Have encountered error -24925:

            The backup tool failed with 2 as sum of exit codes.

        Constructed the following reply:

            ERR

            -24925,ERR_PREPARE: preparation of backup operation failed

            The backup tool failed with 2 as sum of exit codes.

        Have encountered error -24925:

            Could not restore the Backup History or the External Backup History with Backint for MaxDB.

        Copying output of Backint for MaxDB to this file.

        ---------- Begin of output of Backint for MaxDB (F:\Veritas\SAPCONF\output.f)----------

            [7336:8596] VERITAS NetBackup SapDB Agent, v 1.2.0 (Release build)

            [7336:8596] File F:\Veritas\SAPCONF\SapDBAgent.par opened

            [7336:8596] Reading parfile [F:\Veritas\SAPCONF\SapDBAgent.par]

            [7336:8596] Parfile line [policy          SSAPPBWB_SAPDB] : [policy] => [SSAPPBWB_SAPDB]

            [7336:8596] Parfile line [schedule          Default-Application-Backup] : [schedule] => [Default-Application-Backup]

            [7336:8596] Parfile line [buffersz          6] : [buffersz] => [6]

            [7336:8596] Parfile line [server                    SHEX36] : [server] => [SHEX36]

            [7336:8596] Parfile line [oldsid                    PBW] : [oldsid] => [PBW]

            [7336:8596] Parfile line [olddir                    f:\sapdb\data\wrk\PBW] : [olddir] => [f:\sapdb\data\wrk\PBW]

            [7336:8596] Parfile line [newdir                    f:\sapdb\data\wrk\QBW] : [newdir] => [f:\sapdb\data\wrk\QBW]

            [7336:8596]   - NetBackup Policy:   SSAPPBWB_SAPDB

            [7336:8596]   - NetBackup Schedule: Default-Application-Backup

            [7336:8596]   - NetBackup Server: SHEX36

            [7336:8596]   - Buffer Size: 6291456 bytes

            [7336:8596]   - Old SID: PBW

            [7336:8596]   - Old Run Directory: f:\sapdb\data\wrk\PBW

            [7336:8596]   - New Run Directory: f:\sapdb\data\wrk\QBW

            [7336:8596] File F:\Veritas\SAPCONF\input.f opened

            [7336:8596] Reading input from [F:\Veritas\SAPCONF\input.f]

            [7336:8596] File <1> opened

            [7336:8596] Writing output to STDOUT

            [7336:8596] ** Overriding SID to PBW **

            [7336:8596] Starting thread for files

            [7336:8596] Thread 9132 created

            [7336:8596] Threads still running: 1   Number done: 0

            [7336:8596] Waiting for threads..

            [7336:9132] RestoreThread started

            [7336:9132] Initializing BSA interface

            [7336:9132] Restoring File : F:\sapdb\QBW\data\wrk\QBW\dbm.ebf to F:\sapdb\QBW\data\wrk\QBW

            [7336:9132] Catalogue search for /SapDB:PBW:F:\sapdb\QBW\data\wrk\QBW\dbm.ebf Failed

            [7336:9132] Thread ABORTED

            [7336:8596] Done waiting for threads..

            [7336:8596] Moving thread 9132 to DONE set

            [7336:8596] Thread ID 9132 failed - aborting others

            [7336:8596] Threads still running: 0   Number done: 1

            #NOTFOUND F:\sapdb\QBW\data\wrk\QBW\dbm.ebf

            #NOTFOUND F:\sapdb\QBW\data\wrk\QBW\dbm.knl

            [7336:8596] Exiting with code 2

           

        ---------- End of output of Backint for MaxDB (F:\Veritas\SAPCONF\output.f)----------

        Removed Backint for MaxDB's temporary output file 'F:\Veritas\SAPCONF\output.f'.

        Copying error output of Backint for MaxDB to this file.

        ---------- Begin of error output of Backint for MaxDB (F:\Veritas\SAPCONF\error.f)----------

           

        ---------- End of error output of Backint for MaxDB (F:\Veritas\SAPCONF\error.f)----------

        Removed Backint for MaxDB's temporary error output file 'F:\Veritas\SAPCONF\error.f'.

    Could not restore the needed Backup History files correctly.

Prepare failed.

2013-07-29 11:18:21

Cleaning up.

    Removed the Backint for MaxDB input file 'F:\Veritas\SAPCONF\input.f'.

    Moving renamed backup history file from 'F:\sapdb\QBW\data\wrk\QBW\dbm.knc' back to 'F:\sapdb\QBW\data\wrk\QBW\dbm.knl'.

    Moving renamed backup history file from 'F:\sapdb\QBW\data\wrk\QBW\dbm.ebc' back to 'F:\sapdb\QBW\data\wrk\QBW\dbm.ebf'.

Have finished clean up successfully.

former_member188883
Active Contributor
0 Kudos

Hi Pankaj,

Could you refer this threads

http://scn.sap.com/thread/1703899

http://scn.sap.com/thread/1573564

Some analysis and basic troubleshooting steps has been explained.

Hope this helps

Regards,

Deepak Kori

pankaj_pabreja
Participant
0 Kudos

Hi Deepak,

Thanks for the reference but the threads don't have the resolution and are not related to netbackup.

Regards,

Pankaj

Former Member