Rman Restore controlfile without Autobackup on

[SKMORA]

I am trying to restore a test if I don't have autobackup turned on during rman backup to tape. Will I be able to restore the database from rman?

Backup has been done with regular RMAN backup with default values to tape with veritas netbackup software. Looking at rman output log, it has created backupset file and that included the controlfile.

RMAN> run {
2> set controlfile autobackup format for device type 'sbt_type' to '%F';
3> allocate channel t1 device type 'sbt_tape';
4> restore controlfile from autobackup;
5> alter database mount;
6> }

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

allocated channel: t1
channel t1: sid=379 devtype=SBT_TAPE
channel t1: Veritas NetBackup for Oracle - Release 6.5 (2008052301)

Starting restore at 03-JUN-09

channel t1: looking for autobackup on day: 20090603
channel t1: looking for autobackup on day: 20090602
channel t1: looking for autobackup on day: 20090601
channel t1: looking for autobackup on day: 20090531
channel t1: looking for autobackup on day: 20090530
channel t1: looking for autobackup on day: 20090529
channel t1: looking for autobackup on day: 20090528
channel t1: no autobackup in 7 days found
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/03/2009 11:58:04
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece



I guess, it is looking for autobackup on controlfiles. I have tried with
restore controlfiles from tag 'backupsettagname' and I was not success..

Any other idea, I can try or is it not possible to restore the database with that limitation?

[davey23uk]

was the control file backed up? if not - make a new one

[ebrian]

If the log shows which backup piece the controlfile was backed up to, simply do the following:

restore controlfile from '<backup_piece_name>';

[SKMORA]

thanks davey23uk and ebrian for reply.

restore controlfile from '' worked.

I used restore controlfile from '/cntrl_29_1_688498299'.