How to fix the Oracle error RMAN-06564: must use the TO clause when the instance is started with SPFILE?

In this post, you’ll learn more about the Oracle ErrorRMAN-06564: must use the TO clause when the instance is started with SPFILE with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

RMAN-06564: must use the TO clause when the instance is started with SPFILE

Reason for the Error RMAN-06564: must use the TO clause when the instance is started with SPFILE

A restore of the SPFILE from AUTOBACKUP was attempted when the instance is started with SPFILE and no alternate destination was specified.

How to fix the Error RMAN-06564: must use the TO clause when the instance is started with SPFILE ?

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

Specify an alternate destination with the TO clause.