How to restore controlfile backup piece without backup controlfiles
I've monthly rman backups and wish to restore a backup to a new host for testing.
Backups have been taken with autobackup on.
After prearing new host and statring oracle in nomount I've tried to restore controlfile from backup piece as below
but it errors searching for auto backups whiche are not present
How to restore controlfie backup piece when controlfile backup peices are not present
RMAN>run
{
set DBID 2545844721
restore controlfile from '/u01/backups/bak_PANT_s_qrp22jb4.CTL'
}
executing command set DBID
starting restore at 07-MAY-2014 16:19:21
ussing channel ORA_DISK_1
channel ORA_DISK_1: no AUTOBACKUP in 7 days found