PowerProtect Data Manager: Oracle RMAN Backup Failure: ORA-19506: failed to create sequential file, name="…/XXXXXXXX-XXXXXXXX-ff"
Summary: PPDM: Oracle RMAN Backup Failure: 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.
Symptoms
RMAN Backup does not complete on PowerProtect Data Manager (PPDM) with message:
ORA-19506: failed to create sequential file, name=”.../XXXXXXXX-XXXXXXXX-ff”
Cause
The Controlfile format is set to a nonacceptable value. Oracle cannot generate sequential pieces. "%%F" format is not valid.
Resolution
- Check the Controlfile format by typing the command using RMAN:
RMAN> SHOW ALL;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '………/%%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%%F';
- On PPDM log:
autobackup format for disk to '................/controlfile_PRD21.20210923_200001_Tue.%%F.ctl';
- DBA must set the value to the default format (%F) or to an acceptable format:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '………_%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '………_%F';
- For the configuration to take effect, wait until the next day when the Controlfile timestamp is changed, generating a new sequence of pieces.
- To verify that the fix worked, run a new backup or run a Controlfile backup manually, to ensure that the end of the piece has two digits and not "-ff":
RMAN> connect target /
RMAN> backup current controlfile;
".../2615403650-20210924-01"Affected Products
DD Boost for Oracle RMANArticle Properties
Article Number: 000194241
Article Type: Solution
Last Modified: 27 Aug 2022
Version: 3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.