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

What? I am trying to restore the controlfile but and getting the RMAN-06563 error. I know I have a backup on the controlfile but RMAN is not able to see it.

rman target /

RMAN> run {
2>allocate channel ch1 device type disk;
3>restore controlfile;
3>}

Starting restore at 04-21-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=231 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 4/21/15 3:15
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP

Why? When restoring a controlfile from an autobackup without connecting to the RMAN repository, the “from autobackup“ clause must be command must be used.

Resolution: Use the from autobackup clause

RMAN> run {
2>allocate channel ch1 device type disk;
3>restore controlfile from autobackup;
3>}

Starting restore at 04-21-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=231 devtype=DISK

Starting restore at 04-21-15
channel ch1: starting datafile backupset restore
channel ch1: restoring controlfile
output filename=+DATA/sh213bgfjsgidfg

channel ch1: restored backup piece 1
piece handle=c-534627535-534672781-12 tag=null params=NULL
channel ch1: restore complete

released channel: ch1

Leave a Reply

Your email address will not be published.