Troubleshooting Oracle

From SEPsesam
Redirect page
Jump to: navigation, search

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.