RE: Autobackup not found by RMAN

 Hi Jerome,

Thanks for the information. About an hour after posting the original message I figured out what the problem was. It was exactly what you described. The solution in 10g is very simple you just have to set the autobackup format before restoring the spfile.

Run
{set controlfile autobackup format for device type sbt to 'cf_%F';  allocate channel ch01 device type tape;  restore spfile to pfile from autobackup; }

Thanks,

Mark

-----Original Message-----
From: Vitalis Jerome [mailto:vitalisman_at_gmail.com] Sent: Wednesday, November 02, 2005 1:30 AM To: Mark Moynahan
Cc: oracle-l_at_freelists.org
Subject: Re: Autobackup not found by RMAN

Hi Mark,

That's because you had overiden the default autobackup format in the persistent configuration ('cf_%F').

And now RMAN is asking the media manager to restore the spfile from pieces with the default format '%F' and none can be found. AFAIK you can't specify an alternate autobackup format upon restore (the instance is not mounted, you can not create a persistent configuration, at least with 9i). So in your case you may have to
'manually' specify the autobackup to restore by using "FROM
'media_handle'".

If you find a better solution please let us know.

Regards,
Jerome

--
http://www.freelists.org/webpage/oracle-l