Restore SPFILE failed

From: <jackzhunj_at_gmail.com>
Date: Thu, 18 Oct 2007 18:48:40 -0000
Message-ID: <1192733320.739147.232190@i38g2000prf.googlegroups.com>

Oracle 10.2.0.3 enterprise on Linux x86-64

When database is on, I am able to do 'restore spfile to <location> from autobackup;'. This means autobackup option is on and I have valid autobackups.

Now, for testing purpose, I shutdown the database and change file SPFILE name to somthing else.

RMAN> set DBID <...>
RMAN>startup nomount;
startup failed: ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/apps/oracle/product/10.2/ dbs/inittestdb.ora'

starting Oracle instance without parameter file for retrival of spfile Oracle instance started

Total System Global Area 159383552 bytes

Fixed Size                     2071192 bytes
Variable Size                 67110248 bytes
Database Buffers              83886080 bytes
Redo Buffers                   6316032 bytes

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

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=36 devtype=DISK

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: looking for autobackup on day: 20071012
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/18/2007 14:43:48 RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

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

Thanks a lot! Received on Thu Oct 18 2007 - 13:48:40 CDT