In this post, you’ll learn more about the Oracle ErrorRMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP
Reason for the Error RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP
RESTORE CONTROLFILE or RESTORE SPFILE was specified without the FROM AUTOBACKUP option when RMAN is not connected to the recovery catalog.
How to fix the Error RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP ?
You can fix this error in Oracle by following the below steps
If the recovery catalog is available, connect to the recovery catalog and retry the restore. If the recovery catalog in not available, following is the procedure to restore control file or SPFILE:
1. Specify the DBID of the database with the SET DBID command.
2. If the AUTOBACKUP was created with non-default AUTOBACKUP format, then specify the AUTOBACKUP format using the SET CONTROLFILE AUTOBACKUP FORMAT command.
3. If the backup was created with SBT device, then allocate an SBT channel using the ALLOCATE CHANNEL command.
4. Restore control file or SPFILE by starting the RESTORE … FROM AUTOBACKUP command.