How to fix the Oracle error RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP?

In this post, you’ll learn more about the Oracle ErrorRMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP

Reason for the Error RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP

A datafile or archived log restore from AUTOBACKUP was attempted.

How to fix the Error RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP ?

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

Do not specify DATAFILE or ARCHIVELOG for restore from AUTOBACKUP.