How to fix the Oracle error RMAN-06094: datafile string must be restored?

In this post, you’ll learn more about the Oracle ErrorRMAN-06094: datafile string must be restored with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

RMAN-06094: datafile string must be restored

Reason for the Error RMAN-06094: datafile string must be restored

A RECOVER command was issued, and the recovery catalog indicates the specified datafile should be part of the recovery, but this datafile is not listed in the control file, and cannot be found on disk.

How to fix the Error RMAN-06094: datafile string must be restored ?

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

Issue a RESTORE command for this datafile, using the same UNTIL clause specified to the RECOVER command (if any), then reissue the RECOVER.