Troubleshooting Oracle

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Redirect to:

Troubleshooting Guide#Oracle

RMAN file name too long

Error message

ORA-19506: failed to create sequential file, name="full_COMP1_1953897796_55938_1.bck", parms=""

Reason

The RMAN created filename of the backupset is longer than 32 character. E.g. if the Oracle backup file format will be set to format 'full_%d_%I_%s_%p.bck'. When the parameter %s (backup set number) is integrated in the filename, the backupset number increases with every backup. As consequence of that the count of characters of that string will increase. Increasing the number to over 32 character the backup will fail.

Solution

Make sure the character length of the backupset is not longer than 32 characters.