Re: Restore SPFILE failed

From: <jackzhunj_at_gmail.com>
Date: Thu, 18 Oct 2007 20:39:15 -0000
Message-ID: <1192739955.236054.202870@e9g2000prf.googlegroups.com>

On Oct 18, 3:49 pm, Jerome Vitalis
<vitalismanN05..._at_gmail.com.invalid> wrote:
> 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;

Thanks.

This is my testing result: (after 'startup nomount')

The autobackup file is:
/oracle_misc/testdb/recovery/TESTDB/autobackup/2007_10_18/ o1_mf_s_636298529_3kh6c1xl_.bkp'

RMAN> set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/ oracle_misc/testdb/recovery/TESTDB/autobackup/2007_10_18/%F';

executing command: SET CONTROLFILE AUTOBACKUP FORMAT using target database control file instead of recovery catalog

RMAN> restore spfile to '/tmp/test' from autobackup;

Starting restore at 18-OCT-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK

autobackup search outside recovery area not attempted because DBID was not set
RMAN-00571:

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

RMAN-00571:

RMAN-03002: failure of restore command at 10/18/2007 16:28:54 RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

RMAN> restore spfile to '/tmp/test' from '/oracle_misc/testdb/recovery/ TESTDB/autobackup/2007_10_18/o1_mf_s_636298529_3kh6c1xl_.bkp';

Starting restore at 18-OCT-07
using channel ORA_DISK_1

channel ORA_DISK_1: autobackup found: /oracle_misc/testdb/recovery/ TESTDB/autobackup/2007_10_18/o1_mf_s_636298529_3kh6c1xl_.bkp channel ORA_DISK_1: SPFILE restore from autobackup complete Finished restore at 18-OCT-07

Now I just want to get rid of the 'autobackup' thing:

-bash-3.1$ rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Thu Oct 18 16:29:46 2007

connected to target database: DUMMY (not mounted)

RMAN> restore spfile from '/oracle_misc/testdb/recovery/TESTDB/ autobackup/2007_10_18/o1_mf_s_636298529_3kh6c1xl_.bkp';

Starting restore at 18-OCT-07
using target database control file instead of recovery catalog allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=39 devtype=DISK

Still, I don't know how 'restore from autobackup' works. In my testing, basically I have to specify the autobackup file with the full path. Received on Thu Oct 18 2007 - 15:39:15 CDT