Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Restore SPFILE failed
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 foundRMAN-00571:
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
![]() |
![]() |