PowerProtect Data Manager：Oracle RMAN 備份失敗： ORA-19506: failed to create sequential file, name="…/XXXXXXXX-XXXXXXXX-ff"

Summary: PPDM：Oracle RMAN 備份失敗： ORA-19506: failed to create sequential file, name="…/XXXXXXXX-XXXXXXXX-ff".

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

在 PowerProtect Data Manager (PPDM) 上 RMAN 備份未完成，並顯示訊息：

ORA-19506: failed to create sequential file, name=”.../XXXXXXXX-XXXXXXXX-ff”

Cause

Controlfile 格式設定為無法接受的值。Oracle 無法產生循序片段。「%%F」格式無效。

Resolution

使用 RMAN 輸入命令來檢查 Controlfile 格式：

RMAN> SHOW ALL;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '………/%%F';

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%%F';

在 PPDM 記錄中：

autobackup format for disk to '................/controlfile_PRD21.20210923_200001_Tue.%%F.ctl';

DBA 必須將值設為預設格式 (%F) 或可接受的格式：

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '………_%F';

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '………_%F';

若要讓組態生效，請等到第二天 Controlfile 時間戳記變更後，再產生新的片段順序。
若要確認修復有效，請執行新的備份或手動執行 Controlfile 備份，以確保該片段的結尾有兩個數字，而非「-ff」：

RMAN> connect target /

RMAN> backup current controlfile;

".../2615403650-20210924-01"

Affected Products

DD Boost for Oracle RMAN

Article Number: 000194241

Article Type: Solution

Last Modified: 27 Aug 2022

Version: 3

Check if your device is covered by Support Services.