Oracle Error Message
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP
Reason for the Error
RESTORE CONTROLFILE or RESTORE SPFILE was specified without the FROM AUTOBACKUP option when RMAN is not connected to the recovery catalog.
Solution
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.
