HPE Community
IMC
1777029 Members
2061 Online
109062 Solutions
New Discussion

[IMC] Failed to manual restore databases

 
Support_N2
Occasional Visitor

‎11-12-2021 07:45 AM

‎11-12-2021 07:45 AM

[IMC] Failed to manual restore databases

Hello, we currently have a remote database server with MSSQL 11.00.6020 and an IMC Server on 7.3 E0506P09. We are trying to duplicate this setup on a PRE PRODUCTION environment but every time we try to restore the database from one IMC server to the other it fails.

The backup operation works well and when trying to restore the new IMC server own database it also works.

The deployed components are the same and i have followed the Windows IMC migration guide. Basically i did a DB backup on the old server, one on the new, transfered the old DB to the new server and renamed the old files with the new names.

We are getting some errors in dbman_debug that i can't find information about.

2021-11-12 12:00:35 [INFO] [Main] Version: 7.3
2021-11-12 12:00:35 [INFO] [Main] Global directory: C:/IMC/dbman
2021-11-12 12:00:35 [INFO] [Main] Listenning on port: 2812
2021-11-12 12:00:35 [DEBUG] [Main] arv count 2
2021-11-12 12:00:35 [DEBUG] [Main] arv 1: dbman
2021-11-12 12:00:35 [DEBUG] [Main] arv 2: -n
2021-11-12 12:00:35 [INFO] [DBMAN] dbman exit
2021-11-12 12:01:41 [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
2021-11-12 12:01:41 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10000
2021-11-12 12:01:41 [DEBUG] [CDataConnStreamQueueT::deal_msg] Succeed to create SendBakConfigFileReq thread
2021-11-12 12:01:41 [INFO] [SendBakConfigFileReq] Reload config from file: C:\IMC\dbman\bin\..\etc\dbman.conf
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Starting connect to 127.0.0.1: 2812
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Established connection to 127.0.0.1: 2812
2021-11-12 12:01:41 [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
2021-11-12 12:01:41 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10020
2021-11-12 12:01:41 [DEBUG] [CDataConnStreamQueueT::deal_msg] Success to create directory: C:\dbmanbak
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Starting connect to 127.0.0.1: 2812
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Established connection to 127.0.0.1: 2812
2021-11-12 12:01:41 [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
2021-11-12 12:01:41 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10020
2021-11-12 12:01:41 [DEBUG] [CDataConnStreamQueueT::deal_msg] Success to create directory: C:\dbmanrestore
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Starting connect to 10.5.250.155: 2812
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Established connection to 10.5.250.155: 2812
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Starting connect to 10.5.250.155: 2812
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Established connection to 10.5.250.155: 2812
2021-11-12 12:02:09 [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
2021-11-12 12:02:09 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10003
2021-11-12 12:02:09 [DEBUG] [CDataConnStreamQueueT::deal_msg] Succeed to create ManualRestoreBase thread
2021-11-12 12:02:09 [INFO] [Client::connect_to_server] Starting connect to 10.5.250.155: 2812
2021-11-12 12:02:09 [INFO] [Client::connect_to_server] Established connection to 10.5.250.155: 2812
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] All server echo ok
2021-11-12 12:02:09 [DEBUG] [ManualRestoreBase] Manual restore type: 0
2021-11-12 12:02:09 [DEBUG] [ManualRestoreBase] IfRestart imc 1
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@aclm_db_imc_aclm_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@aclm_db_imc_aclm_db_20211112_111930_full.db; FileLen: 496640
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@config_db_imc_config_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@config_db_imc_config_db_20211112_111930_full.db; FileLen: 44698624
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@icc_db_imc_icc_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@icc_db_imc_icc_db_20211112_111930_full.db; FileLen: 9312768
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@invent_db_imc_inventory_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@invent_db_imc_inventory_db_20211112_111930_full.db; FileLen: 8307712
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@monitor_db_imc_monitor_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@monitor_db_imc_monitor_db_20211112_111930_full.db; FileLen: 18228224
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@perf_db_imc_perf_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@perf_db_imc_perf_db_20211112_111930_full.db; FileLen: 63115264
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@reportplat_db_reportplat_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@reportplat_db_reportplat_db_20211112_111930_full.db; FileLen: 476160
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@syslog_db_imc_syslog_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@syslog_db_imc_syslog_db_20211112_111930_full.db; FileLen: 4696064
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@vlanm_db_vlan_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@vlanm_db_vlan_db_20211112_111930_full.db; FileLen: 1005568
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@vnm_db_imc_vnm_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@vnm_db_imc_vnm_db_20211112_111930_full.db; FileLen: 422912
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@vxlan_db_imc_vxlan_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@vxlan_db_imc_vxlan_db_20211112_111930_full.db; FileLen: 648192
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@aclm_db_imc_aclm_db_20211112_111930_full.db; Size: 496640
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@config_db_imc_config_db_20211112_111930_full.db; Size: 44698624
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@icc_db_imc_icc_db_20211112_111930_full.db; Size: 9312768
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@invent_db_imc_inventory_db_20211112_111930_full.db; Size: 8307712
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@monitor_db_imc_monitor_db_20211112_111930_full.db; Size: 18228224
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@perf_db_imc_perf_db_20211112_111930_full.db; Size: 63115264
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@reportplat_db_reportplat_db_20211112_111930_full.db; Size: 476160
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@syslog_db_imc_syslog_db_20211112_111930_full.db; Size: 4696064
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@vlanm_db_vlan_db_20211112_111930_full.db; Size: 1005568
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@vnm_db_imc_vnm_db_20211112_111930_full.db; Size: 422912
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@vxlan_db_imc_vxlan_db_20211112_111930_full.db; Size: 648192
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Begin stop service.
2021-11-12 12:02:10 [INFO] [Main] Version: 7.3
2021-11-12 12:02:10 [INFO] [Main] Global directory: C:/IMC/dbman
2021-11-12 12:02:10 [INFO] [Main] Listenning on port: 2812
2021-11-12 12:02:10 [DEBUG] [Main] arv count 2
2021-11-12 12:02:10 [DEBUG] [Main] arv 1: dbman
2021-11-12 12:02:10 [DEBUG] [Main] arv 2: -n
2021-11-12 12:02:10 [INFO] [DBMAN] dbman exit
2021-11-12 12:02:37 [INFO] [CDbRestore::RestoreDatabaseList] End stop service.
2021-11-12 12:02:37 [INFO] [CDbRestore::RestoreDatabaseList] Restart DBIp: 10.5.250.155
2021-11-12 12:02:37 [INFO] [CRestoreConfig::readFrom] Fail to read restore config file: C:/IMC/dbman\/etc/oracleRac.cfg
2021-11-12 12:02:37 [INFO] [Client::connect_to_server] Starting connect to 10.5.250.155: 2812
2021-11-12 12:02:37 [INFO] [Client::connect_to_server] Established connection to 10.5.250.155: 2812
2021-11-12 12:02:37 [ERROR] [deal_err_response] Remote return error code: AsnDbmanDmErrCode::iERR_MSG_DBMAN_RES_ERROR, errorContent: Dbman deal msg error, please to see dbman_debug.log
2021-11-12 12:02:37 [INFO] [DBMAN] Begin to restore file 10.5.250.155@aclm_dbimc_aclm
2021-11-12 12:02:37 [INFO] [Client::connect_to_server] Starting connect to 10.5.250.155: 2812
2021-11-12 12:02:37 [INFO] [Client::connect_to_server] Established connection to 10.5.250.155: 2812
2021-11-12 12:02:37 [ERROR] [Client::send_filetrans_msg] Send file data error expect 1024 bytes infact -1 bytes
2021-11-12 12:02:37 [INFO] [CDbRestore::RestoreOneDBase] File trans failed
2021-11-12 12:02:37 [ERROR] [CDbRestore::RestoreDatabaseList] Fail to restore DB file in RestoreOneDBase Function 10.5.250.155@aclm_db_imc_aclm_db_20211112_111930_full.db
2021-11-12 12:02:37 [INFO] [ManualRestoreBase] req asn msg:{ -- SEQUENCE --
iErrCode 'f6'H --
,
iContent '61636c6d5f64623b31302e352e3235302e313535'H -- "aclm_db;10.5.250.155" --
}


2021-11-12 12:02:37 [INFO] [sendTrapAlert] Send trap success

2021-11-12 12:02:37 [ERROR] [ManualRestoreBase] Failed to manual restore databases. ManualType: 0
2021-11-12 12:02:37 [ERROR] [response_err_code] errCode = -10
2021-11-12 12:02:37 [INFO] [ManualRestoreBase] Begin start service.
2021-11-12 12:03:13 [INFO] [ManualRestoreBase] End start service.

Any help would be much appreciated.

Regards

0 Kudos
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.