How to fix the Oracle error RMAN-06970: NEWNAME ‘string’ for database must include %f or %U format?

In this post, you’ll learn more about the Oracle ErrorRMAN-06970: NEWNAME ‘string’ for database must include %f or %U format with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error RMAN-06970: NEWNAME ‘string’ for database must include %f or %U format ?

You can fix this error in Oracle by following the below steps

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