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@xxxxxxxxx] 
Sent: Wednesday, November 02, 2005 1:30 AM
To: Mark Moynahan
Cc: oracle-l@xxxxxxxxxxxxx
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


Other related posts: