PowerProtect: 복구 모드가 활성화된 상태에서 DDBMA SQL 복원 Keep_CDC 실패

Summary: keep_CDC가 활성화된 경우 복구 모드를 사용한 PowerProtect Data Manager 및 DDBMA 독립 실행형 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

Restore with Recovery 모드를 선택한 경우에도 로그에 아래 오류가 표시됩니다. 
2024-04-02T05:32:16.909Z 38008  ddbmsqlrc PowerProtect Data Manager critical Option 'norecovery' conflicts with option(s) 'keep_cdc'. Remove the conflicting option and reissue the statement.

Cause

이는 PowerProtect Data Manager(현재 버전 19.16까지) 및 DDBMA 독립 실행형의 알려진 문제입니다.

Resolution

에 대한 두 가지 해결 방법이 있습니다 CDC 데이터베이스. 두 옵션 중 하나를 선택합니다.

해결 방법 1: 
Two restores must be run.

1. Select the second last backup and select norecovery (no keep_cdc option). This can be run from the UI or command line.
2. Select the last backup and select "restore with recovery" and specify keep_cdc option. Generate script and add -z option in the script and run the restore.

The above restores the CDC databases.

This workaround still requires manual process. We request to fix this logic so that the automated process of building recovery chain is without flaws and works for all situations without manual intervention.

해결 방법 2: 
1. Restore the database to a file using DDBEA
2. Restore the database through SSMS with that file
3. Check that the CDC is maintained or not

Restore of database was successful and CDC was maintained too.

Affected Products

PowerProtect Data Manager, PowerProtect App Direct, PowerProtect Software
Article Properties
Article Number: 000224347
Article Type: Solution
Last Modified: 27 Jun 2024
Version:  2
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.