Re: Restore SPFILE failed

From: <jackzhunj_at_gmail.com>
Date: Fri, 19 Oct 2007 13:40:20 -0000
Message-ID: <1192801220.341672.264790@q5g2000prf.googlegroups.com>

On Oct 18, 5:28 pm, Jerome Vitalis
<vitalismanN05..._at_gmail.com.invalid> wrote:
> On Thu, 18 Oct 2007 20:39:15 +0000, jackzhunj wrote:
> > 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
>
> You haven't set the DBID this time. Could you try again with the DBID set?
>
> But it does not seem to be the real cause of the problem. Please post the
> result of "show all;" after opening the database.

Yes, I did. The following is after 'startup nomount' w/o spfile of course.

RMAN> set DBID 2419013957;

executing command: SET DBID

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

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

RMAN> restore spfile from autobackup;

Starting restore at 19-OCT-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=39 devtype=DISK

channel ORA_DISK_1: looking for autobackup on day: 20071019
channel ORA_DISK_1: looking for autobackup on day: 20071018
channel ORA_DISK_1: looking for autobackup on day: 20071017
channel ORA_DISK_1: looking for autobackup on day: 20071016
channel ORA_DISK_1: looking for autobackup on day: 20071015
channel ORA_DISK_1: looking for autobackup on day: 20071014
channel ORA_DISK_1: looking for autobackup on day: 20071013
channel ORA_DISK_1: no autobackup in 7 days found

RMAN-00571:

---

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

---

RMAN-00571:

---

RMAN-03002: failure of restore command at 10/19/2007 09:37:26 RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

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

Starting restore at 19-OCT-07
using channel ORA_DISK_1

channel ORA_DISK_1: autobackup found: /oracle_misc/testdb/recovery/ TESTDB/autobackup/2007_10_19/o1_mf_s_636353416_3kjvy8d0_.bkp channel ORA_DISK_1: SPFILE restore from autobackup complete Finished restore at 19-OCT-07

thnx a lot. Received on Fri Oct 19 2007 - 08:40:20 CDT