Symptom
The switch LOG- and Catalog Backup using the BACKINT interface and all settings looks fine, but in HANA Studio, the Catalog does not found data backups from the TenantDB.
There are current backups included and MiniCheck does not point to an issue regarding Backup, so all Backups looks fine.
No error in Backint.log file, but Backup.log shows below:
2023-05-19T12:55:21+08:00 P2435795 188325c9801 INFO RECOVERY LOAD CATALOG EBIDs backint error: BACKINT inquire job from /usr/sap/XXX/SYS/global/hdb/backint/DB_NHQ/log_backup_0_0_0_0 failed with error code NOTFOUND
2023-05-19T12:55:21+08:00 P2435795 188325c9801 INFO RECOVERY INQUIRE finished successfully
Also, following can be read in the Indexserver Trace file:
[4138348]{-1}[-1/-1] 2023-04-20 19:38:55.036370 w Backup BackupLoadCatalogHandler.cpp(00108) : Error loading catalog: exception 1: no.110081 (Backup/Destination/impl/BackupDest_Factory.cpp:383) TID: 4138348
Catalog backup log_backup_0_0_0_0 not found
exception throw location:
1: 0x00007f1b4b7d5622 in Backup::BackupDest_Factory::getDestinationForRead(ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, Backup::BackupDest::DestinationType, Backup::DestFactoryType, bool)+0x1440 at BackupDest_Factory.cpp:383 (libhdbbackup.so)
2: 0x00007f1b4b7d1e12 in Backup::BackupDest_Factory::getDestinationForRead(ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, Backup::BackupDest::DestinationType, Backup::DestFactoryType, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, bool, ltt::vector<DataAccess::LogSegmentBackupInfo>&)+0x20 at BackupDest_Factory.cpp:202 (libhdbbackup.so)
3: 0x00007f1b4b7d1f34 in Backup::BackupDest_Factory::getDestinationForRead(ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, Backup::BackupDest::DestinationType, Backup::DestFactoryType, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, bool)+0x70 at BackupDest_Factory.cpp:189 (libhdbbackup.so)
4: 0x00007f1b4b891bbf in Backup::BackupLoadCatalogHandler::createDestination(ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, Backup::BackupDest::DestinationType, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&)+0x9b at BackupLoadCatalogHandler.cpp:52 (libhdbbackup.so)
5: 0x00007f1b4b8942db in Backup::BackupLoadCatalogHandler::handleRequest(ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, Backup::BackupDest::DestinationType, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> >&)+0xb7 at BackupLoadCatalogHandler.cpp:103 (libhdbbackup.so)
6: 0x00007f1b4b8b31ef in Backup::LoadCatalogManager::loadSingleCatalog(ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, Backup::BackupDest::DestinationType, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> >&)+0x13b at LoadCatalogManager.cpp:58 (libhdbbackup.so)
7: 0x00007f1b4b8af4d0 in Backup::LoadCatalogManager::loadSingleCatalog(ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, Backup::BackupDest::DestinationType, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> >&)+0x70 at string.hpp:1461 (libhdbbackup.so)
8: 0x00007f1b4b8b5c2f in Backup::LoadCatalogManager::loadSingleCatalogFromFile(ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> >&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> >&, ltt::list<ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > >&)+0x6b at LoadCatalogManager.cpp:239 (libhdbbackup.so)
9: 0x00007f1b4b8b68ce in Backup::LoadCatalogManager::loadCatalog(Backup::BackupMgrClient_RecoverStrategyRequest const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> >&)+0x72a at LoadCatalogManager.cpp:372 (libhdbbackup.so)
10: 0x00007f1b4b8ef93c in Backup::BackupMgr_Manager::prepareRecoveryItems(bool, Backup::Backup_ExtendedRecoveryInformation&)+0x258 at BackupMgr_Manager.cpp:5327 (libhdbbackup.so)
11: 0x00007f1b4b8f3082 in Backup::BackupMgr_Manager::receiveDatabaseRecoveryRequest(Backup::BackupCbc_Parser const&, Backup::Backup_ExtendedRecoveryInformation&)+0x630 at BackupMgr_Manager.cpp:4936 (libhdbbackup.so)
12: 0x00007f1b4b82e596 in Backup::Backup_Recover::lookForDatabaseRecoveryRequest(Backup::BackupCbc_Parser const&, Backup::Backup_ExtendedRecoveryInformation&, unsigned int, bool&)+0x52 at Backup_Recover.cpp:214 (libhdbbackup.so)
13: 0x000055acdec56511 in TRexAPI::TREXIndexServer::started()+0x280 at TREXIndexServer.cpp:950 (hdbindexserver)
14: 0x000055acdec03532 in TableReplicationComponent.cpp.e6cab210+0x1230 at TrexService.cpp:556 (hdbindexserver)
15: 0x00007f1b4077bc51 in System::mainWrapper(int, char**, char**)+0x80 at IsInMain.cpp:334 (libhdbbasis.so)
16: 0x00007f1b3e62c493 in .annobin_libc_start.c+0xf0 (libc.so.6)
17: 0x000055acdebe1e28 in partitioning::PartPropertyDetails::PartPropertyDetails()+0x594 at start.S:112 (hdbindexserver)
exception type information:
- 0: public ltt::exception@0x7f1b40008c40
.
.
[622138]\{300783\}[42/324983329] 2023-04-21 12:10:32.676968 i TraceContext TraceContext.cpp(01269) : UserName=SYSTEM, ApplicationUserName=root, ApplicationName=SLTOOLSET, StatementHash=99f90b6b7f347a28e5ecbcd3f77654f7, StatementExecutionID=1970337721914014
[622138]\{300783\}[42/324983329] 2023-04-21 12:10:32.676953 i SQLSessionCmd Statement.cc(06505) : INI configuration is changed by 300783, client ip=10.167.34.116, client port=194189, query=ALTER SYSTEM ALTER CONFIGURATION ('global.ini','SYSTEM') UNSET ('backup','catalog_backup_using_backint') WITH RECONFIGURE
[622138]\{300783\}[42/324983528] 2023-04-21 12:10:32.840678 i TraceContext TraceContext.cpp(01269) : UserName=SYSTEM, ApplicationUserName=root, ApplicationName=SLTOOLSET, StatementHash=ffc7360ac676d100861954c0e6749a64, StatementExecutionID=1970337721914073
Read more...
Environment
SAP HANA DB Version 2.0
Product
SAP HANA, platform edition 2.0
Keywords
KBA , HAN-DB-BAC , SAP HANA Backup & Recovery , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.