RMAN-06563: controlfile or SPFILE must be restored using FROM AUTOBACKUP 

Cause: RESTORE CONTROLFILE or RESTORE SPFILE was specified without the FROM AUTOBACKUP option when RMAN is not connected to the recovery catalog. 

Action: If the recovery catalog is available, then connect to the recovery catalog and retry the restore. If the recovery catalog is not available, then the following is the procedure to restore controlfile or SPFILE: 

     Specify the DBID of the database with the SET DBID command. 

     If the autobackup was created with non-default autobackup format, then specify the autobackup format using the SET CONTROLFILE AUTOBACKUP FORMAT command. 

     If the backup was created with SBT device, then allocate an SBT channel using the ALLOCATE CHANNEL command. 

     Restore controlfile or SPFILE by starting the RESTORE ... FROM AUTOBACKUP command. 

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/