RMAN-06172: no autobackup found
While performing disaster recovery I get the error RMAN-06172 as below.
RMAN> restore spfile to pfile ‘/oracle/app/oracle/product/10.2.0/db_1/dbs/initARJU.ora’ from ‘/backup1/snap/june/ctl_sp_bak_c-448149146-20080607-00’;
Starting restore at 27-AUG-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03002: failure of restore command at 08/27/2008 00:42:41
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
Cause of The Error
To perform restore operation to a new host you must have at least one autobackup of the controlfile. If you don’t have autobackup of the controlfile then you would not be able to perform disaster recovery. For example if you have snapshot of controlfile backup then you will not be able to restore spfile or controlfile.
Oracle in World: RMAN-06172: no autobackup found.