How to fix the Oracle error RMAN-05049: datafile string is an Oracle Managed File, DB_CREATE_FILE_DEST not set at target?

In this post, you’ll learn more about the Oracle ErrorRMAN-05049: datafile string is an Oracle Managed File, DB_CREATE_FILE_DEST not set at target with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

RMAN-05049: datafile string is an Oracle Managed File, DB_CREATE_FILE_DEST not set at target

Reason for the Error RMAN-05049: datafile string is an Oracle Managed File, DB_CREATE_FILE_DEST not set at target

A Tablespace Point-in-Time Recovery was attempted but the datafile is an Oracle Managed File and DB_FILE_CREATE_DEST is not currently set for the target database.

How to fix the Error RMAN-05049: datafile string is an Oracle Managed File, DB_CREATE_FILE_DEST not set at target ?

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

Specify DB_FILE_CREATE_DEST for the target database or provide a NEWNAME for the specified datafile.