| 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
auto backup and spfile restoreAnother thought is that if you are starting
your database without any init.ora at all (which is very possible),
then you may need to create file systems for the default file locations such
as user_dump_dest, etc...
RF
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Chris
Stephens
Sent: Friday, January 24, 2003 1:54 PM
To: Multiple recipients of list ORACLE-L
Subject: auto backup and spfile restore
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: Robert Freeman
INET: robertgfreeman_at_yahoo.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-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jan 24 2003 - 22:53:40 CST
 |
 |