| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: auto backup and spfile restore
Well, I found the problem.
There was still a pfile in the default location.
The only entry in that pfile was 'spfile=...'
Since that spfile had been deleted, the file not found error message was
returned.
When I delete the pfile, the recovery worked as documented....
RMAN> connect target /
connected to target database (not started)
RMAN> set DBID=1370501721
executing command: SET DBID
RMAN> startup force nomount;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/9.2/dbs/initr'
trying to start the Oracle instance without parameter files ...
Oracle instance started
Total System Global Area 160918624 bytes
Fixed Size 736352 bytes
Variable Size 109051904 bytes
Database Buffers 50331648 bytes
Redo Buffers 798720 bytes
RMAN> restore spfile from autobackup
2> ;
Starting restore at 25-JAN-03
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=9 devtype=DISK
channel ORA_DISK_1: looking for autobackup on day: 20030125
channel ORA_DISK_1: looking for autobackup on day: 20030124
channel ORA_DISK_1: autobackup found: c-1370501721-20030124-06
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 25-JAN-03
RMAN> shutdown abort
Oracle instance shut down
RMAN> startup
connected to target database (not started)
Oracle instance started
database mounted
database opened
Total System Global Area 320301720 bytes
Fixed Size 735896 bytes
Variable Size 285212672 bytes
Database Buffers 33554432 bytes
Redo Buffers 798720 bytes
RMAN> thank you for the response Robert.
chris
-----Original Message-----
Sent: Friday, January 24, 2003 10:54 PM
To: Multiple recipients of list ORACLE-L
My guess is that there is a path defined in your init.ora that isn't correct. Check your alert log for more information.
RF
-----Original Message-----
Sent: Friday, January 24, 2003 1:54 PM
To: Multiple recipients of list ORACLE-L
List,
We are in the process of testing every recovery scenario we can think of using rman. We don't use a catalog and controlfile autobackup is on which implies the spfile is automatically backed up.
So one of the scenarios was to delete the spfile and pfile. To recover I thought we would be able to....
(database already shutdown)
rman
rman>set DBID=1370501721 ---i tried switch this with the command immediate
following
rman>connect target /
rman>startup force nomount; ---from what I read in the documentation this
should force oracle to use a 'dummy' spfile.
rman>restore spfile from autobackup;
i realize there are several other ways to handle this situation but why can't i start the database in this way? the error i get is:
RMAN> startup force nomount;
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===========================================================RMAN-03002: failure of startup command at 01/24/2003 13:37:39 RMAN-04014: startup failed: ORA-27037: unable to obtain file status HP-UX Error: 2: No such file or directory Additional information: 3
what gives?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: ChrisStephens_at_affina.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Sat Jan 25 2003 - 09:23:47 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |