Skip to Content

HANA BackupRestore using backint - QAS System Refresh.

Hi,

I am performing HANA BackupRestore using backint (ddbda) from PRD to QAS (System Refresh). Distributed enviroment PRD (4 Host) and QAS (4 Host)

I see backup available in PRD backup catalog and also able to see the backup in Backup Catalog of QAS in Recovery wizard from studio.

When I complete the wizard to start the recovery I see below logs and the recovery stops.

1) backup.log

2018-10-24T16:16:40+02:00 P130092 166a64c5ab9 INFO RECOVERY INQUIRE finished successfully 2018-10-24T21:25:25+02:00 P044874 166a789e8f1 INFO RECOVERY INQUIRE started 2018-10-24T21:25:25+02:00 P044874 166a789e8f1 INFO RECOVERY command: BACKUP COMPLETE LIST DATA USING SOURCE 'PRD' USING CATALOG BACKINT LIMIT 10 2018-10-24T21:25:25+02:00 P044874 166a789e8f1 INFO RECOVERY state of service: nameserver, psthanqbw01:37001, volume: 0, RecoveryExecuteCatalogRecoveryInProgress 2018-10-24T21:25:32+02:00 P044874 166a789e8f1 INFO RECOVERY state of service: nameserver, psthanqbw01:37001, volume: 0, RecoveryExecuteCatalogRecoveryFinished 2018-10-24T21:25:32+02:00 P044874 166a789e8f1 INFO RECOVERY using backup catalog 1540409008219 from backint /usr/sap/QAS/SYS/global/hdb/backint/log_backup_0_0_0_0 2018-10-24T21:25:32+02:00 P044874 166a789e8f1 INFO RECOVERY INQUIRE finished successfully 2018-10-24T21:25:47+02:00 P045828 166a78a4185 INFO RECOVERY INQUIRE started 2018-10-24T21:25:47+02:00 P045828 166a78a4185 INFO RECOVERY command: BACKUP COMPLETE LIST DATA USING SOURCE 'PRD' USING CATALOG BACKINT LIMIT 10 OFFSET 10 2018-10-24T21:25:47+02:00 P045828 166a78a4185 INFO RECOVERY state of service: nameserver, psthanqbw01:37001, volume: 0, RecoveryExecuteCatalogRecoveryInProgress 2018-10-24T21:25:53+02:00 P045828 166a78a4185 INFO RECOVERY state of service: nameserver, psthanqbw01:37001, volume: 0, RecoveryExecuteCatalogRecoveryFinished 2018-10-24T21:25:53+02:00 P045828 166a78a4185 INFO RECOVERY using backup catalog 1540409008219 from backint /usr/sap/WAS/SYS/global/hdb/backint/log_backup_0_0_0_0 2018-10-24T21:25:54+02:00 P045828 166a78a4185 INFO RECOVERY INQUIRE finished successfully qasadm@psthanqbw01:/usr/sap/QAS/HDB70/psthanqbw01/trace>

2) backint.log

2018-10-24 15:38:38.000 backint started: command: /usr/sap/QAS/SYS/global/hdb/opt/hdbbackint -f inquire -p /opt/ddbda/config/sap_hana_QAS_ddbda.utl -i /var/tmp/hdbbackint_QAS.3d638s -o /var/tmp/hdbbackint_QAS.KFFGMc -u PRD pid: 130157 input: #SOFTWAREID "backint 1.04" "HANA HDB server 1.00.122.11.1499758750" #EBID 1531496953 "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_0_1" #EBID 1531496959 "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_1_1" #EBID 1531496957 "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_2_1" #EBID 1531496958 "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_3_1" #EBID 1531496957 "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_4_1" #EBID 1531496957 "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_5_1" #EBID 1531496957 "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_6_1" 2018-10-24 16:16:40.000 backint terminated: pid: 130157 exit code: 0 output: #SOFTWAREID "backint 1.06" "database app agent 3.0 3.0.0.0.Build.199 199" #BACKUP "1531496953" "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_0_1" #BACKUP "1531496957" "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_2_1" #NOTFOUND "1531496957" "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_4_1" #NOTFOUND "1531496957" "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_5_1" #NOTFOUND "1531496957" "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_6_1" #BACKUP "1531496958" "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_3_1" #BACKUP "1531496959" "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_1_1" 2018-10-24 21:25:25.000 backint started: command: /usr/sap/QAS/SYS/global/hdb/opt/hdbbackint -f restore -p /opt/ddbda/config/sap_hana_QAS_ddbda.utl -i /var/tmp/hdbbackint_QAS.xG13KB -o /var/tmp/hdbbackint_QAS.ieLdxU -u PRD pid: 44914 input: #SOFTWAREID "backint 1.04" "HANA HDB server 1.00.122.11.1499758750" #NULL "/usr/sap/PRD/SYS/global/hdb/backint/log_backup_0_0_0_0" "/usr/sap/QAS/SYS/global/hdb/backint/log_backup_0_0_0_0" 2018-10-24 21:25:32.000 backint terminated: pid: 44914 exit code: 0 output: #SOFTWAREID "backint 1.06" "database app agent 3.0 3.0.0.0.Build.199 199" #RESTORED "1540409010" "/usr/sap/PRD/SYS/global/hdb/backint/log_backup_0_0_0_0" 2018-10-24 21:25:48.000 backint started: command: /usr/sap/QAS/SYS/global/hdb/opt/hdbbackint -f restore -p /opt/ddbda/config/sap_hana_QAS_ddbda.utl -i /var/tmp/hdbbackint_QAS.ZgdoDo -o /var/tmp/hdbbackint_QAS.3uFy8G -u PRD pid: 45866 input: #SOFTWAREID "backint 1.04" "HANA HDB server 1.00.122.11.1499758750" #NULL "/usr/sap/PRD/SYS/global/hdb/backint/log_backup_0_0_0_0" "/usr/sap/QAS/SYS/global/hdb/backint/log_backup_0_0_0_0" 2018-10-24 21:25:53.000 backint terminated: pid: 45866 exit code: 0 output: #SOFTWAREID "backint 1.06" "database app agent 3.0 3.0.0.0.Build.199 199" #RESTORED "1540409010" "/usr/sap/PRD/SYS/global/hdb/backint/log_backup_0_0_0_0"

The above files show NOT FOUND but they are available in PRD backup catalog.

Thanks.

Regards,
Fernando

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 25, 2018 at 02:38 PM

    Since this is a backint solution I would open a ticket with your backup vendor for help with this. We use backint (CommVaulut) where I work and sometimes they have specific ways to do a recovery and config files to be created for cross machine system copies. Can you check that the backup pieces exist in the 3rd party backup solution? The backup catalog may show them, but they may not physically exist.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2018 at 12:35 PM

    Hello Bryan,

    Thanks for your reply.

    I will surely open a case to EMC for backint solution.
    Until I get a really from vendor, are there are specific configuration for backint for cross machine system copies and for distributed enviroment?

    More replies are welcomed.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 28, 2018 at 06:41 PM

    Further Error found during restore in trace file :: localclient_psthanqbw01.p015926.000.trc file

    qasadm@hostname01:/usr/sap/QAS/HDB70/hostname01/trace> tail -100 localclient_hostname01.p010939.000.trc [10939]{-1}[-1/-1] 2018-10-28 19:13:37.269912 i Memory AllocatorImpl.cpp(00496) : Allocators not used [10939]{-1}[-1/-1] 2018-10-28 19:13:37.272442 w TraceTopic TraceTopic.cpp(00147) : Specified trace level Warning for trace topic Basis is below minimum level Info. This causes your database to be unsupportable. [10939]{-1}[-1/-1] 2018-10-28 19:13:37.298338 e DaemonClient NetworkLinux.cpp(00200) : cannot connect to 10.167.77.151:37000, error: exception 1: no.2110013 (Basis/IO/Stream/impl/NetworkChannel.cpp:2720) Connection failed: NetworkChannel::triggerConnect (blocking) rc=111: Connection refused. channel={ ={ ={this=93928004641960, fd=11, refCnt=2, local=10.167.77.151/0_tcp, remote=10.167.77.151/37000_tcp, state=ConnectWait, pending=[----]}}} exception throw location: 1: 0x00007fb75a1a92d8 in Stream::NetworkChannel::triggerConnect()+0x534 at NetworkChannel.cpp:2720 ( libhdbbasis.so) 2: 0x00007fb75a1b4288 in Stream::NetworkChannelSSLFilter::initiateConnection()+0x74 at NetworkChannelSSLFilter.cpp:214 ( libhdbbasis.so) 3: 0x00007fb75a1b451a in Stream::NetworkChannelSSLFilter::NetworkChannelSSLFilter(Crypto::ExportsForBasis&, Stream::NetworkChannelCompletionHandler&, Stream::NetworkChannelParameters const&, NetworkAccess::NetworkAddress const*, NetworkAccess::NetworkAddress const&, ltt::smartptr_handle *, int)+0x206 at NetworkChannelSSLFilter.cpp:79 ( libhdbbasis.so) 4: 0x00007fb75a1c7093 in Stream::NetworkChannelManager::connect(NetworkAccess::NetworkAddress const*, NetworkAccess::NetworkAddress const&, Stream::NetworkChannelParameters const&, bool, ltt::smartptr_handle *, int)+0x1b0 at NetworkChannelManager.cpp:204 ( libhdbbasis.so) 5: 0x00007fb75a1c96d7 in Stream::NetworkChannelManager::connect(NetworkAccess::NetworkAddress const*, NetworkAccess::NetworkAddress const&, Stream::NetworkChannelParameters const&, ltt::smartptr_handle *, int)+0x13 at NetworkChannelManager.cpp:158 ( libhdbbasis.so) 6: 0x00007fb75b66c77a in NC::connect(unsigned int&, char const*, unsigned short, int)+0x366 at NetworkLinux.cpp:187 ( libhdbbasement.so) 7: 0x00007fb75b66d481 in TrexDaemon::Impl::connectToDaemon(char const*, unsigned short, int)+0xd0 at NetworkLinux.cpp:386 ( libhdbbasement.so) 8: 0x00007fb75b667c76 in TrexDaemon::sendDaemonMessage(char const*, unsigned short, TrexDaemon::NetworkMessage*, int)+0x42 at Network.cpp:706 ( libhdbbasement.so) 9: 0x00007fb75b661037 in TrexDaemon::Client::sendPingMessage(char const*, unsigned short, int*)+0x33 at Client.cpp:217 ( libhdbbasement.so) 10: 0x00007fb72802f2dc in sendPingMessage+0x48 at ClientPy.cpp:68 ( DaemonClientPy.so) 11: 0x0000556d4e826649 in PyEval_EvalFrameEx+0x6f85 at ceval.c:4352 (python) 12: 0x0000556d4e828d8d in PyEval_EvalCodeEx+0x809 at ceval.c:3584 (python) 13: 0x0000556d4e826005 in PyEval_EvalFrameEx+0x6941 at ceval.c:4447 (python) 14: 0x0000556d4e826120 in PyEval_EvalFrameEx+0x6a60 at ceval.c:4439 (python) 15: 0x0000556d4e828d8d in PyEval_EvalCodeEx+0x809 at ceval.c:3584 (python) 16: 0x0000556d4e828ec2 in PyEval_EvalCode+0x30 at ceval.c:669 (python) 17: 0x0000556d4e852de2 in PyRun_FileExFlags+0x90 at pythonrun.c:1376 (python) 18: 0x0000556d4e854179 in PyRun_SimpleFileExFlags+0xd5 at pythonrun.c:948 (python) 19: 0x0000556d4e7924ad in Py_Main+0xc49 at main.c:640 (python) 20: 0x00007fb75d4e96d5 in __libc_start_main+0xf1 (libc.so.6) 21: 0x0000556d4e791571 in main+0x30 at start.S:103 (python) [10939]{-1}[-1/-1] 2018-10-28 19:13:37.304042 e DaemonClient NetworkLinux.cpp(00200) : cannot connect to 10.167.77.152:37000, error: exception 1: no.2110013 (Basis/IO/Stream/impl/NetworkChannel.cpp:2720) Connection failed: NetworkChannel::triggerConnect (blocking) rc=111: Connection refused. channel={ ={ ={this=93928004642744, fd=11, refCnt=2, local=10.167.77.152/0_tcp, remote=10.167.77.152/37000_tcp, state=ConnectWait, pending=[----]}}} exception throw location: 1: 0x00007fb75a1a92d8 in Stream::NetworkChannel::triggerConnect()+0x534 at NetworkChannel.cpp:2720 ( libhdbbasis.so) 2: 0x00007fb75a1b4288 in Stream::NetworkChannelSSLFilter::initiateConnection()+0x74 at NetworkChannelSSLFilter.cpp:214 ( libhdbbasis.so) 3: 0x00007fb75a1b451a in Stream::NetworkChannelSSLFilter::NetworkChannelSSLFilter(Crypto::ExportsForBasis&, Stream::NetworkChannelCompletionHandler&, Stream::NetworkChannelParameters const&, NetworkAccess::NetworkAddress const*, NetworkAccess::NetworkAddress const&, ltt::smartptr_handle *, int)+0x206 at NetworkChannelSSLFilter.cpp:79 ( libhdbbasis.so) 4: 0x00007fb75a1c7093 in Stream::NetworkChannelManager::connect(NetworkAccess::NetworkAddress const*, NetworkAccess::NetworkAddress const&, Stream::NetworkChannelParameters const&, bool, ltt::smartptr_handle *, int)+0x1b0 at NetworkChannelManager.cpp:204 ( libhdbbasis.so) 5: 0x00007fb75a1c96d7 in Stream::NetworkChannelManager::connect(NetworkAccess::NetworkAddress const*, NetworkAccess::NetworkAddress const&, Stream::NetworkChannelParameters const&, ltt::smartptr_handle *, int)+0x13 at NetworkChannelManager.cpp:158 ( libhdbbasis.so) 6: 0x00007fb75b66c77a in NC::connect(unsigned int&, char const*, unsigned short, int)+0x366 at NetworkLinux.cpp:187 ( libhdbbasement.so) 7: 0x00007fb75b66d481 in TrexDaemon::Impl::connectToDaemon(char const*, unsigned short, int)+0xd0 at NetworkLinux.cpp:386 ( libhdbbasement.so) 8: 0x00007fb75b667c76 in TrexDaemon::sendDaemonMessage(char const*, unsigned short, TrexDaemon::NetworkMessage*, int)+0x42 at Network.cpp:706 ( libhdbbasement.so) 9: 0x00007fb75b661037 in TrexDaemon::Client::sendPingMessage(char const*, unsigned short, int*)+0x33 at Client.cpp:217 ( libhdbbasement.so) 10: 0x00007fb72802f2dc in sendPingMessage+0x48 at ClientPy.cpp:68 ( DaemonClientPy.so) 11: 0x0000556d4e826649 in PyEval_EvalFrameEx+0x6f85 at ceval.c:4352 (python) 12: 0x0000556d4e828d8d in PyEval_EvalCodeEx+0x809 at ceval.c:3584 (python) 13: 0x0000556d4e826005 in PyEval_EvalFrameEx+0x6941 at ceval.c:4447 (python) 14: 0x0000556d4e826120 in PyEval_EvalFrameEx+0x6a60 at ceval.c:4439 (python) 15: 0x0000556d4e828d8d in PyEval_EvalCodeEx+0x809 at ceval.c:3584 (python) 16: 0x0000556d4e828ec2 in PyEval_EvalCode+0x30 at ceval.c:669 (python) 17: 0x0000556d4e852de2 in PyRun_FileExFlags+0x90 at pythonrun.c:1376 (python) 18: 0x0000556d4e854179 in PyRun_SimpleFileExFlags+0xd5 at pythonrun.c:948 (python) 19: 0x0000556d4e7924ad in Py_Main+0xc49 at main.c:640 (python) 20: 0x00007fb75d4e96d5 in __libc_start_main+0xf1 (libc.so.6) 21: 0x0000556d4e791571 in main+0x30 at start.S:103 (python) [10939]{-1}[-1/-1] 2018-10-28 19:13:37.307138 e DaemonClient NetworkLinux.cpp(00200) : cannot connect to 10.167.77.153:37000, error: exception 1: no.2110013 (Basis/IO/Stream/impl/NetworkChannel.cpp:2720) Connection failed: NetworkChannel::triggerConnect (blocking) rc=111: Connection refused. channel={ ={ ={this=93928004643720, fd=11, refCnt=2, local=10.167.77.153/0_tcp, remote=10.167.77.153/37000_tcp, state=ConnectWait, pending=[----]}}} exception throw location: 1: 0x00007fb75a1a92d8 in Stream::NetworkChannel::triggerConnect()+0x534 at NetworkChannel.cpp:2720 ( libhdbbasis.so) 2: 0x00007fb75a1b4288 in Stream::NetworkChannelSSLFilter::initiateConnection()+0x74 at NetworkChannelSSLFilter.cpp:214 ( libhdbbasis.so) 3: 0x00007fb75a1b451a in Stream::NetworkChannelSSLFilter::NetworkChannelSSLFilter(Crypto::ExportsForBasis&, Stream::NetworkChannelCompletionHandler&, Stream::NetworkChannelParameters const&, NetworkAccess::NetworkAddress const*, NetworkAccess::NetworkAddress const&, ltt::smartptr_handle *, int)+0x206 at NetworkChannelSSLFilter.cpp:79 ( libhdbbasis.so) 4: 0x00007fb75a1c7093 in Stream::NetworkChannelManager::connect(NetworkAccess::NetworkAddress const*, NetworkAccess::NetworkAddress const&, Stream::NetworkChannelParameters const&, bool, ltt::smartptr_handle *, int)+0x1b0 at NetworkChannelManager.cpp:204 ( libhdbbasis.so) 5: 0x00007fb75a1c96d7 in Stream::NetworkChannelManager::connect(NetworkAccess::NetworkAddress const*, NetworkAccess::NetworkAddress const&, Stream::NetworkChannelParameters const&, ltt::smartptr_handle *, int)+0x13 at NetworkChannelManager.cpp:158 ( libhdbbasis.so) 6: 0x00007fb75b66c77a in NC::connect(unsigned int&, char const*, unsigned short, int)+0x366 at NetworkLinux.cpp:187 ( libhdbbasement.so) 7: 0x00007fb75b66d481 in TrexDaemon::Impl::connectToDaemon(char const*, unsigned short, int)+0xd0 at NetworkLinux.cpp:386 ( libhdbbasement.so) 8: 0x00007fb75b667c76 in TrexDaemon::sendDaemonMessage(char const*, unsigned short, TrexDaemon::NetworkMessage*, int)+0x42 at Network.cpp:706 ( libhdbbasement.so) 9: 0x00007fb75b661037 in TrexDaemon::Client::sendPingMessage(char const*, unsigned short, int*)+0x33 at Client.cpp:217 ( libhdbbasement.so) 10: 0x00007fb72802f2dc in sendPingMessage+0x48 at ClientPy.cpp:68 ( DaemonClientPy.so) 11: 0x0000556d4e826649 in PyEval_EvalFrameEx+0x6f85 at ceval.c:4352 (python) 12: 0x0000556d4e828d8d in PyEval_EvalCodeEx+0x809 at ceval.c:3584 (python) 13: 0x0000556d4e826005 in PyEval_EvalFrameEx+0x6941 at ceval.c:4447 (python) 14: 0x0000556d4e826120 in PyEval_EvalFrameEx+0x6a60 at ceval.c:4439 (python) 15: 0x0000556d4e828d8d in PyEval_EvalCodeEx+0x809 at ceval.c:3584 (python) 16: 0x0000556d4e828ec2 in PyEval_EvalCode+0x30 at ceval.c:669 (python) 17: 0x0000556d4e852de2 in PyRun_FileExFlags+0x90 at pythonrun.c:1376 (python) 18: 0x0000556d4e854179 in PyRun_SimpleFileExFlags+0xd5 at pythonrun.c:948 (python) 19: 0x0000556d4e7924ad in Py_Main+0xc49 at main.c:640 (python) 20: 0x00007fb75d4e96d5 in __libc_start_main+0xf1 (libc.so.6) 21: 0x0000556d4e791571 in main+0x30 at start.S:103 (python) [10939]{-1}[-1/-1] 2018-10-28 19:13:37.310301 e DaemonClient NetworkLinux.cpp(00200) : cannot connect to 10.167.77.155:37000, error: exception 1: no.2110013 (Basis/IO/Stream/impl/NetworkChannel.cpp:2720) Connection failed: NetworkChannel::triggerConnect (blocking) rc=111: Connection refused. channel={<NetworkChannelSSLFilter>={<NetworkChannelBase>={this=93928004645336, fd=11, refCnt=2, local=10.167.77.155/0_tcp, remote=10.167.77.155/37000_tcp, state=ConnectWait, pending=[----]}}} exception throw location:qasadm@hostname01:/usr/sap/QAS/HDB70/hostname01/trace>

    Add comment
    10|10000 characters needed characters exceeded