RE: auto backup and spfile restore

[Chris Stephens]

Title: 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-----
From: Robert Freeman [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 24, 2003 10:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: auto backup and spfile restore

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-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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?