Avamar：SQL 備份失敗並顯示錯誤：「已識別記錄檔間隙，或找不到完整備份」

Summary: Avamar：SQL 備份失敗並顯示錯誤：「已識別記錄檔間隙，或找不到完整備份。」

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

SQL 備份會隨機失敗，並出現記錄檔間隙錯誤：「已識別記錄檔間隙，或找不到完整備份。」

備份記錄中的對應部分 （包含偵錯）： 
2022/05/04-23:00:22.09299 [avsql_assist] called avspawnpipe::~avspawnpipe
2022/05/04-23:00:22.09299 [avsql_assist] avspawnpipe::~avspawnpipe done with avspawnpipe::wait stdout
2022/05/04-23:00:22.09299 [avsql_assist] called avspawnpipe::~avspawnpipe
2022/05/04-23:00:22.09299 [avsql_assist] avspawnpipe::~avspawnpipe done with avspawnpipe::wait stderr
2022/05/04-23:00:22.16199 [avsql_assist] xml_message::parse parse error: expected = at 000000001C8D3041 in input
2022/05/04-23:00:22.17100 [avsql_assist] ERROR:  xml_message::validname('') invalid xml name
2022/05/04-23:00:22.17100 [avsql_assist] avsql_metadata::avsql_metadata sqlmetadata = '< />
'..
.
.
.
2022/05/04-23:00:22.18400 [avsql_assist] ===> avsql_assist::evaluate_backup_lsn
2022-05-04 19:00:22 avsql Warning : Evaluate backup LSN numbers is not supported in this version of metadata file (v0.000000).
2022/05/04-23:00:22.18499 [avsql_assist]  sqlconnectimpl_smo::get_last_backup_lsn
2022/05/04-23:00:22.18499 [avsql_assist] retrieving last backup lsn for '' db from sys.database_recovery_status
2022/05/04-23:00:22.18499 [avsql_assist] ===> sqlconnectimpl_smo::InitDll
2022/05/04-23:00:22.18499 [avsql_assist] SMO dll already loaded.
2022/05/04-23:00:22.18600 [avsql_assist]  SMOWrap::SMO_GetLastBackupLSN
2022/05/04-23:00:22.19000 [avsql_assist] database '', last backup lsn = '271000002085600001'
2022/05/04-23:00:22.19099 [avsql_assist]  avsql_metadata::get
2022/05/04-23:00:22.19099 [avsql_assist] ===> avsql_metadata::get
2022/05/04-23:00:22.19099 [avsql_assist]  avsql_assist::align_numeric_ustrings
2022/05/04-23:00:22.19099 [avsql_assist] Before alignment - Str1: '', Str2: '271000002085600001'
2022/05/04-23:00:22.19099 [avsql_assist] After alignment - Str1: '000000000000000000', Str2: '271000002085600001'
2022/05/04-23:00:22.19099 [avsql_assist] : A log gap was identified or a full backup was not found.

Cause

問題在於將sqlmeta檔案與先前的增量備份進行分析。

sqlmeta 檔案的底部 （存在於system_info區域檔案 - 請參閱 KB 000102778 Avamar - 如何從 Avamar 備份擷取system_info區域檔案 

          
          
          
         

檔案被截斷，從17411017至16777216 BYTES**。

由於 avtar 大小限制為 16 MB，sqlmeta檔案被截斷。
所涉 SQL 伺服器有多個資料庫。每個資料庫都有多個檔案群組，導致檔案 （sqlmeta） 擁有超過 9 萬列 （16 MB 大小）。 

Resolution

若要解決 Avamar 問題：SQL 備份失敗並顯示錯誤：「已識別記錄檔間隙，或找不到完整備份。」

Affected Products

Avamar
Article Properties
Article Number: 000201975
Article Type: Solution
Last Modified: 15 Feb 2024
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.