Re: Restore SPFILE failed

From: Jerome Vitalis <vitalismanN05P4M_at_gmail.com.invalid>
Date: 18 Oct 2007 19:49:51 GMT
Message-ID: <4717b8df$0$21492$79c14f64@nan-newsreader-06.noos.net>

On Thu, 18 Oct 2007 18:48:40 +0000, jackzhunj wrote:

> Now it failed to restore from autobackup. What happened? The autobackup
> s in in 20071018 directory.

I haven't tested this recovery scenario, but here's my guess: you used '% F' as the autobackup format with a flashrecovery area, so the path to the autobackup was something like <flashrecovery_area>/.../<date>/%F. Now you have started a dummy instance with no f_r_a configured, so the path defaults to ORACLE_HOME/dbs/%F.

If this is the case, try running:
set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '<flashrecovery_area>/.../<date>/%F';

before:
restore spfile to '/tmp/test' from autobackup; Received on Thu Oct 18 2007 - 14:49:51 CDT