How to fix the Oracle error ORA-19717: for non-OMF search the pattern must be specified?

In this post, you’ll learn more about the Oracle ErrorORA-19717: for non-OMF search the pattern must be specified with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-19717: for non-OMF search the pattern must be specified

Reason for the Error ORA-19717: for non-OMF search the pattern must be specified

The procedure DBMS_BACKUP_RESTORE.SEARCHFILES was called with an empty pattern while the parameter OMF was set to FALSE.

How to fix the Error ORA-19717: for non-OMF search the pattern must be specified ?

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

Either specify the pattern or set the parameter OMF to TRUE.