Oracle Error RMAN-06970: NEWNAME ‘string’ for database must include %f or %U format

Oracle Error Message

RMAN-06970: NEWNAME ‘string’ for database must include %f or %U format

Reason for the Error

The newname in SET NEWNAME FOR DATABASE did not include a format specifier to produce different newnames for the datafiles.

Solution

Include %f or %U in the newname or use SET NEWNAME FOR DATABASE TO NEW to ensure datafiles get different datafile names.