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

In this post, you’ll learn more about the Oracle ErrorRMAN-06971: NEWNAME ‘string’ for tablespace 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-06971: NEWNAME ‘string’ for tablespace must include %f or %U format

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

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

How to fix the Error RMAN-06971: NEWNAME ‘string’ for tablespace 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 TABLESPACE … TO NEW to ensure datafiles get different datafile names.